Few things:
First off, I am approaching this strictly in layman's terms. I understand the chemistry of the question, but an average joe and jane isn't going to know the scientific definition or difference of silica, silicate, silicon, or know what a silicon-oxygen tetrahedron is--or care. Or that the term "sand" merely refers to a specific size of particles and can be any number of elements or compounds. I am going by what is said on the bags of sand sold in the
lfs or Home Depot.
That being said, sand, as it is sold in stores, comes in a few forms--I'll stick to the three most commonly used:
Silica, or quartz sand, is essentially crushed quartz rock. It is sold in many stores for many purposes (e.g. pool filter sand) and is usually a bright white color. It is by far the most common of all sand, and is the form on most beaches. It is chemically inert, meaning that it will not affect the tank's water in any way. This makes it excellent for fish requiring low or neutral pH water. One downside is that quartz is a crystal, and breaks jagged--it seems that any fish that likes to dig would essentially be sifting crushed glass through their gills. I have not heard of anyone having any problems with it, but someone here may tell you differently.
Argonite, or calcium carbonate sand, comes from coral reefs, and is essentially crushed coral. It is formed by the motion of waves breaking up reefs and then depositing the resulting sand on the beach. These particles are generally more rounded--which explains the "fluffy" sand that is so wonderful on Key West and Carribean beaches. It is sold as argonite sand in the
lfs, and is sold as "Carribean Play Sand" in Home Depot (there are other names, such as Southdown). Please note, if this is the stuff you were looking for, it will say "no silica" on the bag. It can range from white to a tan, and
IMO looks more natural. This sand will raise the pH of the tank, if it is low. This sand is excellent for African cichlids, and other fish that love to dig in the sand and need hard water with a high pH.
The third kind most commonly used is black lava sand. The only commercial name I found was Tahitian Moon sand. Black lava sand is black due to the presence of manganese compounds. It is formed by the motion of waves breaking down the lava rock. I don't know much more about this sand, other than some people say it is high in iron.
HTH!