home / zeropm-v0-0-4

api_results

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

21 rows where query_id = 133768

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
153837 153837 133768 133768 PubChem (compound) 1 39635 39635 1
153839 153839 133768 133768 PubChem (compound) 1 137313 137313 2
153841 153841 133768 133768 PubChem (compound) 1 221614 221614 3
153843 153843 133768 133768 PubChem (compound) 1 110574 110574 4
153846 153846 133768 133768 PubChem (compound) 1 328598 328598 5
510274 510274 133768 133768 PubChem (substance) 2 39635 39635 1
510275 510275 133768 133768 PubChem (substance) 2 137313 137313 2
510278 510278 133768 133768 PubChem (substance) 2 221614 221614 3
510280 510280 133768 133768 PubChem (substance) 2 110574 110574 4
510282 510282 133768 133768 PubChem (substance) 2 328598 328598 6
510284 510284 133768 133768 PubChem (substance) 2 138667 138667 5
794394 794394 133768 133768 PubChem (substance) 2 233059 233059 7
794395 794395 133768 133768 PubChem (substance) 2 167225 167225 8
794396 794396 133768 133768 PubChem (substance) 2 287998 287998 9
794399 794399 133768 133768 PubChem (substance) 2 297204 297204 10
794400 794400 133768 133768 PubChem (substance) 2 326468 326468 11
794402 794402 133768 133768 PubChem (substance) 2 249022 249022 12
794404 794404 133768 133768 PubChem (substance) 2 343747 343747 13
794406 794406 133768 133768 PubChem (substance) 2 344135 344135 14
1050590 1050590 133768 133768 CAS Common Chemistry 3 39635 39635 1
1253355 1253355 133768 133768 Computational Toxicology and Exposure Data 4 110574 110574 1
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 466.755ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website