api_results

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

12 rows where query_id = 435509

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124426 124426 435509 435509 PubChem (compound) 1 45280 45280 1
471185 471185 435509 435509 PubChem (substance) 2 45280 45280 1
770893 770893 435509 435509 PubChem (substance) 2 167977 167977 2
770895 770895 435509 435509 PubChem (substance) 2 137230 137230 6
770899 770899 435509 435509 PubChem (substance) 2 189080 189080 3
770902 770902 435509 435509 PubChem (substance) 2 237185 237185 9
770904 770904 435509 435509 PubChem (substance) 2 165819 165819 4
770907 770907 435509 435509 PubChem (substance) 2 159161 159161 5
937461 937461 435509 435509 PubChem (substance) 2 340362 340362 7
937462 937462 435509 435509 PubChem (substance) 2 254661 254661 8
1028324 1028324 435509 435509 CAS Common Chemistry 3 45280 45280 1
1231106 1231106 435509 435509 Computational Toxicology and Exposure Data 4 45280 45280 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)
);