api_results

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

12 rows where query_id = 11268

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21356 21356 11268 11268 PubChem (compound) 1 45327 45327 1
325978 325978 11268 11268 PubChem (substance) 2 45327 45327 1
325985 325985 11268 11268 PubChem (substance) 2 203565 203565 5
326884 326884 11268 11268 PubChem (substance) 2 136425 136425 3
706808 706808 11268 11268 PubChem (substance) 2 136458 136458 2
706812 706812 11268 11268 PubChem (substance) 2 137590 137590 4
706817 706817 11268 11268 PubChem (substance) 2 168990 168990 6
706825 706825 11268 11268 PubChem (substance) 2 248042 248042 7
706828 706828 11268 11268 PubChem (substance) 2 200609 200609 8
706830 706830 11268 11268 PubChem (substance) 2 240687 240687 9
953947 953947 11268 11268 CAS Common Chemistry 3 45327 45327 1
1153406 1153406 11268 11268 Computational Toxicology and Exposure Data 4 45327 45327 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)
);