api_results

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

12 rows where query_id = 106117

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
125980 125980 106117 106117 PubChem (compound) 1 79597 79597 1
473481 473481 106117 106117 PubChem (substance) 2 79597 79597 1
754823 754823 106117 106117 PubChem (substance) 2 197855 197855 8
773873 773873 106117 106117 PubChem (substance) 2 162601 162601 2
773875 773875 106117 106117 PubChem (substance) 2 198066 198066 3
773877 773877 106117 106117 PubChem (substance) 2 161214 161214 4
773878 773878 106117 106117 PubChem (substance) 2 189476 189476 5
773879 773879 106117 106117 PubChem (substance) 2 260129 260129 6
773880 773880 106117 106117 PubChem (substance) 2 226222 226222 7
773881 773881 106117 106117 PubChem (substance) 2 250864 250864 9
1029426 1029426 106117 106117 CAS Common Chemistry 3 79597 79597 1
1232279 1232279 106117 106117 Computational Toxicology and Exposure Data 4 79597 79597 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)
);