api_results

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

12 rows where query_id = 192196

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
209612 209612 192196 192196 PubChem (compound) 1 196072 196072 1
209614 209614 192196 192196 PubChem (compound) 1 139964 139964 2
209618 209618 192196 192196 PubChem (compound) 1 200475 200475 3
209619 209619 192196 192196 PubChem (compound) 1 326582 326582 4
583047 583047 192196 192196 PubChem (substance) 2 196072 196072 1
583048 583048 192196 192196 PubChem (substance) 2 139964 139964 2
583050 583050 192196 192196 PubChem (substance) 2 63615 63615 3
583053 583053 192196 192196 PubChem (substance) 2 200475 200475 4
583055 583055 192196 192196 PubChem (substance) 2 326582 326582 6
770973 770973 192196 192196 PubChem (substance) 2 174904 174904 7
829052 829052 192196 192196 PubChem (substance) 2 292224 292224 5
1090439 1090439 192196 192196 CAS Common Chemistry 3 63615 63615 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)
);