api_results

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

14 rows where query_id = 145827

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
165789 165789 145827 145827 PubChem (compound) 1 205296 205296 1
165790 165790 145827 145827 PubChem (compound) 1 206154 206154 2
473818 473818 145827 145827 PubChem (substance) 2 83485 83485 7
525919 525919 145827 145827 PubChem (substance) 2 205296 205296 1
525921 525921 145827 145827 PubChem (substance) 2 206154 206154 2
654075 654075 145827 145827 PubChem (substance) 2 274707 274707 4
802378 802378 145827 145827 PubChem (substance) 2 262851 262851 3
802381 802381 145827 145827 PubChem (substance) 2 256472 256472 5
802383 802383 145827 145827 PubChem (substance) 2 259398 259398 8
802386 802386 145827 145827 PubChem (substance) 2 287254 287254 9
802387 802387 145827 145827 PubChem (substance) 2 195804 195804 6
802389 802389 145827 145827 PubChem (substance) 2 292136 292136 10
802390 802390 145827 145827 PubChem (substance) 2 292238 292238 11
802391 802391 145827 145827 PubChem (substance) 2 292303 292303 12 
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)
);