consensus_index

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

14 rows where inventory_id = 74151

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
212002 212002 74151 74151 60368 4 0.286331161666649
212003 212003 74151 74151 248612 1 0.0318145735185166
212004 212004 74151 74151 248616 2 0.116894207256942
212005 212005 74151 74151 248709 8 0.104736797616656
212006 212006 74151 74151 248958 2 0.0305230043911318
212007 212007 74151 74151 249086 2 0.116894207256942
212008 212008 74151 74151 249099 1 0.0357913952083311
212009 212009 74151 74151 249102 1 0.0409044516666642
212010 212010 74151 74151 264400 1 0.026030105606059
212011 212011 74151 74151 275192 2 0.027552228877603
212012 212012 74151 74151 284923 2 0.0342231196167931
212013 212013 74151 74151 308325 2 0.0522766787204941
212014 212014 74151 74151 320872 1 0.0286331161666649
212015 212015 74151 74151 326116 2 0.0584471036284708 
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)
);