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 = 143025

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21600 21600 143025 143025 PubChem (compound) 1 51341 51341 1
326480 326480 143025 143025 PubChem (substance) 2 51341 51341 1
326497 326497 143025 143025 PubChem (substance) 2 27338 27338 8
522385 522385 143025 143025 PubChem (substance) 2 67483 67483 2
669499 669499 143025 143025 PubChem (substance) 2 54637 54637 3
707282 707282 143025 143025 PubChem (substance) 2 51341 51341 4
707290 707290 143025 143025 PubChem (substance) 2 206404 206404 6
759540 759540 143025 143025 PubChem (substance) 2 217094 217094 12
771856 771856 143025 143025 PubChem (substance) 2 169502 169502 11
800571 800571 143025 143025 PubChem (substance) 2 205880 205880 5
800573 800573 143025 143025 PubChem (substance) 2 198572 198572 7
800576 800576 143025 143025 PubChem (substance) 2 169781 169781 9
800577 800577 143025 143025 PubChem (substance) 2 188325 188325 10
800579 800579 143025 143025 PubChem (substance) 2 330427 330427 13
800582 800582 143025 143025 PubChem (substance) 2 227653 227653 14
954147 954147 143025 143025 CAS Common Chemistry 3 51341 51341 1
1057524 1057524 143025 143025 CAS Common Chemistry 3 67483 67483 2
1153663 1153663 143025 143025 Computational Toxicology and Exposure Data 4 51341 51341 1
1260118 1260118 143025 143025 Computational Toxicology and Exposure Data 4 97926 97926 2
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 1194.874ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website