consensus_index

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

27 rows where inchi_id = 3062

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15926 15926 4818 4818 3062 6 0.343612334801762
22973 22973 6737 6737 3062 1 0.153846153846154
79261 79261 28616 28616 3062 3 0.336
118634 118634 41370 41370 3062 1 0.153846153846154
140626 140626 50098 50098 3062 3 0.336
140630 140630 50099 50099 3062 1 0.259842519685039
155672 155672 55993 55993 3062 1 0.131274907527264
162619 162619 58246 58246 3062 59 0.125161888843452
211608 211608 74100 74100 3062 6 0.265629615749118
222206 222206 76821 76821 3062 1 0.130297490894792
252308 252308 85726 85726 3062 5 0.340909090909091
423498 423498 153223 153223 3062 6 0.265399230469348
430779 430779 155073 155073 3062 1 0.130297490894792
443628 443628 159031 159031 3062 2 0.229965156794425
443632 443632 159032 159032 3062 6 0.342857142857143
444278 444278 159273 159273 3062 1 0.257142857142857
592501 592501 231018 231018 3062 1 0.130297490894792
672941 672941 240710 240710 3062 6 0.343612334801762
673391 673391 240822 240822 3062 1 0.13101627370448
676618 676618 241809 241809 3062 1 0.259842519685039
746292 746292 262510 262510 3062 1 0.152671755725191
746296 746296 262511 262511 3062 1 0.153846153846154
879691 879691 305438 305438 3062 1 0.150943396226415
912703 912703 322503 322503 3062 1 0.0779220779220779
940408 940408 336431 336431 3062 3 0.263683996894279
1617472 1617472 488388 488388 3062 1 0.153846153846154
1720349 1720349 526883 526883 3062 1 0.153310104529617 
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)
);