consensus_index

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

28 rows where inchi_id = 16834

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
52498 52498 16310 16310 16834 1 0.257142857142857
53352 53352 16605 16605 16834 7 0.444620159513714
102148 102148 36006 36006 16834 7 0.444620159513714
167647 167647 59912 59912 16834 8 0.387297302541359
317989 317989 107154 107154 16834 1 0.257142857142857
321116 321116 108212 108212 16834 8 0.449340531842754
470582 470582 170352 170352 16834 8 0.387297302541359
502334 502334 200635 200635 16834 4 0.362911040737709
528283 528283 209897 209897 16834 8 0.387297302541359
575043 575043 225277 225277 16834 12 0.37015571391452
576539 576539 225980 225980 16834 1 0.257142857142857
686978 686978 245008 245008 16834 1 0.260869565217391
688434 688434 245494 245494 16834 7 0.444620159513714
773170 773170 270472 270472 16834 7 0.444620159513714
773173 773173 270473 270473 16834 4 0.506024096385542
773176 773176 270474 270474 16834 8 0.387297302541359
773181 773181 270475 270475 16834 8 0.401913875598086
953983 953983 342505 342505 16834 4 0.506024096385542
1037844 1037844 367751 367751 16834 6 0.467193636120162
1037847 1037847 367752 367752 16834 6 0.467193636120162
1257450 1257450 414230 414230 16834 6 0.467193636120162
1257453 1257453 414231 414231 16834 6 0.467193636120162
1257456 1257456 414232 414232 16834 6 0.467193636120162
1482963 1482963 458833 458833 16834 6 0.467193636120162
1482966 1482966 458834 458834 16834 6 0.467193636120162
1595758 1595758 481693 481693 16834 6 0.467193636120162
1665962 1665962 505124 505124 16834 6 0.467193636120162
1747957 1747957 535369 535369 16834 7 0.444620159513714 
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)
);