home / MABPAT_dataset

Applications_Sequences

Links patent applications to specific genetic sequences, enabling the tracking of which sequences are claimed in which patents.

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

Patent_application_number
Identifier for the patent application, referencing the Applications table. Searchable
Sequence_accession_number
Identifier for the genetic sequence as specified in INSDC databases, referencing the Sequences table. Searchable
ID
Unique identifier for each record (Primary Key)

12 rows where Patent_application_number = "WO2008075174A2"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • WO2008075174A2 · 12 ✖
ID ▼ Patent_application_number Sequence_accession_number
17346 WO2008075174A2 GM675616
17391 WO2008075174A2 GM675614
171355 WO2008075174A2 GM675596
171356 WO2008075174A2 GM675598
171357 WO2008075174A2 GM675600
171358 WO2008075174A2 GM675602
171359 WO2008075174A2 GM675604
171360 WO2008075174A2 GM675606
171361 WO2008075174A2 GM675608
171362 WO2008075174A2 GM675610
171363 WO2008075174A2 GM675612
171364 WO2008075174A2 GM675618

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE Applications_Sequences (
        Patent_application_number TEXT,
        Sequence_accession_number TEXT,
        ID INTEGER PRIMARY KEY,
        FOREIGN KEY (Patent_application_number) REFERENCES Applications (Patent_application_number),
        FOREIGN KEY (Sequence_accession_number) REFERENCES Sequences (Sequence_accession_number)
    );
Powered by Datasette · Queries took 763.735ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT