mustard update inventory

[GoogleCodeExporter]

seems like this should have a primary gp
http://www.cwrdiversity.org/checklist/genepool-details.php?id[]=2157
if B juncea is listed as confirmed in breeding uses

Original issue reported on code.google.com by colin.kh...@gmail.com on 5 Aug 2013 at 2:18

[GoogleCodeExporter]

There are only 3 potential breeding use taxa associated with this crop.

Original comment by holly.vi...@gmail.com on 6 Aug 2013 at 1:05

[GoogleCodeExporter]

what i mean is that B juncea is listed in both confirmed and potential use. 
that being the case, it seems like a gap that it isn't listed as in the 
genepool (primary)...

Original comment by colin.kh...@gmail.com on 6 Aug 2013 at 1:09

[GoogleCodeExporter]

Well B. juncea is associated as having breeding use for B. carinata (and 
appears in GP2 courtesy of GRIN) and potential in improving B. napus (also 
appears in GP2 for B. napus). I don't know why all of those species are coming 
out in the breeding section for B. juncea crop, as in the db, there's only 3 
potentials associated:
Sinapis alba
Trachystoma ballii 
iplotaxis muralis 

Original comment by holly.vi...@gmail.com on 6 Aug 2013 at 1:24

[GoogleCodeExporter]

my guess is that the breeding uses are associated with the 'main crop' in 
Brassica, with all other crops in the genus (accidentally) listing the breeding 
uses for this main crop...will investigate

Original comment by colin.kh...@gmail.com on 6 Aug 2013 at 1:31

[GoogleCodeExporter]

select DISTINCT b.ID, b.Pot_Conf, b.Description, ref.Ref, sp2.*
          from Breeding_data b
          inner join concepts c on c.Crop_ID = b.Crop_ID
          inner join species sp on b.Taxon_ID = sp.Taxon_ID
          inner join Breeding_ref ref on b.Ref_ID = ref.ID
          INNER JOIN species sp2 ON sp.Valid_Taxon_ID = sp2.Taxon_ID
          where c.Taxon_ID = " . $cropID . "
          ORDER BY b.Pot_Conf, sp2.Genus, sp2.Species, sp2.Species_Author, sp2.Subsp, sp2.Subsp_Author, sp2.Var, sp2.Var_Author,
                 sp2.Form, sp2.Form_Author";

Original comment by alexgcv@gmail.com on 6 Aug 2013 at 1:57

[GoogleCodeExporter]

select DISTINCT b.ID, b.Pot_Conf, b.Description, ref.Ref, sp2.*
          from Breeding_data b
          inner join concepts c on c.Crop_ID = b.Crop_ID
          inner join species sp on b.Taxon_ID = sp.Taxon_ID
          inner join Breeding_ref ref on b.Ref_ID = ref.ID
          INNER JOIN species sp2 ON sp.Valid_Taxon_ID = sp2.Taxon_ID

          //I think here you need to change to this:
          where c.Crop_ID = b.Crop_ID
          //

          ORDER BY b.Pot_Conf, sp2.Genus, sp2.Species, sp2.Species_Author, sp2.Subsp, sp2.Subsp_Author, sp2.Var, sp2.Var_Author,
                 sp2.Form, sp2.Form_Author";

Original comment by holly.vi...@gmail.com on 6 Aug 2013 at 2:05

[GoogleCodeExporter]

fixed

Original comment by colin.kh...@gmail.com on 6 Aug 2013 at 3:58

• Changed state: Verified