consensus_index

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

27 rows where inchi_id = 240429

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15798 15798 4798 4798 240429 1 0.3125
110176 110176 38596 38596 240429 1 0.3125
171744 171744 61275 61275 240429 1 0.0985660676072495
211256 211256 74040 74040 240429 2 0.204986973963682
423318 423318 153196 153196 240429 1 0.3125
511725 511725 205953 205953 240429 2 0.204986973963682
550722 550722 217662 217662 240429 2 0.165478883579662
663724 663724 237873 237873 240429 2 0.204986973963682
715782 715782 253262 253262 240429 1 0.3125
818333 818333 284109 284109 240429 1 0.310344827586207
818335 818335 284110 284110 240429 1 0.3125
818338 818338 284111 284111 240429 1 0.238095238095238
948716 948716 340196 340196 240429 1 0.3
1073792 1073792 377012 377012 240429 1 0.3125
1073794 1073794 377013 377013 240429 1 0.3125
1073796 1073796 377014 377014 240429 1 0.3125
1300076 1300076 424965 424965 240429 1 0.3125
1300078 1300078 424966 424966 240429 1 0.3125
1300080 1300080 424967 424967 240429 1 0.3125
1300082 1300082 424968 424968 240429 1 0.3125
1300084 1300084 424969 424969 240429 1 0.3125
1509057 1509057 465649 465649 240429 1 0.3125
1509059 1509059 465650 465650 240429 1 0.3125
1509061 1509061 465651 465651 240429 1 0.3125
1601736 1601736 483824 483824 240429 1 0.3125
1609055 1609055 485904 485904 240429 1 0.3125
1715574 1715574 525526 525526 240429 2 0.204986973963682 
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)
);