home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 104061

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
4400 4400 104061 104061 PubChem (compound) 1 63056 63056 1
301691 301691 104061 104061 PubChem (substance) 2 63056 63056 1
431732 431732 104061 104061 PubChem (substance) 2 33625 33625 17
446215 446215 104061 104061 PubChem (substance) 2 23718 23718 3
455810 455810 104061 104061 PubChem (substance) 2 46225 46225 6
651383 651383 104061 104061 PubChem (substance) 2 136269 136269 9
658123 658123 104061 104061 PubChem (substance) 2 185872 185872 12
695765 695765 104061 104061 PubChem (substance) 2 136811 136811 5
695778 695778 104061 104061 PubChem (substance) 2 137660 137660 4
695791 695791 104061 104061 PubChem (substance) 2 186844 186844 8
695801 695801 104061 104061 PubChem (substance) 2 284000 284000 13
695824 695824 104061 104061 PubChem (substance) 2 227367 227367 10
695828 695828 104061 104061 PubChem (substance) 2 270864 270864 11
695830 695830 104061 104061 PubChem (substance) 2 203058 203058 2
695846 695846 104061 104061 PubChem (substance) 2 271988 271988 16
695852 695852 104061 104061 PubChem (substance) 2 192459 192459 7
695945 695945 104061 104061 PubChem (substance) 2 310732 310732 14
695947 695947 104061 104061 PubChem (substance) 2 232876 232876 15
941361 941361 104061 104061 CAS Common Chemistry 3 63056 63056 1
1138634 1138634 104061 104061 Computational Toxicology and Exposure Data 4 63056 63056 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 963.011ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website