Marine_Sequences

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

Sequence_accession_number

Unique identifier for the genetic sequence as specified in INSDC databases (Primary Key). Searchable

Species_name

Species associated with the sequence, linking to the Marine Species table. Searchable

GC_content

GC content of the sequence

Sequence_length

Length of the sequence

Sequence_status

Status of the sequence (e.g., confirmed, predicted)

Is_protein_coding_sequence

Indicates if the sequence is protein-coding (1 for yes, 0 for no)

Is_annotated

Indicates if the sequence has been annotated (1 for yes, 0 for no)

5 rows where Is_annotated = 1, Is_protein_coding_sequence = 1 and Species_name = "Glaciecola punicea"

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE TABLE Marine_Sequences (
        Sequence_accession_number TEXT PRIMARY KEY,
        Species_name TEXT,
        GC_content TEXT,
        Sequence_length TEXT,
        Sequence_status TEXT,
        Is_protein_coding_sequence INTEGER,
        Is_annotated INTEGER,
        FOREIGN KEY (Species_name) REFERENCES Marine_Species (Species_name),
        FOREIGN KEY (Sequence_accession_number) REFERENCES Sequences (Sequence_accession_number)
    );