No. The plus (red?) motor lead connects to the positive motor supply lead (6V). Don't power the motor with the Arduino 5V. The minus lead (black?) connects to the collector of the transistor. The emmitter of the transistor connects to the ground of the motor supply. And the Ground of the motor supply also must connect to Arduino's ground. Pin 9 connects to the base resistor.
Do you have or can you get a L298 (or L293) driver?