api_results

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

13 rows where query_id = 158140

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
177396 177396 158140 158140 PubChem (compound) 1 18313 18313 1
541539 541539 158140 158140 PubChem (substance) 2 18313 18313 1
810841 810841 158140 158140 PubChem (substance) 2 151518 151518 2
810842 810842 158140 158140 PubChem (substance) 2 209161 209161 3
810843 810843 158140 158140 PubChem (substance) 2 169277 169277 4
810845 810845 158140 158140 PubChem (substance) 2 187868 187868 5
810846 810846 158140 158140 PubChem (substance) 2 235109 235109 6
810847 810847 158140 158140 PubChem (substance) 2 212273 212273 7
810848 810848 158140 158140 PubChem (substance) 2 174880 174880 8
810849 810849 158140 158140 PubChem (substance) 2 192650 192650 9
810850 810850 158140 158140 PubChem (substance) 2 234152 234152 10
1068453 1068453 158140 158140 CAS Common Chemistry 3 18313 18313 1
1269957 1269957 158140 158140 Computational Toxicology and Exposure Data 4 18313 18313 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)
);