Forgot your password?
New user?
Document Actions
Closest genomes
Table of genomes and number of best hits (highest fasta bit score). Only genomes with hits > 20 are shown.
| genome | best hits |
|---|---|
| Rhodobacter_sphaeroides_2_4_1 | 1069 |
| Roseobacter_denitrificans_OCh_114 | 377 |
| Silicibacter_TM1040 | 346 |
| Silicibacter_pomeroyi_DSS-3 | 302 |
| Jannaschia_CCS1 | 170 |
| Sinorhizobium_meliloti | 49 |
| Rhizobium_etli_CFN_42 | 47 |
| Rhodospirillum_rubrum_ATCC_11170 | 41 |
| Nitrobacter_winogradskyi_Nb-255 | 40 |
| Mesorhizobium_loti | 36 |
| Magnetospirillum_magneticum_AMB-1 | 36 |
| Agrobacterium_tumefaciens_C58_UWash | 31 |
| Brucella_suis_1330 | 30 |
| Mesorhizobium_BNC1 | 29 |
| Bradyrhizobium_japonicum | 27 |
| Rhodopseudomonas_palustris_BisA53 | 24 |
| Rhodopseudomonas_palustris_BisB18 | 24 |
CREATE TABLE analysis_best_hits
SELECT oid,gid,fa_bits FROM fasta_hit s1
WHERE fa_bits=(SELECT MAX(s2.fa_bits) FROM fasta_hit s2 WHERE s1.oid=s2.oid)
AND s1.hit=1
ORDER BY oid;
SELECT genome.name AS genome,count(*) AS best
FROM analysis_best_hits,genome
WHERE analysis_best_hits.gid=genome.gid
GROUP BY genome.gid ORDER BY best DESC;
google calendar IMG454