consensus_index

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

29 rows where inventory_id = 427873

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1316928 1316928 427873 427873 50 1 0.0434081346911564
1316929 1316929 427873 427873 5026 1 0.0144693782303855
1316930 1316930 427873 427873 13102 1 0.0325561010183673
1316931 1316931 427873 427873 19292 1 0.0236771643769944
1316932 1316932 427873 427873 31986 1 0.0118385821884972
1316933 1316933 427873 427873 43529 1 0.0162780505091837
1316934 1316934 427873 427873 50396 1 0.0124023241974733
1316935 1316935 427873 427873 56841 1 0.00898099338437719
1316936 1316936 427873 427873 57219 1 0.0137078320077336
1316937 1316937 427873 427873 61367 10 0.167831653177846
1316938 1316938 427873 427873 75145 2 0.130224404073469
1316939 1316939 427873 427873 91291 2 0.0492201982585695
1316940 1316940 427873 427873 91427 1 0.0173632538764626
1316941 1316941 427873 427873 91431 1 0.0113238612237799
1316942 1316942 427873 427873 97057 1 0.0217040673455782
1316943 1316943 427873 427873 97370 1 0.0153205181262905
1316944 1316944 427873 427873 138664 1 0.0868162693823128
1316945 1316945 427873 427873 153141 1 0.0200345237036107
1316946 1316946 427873 427873 175261 1 0.0289387564607709
1316947 1316947 427873 427873 178281 1 0.00930174314810494
1316948 1316948 427873 427873 180035 1 0.0520897616293877
1316949 1316949 427873 427873 203079 1 0.0104179523258775
1316950 1316950 427873 427873 203382 1 0.0651122020367346
1316951 1316951 427873 427873 207203 1 0.0130224404073469
1316952 1316952 427873 427873 210591 1 0.0108520336727891
1316953 1316953 427873 427873 219653 1 0.0260448808146938
1316954 1316954 427873 427873 232687 1 0.0100172618518053
1316955 1316955 427873 427873 234514 1 0.0186034862962099
1316956 1316956 427873 427873 259706 1 0.0520897616293877 
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)
);