contig_metadata
41 rows where bioproject = "PRJNA1120060" and tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 243984 | 243984 | PRJNA1120060_P_NODE_1876041_length_278_cov_0.863415_g1858025_i0 | PRJNA1120060 | 1876041 | 278 | 0.863415 | 2.4002937 | Candidatus Annandia adelgestsuga | 1302411 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|1538953316|gb|CP026513.1| | 1302411 | g1858025 | i0 | 92.5 | 0.143884892086331 | 40 | 2 | 14 | 1 | 240 | 278 | 325574 | 325613 | Candidatus Annandia adelgestsuga isolate ENA chromosome | blastn | 40 | 56.5 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Annandia | Candidatus Annandia adelgestsuga | |
| 1513918 | 1513918 | PRJNA1120060_P_NODE_1534682_length_292_cov_1.173516_g1516693_i0 | PRJNA1120060 | 1534682 | 292 | 1.173516 | 3.42666672 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|2676815295|gb|CP144768.1| | 2608262 | g1516693 | i0 | 100 | 0.0958904109589041 | 28 | 0 | 10 | 0 | 169 | 196 | 180336 | 180309 | MAG: Candidatus Stammera capleta isolate AENCACNF chromosome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 1524377 | 1524377 | PRJNA1120060_P_NODE_2295962_length_261_cov_2.553191_g2277903_i0 | PRJNA1120060 | 2295962 | 261 | 2.553191 | 6.66382851 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 58.4 | 5.12e-4 | NTclustered | gi|2676815298|gb|CP144780.1| | 2608262 | g2277903 | i0 | 100 | 1.47509578544061 | 31 | 0 | 12 | 0 | 231 | 261 | 198868 | 198898 | MAG: Candidatus Stammera capleta isolate OIKJJOHF chromosome | blastn | 385 | 58.4 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 2791198 | 2791198 | PRJNA1120060_P_NODE_1634283_length_288_cov_0.925581_g1616286_i0 | PRJNA1120060 | 1634283 | 288 | 0.925581 | 2.66567328 | Candidatus Blochmannia vicinus (nom. nud.) | 251540 | Bacteria | Bacteria | 58.4 | 5.73e-4 | NTclustered | gi|2246424065|gb|CP097753.1| | 251540 | g1616286 | i0 | 100 | 0.322916666666667 | 31 | 0 | 11 | 0 | 96 | 126 | 381062 | 381092 | Candidatus Blochmannia vicinus strain C-039 chromosome, complete genome | blastn | 93 | 58.4 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Blochmanniella | Candidatus Blochmannia vicinus (nom. nud.) | |
| 4067196 | 4067196 | PRJNA1120060_P_NODE_1607204_length_289_cov_1.189815_g1589211_i0 | PRJNA1120060 | 1607204 | 289 | 1.189815 | 3.43856535 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|2676815375|gb|CP144853.1| | 2608262 | g1589211 | i0 | 100 | 0.0968858131487889 | 28 | 0 | 10 | 0 | 84 | 111 | 181006 | 180979 | MAG: Candidatus Stammera capleta isolate CBJPGBEN chromosome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 5357169 | 5357169 | PRJNA1120060_P_NODE_2627205_length_250_cov_2.079096_g2609125_i0 | PRJNA1120060 | 2627205 | 250 | 2.079096 | 5.19774 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2676815296|gb|CP144769.1| | 2608262 | g2609125 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 5 | 32 | 211022 | 211049 | MAG: Candidatus Stammera capleta isolate ICGHJNLO chromosome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 5362840 | 5362840 | PRJNA1120060_P_NODE_3125945_length_235_cov_2.129630_g3107843_i0 | PRJNA1120060 | 3125945 | 235 | 2.12963 | 5.0046305 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.021 | NTclustered | gi|1925240896|gb|CP043973.1| | 2608262 | g3107843 | i0 | 100 | 0.119148936170213 | 28 | 0 | 12 | 0 | 4 | 31 | 130648 | 130675 | MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 5372495 | 5372495 | PRJNA1120060_P_NODE_659045_length_339_cov_3.274436_g641261_i0 | PRJNA1120060 | 659045 | 339 | 3.274436 | 11.10033804 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.032 | NTclustered | gi|2676815311|gb|CP144782.1| | 2608262 | g641261 | i0 | 100 | 0.0825958702064897 | 28 | 0 | 8 | 0 | 89 | 116 | 150851 | 150824 | MAG: Candidatus Stammera capleta isolate GKJPGKMO chromosome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 5374523 | 5374523 | PRJNA1120060_P_NODE_808405_length_319_cov_3.146341_g790510_i0 | PRJNA1120060 | 808405 | 319 | 3.146341 | 10.03682779 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.03 | NTclustered | gi|1925240917|gb|CP043985.1| | 2608262 | g790510 | i0 | 100 | 0.0877742946708464 | 28 | 0 | 9 | 0 | 165 | 192 | 117905 | 117932 | MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 6128661 | 6128661 | PRJNA1120060_P_NODE_1843285_length_279_cov_1.718447_g1825270_i0 | PRJNA1120060 | 1843285 | 279 | 1.718447 | 4.79446713 | Candidatus Blochmanniella | 203804 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|2246428341|gb|CP097759.1| | 700220 | g1825270 | i0 | 96.875 | 0.229390681003584 | 32 | 0 | 11 | 1 | 75 | 106 | 212506 | 212536 | Blochmannia endosymbiont of Camponotus sp. strain C-018 chromosome, complete genome | blastn | 64 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Blochmanniella | Blochmannia endosymbiont of Camponotus sp. | |
| 6616054 | 6616054 | PRJNA1120060_P_NODE_145366_length_511_cov_5.381279_g129618_i0 | PRJNA1120060 | 145366 | 511 | 5.381279 | 27.49833569 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 54.7 | 0.014 | NTclustered | gi|2676815370|gb|CP144843.1| | 2608262 | g129618 | i0 | 96.875 | 0.0626223091976517 | 32 | 1 | 6 | 0 | 281 | 312 | 227646 | 227615 | MAG: Candidatus Stammera capleta isolate BAJEDFMN chromosome | blastn | 32 | 54.7 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 6623562 | 6623562 | PRJNA1120060_P_NODE_1991866_length_273_cov_1.755000_g1973838_i0 | PRJNA1120060 | 1991866 | 273 | 1.755 | 4.79115 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|1925240917|gb|CP043985.1| | 2608262 | g1973838 | i0 | 100 | 0.102564102564103 | 28 | 0 | 10 | 0 | 243 | 270 | 155417 | 155390 | MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 6624623 | 6624623 | PRJNA1120060_P_NODE_2072806_length_270_cov_1.243655_g2054769_i0 | PRJNA1120060 | 2072806 | 270 | 1.243655 | 3.3578685 | Candidatus Blochmanniella pennsylvanica | 101534 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2224893745|gb|CP095401.1| | 101534 | g2054769 | i0 | 100 | 0.21481481481481501 | 30 | 0 | 11 | 0 | 123 | 152 | 295265 | 295294 | Candidatus Blochmanniella pennsylvanica isolate B_Penn7 chromosome, complete genome | blastn | 58 | 56.5 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Blochmanniella | Candidatus Blochmanniella pennsylvanica | |
| 7403243 | 7403243 | PRJNA1120060_P_NODE_1378566_length_299_cov_1.331858_g1360589_i0 | PRJNA1120060 | 1378566 | 299 | 1.331858 | 3.98225542 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.028 | NTclustered | gi|1011040111|emb|LN999832.1| | 1070130 | g1360589 | i0 | 100 | 0.280936454849498 | 28 | 0 | 9 | 0 | 110 | 137 | 98133 | 98160 | Enterobacteriaceae bacterium symbiont of Ferrisia virgata isolate GEFVIR genome assembly, chromosome: I | blastn | 84 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Gullanella | Candidatus Gullanella endobia | |
| 9161901 | 9161901 | PRJNA1120060_P_NODE_1184208_length_310_cov_3.797468_g1166268_i0 | PRJNA1120060 | 1184208 | 310 | 3.797468 | 11.7721508 | Blochmannia endosymbiont of Camponotus modoc | 2945587 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2246427729|gb|CP097758.1| | 2945587 | g1166268 | i0 | 100 | 0.0967741935483871 | 30 | 0 | 10 | 0 | 58 | 87 | 704843 | 704814 | Blochmannia endosymbiont of Camponotus modoc strain C-019 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Blochmanniella | Blochmannia endosymbiont of Camponotus modoc | |
| 9163157 | 9163157 | PRJNA1120060_P_NODE_1262108_length_309_cov_1.915254_g1244167_i0 | PRJNA1120060 | 1262108 | 309 | 1.915254 | 5.91813486 | Candidatus Tachikawaea gelatinosa | 1410383 | Bacteria | Bacteria | 54.7 | 0.008 | NTclustered | gi|686207191|dbj|AP014521.1| | 1410383 | g1244167 | i0 | 96.97 | 0.106796116504854 | 33 | 0 | 11 | 1 | 172 | 204 | 366719 | 366688 | Candidatus Tachikawaea gelatinosa DNA, complete genome | blastn | 33 | 54.7 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Tachikawaea | Candidatus Tachikawaea gelatinosa | |
| 9187129 | 9187129 | PRJNA1120060_P_NODE_3108048_length_235_cov_5.870370_g3089946_i0 | PRJNA1120060 | 3108048 | 235 | 5.87037 | 13.7953695 | Candidatus Dasytiphilus stammeri | 1895663 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2689080379|gb|CP145881.1| | 1895663 | g3089946 | i0 | 94.444 | 0.153191489361702 | 36 | 2 | 15 | 0 | 181 | 216 | 373466 | 373431 | MAG: Candidatus Dasytiphilus stammeri isolate Dsp02 chromosome | blastn | 36 | 56.5 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Dasytiphilus | Candidatus Dasytiphilus stammeri | |
| 10458874 | 10458874 | PRJNA1120060_P_NODE_2766989_length_247_cov_0.890805_g2748905_i0 | PRJNA1120060 | 2766989 | 247 | 0.890805 | 2.20028835 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2676815311|gb|CP144782.1| | 2608262 | g2748905 | i0 | 100 | 0.117408906882591 | 29 | 0 | 12 | 0 | 50 | 78 | 186594 | 186622 | MAG: Candidatus Stammera capleta isolate GKJPGKMO chromosome | blastn | 29 | 54.7 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 11721110 | 11721110 | PRJNA1120060_P_NODE_1765090_length_282_cov_2.440191_g1747079_i0 | PRJNA1120060 | 1765090 | 282 | 2.440191 | 6.88133862 | Candidatus Blochmanniella pennsylvanica | 101534 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2224893745|gb|CP095401.1| | 101534 | g1747079 | i0 | 100 | 0.205673758865248 | 30 | 0 | 11 | 0 | 1 | 30 | 295294 | 295265 | Candidatus Blochmanniella pennsylvanica isolate B_Penn7 chromosome, complete genome | blastn | 58 | 56.5 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Blochmanniella | Candidatus Blochmanniella pennsylvanica | |
| 11734256 | 11734256 | PRJNA1120060_P_NODE_2786490_length_246_cov_2.526012_g2768404_i0 | PRJNA1120060 | 2786490 | 246 | 2.526012 | 6.21398952 | Candidatus Dasytiphilus stammeri | 1895663 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2689085891|gb|CP145882.1| | 1895663 | g2768404 | i0 | 96.875 | 0.130081300813008 | 32 | 1 | 13 | 0 | 196 | 227 | 451965 | 451996 | MAG: Candidatus Dasytiphilus stammeri isolate Dsp01 chromosome | blastn | 32 | 54.7 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Dasytiphilus | Candidatus Dasytiphilus stammeri | |
| 11750924 | 11750924 | PRJNA1120060_P_NODE_875810_length_313_cov_0.991667_g857886_i0 | PRJNA1120060 | 875810 | 313 | 0.991667 | 3.10391771 | Candidatus Dasytiphilus stammeri | 1895663 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2689070146|gb|CP145873.1| | 1895663 | g857886 | i0 | 100 | 0.0958466453674121 | 30 | 0 | 10 | 0 | 108 | 137 | 313608 | 313637 | MAG: Candidatus Dasytiphilus stammeri isolate Lsp01 chromosome | blastn | 30 | 56.5 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Dasytiphilus | Candidatus Dasytiphilus stammeri | |
| 11751123 | 11751123 | PRJNA1120060_P_NODE_888730_length_312_cov_5.648536_g870802_i0 | PRJNA1120060 | 888730 | 312 | 5.648536 | 17.62343232 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 54.7 | 0.008 | NTclustered | gi|2676815335|gb|CP144810.1| | 2608262 | g870802 | i0 | 96.875 | 0.102564102564103 | 32 | 1 | 10 | 0 | 1 | 32 | 169486 | 169455 | MAG: Candidatus Stammera capleta isolate ECOKPGPJ chromosome | blastn | 32 | 54.7 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 12989543 | 12989543 | PRJNA1120060_P_NODE_1286031_length_307_cov_9.273504_g1268086_i0 | PRJNA1120060 | 1286031 | 307 | 9.273504 | 28.46965728 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|2676815317|gb|CP144796.1| | 2608262 | g1268086 | i0 | 100 | 0.0912052117263844 | 28 | 0 | 9 | 0 | 85 | 112 | 1697 | 1724 | MAG: Candidatus Stammera capleta isolate IDODFKOK chromosome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 12993504 | 12993504 | PRJNA1120060_P_NODE_156791_length_501_cov_1.525701_g140857_i0 | PRJNA1120060 | 156791 | 501 | 1.525701 | 7.64376201 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.049 | NTclustered | gi|2676815298|gb|CP144780.1| | 2608262 | g140857 | i0 | 91.892 | 0.0738522954091816 | 37 | 3 | 7 | 0 | 445 | 481 | 156659 | 156623 | MAG: Candidatus Stammera capleta isolate OIKJJOHF chromosome | blastn | 37 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 14285184 | 14285184 | PRJNA1120060_P_NODE_2830732_length_245_cov_2.232558_g2812646_i0 | PRJNA1120060 | 2830732 | 245 | 2.232558 | 5.4697671 | secondary endosymbiont of Heteropsylla cubana | 134287 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|400364260|gb|CP003547.1| | 134287 | g2812646 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 16 | 43 | 150525 | 150498 | Secondary endosymbiont of Heteropsylla cubana isolate Hcub_S chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | secondary endosymbiont of Heteropsylla cubana | ||
| 15569307 | 15569307 | PRJNA1120060_P_NODE_459293_length_375_cov_2.274834_g441746_i0 | PRJNA1120060 | 459293 | 375 | 2.274834 | 8.5306275 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.036 | NTclustered | gi|2676815344|gb|CP144815.1| | 2608262 | g441746 | i0 | 100 | 0.0746666666666667 | 28 | 0 | 7 | 0 | 94 | 121 | 236385 | 236358 | MAG: Candidatus Stammera capleta isolate KGPCFMKM chromosome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 16837497 | 16837497 | PRJNA1120060_P_NODE_3194714_length_231_cov_5.924051_g3176607_i0 | PRJNA1120060 | 3194714 | 231 | 5.924051 | 13.68455781 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.021 | NTclustered | gi|2676815332|gb|CP144805.1| | 2608262 | g3176607 | i0 | 100 | 0.121212121212121 | 28 | 0 | 12 | 0 | 73 | 100 | 212332 | 212359 | MAG: Candidatus Stammera capleta isolate LBLEAMOG chromosome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 18099824 | 18099824 | PRJNA1120060_P_NODE_2176835_length_266_cov_1.243523_g2158786_i0 | PRJNA1120060 | 2176835 | 266 | 1.243523 | 3.30777118 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2676815375|gb|CP144853.1| | 2608262 | g2158786 | i0 | 100 | 0.214285714285714 | 29 | 0 | 11 | 0 | 31 | 59 | 181008 | 180980 | MAG: Candidatus Stammera capleta isolate CBJPGBEN chromosome | blastn | 57 | 54.7 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 18109656 | 18109656 | PRJNA1120060_P_NODE_2981215_length_242_cov_0.905325_g2963121_i0 | PRJNA1120060 | 2981215 | 242 | 0.905325 | 2.1908865 | Candidatus Blochmanniella camponoti | 108080 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2246420380|gb|CP097750.1| | 108080 | g2963121 | i0 | 100 | 0.347107438016529 | 28 | 0 | 12 | 0 | 206 | 233 | 271185 | 271212 | Candidatus Blochmanniella camponoti strain C-050 chromosome, complete genome | blastn | 84 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Blochmanniella | Candidatus Blochmanniella camponoti | |
| 19362043 | 19362043 | PRJNA1120060_P_NODE_1313576_length_305_cov_3.564655_g1295619_i0 | PRJNA1120060 | 1313576 | 305 | 3.564655 | 10.87219775 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.028 | NTclustered | gi|2676815295|gb|CP144768.1| | 2608262 | g1295619 | i0 | 96.875 | 0.104918032786885 | 32 | 0 | 10 | 1 | 18 | 48 | 239327 | 239296 | MAG: Candidatus Stammera capleta isolate AENCACNF chromosome | blastn | 32 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 19386182 | 19386182 | PRJNA1120060_P_NODE_3190456_length_232_cov_2.207547_g3172350_i0 | PRJNA1120060 | 3190456 | 232 | 2.207547 | 5.12150904 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 58.4 | 4.46e-4 | NTclustered | gi|2676815298|gb|CP144780.1| | 2608262 | g3172350 | i0 | 100 | 0.375 | 31 | 0 | 13 | 0 | 106 | 136 | 90634 | 90664 | MAG: Candidatus Stammera capleta isolate OIKJJOHF chromosome | blastn | 87 | 58.4 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 19395086 | 19395086 | PRJNA1120060_P_NODE_649416_length_341_cov_0.854478_g631644_i0 | PRJNA1120060 | 649416 | 341 | 0.854478 | 2.91376998 | Candidatus Hartigia pinicola | 1345115 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2119947094|gb|CP048208.1| | 1345115 | g631644 | i0 | 94.595 | 0.108504398826979 | 37 | 1 | 11 | 1 | 240 | 276 | 1552177 | 1552142 | Candidatus Hartigia pinicola isolate Ad13-065 chromosome | blastn | 37 | 56.5 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Hartigia | Candidatus Hartigia pinicola | |
| 19397554 | 19397554 | PRJNA1120060_P_NODE_825196_length_317_cov_3.127049_g807287_i0 | PRJNA1120060 | 825196 | 317 | 3.127049 | 9.91274533 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 58.4 | 6.38e-4 | NTclustered | gi|2676815323|gb|CP144799.1| | 2608262 | g807287 | i0 | 100 | 0.0977917981072555 | 31 | 0 | 10 | 0 | 274 | 304 | 116912 | 116882 | MAG: Candidatus Stammera capleta isolate KBEPEHBJ chromosome | blastn | 31 | 58.4 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 20637547 | 20637547 | PRJNA1120060_P_NODE_1332437_length_303_cov_3.573913_g1314472_i0 | PRJNA1120060 | 1332437 | 303 | 3.573913 | 10.82895639 | Candidatus Tachikawaea gelatinosa | 1410383 | Bacteria | Bacteria | 52.8 | 0.028 | NTclustered | gi|686207191|dbj|AP014521.1| | 1410383 | g1314472 | i0 | 100 | 0.0924092409240924 | 28 | 0 | 9 | 0 | 72 | 99 | 129578 | 129551 | Candidatus Tachikawaea gelatinosa DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Tachikawaea | Candidatus Tachikawaea gelatinosa | |
| 20649793 | 20649793 | PRJNA1120060_P_NODE_2215897_length_264_cov_2.659686_g2197844_i0 | PRJNA1120060 | 2215897 | 264 | 2.659686 | 7.02157104 | Candidatus Gullanella endobia | 1070130 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|1011040111|emb|LN999832.1| | 1070130 | g2197844 | i0 | 96.774 | 0.117424242424242 | 31 | 1 | 12 | 0 | 68 | 98 | 806070 | 806040 | Enterobacteriaceae bacterium symbiont of Ferrisia virgata isolate GEFVIR genome assembly, chromosome: I | blastn | 31 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Gullanella | Candidatus Gullanella endobia | |
| 21932763 | 21932763 | PRJNA1120060_P_NODE_2813058_length_246_cov_0.878613_g2794972_i0 | PRJNA1120060 | 2813058 | 246 | 0.878613 | 2.16138798 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2676815340|gb|CP144813.1| | 2608262 | g2794972 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 186 | 213 | 222390 | 222363 | MAG: Candidatus Stammera capleta isolate DOCHLPPF chromosome | blastn | 28 | 52.8 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 23223977 | 23223977 | PRJNA1120060_P_NODE_820399_length_318_cov_1.477551_g802495_i0 | PRJNA1120060 | 820399 | 318 | 1.477551 | 4.69861218 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 54.7 | 0.008 | NTclustered | gi|2676815380|gb|CP144850.1| | 2608262 | g802495 | i0 | 100 | 0.0911949685534591 | 29 | 0 | 9 | 0 | 287 | 315 | 110801 | 110773 | MAG: Candidatus Stammera capleta isolate BHILEGBA chromosome | blastn | 29 | 54.7 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 24472588 | 24472588 | PRJNA1120060_P_NODE_2048540_length_271_cov_1.176768_g2030503_i0 | PRJNA1120060 | 2048540 | 271 | 1.176768 | 3.18904128 | Candidatus Hartigia pinicola | 1345115 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2119947094|gb|CP048208.1| | 1345115 | g2030503 | i0 | 100 | 0.11070110701107 | 30 | 0 | 11 | 0 | 223 | 252 | 844044 | 844073 | Candidatus Hartigia pinicola isolate Ad13-065 chromosome | blastn | 30 | 56.5 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Hartigia | Candidatus Hartigia pinicola | |
| 24480169 | 24480169 | PRJNA1120060_P_NODE_2647700_length_250_cov_0.870056_g2629620_i0 | PRJNA1120060 | 2647700 | 250 | 0.870056 | 2.17514 | Candidatus Stammera capleta | 2608262 | Bacteria | Bacteria | 58.4 | 4.87e-4 | NTclustered | gi|2676815335|gb|CP144810.1| | 2608262 | g2629620 | i0 | 100 | 0.472 | 31 | 0 | 12 | 0 | 217 | 247 | 144014 | 143984 | MAG: Candidatus Stammera capleta isolate ECOKPGPJ chromosome | blastn | 118 | 58.4 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Stammera | Candidatus Stammera capleta | |
| 25253534 | 25253534 | PRJNA1120060_P_NODE_742560_length_328_cov_0.898039_g724711_i0 | PRJNA1120060 | 742560 | 328 | 0.898039 | 2.94556792 | Candidatus Blochmanniella | 203804 | Bacteria | Bacteria | 54.7 | 0.009 | NTclustered | gi|2246420380|gb|CP097750.1| | 108080 | g724711 | i0 | 100 | 0.530487804878049 | 29 | 0 | 9 | 0 | 250 | 278 | 713530 | 713502 | Candidatus Blochmanniella camponoti strain C-050 chromosome, complete genome | blastn | 174 | 54.7 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Blochmanniella | Candidatus Blochmanniella camponoti | |
| 30354155 | 30354155 | PRJNA1120060_P_NODE_2855212_length_245_cov_0.877907_g2837126_i0 | PRJNA1120060 | 2855212 | 245 | 0.877907 | 2.15087215 | Blochmannia endosymbiont of Polyrhachis (Hedomyrma) turneri | 1505596 | Bacteria | Bacteria | 41.6 | 0.033 | NR | WP_046288712.1 | 1505596 | g2837126 | i0 | 42.4 | 0.722448979591837 | 59 | 31 | 72.2 | 2 | 36 | 212 | 41 | 96 | WP_046288712.1 50S ribosomal protein L22 [Blochmannia endosymbiont of Polyrhachis (Hedomyrma) turneri] | diamond | 177 | 41.6 | 1 | Bacteria | ant, tsetse, mealybug, aphid, etc. endosymbionts | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Candidatus Blochmanniella | Blochmannia endosymbiont of Polyrhachis (Hedomyrma) turneri |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;