consensus_index

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

11 rows where inventory_id = 1435

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4702 4702 1435 1435 119793 1 0.202510387359871
4703 4703 1435 1435 124276 1 0.101255193679935
4704 4704 1435 1435 192351 2 0.0584597133279584
4705 4705 1435 1435 201303 5 0.127775416238239
4706 4706 1435 1435 213438 1 0.0405020774719742
4707 4707 1435 1435 215238 3 0.127573549928533
4708 4708 1435 1435 216017 1 0.0506275968399677
4709 4709 1435 1435 223498 1 0.0675034624532903
4710 4710 1435 1435 226038 1 0.0289300553371244
4711 4711 1435 1435 231927 2 0.116919426655917
4712 4712 1435 1435 270524 1 0.0337517312266451 
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)
);