What Pingu said:
Weld on the rear section, cut out the rear beam. That rear structure has to support the rear hatch, so it’s already structurally significant. I suspect more so than the beam.
If it were me I’d ‘K’ frame it, as Pingu, CDS tube from turret to turret, two more tubes to form a K on its side. Probably box section would be more than adequate, panelled in say carbon, or similar, you could make a feature of it.
For your Targa roof.
You’ll struggle to tension it if you do it as a hood. Make it from fibreglass composite, light, solid and easy to seal. Use hood catches at the front and over centre clips at the rear. An awful lot less hassle. You’re only making one, so use balsa core for the pattern, overlay with glass cloth and diolen. Some strips of reinforcing core on the inside, covered with 2 layers of cloth. Paint, cloth/leather headlining, job done.