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 = "WO2008157789A2"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • WO2008157789A2 · 18 ✖
ID ▼ Patent_application_number Sequence_accession_number
14776 WO2008157789A2 GN000422
20435 WO2008157789A2 GN000424
20436 WO2008157789A2 GN000426
34590 WO2008157789A2 GN000402
38422 WO2008157789A2 GN000392
42855 WO2008157789A2 GN000388
178053 WO2008157789A2 GN000384
178054 WO2008157789A2 GN000390
178055 WO2008157789A2 GN000394
178056 WO2008157789A2 GN000396
178057 WO2008157789A2 GN000398
178058 WO2008157789A2 GN000400
178059 WO2008157789A2 GN000404
178060 WO2008157789A2 GN000406
178061 WO2008157789A2 GN000408
178062 WO2008157789A2 GN000416
178063 WO2008157789A2 GN000418
178064 WO2008157789A2 GN000420

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