api_results

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

11 rows where inchi_id = 1547

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
101293 101293 107828 107828 PubChem (compound) 1 1547 1547 1
101294 101294 61252 61252 PubChem (compound) 1 1547 1547 1
101295 101295 61253 61253 PubChem (compound) 1 1547 1547 1
439152 439152 107828 107828 PubChem (substance) 2 1547 1547 1
439153 439153 41394 41394 PubChem (substance) 2 1547 1547 2
439154 439154 61252 61252 PubChem (substance) 2 1547 1547 1
439155 439155 61253 61253 PubChem (substance) 2 1547 1547 1
1012782 1012782 61253 61253 CAS Common Chemistry 3 1547 1547 1
1012783 1012783 61252 61252 CAS Common Chemistry 3 1547 1547 1
1214926 1214926 61253 61253 Computational Toxicology and Exposure Data 4 1547 1547 1
1214927 1214927 61252 61252 Computational Toxicology and Exposure Data 4 1547 1547 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)
);