api_results

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

13 rows where inchi_id = 42545

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
75965 75965 37786 37786 PubChem (compound) 1 42545 42545 1
75966 75966 177966 177966 PubChem (compound) 1 42545 42545 1
75967 75967 37787 37787 PubChem (compound) 1 42545 42545 1
403505 403505 37786 37786 PubChem (substance) 2 42545 42545 1
403506 403506 37787 37787 PubChem (substance) 2 42545 42545 1
403507 403507 177966 177966 PubChem (substance) 2 42545 42545 1
403508 403508 349812 349812 PubChem (substance) 2 42545 42545 7
403509 403509 335874 335874 PubChem (substance) 2 42545 42545 7
993688 993688 37787 37787 CAS Common Chemistry 3 42545 42545 1
993689 993689 37786 37786 CAS Common Chemistry 3 42545 42545 1
993690 993690 177966 177966 CAS Common Chemistry 3 42545 42545 1
1196746 1196746 37786 37786 Computational Toxicology and Exposure Data 4 42545 42545 1
1196747 1196747 37787 37787 Computational Toxicology and Exposure Data 4 42545 42545 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)
);