consensus_index

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

20 rows where inchi_id = 140203

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
50364 50364 15628 15628 140203 4 0.277777777777778
103044 103044 36255 36255 140203 2 0.131473660030799
103049 103049 36256 36256 140203 4 0.277777777777778
151135 151135 54174 54174 140203 4 0.277777777777778
161449 161449 57937 57937 140203 1 0.15
308947 308947 104387 104387 140203 4 0.276923076923077
328060 328060 110590 110590 140203 2 0.130932409479902
466277 466277 168416 168416 140203 2 0.272727272727273
468612 468612 169422 169422 140203 1 0.171924798044066
473373 473373 171902 171902 140203 1 0.103800193390652
582962 582962 227896 227896 140203 4 0.275862068965517
681463 681463 243403 243403 140203 4 0.277777777777778
691284 691284 246589 246589 140203 2 0.0950921895917403
769325 769325 269158 269158 140203 1 0.173733902794566
769328 769328 269159 269159 140203 1 0.171924798044066
958505 958505 344819 344819 140203 2 0.272727272727273
1660357 1660357 503230 503230 140203 4 0.277777777777778
1745140 1745140 534529 534529 140203 4 0.277777777777778
1746710 1746710 534988 534988 140203 1 0.173733902794566
1749244 1749244 535810 535810 140203 2 0.131473660030799 
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)
);