consensus_index

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

26 rows where inchi_id = 122235

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27307 27307 7924 7924 122235 3 0.313010237043339
43868 43868 13382 13382 122235 1 0.0501268641761312
102747 102747 36186 36186 122235 3 0.313010237043339
158915 158915 57197 57197 122235 4 0.206059864037631
162692 162692 58264 58264 122235 1 0.0511418323223911
229217 229217 78640 78640 122235 4 0.380952380952381
230878 230878 79033 79033 122235 5 0.132815782566418
435188 435188 156253 156253 122235 3 0.375
435784 435784 156385 156385 122235 2 0.312122078808119
469101 469101 169647 169647 122235 2 0.630993034743972
565356 565356 222059 222059 122235 4 0.206059864037631
578326 578326 226524 226524 122235 3 0.375
697972 697972 248812 248812 122235 5 0.301033328943001
719108 719108 254262 254262 122235 4 0.0505478578366192
790780 790780 276106 276106 122235 4 0.300656214188731
790786 790786 276107 276107 122235 2 0.200011683399441
790795 790795 276108 276108 122235 5 0.132815782566418
790804 790804 276109 276109 122235 4 0.208530760273729
790811 790811 276110 276110 122235 2 0.312122078808119
790816 790816 276111 276111 122235 2 0.312122078808119
823757 823757 285936 285936 122235 1 0.0391774413836672
823766 823766 285937 285937 122235 1 0.0511418323223911
915729 915729 324505 324505 122235 2 0.312122078808119
1622214 1622214 489802 489802 122235 4 0.306379582771296
1723981 1723981 527929 527929 122235 2 0.312122078808119
1738017 1738017 532385 532385 122235 1 0.0511418323223911 
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)
);