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)

where Patent_application_number = "WO2017022587A1"

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Patent_application_number

ID ▼ Patent_application_number Sequence_accession_number
29060 WO2017022587A1 LV571732
29492 WO2017022587A1 LV571682
29493 WO2017022587A1 LV571696
29494 WO2017022587A1 LV571713
29495 WO2017022587A1 LV571718
29496 WO2017022587A1 LV571727
29497 WO2017022587A1 LV571728
29843 WO2017022587A1 LV571730
29936 WO2017022587A1 LV571731
83194 WO2017022587A1 LV571687
83195 WO2017022587A1 LV571729

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