consensus_index

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

21 rows where inchi_id = 42239

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
39529 39529 11942 11942 42239 1 0.3125
58646 58646 18520 18520 42239 2 0.138555100281172
123497 123497 42886 42886 42239 2 0.138555100281172
178526 178526 63623 63623 42239 2 0.138555100281172
181428 181428 64817 64817 42239 1 0.318181818181818
278046 278046 94286 94286 42239 5 0.539504286779636
279126 279126 94652 94652 42239 1 0.3125
342862 342862 115734 115734 42239 2 0.138555100281172
453407 453407 162808 162808 42239 5 0.539504286779636
479362 479362 175228 175228 42239 2 0.138555100281172
510871 510871 205637 205637 42239 1 0.239130434782609
559826 559826 220215 220215 42239 1 0.3125
560272 560272 220374 220374 42239 5 0.539504286779636
565462 565462 222089 222089 42239 2 0.138555100281172
668008 668008 239389 239389 42239 1 0.3125
790423 790423 276011 276011 42239 2 0.138555100281172
932167 932167 332029 332029 42239 3 0.524040820577346
1645078 1645078 498002 498002 42239 1 0.3125
1675444 1675444 508600 508600 42239 2 0.138555100281172
1735847 1735847 531761 531761 42239 1 0.3125
1752797 1752797 536988 536988 42239 2 0.138555100281172 
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)
);