api_results

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

14 rows where inchi_id = 22789

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
45257 45257 20454 20454 PubChem (compound) 1 22789 22789 1
45258 45258 20453 20453 PubChem (compound) 1 22789 22789 1
45259 45259 126911 126911 PubChem (compound) 1 22789 22789 1
360272 360272 20456 20456 PubChem (substance) 2 22789 22789 2
360273 360273 126911 126911 PubChem (substance) 2 22789 22789 1
360274 360274 20453 20453 PubChem (substance) 2 22789 22789 1
360275 360275 59632 59632 PubChem (substance) 2 22789 22789 2
360276 360276 20454 20454 PubChem (substance) 2 22789 22789 1
970976 970976 126911 126911 CAS Common Chemistry 3 22789 22789 1
970977 970977 20453 20453 CAS Common Chemistry 3 22789 22789 1
970978 970978 20454 20454 CAS Common Chemistry 3 22789 22789 1
1173513 1173513 20453 20453 Computational Toxicology and Exposure Data 4 22789 22789 1
1173514 1173514 126911 126911 Computational Toxicology and Exposure Data 4 22789 22789 1
1173515 1173515 20454 20454 Computational Toxicology and Exposure Data 4 22789 22789 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)
);