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)

34 rows where Patent_application_number = "EP2992103A2"

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number 1

  • EP2992103A2 · 34 ✖
ID ▼ Patent_application_number Sequence_accession_number
14962 EP2992103A2 LQ310213
14963 EP2992103A2 LQ310214
15203 EP2992103A2 LQ310245
20752 EP2992103A2 LQ310251
29362 EP2992103A2 LQ310219
29363 EP2992103A2 LQ310220
30498 EP2992103A2 LQ310225
30499 EP2992103A2 LQ310226
33205 EP2992103A2 LQ310222
33206 EP2992103A2 LQ310223
77242 EP2992103A2 LQ310211
77243 EP2992103A2 LQ310216
77244 EP2992103A2 LQ310217
77245 EP2992103A2 LQ310228
77246 EP2992103A2 LQ310229
77247 EP2992103A2 LQ310231
77248 EP2992103A2 LQ310233
77249 EP2992103A2 LQ310235
77250 EP2992103A2 LQ310237
77251 EP2992103A2 LQ310239
77252 EP2992103A2 LQ310241
77253 EP2992103A2 LQ310243
77254 EP2992103A2 LQ310247
77255 EP2992103A2 LQ310249
77256 EP2992103A2 LQ310253
77257 EP2992103A2 LQ310255
77258 EP2992103A2 LQ310257
77259 EP2992103A2 LQ310259
77260 EP2992103A2 LQ310261
77261 EP2992103A2 LQ310262
77262 EP2992103A2 LQ310264
77263 EP2992103A2 LQ310266
77264 EP2992103A2 LQ310278
77265 EP2992103A2 LQ310279

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