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)

22 rows where Patent_application_number = "JP2019151579A"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • JP2019151579A · 22 ✖
ID ▼ Patent_application_number Sequence_accession_number
38794 JP2019151579A MB420783
38795 JP2019151579A MB420784
38796 JP2019151579A MB420785
38797 JP2019151579A MB420786
38798 JP2019151579A MB420787
38799 JP2019151579A MB420788
38800 JP2019151579A MB420789
38801 JP2019151579A MB420790
38802 JP2019151579A MB420791
38803 JP2019151579A MB420792
38804 JP2019151579A MB420793
38805 JP2019151579A MB420794
38806 JP2019151579A MB420795
38807 JP2019151579A MB420796
38808 JP2019151579A MB420797
38809 JP2019151579A MB420798
38810 JP2019151579A MB420799
38811 JP2019151579A MB420800
38812 JP2019151579A MB420801
38813 JP2019151579A MB420802
38814 JP2019151579A MB420803
38815 JP2019151579A MB420804

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