consensus_index

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

18 rows where inchi_id = 3289

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
22995 22995 6743 6743 3289 8 0.625
163662 163662 58613 58613 3289 8 0.625
222241 222241 76828 76828 3289 8 0.413793103448276
430803 430803 155078 155078 3289 8 0.413793103448276
517882 517882 207223 207223 3289 8 0.413793103448276
517886 517886 207224 207224 3289 8 0.413793103448276
592483 592483 231014 231014 3289 8 0.413793103448276
673418 673418 240828 240828 3289 12 0.417391304347826
686938 686938 244986 244986 3289 1 0.157083884617477
746347 746347 262527 262527 3289 8 0.625
789055 789055 275589 275589 3289 3 0.408922800339742
989667 989667 355448 355448 3289 8 0.625
1199579 1199579 399553 399553 3289 8 0.625
1199581 1199581 399554 399554 3289 8 0.625
1447028 1447028 449751 449751 3289 8 0.625
1590938 1590938 480223 480223 3289 8 0.625
1617498 1617498 488395 488395 3289 8 0.625
1720359 1720359 526886 526886 3289 5 0.608695652173913 
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)
);