Marine_Species

Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT

Species_name

Name of the marine species (Primary Key). Searchable

Domain

Taxonomic domain of the species

Phylum

Taxonomic phylum of the species

Taxonomic_source

Source of the taxonomic classification

Is_deep_sea

Indicates if the species is a deep-sea species (1 for yes, 0 for no)

Deep_sea_source

Source of information on the species' deep-sea status

Is_ABNJ_present

Indicates if the species is present in ABNJ (YES, NO, UNKNOWN)

61 rows where Is_ABNJ_present = "YES", Is_deep_sea = 0 and Phylum = "Proteobacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE TABLE Marine_Species (
        Species_name TEXT PRIMARY KEY,
        Domain TEXT,
        Phylum TEXT,
        Taxonomic_source TEXT,
        Is_deep_sea INTEGER,
        Deep_sea_source TEXT,
        is_ABNJ_present TEXT
    );