consensus_index

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

12 rows where inventory_id = 67830

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
190246 190246 67830 67830 11785 1 0.142847252534837
190247 190247 67830 67830 63673 1 0.0952315016898915
190248 190248 67830 67830 75665 2 0.101008260941251
190249 190249 67830 67830 76186 10 0.285694505069675
190250 190250 67830 67830 145041 1 0.0259722277336068
190251 190251 67830 67830 149215 1 0.0476157508449458
190252 190252 67830 67830 149241 1 0.0408135007242392
190253 190253 67830 67830 188299 1 0.0317438338966305
190254 190254 67830 67830 195975 1 0.0571389010139349
190255 190255 67830 67830 200988 1 0.0285694505069675
190256 190256 67830 67830 201197 1 0.0357118131337093
190257 190257 67830 67830 201264 1 0.0952315016898915 
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)
);