home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 182132

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
200278 200278 182132 182132 PubChem (compound) 1 287417 287417 1
571090 571090 182132 182132 PubChem (substance) 2 287417 287417 3
753507 753507 182132 182132 PubChem (substance) 2 258654 258654 1
824145 824145 182132 182132 PubChem (substance) 2 327219 327219 2
824147 824147 182132 182132 PubChem (substance) 2 317079 317079 4
824149 824149 182132 182132 PubChem (substance) 2 238987 238987 6
824151 824151 182132 182132 PubChem (substance) 2 326701 326701 7
824153 824153 182132 182132 PubChem (substance) 2 241891 241891 9
824154 824154 182132 182132 PubChem (substance) 2 191858 191858 10
824159 824159 182132 182132 PubChem (substance) 2 308454 308454 12
824163 824163 182132 182132 PubChem (substance) 2 217545 217545 13
824165 824165 182132 182132 PubChem (substance) 2 329555 329555 15
824169 824169 182132 182132 PubChem (substance) 2 317858 317858 17
824170 824170 182132 182132 PubChem (substance) 2 191858 191858 5
824171 824171 182132 182132 PubChem (substance) 2 217475 217475 8
824172 824172 182132 182132 PubChem (substance) 2 263250 263250 11
824173 824173 182132 182132 PubChem (substance) 2 308841 308841 14
824174 824174 182132 182132 PubChem (substance) 2 262051 262051 16
1084125 1084125 182132 182132 CAS Common Chemistry 3 49503 49503 1
1285746 1285746 182132 182132 Computational Toxicology and Exposure Data 4 98108 98108 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 1898.267ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website