home / MABPAT_dataset

Marine_Sequences

Provides detailed information about each marine genetic sequence, including its GC content, sequence length, and whether it contains protein-coding information.

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 Sequence_status = "observed" and Species_name = "Lytechinus variegatus"

✎ View and edit SQL

This data as json, CSV (advanced)

Is_protein_coding_sequence 2

  • 0 3
  • 1 2

Is_annotated 2

  • 0 3
  • 1 2

Species_name 1

  • Lytechinus variegatus · 5 ✖

Sequence_status 1

  • observed · 5 ✖
Sequence_accession_number ▼ Species_name GC_content Sequence_length Sequence_status Is_protein_coding_sequence Is_annotated
GN079751 Lytechinus variegatus 42.6597582037997 579.0 observed 1 1
HH771156 Lytechinus variegatus 44.3108974358974 1248.0 observed 1 1
OF274700 Lytechinus variegatus 53.8035264483627 3970.0 observed 0 0
OF274823 Lytechinus variegatus 30.0 10.0 observed 0 0
OF274946 Lytechinus variegatus 30.3030303030303 297.0 observed 0 0

Advanced export

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

CSV options:

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)
    );
Powered by Datasette · Queries took 269.313ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT