home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 89003

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
36681 36681 89003 89003 PubChem (compound) 1 44058 44058 1
36685 36685 89003 89003 PubChem (compound) 1 136957 136957 2
116561 116561 89003 89003 PubChem (compound) 1 200128 200128 3
116563 116563 89003 89003 PubChem (compound) 1 12197 12197 4
116565 116565 89003 89003 PubChem (compound) 1 208092 208092 5
116566 116566 89003 89003 PubChem (compound) 1 219140 219140 6
116567 116567 89003 89003 PubChem (compound) 1 257451 257451 7
116568 116568 89003 89003 PubChem (compound) 1 308223 308223 8
348120 348120 89003 89003 PubChem (substance) 2 44058 44058 1
348129 348129 89003 89003 PubChem (substance) 2 136957 136957 2
360110 360110 89003 89003 PubChem (substance) 2 11091 11091 4
460195 460195 89003 89003 PubChem (substance) 2 200128 200128 3
460200 460200 89003 89003 PubChem (substance) 2 12197 12197 5
460208 460208 89003 89003 PubChem (substance) 2 208092 208092 6
460211 460211 89003 89003 PubChem (substance) 2 219140 219140 10
460214 460214 89003 89003 PubChem (substance) 2 257451 257451 9
460215 460215 89003 89003 PubChem (substance) 2 308223 308223 11
715373 715373 89003 89003 PubChem (substance) 2 189214 189214 8
715377 715377 89003 89003 PubChem (substance) 2 195842 195842 12
764625 764625 89003 89003 PubChem (substance) 2 274012 274012 7
964934 964934 89003 89003 CAS Common Chemistry 3 44058 44058 1
1166592 1166592 89003 89003 Computational Toxicology and Exposure Data 4 44058 44058 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 419.41ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website