api_results

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

9 rows where query_id = 18078

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
40054 40054 18078 18078 PubChem (compound) 1 55346 55346 1
352827 352827 18078 18078 PubChem (substance) 2 55346 55346 1
717120 717120 18078 18078 PubChem (substance) 2 245468 245468 2
717121 717121 18078 18078 PubChem (substance) 2 175973 175973 3
717122 717122 18078 18078 PubChem (substance) 2 294824 294824 4
717123 717123 18078 18078 PubChem (substance) 2 274269 274269 5
717124 717124 18078 18078 PubChem (substance) 2 248756 248756 6
967343 967343 18078 18078 CAS Common Chemistry 3 55346 55346 1
1169317 1169317 18078 18078 Computational Toxicology and Exposure Data 4 55346 55346 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)
);