api_results

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

22 rows where query_id = 328401

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
120624 120624 328401 328401 PubChem (compound) 1 3548 3548 1
261902 261902 328401 328401 PubChem (compound) 1 226867 226867 2
261903 261903 328401 328401 PubChem (compound) 1 139088 139088 3
261904 261904 328401 328401 PubChem (compound) 1 288992 288992 4
261905 261905 328401 328401 PubChem (compound) 1 309254 309254 5
261906 261906 328401 328401 PubChem (compound) 1 326176 326176 6
312404 312404 328401 328401 PubChem (substance) 2 58720 58720 5
312422 312422 328401 328401 PubChem (substance) 2 137316 137316 9
465797 465797 328401 328401 PubChem (substance) 2 3548 3548 1
647327 647327 328401 328401 PubChem (substance) 2 226867 226867 2
647331 647331 328401 328401 PubChem (substance) 2 139088 139088 3
647332 647332 328401 328401 PubChem (substance) 2 288992 288992 11
647334 647334 328401 328401 PubChem (substance) 2 309254 309254 12
647335 647335 328401 328401 PubChem (substance) 2 326176 326176 13
647338 647338 328401 328401 PubChem (substance) 2 231221 231221 4
700888 700888 328401 328401 PubChem (substance) 2 138190 138190 7
908654 908654 328401 328401 PubChem (substance) 2 238758 238758 6
908656 908656 328401 328401 PubChem (substance) 2 258795 258795 8
908658 908658 328401 328401 PubChem (substance) 2 288115 288115 10
908660 908660 328401 328401 PubChem (substance) 2 334433 334433 14
1114344 1114344 328401 328401 CAS Common Chemistry 3 3548 3548 1
1325574 1325574 328401 328401 Computational Toxicology and Exposure Data 4 3548 3548 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)
);