home / zeropm-v0-0-4

consensus_index

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

21 rows where inventory_id = 217830

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
551223 551223 217830 217830 4179 1 0.0435878126379419
551224 551224 217830 217830 13899 1 0.0158501136865243
551225 551225 217830 217830 37045 1 0.0124536607536977
551226 551226 217830 217830 39693 1 0.0174351250551768
551227 551227 217830 217830 50396 7 0.174351250551768
551228 551228 217830 217830 54311 2 0.12328495157351
551229 551229 217830 217830 155149 1 0.00968618058620932
551230 551230 217830 217830 169822 1 0.0348702501103536
551231 551231 217830 217830 182791 1 0.0116234167034512
551232 551232 217830 217830 185711 2 0.174351250551768
551233 551233 217830 217830 204864 1 0.0102559559148099
551234 551234 217830 217830 205328 1 0.0193723611724186
551235 551235 217830 217830 208099 1 0.0871756252758839
551236 551236 217830 217830 208100 1 0.029058541758628
551237 551237 217830 217830 218140 1 0.0108969531594855
551238 551238 217830 217830 232897 1 0.0249073215073954
551239 551239 217830 217830 241952 1 0.0871756252758839
551240 551240 217830 217830 254152 1 0.0581170835172559
551241 551241 217830 217830 258801 1 0.021793906318971
551242 551242 217830 217830 322972 1 0.014529270879314
551243 551243 217830 217830 322973 1 0.0134116346578283
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 1964.266ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website