consensus_index

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

27 rows where inchi_id = 18931

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
7079 7079 2163 2163 18931 2 0.134423256001079
153845 153845 55298 55298 18931 2 0.134423256001079
154143 154143 55402 55402 18931 4 0.327586206896552
154149 154149 55406 55406 18931 2 0.327586206896552
154156 154156 55410 55410 18931 4 0.327868852459016
203122 203122 71983 71983 18931 2 0.133977653920583
214898 214898 74686 74686 18931 1 0.111553784860558
425652 425652 153601 153601 18931 1 0.111553784860558
514183 514183 206344 206344 18931 1 0.111553784860558
514189 514189 206345 206345 18931 1 0.111553784860558
537311 537311 213221 213221 18931 1 0.111553784860558
666519 666519 238580 238580 18931 1 0.112026359143328
741565 741565 261227 261227 18931 4 0.470588235294118
746859 746859 262696 262696 18931 4 0.321428571428571
753299 753299 264686 264686 18931 4 0.323529411764706
782228 782228 273514 273514 18931 2 0.42052772921983
782464 782464 273588 273588 18931 2 0.42052772921983
783182 783182 273794 273794 18931 2 0.42052772921983
783184 783184 273795 273795 18931 4 0.323529411764706
784234 784234 274136 274136 18931 4 0.470588235294118
787017 787017 274876 274876 18931 2 0.408628001184222
787792 787792 275140 275140 18931 4 0.321428571428571
788000 788000 275176 275176 18931 1 0.0714285714285714
797203 797203 278161 278161 18931 4 0.27906976744186
826137 826137 286735 286735 18931 1 0.191489361702128
846356 846356 293128 293128 18931 1 0.111553784860558
1748544 1748544 535574 535574 18931 8 0.9 
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)
);