consensus_index

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

12 rows where inchi_id = 12321

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
128354 128354 45855 45855 12321 1 0.0498967828793475
257500 257500 87175 87175 12321 7 0.476190476190476
315377 315377 106368 106368 12321 1 0.110417469241272
445815 445815 159655 159655 12321 7 0.476190476190476
468450 468450 169340 169340 12321 1 0.110417469241272
485819 485819 179905 179905 12321 2 0.630993034743972
578598 578598 226618 226618 12321 7 0.476190476190476
685079 685079 244380 244380 12321 8 0.478260869565217
767950 767950 268805 268805 12321 8 0.478260869565217
767953 767953 268806 268806 12321 6 0.615384615384615
931370 931370 331644 331644 12321 4 0.6
1663583 1663583 504275 504275 12321 1 0.111197939569107 
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)
);