[MINOR_METAL] will make them use the weakest available metal (in vanilla, copper).
[STONE_PREF] has nothing to do with metal -- it allows the trading of stone and stone items, and might or might not allow races to use obsidian weapons. A race with no metal tags will default to iron (or whatever's one step below the strongest metal?).
[GEM_PREF] is for use of gems.
[WOOD_PREF] is something only elves have. It allows them to use wood without them letting you trade it to them?
[INDOOR_FARMING] allows use of subterranean plants and their products.
[OUTDOOR_FARMING] does the same thing, but with above-ground plants.
[RIVER_PRODUCTS] and [OCEAN_PRODUCTS] allow the use of river and ocean animals.
[USE_ANIMAL_PRODUCTS] will allow usage of meat, leather, and bone. Maybe silk too.
[USE_MISC_PROCESSED_WOOD_PRODUCTS] is for logs and wood items. Elves do not have this tag.
[USE_CAVE_ANIMALS] allows use of animals with subterranean biomes (magma seems to be excluded).
[SUBTERRANEAN_CLOTHING] I'm not sure of the interaction between this, animal product usage, and cave animal usage, but it allows (G)CS silk and pig tail clothes. Maybe cave animal leather too, if the civ has the necessary tag.
[USE_GOOD / EVIL_ANIMALS / PLANTS / WOOD] -- Entities won't use good / evil flora and fauna unless you tell them to.
There's no clear relationship between these tags and the permitted jobs -- you can remove the butchery and tanning jobs from a civ and give it the same KILL_ANIMAL ethic as the elves and it'll still bring leather and meat if it has [USE_ANIMAL_PRODUCTS].