api_results

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

18 rows where query_id = 237878

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
240965 240965 237878 237878 PubChem (compound) 1 120186 120186 1
513376 513376 237878 237878 PubChem (substance) 2 43999 43999 5
622156 622156 237878 237878 PubChem (substance) 2 120186 120186 1
795943 795943 237878 237878 PubChem (substance) 2 136757 136757 15
795950 795950 237878 237878 PubChem (substance) 2 224309 224309 14
795953 795953 237878 237878 PubChem (substance) 2 218873 218873 2
795962 795962 237878 237878 PubChem (substance) 2 210288 210288 3
841501 841501 237878 237878 PubChem (substance) 2 230478 230478 4
841503 841503 237878 237878 PubChem (substance) 2 239100 239100 6
841506 841506 237878 237878 PubChem (substance) 2 228766 228766 7
841507 841507 237878 237878 PubChem (substance) 2 44444 44444 8
841508 841508 237878 237878 PubChem (substance) 2 266497 266497 9
841509 841509 237878 237878 PubChem (substance) 2 291667 291667 10
841510 841510 237878 237878 PubChem (substance) 2 173860 173860 11
841511 841511 237878 237878 PubChem (substance) 2 120186 120186 12
841512 841512 237878 237878 PubChem (substance) 2 120186 120186 13
1109174 1109174 237878 237878 CAS Common Chemistry 3 44444 44444 1
1312697 1312697 237878 237878 Computational Toxicology and Exposure Data 4 120186 120186 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)
);