ensembl.sh

##reverse engeenering for mysql/ensembl

SQL="mysql -N -A -h ensembldb.ensembl.org -u anonymous -P 5306"

for D in homo_sapiens_core_48_36j #`${SQL} -e "show databases like 'homo%'"`
do
	for T in `${SQL} -D $D -e 'show tables'`
		do
			for F in `${SQL} -D $D -e "desc $T" |egrep -w 'translation_id' | cut -d '	' -f 1`
			do
				#echo "#$D.$T.$F"
				${SQL} -D $D  -e "select '$D.$T.$F' from $T where $F = 37300 limit 1"
			done
		done
done

exit

for D in `${SQL} -e "show databases like 'homo%'"`
do
	for T in `${SQL} -D $D -e 'show tables'`
		do
			for F in `${SQL} -D $D -e "desc $T" |egrep -w '(varchar|text)' | cut -d '	' -f 1`
			do
				#echo "#$D.$T.$F"
				${SQL} -D $D  -e "select '$D.$T.$F' from $T where $F = 'GO:0000166' limit 1"
			done
		done
done


exit

for D in homo_sapiens_core_48_36j #`${SQL} -e "show databases like 'homo%'"`
do
	for T in `${SQL} -D $D -e 'show tables'`
		do
			for F in `${SQL} -D $D -e "desc $T" |egrep -w 'object_xref_id' | cut -d '	' -f 1`
			do
				#echo "#$D.$T.$F"
				${SQL} -D $D  -e "select '$D.$T.$F' from $T where $F = 2920037 limit 1"
			done
		done
done

exit

for D in homo_sapiens_core_48_36j #`${SQL} -e "show databases like 'homo%'"`
do
	for T in `${SQL} -D $D -e 'show tables'`
		do
			for F in `${SQL} -D $D -e "desc $T" |egrep -w 'xref_id' | cut -d '	' -f 1`
			do
				#echo "#$D.$T.$F"
				${SQL} -D $D  -e "select '$D.$T.$F' from $T where $F = 1271867 limit 1"
			done
		done
done

exit

for D in homo_sapiens_core_48_36j #`${SQL} -e "show databases like 'homo%'"`
do
	for T in `${SQL} -D $D -e 'show tables'`
		do
			for F in `${SQL} -D $D -e "desc $T" |egrep -w '(varchar|text)' | cut -d '	' -f 1`
			do
				#echo "#$D.$T.$F"
				${SQL} -D $D  -e "select '$D.$T.$F' from $T where $F like 'NM\_030621%' limit 1"
			done
		done
done