api_results

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

14 rows where inchi_id = 45495

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
76158 76158 443044 443044 PubChem (compound) 1 45495 45495 1
76159 76159 37950 37950 PubChem (compound) 1 45495 45495 1
76160 76160 37949 37949 PubChem (compound) 1 45495 45495 1
76161 76161 178603 178603 PubChem (compound) 1 45495 45495 1
403802 403802 37949 37949 PubChem (substance) 2 45495 45495 1
403803 403803 37950 37950 PubChem (substance) 2 45495 45495 1
403804 403804 443044 443044 PubChem (substance) 2 45495 45495 1
403805 403805 178603 178603 PubChem (substance) 2 45495 45495 1
993842 993842 37950 37950 CAS Common Chemistry 3 45495 45495 1
993843 993843 443044 443044 CAS Common Chemistry 3 45495 45495 1
993844 993844 37949 37949 CAS Common Chemistry 3 45495 45495 1
1196898 1196898 37950 37950 Computational Toxicology and Exposure Data 4 45495 45495 1
1196899 1196899 37949 37949 Computational Toxicology and Exposure Data 4 45495 45495 1
1196900 1196900 443044 443044 Computational Toxicology and Exposure Data 4 45495 45495 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)
);