consensus_index

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

22 rows where inventory_id = 226974

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
579848 579848 226974 226974 137043 1 0.0554131676541452
579849 579849 226974 226974 141173 1 0.0184710558847151
579850 579850 226974 226974 189117 1 0.0316646672309401
579851 579851 226974 226974 192032 2 0.221652670616581
579852 579852 226974 226974 217815 1 0.11082633530829
579853 579853 226974 226974 222711 2 0.040468055875988
579854 579854 226974 226974 235005 2 0.0904893238559689
579855 579855 226974 226974 235006 2 0.0350463644303737
579856 579856 226974 226974 237478 2 0.0272835577057459
579857 579857 226974 226974 243001 1 0.0170502054320447
579858 579858 226974 226974 243368 2 0.0247815219446523
579859 579859 226974 226974 259555 1 0.0158323336154701
579860 579860 226974 226974 264249 1 0.0147768447077721
579861 579861 226974 226974 275523 2 0.0639856145235412
579862 579862 226974 226974 276489 1 0.0221652670616581
579863 579863 226974 226974 288177 2 0.020944208710171
579864 579864 226974 226974 309430 1 0.0130383923892106
579865 579865 226974 226974 319447 1 0.0246280745129534
579866 579866 226974 226974 320759 1 0.0123140372564767
579867 579867 226974 226974 320961 1 0.0116659300324516
579868 579868 226974 226974 321738 1 0.0246280745129534
579869 579869 226974 226974 326254 1 0.011082633530829 
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)
);