Marine_Sequences
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, Sequence_status = "predicted" and Species_name = "Fragilariopsis cylindrus ccmp1102"
This data as json, CSV (advanced)
Species_name 1
- Fragilariopsis cylindrus ccmp1102 · 10 ✖
Sequence_status 1
- predicted · 10 ✖
Is_protein_coding_sequence 1
- 1 10
Is_annotated 1
- 1 · 10 ✖
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
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) );