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)

18 rows where Patent_application_number = "WO2004064987A2"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • WO2004064987A2 · 18 ✖
ID ▼ Patent_application_number Sequence_accession_number
12765 WO2004064987A2 CQ924759
12766 WO2004064987A2 CQ924780
12767 WO2004064987A2 CQ924801
50085 WO2004064987A2 CQ924758
50086 WO2004064987A2 CQ924760
50087 WO2004064987A2 CQ924761
50088 WO2004064987A2 CQ924762
50089 WO2004064987A2 CQ924764
50090 WO2004064987A2 CQ924766
50091 WO2004064987A2 CQ924768
50092 WO2004064987A2 CQ924770
50093 WO2004064987A2 CQ924772
50094 WO2004064987A2 CQ924774
50095 WO2004064987A2 CQ924776
50096 WO2004064987A2 CQ924778
50097 WO2004064987A2 CQ924799
50098 WO2004064987A2 CQ924800
50099 WO2004064987A2 CQ924803

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 418.174ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT