home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 117726

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
14191 14191 117726 117726 PubChem (compound) 1 74726 74726 1
315640 315640 117726 117726 PubChem (substance) 2 74726 74726 1
315650 315650 117726 117726 PubChem (substance) 2 119826 119826 5
329666 329666 117726 117726 PubChem (substance) 2 77511 77511 2
345064 345064 117726 117726 PubChem (substance) 2 10940 10940 3
348954 348954 117726 117726 PubChem (substance) 2 45397 45397 8
354535 354535 117726 117726 PubChem (substance) 2 59100 59100 14
356556 356556 117726 117726 PubChem (substance) 2 84934 84934 12
452392 452392 117726 117726 PubChem (substance) 2 215683 215683 9
464889 464889 117726 117726 PubChem (substance) 2 107364 107364 10
473791 473791 117726 117726 PubChem (substance) 2 83463 83463 11
487229 487229 117726 117726 PubChem (substance) 2 185589 185589 16
671808 671808 117726 117726 PubChem (substance) 2 202589 202589 13
673372 673372 117726 117726 PubChem (substance) 2 1176 1176 7
734104 734104 117726 117726 PubChem (substance) 2 228475 228475 6
783212 783212 117726 117726 PubChem (substance) 2 169411 169411 4
783213 783213 117726 117726 PubChem (substance) 2 322962 322962 15
948751 948751 117726 117726 CAS Common Chemistry 3 74726 74726 6
948845 948845 117726 117726 CAS Common Chemistry 3 76701 76701 7
949415 949415 117726 117726 CAS Common Chemistry 3 69416 69416 5
951194 951194 117726 117726 CAS Common Chemistry 3 58716 58716 3
972327 972327 117726 117726 CAS Common Chemistry 3 19054 19054 1
1147305 1147305 117726 117726 Computational Toxicology and Exposure Data 4 74726 74726 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 1239.334ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website