consensus_index

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

12 rows where inventory_id = 168980

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
467703 467703 168980 168980 11051 6 0.282709209434086
467704 467704 168980 168980 168510 1 0.0706773023585215
467705 467705 168980 168980 181051 2 0.163222238169156
467706 467706 168980 168980 185080 4 0.0429797114074055
467707 467707 168980 168980 187220 3 0.0738942445970166
467708 467708 168980 168980 203237 2 0.141354604717043
467709 467709 168980 168980 216034 2 0.0337902135237929
467710 467710 168980 168980 237785 2 0.0447002508658637
467711 467711 168980 168980 243336 2 0.0516154037405004
467712 467712 168980 168980 281376 1 0.0314121343815651
467713 467713 168980 168980 323194 2 0.0284133446203293
467714 467714 168980 168980 334465 2 0.0258077018702502 
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)
);