api_results

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

17 rows where query_id = 84859

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
114318 114318 84859 84859 PubChem (compound) 1 54002 54002 1
396430 396430 84859 84859 PubChem (substance) 2 27174 27174 4
456916 456916 84859 84859 PubChem (substance) 2 54002 54002 1
456924 456924 84859 84859 PubChem (substance) 2 43997 43997 7
673779 673779 84859 84859 PubChem (substance) 2 139450 139450 3
697813 697813 84859 84859 PubChem (substance) 2 136409 136409 2
727219 727219 84859 84859 PubChem (substance) 2 233012 233012 11
734154 734154 84859 84859 PubChem (substance) 2 235026 235026 6
734161 734161 84859 84859 PubChem (substance) 2 243348 243348 10
734190 734190 84859 84859 PubChem (substance) 2 217312 217312 9
734223 734223 84859 84859 PubChem (substance) 2 310258 310258 12
762577 762577 84859 84859 PubChem (substance) 2 186104 186104 5
762578 762578 84859 84859 PubChem (substance) 2 261509 261509 8
762580 762580 84859 84859 PubChem (substance) 2 242192 242192 13
762582 762582 84859 84859 PubChem (substance) 2 217181 217181 14
1021689 1021689 84859 84859 CAS Common Chemistry 3 54002 54002 1
1224107 1224107 84859 84859 Computational Toxicology and Exposure Data 4 54002 54002 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)
);