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)

22 rows where Patent_application_number = "EP2970942A1"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • EP2970942A1 · 22 ✖
ID ▼ Patent_application_number Sequence_accession_number
23772 EP2970942A1 LQ006043
76035 EP2970942A1 LQ006030
76036 EP2970942A1 LQ006031
76037 EP2970942A1 LQ006032
76038 EP2970942A1 LQ006033
76039 EP2970942A1 LQ006036
76040 EP2970942A1 LQ006037
76041 EP2970942A1 LQ006038
76042 EP2970942A1 LQ006039
76043 EP2970942A1 LQ006040
76044 EP2970942A1 LQ006044
76045 EP2970942A1 LQ006045
76046 EP2970942A1 LQ006046
76047 EP2970942A1 LQ006047
76048 EP2970942A1 LQ006048
76049 EP2970942A1 LQ006049
76050 EP2970942A1 LQ006050
76051 EP2970942A1 LQ006051
76052 EP2970942A1 LQ006052
76053 EP2970942A1 LQ006053
76054 EP2970942A1 LQ006054
76055 EP2970942A1 LQ006068

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