consensus_index

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

27 rows where inchi_id = 47696

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
57484 57484 18079 18079 47696 4 0.656703184093677
62430 62430 20107 20107 47696 1 0.105263157894737
93184 93184 33135 33135 47696 1 0.105263157894737
117536 117536 41035 41035 47696 4 0.656703184093677
173296 173296 61908 61908 47696 6 0.438024437775896
193625 193625 68827 68827 47696 1 0.105960264900662
237418 237418 80830 80830 47696 8 0.478260869565217
338522 338522 114147 114147 47696 4 0.432136581898648
361763 361763 122862 122862 47696 1 0.105011933174224
437600 437600 156878 156878 47696 8 0.478260869565217
477412 477412 174115 174115 47696 6 0.615384615384615
486278 486278 180278 180278 47696 1 0.105011933174224
555767 555767 219039 219039 47696 1 0.104712041884817
708744 708744 251587 251587 47696 8 0.625
709762 709762 251840 251840 47696 1 0.105263157894737
808607 808607 281529 281529 47696 1 0.105263157894737
808612 808612 281530 281530 47696 1 0.103896103896104
933777 933777 332739 332739 47696 2 0.630993034743972
1061313 1061313 374819 374819 47696 1 0.105011933174224
1061318 1061318 374820 374820 47696 1 0.105011933174224
1285548 1285548 422587 422587 47696 1 0.105011933174224
1500309 1500309 464119 464119 47696 1 0.105011933174224
1600494 1600494 483487 483487 47696 1 0.105011933174224
1624734 1624734 490614 490614 47696 8 0.625
1673570 1673570 507895 507895 47696 4 0.656703184093677
1683112 1683112 511650 511650 47696 1 0.105011933174224
1756001 1756001 538238 538238 47696 1 0.105263157894737 
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)
);