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:	-- Wheat SNPs select probe.name as Probe, proberemark.remark as 'Linkage Group', probeprimer.primeronesequence as Primer1, probeprimer.primertwosequence as Primer2 from probe left join proberemark on proberemark.probeid = probe.id and proberemark.type = "Linkage_Group" left join probeprimer on probeprimer.probeid = probe.id join probetype on probetype.probeid = probe.id join probesourcespecies on probesourcespecies.probeid = probe.id join species on species.id = probesourcespecies.speciesid where probetype.type = 'SNP' and species.name = 'Triticum aestivum' order by probe.name
	Schema: Diagrams \| Table definitions

[ TOP | <<2500 | <<250 | <<25 | 1 - 25 of 3407 | >>25 | >>250 | >>2500 | BOTTOM ]

Showing records 1 through 25 of 3407 records

Probe	Linkage Group	Primer1	Primer2
AF085169-3B	3B	AF085169B_F1_UMN GGAATCTGGAGTGACATTTGC	AF085169B_R1_UMN TGCAGCTGGTAATCTGCATT
AJ612027-5A	5A	AJ612027A_F1 TGATGGTCTAATTGGCTTATCA	AJ612027_cpR1 TGAAACACAAGAGGTCACTGC
AJ612027-5B	5B	AJ612027B_R1 ACAACAGTAGTGAACTCTCAG	AJ612027_cpF1 GTCTGTTATGACGTATGCACC
AJ612027-5D	5D	AJ612027_cpR1 TGAAACACAAGAGGTCACTGC	AJ612027D_F1 GATGGTCTAATTGGGTTATCG
AY244508-5A	5A	AY244508A_R2 AATTCACATAAACAACACCCAG	AY244508_cpF2 TGCAGAACCAACTTATGCACG
AY244508-5B	5B	AY244508B_R2 TCACATAAACAACACCCGCTC	AY244508_cpF2 TGCAGAACCAACTTATGCACG
AY672996-5A	5A	AY672996A_F1 CTTAGACATGAGAACTTCCAC	AY672996A_R1 GGCAACCTCCTGTCACTTAC
AY672996-5B	5B	AY672996B_F1 GATATGCACTACTTGGACATG	AY672996_cpR1 TATCCAGCAAACCGCTTTCAG
AY672996-5D	5D	AY672996_cpF1 CATGACAATGATCTAGAAGGC	AY672996D_R1 CAACCTCCTGTCGCTACTGT
BE292081-B
BE312718-A
BE312718-B
BE312718-D
BE352570-7A	7A	BE352570A_F1 TGCGTTACCCACTGTACGTG	BE352570_cpR1 CGAGCCTTGGACTTCTCAAC
BE352570-7B	7B
BE352570-7D	7D	BE352570_cpF1 CAGATCATCCCGTGGAACTT	BE352570D_R3 AACATGCATACTGCATAATTTTTT
BE352587-3D	3D	BE352587_cpR1 ccaaagcaaggaaggcgtctctc	BE352587D_F2 GGTGTGTTTTAATCCCGTTTGCCCT
BE352587-A
BE352587-B
BE352587-D
BE352592-5A
BE352592-5B
BE352592-5D
BE352603-5A	5A	BE352603A_R1 GAAAGGAAAACAGTATTCGTGCA	BE352603_cpF3 GTTCGACACAAAGCACAATGG
BE352603-5D

[ TOP | <<2500 | <<250 | <<25 | 1 - 25 of 3407 | >>25 | >>250 | >>2500 | BOTTOM ]


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