Back

Query language

Query language allows searching by the value of a field.
The main syntax is:

find <class name> < field name> = <value>

For example:

Click on 'Submit Query' .

Or lets say you are looking for a QTL for height that was detected in a trial in Aberdeen.
The syntax for that kind of search is

find <class name> <value> < field name> = <value>

Click on 'Submit Query' and see if GrainGenes has that kind of QTL.

Query language

Enter an acedb query:

 

Model : ?QTL

Trait_affected ?Trait 
Trait_study ?Trait_Study 
Environment ?Environment 
Mapping_data ?Map_Data 
Linkage_data ?Linkage_Data 
Chromosome_arm ?Text 
Associated_gene ?Gene 
Nearest_marker ?Locus 
Significance_level Float 
Positive Significant_marker ?Locus Text 
Negative Nonsignificant_marker ?Locus 
Position Map ?Map #map_position 
Map_label ?Text 
LOD_peak_location ?Locus 
LOD_peak_height Float 
Significant_LOD_interval gMap ?Map Float Float 
LOD_threshold Float 
Phenotypic_R2 Float 
Genetic_R2 Float 
Effect_of_allele_substitution Float Text 
Additivity_Dominance_ratio Float 
Higher_scoring_allele_from ?Germplasm 
Interactions Text 
Significance_x_Environment Float ?Environment 
Comment Text 
Image ?Image
Choose new class:

The 'Show all' button will lead you to all records. If you wish to perform a query on a different class use the 'Choose new class' drop-down menu.

Query language also uses Boolean OR, AND, NOT, XOR and <, >, =, !=, <=, >=.

To see more query language examples click here.

Back