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:	-- Best peptide BLAST hits select sequence.name as Sequence, protein.name as Protein, protein.title as Title, sequence.bestpepscore as Score, sequence.bestpepevalue as Evalue from sequence join protein on sequence.bestpep_proteinid = protein.id
	Schema: Diagrams \| Table definitions

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

Showing records 1 through 25 of 688 records

Sequence	Protein	Title	Score	Evalue
BE438608	AAB88617.1	(AF034946) ubiquitin conjugating enzyme [Zea mays]	182	4e-53
BE438609	AAD17232.1	(AF117660) S-adenosylmethionine decarboxylase precursor [Triticum aestivum]	50.8	4e-06
BE438610	BAB08647.1	(AB009048) frnE protein-like [Arabidopsis thaliana]	76.5	5e-14
BE438611	G3PX_HORVU	GLYCERALDEHYDE 3-PHOSPHATE DEHYDROGENASE, CYTOSOLIC	172	1e-42
BE438613	A34690	DNA-binding protein inhibitor Id - mouse (fragment)	32.5	0.74
BE438614	RBS_AEGSQ	RIBULOSE BISPHOSPHATE CARBOXYLASE SMALL CHAIN PRECURSOR (RUBISCO SMALL SUBUNIT) squarrosa	83.9	9e-17
BE438615	AE005536_5	(AE005536) orf, hypothetical protein [Escherichia coli O157:H7	30.1	4.0
BE438616	AF308468_7	(AF308468) siroheme synthetase [Klebsiella aerogenes]	33.6	0.67
BE438617	NP_013059.1	Succinate dehydrogenase (ubiquinone) iron-sulfur protein subunit; Sdh2p [Saccharomyces cerevisiae] MITOCHONDRIAL PRECURSOR (IP) protein precursor - yeast (Saccharomyces cerevisiae) 1.3.99.1) [Saccharomyces cerevisiae]	30.5	2.9
BE438618	AF221543_1	(AF221543) heat shock protein 70 [Cryptosporidium muris]	55.4	1e-07
BE438619	BAA95779.1	(AB028608) polygalacturonase-like protein [Arabidopsis thaliana]	113	2e-30
BE438620	S18135	ryanodine receptor - pig (fragment)	32.8	0.57
BE438621	R142_MAIZE	40S RIBOSOMAL PROTEIN S14 (CLONE MCH2)	57.8	5e-08
BE438622	NP_064092.1	orf131 [Beta vulgaris]	31.7	1.3
BE438623	BAB02292.1	(AB017071) WD-40 repeat protein-like [Arabidopsis thaliana]	35.6	0.31
BE438624	T46636	glycine dehydrogenase (decarboxylating) (EC 1.4.4.2) [imported] - Hordeum sp. x Triticum sp	36.4	0.11
BE438625	AAF51757.1	(AE003595) CG7162 gene product [Drosophila melanogaster]	34.8	0.50
BE438626	T06985	probable phenylalanine ammonia-lyase (EC 4.3.1.5) wali4 - wheat (fragment)	122	2e-27
BE438627	PGKH_WHEAT	PHOSPHOGLYCERATE KINASE, CHLOROPLAST PRECURSOR	229	1e-59
BE438628	BAB11531.1	(AB005245) contains similarity to unknown protein~gb\|AAF19573.1~gene_id:MUG13.5 [Arabidopsis thaliana]	30.5	4.6
BE438629	AC026238_6	(AC026238) Hypothetical protein [Arabidopsis thaliana]	80	4e-15
BE438630	I54552	hypothetical serine proteinase - rat	30.9	6.9
BE438631	T06177	ribulose-bisphosphate carboxylase activase (EC 6.3.4.-) A1 - barley vulgare]	181	3e-45
BE438632	S22515	thionin precursor, leaf - barley	169	9e-42
BE438633	CAB42658.1	(AJ012374) iron sulfur subunit of succinate dehydrogenase (truncated) and ribosomal protein S14 [Zea mays]	156	3e-43

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


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