api_results

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

18 rows where query_id = 172441

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
191076 191076 172441 172441 PubChem (compound) 1 230178 230178 1
191077 191077 172441 172441 PubChem (compound) 1 230178 230178 2
191078 191078 172441 172441 PubChem (compound) 1 35864 35864 3
191079 191079 172441 172441 PubChem (compound) 1 207082 207082 4
191080 191080 172441 172441 PubChem (compound) 1 274842 274842 5
191082 191082 172441 172441 PubChem (compound) 1 329565 329565 6
343515 343515 172441 172441 PubChem (substance) 2 7167 7167 10
559351 559351 172441 172441 PubChem (substance) 2 230178 230178 1
559352 559352 172441 172441 PubChem (substance) 2 230178 230178 2
559356 559356 172441 172441 PubChem (substance) 2 35864 35864 3
559357 559357 172441 172441 PubChem (substance) 2 207082 207082 6
559359 559359 172441 172441 PubChem (substance) 2 274842 274842 5
559361 559361 172441 172441 PubChem (substance) 2 329565 329565 9
819140 819140 172441 172441 PubChem (substance) 2 310138 310138 4
819141 819141 172441 172441 PubChem (substance) 2 157793 157793 7
819142 819142 172441 172441 PubChem (substance) 2 292682 292682 8
1077775 1077775 172441 172441 CAS Common Chemistry 3 35864 35864 1
1279186 1279186 172441 172441 Computational Toxicology and Exposure Data 4 126915 126915 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)
);