api_results

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

12 rows where query_id = 21390

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
47410 47410 21390 21390 PubChem (compound) 1 119324 119324 1
363288 363288 21390 21390 PubChem (substance) 2 119324 119324 1
393080 393080 21390 21390 PubChem (substance) 2 196011 196011 9
459512 459512 21390 21390 PubChem (substance) 2 138441 138441 7
459518 459518 21390 21390 PubChem (substance) 2 119324 119324 6
459521 459521 21390 21390 PubChem (substance) 2 314191 314191 3
459524 459524 21390 21390 PubChem (substance) 2 314934 314934 2
720953 720953 21390 21390 PubChem (substance) 2 183428 183428 4
720954 720954 21390 21390 PubChem (substance) 2 264293 264293 5
720955 720955 21390 21390 PubChem (substance) 2 20188 20188 8
972531 972531 21390 21390 CAS Common Chemistry 3 20188 20188 1
1175206 1175206 21390 21390 Computational Toxicology and Exposure Data 4 119324 119324 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)
);