consensus_index

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

26 rows where inventory_id = 38177

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
108972 108972 38177 38177 4475 8 0.222036160464741
108973 108973 38177 38177 39072 1 0.0444072320929483
108974 108974 38177 38177 67612 1 0.0100925527483973
108975 108975 38177 38177 136970 2 0.111018080232371
108976 108976 38177 38177 137753 1 0.0555090401161854
108977 108977 38177 38177 146475 1 0.0201851054967947
108978 108978 38177 38177 195730 2 0.0302152943102969
108979 108979 38177 38177 198573 1 0.0740120534882471
108980 108980 38177 38177 208864 1 0.017079704651134
108981 108981 38177 38177 211085 1 0.0185030133720618
108982 108982 38177 38177 216432 2 0.0224290392476061
108983 108983 38177 38177 232047 1 0.0246706844960824
108984 108984 38177 38177 241517 1 0.0370060267441236
108985 108985 38177 38177 243345 1 0.0740120534882471
108986 108986 38177 38177 243355 1 0.017079704651134
108987 108987 38177 38177 256418 2 0.0181291765861781
108988 108988 38177 38177 259410 2 0.0265383971294221
108989 108989 38177 38177 260172 1 0.0277545200580927
108990 108990 38177 38177 272682 1 0.0158597257474815
108991 108991 38177 38177 291626 1 0.0116861137086706
108992 108992 38177 38177 297698 2 0.0167366053216521
108993 108993 38177 38177 309787 2 0.0155456406716412
108994 108994 38177 38177 320450 2 0.0392508186833108
108995 108995 38177 38177 321737 1 0.0111018080232371
108996 108996 38177 38177 323080 1 0.010573150498321
108997 108997 38177 38177 340494 2 0.0234046663329071 
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)
);