Orbital Control of Long-Range Transport in Conjugated and Metal-Centered Molecular Electronic Junctions