Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
phage transcriptional regulator, AlpA |
NC_008322 (Shewanella sp. MR-7) |
4e-15 |
55 |
|
phage transcriptional regulator AlpA |
NC_009901 (Shewanella pealeana ATCC 700345) |
2e-14 |
57 |
|
phage transcriptional regulator AlpA |
NC_018692 (Alteromonas macleodii Black Sea 11) |
4e-14 |
49 |
|
DNA-binding protein |
NC_014012 (Shewanella violacea DSS12) |
6e-14 |
57 |
|
phage transcriptional regulator AlpA |
NC_011663 (Shewanella baltica OS223) |
6e-14 |
48 |
|
phage transcriptional regulator AlpA |
NC_009092 (Shewanella loihica PV-4) |
2e-13 |
56 |
|
Phage AlpA Prophage CP4-57 regulatory protein (AlpA) |
NC_021810 (Salmonella enterica 41578) |
4e-13 |
48 |
|
Phage_AlpA Prophage CP4-57 regulatory protein (AlpA) |
NC_017623 (Salmonella enterica B182) |
4e-13 |
48 |
|
DNA-binding protein |
NC_021812 (Salmonella enterica CFSAN002069) |
4e-13 |
48 |
|
phage transcriptional regulator AlpA |
NC_009438 (Shewanella putrefaciens CN-32) |
6e-13 |
56 |
|
putative transcriptional regulator |
NC_013654 (Escherichia coli SE15) |
6e-13 |
48 |
|
transcriptional regulator |
NC_021286 (Idiomarina loihiensis GSL 199) |
7e-13 |
45 |
|
transcriptional regulator |
NC_006512 (Idiomarina loihiensis L2TR) |
7e-13 |
45 |
|
phage transcriptional regulator AlpA |
NC_010322 (Pseudomonas putida GB-1) |
9e-13 |
49 |
|
phage transcriptional regulator, AlpA |
NC_019905 (Pseudomonas putida PC9) |
1e-12 |
49 |
|
phage transcriptional regulator, AlpA |
NC_015222 (Nitrosomonas sp. AL212) |
1e-12 |
52 |
|
phage transcriptional regulator AlpA |
NC_011663 (Shewanella baltica OS223) |
1e-12 |
56 |
|
phage transcriptional regulator AlpA |
NC_015731 (Nitrosomonas sp. Is79A3) |
2e-12 |
47 |
|
DNA-binding protein |
NC_020802 (Psychromonas sp. CNPT3) |
3e-12 |
42 |
|
AlpA family transcriptional regulator |
NC_015379 (Pseudomonas brassicacearum NFM421) |
4e-12 |
50 |
|
phage transcriptional regulator AlpA |
NC_009439 (Pseudomonas mendocina ymp) |
4e-12 |
46 |
|
phage transcriptional regulator, AlpA |
NC_015276 (Marinomonas mediterranea MMB-1) |
5e-12 |
47 |
|
phage DNA binding protein |
NC_013941 (Escherichia coli CB9615) |
5e-12 |
43 |
|
phage DNA binding protein |
NC_011353 (Escherichia coli EC4115) |
5e-12 |
43 |
|
regulatory protein encoded in prophage CP-933I |
NC_002655 (Escherichia coli EDL933) |
5e-12 |
43 |
|
phage DNA binding protein |
NC_017656 (Escherichia coli RM12579) |
5e-12 |
43 |
|
DNA binding protein |
NC_002695 (Escherichia coli Sakai) |
5e-12 |
43 |
|
regulatory protein encoded in prophage CP-933I |
NC_013008 (Escherichia coli TW14359) |
5e-12 |
43 |
|
putative DNA binding protein |
NC_017906 (Escherichia coli Xuzhou21) |
5e-12 |
43 |
|
prophage regulatory protein |
NC_009348 (Aeromonas salmonicida A449) |
5e-12 |
42 |
|
phage transcriptional regulator, AlpA-family |
NC_014306 (Erwinia billingiae Eb661) |
6e-12 |
45 |
|
Predicted transcriptional regulator |
NC_021046 (Enterobacter cloacae NCTC 9394) |
6e-12 |
50 |
|
hypothetical protein |
NC_004631 (Salmonella enterica Ty2) |
6e-12 |
49 |
|
predicted phage transcriptional regulator |
NC_012962 (Photorhabdus asymbiotica ATCC 43949) |
1e-11 |
43 |
|
putative dna binding protein |
NC_012962 (Photorhabdus asymbiotica ATCC 43949) |
1e-11 |
43 |
|
AlpA |
NC_013956 (Pantoea ananatis LMG 20103) |
1e-11 |
43 |
|
phage transcriptional regulator, AlpA |
NC_011080 (Salmonella enterica SL254) |
1e-11 |
45 |
|
hypothetical protein |
NC_013508 (Edwardsiella tarda EIB202) |
2e-11 |
50 |
|
Phage transcriptional regulator, AlpA |
NC_017845 (Pectobacterium sp. SCC3193) |
2e-11 |
47 |
|
hypothetical protein |
NC_010067 (Salmonella enterica RSK2980) |
2e-11 |
45 |
|
phage transcriptional regulator AlpA |
NC_012880 (Dickeya dadantii Ech703) |
3e-11 |
45 |
|
DNA-binding protein |
NC_014500 (Dickeya dadantii 3937) |
3e-11 |
45 |
|
phage transcriptional regulator AlpA |
NC_013592 (Dickeya dadantii Ech586) |
3e-11 |
45 |
|
phage transcriptional regulator AlpA |
NC_012912 (Dickeya zeae Ech1591) |
3e-11 |
45 |
|
phage transcriptional regulator AlpA |
NC_012912 (Dickeya zeae Ech1591) |
3e-11 |
45 |
|
Predicted transcriptional regulator |
NC_021046 (Enterobacter cloacae NCTC 9394) |
4e-11 |
46 |
|
hypothetical protein |
NC_021500 (Enterobacter sp. R4-368) |
4e-11 |
41 |
|
transcriptional regulator |
NC_005810 (Yersinia pestis 91001) |
4e-11 |
50 |
|
AlpA family transcriptional regulator |
NC_017168 (Yersinia pestis A1122) |
4e-11 |
50 |
|
AlpA family transcriptional regulator |
NC_010159 (Yersinia pestis Angola) |
4e-11 |
50 |
|
transcriptional regulator |
NC_008150 (Yersinia pestis Antiqua) |
4e-11 |
50 |
|
DNA-binding protein |
NC_017265 (Yersinia pestis Harbin 35) |
4e-11 |
50 |
|
transcriptional regulator |
NC_008149 (Yersinia pestis Nepal516) |
4e-11 |
50 |
|
transcriptional regulator |
NC_009381 (Yersinia pestis Pestoides F) |
4e-11 |
50 |
|
prophage regulatory protein |
NC_005085 (Chromobacterium violaceum ATCC 12472) |
5e-11 |
42 |
|
hypothetical protein |
NC_009778 (Cronobacter sakazakii ATCC BAA-894) |
7e-11 |
46 |
|
putative Putative DNA binding protein |
NC_017626 (Escherichia coli 042) |
7e-11 |
44 |
|
phage transcriptional regulator, AlpA |
NC_015224 (Yersinia enterocolitica 105.5R(r)) |
8e-11 |
50 |
|
prophage regulatory protein |
NC_009348 (Aeromonas salmonicida A449) |
1e-10 |
42 |
|
putative transcriptional regulator |
NC_017033 (Frateuria aurantia DSM 6220) |
1e-10 |
47 |
|
phage DNA binding protein |
NC_017564 (Yersinia enterocolitica Y11) |
1e-10 |
51 |
|
Regulatory protein |
NC_015224 (Yersinia enterocolitica 105.5R(r)) |
1e-10 |
50 |
|
phage DNA binding protein |
NC_017564 (Yersinia enterocolitica Y11) |
1e-10 |
50 |
|
putative transcriptional regulator |
NC_017033 (Frateuria aurantia DSM 6220) |
1e-10 |
46 |
|
DNA binding protein |
NC_013941 (Escherichia coli CB9615) |
1e-10 |
44 |
|
regulatory protein |
NC_005810 (Yersinia pestis 91001) |
2e-10 |
50 |
|
putative regulatory protein |
NC_017168 (Yersinia pestis A1122) |
2e-10 |
50 |
|
AlpA family protein |
NC_010159 (Yersinia pestis Angola) |
2e-10 |
50 |
|
putative regulatory protein |
NC_008150 (Yersinia pestis Antiqua) |
2e-10 |
50 |
|
regulatory protein |
NC_003143 (Yersinia pestis CO92) |
2e-10 |
50 |
|
putative regulatory protein |
NC_017265 (Yersinia pestis Harbin 35) |
2e-10 |
50 |
|
hypothetical protein |
NC_004088 (Yersinia pestis KIM) |
2e-10 |
50 |
|
regulatory protein |
NC_008149 (Yersinia pestis Nepal516) |
2e-10 |
50 |
|
regulatory protein |
NC_009381 (Yersinia pestis Pestoides F) |
2e-10 |
50 |
|
AlpA family protein |
NC_009708 (Yersinia pseudotuberculosis IP 31758) |
2e-10 |
50 |
|
DNA binding protein |
NC_006155 (Yersinia pseudotuberculosis IP 32953) |
2e-10 |
50 |
|
phage transcriptional regulator AlpA |
NC_010634 (Yersinia pseudotuberculosis PB1/+) |
2e-10 |
50 |
|
phage transcriptional regulator AlpA |
NC_010465 (Yersinia pseudotuberculosis YPIII) |
2e-10 |
50 |
|
DNA binding protein |
NC_002655 (Escherichia coli EDL933) |
2e-10 |
46 |
|
DNA binding protein |
NC_002695 (Escherichia coli Sakai) |
2e-10 |
46 |
|
DNA binding protein |
NC_013008 (Escherichia coli TW14359) |
2e-10 |
46 |
|
putative DNA binding protein |
NC_017906 (Escherichia coli Xuzhou21) |
2e-10 |
46 |
|
phage transcriptional regulator AlpA |
NC_008709 (Psychromonas ingrahamii 37) |
2e-10 |
41 |
|
phage transcriptional regulator, AlpA |
NC_012917 (Pectobacterium carotovorum PC1) |
2e-10 |
49 |
|
DNA binding protein |
NC_017656 (Escherichia coli RM12579) |
2e-10 |
46 |
|
phage transcriptional regulator AlpA |
NC_015675 (Mesorhizobium opportunistum WSM2075) |
3e-10 |
45 |
|
phage transcriptional regulator, AlpA |
NC_016041 (Glaciecola nitratireducens FR1064) |
3e-10 |
43 |
|
CP4-57 prophage; transcriptional acitvator of a P4-like cryptic prophage |
NC_013892 (Xenorhabdus bovienii SS-2004) |
3e-10 |
41 |
|
phage transcriptional regulator, AlpA |
NC_008321 (Shewanella sp. MR-4) |
3e-10 |
42 |
|
phage transcriptional regulator, AlpA |
NC_009436 (Enterobacter sp. 638) |
4e-10 |
47 |
|
putative DNA binding protein from phage origin |
NC_011745 (Escherichia coli ED1a) |
5e-10 |
42 |
|
hypothetical protein |
NC_010067 (Salmonella enterica RSK2980) |
6e-10 |
47 |
|
prophage CP4-57 regulator |
NC_021286 (Idiomarina loihiensis GSL 199) |
6e-10 |
43 |
|
prophage CP4-57 regulator |
NC_006512 (Idiomarina loihiensis L2TR) |
6e-10 |
43 |
|
regulatory protein |
NC_018522 (Klebsiella pneumoniae 1084) |
6e-10 |
42 |
|
phage transcriptional regulator, AlpA |
NC_013421 (Pectobacterium wasabiae WPP163) |
7e-10 |
49 |
|
phage-like protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
7e-10 |
45 |
|
phage-like protein |
NC_017731 (Providencia stuartii MRSN 2154) |
8e-10 |
45 |
|
Phage transcriptional regulator, AlpA |
NC_017845 (Pectobacterium sp. SCC3193) |
8e-10 |
41 |
|
hypothetical protein |
NC_011094 (Salmonella enterica CVM19633) |
1e-09 |
47 |
|
CP4-57 prophage; transcriptional acitvator of a P4-like cryptic prophage |
NC_013892 (Xenorhabdus bovienii SS-2004) |
1e-09 |
44 |
|
transcriptional regulator AlpA family |
NC_011283 (Klebsiella pneumoniae 342) |
1e-09 |
43 |
|
prophage CP4-57 regulatory protein |
NC_009485 (Bradyrhizobium sp. BTAi1) |
1e-09 |
41 |
|
phage transcriptional regulator, AlpA |
NC_007925 (Rhodopseudomonas palustris BisB18) |
1e-09 |
41 |
|
phage transcriptional regulator, AlpA |
NC_016631 (Granulicella mallensis MP5ACTX8) |
1e-09 |
49 |
|
hypothetical protein |
NC_007722 (Erythrobacter litoralis HTCC2594) |
1e-09 |
43 |
|
phage transcriptional regulator, AlpA |
NC_007925 (Rhodopseudomonas palustris BisB18) |
2e-09 |
42 |
|
transcriptional regulator |
NC_018525 (Pectobacterium carotovorum PCC21) |
2e-09 |
44 |
|
phage transcriptional regulator, AlpA |
NC_010336 (Francisella philomiragia ATCC 25017) |
2e-09 |
43 |
|
prophage regulatory protein |
NC_004547 (Pectobacterium atrosepticum SCRI1043) |
2e-09 |
41 |
|
phage transcriptional regulator, AlpA |
NC_013421 (Pectobacterium wasabiae WPP163) |
2e-09 |
41 |
|
putative phage DNA binding protein |
NC_011741 (Escherichia coli IAI1) |
2e-09 |
47 |
|
phage-like protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
2e-09 |
45 |
|
hypothetical protein |
NC_010994 (Rhizobium etli CIAT 652) |
2e-09 |
44 |
|
prophage regulatory protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
2e-09 |
44 |
|
phage transcriptional regulator AlpA |
NC_015675 (Mesorhizobium opportunistum WSM2075) |
2e-09 |
41 |
|
putative AlpA family transcriptional regulator |
NC_015976 (Sphingobium sp. SYK-6) |
3e-09 |
45 |
|
phage transcriptional regulator AlpA |
NC_010338 (Caulobacter sp. K31) |
3e-09 |
42 |
|
phage transcriptional regulator, AlpA |
NC_008435 (Rhodopseudomonas palustris BisA53) |
3e-09 |
42 |
|
phage transcriptional regulator AlpA |
NC_013592 (Dickeya dadantii Ech586) |
3e-09 |
41 |
|
phage-like protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
3e-09 |
50 |
|
hypothetical protein |
NC_008800 (Yersinia enterocolitica 8081) |
3e-09 |
45 |
|
phage transcriptional regulator AlpA |
NC_008740 (Marinobacter aquaeolei VT8) |
3e-09 |
44 |
|
phage transcriptional regulator, AlpA |
NC_007925 (Rhodopseudomonas palustris BisB18) |
3e-09 |
42 |
|
hypothetical protein |
NC_012731 (Klebsiella pneumoniae NTUH-K2044) |
3e-09 |
47 |
|
hypothetical protein |
NC_009648 (Klebsiella pneumoniae subsp. pneumoniae MGH 78578) |
3e-09 |
47 |
|
phage transcriptional regulator, AlpA |
NC_014972 (Desulfobulbus propionicus DSM 2032) |
3e-09 |
43 |
|
regulatory protein |
NC_014500 (Dickeya dadantii 3937) |
4e-09 |
50 |
|
phage transcriptional regulator AlpA |
NC_010338 (Caulobacter sp. K31) |
4e-09 |
47 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
4e-09 |
44 |
|
transcriptional regulator |
NC_018522 (Klebsiella pneumoniae 1084) |
4e-09 |
48 |
|
hypothetical protein |
NC_021870 (Salmonella bongori N268-08) |
4e-09 |
48 |
|
hypothetical protein |
NC_020796 (Edwardsiella tarda C07-087) |
4e-09 |
46 |
|
hypothetical protein |
NC_011094 (Salmonella enterica CVM19633) |
4e-09 |
46 |
|
hypothetical protein |
NC_010694 (Erwinia tasmaniensis Et1/99) |
4e-09 |
45 |
|
putative transcriptional regulator |
NC_019973 (Mesorhizobium australicum WSM2073) |
4e-09 |
45 |
|
phage transcriptional regulator, AlpA |
NC_009485 (Bradyrhizobium sp. BTAi1) |
4e-09 |
43 |
|
prophage CP4-57 regulator |
NC_009445 (Bradyrhizobium sp. ORS278) |
4e-09 |
42 |
|
phage transcriptional regulator, AlpA |
NC_008036 (Sphingopyxis alaskensis RB2256) |
5e-09 |
43 |
|
Phage transcriptional regulator, AlpA |
NC_011748 (Escherichia coli 55989) |
5e-09 |
48 |
|
putative phage DNA binding protein |
NC_020796 (Edwardsiella tarda C07-087) |
5e-09 |
47 |
|
prophage CP4-57 regulatory protein |
NC_021149 (Azotobacter vinelandii CA) |
5e-09 |
44 |
|
prophage CP4-57 regulatory protein |
NC_021150 (Azotobacter vinelandii CA6) |
5e-09 |
44 |
|
prophage CP4-57 regulatory protein |
NC_012560 (Azotobacter vinelandii DJ) |
5e-09 |
44 |
|
hypothetical protein |
NC_013716 (Citrobacter rodentium ICC168) |
6e-09 |
47 |
|
DNA-binding protein |
NC_004578 (Pseudomonas syringae DC3000) |
7e-09 |
44 |
|
Transcriptional regulator, AlpA like protein |
NC_017309 (Edwardsiella tarda FL6-60) |
7e-09 |
50 |
|
phage transcriptional regulator, AlpA |
NC_015567 (Serratia plymuthica AS9) |
8e-09 |
46 |
|
phage transcriptional regulator, AlpA |
NC_015566 (Serratia sp. AS12) |
8e-09 |
46 |
|
phage transcriptional regulator AlpA |
NC_017573 (Serratia sp. AS13) |
8e-09 |
46 |
|
phage transcriptional regulator AlpA |
NC_012912 (Dickeya zeae Ech1591) |
8e-09 |
41 |
|
phage transcriptional regulator, AlpA |
NC_015554 (Alteromonas sp. SN2) |
9e-09 |
47 |
|
hypothetical protein |
NC_009792 (Citrobacter koseri ATCC BAA-895) |
1e-08 |
47 |
|
Phage transcriptional regulator, AlpA |
NC_017845 (Pectobacterium sp. SCC3193) |
1e-08 |
47 |
|
putative phage DNA binding protein |
NC_017656 (Escherichia coli RM12579) |
1e-08 |
45 |
|
regulatory protein |
NC_008253 (Escherichia coli 536) |
2e-08 |
45 |
|
putative regulatory protein |
NC_017652 (Escherichia coli clone D i14) |
2e-08 |
45 |
|
putative regulatory protein |
NC_017651 (Escherichia coli clone D i2) |
2e-08 |
45 |
|
regulatory protein |
NC_018079 (Enterobacter cloacae SDM) |
2e-08 |
47 |
|
putative regulatory protein from prophage (AlpA family) |
NC_011745 (Escherichia coli ED1a) |
2e-08 |
46 |
|
DNA-binding protein |
NC_014500 (Dickeya dadantii 3937) |
2e-08 |
41 |
|
hypothetical protein |
NC_014125 (Legionella pneumophila 2300/99 Alcoy) |
2e-08 |
45 |
|
prophage CP4-57 regulatory protein AlpA |
NC_009494 (Legionella pneumophila Corby) |
2e-08 |
45 |
|
putative transcriptional regulator |
NC_020304 (Desulfocapsa sulfexigens DSM 10523) |
3e-08 |
47 |
|
phage transcriptional regulator AlpA |
NC_008740 (Marinobacter aquaeolei VT8) |
3e-08 |
45 |
|
phage transcriptional regulator AlpA |
NC_011901 (Thioalkalivibrio sulfidophilus HL-EbGR7) |
3e-08 |
41 |
|
DNA-binding protein |
NC_003911 (Ruegeria pomeroyi DSS-3) |
4e-08 |
42 |
|
prophage regulatory protein |
NC_015580 (Novosphingobium sp. PP1Y) |
4e-08 |
44 |
|
phage transcriptional regulator, AlpA |
NC_008340 (Alkalilimnicola ehrlichii MLHE-1) |
5e-08 |
44 |
|
putative AlpA family transcriptional regulator |
NC_017075 (Rubrivivax gelatinosus IL144) |
5e-08 |
43 |
|
DNA-binding protein |
NC_020829 (Pseudomonas denitrificans ATCC 13867) |
5e-08 |
44 |
|
putative phage transcriptional AlpA-like regulator |
NC_017631 (Escherichia coli ABU 83972) |
6e-08 |
46 |
|
putative prophage transcriptional regulator |
NC_017633 (Escherichia coli ETEC H10407) |
6e-08 |
46 |
|
phage transcriptional regulator, AlpA |
NC_008309 (Haemophilus somnus 129PT) |
6e-08 |
41 |
|
hypothetical protein |
NC_013508 (Edwardsiella tarda EIB202) |
9e-08 |
42 |
|
phage transcriptional regulator, AlpA |
NC_022268 (Serratia sp. ATCC 39006) |
2e-07 |
44 |
|
hypothetical protein |
NC_020800 (Xanthomonas axonopodis Xac29-1) |
3e-07 |
42 |
|
prophage regulatory protein-like protein |
NC_020908 (Octadecabacter arcticus 238) |
3e-07 |
46 |
|
Prophage CP4-57 regulatory , AlpA-like protein |
NC_021149 (Azotobacter vinelandii CA) |
5e-07 |
46 |
|
Prophage CP4-57 regulatory , AlpA-like protein |
NC_021150 (Azotobacter vinelandii CA6) |
5e-07 |
46 |
|
Prophage CP4-57 regulatory , AlpA-like protein |
NC_012560 (Azotobacter vinelandii DJ) |
5e-07 |
46 |
|
phage regulatory protein |
NC_011274 (Salmonella enterica 287/91) |
5e-07 |
43 |
|
putative phage regulatory protein |
NC_022221 (Salmonella enterica CDC1983-67) |
5e-07 |
43 |
|
hypothetical protein |
NC_011205 (Salmonella enterica CT_02021853) |
5e-07 |
43 |
|
phage regulatory protein |
NC_011294 (Salmonella enterica P125109) |
5e-07 |
43 |
|
putative phage regulatory protein |
NC_016831 (Salmonella enterica RKS5078) |
5e-07 |
43 |
|
DNA-binding protein |
NC_021984 (Salmonella enterica S06004) |
5e-07 |
43 |
|
hypothetical protein |
NC_011149 (Salmonella enterica SL483) |
5e-07 |
43 |
|
DNA-binding transcriptional activator; CP4-57 prophage |
NC_017574 (Ralstonia solanacearum Po82) |
6e-07 |
42 |
|
AlpA family phage transcriptional regulator |
NC_017554 (Pantoea ananatis PA13) |
8e-07 |
44 |
|
Predicted transcriptional regulator |
NC_021046 (Enterobacter cloacae NCTC 9394) |
1e-06 |
44 |
|
DNA-binding protein |
NC_020307 (Salmonella enterica CFSAN001992) |
1e-06 |
44 |
|
prophage CP4-57 regulator |
NC_014923 (Mesorhizobium ciceri WSM1271) |
2e-06 |
42 |
|
phage transcriptional regulator AlpA |
NC_014217 (Starkeya novella DSM 506) |
3e-06 |
41 |
|
putative phage transcriptional regulator AlpA |
NC_020059 (Rhizobium tropici CIAT 899) |
4e-06 |
42 |
|
DNA binding protein from phage origin |
NC_018405 (Enterobacter cloacae ENHKU01) |
0.008 |
45 |
SELECT distinct ph.genome_accn, ph.id_genome_orf, ph.position_begin_pai, ph.position_end_pai, ph.position_begin_genome, ph.position_end_genome, ph.identity, ph.qcoverage, ph.tcoverage,
ph.evalue, ph.score, ph.multi_hsp, ph.multi_strand, ph.source_class, hsp, go.name, go.name_alt, go.pid
FROM pai_homolog as ph, genome_orf as go
WHERE ph.pai_accn='NC_002505_P5' AND ph.id_pai_orf='51' AND match_level='P'
AND go.genome_accn=ph.genome_accn AND ph.id_genome_orf=go.id_genome_orf
ORDER BY ph.score desc, ph.evalue asc, ph.identity desc