consensus_index

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

19 rows where inventory_id = 101337

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
299644 299644 101337 101337 139026 2 0.0569132642536669
299645 299645 101337 101337 170075 1 0.0301828163199224
299646 299646 101337 101337 170076 2 0.0328588884373149
299647 299647 101337 101337 181710 2 0.0697042285088328
299648 299648 101337 101337 181711 1 0.0482925061118758
299649 299649 101337 101337 195833 1 0.0219511391417617
299650 299650 101337 101337 199497 2 0.0162425275076797
299651 299651 101337 101337 229165 2 0.170739792761001
299652 299652 101337 101337 231498 2 0.170739792761001
299653 299653 101337 101337 231998 1 0.0603656326398447
299654 299654 101337 101337 240978 2 0.028860292460685
299655 299655 101337 101337 243721 2 0.0187978325095046
299656 299656 101337 101337 246033 1 0.0185740408122599
299657 299657 101337 101337 270490 1 0.0268291700621532
299658 299658 101337 101337 284740 1 0.0201218775466149
299659 299659 101337 101337 308111 2 0.0204073085059773
299660 299660 101337 101337 320288 2 0.0408146170119547
299661 299661 101337 101337 333098 1 0.0301828163199224
299662 299662 101337 101337 334341 2 0.0174260571272082 
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)
);