consensus_index

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

12 rows where inventory_id = 79424

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
232112 232112 79424 79424 36971 4 0.237642968925244
232113 232113 79424 79424 50973 2 0.118821484462622
232114 232114 79424 79424 112993 2 0.042009738707086
232115 232115 79424 79424 137922 1 0.0594107422313111
232116 232116 79424 79424 140556 2 0.0560129849427814
232117 232117 79424 79424 169174 4 0.237642968925244
232118 232118 79424 79424 203709 1 0.0396071614875407
232119 232119 79424 79424 208385 2 0.0613591507327172
232120 232120 79424 79424 243871 1 0.0475285937850489
232121 232121 79424 79424 254620 2 0.0265692916445858
232122 232122 79424 79424 289179 1 0.0339489955607492
232123 232123 79424 79424 308003 2 0.0299401998380594 
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)
);