home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 310131

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102199 102199 310131 310131 PubChem (compound) 1 47088 47088 1
440352 440352 310131 310131 PubChem (substance) 2 45291 45291 6
440368 440368 310131 310131 PubChem (substance) 2 47088 47088 1
651825 651825 310131 310131 PubChem (substance) 2 173854 173854 5
752165 752165 310131 310131 PubChem (substance) 2 210657 210657 3
752168 752168 310131 310131 PubChem (substance) 2 137376 137376 2
752170 752170 310131 310131 PubChem (substance) 2 255515 255515 17
752173 752173 310131 310131 PubChem (substance) 2 247481 247481 19
752175 752175 310131 310131 PubChem (substance) 2 294562 294562 20
752178 752178 310131 310131 PubChem (substance) 2 189151 189151 4
771306 771306 310131 310131 PubChem (substance) 2 284041 284041 16
771309 771309 310131 310131 PubChem (substance) 2 154321 154321 18
776036 776036 310131 310131 PubChem (substance) 2 232160 232160 8
847258 847258 310131 310131 PubChem (substance) 2 232121 232121 7
847260 847260 310131 310131 PubChem (substance) 2 232197 232197 9
847261 847261 310131 310131 PubChem (substance) 2 206750 206750 10
847262 847262 310131 310131 PubChem (substance) 2 206751 206751 11
847263 847263 310131 310131 PubChem (substance) 2 206752 206752 12
847264 847264 310131 310131 PubChem (substance) 2 206753 206753 13
847265 847265 310131 310131 PubChem (substance) 2 232322 232322 14
847266 847266 310131 310131 PubChem (substance) 2 176257 176257 15
1013413 1013413 310131 310131 CAS Common Chemistry 3 47088 47088 1
1215541 1215541 310131 310131 Computational Toxicology and Exposure Data 4 47088 47088 1
1234164 1234164 310131 310131 Computational Toxicology and Exposure Data 4 7154 7154 2
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 1253.107ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website