consensus_index

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

12 rows where inventory_id = 244000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
683501 683501 244000 244000 11051 6 0.202858409313507
683502 683502 244000 244000 168510 3 0.172265467461653
683503 683503 244000 244000 181051 2 0.157878962367302
683504 683504 244000 244000 185080 4 0.0415727189870719
683505 683505 244000 244000 187220 3 0.0714752278412093
683506 683506 244000 244000 203237 2 0.13672719213321
683507 683507 244000 244000 216034 2 0.0326840503423147
683508 683508 244000 244000 237785 2 0.0432369345220401
683509 683509 244000 244000 243336 2 0.0499257115704682
683510 683510 244000 244000 281376 1 0.0303838204740468
683511 683511 244000 244000 323194 2 0.0274831996936177
683512 683512 244000 244000 334465 2 0.0249628557852341 
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)
);