api_results

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

16 rows where query_id = 231612

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
237911 237911 231612 231612 PubChem (compound) 1 129186 129186 1
618167 618167 231612 231612 PubChem (substance) 2 129186 129186 1
658049 658049 231612 231612 PubChem (substance) 2 136872 136872 12
752354 752354 231612 231612 PubChem (substance) 2 136704 136704 5
790772 790772 231612 231612 PubChem (substance) 2 170777 170777 2
790793 790793 231612 231612 PubChem (substance) 2 326278 326278 13
840541 840541 231612 231612 PubChem (substance) 2 199630 199630 3
840542 840542 231612 231612 PubChem (substance) 2 219036 219036 4
840544 840544 231612 231612 PubChem (substance) 2 13496 13496 6
840545 840545 231612 231612 PubChem (substance) 2 228999 228999 7
840546 840546 231612 231612 PubChem (substance) 2 255537 255537 8
840548 840548 231612 231612 PubChem (substance) 2 275081 275081 9
840550 840550 231612 231612 PubChem (substance) 2 308328 308328 10
840551 840551 231612 231612 PubChem (substance) 2 309439 309439 11
1108010 1108010 231612 231612 CAS Common Chemistry 3 13496 13496 1
1310336 1310336 231612 231612 Computational Toxicology and Exposure Data 4 129186 129186 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)
);