consensus_index

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

25 rows where inventory_id = 199235

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
501064 501064 199235 199235 18897 1 0.0715885620116132
501065 501065 199235 199235 22667 5 0.148125857467583
501066 501066 199235 199235 139287 1 0.0477257080077421
501067 501067 199235 199235 142097 1 0.0260322043678594
501068 501068 199235 199235 168535 1 0.0119314270019355
501069 501069 199235 199235 169158 3 0.0453353302039203
501070 501070 199235 199235 189089 2 0.0572708496092906
501071 501071 199235 199235 192014 2 0.143177124023226
501072 501072 199235 199235 195253 1 0.0178971405029033
501073 501073 199235 199235 216837 2 0.0275544503655354
501074 501074 199235 199235 224753 2 0.0954514160154843
501075 501075 199235 199235 231931 1 0.0286354248046453
501076 501076 199235 199235 237605 2 0.0312438099344055
501077 501077 199235 199235 240426 2 0.0220927098747217
501078 501078 199235 199235 240555 1 0.0357942810058066
501079 501079 199235 199235 242999 1 0.0220272498497271
501080 501080 199235 199235 262587 1 0.0190902832030969
501081 501081 199235 199235 265815 2 0.0218980566541766
501082 501082 199235 199235 270109 2 0.0193059994648684
501083 501083 199235 199235 284059 1 0.0168443675321443
501084 501084 199235 199235 309835 2 0.0193059994648684
501085 501085 199235 199235 320456 1 0.0204538748604609
501086 501086 199235 199235 321733 1 0.0124501846976719
501087 501087 199235 199235 334355 2 0.0165326702193212
501088 501088 199235 199235 334567 2 0.0155756177396324 
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)
);