consensus_index

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

23 rows where inventory_id = 282321

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
811434 811434 282321 282321 50402 2 0.15371100205225
811435 811435 282321 282321 75177 2 0.01403183052679
811436 811436 282321 282321 106751 1 0.15371100205225
811437 811437 282321 282321 107063 2 0.108690091894125
811438 811438 282321 282321 137100 1 0.0192138752565313
811439 811439 282321 282321 137613 6 0.044071672921167
811440 811440 282321 282321 138513 2 0.076855501026125
811441 811441 282321 282321 140396 1 0.0256185003420417
811442 811442 282321 282321 152808 1 0.0384277505130625
811443 811443 282321 282321 173809 1 0.03074220041045
811444 811444 282321 282321 195165 1 0.00960693762826563
811445 811445 282321 282321 195482 2 0.015527155984875
811446 811446 282321 282321 208682 1 0.0170790002280278
811447 811447 282321 282321 208683 1 0.00904182365013236
811448 811448 282321 282321 232043 1 0.0118239232347885
811449 811449 282321 282321 239006 2 0.0290486489431995
811450 811450 282321 282321 255643 4 0.15371100205225
811451 811451 282321 282321 256855 1 0.00853950011401389
811452 811452 282321 282321 260076 1 0.00809005273959211
811453 811453 282321 282321 261306 1 0.0128092501710208
811454 811454 282321 282321 294527 4 0.0311356790978586
811455 811455 282321 282321 309407 1 0.0076855501026125
811456 811456 282321 282321 329529 1 0.0170790002280278 
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)
);