This just in:
There are 40 million bacterial cells in a single gram of soil
There are 1 million bacterial cells in a single milliliter of freshwater
There are 5 nonillion (5x10^30) bacteria on Earth
(granted this is # organisms, not species)
I believe there are about 250,000 species of beetles on earth.
But alas, I am wrong:
Group and Number of Species
Higher plants - 270,000
Algae - 40,000
Fungi - 72,000
Bacteria (including cyanobacteria) - 4,000
Viruses - 1,550
Mammals - 4650
Birds - 9700
Reptiles - 7150
Fish - 26,959
Amphibians - 4,780
Insects - 1,025,000
Crustaceans - 43,000
Molluscs - 70,000
Nematodes and worms - 25,000
Protozoa - 40,000
Others - 110,000
Eukaryotes bring home the money. Though their recent origin compared to bacteria does have me confused as to how they achieved this..