consensus_index

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

27 rows where inchi_id = 18874

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14122 14122 4338 4338 18874 4 0.224420826871039
28112 28112 8144 8144 18874 4 0.224420826871039
107127 107127 37710 37710 18874 4 0.224420826871039
107136 107136 37712 37712 18874 2 0.182536947682992
146516 146516 52374 52374 18874 2 0.182536947682992
180618 180618 64506 64506 18874 4 0.224420826871039
235380 235380 80284 80284 18874 4 0.171870494220122
252254 252254 85706 85706 18874 2 0.1836658200277
254165 254165 86353 86353 18874 1 0.250105371722469
324093 324093 109206 109206 18874 6 0.620689655172414
350328 350328 118380 118380 18874 3 0.378378378378378
436858 436858 156680 156680 18874 4 0.171870494220122
443607 443607 159023 159023 18874 2 0.184521679995463
444244 444244 159258 159258 18874 1 0.250105371722469
471830 471830 171025 171025 18874 6 0.620689655172414
481942 481942 176958 176958 18874 4 0.384615384615385
594024 594024 231463 231463 18874 2 0.0740978468125391
706080 706080 250980 250980 18874 4 0.224420826871039
802832 802832 279960 279960 18874 4 0.224420826871039
802837 802837 279961 279961 18874 2 0.157517899761337
802842 802842 279962 279962 18874 2 0.157517899761337
862063 862063 297973 297973 18874 2 0.375
862188 862188 298006 298006 18874 2 0.182536947682992
951748 951748 341443 341443 18874 2 0.157068062827225
1623877 1623877 490351 490351 18874 4 0.224420826871039
1724891 1724891 528172 528172 18874 4 0.224420826871039
1729022 1729022 529501 529501 18874 2 0.182536947682992 
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)
);