consensus_index

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

22 rows where inventory_id = 489218

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1620081 1620081 489218 489218 8133 6 0.159856606714013
1620082 1620082 489218 489218 136435 4 0.098745771147932
1620083 1620083 489218 489218 137779 1 0.018605904120775
1620084 1620084 489218 489218 151115 2 0.0191220363582175
1620085 1620085 489218 489218 167949 2 0.0323221407744418
1620086 1620086 489218 489218 168944 4 0.171032692660787
1620087 1620087 489218 489218 169441 3 0.0521107668603662
1620088 1620088 489218 489218 169456 3 0.133109907247867
1620089 1620089 489218 489218 189218 2 0.0195545765362924
1620090 1620090 489218 489218 195847 1 0.0201563961308395
1620091 1620091 489218 489218 237231 2 0.0215480938496278
1620092 1620092 489218 489218 244140 1 0.0161251169046716
1620093 1620093 489218 489218 257446 3 0.0389215729924631
1620094 1620094 489218 489218 257697 1 0.0219887957790977
1620095 1620095 489218 489218 258888 2 0.030473606565432
1620096 1620096 489218 489218 271958 1 0.0241876753570075
1620097 1620097 489218 489218 282132 3 0.0297027192980344
1620098 1620098 489218 489218 290002 2 0.0323221407744418
1620099 1620099 489218 489218 291005 1 0.0151172970981297
1620100 1620100 489218 489218 309501 2 0.0175475840168801
1620101 1620101 489218 489218 320945 1 0.011517940646194
1620102 1620102 489218 489218 327222 1 0.0109943978895488 
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)
);