api_results

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

9 rows where query_id = 217530

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
41405 41405 217530 217530 PubChem (compound) 1 59574 59574 1
229663 229663 217530 217530 PubChem (compound) 1 132853 132853 2
229664 229664 217530 217530 PubChem (compound) 1 257184 257184 3
354660 354660 217530 217530 PubChem (substance) 2 59574 59574 1
608132 608132 217530 217530 PubChem (substance) 2 132853 132853 2
608134 608134 217530 217530 PubChem (substance) 2 257184 257184 3
836689 836689 217530 217530 PubChem (substance) 2 86437 86437 4
1103260 1103260 217530 217530 CAS Common Chemistry 3 86437 86437 1
1305057 1305057 217530 217530 Computational Toxicology and Exposure Data 4 132853 132853 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)
);