Spreadsheet: 92937d1292449110-return-a-value-from-the-same-row-that-match-2-conditions-blast_podo_forum
Sheet: Syn5 table of coord.txt

 | Cyanophage Syn5, complete genome
Gi | Product Name | Start | End | Strand | Length | GeneID | Locus | Locus_tag | COG(s)
148724444 | gp1 | 137 | 502 | + | 121 | 5220186 | 1 | CSV5_gp01 | - | 61806413
148724445 | gp2 | 790 | 960 | + | 56 | 5220190 | 2 | CSV5_gp02 | -
148724446 | gp3 | 961 | 1206 | + | 81 | 5220213 | 3 | CSV5_gp03 | -
148724447 | gp4 | 1230 | 1400 | + | 56 | 5220184 | 4 | CSV5_gp04 | -
148724448 | gp5 | 1745 | 2089 | + | 114 | 5220182 | 5 | CSV5_gp05 | -
148724449 | gp6 | 2103 | 2267 | + | 54 | 5220185 | 6 | CSV5_gp06 | -
148724450 | gp7 | 2270 | 2452 | + | 60 | 5220181 | 7 | CSV5_gp07 | -
148724451 | [NAME] | 2452 | 2556 | + | 34 | 5220158 | 8 | CSV5_gp08 | -
148724452 | gp9 | 2553 | 2714 | + | 53 | 5220175 | 9 | CSV5_gp09 | -
148724453 | gp10 | 2787 | 3140 | + | 117 | 5220156 | 10 | [NAME] | -
148724454 | gp11 | 3140 | 3241 | + | 33 | 5220173 | 11 | CSV5_gp11 | -
148724455 | gp12 | 3282 | 3482 | + | 66 | 5220170 | 12 | CSV5_gp12 | -
148724456 | [NAME] | 3479 | 3685 | + | 68 | 5220163 | 13 | CSV5_gp13 | -
148724457 | gp14 | 3667 | 4116 | + | 149 | 5220154 | 14 | CSV5_gp14 | -
148724458 | RNA polymerase | 4120 | 6459 | + | 779 | 5220157 | 15 | CSV5_gp15 | -
148724459 | gp16 | 6459 | 6614 | + | 51 | 5220159 | 16 | CSV5_gp16 | -
148724460 | integrase | 6614 | 7402 | + | 262 | 5220180 | 17 | CSV5_gp17 | -
148724461 | gp18 | 7392 | 7544 | + | 50 | 5220176 | 18 | CSV5_gp18 | -
148724462 | gp19 | 7619 | 7747 | + | 42 | 5220177 | 19 | CSV5_gp19 | -
148724463 | gp20 | 7747 | 7839 | + | 30 | 5220172 | 20 | CSV5_gp20 | -
148724464 | ssDNA binding protein | 7832 | 8410 | + | 192 | 5220178 | 21 | [NAME] | -
148724465 | endonuclease | 8410 | 8766 | + | 118 | 5220191 | 22 | CSV5_gp22 | -
148724466 | gp23 | 8751 | 8891 | + | 46 | 5220202 | 23 | CSV5_gp23 | -
148724467 | primase/helicase | 8884 | 10488 | + | 534 | 5220205 | 24 | CSV5_gp24 | -
148724468 | gp25 | 10475 | 10771 | + | 98 | 5220161 | 25 | CSV5_gp25 | -
148724469 | gp26 | 10768 | 11019 | + | 83 | 5220207 | 26 | CSV5_gp26 | -
148724470 | DNA polymerase | 11016 | 12767 | + | 583 | 5220203 | 27 | CSV5_gp27 | -
148724471 | gp28 | 12796 | 13128 | + | 110 | 5220155 | 28 | CSV5_gp28 | -
148724472 | exonuclease | 13118 | 13855 | + | 245 | 5220208 | 29 | CSV5_gp29 | -
148724473 | gp30 | 13852 | 14010 | + | 52 | 5220209 | 30 | [NAME] | -
148724474 | gp31 | 13988 | 14194 | + | 68 | 5220199 | 31 | [NAME] | -
148724475 | gp32 | 14184 | 14570 | + | 128 | 5220204 | 32 | CSV5_gp32 | -
148724476 | ribonucleotide reductase | 14570 | 15964 | + | 464 | 5220201 | 33 | CSV5_gp33 | -
148724477 | gp34 | 15964 | 16683 | + | 239 | 5220206 | 34 | CSV5_gp34 | -
148724478 | gp35 | 16676 | 16867 | + | 63 | 5220166 | 35 | CSV5_gp35 | -
148724479 | gp36 | 16860 | 17123 | + | 87 | 5220195 | 36 | CSV5_gp36 | -
148724480 | head to tail connector | 17125 | 18753 | + | 542 | 5220167 | 37 | CSV5_gp37 | -
148724481 | scaffolding protein | 18924 | 19754 | + | 276 | 5220200 | 38 | CSV5_gp38 | -
148724482 | major capsid protein | 20017 | 21015 | + | 332 | 5220210 | 39 | CSV5_gp39 | -
148724483 | tail tube A | 21072 | 21665 | + | 197 | 5220212 | 40 | [NAME] | -
148724484 | tail tube B | 21668 | 24385 | + | 905 | 5220174 | 41 | CSV5_gp41 | -
148724485 | gp42 | 24385 | 24909 | + | 174 | 5220168 | 42 | CSV5_gp42 | -
148724486 | internal virion protein | 24828 | 25532 | + | 234 | 5220192 | 43 | CSV5_gp43 | -
148724487 | internal virion protein | 25532 | 28042 | + | 836 | 5220160 | 44 | CSV5_gp44 | -
148724488 | internal virion protein | 28080 | 32327 | + | 1415 | 5220164 | 45 | CSV5_gp45 | -
148724489 | tail fiber | 32327 | 36382 | + | 1351 | 5220153 | 46 | CSV5_gp46 | -
148724490 | gp47 | 36392 | 36652 | + | 86 | 5220197 | 47 | CSV5_gp47 | -
148724491 | gp48 | 36665 | 36835 | + | 56 | 5220179 | 48 | CSV5_gp48 | -
148724492 | gp49 | 36839 | 37069 | + | 76 | 5220169 | 49 | [NAME] | -
148724493 | gp50 | 37069 | 37347 | + | 92 | 5220171 | 50 | CSV5_gp50 | -
148724494 | HNH endonuclease | 37369 | 37638 | + | 89 | 5220188 | 51 | CSV5_gp51 | -
148724495 | gp52 | 37638 | 37982 | + | 114 | 5220194 | 52 | CSV5_gp52 | -
148724496 | structural protein | 37982 | 39322 | + | 446 | 5220196 | 53 | CSV5_gp53 | -
148724497 | structural protein | 39335 | 41203 | + | 622 | 5220165 | 54 | CSV5_gp54 | -
148724498 | [NAME] | 41207 | 41677 | + | 156 | 5220183 | 55 | CSV5_gp55 | -
148724499 | gp56 | 41677 | 41889 | + | 70 | 5220198 | 56 | CSV5_gp56 | -
148724500 | gp57 | 41891 | 42286 | + | 131 | 5220187 | 57 | CSV5_gp57 | -
148724501 | structural protein | 42286 | 42795 | + | 169 | 5220162 | 58 | CSV5_gp58 | -
148724502 | gp59 | 42932 | 43060 | + | 42 | 5220193 | 59 | CSV5_gp59 | -
148724503 | DNA packaging protein | 43067 | 44791 | + | 574 | 5220189 | 60 | CSV5_gp60 | -
148724504 | thymidylate synthase | 45229 | 45720 | + | 163 | 5220211 | 61 | CSV5_gp61 | -
 | Prochlorococcus phage P-SSP7, complete genome
