consensus_index

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

11 rows where inventory_id = 100626

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
297671 297671 100626 100626 16458 1 0.0265053823784939
297672 297672 100626 100626 19157 1 0.0291559206163433
297673 297673 100626 100626 75493 8 0.24517109129705
297674 297674 100626 100626 75990 2 0.291559206163433
297675 297675 100626 100626 140554 2 0.0971864020544778
297676 297676 100626 100626 149199 2 0.0651946204447312
297677 297677 100626 100626 149200 1 0.0416513151662048
297678 297678 100626 100626 149226 1 0.0728898015408583
297679 297679 100626 100626 149289 1 0.0364449007704292
297680 297680 100626 100626 149321 1 0.0323954673514926
297681 297681 100626 100626 188298 1 0.0485932010272389 
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)
);