consensus_index

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

19 rows where inventory_id = 478766

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1585707 1585707 478766 478766 139026 2 0.0569132642536669
1585708 1585708 478766 478766 170075 1 0.0301828163199224
1585709 1585709 478766 478766 170076 2 0.0328588884373149
1585710 1585710 478766 478766 181710 2 0.0697042285088328
1585711 1585711 478766 478766 181711 1 0.0482925061118758
1585712 1585712 478766 478766 195833 1 0.0219511391417617
1585713 1585713 478766 478766 199497 2 0.0162425275076797
1585714 1585714 478766 478766 229165 2 0.170739792761001
1585715 1585715 478766 478766 231498 2 0.170739792761001
1585716 1585716 478766 478766 231998 1 0.0603656326398447
1585717 1585717 478766 478766 240978 2 0.028860292460685
1585718 1585718 478766 478766 243721 2 0.0187978325095046
1585719 1585719 478766 478766 246033 1 0.0185740408122599
1585720 1585720 478766 478766 270490 1 0.0268291700621532
1585721 1585721 478766 478766 284740 1 0.0201218775466149
1585722 1585722 478766 478766 308111 2 0.0204073085059773
1585723 1585723 478766 478766 320288 2 0.0408146170119547
1585724 1585724 478766 478766 333098 1 0.0301828163199224
1585725 1585725 478766 478766 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)
);