[Gmod-schema] Storing similar analyses

[Stephen F. <spf...@gm...>]

Hi All,

 

I'm curious how most folks are storing analysis records in the analysis
table.  It has a unique constraint with the program, programversion and
sourcename fields.  

 

So, say for instance I'm being precise in specifying those fields.  For
instance, if  I have a FASTA file that a I blasted against several protein
databases.  The program would be 'blastx', the programversion would be
'blastx 2.2.24 [Aug-08-2010]' and the sourcename is the file name of my
file.   

 

Those values will be the same for all of my blast jobs, so I'm limited to
only one analysis for the set of blast jobs performed.  I would like to have
a separate analysis record for each blast job individually.  

 

I could provide a unique description in the sourcename  field that would
allow me to do this, but that doesn't feel right.  But I can't see any other
way around this other than removing the unique constraint all together.  I
wanted to ask what other folks are doing?

 

Thanks for any input,

Stephen