consensus_index

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

27 rows where inchi_id = 812

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
32462 32462 9561 9561 812 1 0.310344827586207
47826 47826 14720 14720 812 7 0.373413189865164
79805 79805 28804 28804 812 1 0.310344827586207
79807 79807 28805 28805 812 7 0.373413189865164
158388 158388 57064 57064 812 3 0.19930319730676
188638 188638 67168 67168 812 1 0.310344827586207
251842 251842 85567 85567 812 1 0.310344827586207
300783 300783 101827 101827 812 8 0.364626634022101
461459 461459 165823 165823 812 3 0.352119201842254
595358 595358 231885 231885 812 6 0.363180231252727
669858 669858 239898 239898 812 9 0.379293148122884
671744 671744 240423 240423 812 1 0.310344827586207
848092 848092 293323 293323 812 1 0.205110352595195
848096 848096 293324 293324 812 1 0.216068290949324
902799 902799 318102 318102 812 1 0.3
914860 914860 323904 323904 812 5 0.349328498040593
975836 975836 353351 353351 812 1 0.3
975838 975838 353352 353352 812 1 0.3
1185775 1185775 397356 397356 812 1 0.3
1185777 1185777 397357 397357 812 1 0.3
1438781 1438781 448316 448316 812 1 0.3
1438783 1438783 448317 448317 812 1 0.3
1590170 1590170 480014 480014 812 1 0.3
1632171 1632171 493310 493310 812 1 0.3
1654963 1654963 501446 501446 812 7 0.319332969519203
1728863 1728863 529457 529457 812 1 0.3
1742377 1742377 533673 533673 812 7 0.373413189865164 
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)
);