consensus_index

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

14 rows where inventory_id = 29425

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
81682 81682 29425 29425 124780 4 0.275227061507512
81683 81683 29425 29425 141956 1 0.0458711769179187
81684 81684 29425 29425 169204 2 0.137613530753756
81685 81685 29425 29425 173848 1 0.0917423538358374
81686 81686 29425 29425 261889 2 0.079451209024816
81687 81687 29425 29425 263372 1 0.0275227061507512
81688 81688 29425 29425 264903 1 0.0393181516439303
81689 81689 29425 29425 285519 1 0.0550454123015025
81690 81690 29425 29425 286471 1 0.034403382688439
81691 81691 29425 29425 297852 2 0.0458711769179187
81692 81692 29425 29425 309930 1 0.0250206419552284
81693 81693 29425 29425 320927 2 0.0355316608548066
81694 81694 29425 29425 334405 1 0.0211713124236548
81695 81695 29425 29425 334607 2 0.0300297343490105 
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)
);