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)

12 rows where Is_annotated = 1, Sequence_status = "observed" and Species_name = "Photobacterium leiognathi"

✎ View and edit SQL

This data as json, CSV (advanced)

Species_name 1

  • Photobacterium leiognathi · 12 ✖

Sequence_status 1

  • observed · 12 ✖

Is_protein_coding_sequence 1

  • 1 12

Is_annotated 1

  • 1 · 12 ✖
Sequence_accession_number ▼ Species_name GC_content Sequence_length Sequence_status Is_protein_coding_sequence Is_annotated
DM044402 Photobacterium leiognathi 32.3293172690763 1494.0 observed 1 1
GM961059 Photobacterium leiognathi 42.4924924924925 666.0 observed 1 1
HV543459 Photobacterium leiognathi 42.8921568627451 1632.0 observed 1 1
HW313969 Photobacterium leiognathi 41.5023474178404 1065.0 observed 1 1
HW313970 Photobacterium leiognathi 37.3088685015291 981.0 observed 1 1
HW313971 Photobacterium leiognathi 38.8308977035491 1437.0 observed 1 1
HW313972 Photobacterium leiognathi 34.915611814346 948.0 observed 1 1
HW313973 Photobacterium leiognathi 36.1853832442068 1122.0 observed 1 1
HW313974 Photobacterium leiognathi 34.7517730496454 705.0 observed 1 1
JC210416 Photobacterium leiognathi 32.3567708333333 1536.0 observed 1 1
LY980213 Photobacterium leiognathi 47.3895582329317 1494.0 observed 1 1
LY980215 Photobacterium leiognathi 47.4120082815735 1449.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 1552.428ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT