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)

31 rows where Is_annotated = 1, Sequence_status = "observed" and Species_name = "Synechococcus sp. pcc 7002"

✎ View and edit SQL

This data as json, CSV (advanced)

Species_name 1

  • Synechococcus sp. pcc 7002 · 31 ✖

Sequence_status 1

  • observed · 31 ✖

Is_protein_coding_sequence 1

  • 1 31

Is_annotated 1

  • 1 · 31 ✖
Sequence_accession_number ▼ Species_name GC_content Sequence_length Sequence_status Is_protein_coding_sequence Is_annotated
E06956 Synechococcus sp. pcc 7002 50.8121468926554 2832.0 observed 1 1
GN000424 Synechococcus sp. pcc 7002 39.1430646332607 2754.0 observed 1 1
GN000426 Synechococcus sp. pcc 7002 45.4280510018215 2745.0 observed 1 1
GN109720 Synechococcus sp. pcc 7002 53.7202380952381 672.0 observed 1 1
GN128046 Synechococcus sp. pcc 7002 55.3865652724968 789.0 observed 1 1
HC495123 Synechococcus sp. pcc 7002 50.7291666666667 960.0 observed 1 1
HC495125 Synechococcus sp. pcc 7002 51.0224948875256 978.0 observed 1 1
HC496264 Synechococcus sp. pcc 7002 53.1051964512041 1578.0 observed 1 1
HC496839 Synechococcus sp. pcc 7002 53.5947712418301 1224.0 observed 1 1
HC496987 Synechococcus sp. pcc 7002 47.2666666666667 1500.0 observed 1 1
HC497913 Synechococcus sp. pcc 7002 50.8547008547009 702.0 observed 1 1
HC743147 Synechococcus sp. pcc 7002 47.9041916167665 501.0 observed 1 1
HC743264 Synechococcus sp. pcc 7002 49.3734335839599 399.0 observed 1 1
HC743783 Synechococcus sp. pcc 7002 53.6429872495446 1098.0 observed 1 1
HC745069 Synechococcus sp. pcc 7002 49.1319444444444 576.0 observed 1 1
HC745716 Synechococcus sp. pcc 7002 52.2075055187638 906.0 observed 1 1
HC745718 Synechococcus sp. pcc 7002 53.0454042081949 903.0 observed 1 1
HC746625 Synechococcus sp. pcc 7002 53.0565167243368 867.0 observed 1 1
HC746627 Synechococcus sp. pcc 7002 46.9174503657262 957.0 observed 1 1
HC748742 Synechococcus sp. pcc 7002 54.4260027662517 1446.0 observed 1 1
HC749796 Synechococcus sp. pcc 7002 51.4625850340136 2940.0 observed 1 1
HC749798 Synechococcus sp. pcc 7002 49.5183044315992 2595.0 observed 1 1
HC750471 Synechococcus sp. pcc 7002 50.6410256410256 624.0 observed 1 1
HC750649 Synechococcus sp. pcc 7002 56.6666666666667 810.0 observed 1 1
HC753774 Synechococcus sp. pcc 7002 51.3605442176871 588.0 observed 1 1
JC196591 Synechococcus sp. pcc 7002 48.6821705426357 1290.0 observed 1 1
JC196599 Synechococcus sp. pcc 7002 49.5476687543493 1437.0 observed 1 1
JC196612 Synechococcus sp. pcc 7002 54.1922290388548 978.0 observed 1 1
JC196614 Synechococcus sp. pcc 7002 53.2293986636971 1347.0 observed 1 1
JC196615 Synechococcus sp. pcc 7002 49.7916666666667 960.0 observed 1 1
LQ663857 Synechococcus sp. pcc 7002 47.7620730270907 1698.0 observed 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)
    );
Powered by Datasette · Queries took 1292.081ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT