You need to identify your clam before making decisions on keeping one. As mentioned in that other post, clams can live for over a hundred years (freshwater mussels are among the longest-lived animals known). The difference between clams and mussels by the way is a bit meaningless and not used by scientists. They are all bivalve molluscs.
Freshwater mussels, the ones traded in the US and UK anyway, are species of
Unio and Anodonta. These are know variously as "swan mussels", "painter's mussels", and the like. They are vitually impossible to keep alive in tropical fish tanks. They need cool, well-oxygenated water containing lots of green algae. Sometimes they do well in ponds, but that's about it.
They cannot "scavenge" in any way whatsoever. They can only pump water across the gills and extract small animals and algae thus. Freshwater mussels
do produce parasitic larvae (known as glochidia) that attach to the gill filaments of cyprinid fishes such as minnows and carp. Freshwater mussels are easy to recognise: they are large, have very oval shells, and a greenish-brown tint.
Freshwater clams are not widely traded at all. The one species you are likely to find is
Corbicula fluminea. It is small, about the size and shape of a large grape. Also known as the "Asian clam". Tolerates warm water well, and also slightly brackish water. Not really suitable for coldwater aquaria.
It is another strictly filter-feeding organism, and cannot scavenge. Asian clams do not produce parasitic larvae.
Reports that either can survive by "scavenging" in an aquarium are erroneous; at best these molluscs will simply die extremely slowly, starving to death over months or years. If you want to keep these animals in an aquarium, you
must feed them. Consult with any marine aquarium handbook on tips for feeding filter-feeding animals; there are numerous techniques and options for suitable foods.
There are some deposit-feeding bivalves that use their siphons to suck up tiny organisms such as ostracods from the substrate. Examples include the tellin, Macoma, and the nutclam, Nucula. These are all marine, as far as I know, and none of the freshwater species are deposit feeders.
I don't know what to make of
afishdude's report of a clam eating a fish. Biologically, it's impossible. They do not have jaws. The mouth is close to the gills, and rows of cilia transport tiny particles of food along a stream of mucous into the mouth. There is no way whatsoever a clam could catch a fish, cut off some fin, and move the fin into the mouth and eat it. Clams do close their shells when threatened, but not with sufficient force that a fish could be killed or damaged.
In short: for 99.9% of aquarists, buying a clam for a freshwater aquarium amounts of buying an animal that will dead within a few months. Since they don't do much beyond burrowing into the sand, you may as well just buy some clam or oyster shells and stick them in the aquarium where you want. Look much the same and far cheaper.
Cheers,
Neale