api_results

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

16 rows where query_id = 11497

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
327844 327844 11497 11497 PubChem (substance) 2 136302 136302 5
327895 327895 11497 11497 PubChem (substance) 2 167483 167483 7
375359 375359 11497 11497 PubChem (substance) 2 54960 54960 11
436546 436546 11497 11497 PubChem (substance) 2 58691 58691 1
442116 442116 11497 11497 PubChem (substance) 2 12546 12546 4
442289 442289 11497 11497 PubChem (substance) 2 54700 54700 3
708154 708154 11497 11497 PubChem (substance) 2 169131 169131 2
708158 708158 11497 11497 PubChem (substance) 2 332651 332651 6
708162 708162 11497 11497 PubChem (substance) 2 260936 260936 8
708163 708163 11497 11497 PubChem (substance) 2 170612 170612 9
708166 708166 11497 11497 PubChem (substance) 2 235027 235027 10
708170 708170 11497 11497 PubChem (substance) 2 292834 292834 12
708171 708171 11497 11497 PubChem (substance) 2 310232 310232 13
708172 708172 11497 11497 PubChem (substance) 2 241459 241459 14
954497 954497 11497 11497 CAS Common Chemistry 3 58691 58691 1
1154146 1154146 11497 11497 Computational Toxicology and Exposure Data 4 54700 54700 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)
);