consensus_index

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

14 rows where inventory_id = 49799

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
139822 139822 49799 49799 37895 1 0.0776294369899904
139823 139823 49799 49799 62334 50 0.229682068772805
139824 139824 49799 49799 107774 2 0.104150818898793
139825 139825 49799 49799 126157 1 0.0388147184949952
139826 139826 49799 49799 136845 16 0.126983251980052
139827 139827 49799 49799 160626 2 0.054892301315316
139828 139828 49799 49799 177262 1 0.0332697587099959
139829 139829 49799 49799 194792 1 0.0582220777424928
139830 139830 49799 49799 195367 2 0.0440117538628871
139831 139831 49799 49799 195561 2 0.0368228751547343
139832 139832 49799 49799 197896 1 0.0291110388712464
139833 139833 49799 49799 197897 1 0.0258764789966635
139834 139834 49799 49799 217751 1 0.0776294369899904
139835 139835 49799 49799 284927 2 0.0601315033275381 
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)
);