consensus_index

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

25 rows where inventory_id = 78047

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
226818 226818 78047 78047 8133 6 0.145340929881245
226819 226819 78047 78047 136435 3 0.0666014945922278
226820 226820 78047 78047 137779 1 0.0169164069085527
226821 226821 78047 78047 139655 1 0.0129360758712462
226822 226822 78047 78047 151115 2 0.0173856720886011
226823 226823 78047 78047 167949 2 0.0185860652555268
226824 226824 78047 78047 168944 4 0.130761224463558
226825 226825 78047 78047 169441 3 0.0473788820368252
226826 226826 78047 78047 169456 3 0.219913289811185
226827 226827 78047 78047 173771 1 0.0199921172555623
226828 226828 78047 78047 189218 3 0.0174866471873943
226829 226829 78047 78047 195847 2 0.0224448061539251
226830 226830 78047 78047 232929 1 0.0244348099790206
226831 226831 78047 78047 237231 2 0.0138532351152017
226832 226832 78047 78047 244140 1 0.0146608859874123
226833 226833 78047 78047 257446 3 0.0389487903158325
226834 226834 78047 78047 257697 1 0.0199921172555623
226835 226835 78047 78047 258888 2 0.0214613395569087
226836 226836 78047 78047 271958 1 0.0219913289811185
226837 226837 78047 78047 282132 3 0.0304149804875303
226838 226838 78047 78047 290002 3 0.0251070132115937
226839 226839 78047 78047 291005 1 0.0137445806131991
226840 226840 78047 78047 309501 3 0.0151807634922965
226841 226841 78047 78047 320945 1 0.0104720614195802
226842 226842 78047 78047 327222 1 0.00999605862778114 
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)
);