consensus_index

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

27 rows where inchi_id = 17929

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
7570 7570 2266 2266 17929 1 0.227848101265823
29367 29367 8507 8507 17929 1 0.0226459031353793
53670 53670 16709 16709 17929 6 0.341968911917098
120019 120019 41789 41789 17929 1 0.0226459031353793
131856 131856 46831 46831 17929 1 0.0199611772534025
163733 163733 58638 58638 17929 5 0.339622641509434
203685 203685 72178 72178 17929 1 0.227848101265823
287257 287257 97305 97305 17929 1 0.172413793103448
322736 322736 108721 108721 17929 6 0.292035398230089
393542 393542 135790 135790 17929 2 0.314285714285714
506296 506296 202475 202475 17929 6 0.292035398230089
528394 528394 209917 209917 17929 6 0.292035398230089
574306 574306 225016 225016 17929 9 0.294478527607362
689126 689126 245751 245751 17929 9 0.294117647058824
711381 711381 252250 252250 17929 1 0.0226459031353793
774195 774195 270814 270814 17929 6 0.341968911917098
774199 774199 270815 270815 17929 3 0.336
811385 811385 282306 282306 17929 1 0.0226459031353793
868811 868811 299700 299700 17929 1 0.226415094339623
893131 893131 313345 313345 17929 3 0.336
906601 906601 319976 319976 17929 1 0.168674698795181
1625810 1625810 490951 490951 17929 1 0.0226459031353793
1648254 1648254 499103 499103 17929 1 0.172413793103448
1666645 1666645 505366 505366 17929 6 0.341968911917098
1707569 1707569 522095 522095 17929 1 0.230769230769231
1726022 1726022 528488 528488 17929 1 0.0226459031353793
1760940 1760940 540636 540636 17929 1 0.226415094339623 
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)
);