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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
14140 14140 27586 27586 PubChem (compound) 1 75177 75177 1
315564 315564 27586 27586 PubChem (substance) 2 75177 75177 1
380750 380750 27586 27586 PubChem (substance) 2 75665 75665 17
382389 382389 27586 27586 PubChem (substance) 2 274 274 12
383619 383619 27586 27586 PubChem (substance) 2 123602 123602 5
440288 440288 27586 27586 PubChem (substance) 2 241343 241343 13
444913 444913 27586 27586 PubChem (substance) 2 7710 7710 9
450988 450988 27586 27586 PubChem (substance) 2 77231 77231 11
457034 457034 27586 27586 PubChem (substance) 2 12920 12920 3
496271 496271 27586 27586 PubChem (substance) 2 192032 192032 14
570020 570020 27586 27586 PubChem (substance) 2 168956 168956 18
702572 702572 27586 27586 PubChem (substance) 2 75177 75177 2
727195 727195 27586 27586 PubChem (substance) 2 186046 186046 4
727198 727198 27586 27586 PubChem (substance) 2 188379 188379 6
727201 727201 27586 27586 PubChem (substance) 2 188380 188380 7
727204 727204 27586 27586 PubChem (substance) 2 284659 284659 8
727207 727207 27586 27586 PubChem (substance) 2 139279 139279 10
727210 727210 27586 27586 PubChem (substance) 2 140716 140716 15
727213 727213 27586 27586 PubChem (substance) 2 233012 233012 16
948705 948705 27586 27586 CAS Common Chemistry 3 75177 75177 1
1147262 1147262 27586 27586 Computational Toxicology and Exposure Data 4 75177 75177 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 1315.165ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website