Saturday, June 23, 2007

One-liner for mapping Agilent Microarray ID to Affymetrix Genechip ID

echo "
SELECT
mmusculus_gene_ensembl__xref_agilentprobe__dm.dbprimary_id,
mmusculus_gene_ensembl__xref_agilentprobe__dm.gene_stable_id,
mmusculus_gene_ensembl__xref_affy_mouse430_2__dm.dbprimary_id
FROM
mmusculus_gene_ensembl__xref_agilentprobe__dm,
mmusculus_gene_ensembl__xref_affy_mouse430_2__dm
WHERE
mmusculus_gene_ensembl__xref_agilentprobe__dm.dbprimary_id = 'A_52_P654624' AND
mmusculus_gene_ensembl__xref_agilentprobe__dm.gene_id_key = /
mmusculus_gene_ensembl__xref_affy_mouse430_2__dm.gene_id_key;" /
| mysql -h ensembldb.ensembl.org -A -uanonymous -D ensembl_mart_40

You need mysqlclient.

2 comments:

Anonymous said...

What is Baccarat? - Urban Dictionary
In the early 1900s, the card game was played in a casino, planet win 365 as the vua nhà cái name implies, in which each player is dealt two cards. A "cutthroat" game (in the 바카라 사이트 game of

casinositezone.com said...

I went over this internet site and I think you have a lot of great info , saved to favorites.
스포츠토토구매