consensus_index

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

12 rows where inchi_id = 40654

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
117852 117852 41136 41136 40654 1 0.0973451327433628
132773 132773 47169 47169 40654 1 0.094302548491974
339618 339618 114559 114559 40654 1 0.0967741935483871
353850 353850 119747 119747 40654 1 0.466666666666667
696283 696283 248234 248234 40654 1 0.0973451327433628
787360 787360 274998 274998 40654 1 0.0963855421686747
787365 787365 274999 274999 40654 1 0.0973451327433628
872764 872764 301386 301386 40654 1 0.0963855421686747
872803 872803 301401 301401 40654 1 0.454545454545455
1680034 1680034 510349 510349 40654 1 0.470588235294118
1752043 1752043 536730 536730 40654 1 0.0973451327433628
1754802 1754802 537742 537742 40654 2 0.470588235294118 
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)
);