api_results

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

18 rows where inchi_id = 51792

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
45594 45594 20616 20616 PubChem (compound) 1 51792 51792 1
45595 45595 20617 20617 PubChem (compound) 1 51792 51792 1
45596 45596 138879 138879 PubChem (compound) 1 51792 51792 1
360714 360714 20616 20616 PubChem (substance) 2 51792 51792 1
360715 360715 20617 20617 PubChem (substance) 2 51792 51792 1
360716 360716 138692 138692 PubChem (substance) 2 51792 51792 22
360717 360717 83327 83327 PubChem (substance) 2 51792 51792 22
360718 360718 191900 191900 PubChem (substance) 2 51792 51792 26
360719 360719 138879 138879 PubChem (substance) 2 51792 51792 1
360720 360720 95605 95605 PubChem (substance) 2 51792 51792 22
360721 360721 439829 439829 PubChem (substance) 2 51792 51792 16
360722 360722 336166 336166 PubChem (substance) 2 51792 51792 16
971241 971241 20617 20617 CAS Common Chemistry 3 51792 51792 1
971242 971242 20616 20616 CAS Common Chemistry 3 51792 51792 1
971243 971243 138879 138879 CAS Common Chemistry 3 51792 51792 1
1173785 1173785 20617 20617 Computational Toxicology and Exposure Data 4 51792 51792 1
1173786 1173786 20616 20616 Computational Toxicology and Exposure Data 4 51792 51792 1
1173787 1173787 138879 138879 Computational Toxicology and Exposure Data 4 51792 51792 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)
);