On 1/6/2015 2:19 PM, Jeff Janes wrote:
I suppose there could be a gene table which would contain data about each gene_id.
But I'm an IT guy, not a biologist, and my sample_gene table doesn't actually
exist. I'm more concerned with how to deal with many-to-many relationships
when each parent could have tens of thousands of children. Collapsing all
the children into an array for each parent looked intriguing - but maybe it's
not a good idea. I just don't know, so I thought I'd ask you guys.
Yes, it's shorthand for the full range of values from 1 to 30475. Wasn't sure how
to represent it, and almost went with (1,2,3...30475). Apologies...
Michael Heaney
JCVI