api_results

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

7 rows where inchi_id = 47682

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
198936 198936 180744 180744 PubChem (compound) 1 47682 47682 1
198937 198937 180745 180745 PubChem (compound) 1 47682 47682 1
569314 569314 360659 360659 PubChem (substance) 2 47682 47682 3
569315 569315 180744 180744 PubChem (substance) 2 47682 47682 1
569316 569316 180745 180745 PubChem (substance) 2 47682 47682 1
1083224 1083224 180744 180744 CAS Common Chemistry 3 47682 47682 1
1284821 1284821 180744 180744 Computational Toxicology and Exposure Data 4 47682 47682 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)
);