From: Sook J. <so...@gm...> - 2015-03-18 14:56:38
|
Hi Ethy, Our databases (GDR, CGD, CottonGen,etc) stores genetic maps from interspecific crosses and we just use featuremap_organism table (which is one of our custom tables that we recently submitted to Scott to be included in the next version of Chdo). For the interspecific population stored in stock table, we just use organism id for 'spp.' as species. 'spp.' is commonly used for multispecies and 'sp.' is for single species (when exact species not known).. I think we need to do something to directly store interspecific crosses to multiple species. We could create stock_organism table to store individual species and then store .spp for stock.organism_id but it could be confusing.. Cheers Sook On Wed, Mar 18, 2015 at 10:19 AM, Cannon, Ethalinda K [E CPE] < ekc...@ia...> wrote: > Hello, > > > We are storing genetic maps at PeanutBase that are created from multiple > species. Our favorite option at the moment is to attach the multiple > species to the stock record for the mapping population via a > new stock_organism linker table and leaving the field, stock.organism_id > blank. > > > Alternatively, we have considered creating a genus-level organism record > and using that for stock.organism_id (and potentially feature.organism_id, > which is a required field), then attaching multiple species via our > new stock_organism table. > > > Any better suggestions? Has anyone else out there had to deal with > interspecific crosses? > > > Ethy > > > > > ------------------------------------------------------------------------------ > Dive into the World of Parallel Programming The Go Parallel Website, > sponsored > by Intel and developed in partnership with Slashdot Media, is your hub for > all > things parallel software development, from weekly thought leadership blogs > to > news, videos, case studies, tutorials and more. Take a look and join the > conversation now. http://goparallel.sourceforge.net/ > _______________________________________________ > Gmod-schema mailing list > Gmo...@li... > https://lists.sourceforge.net/lists/listinfo/gmod-schema > > |