Taxonomic database of diatom microalgae from Crimean inland waters

A.M. Lyakh1, I.V. Agarkova-Lyakh2

1 A.O. Kovalevsky Institute of Biology of the Southern Seas of RAS, RF, Sevastopol, Nakhimov Av., 2


2 Institute of Natural and Technical Systems, RF, Sevastopol, Lenin St., 28


DOI: 10.33075/2220-5861-2022-2-22-30

UDC 574.5+561.26:477.75(556.5)+004.65               


   The paper describes the database structure for storing taxonomic, geographical, ecological and other data on diatom microalgae of inland waters of the Crimean Peninsula. Structure of the database is designed from information modules and includes taxonomic and geographic modules, modules with ecological parameters, with the description of data sources, and information on individual cells of microalgae. The modules are bound together using a linking table. The entries of this table consist of fields for storing: the identifier of a specimen, a taxonomic name, the location of finding, the values of ecological parameters, the date of finding, and the identifier of a data source.
Usually, instead of the mentioned complex information, we get its fragments, in which, for example, there are no values of ecological characteristics of sampling locations, the exact position of sampling points is unknown or there is no information about the specimens of organisms used for species identification. The structure of the linkage table allows storing such fragments, it is enough to leave out the fields with missing values.
The information published in L.N. Bukhtiyarova’s monograph (1999) was used for filling the database. These data were digitized, systematized, and structuralized by the authors. The information system for remote work with the materials of the database is located at: 3d
The structure of the database is universal and allows storing complex ecological and geographical information about any groups of organisms from any region.

Keywords: biological database, taxonomic information system, geographical object, diatoms, taxonomic composition, Crimea, inland waters.

To quote: 

Full text in PDF(RUS)


  1. Bukhtiyarova L.N. Bacillariophyta v monitoringe rechnykh ekosistem. Sovremennoe sostoyanie i perspektivy ispolzovaniya (Bacillariophyta in biomonitoring of river ecosystems. Modern situation and perspectives of application). Internatinal Journal of Algae, 1999, Vol. 9, No. 3, pp. 89–103.
  2. Ruhland K.M., Paterson A.M., and Smol J.P. Lake diatom responses to warming: reviewing the evidence. Journal of Paleolimnology, 2015, Vol. 54, pp. 1–35.
  3. Vasiljevic B., Simic S.B., Paunovic M., Zuliani T., Krizmanic J., Markovic V., and Tomovic J. Contribution to the improvement of diatom-based assessments of the ecological status of large rivers – the Sava River case study. Science of the Total Environment, 2017, Vol. 605–606, pp. 874–883.
  4. Tornes E., Mor J.-R., Mandaric L., and Sabater S. Diatom responses to sewage inputs and hydrological alteration in Mediterranean streams. Environmental Pollution, 2018, Vol. 238, pp. 369–378.
  5. Falasco E., Bona F., Badino G., Hoffmann L., and Ector L. Diatom teratological forms and environmental alterations: a review. Hydrobiologia, 2009, Vol. 623, pp. 135.
  6. Falasco E., Ector L., Wetzel C.E., Badino G., and Bona F. Looking back, looking forward: a review of the new literature on diatom teratological forms (2010-2020). Hydrobiologia, 2021, Vol. 848, pp. 1675–1753.
  7. Bukhtiyarova L.N. Diatoms of Ukraine. Inland waters. Kyiv: M. G. Kholodny Institute of Botany, 1999, 134 p.
  8. Kulikovsky M.S., Gluschenko A.M., Genkal S.I., and Kuznetsova I.V. Opredelitel diatomovykh vodorosley Rossii (Idenification book of diatoms from Russia). Yaroslavl: Filigran, 2016, 804 p.
  9. Genkal S.I., Kulikovsky M.S., and Kuznetsova I.V. Sovremennye presnovodnye tsentricheskie diatomovye vodorosli Rossii (The recent freshwater centric diatoms of Russia). Yaroslavl: Filigran, 2020, 433 p.
  10. Lyakh A.M. and Lelekov S.G. Modulnaya struktura taksonomicheskoy bazy dannykh (The modular structure of a taxonomic database). Electronic Information Systems, 2018, No. 2 (17), pp. 59–70.
  11. Lyakh A.M. Minimalnaya struktura bazy dlya hraneniya dannyh o biologicheskom raznoobrazii organizmov (Minimal structure of the database for storing organisms’ biodiversity data). SPIIRAS Proceedings, 2020, Vol. 19, No. 4, pp. 855–879.
  12. Lyakh A.M. and Agarkova-Lyakh I.V. Relyatsionnaya model bazy dannykh dlya khraneniya ekologo-biologicheskikh ekspeditsionnykh dannykh. Monitoring systems of environment, 2021, № 3 (45), pp. 98–106.
  13. Williams D.M. Names, taxa and databases: some aspects of diatom nomenclature. Diatom Research, Vol. 36, No. 2, pp. 101–106.
  14. Guiry M.D. and Guiry G.M. AlgaeBase. World-wide electronic publication, National University of Ireland, Galway, 2022.
  15. Podgorodetsky P.D. Krym: Priroda: Spravochnoe izdanie (The Crimea: Nature. A reference book). Simferopol: Tavriya, 1988, 192 p.
  16. Kuzmin S.B. Obschee geomorfologicheskoe rayonirovanie i kartografirovanie Krymskogo poluostrova (General geomorphological zoning and mapping of the Crimean Peninsula). Climate & Nature, 2021, No. 2 (39), pp. 3–36.
  17. Sovremennye landshafty Kryma i sopredelnykh aquatoriy: Monografiya (Modern landscapes of the Crimea and adjacent water areas: Monograph) / Sci. edt. E.A. Pozachenyuk. Simferopol: Biznes-Inform, 2009. 672 p.
  18. Oliferov A.N. and Timchenko Z.V. Reki i ozera Kryma (Rivers and lakes of Crimea). Simferopol: Dolya, 2005. 216 p.
  19. Dunaeva E.A. and Kovalenko P.I. Tipizatsiya basseynov rek Kryma po agrolandshaftam i ekologicheskoy nagruzke na nikh (River basins typification on Crimea by agrolandscapes and ecological load). Nauchny zhurnal Rossiyskogo NII problem melioratsii. 2013, No. 4 (12), pp. 157–167.
  20. Bukhtiyarova L.N. Diatomovye vodorosli gornogo Kryma: Dis. … kand. biol. nauk (Diatoms of the mountain Crimea. Cand. biol. sci.), Kiev: In-t Botaniki N.G. Kholodnogo, 1992, 18 p.