consensus_index

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

12 rows where inventory_id = 53673

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
149418 149418 53673 53673 1631 2 0.0433501299816219
149419 149419 53673 53673 2185 5 0.124490557496992
149420 149420 53673 53673 111030 3 0.21675064990811
149421 149421 53673 53673 111218 1 0.0361251083180183
149422 149422 53673 53673 132427 1 0.0309643785583014
149423 149423 53673 53673 188291 2 0.0294960274273057
149424 149424 53673 53673 188293 3 0.0722502166360365
149425 149425 53673 53673 220424 1 0.0270938312385137
149426 149426 53673 53673 229749 3 0.108375324954055
149427 149427 53673 53673 230325 2 0.21675064990811
149428 149428 53673 53673 288985 1 0.0309643785583014
149429 149429 53673 53673 295033 1 0.021675064990811 
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)
);