consensus_index

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

9 rows where inventory_id = 39497

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
113065 113065 39497 39497 14089 4 0.176297321215336
113066 113066 39497 39497 45335 1 0.0390210115761224
113067 113067 39497 39497 110253 7 0.273608619193441
113068 113068 39497 39497 165077 1 0.0557443022516034
113069 113069 39497 39497 259977 2 0.159302612681226
113070 113070 39497 39497 265948 2 0.0872536344350158
113071 113071 39497 39497 285524 3 0.0996738974410686
113072 113072 39497 39497 296954 1 0.0487762644701529
113073 113073 39497 39497 310062 1 0.0433566795290248 
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)
);