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)

19 rows where Patent_application_number = "JP2017209064A"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • JP2017209064A · 19 ✖
ID ▼ Patent_application_number Sequence_accession_number
29067 JP2017209064A LZ952040
29567 JP2017209064A LZ952001
29568 JP2017209064A LZ952010
29569 JP2017209064A LZ952019
29570 JP2017209064A LZ952020
29571 JP2017209064A LZ952026
29572 JP2017209064A LZ952027
29573 JP2017209064A LZ952035
29574 JP2017209064A LZ952041
29575 JP2017209064A LZ952042
29576 JP2017209064A LZ952043
29577 JP2017209064A LZ952044
29578 JP2017209064A LZ952045
29579 JP2017209064A LZ952046
29858 JP2017209064A LZ952003
29859 JP2017209064A LZ952038
29943 JP2017209064A LZ952039
85524 JP2017209064A LZ952036
85525 JP2017209064A LZ952037

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