home

MABPAT_dataset

Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT

Custom SQL query

Queries

  • All database records with sequences derived from species uniquely present in ABNJ
  • Unified query search for patent applicant names across all dataset tables
  • Unified query search for marine species names across all dataset tables

Tables

Applicants

Applicant_name, Applicant_type, Applicant_country

1,326 rows

Applications

Patent_application_number, Applicant_name, Year_of_application, Patent_system

4,779 rows

Applications_Sequences

Patent_application_number, Sequence_accession_number, ID

557,532 rows

Marine_Sequences

Sequence_accession_number, Species_name, GC_content, Sequence_length, Sequence_status, Is_protein_coding_sequence, Is_annotated

104,467 rows

Marine_Sequences_Protein_Annotations

Sequence_accession_number, f_header, sseqid, stitle, pident, evalue, qcovs, annotation_source

71,149 rows

Marine_Species

Species_name, Domain, Phylum, Taxonomic_source, Is_deep_sea, Deep_sea_source, is_ABNJ_present

1,639 rows

Sequences

Sequence_accession_number, Species_name, Is_marine_species

557,484 rows

... and 35 hidden tables

Views

  • View_MarineSequences_Applicants
  • View_MarineSequences_Species
  • View_MarineSequences_Annotations

Download SQLite DB: MABPAT_dataset.db 110.6 MB

Powered by Datasette · Queries took 261.474ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT