consensus_index

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

14 rows where inventory_id = 253601

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
717005 717005 253601 253601 6801 2 0.0304689204375321
717006 717006 253601 253601 56065 12 0.272522309197418
717007 717007 253601 253601 71273 2 0.11125676684311
717008 717008 253601 253601 137217 3 0.119035082759845
717009 717009 253601 253601 138388 1 0.0454203848662363
717010 717010 253601 253601 167192 1 0.0681305772993544
717011 717011 253601 253601 168452 1 0.0681305772993544
717012 717012 253601 253601 231765 1 0.0389317584567739
717013 717013 253601 253601 235037 1 0.0545044618394835
717014 717014 253601 253601 241833 1 0.0272522309197418
717015 717015 253601 253601 245816 2 0.0460646778253276
717016 717016 253601 253601 294834 1 0.0454203848662363
717017 717017 253601 253601 310061 2 0.0302802565774908
717018 717018 253601 253601 310180 1 0.0340652886496772 
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)
);