The wall in question almost certainly needs a structural engineer to sign off before you touch it, and that's not optional - it's a code thing. I learned this the hard way when my wife and I wanted to open up our kitchen a few years back; we thought we'd save money by skipping the assessment, but our contractor basically laughed us out of the room and said the permit wouldn't go through without an engineer's stamp. They'll look at things like what's directly above the wall, how the floor joists run, whether there are bearing points underneath, and what kind of load is being carried - and yeah, most walls running perpendicular to those joists and supporting anything above (another floor, roof framing) are load-bearing and will need a beam. The actual beam itself can be steel, LVL, or engineered wood depending on the span and load, but you won't know what you need until someone qualified looks at your specific house.