api_results

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

11 rows where query_id = 117612

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
137231 137231 117612 117612 PubChem (compound) 1 60782 60782 1
488239 488239 117612 117612 PubChem (substance) 2 59790 59790 6
488470 488470 117612 117612 PubChem (substance) 2 60782 60782 1
783122 783122 117612 117612 PubChem (substance) 2 168929 168929 2
783126 783126 117612 117612 PubChem (substance) 2 135060 135060 3
783128 783128 117612 117612 PubChem (substance) 2 136361 136361 4
783129 783129 117612 117612 PubChem (substance) 2 224161 224161 5
783130 783130 117612 117612 PubChem (substance) 2 169436 169436 7
783131 783131 117612 117612 PubChem (substance) 2 308056 308056 8
1038030 1038030 117612 117612 CAS Common Chemistry 3 60782 60782 1
1241019 1241019 117612 117612 Computational Toxicology and Exposure Data 4 135060 135060 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)
);