api_results

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

11 rows where query_id = 162246

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
181521 181521 162246 162246 PubChem (compound) 1 23429 23429 1
311379 311379 162246 162246 PubChem (substance) 2 73281 73281 2
536036 536036 162246 162246 PubChem (substance) 2 126710 126710 5
546679 546679 162246 162246 PubChem (substance) 2 23429 23429 1
652167 652167 162246 162246 PubChem (substance) 2 93123 93123 4
708830 708830 162246 162246 PubChem (substance) 2 169847 169847 7
708834 708834 162246 162246 PubChem (substance) 2 154056 154056 3
807908 807908 162246 162246 PubChem (substance) 2 122237 122237 6
813239 813239 162246 162246 PubChem (substance) 2 204157 204157 8
813240 813240 162246 162246 PubChem (substance) 2 206504 206504 9
813241 813241 162246 162246 PubChem (substance) 2 206511 206511 10 
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)
);