The freshwaterecology.info database contains ecological characteristics and distribution patterns of more than 12.000 European freshwater organisms belonging to fish, macro-invertebrates, macrophytes, diatoms and phytoplankton. The ecology data feature (amongst others) ecoregional and altitudinal distribution, temperature and stream zonation preference, substrate or microhabitat preference, feeding type, life duration, saprobity and many more. All ecological parameters can be individually combined and queried.
More information on this dataset can be found in the Freshwater Metadatabase - BF20 (http://www.freshwatermetadata.eu/metadb/bf_mdb_view.php?entryID=BF20).