home / zeropm-v0-0-4

consensus_index

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

31 rows where inchi_id = 41874

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
34887 34887 10332 10332 41874 1 0.3125
35334 35334 10495 10495 41874 1 0.258620689655172
39175 39175 11817 11817 41874 8 0.336835624829966
91342 91342 32581 32581 41874 1 0.3125
91591 91591 32684 32684 41874 1 0.0889563472893368
152534 152534 54881 54881 41874 2 0.263736263736264
152538 152538 54882 54882 41874 8 0.336835624829966
258704 258704 87593 87593 41874 1 0.310344827586207
260563 260563 88267 88267 41874 1 0.159840092346603
277790 277790 94191 94191 41874 7 0.406348452227496
446286 446286 159854 159854 41874 2 0.314285714285714
446967 446967 160161 160161 41874 1 0.258620689655172
453288 453288 162761 162761 41874 7 0.406348452227496
560440 560440 220435 220435 41874 7 0.406348452227496
574222 574222 224987 224987 41874 1 0.159840092346603
576333 576333 225911 225911 41874 1 0.310344827586207
687128 687128 245055 245055 41874 2 0.314285714285714
687132 687132 245056 245056 41874 1 0.0889563472893368
703354 703354 250467 250467 41874 8 0.336835624829966
771282 771282 269860 269860 41874 2 0.314285714285714
771284 771284 269861 269861 41874 1 0.304347826086957
771290 771290 269863 269863 41874 1 0.0889563472893368
774278 774278 270846 270846 41874 2 0.260869565217391
774281 774281 270847 270847 41874 1 0.253012048192771
799931 799931 279056 279056 41874 8 0.336835624829966
799934 799934 279057 279057 41874 7 0.406348452227496
899215 899215 316185 316185 41874 4 0.328649754076467
1635668 1635668 494492 494492 41874 2 0.314285714285714
1635672 1635672 494493 494493 41874 1 0.0889563472893368
1636523 1636523 494819 494819 41874 2 0.260869565217391
1644513 1644513 497778 497778 41874 8 0.336835624829966
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)
);
Powered by Datasette · Queries took 604.833ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website