api_results

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

13 rows where query_id = 317178

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
260427 260427 317178 317178 PubChem (compound) 1 8745 8745 1
645382 645382 317178 317178 PubChem (substance) 2 8745 8745 1
645383 645383 317178 317178 PubChem (substance) 2 168928 168928 5
848154 848154 317178 317178 PubChem (substance) 2 136491 136491 2
848155 848155 317178 317178 PubChem (substance) 2 238420 238420 3
848157 848157 317178 317178 PubChem (substance) 2 237109 237109 4
848158 848158 317178 317178 PubChem (substance) 2 266778 266778 6
848159 848159 317178 317178 PubChem (substance) 2 288119 288119 7
848160 848160 317178 317178 PubChem (substance) 2 310238 310238 8
848161 848161 317178 317178 PubChem (substance) 2 326232 326232 9
848162 848162 317178 317178 PubChem (substance) 2 228813 228813 10
1113847 1113847 317178 317178 CAS Common Chemistry 3 8745 8745 1
1324751 1324751 317178 317178 Computational Toxicology and Exposure Data 4 8745 8745 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)
);