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)

23 rows where Patent_application_number = "WO2008102903A1"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • WO2008102903A1 · 23 ✖
ID ▼ Patent_application_number Sequence_accession_number
2788 WO2008102903A1 DM015786
2789 WO2008102903A1 DM015787
2790 WO2008102903A1 DM015788
2791 WO2008102903A1 DM015798
2792 WO2008102903A1 DM015799
2793 WO2008102903A1 DM015800
2794 WO2008102903A1 DM015801
97070 WO2008102903A1 DM015789
97071 WO2008102903A1 DM015790
97072 WO2008102903A1 DM015791
97073 WO2008102903A1 DM015806
97074 WO2008102903A1 DM015807
97075 WO2008102903A1 DM015808
97076 WO2008102903A1 DM015811
97077 WO2008102903A1 DM015812
97078 WO2008102903A1 DM015813
97079 WO2008102903A1 DM015820
97080 WO2008102903A1 DM015821
97081 WO2008102903A1 DM015822
97082 WO2008102903A1 DM015823
97083 WO2008102903A1 DM015824
97084 WO2008102903A1 DM015826
97085 WO2008102903A1 DM015827

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