api_results

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

12 rows where query_id = 104625

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124545 124545 104625 104625 PubChem (compound) 1 192035 192035 1
471372 471372 104625 104625 PubChem (substance) 2 192035 192035 1
473765 473765 104625 104625 PubChem (substance) 2 185753 185753 6
771196 771196 104625 104625 PubChem (substance) 2 137595 137595 2
771197 771197 104625 104625 PubChem (substance) 2 255507 255507 7
771202 771202 104625 104625 PubChem (substance) 2 263384 263384 8
771206 771206 104625 104625 PubChem (substance) 2 309145 309145 9
771208 771208 104625 104625 PubChem (substance) 2 184898 184898 3
771209 771209 104625 104625 PubChem (substance) 2 206685 206685 4
771210 771210 104625 104625 PubChem (substance) 2 206686 206686 5
1028397 1028397 104625 104625 CAS Common Chemistry 3 46112 46112 1
1231198 1231198 104625 104625 Computational Toxicology and Exposure Data 4 46112 46112 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)
);