consensus_index

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

19 rows where inchi_id = 18196

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
53761 53761 16743 16743 18196 8 0.478260869565217
90441 90441 32287 32287 18196 8 0.478260869565217
180998 180998 64654 64654 18196 8 0.478260869565217
323131 323131 108858 108858 18196 7 0.620689655172414
471510 471510 170853 170853 18196 4 0.6
574167 574167 224970 224970 18196 4 0.6
689262 689262 245796 245796 18196 12 0.484848484848485
774359 774359 270869 270869 18196 8 0.478260869565217
774361 774361 270870 270870 18196 4 0.6
1038642 1038642 368032 368032 18196 7 0.620689655172414
1038644 1038644 368033 368033 18196 7 0.620689655172414
1038646 1038646 368034 368034 18196 7 0.620689655172414
1258546 1258546 414607 414607 18196 7 0.620689655172414
1258548 1258548 414608 414608 18196 7 0.620689655172414
1258550 1258550 414609 414609 18196 7 0.620689655172414
1483561 1483561 459059 459059 18196 7 0.620689655172414
1595959 1595959 481775 481775 18196 7 0.620689655172414
1666812 1666812 505431 505431 18196 7 0.620689655172414
1748358 1748358 535507 535507 18196 8 0.478260869565217 
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)
);