consensus_index

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

22 rows where inventory_id = 226396

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
577896 577896 226396 226396 13150 4 0.10201907311558
577897 577897 226396 226396 53041 3 0.078499676335626
577898 577898 226396 226396 103570 12 0.143864357738418
577899 577899 226396 226396 140089 1 0.0204107383575683
577900 577900 226396 226396 274619 1 0.0155510387486234
577901 577901 226396 226396 284818 1 0.017187990195847
577902 577902 226396 226396 313847 4 0.0801219347166738
577903 577903 226396 226396 314160 3 0.0662091912370817
577904 577904 226396 226396 314544 1 0.0148441733509587
577905 577905 226396 226396 315061 2 0.0712638122007582
577906 577906 226396 226396 315125 2 0.024686508694552
577907 577907 226396 226396 315626 1 0.0326571813721092
577908 577908 226396 226396 315866 2 0.0296883467019175
577909 577909 226396 226396 315867 2 0.0314243874269362
577910 577910 226396 226396 316308 2 0.027600355784079
577911 577911 226396 226396 317291 1 0.0181428785400607
577912 577912 226396 226396 317399 1 0.081642953430273
577913 577913 226396 226396 317401 2 0.0280033020002951
577914 577914 226396 226396 317478 3 0.0406110529950309
577915 577915 226396 226396 317664 2 0.0195163987380836
577916 577916 226396 226396 317898 1 0.0136071589050455
577917 577917 226396 226396 332568 1 0.0362857570801213 
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)
);