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)

8 rows where Patent_application_number = "WO2018235787A1"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • WO2018235787A1 · 8 ✖
ID ▼ Patent_application_number Sequence_accession_number
11273 WO2018235787A1 MA819075
36537 WO2018235787A1 MA819063
36538 WO2018235787A1 MA819076
36829 WO2018235787A1 MA819061
37405 WO2018235787A1 MA819062
37406 WO2018235787A1 MA819067
37407 WO2018235787A1 MA819068
86481 WO2018235787A1 MA819070

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