I don't think any of us truly knows....I've built and helped build houses....I know how flooring is layed out. It all comes down to who has the bigger stones to find out what the biggest size (wgt/sq.ft.) holds until something gives. Then comes the question of sagging/warping over time. New composite wood?? Personally I don't trust things that are composite....might be stronger but more brittle. If we really want to find out someone will have to pay to have an engineer do stress analysis on 2x10's per foot with say 500lb increments. We would also have to know how much or atleast the rate that sagging would occur. I think up to a 150gal, 6ft. footprint sounds feasible but honestly I wouldnt' go another fifty gal. unless I had atleast 2 more ft.
We've also not really dicussed footprint with respect to depth (front to back). A 55gal isn't exactly huge so I did go ahead and run it with the joists because thats the wall I wanted it on. Now, we could probably say that a 55 might get up to about 500lbs. This tank is enough to give almost a 1/4in. sag....closer to an 1/8in. This being said, I suggest being careful of depth of tank and state that it would be imparative that anything larger than a 55gal. be placed against the wall perpendicular to the floor joists. If you don't know which way they run, generally consider that it will run the length of the shortest dimension..... eg. If the house is 20 by 40ft, you would run them 20 feet long.
Here's the simplest solution.... Put some support beams in starting from the foundation to the floor of placement. Some nice things can be done with 6x6's or 8x8's to dress them up for the floors they go through. You can also get steel tube pilars that will work but I don't think look as nice.
GOOD LUCK!!!!!