Hi Friends,
I am a newbie to bioinformatics. This is my first analysis. Hence, I only understand very basics. I want to SQL-query a database which was prepared using RSQLite which contains output of gene-differential-analysis. I am able to make simple queries but stuck with complex ones.
For those who understand it, specifically I am trying to query RSQlite based cummeRbund which has a SQLite backend. The database is built on tables obtained for differential expression of genes.
I have three samples (value_1, value_2, value_3) which are compared pairwise ( sample_1 vs sample_2) where, sample_1 and sample 2 can take any of the values i.e. value_1, value_2 or value_3.
I want to obtain a SQL query for only those values for gene_ids in column_1 where sample_1 column takes either of the values (value_1, value_2) but sample_2 column takes only value_3.
Please help me.
Thanks
T_L
I am a newbie to bioinformatics. This is my first analysis. Hence, I only understand very basics. I want to SQL-query a database which was prepared using RSQLite which contains output of gene-differential-analysis. I am able to make simple queries but stuck with complex ones.
For those who understand it, specifically I am trying to query RSQlite based cummeRbund which has a SQLite backend. The database is built on tables obtained for differential expression of genes.
I have three samples (value_1, value_2, value_3) which are compared pairwise ( sample_1 vs sample_2) where, sample_1 and sample 2 can take any of the values i.e. value_1, value_2 or value_3.
I want to obtain a SQL query for only those values for gene_ids in column_1 where sample_1 column takes either of the values (value_1, value_2) but sample_2 column takes only value_3.
Please help me.
Thanks
T_L