April 2008 - binari@psb.ugent.be - maillist.psb.ugent.be

[Binari] my little brother...
by Michiel Van Bel 28 Apr '08

28 Apr '08

attempting to recreate jackass... and quite succeeding http://youtube.com/watch?v=D7V13Kch3Jg -- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel(a)psb.ugent.be http://www.psb.ugent.be ==================================================================

1 0

[Binari] folder artr
by kenny.billiau＠psb.ugent.be 28 Apr '08

28 Apr '08

for those who have too many folders on their desktop: http://gizmodo.com/381081/spider+pig-and-homer-simpson-made-of-folders-are-… -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] firefox logo spotted in deep space
by kenny.billiau＠psb.ugent.be 24 Apr '08

24 Apr '08

the fox is out there: http://www.newlaunches.com/archives/firefox_logo_spotted_in_deep_space_by_t… -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] firefox in space
by Kenny Billiau 24 Apr '08

24 Apr '08

http://www.newlaunches.com/archives/firefox_logo_spotted_in_deep_space_by_t… -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] liedje
by Sofie Van Landeghem 21 Apr '08

21 Apr '08

Voor wie de maandag zwaar valt... http://www.olvh-brugge.be/vakken/aso/nederlands/nederlands1/eerste%20trimes… :-)

4 6

[Binari] Three Pitfalls in Java Performance Evaluation
by Sofie Van Landeghem 21 Apr '08

21 Apr '08

Maybe of interest to some? Andy Georges' phd defense at the plateau, April 30th (14h) : http://www.itkovian.net/base/public-phd-defense I might go...

1 0

[Binari] losing my religion cover
by Michiel Van Bel 17 Apr '08

17 Apr '08

ik heb het ff op de g-schijf gezet (weet niet of er hier een beperking is op attachment grootte) "G:\users\mibel\Graveworm - losing my religion.mp3" Have fun! Michiel -- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel(a)psb.ugent.be http://www.psb.ugent.be ==================================================================

1 0

[Binari] portishead
by Kenny Billiau 17 Apr '08

17 Apr '08

Hi, just in case you misssed their new album, here it is: http://psbpc057/Music/Portishead/ -Kenny -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau(a)psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

Re: [Binari] SQL challenge part 5078 (or something like that)
by Michiel Van Bel 15 Apr '08

15 Apr '08

I guess the data only changes when a new genome is added, so this might indeed be the only viable solution. I hadn't thought about it yet. Michiel PS: if anybody else has a brilliant solution, please feel free to submit it :) Thomas Abeel wrote: > How often does the data changes? > > If this is not too often, you may want to put these counts in a > separate table and update them when you update the other tables. This > will probably be the only fast solution. > > regards, > Thomas > > Michiel Van Bel wrote: >> Hi, >> >> perhaps you guys can help me with this. >> we have 2 tables: >> >> * gf_data: 2 columns (gene_family id`s and gene_id`s) . This table >> has about 500k rows >> * annotation: lots of columns, but we only need the ones with the >> gene_id`s and the species. This table has about 300k rows. >> >> We now need a couple of things: >> >> * For each species, we need a count of genes that are in >> gene_families with a size larger than 1 >> * For each species, we need a count of gene_families. >> >> Now, I've tried already a lot, but run into the problem of having to >> use either joins or nested queries, which do not really scale >> well apparently :s >> >> I thought about creating a view (by appending the gene_family into >> the annotation table), but it's been such a long time >> i've done this that I cannot remember whether this will be any help >> at all. >> >> So, any suggestions? >> >> Michiel >> >> PS: I'll think about a price for the winner :) >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Binari mailing list >> Binari(a)psb.ugent.be >> https://maillist.psb.ugent.be/mailman/listinfo/binari >> -- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel(a)psb.ugent.be http://www.psb.ugent.be ==================================================================

1 0

[Binari] SQL challenge part 5078 (or something like that)
by Michiel Van Bel 15 Apr '08

15 Apr '08

Hi, perhaps you guys can help me with this. we have 2 tables: * gf_data: 2 columns (gene_family id`s and gene_id`s) . This table has about 500k rows * annotation: lots of columns, but we only need the ones with the gene_id`s and the species. This table has about 300k rows. We now need a couple of things: * For each species, we need a count of genes that are in gene_families with a size larger than 1 * For each species, we need a count of gene_families. Now, I've tried already a lot, but run into the problem of having to use either joins or nested queries, which do not really scale well apparently :s I thought about creating a view (by appending the gene_family into the annotation table), but it's been such a long time i've done this that I cannot remember whether this will be any help at all. So, any suggestions? Michiel PS: I'll think about a price for the winner :) -- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel(a)psb.ugent.be http://www.psb.ugent.be ==================================================================

1 0