PlanetMicrobe
planetmicrobe
Philosophy
Catalog marine microbial diversity. Connect oceanographic sampling with microbial community composition and function for global-scale marine ecology research.
Data sources:
PlanetMicrobe
Scale
2,371
samples
5,946
experiments
1,151
sampling_events
30
tables
Schema Browser
experiment
5,946 rows
| Column | Type | Description |
|---|---|---|
experiment_id |
string | **Primary Key** |
sample_id |
string | FK -> `sample` |
name |
string | Experiment name |
accn |
string | Accession number |
Sample Queries
Get marine samples
SELECT *
FROM planetmicrobe_planetmicrobe.sample
LIMIT 20
Get sampling events
SELECT *
FROM planetmicrobe_planetmicrobe.sampling_event
LIMIT 20