Microbial Discovery Forge

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

Tables (4)

sample 2,371 sampling_event 1,151 experiment 5,946 library

`sampling_event` 1,151 rows

Column	Type	Description
`sampling_event_id`	string	Primary Key
`sampling_event_type`	string	Event type
`campaign_id`	string	FK -> `campaign`
`name`	string	Event name
`locations`	string	Geographic coordinates
`start_time`	string	Start timestamp
`end_time`	string	End timestamp

Sample Queries

Get marine samples

SELECT *
FROM planetmicrobe_planetmicrobe.sample
LIMIT 20

Get sampling events

SELECT *
FROM planetmicrobe_planetmicrobe.sampling_event
LIMIT 20

Sub-Collections

planetmicrobe_planetmicrobe

View collection →

planetmicrobe_planetmicrobe_raw

View collection →

Start Exploring

Access the full PlanetMicrobe data through BERDL JupyterHub.

Open JupyterHub

PlanetMicrobe