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)

10 rows where Is_annotated = 1 and Species_name = "Fragilariopsis cylindrus ccmp1102"

✎ View and edit SQL

This data as json, CSV (advanced)

Species_name 1

  • Fragilariopsis cylindrus ccmp1102 · 10 ✖

Sequence_status 1

Is_protein_coding_sequence 1

  • 1 10

Is_annotated 1

Sequence_accession_number ▼ Species_name GC_content Sequence_length Sequence_status Is_protein_coding_sequence Is_annotated
HL526246 Fragilariopsis cylindrus ccmp1102 44.0129449838188 1545.0 predicted 1 1
HL526247 Fragilariopsis cylindrus ccmp1102 41.966966966967 1332.0 predicted 1 1
MI078976 Fragilariopsis cylindrus ccmp1102 42.9980276134122 507.0 predicted 1 1
MM777211 Fragilariopsis cylindrus ccmp1102 40.7137064071371 1233.0 predicted 1 1
MM777212 Fragilariopsis cylindrus ccmp1102 35.9801488833747 2418.0 predicted 1 1
MV349152 Fragilariopsis cylindrus ccmp1102 44.4289044289044 4290.0 predicted 1 1
MV349153 Fragilariopsis cylindrus ccmp1102 43.3460076045627 3156.0 predicted 1 1
MV802898 Fragilariopsis cylindrus ccmp1102 41.9047619047619 1470.0 predicted 1 1
MV802899 Fragilariopsis cylindrus ccmp1102 46.1486025903204 1467.0 predicted 1 1
MX176516 Fragilariopsis cylindrus ccmp1102 37.3626373626374 819.0 predicted 1 1

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