consensus_index

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

14 rows where inventory_id = 87061

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
257069 257069 87061 87061 24864 1 0.0217890782638223
257070 257070 87061 87061 56057 3 0.141629008714845
257071 257071 87061 87061 73961 1 0.018883867828646
257072 257072 87061 87061 119998 1 0.0566516034859381
257073 257073 87061 87061 124628 3 0.0472096695716151
257074 257074 87061 87061 136700 2 0.141629008714845
257075 257075 87061 87061 141033 1 0.0944193391432302
257076 257076 87061 87061 164459 1 0.0202327155306922
257077 257077 87061 87061 170780 1 0.0314731130477434
257078 257078 87061 87061 170797 1 0.0354072521787113
257079 257079 87061 87061 173492 1 0.0283258017429691
257080 257080 87061 87061 239058 1 0.0257507288572446
257081 257081 87061 87061 242698 3 0.283258017429691
257082 257082 87061 87061 248396 1 0.0404654310613844 
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)
);