home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 53483

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
91598 91598 53483 53483 PubChem (compound) 1 173832 173832 1
91602 91602 53483 53483 PubChem (compound) 1 215237 215237 2
91604 91604 53483 53483 PubChem (compound) 1 267494 267494 3
91606 91606 53483 53483 PubChem (compound) 1 281432 281432 4
91608 91608 53483 53483 PubChem (compound) 1 309422 309422 5
425246 425246 53483 53483 PubChem (substance) 2 173832 173832 1
425252 425252 53483 53483 PubChem (substance) 2 215237 215237 3
425254 425254 53483 53483 PubChem (substance) 2 267494 267494 4
425256 425256 53483 53483 PubChem (substance) 2 281432 281432 6
425258 425258 53483 53483 PubChem (substance) 2 309422 309422 10
643376 643376 53483 53483 PubChem (substance) 2 66879 66879 7
643382 643382 53483 53483 PubChem (substance) 2 308364 308364 9
744361 744361 53483 53483 PubChem (substance) 2 277341 277341 2
744363 744363 53483 53483 PubChem (substance) 2 332589 332589 5
744365 744365 53483 53483 PubChem (substance) 2 274462 274462 8
744366 744366 53483 53483 PubChem (substance) 2 326589 326589 11
744368 744368 53483 53483 PubChem (substance) 2 330202 330202 12
1006042 1006042 53483 53483 CAS Common Chemistry 3 66879 66879 1
1207934 1207934 53483 53483 Computational Toxicology and Exposure Data 4 114206 114206 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 1029.171ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website