consensus_index

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

28 rows where inchi_id = 85225

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19505 19505 5743 5743 85225 5 0.382978723404255
24052 24052 7051 7051 85225 2 0.252429653492726
97609 97609 34644 34644 85225 5 0.384615384615385
119158 119158 41477 41477 85225 2 0.252429653492726
129256 129256 46093 46093 85225 5 0.384615384615385
129265 129265 46095 46095 85225 2 0.252429653492726
129974 129974 46301 46301 85225 1 0.0312498017526097
218004 218004 75605 75605 85225 6 0.342857142857143
218024 218024 75609 75609 85225 1 0.0725097884376339
256207 256207 86925 86925 85225 2 0.272727272727273
427652 427652 154180 154180 85225 6 0.384615384615385
427672 427672 154184 154184 85225 1 0.0725097884376339
445273 445273 159570 159570 85225 3 0.256761901328841
515108 515108 206557 206557 85225 1 0.0725097884376339
533111 533111 211480 211480 85225 1 0.0725097884376339
533121 533121 211482 211482 85225 8 0.388059701492537
667127 667127 238945 238945 85225 6 0.342857142857143
735109 735109 259319 259319 85225 8 0.388059701492537
735169 735169 259323 259323 85225 1 0.0312475406856484
742348 742348 261404 261404 85225 1 0.20625
760880 760880 266977 266977 85225 2 0.252429653492726
856682 856682 296353 296353 85225 6 0.384615384615385
856685 856685 296354 296354 85225 5 0.382978723404255
856688 856688 296355 296355 85225 3 0.378378378378378
924509 924509 328406 328406 85225 3 0.375
1613177 1613177 487042 487042 85225 5 0.382978723404255
1634655 1634655 494166 494166 85225 2 0.252429653492726
1718184 1718184 526214 526214 85225 5 0.382978723404255 
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)
);