api_results

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

10 rows where query_id = 190519

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
208106 208106 190519 190519 PubChem (compound) 1 61699 61699 1
581115 581115 190519 190519 PubChem (substance) 2 61699 61699 1
828383 828383 190519 190519 PubChem (substance) 2 320323 320323 2
828384 828384 190519 190519 PubChem (substance) 2 192818 192818 3
828385 828385 190519 190519 PubChem (substance) 2 282241 282241 4
828386 828386 190519 190519 PubChem (substance) 2 287890 287890 5
828387 828387 190519 190519 PubChem (substance) 2 169329 169329 6
828388 828388 190519 190519 PubChem (substance) 2 326572 326572 7
1089397 1089397 190519 190519 CAS Common Chemistry 3 61699 61699 1
1291118 1291118 190519 190519 Computational Toxicology and Exposure Data 4 61699 61699 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)
);