home / zeropm-v0-0-4

api_results

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

30 rows where query_id = 163898

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
94236 94236 163898 163898 PubChem (compound) 1 130672 130672 1
428765 428765 163898 163898 PubChem (substance) 2 130672 130672 26
428770 428770 163898 163898 PubChem (substance) 2 130672 130672 1
428776 428776 163898 163898 PubChem (substance) 2 271142 271142 27
476819 476819 163898 163898 PubChem (substance) 2 228799 228799 6
477821 477821 163898 163898 PubChem (substance) 2 220679 220679 4
631875 631875 163898 163898 PubChem (substance) 2 215633 215633 3
652328 652328 163898 163898 PubChem (substance) 2 205758 205758 2
814187 814187 163898 163898 PubChem (substance) 2 248126 248126 5
814188 814188 163898 163898 PubChem (substance) 2 248231 248231 7
814189 814189 163898 163898 PubChem (substance) 2 248462 248462 8
814190 814190 163898 163898 PubChem (substance) 2 248118 248118 9
814191 814191 163898 163898 PubChem (substance) 2 248515 248515 10
814192 814192 163898 163898 PubChem (substance) 2 248457 248457 11
814193 814193 163898 163898 PubChem (substance) 2 248355 248355 12
814194 814194 163898 163898 PubChem (substance) 2 248271 248271 13
814195 814195 163898 163898 PubChem (substance) 2 248356 248356 14
814196 814196 163898 163898 PubChem (substance) 2 222256 222256 15
814197 814197 163898 163898 PubChem (substance) 2 228961 228961 16
814198 814198 163898 163898 PubChem (substance) 2 222253 222253 17
814199 814199 163898 163898 PubChem (substance) 2 248357 248357 18
814200 814200 163898 163898 PubChem (substance) 2 248406 248406 19
814201 814201 163898 163898 PubChem (substance) 2 248157 248157 20
814202 814202 163898 163898 PubChem (substance) 2 248358 248358 21
814203 814203 163898 163898 PubChem (substance) 2 248349 248349 22
814204 814204 163898 163898 PubChem (substance) 2 248272 248272 23
814205 814205 163898 163898 PubChem (substance) 2 248459 248459 24
814206 814206 163898 163898 PubChem (substance) 2 248460 248460 25
1072586 1072586 163898 163898 CAS Common Chemistry 3 25402 25402 1
1209951 1209951 163898 163898 Computational Toxicology and Exposure Data 4 130672 130672 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)
);
Powered by Datasette · Queries took 729.301ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website