consensus_index

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

12 rows where inventory_id = 245980

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
689786 689786 245980 245980 19092 5 0.238471041667979
689787 689787 245980 245980 126758 1 0.238471041667979
689788 689788 245980 245980 160777 1 0.0397451736113299
689789 689789 245980 245980 162868 3 0.11923552083399
689790 689790 245980 245980 207885 2 0.0794903472226598
689791 689791 245980 245980 231884 2 0.0596177604169948
689792 689792 245980 245980 234411 3 0.0565477367615738
689793 689793 245980 245980 242195 2 0.0344203300252346
689794 689794 245980 245980 258023 2 0.0450667907959996
689795 689795 245980 245980 320511 2 0.0271762973774133
689796 689796 245980 245980 320819 2 0.028104081780008
689797 689797 245980 245980 326329 2 0.0251370549221245 
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)
);