consensus_index

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

13 rows where inventory_id = 74661

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
214786 214786 74661 74661 1688 2 0.133513299210001
214787 214787 74661 74661 27975 1 0.0467199224200054
214788 214788 74661 74661 44863 1 0.054506576156673
214789 214789 74661 74661 51026 1 0.0251568813030798
214790 214790 74661 74661 76684 1 0.0654078913880076
214791 214791 74661 74661 76685 9 0.302797563100949
214792 214792 74661 74661 116272 1 0.0817598642350095
214793 214793 74661 74661 169774 1 0.109013152313346
214794 214794 74661 74661 185740 1 0.036337717437782
214795 214795 74661 74661 199768 1 0.0272532880783365
214796 214796 74661 74661 220765 1 0.0297308597218216
214797 214797 74661 74661 254209 1 0.0327039456940038
214798 214798 74661 74661 314502 1 0.0408799321175047 
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)
);