consensus_index

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

20 rows where inchi_id = 85234

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2702 2702 745 745 85234 3 0.454545454545455
6975 6975 2133 2133 85234 3 0.454545454545455
119569 119569 41624 41624 85234 6 0.259419394688079
165017 165017 59048 59048 85234 6 0.259419394688079
218042 218042 75614 75614 85234 6 0.297596337275849
293951 293951 99505 99505 85234 9 0.344827586206897
319915 319915 107813 107813 85234 1 0.310344827586207
515112 515112 206558 206558 85234 3 0.187190310148651
515123 515123 206560 206560 85234 5 0.120904757840681
533101 533101 211478 211478 85234 4 0.295566502463054
543220 543220 214893 214893 85234 6 0.341968911917098
575563 575563 225458 225458 85234 1 0.304347826086957
687830 687830 245299 245299 85234 2 0.184138505033529
735214 735214 259331 259331 85234 9 0.214285714285714
866872 866872 299184 299184 85234 1 0.3
882064 882064 306583 306583 85234 3 0.294599018003273
1613263 1613263 487049 487049 85234 6 0.259419394688079
1718205 1718205 526220 526220 85234 3 0.294599018003273
1738818 1738818 532624 532624 85234 3 0.454545454545455
1747674 1747674 535291 535291 85234 1 0.3125 
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)
);