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)

13 rows where Patent_application_number = "WO2002022831A1"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • WO2002022831A1 · 13 ✖
ID ▼ Patent_application_number Sequence_accession_number
1416 WO2002022831A1 BD142767
2383 WO2002022831A1 BD142747
2384 WO2002022831A1 BD142750
3568 WO2002022831A1 BD142735
3569 WO2002022831A1 BD142743
3570 WO2002022831A1 BD142746
10359 WO2002022831A1 BD142738
10575 WO2002022831A1 BD142755
10576 WO2002022831A1 BD142758
10625 WO2002022831A1 BD142763
10626 WO2002022831A1 BD142766
191243 WO2002022831A1 BD142726
191244 WO2002022831A1 BD142733

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