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)

14 rows where Patent_application_number = "WO2007061845A2"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • WO2007061845A2 · 14 ✖
ID ▼ Patent_application_number Sequence_accession_number
14019 WO2007061845A2 CS646774
23891 WO2007061845A2 CS646856
23892 WO2007061845A2 CS646864
23893 WO2007061845A2 CS646866
23894 WO2007061845A2 CS646869
23895 WO2007061845A2 CS646870
23896 WO2007061845A2 CS646871
23897 WO2007061845A2 CS646874
70153 WO2007061845A2 CS646746
70154 WO2007061845A2 CS646747
70155 WO2007061845A2 CS646748
70156 WO2007061845A2 CS646749
70157 WO2007061845A2 CS646761
70158 WO2007061845A2 CS646833

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