consensus_index

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

10 rows where inventory_id = 305923

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
880666 880666 305923 305923 33460 4 0.33328924745404
880667 880667 305923 305923 136588 1 0.16664462372702
880668 880668 305923 305923 192090 1 0.0555482079090067
880669 880669 305923 305923 210396 1 0.0666578494908081
880670 880670 305923 305923 210397 1 0.0416611559317551
880671 880671 305923 305923 237581 1 0.0476127496362915
880672 880672 305923 305923 239009 1 0.0833223118635101
880673 880673 305923 305923 253755 1 0.111096415818013
880674 880674 305923 305923 310001 1 0.033328924745404
880675 880675 305923 305923 314090 1 0.0370321386060045 
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)
);