api_results

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

14 rows where query_id = 112677

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
36677 36677 112677 112677 PubChem (compound) 1 44058 44058 1
348122 348122 112677 112677 PubChem (substance) 2 44058 44058 1
348126 348126 112677 112677 PubChem (substance) 2 136957 136957 2
460194 460194 112677 112677 PubChem (substance) 2 200128 200128 4
460201 460201 112677 112677 PubChem (substance) 2 12197 12197 9
460209 460209 112677 112677 PubChem (substance) 2 208092 208092 6
460212 460212 112677 112677 PubChem (substance) 2 219140 219140 7
715367 715367 112677 112677 PubChem (substance) 2 260772 260772 5
715372 715372 112677 112677 PubChem (substance) 2 189214 189214 3
715375 715375 112677 112677 PubChem (substance) 2 206872 206872 11
715380 715380 112677 112677 PubChem (substance) 2 237302 237302 10
764624 764624 112677 112677 PubChem (substance) 2 274012 274012 8
964932 964932 112677 112677 CAS Common Chemistry 3 44058 44058 1
1166589 1166589 112677 112677 Computational Toxicology and Exposure Data 4 44058 44058 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)
);