GrainGenes SQL Interface

This page allows you to perform raw SQL queries directly. This is the ultimate power query. We don't know of any other Web-accessible databases that open this privilege to their users. It entails some risk but we're confident that it's minimal because we know our users are responsible. But, we hope, not timid. We want this interface to be used. Please click here for full information on how to use it.

Premade Queries:
SQL query: 
      Schema: Diagrams | Table definitions

[ TOP | <<25 | 1 - 25 of 27 | >>25 | BOTTOM  ]

Showing records 1 through 25 of 27 records
SSRPrimer_1Primer_2ConditionsSSR_SizeSequence
SCM1025' AACAAGTGCAGAACTCGCGT3' CAGAAAGTCTTGGGGCCAGAnnealing temperature = 60 degrees C208 
SCM1045' GATAGTGGGACATTTGGGTACG3' GCCATTCCCCATTAGTACGGAnnealing temperature = 60 degrees C173 
SCM1095' AACCCCCTTTCGTACCTTGT3' TAAAGCAAACCACCAGAGCCAnnealing temperature = 60 degrees C98 
SCM1205' CATTGTTGCGAGTGTTGAAGC3' TGTGCTGTCGTCGATGTTGTCAnnealing temperature = 60 degrees C127 
SCM1385' ATAGCCGCAGATGGTTGAGGAC3' GAGAAGTCTACAAATCAAGGGGGCAnnealing temperature = 60 degrees C188 
SCM1805' GTTTCGTCCCCGTTGCCATC3' ACGTGTCGCTTTCCATTGCCCAnnealing temperature = 60 degrees C140 
SCM25' GATGACTATGACTACCAGGATGAA3' GGAGTGAGAAGGCCGAGAAGAnnealing temperature = 55 degrees C113 
SCM2065' TCATCGAAAGACGGGACACCT3' ACGATTGCTGCTAATAGCCATGTGAnnealing temperature = 60 degrees C171 
SCM2435' AGTTGCCGCAGTATTTCCTCA3' AACTTAACAATGGTTTCGAGGGAnnealing temperature = 60 degrees C110 
SCM2565' CTAATTGCCTCACAGAACTATCA3' CCAGAGAACAACACAGATCAGCAnnealing temperature = 60 degrees C136 
SCM2685' GCGCACCCCACACAACACG3' GCGGTGGCGGTTGAGGACAnnealing temperature = 65 degrees C153 
SCM2735' GAGTGGTCGCCATATAACCGTG3' TTCGTGAATACCCTGTTTAGCAAGAnnealing temperature = 60 degrees C214 
SCM285' CTGGTCCTGGTCTGGTGGGTC3' CGCATCGGGTGTGTCGCATACAnnealing temperature = 60 degrees C159 
SCM3045' CATCGGATCACATTCACTTAGTTCTG3' TAACGCCACCACCAAGCCTTCAnnealing temperature = 60 degrees C267 
SCM3065' GTGTCGCGTGTCCTTCGGC3' AGCCAGCTGCGGTCACCCCAnnealing temperature = 65 degrees C188 
SCM3075' GTAATCAATCTACTACTCTTTCA3' CCTTCTGCTGTCATTGTTGGAnnealing temperature = 55 degrees C132 
SCM395' GACCTCAGTGGAGCCTCTAGGT3' GGACATCTGCCGTGACAATACCAnnealing temperature = 60 degrees C230 
SCM405' CCCTTCAGCGGTCATTGTTG3' CACATCTTGGGCCTGACACCAnnealing temperature = 60 degrees C159 
SCM435' CTAGGGGATTACAGGGAGGGCA3' GTTCCCTTGTCCTACTCGTTACCGAnnealing temperature = 60 degrees C100 
SCM55' TCGCGATACATCAAGATCGTG3' CTAGCATCGACGTAACCCTTTAnnealing temperature = 50 degrees C285 
SCM655' CCCGTCCTTCAGTTATGTATGG3' TTTGATCGATGAAGAGAGCCAAnnealing temperature = 60 degrees C295 
SCM695' CTACCTGCTGTTCCCATTTGG3' GTGTGTAGAAGATGTTGTCCTGGAnnealing temperature = 60 degrees C144 
SCM755' TTTTCTATCTCAGCGATTCATGC3' TCCTGAGATCAAGTGCGTGTGAnnealing temperature = 60 degrees C191 
SCM865' CAGATAGATGGGTGTTGTGCG3' CTCTTCTCGACATCCACACTCCAnnealing temperature = 60 degrees C117 
SCM95' TGACAACCCCCTTTCCCTCGT3' TCATCGACGCTAAGGAGGACCCAnnealing temperature = 60 degrees C220 

[ TOP | <<25 | 1 - 25 of 27 | >>25 | BOTTOM  ]