api_results

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

18 rows where query_id = 87182

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
3493 3493 87182 87182 PubChem (compound) 1 136430 136430 2
60940 60940 87182 87182 PubChem (compound) 1 154436 154436 3
91346 91346 87182 87182 PubChem (compound) 1 169013 169013 1
115555 115555 87182 87182 PubChem (compound) 1 240997 240997 4
115558 115558 87182 87182 PubChem (compound) 1 310230 310230 5
300432 300432 87182 87182 PubChem (substance) 2 136430 136430 3
382158 382158 87182 87182 PubChem (substance) 2 154436 154436 4
424945 424945 87182 87182 PubChem (substance) 2 169013 169013 1
458727 458727 87182 87182 PubChem (substance) 2 240997 240997 7
458728 458728 87182 87182 PubChem (substance) 2 310230 310230 11
763665 763665 87182 87182 PubChem (substance) 2 3633 3633 2
763669 763669 87182 87182 PubChem (substance) 2 167423 167423 5
763670 763670 87182 87182 PubChem (substance) 2 154077 154077 6
763673 763673 87182 87182 PubChem (substance) 2 291081 291081 8
763674 763674 87182 87182 PubChem (substance) 2 218196 218196 9
763676 763676 87182 87182 PubChem (substance) 2 257227 257227 10
1022593 1022593 87182 87182 CAS Common Chemistry 3 3633 3633 1
1224978 1224978 87182 87182 Computational Toxicology and Exposure Data 4 3633 3633 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)
);