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)

15 rows where Patent_application_number = "JP2018134085A"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • JP2018134085A · 15 ✖
ID ▼ Patent_application_number Sequence_accession_number
16281 JP2018134085A MB443475
16282 JP2018134085A MB443476
16283 JP2018134085A MB443479
30108 JP2018134085A MB443473
30109 JP2018134085A MB443474
30110 JP2018134085A MB443480
89807 JP2018134085A MB443448
89808 JP2018134085A MB443477
89809 JP2018134085A MB443478
89810 JP2018134085A MB443481
89811 JP2018134085A MB443482
89812 JP2018134085A MB443483
89813 JP2018134085A MB443484
89814 JP2018134085A MB443485
89815 JP2018134085A MB443486

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