ANALISE DAS TABELAS DE ANOTAÇÃO DE TRANSCRITOS DE TUMOR

(procedimento)

1) mysql -u aula –p <ENTER>

2) use aula;

3) show tables;

4) select * from hsa_count limit 10;

5) select * from hsa_count order by hits limit 10;

6) select * from hsa_count order by hits desc limit 10;

7) select * from hsa_count where description like ‘%pituitary%’;

8) select * from hsa_ko limit 10;

9) select * from hsa_ko order by ko limit 10;

10) select * from ko_hits limit 10;

11) select * from ko_hits where ko_desc like ‘%pituitary%’;

12) select * from ko_hits where path_desc like ‘%cell cycle%’;

13) select * from ko_hits where path_desc like ‘%cell cycle%’ order by total_hits desc;

14) select * from ko_hits where path_desc like ‘%repair%’ order by total_hits desc;

15) select * from ko_hits where path_desc like ‘%base excision repair%’ order by total_hits desc;

16) observar HMGB1, polB, XRCC1 e APE1 no Kegg Pathway