Can we get GO info?



SELECT * FROM [sr320@washington.edu].[qDOD Cgigas Gene Descriptions (Swiss-prot)] cgsp
  LEFT JOIN [sr320@washington.edu].[SPID and GO Numbers] ass
  ON cgsp.SPID = ass.SPID
    
  LEFT JOIN [sr320@washington.edu].[GO_to_GOslim] slim
  on ass."GOID" = slim.GO_id


Saved dataset



Want to find genes involved in stress

SELECT CGI_ID,evalue,Description,SPID,GOID,term,GOSlim_bin
  FROM [sr320@washington.edu].[qDOD_Cgigas_GO_GOslim]
  
  Where GOSlim_bin LIKE '%stress%'


-----


Want to find genes involved in stress and get actual sequence


SELECT cgslim.CGI_ID,Description,evalue,SPID,GOID,term,GOSlim_bin,sequence
  FROM [sr320@washington.edu].[qDOD_Cgigas_GO_GOslim] cgslim
 
 LEFT JOIN [sr320@washington.edu].[qDOD_Cgigas_gene_fasta] cgf
  on cgslim.CGI_ID = cgf.CGI_ID
  
  Where GOSlim_bin LIKE '%stress%'



-----

SELECT cgslim.CGI_ID,Description,evalue,SPID,GOID,term,GOSlim_bin,sequence
  FROM [sr320@washington.edu].[qDOD_Cgigas_GO_GOslim] cgslim
 
 LEFT JOIN [sr320@washington.edu].[qDOD_Cgigas_gene_fasta] cgf
  on cgslim.CGI_ID = cgf.CGI_ID
  
  Where term LIKE '%immune%'

------

SELECT cgslim.CGI_ID,Description,evalue,SPID,GOID,term,GOSlim_bin,sequence
  FROM [sr320@washington.edu].[qDOD_Cgigas_GO_GOslim] cgslim
 
 LEFT JOIN [sr320@washington.edu].[qDOD_Cgigas_gene_fasta] cgf
  on cgslim.CGI_ID = cgf.CGI_ID
  
  Where Description LIKE '%interleuk%'



--


SELECT cgslim.CGI_ID,Description,evalue,SPID,GOID,term,GOSlim_bin,sequence
  FROM [sr320@washington.edu].[qDOD_Cgigas_GO_GOslim] cgslim
 
 LEFT JOIN [sr320@washington.edu].[qDOD_Cgigas_gene_fasta] cgf
  on cgslim.CGI_ID = cgf.CGI_ID
  
  Where term LIKE '%methyl%'
  OR
  term LIKE '%histone%'







qDOD Cgigas Gene Descriptions (Swiss-prot)