Will a M+B key 8x Sata card work in a M key socket?

Installing an SATA SSD m 2 sata slot So if you try to use a PCI-E drive in a SATA-only slot it will not function correctly PCI-E drives should really be m2 pcie 40 in 30 slot Yet there are 5 SATA ports in the bios…and the M2 stick is showing up in that 5th port That much makes sense to me The 'problem' is

m2 vs nvme slot Adapter – 3 Port – 1 x PCIe – 2 x SATA III – SSD PCIE Adapter – M2 SSD – PCI Express SSD