GrainGenes-SQL offers several advanced modes for searching the MySQL database.
Click here for a video tutorial on querying the GrainGenes database.
Field-based Search
Search by the value of a field or combination of fields. The result is a
list of the matching records, for viewing in full individually. Currently
the Field-based Search is available only for the Gene and Sequence data
classes.
SQL Interface
Enter raw SQL "select .. from .. where .." queries directly. Some examples
are provided, along with access to the GrainGenes schema. The
Batch SQL Interface
As above, but then enter a list of arguments to the "where .." part of the
query.
Batch Query to get Sequences in FASTA Format
Enter a list of sequence names or accessions to get the sequences in FASTA format.
Batch Query to get all FASTA Sequences for a list of Probes
Enter a list of probe names to get the corresponding sequences in FASTA format.