consensus_index

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

23 rows where inventory_id = 219834

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
558450 558450 219834 219834 45291 11 0.244452895820286
558451 558451 219834 219834 137375 2 0.122226447910143
558452 558452 219834 219834 140858 1 0.0116406140866803
558453 558453 219834 219834 165307 1 0.040742149303381
558454 558454 219834 219834 176256 1 0.0203710746516905
558455 558455 219834 219834 180086 1 0.040742149303381
558456 558456 219834 219834 189150 2 0.046197254972147
558457 558457 219834 219834 200194 1 0.0188040689092528
558458 558458 219834 219834 204863 2 0.0814842986067621
558459 558459 219834 219834 206746 1 0.0349218422600409
558460 558460 219834 219834 206747 1 0.0305566119775358
558461 558461 219834 219834 206748 1 0.0271614328689207
558462 558462 219834 219834 206749 1 0.0244452895820286
558463 558463 219834 219834 207524 1 0.0222229905291169
558464 558464 219834 219834 213756 1 0.0143795821070757
558465 558465 219834 219834 227359 2 0.0488905791640573
558466 558466 219834 219834 243351 1 0.0611132239550716
558467 558467 219834 219834 249870 1 0.0135807164344603
558468 558468 219834 219834 261964 2 0.0223153942147052
558469 558469 219834 219834 266825 2 0.0203710746516905
558470 558470 219834 219834 284042 1 0.0174609211300204
558471 558471 219834 219834 291651 1 0.0122226447910143
558472 558472 219834 219834 308500 2 0.0177344770188235 
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)
);