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:	-- Mapped STSs select distinct probe.name as STS, dna.name as DNA, dna.sequence as Sequence from probe inner join probeprimer on probe.id = probeprimer.probeid and probeprimer.type = 'STS_primers' inner join sequenceprobe on probe.id = sequenceprobe.probeid inner join sequence on sequenceprobe.sequenceid = sequence.id inner join dna on sequence.dnaid = dna.id order by dna.name
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 959 records

STS	DNA	Sequence
ABC152	ABC152-3	cgccgggaacgcgcctaagccacccagagcgctgcattcgggagcgatga caccgttcgccaccattagtattactgtagttgattggctttccttgtcc agatatgcgtcttgtggttcgttgtg
ABC152	ABC152-5	ctccaccggcggcaaggccccccgcaagcagctcgccaccaaggcggcga ggaagtcggcgccgaccaccggcggcgtgaagaagcctcaccgctacagg cccgggaccgtggcgctccgcgagatccgcaagtaccagaagagcaccga
ABC156	ABC156-5	ctttttttttacgggatcaaagctgaggcgccatgtatatttcggatcgg aggcatgaggaaggacacactggtcgaacgctacacgcagggcatacaga actaacgaacacgacggcggttttattttattcagcgcgcgcgcatgcag cggctactgatgatacgatggcgatggtgatggtgcttggttggtgttgc ttgtcctcctctcatcctcgtgctcgcctctgccggccgg
ABC163	ABC163-5	ccgtattatttcataccgacactgaatacgaggggaaaatagcacttcaa aggaaaattacagacacttgaattaaaaactttccatgacctctcctcat gtttttatccatgtttttcggtagaaatgaaattaaagattgttcggcgg gcttcttcctamcccacaagacaaaataaaacagagtgccgttctcttgt aaaggaaagcttttatttcaagaccacatcgaagaagcagacatgaggga acctwcaacagcgctgccactgcactctggtgttggcg
ABC164	ABC164-5	ccgcagccgcagcggcgcgcacacctctccctccttcgtgaagacaacgc cgccggcgcaagagcacaggatggcgaccgtccccgctcccgcagccgag accgcggcctccacggcgcgcacggtcaaggatgtgaacccccacgagtt cgtcaaggcctactccgcgcacctcaagcgctccggcaagatggagcttc ccgagtgggttgacattgtcaagactgcaaggttcaaggagctgccgcct actgacgctgactggtactacatcagggctgcctcgatggcaaggaagat ctacctgaggcagaattgggattggtggattccagaagatctatggtggc cgtcagaggaacggttcacgccccccacacttctgcaagagcagtggtgc tgtttcccgcaacatccttcaggagttgcagaagatgggcatcattgatg tcgaccccaagggtggaaggctcatcacctcccagggaaggcgtgatctt gaccaggttgctggaactgttcctgct
ABC167	ABC167-5	cggcgccgcccctcgtccacgtccaccgccaccggcgttcttcagcccat gagctagtgttcctgctaatgtatgcatcgtcgtcagtgtcccaagaaac tgctgcggaatgaataattgaatatctgtcgtcgaaaaaaaaaaaaaaaa aaaaaatggggatactagataacgatggaagtccaagttcctttaccaga gcattcaataatacttctttgtccctctggaatttcatcatccaaacttg tgt
ABC168	ABC168-5	ccacacttacacaccacaccatgggttaggtttatctaaaacccggtaac tacttacaccgtaagaacaaaacccaaaaccaaagccgtaaaccggtgcc tgtcctgcctacwcggccagatccctatgtacaacatatctgaagtngga cttgtagggcagccactccacgcacttgtcgatccttctcctgagcctgt gctggagctgcgccatctccttccgctgggtctccgaggtggtctcgcac accagctccacgaggtggcgcagctcgagcgccgcgtccttggcatagta gtggagcg
ABC175	ABC175-5	ctttactcagaacacttgtaataagtattaaaccatggtcttcaaacaga gataaagtgcaatcagtttacaagtgcagaggtactcagtttttctctga agacaacacaatccattgtttcaatgtgcacacacgcgaaattgacgagc tgcatgcataggtccagcacactggaacactcatacgaaccttaattagc cagggccgacctttgggatatcatagtgctcactaagatttgccaggtac tggttgaagtcctggattcggtccctgtgcgacttgtcggccaccttggc cagcttgtgtacgtcgatcttctgcttctgttcaatgtaacgcctctcgg ctggagtgaggtggtcataatcagcttgtgcattcccttcgtctcccagc ttgtgagcttcactgaactcattgtcagggtcacctggcaattcagagct tccaccttcgcggggctcgccgtgctcgccttgagaggactcctcgcggc ggtgcttcttcttattcttcttcttgactccgccctccttgacatccagc ggcttccccttcagcttgagcttccccccgacgacgttctggtactccga catctcgactgcgttgcaggaggagtcgattcgcgtgagtccccgatccg cgccgatccagtggaggatggcacggggaggaggacgaggg
ABC302	ABC302-3	gtgctgttgcgcaattgaatcgaccctgtgcagtttcagttttggggaca ttcctgaaagcagaataaacgaataatcgcctcatcggcagcggctttgg tgcggttgtgggggtagtacatttcagtaactggatgatggctgtagatt tggtccgaccatactgtctgtcctgtactctgttcctgttccttatgttt tgatgatgttcagctttctcagccag
ABC302	ABC302-5	cgcggctatggcagctggtgctttcgatgctgtcgtctgctcccaccatg cacacggtggtaaaggagcggttgatcttggactcgcagttcaacgagca tgtgaaagccaggcagagcctctgaagtttttatatcctttagattctag cataaaggagaagattgagtcgatagcaaagttctatggtgctagtggtc ttgaatactctgaacaggctgaaaagcagatcgagatgtacaccaagcaa ggcttctccaacctcccgatatgcatggcgaagactcagtactccttctc ccatgtgccgtccatgaagggcgcgcatccggctttgtgctgccgataag gg
ABC309	ABC309-3	ggcgcggaggagcggcggaggaggatcccgcggagggaggacgccgacgc ggatcgcagcctcgccgtcgccgtcgccgtcgccatgggggggattagct ctcctagggttttcgcggagcatcttcttttttgaaccgggtgcatagca gaaaattagcagattctgttacaggagaccggacaggaaaccaactgtgc acgctcgg
ABC309	ABC309-5	ctctataggcacaacagataccaaatggaacaatgttttacatagcttta agagaaatcgcaaacagagataccactgggattctaaactgtcaatcaca gaggggcatgttgcttctacttattcaaaaccatccaggtgttaaaaata ttccaagccagcgattcgcaaatcttcgcatggaataaaataacagcgat accgtatactacatattctcacaagtattagctacagaaaaaaaggaccg gagagctcagccaggttcaagagcacaaatgcggtcaaaacagtagcttc atcacaagttcttgaacgcagactcgttagggagcttaggcgtgagctct ccagcaaggccttgttggagaagtgatcagcgtcgacgaagtagaagtcc ccttcgcccctagagggtacacaaa
ABC310	ABC310-3	ttgaccactgggacatcatggcttctgatcctttggacccgggcacccag tcggcaacgcttgtcacggagatccgcaagaggaagggtctcaaggagca gatgacccctctatctgatttcgaggacaagctctaaattttggtgctgt tatcccttacctgctcttgttgagttgaactattttgtatcggtgagtca atcttactatcttgctgttaaatgacctgtttgtggtgatactgggaaga gaactatgttttgatgtctggtgatgtaacggatgttgaacttagattat gtatctgttgtccactggtaaag
ABC310	ABC310-5	ctttcaccttccctctccttcaaaggcccagaggtatcgtgtggagaact tatacgagggcccccttgatgacatttatgcaaatgctatcagaaactgt gatcctgatggtcctcttatgctgtatgtgtccaagatgattccagcatc tgacaagggtagattctttgcctttggacgtgtttttgccgggagggttg caactggcatgaaggtccgtatcatgggtcccaactttgttcccggccag aagaaggatctgtatgtgaagagtgttcagcgtactgttatctggatggg aagaagcaagaatctgttgaggatgttccctgtggtacactgttgctttg gttggtttggatcagttcatcacaaagaatgcaaccctgacaaatgagaa ggaagttgatgcctgcccaatcagggcaatgaagttctctgtg
ABC455	ABC455-3	tggtagagaaccagcaccggctgggatgaggatggttccgatggtgctcc ctgatggccgccttggctatgttctgcaacaacctggtggaatgccgcct ccaccccctcctcgacgtggtgaccggcgggatggcggtggcgaaggaag ccaccggcgttatcggccctactagtttttcccttgccttgcatcttttg taggtgatggatttgttaactttgatggagtgcgtttaggagcgtgtttt gttttgccctgtaagactttttcttgataaacacctgagacttgttctgt tgtgctgtccttttca
ABC455	ABC455-5	ttccggaaggggcaggtgtcgtcaatattgagatgtttaaggatttgcat aacccaagccgtaatcgtgggttcctctttgttgagtactataaccatgc ttgcgcagactatgccagacagaaattgtcatcaccagactttaaggttg atggaagccagttgactgttagctgggccgaacctaagggttcatcatca tcatcatcggattcttcttcacctgctgctcaggtgaagactatatacgt gaagaacctgccagagaatgtttctaaagagaaagttaaggatctctttg aagttcatggagaggtcacaaaaattgttttaccgcctgctaaggccggg gcataagagggattttgggtttgttcacttttgctgaaagatcaagtgc
ABG4	ABG004-5	agtgggggcgggccggggttaagtaaccggggcaagcaacgtagccatgg cacagcaccggctttggcagtcgtcgggaggaggggaagaggacgggccg agaattttggagggaaagggggcaaggaaggtatcgtttgatctgtgacc gttgcaagcaagcaactcacttagccatggcagaggacactggcaggcag ccaggcgcacggcgactgccacaaggaatttccggttgccgtgtggcacg ggggcttgcttgcttgcttgcttgccggttgctacttcccaggacgatac tcaaaagcgcttgtaaagtggtgtctgtcgtgcgttttctgggactcggg acgccggcacaggtgtttcgacaaaacaatctcatggaaagtggcttggg caaaactggacggagatgaacgaggggagctgggcttcttttggttgttt tatttgggcaagcttctttctgaatgccattttaaatgggaggcagcgtt gggcgtggctcgggttcaggtgctttggtgctgtgacgacggtgc
ABG1	ABG1-5	ggcaaatgccgactcgttgttgattcagctggtttgtaaatcccgagatc tctatcctgcataatagatgcycccatatatgacggagcacctgccaatc aatcattgcaaataagcactaaaactgcttcccaatttgtacaagccctc ttgtctgtgtatttctatcaagtaatataagcaactttaggatcggtaaa aatcaacagaaaatttgcaccagggattactgaatatgtctccaagtgac agttgggcttaaataggaaattatgcagctcaagttattgcaacttttca gttagataaaactggtggttggtattgaggtgcaaaacaaatatggatca tgtatgcacaagcatcttttttttgtaatagtatgtgcaagcctctaacg caagcatcttgtcaaatcgacatgaccatctccaaatccagcat
ABG20	ABG20-3	cctcatctctgcgctttttctcactctgtgctctgttctcagtcacagcc tcaccatgagcgagcaggtggtgtgtataaataggccaggcctctcatgt cagagcatttcaacaatgcgcagagttgacagtcaaactgtaggaaattt tggaggaattcacagattcagggtacagttcctctgtcccgtcaaaaaga aaaaaggacgtctttgccctttggcttataattaactagtcttccgagaa ctgcatgtcctagctacgagaagaatctcttgtttctggagctagctcat cggttaattaaccaaactccaagtctttctttcttgcggttgccgcactc tccttctgggtccaagtgcag
ABG20	ABG20-5	gaaccctctgcccctcgcgatgatgttcttcaggaaagaagaagaacctt tcttccttgaagaaaggttattttcttcttcttcaagaaatttcgccaaa aaaaaagaagttgttcaagaaaaaaaaggtatgaagcagctttggatgca gctttgaaatctcacttcagagttgaggcagagacagggaccgacatagc aaagcgactatttttcatgagccatcaaagatagtggggaaccatgaagc tacaagggactctacatgctccttacagaatctaccaaaagagatcattt tatactcctatgtctaatctgcttactgtcatacg
ABG358	ABG358-5	attcctcggatttacaatgtatacagggagatgggcacgattaattcatt ccagaacctcctcgacaacatttttcttccactttttgaagtgactgttg atcctgcttcacatcctcagctgcacgttttcttggaacaggtcagtgga agtactttgtatattttttacttgtctgcattatgttgatgtggctttca gtactaatctagtcatcttgcaattgtacgagatagaaaagcaactgatt tgtagtatgtcttttaagaaaaagttattgaccaatgctcgagagatcaa tcttgttctctactttagtagaaaaagtatggacaatcttgagaaagtta ctggc
ABG377	ABG377-5	cttactgcgattccaaagttcttacagagttgttaggcctggaacttgcc aacttgaatttgaagaacagtcgtgggtacacagcactccacctagctgc tatgaggagagaaccagctattattatgtgtctccttaagcaaaggagca gtggcgtcacaattgaccgatgatggtcgccttgcaagtaatatttgtcg aaggttaacaagactaaaagattacaatgcaaagatggagcagggcccaa gagtcaaataaagataggatgtgcattgacatcctagagagggagatgat gagaaatcctatgacagcggaagattctgtgacctcacctttattagctg atgatcttcacatgaaactaagctacctggaaaacagaggtgaagtaccc cttttatgcaaatgatataatgacgcatctagacaaatattttctgaaca ttaaaatggtgggggatgtcgttaaaaagtaccccccccccttcccaaaa acccctctttttttttacctctagagtgcatatgctatagaaataggtgg ctgtaacacttactgcacattcagctctgccatattcacctgtttcatac catgttaaaatgatctgtggtct
ABG380	ABG380-5	gccgggcgagacggtgcaggatgtggtcgttgacgtgcccgctgcgctgc cagacttgaggtaagacttgaggtaagcccaaacaactagaaagggagag gaaagaaagaaaaaaaaaggaaagaaagagaaacaacaagatttacaaca cgaacagaaggagactaagaaagctaaaagagaaaagcgaaagctaagct acytctaataggattacaacaaggcttccagccaagtggagaactgatgg atatggtttctcttcatcctgtattttaacagcttgagctcctccacgaa gataaatttccagccctgaaatgaaggagttatattctcaaagattttat tgttccttcatatccaaatagcccatgaccctagaatgataatctccata aagarggggtagttcagcttgtcctttagatcttggtaagcttctaacac taacaagttatgtgatcttgtgggacagataaaatctcagcattaaatgg caaaagggcatgcccaaaaaagatgatgtagggtttcttcctgttgacag cccctca
ABG387	ABG387-5	ttttgatgaagggtggagacagatgacaggcaagattgacgcagtatttg agttacaattacttcaatttattcattttgctgacaaaatgtggcatcaa ttcaccggctgtttgcgtaatgaacattttgtggcaattcaatgccagaa aaggggacagaagacaaaataattgtgtaactagctgcgcaaatatgtag tgagagggaaccaaacagaccaagagaaaacaggaagtaagctacatcca aaatgtaccaattcagcgctgaggaactgttaagcaacagtgtccaaaat acagtacccagctagcctagctaatgcagtgttaagttgttccaaaatct tactggcatcagtaagtaatttggtcagtgtgataaggaactggagtagt gaagagagagagagagagamgcaggaacagagtgatgatgatcaccttca tgtcgtcctcgatcttggcgacctgggactggatgctggcgacggtctcc ttgagcggggcgttgacggggtacttgccctcgtcccacacgaacctgca tccatccatccatccatccatcctctacagcgtaagcaagcgctggtggg cgcagcaagaaagaatgtaagcagcggcaagcagagggatggtgacctgg tgaggtagctgtcgacggggactccgtcgacggtgagggtgccgggctcg acccctccggcgcgctccaggtcctcgatctgcctgcggatcttgtgcga gacgccctcgatgaagatgttgga
ABG388	ABG388-3	cgactgaaagggagtggagaaggagaacactaattaccggagcagcgcgg gagtactggcaggtgtgacggtgatatctggcggtggcggggctgtcgaa gatgttgaggcagatg

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


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