consensus_index

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

15 rows where inventory_id = 79406

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
232063 232063 79406 79406 35702 1 0.046481758429285
232064 232064 79406 79406 36775 8 0.27889055057571
232065 232065 79406 79406 135599 2 0.062361822936963
232066 232066 79406 79406 137918 2 0.139445275287855
232067 232067 79406 79406 145955 1 0.0309878389528566
232068 232068 79406 79406 157515 2 0.0929635168585699
232069 232069 79406 79406 194715 1 0.055778110115142
232070 232070 79406 79406 196744 1 0.0309878389528566
232071 232071 79406 79406 207013 2 0.027889055057571
232072 232072 79406 79406 219149 2 0.0527053599878007
232073 232073 79406 79406 234955 1 0.0253536864159736
232074 232074 79406 79406 234956 1 0.046481758429285
232075 232075 79406 79406 242180 2 0.0348613188219637
232076 232076 79406 79406 258935 1 0.0398415072251014
232077 232077 79406 79406 320878 1 0.0253536864159736 
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)
);