consensus_index

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

25 rows where inchi_id = 111717

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28145 28145 8153 8153 111717 1 0.105263157894737
31726 31726 9328 9328 111717 6 0.406443397142934
100441 100441 35509 35509 111717 1 0.105263157894737
100449 100449 35511 35511 111717 6 0.406443397142934
137796 137796 49052 49052 111717 9 0.409215445741778
154815 154815 55682 55682 111717 2 0.0984455958549223
235528 235528 80324 80324 111717 1 0.105011933174224
248414 248414 84533 84533 111717 5 0.418333006514514
535603 535603 212567 212567 111717 3 0.414003226156891
558820 558820 219912 219912 111717 1 0.104347826086957
706147 706147 250998 250998 111717 2 0.0984455958549223
732166 732166 258189 258189 111717 9 0.409215445741778
802933 802933 279990 279990 111717 1 0.105011933174224
802938 802938 279991 279991 111717 1 0.104347826086957
802943 802943 279992 279992 111717 1 0.105263157894737
802948 802948 279993 279993 111717 2 0.0980392156862745
802954 802954 279994 279994 111717 1 0.104347826086957
850873 850873 294363 294363 111717 3 0.414003226156891
850877 850877 294364 294364 111717 6 0.406443397142934
850881 850881 294365 294365 111717 5 0.418333006514514
886484 886484 308961 308961 111717 1 0.103896103896104
1623944 1623944 490370 490370 111717 1 0.104712041884817
1628610 1628610 492020 492020 111717 4 0.403708651877515
1724926 1724926 528181 528181 111717 1 0.104712041884817
1728146 1728146 529234 529234 111717 5 0.418333006514514 
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)
);