api_results

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

17 rows where query_id = 117562

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
137181 137181 117562 117562 PubChem (compound) 1 60119 60119 1
488393 488393 117562 117562 PubChem (substance) 2 60119 60119 1
783044 783044 117562 117562 PubChem (substance) 2 138202 138202 2
783046 783046 117562 117562 PubChem (substance) 2 172577 172577 3
783048 783048 117562 117562 PubChem (substance) 2 210299 210299 4
783049 783049 117562 117562 PubChem (substance) 2 238104 238104 5
783051 783051 117562 117562 PubChem (substance) 2 320494 320494 6
783053 783053 117562 117562 PubChem (substance) 2 288694 288694 7
783055 783055 117562 117562 PubChem (substance) 2 323950 323950 8
783058 783058 117562 117562 PubChem (substance) 2 294520 294520 9
783059 783059 117562 117562 PubChem (substance) 2 294833 294833 10
783060 783060 117562 117562 PubChem (substance) 2 320744 320744 11
783061 783061 117562 117562 PubChem (substance) 2 210300 210300 12
783062 783062 117562 117562 PubChem (substance) 2 324622 324622 13
783064 783064 117562 117562 PubChem (substance) 2 329567 329567 14
1037993 1037993 117562 117562 CAS Common Chemistry 3 60119 60119 1
1240981 1240981 117562 117562 Computational Toxicology and Exposure Data 4 60119 60119 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)
);