consensus_index

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

8 rows where inchi_id = 31687

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
342612 342612 115642 115642 31687 7 0.4125
393229 393229 135653 135653 31687 1 0.1375
697532 697532 248673 248673 31687 11 0.416666666666667
727670 727670 256909 256909 31687 1 0.173228346456693
790043 790043 275900 275900 31687 8 0.519685039370079
790046 790046 275901 275901 31687 4 0.506024096385542
906152 906152 319775 319775 31687 4 0.506024096385542
950161 950161 340813 340813 31687 1 0.168674698795181 
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)
);