api_results

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

14 rows where query_id = 376191

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
269574 269574 376191 376191 PubChem (compound) 1 84547 84547 1
445937 445937 376191 376191 PubChem (substance) 2 137171 137171 10
509454 509454 376191 376191 PubChem (substance) 2 37980 37980 9
659247 659247 376191 376191 PubChem (substance) 2 84547 84547 1
919218 919218 376191 376191 PubChem (substance) 2 212339 212339 2
919219 919219 376191 376191 PubChem (substance) 2 241861 241861 3
919220 919220 376191 376191 PubChem (substance) 2 214392 214392 4
919221 919221 376191 376191 PubChem (substance) 2 220608 220608 5
919222 919222 376191 376191 PubChem (substance) 2 209788 209788 6
919223 919223 376191 376191 PubChem (substance) 2 234361 234361 7
919224 919224 376191 376191 PubChem (substance) 2 320452 320452 8
919225 919225 376191 376191 PubChem (substance) 2 309995 309995 11
1117983 1117983 376191 376191 CAS Common Chemistry 3 84547 84547 1
1329626 1329626 376191 376191 Computational Toxicology and Exposure Data 4 84547 84547 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)
);