consensus_index

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

11 rows where inventory_id = 53451

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
148677 148677 53451 53451 29093 6 0.27581692340148
148678 148678 53451 53451 92339 2 0.195032016903197
148679 148679 53451 53451 136400 1 0.0394024176287829
148680 148680 53451 53451 136456 2 0.0975160084515986
148681 148681 53451 53451 155938 1 0.0919389744671601
148682 148682 53451 53451 200972 1 0.0306463248223867
148683 148683 53451 53451 234143 1 0.055163384680296
148684 148684 53451 53451 237702 1 0.04596948723358
148685 148685 53451 53451 260178 1 0.0919389744671601
148686 148686 53451 53451 271570 1 0.027581692340148
148687 148687 53451 53451 276597 1 0.034477115425185 
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)
);