SELECT dbSNP, gene_id
FROM dbo.sequence
WHERE selected030405=1 AND gene_id='#URLgene_id#'
ORDER BY SNPper_Position;
E-bench
Find
INTRON
BOUNDARY
EXON
repeat
CpG
PROMOTER
SNP
CRYPTIC
TF SITE
ARE
ESE
SELECT
#dbsnp# |
#display#
",fastafile,1)#>
",fastafile,1)#>
SELECT gene_id, sequence_id, dbSNP, SNPper_Allele, SNPper_Position, SNPper_Role, SNPper_Function, dbsnp_submitter, selected030405
FROM dbo.sequence
WHERE (gene_id=#URLgene_id#)
ORDER BY SNPper_Position;
SELECT gene_id, SNPper_PositionStart, SNPper_PositionEnd, exon_nr, exon_id
FROM dbo.exon
WHERE (gene_id = #URLgene_id#);
SELECT gene_id, SNPper_PositionStart, SNPper_PositionEnd, exon_nr, exon_id
FROM dbo.exon
WHERE (gene_id = #URLgene_id#);
SELECT name, cdsStart, cdsEnd, exonStarts, exonEnds, exonCount
FROM dbo.[030807hg15acembly]
WHERE name LIKE '%#left(fasta,Find(">",fasta,1)-1)#%'
ORDER BY name ASC;
SELECT name, cdsStart, cdsEnd, exonStarts, exonEnds, exonCount
FROM dbo.[030807hg15acembly]
WHERE name LIKE '%#left(fasta,Find(">",fasta,1)-1)#%'
ORDER BY name ASC;
",TFfile,TFstart0+1)#>
",TFfile,TFstart1+1)#>
",TFfile,TFstart2+1)#>
",TFfile,TFend2+1)#>
",TFfile,TFend2+1)#>
","","ALL")#>
","","ALL")#>
#l[s][ss]#">
#l[s][ss]##highlight2#">
#l[s][ss]#">
#l[s][ss]#">
">
">
",P[i][ii],1)# is 0>
","","ALL")#>
",L[i_pos][iI_pos],1)#>
">
">
">
" & #Lline# & "" & #Lpost[Lpostcounter]# & #chr(10)#>
" & #Lline# & "" & #Lpost[Lpostcounter]# & #chr(10)#
& #Repeatstring(" ",len(Lpre[i])-len(Ppre[i])-1)# & " #Ppre[i]# #Pline# #Ppost[i]##chr(10)#">
#TQpre# #TQline# #chr(10)#">
#TQpre# #TQline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TRpre)-1)# & " #TRpre# #TRline# #chr(10)#">
#TQpre# #TQline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TRpre)-1)# & " #TRpre# #TRline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TSpre)-1)# & " #TSpre# #TSline# #chr(10)#">
#TQpre# #TQline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TRpre)-1)# & " #TRpre# #TRline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TSpre)-1)# & " #TSpre# #TSline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TTpre)-1)# & " #TTpre# #TTline# #chr(10)#">
#TQpre# #TQline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TRpre)-1)# & " #TRpre# #TRline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TSpre)-1)# & " #TSpre# #TSline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TTpre)-1)# & " #TTpre# #TTline# #chr(10)#"
& #Repeatstring(" ",len(Lpre[i])-len(TUpre)-1)# & " #TUpre# #TUline# #chr(10)#">
#MouseApre# #MouseAline# #chr(10)#">
#FuguApre# #FuguAline# #chr(10)#">
#errortrap#
#display#
SELECT selected030405,row_comment,stat030808
FROM #table#
WHERE #table#.dbsnp='#dbsnp#';
UPDATE #table#
SET stat030808='#comment#|#stat030808#'
WHERE #table#.dbsnp='#dbsnp#';
UPDATE #table#
SET selected030405=1,row_comment='#row_comment#|auto:#comment#'
WHERE #table#.dbsnp='#dbsnp#';