IUBio GIL .. BIOSCI/Bionet News .. Biosequences .. Software .. FTP

problem with an aql query

Florent.Crepineau crepinau at sb-roscoff.fr
Thu Nov 25 06:18:57 EST 1999


	Hello,

I have this table with 2 entries, the name of an assembly and the number of EST this assembly is made of :

// New Acedb Query Language : AQL beta release
"LamdiScon7"    10
"LamdiScon40"   3
"LamdiScon49"   2
"LamdiScon59"   2
"LamdiScon63"   2
"LamdiScon2"    6
"LamdiScon27"   4
"LamdiScon52"   5
"LamdiScon13"   4
"LamdiScon42"   2
"LamdiScon20"   12
"LamdiScon9"    8
"LamdiScon41"   2
"LamdiScon24"   7

I would like to count the occurence of the number of EST an assembly is made of for statistic purpose, like :

17 assemblies are made of 2 ESTs
14 assemblies are made of 3 ESTs
.
.
.


I have tried with three colums and counting each time a colum 2=coulum 3 :

// New Acedb Query Language : AQL beta release
"LamdiScon7"    10      10
"LamdiScon40"   3       3
"LamdiScon49"   2       2
"LamdiScon59"   2       2
"LamdiScon63"   2       2
"LamdiScon2"    6       6
"LamdiScon27"   4       4
"LamdiScon52"   5       5
"LamdiScon13"   4       4
"LamdiScon42"   2       2
"LamdiScon20"   12      12
"LamdiScon9"    8       8
"LamdiScon41"   2       2
"LamdiScon24"   7       7

aql select f:2,count(select f:3) from f in @f where f:3=f:2

but it is not correct!

Do you have any idea how I could do that.

Thank you for reading my message.

Florent






More information about the Acedb mailing list

Send comments to us at archive@iubioarchive.bio.net