Talk:Bklein7 Week 14

select propertytype.value from propertytype inner join dbreferencetype on

  (propertytype.dbreferencetype_property_hjid = dbreferencetype.hjid)
  where dbreferencetype.type = 'EnsemblBacteria' and propertytype.type = 'gene ID' order by propertytype.value;