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  | <<2500 | <<250 | <<25  | 226 - 250 of 6162 | >>25  | >>250  | >>2500  | BOTTOM  ]

Showing records 226 through 250 of 6162 records
QTLTraitMap DataChromosome armSignificant marker
QBG.CORE-BG_6.1beta-glucan (oat)Oat-2020-CORE-BG GMI_DS_LB_6011,GMI_ES01_c17690_632,GMI_ES01_c26202_132
QBG.CORE-BG_6.2beta-glucan (oat)Oat-2020-CORE-BG avgbs_218464,GMI_ES01_c1307_465,GMI_ES15_c12071_400,GMI_GBS_24858
QBG.CORE-BG_6.3beta-glucan (oat)Oat-2020-CORE-BG avgbs_215595,GMI_ES03_lrc22298_545
QBG.CORE-BG_6.4beta-glucan (oat)Oat-2020-CORE-BG avgbs_201177,GMI_ES01_c21720_82,GMI_ES01_lrc17667_357,GMI_ES14_c304_84,GMI_ES15_c2202_214,GMI_ES15_c5396_587,GMI_ES22_c4889_60,GMI_ES22_c5057_495
QBG.CORE-BG_8.1beta-glucan (oat)Oat-2020-CORE-BG avgbs_213598
QBG.CORE-BG_8.2beta-glucan (oat)Oat-2020-CORE-BG GMI_DS_LB_9591
QBG.CORE-BG_8.3beta-glucan (oat)Oat-2020-CORE-BG avgbs_55946
QBg1.jki-A1beta-glucan (oat)Oat-2014-AB_QTL E31M49_1,E31M49_3,E31M57_1,E32M52_1,E32M55_1,E33M48_1,E34M52_1,E34M55_1,E34M56_1,E34M56_2,E34M57_2,E34M60_3,E35M53_1,E35M53_2,E35M53_3,E35M53_4,E35M55_4,E35M56_1,E36M52_1,E36M52_3,E36M55_1,E36M57_4,E36M60_2,E36M62_1,E37M47_2,E37M55_2,E37M60_2,E37M62_5,E38M53_1,E38M57_1,E38M60_2,E38M61_1,E39M55_1,E39M56_1,E40M58_2,E40M58_3,E42M55_4,E43M58_3,E46M53_2,E46M58_1
QBg1.jki-B1beta-glucan (oat)Oat-2014-AB_QTL E32M52_1,E32M55_1,E32M56_b,E34M52_d,E34M53_a,E34M55_1,E34M56_1,E34M56_2,E34M57_2,E35M53_1,E35M53_2,E35M55_4,E35M60_a,E36M56_a,E36M57_4,E36M62_1,E37M47_2,E38M53_1,E38M57_1,E38M61_1,E40M58_3,E41M55_b,E41M58_b,E42M49_c,E42M55_4,E43M58_3,E46M58_1
QBg2.jki-A10beta-glucan (oat)Oat-2014-AB_QTL E33M48_2,E34M49_1
Qbgl.UFRGS.E17N-Mrg06.1beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_cluster_39442.1.33
Qbgl.UFRGS.E17N-Mrg11.7beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs2_96603.1.42
Qbgl.UFRGS.E17N-Mrg12.1beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_cluster_33876.1.64
Qbgl.UFRGS.E18N-Mrg06.1beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_cluster_39442.1.33
Qbgl.UFRGS.E18N-Mrg11.3beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_104028.1.28
Qbgl.UFRGS.E18N-Mrg11.5beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_62906.1.35
Qbgl.UFRGS.E18N-Mrg11.6beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_225806.1.13,avgbs_72741.1.47
Qbgl.UFRGS.E18N-Mrg12.1beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_cluster_33876.1.64
Qbgl.UFRGS.E18N-Mrg12.2beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_cluster_30172.1.9
Qbgl.UFRGS.E18N-Mrg19.2beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_cluster_32091.1.36
Qbgl.UFRGS.L17E-Mrg02.1beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs2_50181.1.51
Qbgl.UFRGS.L17E-Mrg20beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_cluster_35845.1.61
Qbgl.UFRGS.L17N-Mrg02.2beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_cluster_30914.1.60
Qbgl.UFRGS.L17N-Mrg11.1beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs2_44135.1.36,avgbs2_86064.1.51,avgbs2_86064.1.6,avgbs_200620.1.64
Qbgl.UFRGS.L17N-Mrg11.2beta-glucan (oat)Oat-2020-UFRGS-Bg avgbs_42869.1.46

[ TOP  | <<2500 | <<250 | <<25  | 226 - 250 of 6162 | >>25  | >>250  | >>2500  | BOTTOM  ]

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