I don't know about Canon white balance numbers, but Nikon white balance numbers do not correlate to Adobe's white balance numbers.
Which is to be expected (the numbers have quite a range of values that can describe the same color)! Plus each converter is unique in how it renders the data so YMMV. 5500K isn't an exact color, it's a pretty significant possible range of colors. The values are correlated color temp values (CCT).