consensus_index

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

11 rows where inventory_id = 243126

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
680507 680507 243126 243126 8438 3 0.103395962520469
680508 680508 243126 243126 120671 1 0.0442011522233719
680509 680509 243126 243126 135559 1 0.176804608893488
680510 680510 243126 243126 151707 3 0.111379924231668
680511 680511 243126 243126 166940 1 0.0442011522233719
680512 680512 243126 243126 201131 4 0.176804608893488
680513 680513 243126 243126 206142 2 0.0559105264918684
680514 680514 243126 243126 225036 1 0.0294674348155813
680515 680515 243126 243126 245584 2 0.102078188538622
680516 680516 243126 243126 261445 1 0.0884023044467439
680517 680517 243126 243126 343964 1 0.0589348696311626 
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)
);