api_results

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

13 rows where query_id = 125496

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
145508 145508 125496 125496 PubChem (compound) 1 19236 19236 1
499426 499426 125496 125496 PubChem (substance) 2 19236 19236 1
702849 702849 125496 125496 PubChem (substance) 2 164048 164048 5
789077 789077 125496 125496 PubChem (substance) 2 228251 228251 2
789080 789080 125496 125496 PubChem (substance) 2 138806 138806 3
789081 789081 125496 125496 PubChem (substance) 2 155002 155002 4
789082 789082 125496 125496 PubChem (substance) 2 169282 169282 6
789083 789083 125496 125496 PubChem (substance) 2 195426 195426 7
789084 789084 125496 125496 PubChem (substance) 2 181392 181392 8
789085 789085 125496 125496 PubChem (substance) 2 191056 191056 9
789086 789086 125496 125496 PubChem (substance) 2 176111 176111 10
789087 789087 125496 125496 PubChem (substance) 2 176163 176163 11
1247158 1247158 125496 125496 Computational Toxicology and Exposure Data 4 19236 19236 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)
);