You will not be able to make an actual spiral around the tube. You can rotate the texture to make it look like it spirals around, but it won't actually do a coil/spiral.

The technical explanation goes quite deep if you're unfamiliar with advanced texture practices such as UV coordinates, and why this is often a pain point for those working in CAD programs.

I hope this simply answers your question rather than discourages you from trying to make it work. There's quite a few pages on this forum that get into some of the specifics of this. If this is your model, I believe it would actually be faster to model the detail you're trying to add with a texture.