consensus_index

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

10 rows where inventory_id = 96642

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
285148 285148 96642 96642 7045 1 0.102081305319524
285149 285149 96642 96642 51434 8 0.306243915958573
285150 285150 96642 96642 173292 2 0.153121957979287
285151 285151 96642 96642 257993 1 0.102081305319524
285152 285152 96642 96642 278082 1 0.0765609789896433
285153 285153 96642 96642 279716 1 0.0340271017731748
285154 285154 96642 96642 287895 2 0.0684782213779102
285155 285155 96642 96642 308342 2 0.0559122336230756
285156 285156 96642 96642 309515 2 0.0472544621379172
285157 285157 96642 96642 326540 2 0.0409235646536062 
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)
);