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

`library`

## Pitfalls

Column	Type	Description
`library_id`	string	Primary Key
`experiment_id`	string	FK -> `experiment`
`name`	string	Library name
`strategy`	string	Sequencing strategy
`source`	string	Source material
`selection`	string	Selection method
`protocol`	string	Protocol description
`layout`	string	Library layout
`length`	string	Fragment length

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