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)

8 rows where Patent_application_number = "JP2017514789A"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • JP2017514789A · 8 ✖
ID ▼ Patent_application_number Sequence_accession_number
15211 JP2017514789A LZ101017
20755 JP2017514789A LZ101022
84715 JP2017514789A LZ101015
84716 JP2017514789A LZ101018
84717 JP2017514789A LZ101019
84718 JP2017514789A LZ101020
84719 JP2017514789A LZ101021
84720 JP2017514789A LZ101035

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