consensus_index

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

19 rows where inventory_id = 199930

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
501711 501711 199930 199930 3633 3 0.167178496253911
501712 501712 199930 199930 13462 1 0.0126901639150969
501713 501713 199930 199930 62244 1 0.0200927595322368
501714 501714 199930 199930 136430 2 0.069603360748196
501715 501715 199930 199930 154077 1 0.0185471626451417
501716 501716 199930 199930 154188 1 0.0301391392983552
501717 501717 199930 199930 154256 1 0.0267903460429824
501718 501718 199930 199930 154436 2 0.120556557193421
501719 501719 199930 199930 154499 1 0.0241113114386842
501720 501720 199930 199930 167423 1 0.0482226228773683
501721 501721 199930 199930 169013 2 0.241113114386842
501722 501722 199930 199930 195129 2 0.045566095607418
501723 501723 199930 199930 200100 1 0.0219193740351674
501724 501724 199930 199930 218196 1 0.0401855190644736
501725 501725 199930 199930 231815 1 0.0160742076257894
501726 501726 199930 199930 240997 2 0.0254155538399711
501727 501727 199930 199930 275029 2 0.026307597564863
501728 501728 199930 199930 291081 1 0.0150695696491776
501729 501729 199930 199930 310230 2 0.0221028029572209 
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)
);