consensus_index

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

25 rows where inchi_id = 25579

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
36691 36691 10973 10973 25579 1 0.3125
82249 82249 29621 29621 25579 1 0.3125
125957 125957 45001 45001 25579 1 0.310344827586207
145835 145835 52022 52022 25579 4 0.506024096385542
265798 265798 90086 90086 25579 6 0.514285714285714
266468 266468 90314 90314 25579 1 0.307692307692308
448842 448842 160923 160923 25579 6 0.514285714285714
449161 449161 161051 161051 25579 1 0.307692307692308
569457 569457 223336 223336 25579 1 0.307692307692308
570071 570071 223514 223514 25579 6 0.514285714285714
694019 694019 247539 247539 25579 1 0.3125
781908 781908 273406 273406 25579 1 0.3125
781910 781910 273407 273407 25579 1 0.310344827586207
781912 781912 273408 273408 25579 1 0.3
895365 895365 314350 314350 25579 4 0.506024096385542
1042841 1042841 369355 369355 25579 7 0.4125
1042845 1042845 369356 369356 25579 7 0.4125
1263306 1263306 416072 416072 25579 7 0.4125
1263310 1263310 416073 416073 25579 7 0.4125
1486494 1486494 460007 460007 25579 7 0.4125
1486498 1486498 460008 460008 25579 7 0.4125
1596850 1596850 482164 482164 25579 7 0.4125
1638796 1638796 495681 495681 25579 7 0.4125
1639174 1639174 495813 495813 25579 1 0.3125
1733014 1733014 530788 530788 25579 1 0.310344827586207 
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)
);