api_results

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

14 rows where query_id = 62882

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
103248 103248 62882 62882 PubChem (compound) 1 54006 54006 1
441896 441896 62882 62882 PubChem (substance) 2 54006 54006 1
441898 441898 62882 62882 PubChem (substance) 2 159947 159947 2
473736 473736 62882 62882 PubChem (substance) 2 83168 83168 11
753454 753454 62882 62882 PubChem (substance) 2 259209 259209 3
753456 753456 62882 62882 PubChem (substance) 2 239268 239268 4
753458 753458 62882 62882 PubChem (substance) 2 174738 174738 5
753460 753460 62882 62882 PubChem (substance) 2 198244 198244 6
753461 753461 62882 62882 PubChem (substance) 2 262639 262639 7
753463 753463 62882 62882 PubChem (substance) 2 177874 177874 8
753465 753465 62882 62882 PubChem (substance) 2 196127 196127 9
753466 753466 62882 62882 PubChem (substance) 2 224444 224444 10
1014123 1014123 62882 62882 CAS Common Chemistry 3 54006 54006 1
1216261 1216261 62882 62882 Computational Toxicology and Exposure Data 4 54006 54006 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)
);