api_results

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

13 rows where query_id = 87942

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
56447 56447 87942 87942 PubChem (compound) 1 118673 118673 2
115962 115962 87942 87942 PubChem (compound) 1 169335 169335 1
115963 115963 87942 87942 PubChem (compound) 1 24224 24224 3
334421 334421 87942 87942 PubChem (substance) 2 47697 47697 6
375538 375538 87942 87942 PubChem (substance) 2 118673 118673 2
375547 375547 87942 87942 PubChem (substance) 2 259796 259796 4
459353 459353 87942 87942 PubChem (substance) 2 169335 169335 1
459354 459354 87942 87942 PubChem (substance) 2 24224 24224 3
764241 764241 87942 87942 PubChem (substance) 2 265907 265907 5
764242 764242 87942 87942 PubChem (substance) 2 216268 216268 7
764243 764243 87942 87942 PubChem (substance) 2 259796 259796 8
764244 764244 87942 87942 PubChem (substance) 2 269886 269886 9
1022861 1022861 87942 87942 CAS Common Chemistry 3 24224 24224 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)
);