api_results

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

12 rows where query_id = 16476

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
35732 35732 16476 16476 PubChem (compound) 1 30754 30754 1
313732 313732 16476 16476 PubChem (substance) 2 3517 3517 2
346742 346742 16476 16476 PubChem (substance) 2 30754 30754 1
366648 366648 16476 16476 PubChem (substance) 2 30594 30594 6
398333 398333 16476 16476 PubChem (substance) 2 30094 30094 3
402295 402295 16476 16476 PubChem (substance) 2 39265 39265 4
563171 563171 16476 16476 PubChem (substance) 2 39624 39624 5
714816 714816 16476 16476 PubChem (substance) 2 233966 233966 7
714818 714818 16476 16476 PubChem (substance) 2 209095 209095 8
714820 714820 16476 16476 PubChem (substance) 2 136518 136518 9
964198 964198 16476 16476 CAS Common Chemistry 3 30754 30754 1
1165771 1165771 16476 16476 Computational Toxicology and Exposure Data 4 30754 30754 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)
);