consensus_index

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

16 rows where inventory_id = 78020

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
226699 226699 78020 78020 7801 3 0.107238033061497
226700 226700 78020 78020 130556 8 0.175761510480772
226701 226701 78020 78020 136391 2 0.13133923101019
226702 226702 78020 78020 197767 2 0.0587366897302667
226703 226703 78020 78020 197769 2 0.0485002253073699
226704 226704 78020 78020 197771 2 0.0415331116127218
226705 226705 78020 78020 227352 1 0.0201071311990307
226706 226706 78020 78020 229306 2 0.0928708608831319
226707 226707 78020 78020 230121 2 0.0415331116127218
226708 226708 78020 78020 245401 2 0.042990854844392
226709 226709 78020 78020 255538 2 0.0464354304415659
226710 226710 78020 78020 264660 1 0.0189243587755583
226711 226711 78020 78020 267987 2 0.0508674654406155
226712 226712 78020 78020 277630 2 0.0269030844949659
226713 226713 78020 78020 310149 1 0.0229795785131779
226714 226714 78020 78020 332546 1 0.0643428198368982 
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)
);