What manual transmissions were behind the magnums and do they fit into my car

To my knowledge, it's all truck stuff. Not really a go.

Look into any of the four-speeds, or Passon's 5 speed (long wait list I've heard), or any of the 5/6 speed swaps that are small block compatible. Only the factory transmissions and Passon's would be bolt ins.