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)

19 rows where Patent_application_number = "WO2017203827A1"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • WO2017203827A1 · 19 ✖
ID ▼ Patent_application_number Sequence_accession_number
29068 WO2017203827A1 LZ983289
29580 WO2017203827A1 LZ983250
29581 WO2017203827A1 LZ983259
29582 WO2017203827A1 LZ983268
29583 WO2017203827A1 LZ983269
29584 WO2017203827A1 LZ983275
29585 WO2017203827A1 LZ983276
29586 WO2017203827A1 LZ983284
29587 WO2017203827A1 LZ983290
29588 WO2017203827A1 LZ983291
29589 WO2017203827A1 LZ983292
29590 WO2017203827A1 LZ983293
29591 WO2017203827A1 LZ983294
29592 WO2017203827A1 LZ983295
29860 WO2017203827A1 LZ983252
29861 WO2017203827A1 LZ983287
29944 WO2017203827A1 LZ983288
85557 WO2017203827A1 LZ983285
85558 WO2017203827A1 LZ983286

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