MABPAT_dataset: Marine_Species: 1 row where Is_ABNJ_present = "UNKNOWN", Is_deep_sea = 0 and Phylum = "Candidatus Thermoplasmatota"

Catalogs marine species associated with genetic sequences in the dataset. It includes the species name, taxonomic classification (domain, phylum), and information on whether the species is considered deep-sea.

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)

1 row where Is_ABNJ_present = "UNKNOWN", Is_deep_sea = 0 and Phylum = "Candidatus Thermoplasmatota"

Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Species_name ▼	Domain	Phylum	Taxonomic_source	Is_deep_sea	Deep_sea_source	is_ABNJ_present
Uncultured marine group ii euryarchaeote 37f11	Archaea	Candidatus Thermoplasmatota	NCBI	0	0	UNKNOWN

Advanced export

JSON shape: default, array, newline-delimited, object

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
    );