Related Experiment Video
Updated: Jun 22, 2025

Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
Published on: March 19, 2018
Multiple graphical views for automatically generating SQL for the MycoDiversity DB; making fungal biodiversity
Irene Martorelli1,2, Aram Pooryousefi1, Haike van Thiel1
1Leiden Institute of Advanced Computer Science (LIACS), Leiden University, Leiden, Netherlands Leiden Institute of Advanced Computer Science (LIACS), Leiden University Leiden Netherlands.
This study introduces the MycoDiversity DataBase User Interface, a tool for accessing previously unavailable fungal biodiversity data. It helps researchers analyze fungal communities using DNA sequencing data for ecological studies.
Area of Science:
- Mycology
- Ecology
- Bioinformatics
Background:
- Fungi exhibit high diversity across diverse environments.
- Understanding fungal biodiversity drivers and spatial variation is crucial.
- Metabarcoding advances fungal community observation but data is fragmented and inaccessible.
Purpose of the Study:
- To develop a user interface for direct access and retrieval of fungal biodiversity data.
- To integrate geo-location, taxonomic, and environmental data for fungal species.
- To facilitate the use of public DNA sequencing data for fungal biodiversity research.
Main Methods:
- Development of the MycoDiversity DataBase User Interface.
- Integration of geo-location, taxonomic names, and environmental features.
- Implementation of interactive topological maps and hierarchical trees for data exploration.
- SQL query generation for direct DNA sequencing data access.
Main Results:
- The MycoDiversity DataBase User Interface provides accessible fungal biodiversity data.
- Graphical views reveal data components like geo-location, taxonomy, and environment.
- Interactive tools enable SQL query creation for data retrieval.
- Search results are presented in downloadable, configurable tables.
Conclusions:
- The MycoDiversity DataBase User Interface enhances accessibility of fungal biodiversity data.
- It supports researchers and stakeholders in utilizing metabarcoding studies for biodiversity assessment.
- This tool bridges the gap between raw sequencing data and actionable biodiversity insights.
Related Concept Videos
pV-Diagrams
Statistical Analysis: Overview
One of the most commonly used statistical quantifiers is the mean, which is the ratio between the sum of the numerical values of all results and the...
Pedigree Analysis
Interpreting Run Charts
Ogive Graph
Bar Graph

