MABPAT_dataset: Marine_Species: 9 rows where Domain = "Archaea" and Phylum = "Crenarchaeota"

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)

9 rows where Domain = "Archaea" and Phylum = "Crenarchaeota"

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
Aeropyrum pernix	Archaea	Crenarchaeota	WoRMS	1	2018	UNKNOWN
Hyperthermus butylicus	Archaea	Crenarchaeota	WoRMS	0	0	UNKNOWN
Ignicoccus hospitalis	Archaea	Crenarchaeota	WoRMS	1	2018	UNKNOWN
Pyrobaculum aerophilum	Archaea	Crenarchaeota	WoRMS	0	0	UNKNOWN
Pyrodictium abyssi	Archaea	Crenarchaeota	WoRMS	0	0	UNKNOWN
Pyrodictium brockii	Archaea	Crenarchaeota	WoRMS	0	0	UNKNOWN
Pyrodictium occultum	Archaea	Crenarchaeota	WoRMS	0		UNKNOWN
Pyrolobus fumarii	Archaea	Crenarchaeota	WoRMS	1	2018	UNKNOWN
Staphylothermus marinus	Archaea	Crenarchaeota	WoRMS	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
    );