GrainGenes 2.0

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:	-- Microsatellites from oat select distinct probe.name as SSR, pr.primeronesequence as Primer_1, pr.primertwosequence as Primer_2, pr.ampconditions as Conditions, prSSR.size as SSR_Size, sequence.name as Sequence from probe inner join probetype on probe.id = probetype.probeid and probetype.type = 'SSR' inner join probesourcespecies on probe.id = probesourcespecies.probeid inner join species on species.id = probesourcespecies.speciesid and species.name like 'Avena%' -- Get primer sequences and conditions: inner join probeprimer pr on probe.id = pr.probeid and pr.primeronesequence is not null -- Get any size data: left join probeprimer prSSR on prSSR.probeid = probe.id and prSSR.sizetype = 'SSR_size' left join sequenceprobe on probe.id = sequenceprobe.probeid left join sequence on sequenceprobe.sequenceid = sequence.id
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 106 records

SSR	Primer_1	Primer_2	Conditions	SSR_Size	Sequence
AM1	5'GGA TCC TCC ACG CTG TTG A	5'CTC ATC CGT ATG GGC TTT A	Average melting temperature (degrees C) = 46	204
AM10	5'AAA ATC GGG GAA GGA AAC C	5'GAA GGC AAA ATA CAT GGA GTC AC	Average melting temperature (degrees C) = 46	186
AM100	5' CGCTGTCCAATGTTCCACTCCTG	5' CAGTTGATAACCAAAAGGCTGATTGTG	58	181
AM101	5' CGCTTATCACCCACAGACCGAC	5' CACAATCTGCCTTTGGTTATCAACTG	58	209
AM102	5' TGGTCAGCAAGCATCACAAT	5' TGTGCATGCATCTGTGCTTA	55	213
AM103	5' CAACAACTTGGATGCAACAGA	5' CATCAACGTGAGGTTCTCCA	58	212
AM104	5' AACAATGATGGGGATGGTGT	5' GTCGTGAGCAAGTTGAACCA	55	186
AM105	5' GTCGCGGGTAGCTTAATGG	5' ACTGTGATCCAAGTCGTCCA	58	192
AM106	5' CAAGCATCTGCAGACTCACC	5' GGGAACCAGTTAGGCTCAAA	58	166
AM107	5' CCGTGGTATGAGTGCTAATGAA	5' TTTTCATGAGGTTGTCCTTGG	58	263
AM108	5' ATCCCAAGTACACCCCTTCC	5' GCACAATGGCATGACGTAAC	55	192
AM109	5' ACCCCTGTCAGAGGAACGTC	5' GGGACACATGCAAGAACCTA	58	178
AM11	5'TCG TGG CAG AGA ATC AAA GAC AC	5'TGG GTG GAG GCA AAA ACA AAA C	Average melting temperature (degrees C) = 49	225
AM110	5' TTCATCGCTGTGACCATGTG	5' TCCGTGAGTTCCCTCAGTTC	58	193
AM111	5' CAAGTGGGCGGAGTTAGGTA	5' TCTTCGGTGTGAGTTTCCAA	58	235
AM112	5' AGCGGTGTAGGGGAAAGAGT	5' TTCTTGGTTTAGATGGGAGGA	55	234
AM113	5' ATCAAAGATCGCCTCGAGTT	5' GGTCCAACATAGGCACAAGG	55	228
AM114	5' TTCGACAGTGAGTTATCCTTGC	5' CAATGCATGGCACAGTCAA	55	206
AM115	5' CGCAACTCTTCCTACTTTTTGTT	5' TGGCAAACTCCCTCGATTTA	55	214
AM116	5' TCGAAAATCAGAAGTTATACAACAAAA	5' TCAATCTCAAGAACCTGGTAAGCA	60	238
AM117	5' CACTACCCGCAAAGTCATCA	5' AGGACACATTTCCAGCAAGG	58	237
AM118	5' TCCATTGCATGACCTCTTGA	5' ACTTCCCGCAAAATCATCAC	58	190
AM119	5' GCATTGGCTTTGTCCCTAAA	5' GTTTTGCCATTCGTGGACTT	58	118
AM12	5'TGC TGA AGT GAA CAA TCG C	5'CCT TCT CCA ACA ACT CTA C	Average melting temperature (degrees C) = 44	310
AM120	5' GCAAGCAAAGGACGAACAAT	5' TGGGAACCCAAATAGACCAA	58	268

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


GrainGenes is a product of the Agricultural Research Service of the US Department of Agriculture.