Gi | Product Name | Start | End | Strand | Length | GeneID | Locus | Locus_tag | COG(s)
61806402 | hypothetical protein PSSP7_001 | 145 | 882 | + | 245 | 3294743 | - | PSSP7_001 | -
61806403 | hypothetical protein PSSP7_002 | 911 | 1489 | + | 192 | 3294720 | gp12 | PSSP7_002 | -
61806404 | hypothetical protein PSSP7_003 | 1703 | 1969 | + | 88 | 3294726 | - | PSSP7_003 | -
61806405 | hypothetical protein PSSP7_004 | 1966 | 2196 | + | 76 | 3294740 | - | PSSP7_004 | -
61806406 | hypothetical protein [NAME] | 2193 | 2357 | + | 54 | 3294735 | - | [NAME] | -
61806407 | hypothetical protein PSSP7_006 | 2354 | 2536 | + | 60 | 3294722 | - | PSSP7_006 | -
61806408 | hypothetical protein PSSP7_007 | 2683 | 2793 | + | 36 | 3294716 | - | PSSP7_007 | -
61806409 | hypothetical protein PSSP7_008 | 2790 | 3128 | + | 112 | 3294744 | - | PSSP7_008 | -
61806410 | hypothetical protein PSSP7_009 | 3121 | 3255 | + | 44 | 3294728 | - | PSSP7_009 | -
61806411 | hypothetical protein [NAME] | 3300 | 3419 | + | 39 | 3294721 | - | PSSP7_010 | -
61806412 | gp0.7 | 3610 | 3984 | + | 124 | 3294718 | 0.7 | PSSP7_011 | -
61806413 | phage-related integrase | 3962 | 4834 | + | 290 | 3294717 | int | PSSP7_012 | -
61806414 | T7-like RNA polymerase | 5105 | 7441 | + | 778 | 3294710 | 1 | PSSP7_013 | -
61806415 | T7-like ssDNA binding protein | 7441 | 8010 | + | 189 | 3294697 | 2.5 | PSSP7_014 | -
61806416 | T7-like endonuclease | 8010 | 8360 | + | 116 | 3294733 | 3 | PSSP7_015 | -
61806417 | T7-like primase/helicase | 8357 | 9919 | + | 520 | 3294739 | 4 | PSSP7_016 | -
61806418 | hypothetical protein PSSP7_018 | 11763 | 12137 | + | 124 | 3294727 | - | PSSP7_018 | -
61806419 | T7-like exonuclease | 12134 | 12913 | + | 259 | 3294731 | 6 | PSSP7_019 | -
61806420 | ribonucleotide reductase domain | 13194 | 14600 | + | 468 | 3294715 | nrd | PSSP7_020 | -
61806421 | hypothetical protein PSSP7_021 | 14597 | 15310 | + | 237 | 3294732 | - | PSSP7_021 | -
61806422 | hypothetical protein PSSP7_022 | 15279 | 15470 | + | 63 | 3294738 | - | PSSP7_022 | -
61806423 | hypothetical protein PSSP7_023 | 15470 | 15751 | + | 93 | 3294741 | - | PSSP7_023 | -
61806424 | T7-like head-to-tail connector | 15751 | 17319 | + | 522 | 3294719 | 8 | PSSP7_024 | -
61806425 | T7-like capsid assembly protein | 17319 | 18116 | + | 265 | 3294742 | 9 | [NAME] | -
61806426 | hgh-light inducible protein | 18116 | 18307 | + | 63 | 3294734 | [NAME] | PSSP7_026 | -
61806427 | core photosystem II reaction center protein | 18308 | 19387 | + | 359 | 3294724 | psbA | PSSP7_027 | -
61806428 | hypothetical protein PSSP7_028 | 19462 | 19581 | + | 39 | 3294723 | - | PSSP7_028 | -
61806429 | T7-like capsid protein | 19888 | 21015 | + | 375 | 3294737 | 10 | PSSP7_029 | -
61806430 | T7-like tail tubular protein A | 21060 | 21674 | + | 204 | 3294707 | 11 | [NAME] | -
61806431 | T7-like tail tubular protein B | 21674 | 24604 | + | 976 | 3294702 | 12 | PSSP7_031 | -
61806432 | hypothetical protein PSSP7_032 | 24597 | 25043 | + | 148 | 3294736 | - | PSSP7_032 | -
61806433 | hypothetical protein PSSP7_033 | 25108 | 25623 | + | 171 | 3294747 | - | PSSP7_033 | -
61806434 | T7-like internal core protein | 25624 | 28137 | + | 837 | 3294701 | 15 | PSSP7_034 | -
61806435 | T7-like internal core protein | 28157 | 31894 | + | 1245 | 3294698 | 16 | PSSP7_035 | -
61806436 | T7-like tail fiber | 31931 | 34078 | + | 715 | 3294705 | 17 | PSSP7_036 | -
61806437 | hypothetical protein PSSP7_037 | 34082 | 34663 | + | 193 | 3294700 | - | [NAME] | -
61806438 | hypothetical protein PSSP7_038 | 34660 | 35256 | + | 198 | 3294708 | - | [NAME] | -
61806439 | hypothetical protein PSSP7_039 | 35256 | 35831 | + | 191 | 3294706 | - | PSSP7_039 | -
61806440 | hypothetical protein PSSP7_040 | 35859 | 36149 | + | 96 | 3294695 | - | PSSP7_040 | -
61806441 | hypothetical protein PSSP7_041 | 36161 | 36802 | + | 213 | 3294711 | - | PSSP7_041 | -
61806442 | hypothetical protein PSSP7_042 | 36805 | 37170 | + | 121 | 3294714 | - | PSSP7_042 | -
61806443 | hypothetical protein PSSP7_043 | 37134 | 37445 | + | 103 | 3294712 | - | PSSP7_043 | -
61806444 | hypothetical protein PSSP7_044 | 37442 | 37804 | + | 120 | 3294699 | - | PSSP7_044 | -
61806445 | hypothetical protein PSSP7_045 | 37849 | 38304 | + | 151 | 3294703 | - | PSSP7_045 | -
61806446 | hypothetical protein PSSP7_046 | 38413 | 38577 | + | 54 | 3294709 | - | PSSP7_046 | -
61806447 | hypothetical protein PSSP7_047 | 38574 | 38816 | + | 80 | 3294696 | - | PSSP7_047 | -
61806448 | hypothetical protein PSSP7_048 | 38800 | 39048 | + | 82 | 3294725 | - | PSSP7_048 | -
61806449 | possible endonuclease | 39045 | 39377 | + | 110 | 3294729 | - | PSSP7_049 | -
61806450 | hypothetical protein PSSP7_050 | 39425 | 41131 | + | 568 | 3294704 | - | PSSP7_050 | -
61806451 | DNA maturase beta subunit | 41147 | 42880 | + | 577 | 3294745 | 19 | PSSP7_051 | -
61806452 | hypothetical protein PSSP7_052 | 43037 | 43315 | + | 92 | 3294730 | - | PSSP7_052 | -
61806453 | hypothetical protein PSSP7_053 | 43308 | 43388 | + | 26 | 3294713 | - | PSSP7_053 | -
61806454 | transaldolase family protein | 43385 | 44029 | + | 214 | 3294746 | talC | PSSP7_054 | -