consensus_index

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

9 rows where inventory_id = 79602

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
232745 232745 79602 79602 38851 8 0.305491574736332
232746 232746 79602 79602 112334 1 0.152745787368166
232747 232747 79602 79602 137948 2 0.152745787368166
232748 232748 79602 79602 195164 1 0.0509152624560553
232749 232749 79602 79602 195392 1 0.0610983149472663
232750 232750 79602 79602 200824 1 0.101830524912111
232751 232751 79602 79602 229938 1 0.0763728936840829
232752 232752 79602 79602 233396 1 0.0381864468420415
232753 232753 79602 79602 282706 1 0.0436416535337617 
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)
);