home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 88161

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
47411 47411 88161 88161 PubChem (compound) 1 119324 119324 1
116071 116071 88161 88161 PubChem (compound) 1 138441 138441 2
116072 116072 88161 88161 PubChem (compound) 1 119324 119324 3
116073 116073 88161 88161 PubChem (compound) 1 314191 314191 4
116074 116074 88161 88161 PubChem (compound) 1 314934 314934 5
116075 116075 88161 88161 PubChem (compound) 1 119324 119324 6
363246 363246 88161 88161 PubChem (substance) 2 134011 134011 3
363295 363295 88161 88161 PubChem (substance) 2 119324 119324 1
459517 459517 88161 88161 PubChem (substance) 2 138441 138441 2
459519 459519 88161 88161 PubChem (substance) 2 119324 119324 6
459522 459522 88161 88161 PubChem (substance) 2 314191 314191 4
459526 459526 88161 88161 PubChem (substance) 2 314934 314934 7
459528 459528 88161 88161 PubChem (substance) 2 119324 119324 8
470542 470542 88161 88161 PubChem (substance) 2 314778 314778 5
537999 537999 88161 88161 PubChem (substance) 2 141347 141347 9
673833 673833 88161 88161 PubChem (substance) 2 20190 20190 11
722428 722428 88161 88161 PubChem (substance) 2 36256 36256 10
972535 972535 88161 88161 CAS Common Chemistry 3 20188 20188 1
1175207 1175207 88161 88161 Computational Toxicology and Exposure Data 4 119324 119324 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 428.876ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website