consensus_index

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

27 rows where inventory_id = 2973

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
9821 9821 2973 2973 51007 1 0.0339314488692327
9822 9822 2973 2973 52193 8 0.237520142084629
9823 9823 2973 2973 55057 1 0.0475040284169258
9824 9824 2973 2973 128257 1 0.0107963700947559
9825 9825 2973 2973 137481 2 0.118760071042315
9826 9826 2973 2973 137620 2 0.0593800355211573
9827 9827 2973 2973 173272 1 0.0118760071042315
9828 9828 2973 2973 181280 1 0.0215927401895117
9829 9829 2973 2973 181386 1 0.0197933451737191
9830 9830 2973 2973 181642 1 0.0296900177605786
9831 9831 2973 2973 182408 1 0.0169657244346164
9832 9832 2973 2973 185925 1 0.0148450088802893
9833 9833 2973 2973 186402 1 0.0339314488692327
9834 9834 2973 2973 189167 2 0.0559840343788112
9835 9835 2973 2973 195518 1 0.0237520142084629
9836 9836 2973 2973 199754 1 0.0158346761389753
9837 9837 2973 2973 200610 1 0.0263911268982921
9838 9838 2973 2973 205164 1 0.0182707801603561
9839 9839 2973 2973 206690 2 0.0559840343788112
9840 9840 2973 2973 208892 1 0.0131955634491461
9841 9841 2973 2973 218613 1 0.0139717730638017
9842 9842 2973 2973 231503 2 0.0183250768035652
9843 9843 2973 2973 235224 1 0.00989667258685954
9844 9844 2973 2973 241683 1 0.0125010601097173
9845 9845 2973 2973 248048 1 0.00950080568338516
9846 9846 2973 2973 308237 2 0.0165087910845099
9847 9847 2973 2973 314691 1 0.0475040284169258 
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)
);