consensus_index

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

9 rows where inventory_id = 61870

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
173199 173199 61870 61870 39724 2 0.213007048117794
173200 173200 61870 61870 117513 1 0.106503524058897
173201 173201 61870 61870 201136 2 0.0549981833323346
173202 173202 61870 61870 207122 1 0.0532517620294485
173203 173203 61870 61870 216077 1 0.0426014096235588
173204 173204 61870 61870 251422 1 0.213007048117794
173205 173205 61870 61870 260024 2 0.122979676570096
173206 173206 61870 61870 283030 2 0.0753093640823107
173207 173207 61870 61870 335178 2 0.035501174686299 
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)
);