Applications_Sequences

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)

1 row where Patent_application_number = "JP2015523088A" and Sequence_accession_number = "HZ390715"

✎ View and edit SQL

This data as json, CSV (advanced)

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)
    );