You need to leave the "adapter cable" ideology behind. You want a proper interface like this. There are plenty like it around the $60-100 USD price range. Integrated phantom power so you don't need a separate phantom power supply. Those "adapter cables" try to cram some cheap analog-to-digital USB hardware into a very small space, and the result is a shitty overall product.

Also, the above poster is ribbing you for saying 48 watts instead of 48 volts in terms of phantom power.