api_results

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

14 rows where inchi_id = 7045

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
128432 128432 109277 109277 PubChem (compound) 1 7045 7045 1
128433 128433 231316 231316 PubChem (compound) 1 7045 7045 1
128434 128434 109278 109278 PubChem (compound) 1 7045 7045 1
476711 476711 138783 138783 PubChem (substance) 2 7045 7045 3
476712 476712 302766 302766 PubChem (substance) 2 7045 7045 4
476713 476713 109277 109277 PubChem (substance) 2 7045 7045 1
476714 476714 231316 231316 PubChem (substance) 2 7045 7045 1
476715 476715 109278 109278 PubChem (substance) 2 7045 7045 1
476716 476716 343846 343846 PubChem (substance) 2 7045 7045 5
1031263 1031263 109277 109277 CAS Common Chemistry 3 7045 7045 1
1031264 1031264 109278 109278 CAS Common Chemistry 3 7045 7045 1
1234156 1234156 109277 109277 Computational Toxicology and Exposure Data 4 7045 7045 1
1234157 1234157 109278 109278 Computational Toxicology and Exposure Data 4 7045 7045 1
1234158 1234158 231316 231316 Computational Toxicology and Exposure Data 4 7045 7045 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)
);