consensus_index

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

12 rows where inchi_id = 21686

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
20655 20655 6077 6077 21686 6 0.384615384615385
119715 119715 41669 41669 21686 6 0.384615384615385
168921 168921 60254 60254 21686 6 0.384615384615385
262902 262902 89067 89067 21686 6 0.342857142857143
281887 281887 95607 95607 21686 1 0.173228346456693
454783 454783 163386 163386 21686 1 0.173228346456693
691269 691269 246585 246585 21686 6 0.384615384615385
707428 707428 251280 251280 21686 1 0.175438596491228
777513 777513 271941 271941 21686 6 0.342857142857143
777517 777517 271942 271942 21686 6 0.384615384615385
906607 906607 319978 319978 21686 1 0.168674698795181
941879 941879 337067 337067 21686 3 0.375 
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)
);