genotyping_protocols

SELECT nd_protocol.nd_protocol_id AS genotyping_protocol_id,

    nd_protocol.name AS genotyping_protocol_name

   FROM nd_protocol

  WHERE (nd_protocol.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

          WHERE ((cvterm.name)::text = 'genotyping_experiment'::text)))

  GROUP BY nd_protocol.nd_protocol_id, nd_protocol.name;