This looks as though it's an experimental project. The kind where you will experiment with different capacitor values, and charge it to different volt levels.
One cannot predict performance ahead of time.
As a rough idea, you'll probably need over 100,000 uF, in order to e noticeable magnetic force on a metal (ferrous) object held near one end of the coil. The force will last only for an instant.
There is a formula to convert capacitor charge to joules. A certain amount of joules will exert a certain amount of force on a metal object.
Do you really wish to burn the wires? Or do you wish to avoid burning the wires?
Have you tried an internet search to find websites where people tell about making their own coilguns and railguns?