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)

21 rows where Is_annotated = 0, Sequence_status = "observed" and Species_name = "Nodularia spumigena"

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Sequence_status, Is_protein_coding_sequence, Is_annotated, Species_name

Sequence_accession_number ▼ Species_name GC_content Sequence_length Sequence_status Is_protein_coding_sequence Is_annotated
CQ788406 Nodularia spumigena 34.4444444444444 720.0 observed 0 0
CQ793236 Nodularia spumigena 33.6231884057971 690.0 observed 1 0
CQ793257 Nodularia spumigena 34.4444444444444 720.0 observed 0 0
CQ793400 Nodularia spumigena 33.6231884057971 690.0 observed 1 0
CQ793565 Nodularia spumigena 33.6231884057971 690.0 observed 1 0
CQ793626 Nodularia spumigena 34.4444444444444 720.0 observed 0 0
CS046312 Nodularia spumigena 35.1213282247765 783.0 observed 1 0
CS046314 Nodularia spumigena 35.1213282247765 783.0 observed 1 0
CS046376 Nodularia spumigena 35.6877323420074 807.0 observed 0 0
CS046378 Nodularia spumigena 35.8116480793061 807.0 observed 0 0
DI345456 Nodularia spumigena 45.6356180433509 1707.0 observed 1 0
GM737047 Nodularia spumigena 40.3799019607843 3264.0 observed 1 0
HC492290 Nodularia spumigena 46.5686274509804 612.0 observed 1 0
HC508035 Nodularia spumigena 45.6356180433509 1707.0 observed 1 0
HC508947 Nodularia spumigena 45.6356180433509 1707.0 observed 1 0
HC509646 Nodularia spumigena 45.6356180433509 1707.0 observed 1 0
HW268047 Nodularia spumigena 45.6356180433509 1707.0 observed 1 0
JC738400 Nodularia spumigena 45.6356180433509 1707.0 observed 1 0
JD593997 Nodularia spumigena 50.3401360544218 147.0 observed 0 0
LF709845 Nodularia spumigena 45.6356180433509 1707.0 observed 1 0
OF062738 Nodularia spumigena 50.3401360544218 147.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 6898.745ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT