trial_types

SELECT cvterm.cvterm_id AS trial_type_id,

    cvterm.name AS trial_type_name

   FROM (cvterm

     JOIN cv USING (cv_id))

  WHERE ((cv.name)::text = 'project_type'::text)

  GROUP BY cvterm.cvterm_id;