consensus_index

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

15 rows where inchi_id = 187548

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
13897 13897 4267 4267 187548 4 0.320125648256355
17691 17691 5181 5181 187548 4 0.320125648256355
81333 81333 29308 29308 187548 4 0.320125648256355
173776 173776 62075 62075 187548 4 0.320125648256355
215004 215004 74705 74705 187548 4 0.326445991231555
397959 397959 137923 137923 187548 1 0.304347826086957
425713 425713 153612 153612 187548 4 0.326445991231555
537249 537249 213212 213212 187548 4 0.326445991231555
730188 730188 257583 257583 187548 4 0.320125648256355
846568 846568 293180 293180 187548 4 0.320125648256355
846572 846572 293181 293181 187548 2 0.314139685724475
852620 852620 294993 294993 187548 1 0.163917163433222
872387 872387 301168 301168 187548 2 0.314139685724475
1611204 1611204 486357 486357 187548 4 0.320125648256355
1717175 1717175 525909 525909 187548 4 0.320125648256355 
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)
);