Magic Music Visuals

Is there a way to make video transparency? For example, can I import a logo intro animation video and just have the background transparent? Or import a video of particles and blend the particles with another background layer? Currently the only thing I had success with is using the transparency feat...