Full write-up of the database design: tables, relationships, and example queries for microbiome data.
The database models samples, taxonomy, and measurements as related tables so microbiome results can be queried with standard SQL rather than scattered spreadsheets.
The accompanying report walks through the schema design, entity relationships, and a set of example queries that pull taxonomic abundance and sample metadata together in a single statement.