consensus_index

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

16 rows where inventory_id = 78749

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
229736 229736 78749 78749 14028 8 0.270493931162264
229737 229737 78749 78749 24189 1 0.0208072254740203
229738 229738 78749 78749 75122 1 0.033811741395283
229739 229739 78749 78749 136242 2 0.0676234827905661
229740 229740 78749 78749 137839 2 0.045721819360006
229741 229741 78749 78749 158402 4 0.110428684977844
229742 229742 78749 78749 168959 2 0.135246965581132
229743 229743 78749 78749 196723 2 0.0493852092552739
229744 229744 78749 78749 197793 2 0.0257905843981191
229745 229745 78749 78749 205754 1 0.0225411609301887
229746 229746 78749 78749 211005 2 0.0403228545053314
229747 229747 78749 78749 218186 4 0.0509889689612574
229748 229748 78749 78749 231799 1 0.0386419901660377
229749 229749 78749 78749 238170 2 0.0285125638575184
229750 229750 78749 78749 258386 2 0.0208690598613764
229751 229751 78749 78749 259502 2 0.0318780154991074 
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)
);