api_results

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

11 rows where query_id = 32249

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
540892 540892 32249 32249 PubChem (substance) 2 190682 190682 3
564794 564794 32249 32249 PubChem (substance) 2 171888 171888 7
655600 655600 32249 32249 PubChem (substance) 2 17692 17692 4
732544 732544 32249 32249 PubChem (substance) 2 217497 217497 1
732546 732546 32249 32249 PubChem (substance) 2 112930 112930 2
732548 732548 32249 32249 PubChem (substance) 2 112930 112930 5
732549 732549 32249 32249 PubChem (substance) 2 17692 17692 6
732550 732550 32249 32249 PubChem (substance) 2 258955 258955 8
732551 732551 32249 32249 PubChem (substance) 2 190682 190682 9
987732 987732 32249 32249 CAS Common Chemistry 3 17692 17692 1
1190622 1190622 32249 32249 Computational Toxicology and Exposure Data 4 112930 112930 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)
);