Yes, it's a USB-UART interface, or more commonly "USB-TTL serial adapter" - variations like that (often people leave out "TTL" in conversation). The three that people commonly use are the FT232RL, CP2102, and CH340G.
HIN232 and MAX232 are not USB serial adapters, they are TTL serial to RS232 serial adapters, ie, they change the voltage levels from 5v and 0v to 10v and -10v as required for RS232 (this increases the length of cable that can be used, but requires a converter at both ends). These chips are also used often as a ghetto way to get a dual supply, as they're both cheaper and easier to work with than the switcher that would otherwise be needed (those cheap ultrasonic ranging modules use this to turn 5v into +/-10v, which they connect soas to put the full 20v across the transducer used to send the ping)
I don't know of any alternatives that come in through-hole package. But I also strongly recommend against making your own USB serial adapter on a breadboard - only do it if you're making a custom PCB and really need it to be integrated; If you're making your own PCB, I'd use a CH340G. Dirt shit cheap (25 cents a pop or so), easy to solder by hand in SOIC-16 ( easier than the TSSOP package of the FT232 and much easier than the no-lead package of the CP2102), and pretty forgiving of abuse and halfassed design (FFS, I think the third PCB I designed that wasn't just prototyping board was a CH340G based adapter, out of unabashed NIHism, and they worked great)
If you're just breadboarding, there's no reason to reinvent the wheel; CH340G serial adapters that are great for Arduino are under $2 each. I like these: 1PCS 5v CH340G Serial Converter USB 2.0 To TTL 6PIN Module for PRO mini K9 | eBay - no specific endorsement of that vendor, many sell them. Search for CH340G 6pin, and buy the ones with the little switch on the board (there are a few other designs with the wrong pinout, terribad build quality (the sub-$1 ones are awful; I've had them arrive with the USB connector barely attached), and/or problems when running at 3.3v; the black ones with the switch are great though).
As an aside, never try to buy cheap FT232RL chips on ebay/et al - there are counterfeit ones around, but they don't actually work on windows, and you can't tell until you have it assembled and find that they don't work.