consensus_index

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

10 rows where inventory_id = 36754

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
104248 104248 36754 36754 22077 4 0.33328924745404
104249 104249 36754 36754 136886 1 0.16664462372702
104250 104250 36754 36754 139333 1 0.0833223118635101
104251 104251 36754 36754 189102 1 0.0666578494908081
104252 104252 36754 36754 237487 1 0.0416611559317551
104253 104253 36754 36754 239237 1 0.111096415818013
104254 104254 36754 36754 260165 1 0.0555482079090067
104255 104255 36754 36754 296169 1 0.0476127496362915
104256 104256 36754 36754 309882 1 0.0370321386060045
104257 104257 36754 36754 320870 1 0.033328924745404 
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)
);