consensus_index

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

26 rows where inchi_id = 74397

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
26829 26829 7819 7819 74397 3 0.198373954454235
52179 52179 16195 16195 74397 1 0.259842519685039
78657 78657 28426 28426 74397 1 0.156521739130435
132663 132663 47147 47147 74397 4 0.172844556128471
134192 134192 47637 47637 74397 5 0.333426983929139
229388 229388 78676 78676 74397 2 0.158215010141988
296703 296703 100373 100373 74397 5 0.333426983929139
316491 316491 106689 106689 74397 1 0.259842519685039
468808 468808 169511 169511 74397 1 0.259842519685039
503613 503613 201519 201519 74397 2 0.158215010141988
505703 505703 202261 202261 74397 5 0.333426983929139
540158 540158 214048 214048 74397 5 0.333426983929139
578021 578021 226419 226419 74397 2 0.158215010141988
685735 685735 244562 244562 74397 2 0.158215010141988
769306 769306 269154 269154 74397 2 0.158215010141988
769311 769311 269155 269155 74397 2 0.158215010141988
769316 769316 269156 269156 74397 2 0.145404837743975
771524 771524 269946 269946 74397 1 0.3125
863458 863458 298330 298330 74397 1 0.243864228693887
868413 868413 299572 299572 74397 1 0.155844155844156
1034803 1034803 366827 366827 74397 2 0.158215010141988
1253723 1253723 413100 413100 74397 2 0.158215010141988
1480621 1480621 458106 458106 74397 2 0.158215010141988
1595122 1595122 481459 481459 74397 2 0.158215010141988
1621529 1621529 489651 489651 74397 2 0.158215010141988
1723481 1723481 527804 527804 74397 3 0.198373954454235 
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)
);