consensus_index

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

27 rows where inventory_id = 60875

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
170664 170664 60875 60875 17481 2 0.127463007420955
170665 170665 60875 60875 73622 4 0.25492601484191
170666 170666 60875 60875 100953 1 0.0212438345701591
170667 170667 60875 60875 106252 1 0.050985202968382
170668 170668 60875 60875 108407 1 0.014995647931877
170669 170669 60875 60875 108570 1 0.0196096934493777
170670 170670 60875 60875 109852 1 0.0283251127602122
170671 170671 60875 60875 110265 1 0.0115875461291777
170672 170672 60875 60875 120194 1 0.025492601484191
170673 170673 60875 60875 123636 1 0.0849753382806366
170674 170674 60875 60875 123844 1 0.0110837397757352
170675 170675 60875 60875 129119 1 0.0637315037104774
170676 170676 60875 60875 132800 1 0.0364180021202728
170677 170677 60875 60875 173797 1 0.0424876691403183
170678 170678 60875 60875 212750 1 0.0182090010601364
170679 170679 60875 60875 217830 1 0.0106219172850796
170680 170680 60875 60875 229210 1 0.0318657518552387
170681 170681 60875 60875 229416 1 0.0231750922583554
170682 170682 60875 60875 229437 1 0.0127463007420955
170683 170683 60875 60875 229758 1 0.00980484672468884
170684 170684 60875 60875 230202 1 0.00944170425340407
170685 170685 60875 60875 230241 1 0.0169950676561273
170686 170686 60875 60875 230346 1 0.0159328759276194
170687 170687 60875 60875 230352 1 0.0121393340400909
170688 170688 60875 60875 230831 1 0.0141625563801061
170689 170689 60875 60875 238741 1 0.01341715867589
170690 170690 60875 60875 244222 1 0.0101970405936764 
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)
);