consensus_index

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

18 rows where inventory_id = 65945

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
184716 184716 65945 65945 3548 3 0.10324826678595
184717 184717 65945 65945 58720 8 0.260169329377559
184718 184718 65945 65945 137316 3 0.0787931743392151
184719 184719 65945 65945 158843 1 0.0325211661721949
184720 184720 65945 65945 173361 3 0.0560517828493345
184721 184721 65945 65945 205783 3 0.11363942183389
184722 184722 65945 65945 210540 1 0.0216807774481299
184723 184723 65945 65945 214813 1 0.0260169329377559
184724 184724 65945 65945 214814 2 0.0322700337175979
184725 184725 65945 65945 226867 2 0.037167047053937
184726 184726 65945 65945 231221 1 0.0236517572161417
184727 184727 65945 65945 231968 3 0.0378798072779632
184728 184728 65945 65945 235208 2 0.0354045613165061
184729 184729 65945 65945 242191 2 0.028386801080442
184730 184730 65945 65945 242683 1 0.0325211661721949
184731 184731 65945 65945 287970 1 0.0260169329377559
184732 184732 65945 65945 308061 1 0.0236517572161417
184733 184733 65945 65945 320838 2 0.0245836908678383 
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)
);