api_results

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

16 rows where query_id = 105111

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22026 22026 105111 105111 PubChem (compound) 1 57316 57316 1
125093 125093 105111 105111 PubChem (compound) 1 6759 6759 2
125094 125094 105111 105111 PubChem (compound) 1 6759 6759 3
125097 125097 105111 105111 PubChem (compound) 1 249874 249874 4
125100 125100 105111 105111 PubChem (compound) 1 24790 24790 5
305237 305237 105111 105111 PubChem (substance) 2 55037 55037 5
327239 327239 105111 105111 PubChem (substance) 2 57316 57316 1
472243 472243 105111 105111 PubChem (substance) 2 6759 6759 3
472249 472249 105111 105111 PubChem (substance) 2 6759 6759 2
472252 472252 105111 105111 PubChem (substance) 2 249874 249874 4
472261 472261 105111 105111 PubChem (substance) 2 24790 24790 9
655746 655746 105111 105111 PubChem (substance) 2 266466 266466 8
708117 708117 105111 105111 PubChem (substance) 2 57316 57316 6
708126 708126 105111 105111 PubChem (substance) 2 168850 168850 7
954446 954446 105111 105111 CAS Common Chemistry 3 57316 57316 1
1154075 1154075 105111 105111 Computational Toxicology and Exposure Data 4 57316 57316 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)
);