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 | <<250 | <<25 | 1 - 25 of 959 | >>25  | >>250  | BOTTOM  ]

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

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