consensus_index

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

20 rows where inchi_id = 148985

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
26873 26873 7828 7828 148985 1 0.115384615384615
30832 30832 9014 9014 148985 2 0.176082580439468
101005 101005 35696 35696 148985 1 0.115384615384615
135011 135011 47852 47852 148985 1 0.0620676360942978
161621 161621 57998 57998 148985 2 0.176082580439468
229469 229469 78690 78690 148985 1 0.0745418200160667
243888 243888 82984 82984 148985 1 0.258620689655172
367993 367993 125148 125148 148985 1 0.266245718268997
435358 435358 156285 156285 148985 1 0.0745418200160667
577781 577781 226358 226358 148985 1 0.0745418200160667
685886 685886 244606 244606 148985 1 0.0747458177935282
717817 717817 253888 253888 148985 2 0.176082580439468
769601 769601 269219 269219 148985 1 0.115384615384615
821543 821543 285246 285246 148985 2 0.176082580439468
821546 821546 285247 285247 148985 1 0.253012048192771
905199 905199 319336 319336 148985 1 0.113207547169811
948005 948005 339889 339889 148985 1 0.253012048192771
1621569 1621569 489659 489659 148985 1 0.115384615384615
1628130 1628130 491845 491845 148985 2 0.176082580439468
1723519 1723519 527811 527811 148985 1 0.113207547169811 
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)
);