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
sample
2,371 rows
| Column | Type | Description |
|---|---|---|
sample_id |
string | **Primary Key** |
schema_id |
string | Data schema reference |
accn |
string | Accession number |
locations |
string | Geographic locations |
number_vals |
string | Numeric metadata values |
string_vals |
string | String metadata values |
datetime_vals |
string | Temporal metadata values |
Sample Queries
Get marine samples
SELECT *
FROM planetmicrobe_planetmicrobe.sample
LIMIT 20
Get sampling events
SELECT *
FROM planetmicrobe_planetmicrobe.sampling_event
LIMIT 20