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

Applicants_fts (hidden)

Applicant_name, Applicants_fts, rank

1,326 rows

Applicants_fts_config (hidden)

k, v

1 row

Applicants_fts_data (hidden)

id, block

12 rows

Applicants_fts_docsize (hidden)

id, sz

1,326 rows

Applicants_fts_idx (hidden)

segid, term, pgno

10 rows

Applications_Sequences_fts (hidden)

Patent_application_number, Sequence_accession_number, Applications_Sequences_fts, rank

557,532 rows

Applications_Sequences_fts_config (hidden)

k, v

1 row

Applications_Sequences_fts_data (hidden)

id, block

2,028 rows

Applications_Sequences_fts_docsize (hidden)

id, sz

557,532 rows

Applications_Sequences_fts_idx (hidden)

segid, term, pgno

2,161 rows

Applications_fts (hidden)

Patent_application_number, Applicant_name, Applications_fts, rank

4,779 rows

Applications_fts_config (hidden)

k, v

1 row

Applications_fts_data (hidden)

id, block

39 rows

Applications_fts_docsize (hidden)

id, sz

4,779 rows

Applications_fts_idx (hidden)

segid, term, pgno

37 rows

Marine_Sequences_Protein_Annotations_fts (hidden)

Sequence_accession_number, Marine_Sequences_Protein_Annotations_fts, rank

71,149 rows

Marine_Sequences_Protein_Annotations_fts_config (hidden)

k, v

1 row

Marine_Sequences_Protein_Annotations_fts_data (hidden)

id, block

174 rows

Marine_Sequences_Protein_Annotations_fts_docsize (hidden)

id, sz

71,149 rows

Marine_Sequences_Protein_Annotations_fts_idx (hidden)

segid, term, pgno

172 rows

Marine_Sequences_fts (hidden)

Sequence_accession_number, Species_name, Marine_Sequences_fts, rank

104,467 rows

Marine_Sequences_fts_config (hidden)

k, v

1 row

Marine_Sequences_fts_data (hidden)

id, block

632 rows

Marine_Sequences_fts_docsize (hidden)

id, sz

104,467 rows

Marine_Sequences_fts_idx (hidden)

segid, term, pgno

509 rows

Marine_Species_fts (hidden)

Species_name, Marine_Species_fts, rank

1,639 rows

Marine_Species_fts_config (hidden)

k, v

1 row

Marine_Species_fts_data (hidden)

id, block

23 rows

Marine_Species_fts_docsize (hidden)

id, sz

1,639 rows

Marine_Species_fts_idx (hidden)

segid, term, pgno

21 rows

Sequences_fts (hidden)

Sequence_accession_number, Species_name, Sequences_fts, rank

557,484 rows

Sequences_fts_config (hidden)

k, v

1 row

Sequences_fts_data (hidden)

id, block

3,127 rows

Sequences_fts_docsize (hidden)

id, sz

557,484 rows

Sequences_fts_idx (hidden)

segid, term, pgno

2,208 rows

Views

  • View_MarineSequences_Applicants
  • View_MarineSequences_Species
  • View_MarineSequences_Annotations

Download SQLite DB: MABPAT_dataset.db 110.6 MB

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