RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA1148190" and tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • ant, tsetse, mealybug, aphid, etc. endosymbionts · 25 ✖

bioproject 1

  • PRJNA1148190 · 25 ✖
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
1570346 1570346 PRJNA1148190_P_NODE_444802_length_277_cov_1.764706_g433629_i0 PRJNA1148190 444802 277 1.764706 4.88823562 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.025   NTclustered gi|1925240903|gb|CP043978.1| 2608262 g433629 i0 100 0.101083032490975 28 0 10 0 216 243 227262 227235 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
4124058 4124058 PRJNA1148190_P_NODE_543384_length_258_cov_1.567568_g532211_i0 PRJNA1148190 543384 258 1.567568 4.04432544 Candidatus Dasytiphilus stammeri 1895663 Bacteria Bacteria 52.8 0.023   NTclustered gi|2689070146|gb|CP145873.1| 1895663 g532211 i0 100 0.108527131782946 28 0 11 0 160 187 284282 284309 MAG: Candidatus Dasytiphilus stammeri isolate Lsp01 chromosome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Dasytiphilus Candidatus Dasytiphilus stammeri
4126607 4126607 PRJNA1148190_P_NODE_744864_length_243_cov_0.905882_g733691_i0 PRJNA1148190 744864 243 0.905882 2.20129326 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.022   NTclustered gi|2676815349|gb|CP144819.1| 2608262 g733691 i0 94.286 0.288065843621399 35 0 14 2 211 243 90269 90303 MAG: Candidatus Stammera capleta isolate EPMLGANN chromosome blastn 70 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
4864446 4864446 PRJNA1148190_P_NODE_785424_length_241_cov_0.916667_g774251_i0 PRJNA1148190 785424 241 0.916667 2.20916747 Gammaproteobacteria 1236 Bacteria Bacteria 122 1.6299999999999994e-23   NTclustered gi|2246424065|gb|CP097753.1| 251540 g774251 i0 78.689 4.70954356846473 183 39 76 0 4 186 82164 82346 Candidatus Blochmannia vicinus strain C-039 chromosome, complete genome blastn 1135 122 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmannia vicinus (nom. nud.)
5396110 5396110 PRJNA1148190_P_NODE_252085_length_342_cov_1.661710_g240915_i0 PRJNA1148190 252085 342 1.66171 5.6830482 Candidatus Stammera capleta 2608262 Bacteria Bacteria 54.7 0.009   NTclustered gi|2676815314|gb|CP144793.1| 2608262 g240915 i0 100 0.248538011695906 29 0 8 0 93 121 298993 298965 MAG: Candidatus Stammera capleta isolate KPIKDOKP chromosome blastn 85 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
5402532 5402532 PRJNA1148190_P_NODE_727645_length_244_cov_0.900585_g716472_i0 PRJNA1148190 727645 244 0.900585 2.1974274 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.022   NTclustered gi|2676815340|gb|CP144813.1| 2608262 g716472 i0 100 0.344262295081967 28 0 11 0 93 120 140873 140900 MAG: Candidatus Stammera capleta isolate DOCHLPPF chromosome blastn 84 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
6138639 6138639 PRJNA1148190_P_NODE_606265_length_250_cov_0.870056_g595092_i0 PRJNA1148190 606265 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 52.8 0.023   NTclustered gi|2246420991|gb|CP097762.1| 251538 g595092 i0 100 0.224 28 0 11 0 221 248 87815 87788 Candidatus Blochmannia ocreatus strain C-006 chromosome, complete genome blastn 56 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmannia ocreatus (nom. nud.)
6671927 6671927 PRJNA1148190_P_NODE_329226_length_308_cov_1.446809_g318053_i0 PRJNA1148190 329226 308 1.446809 4.45617172 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.029   NTclustered gi|2676815342|gb|CP144817.1| 2608262 g318053 i0 96.875 0.103896103896104 32 0 10 1 248 279 228786 228816 MAG: Candidatus Stammera capleta isolate HMMJOMFK chromosome blastn 32 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
6673740 6673740 PRJNA1148190_P_NODE_451966_length_276_cov_1.290640_g440793_i0 PRJNA1148190 451966 276 1.29064 3.5621664 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.025   NTclustered gi|2676815326|gb|CP144802.1| 2608262 g440793 i0 100 0.202898550724638 28 0 10 0 125 152 144169 144142 MAG: Candidatus Stammera capleta isolate HDEGCJIM chromosome blastn 56 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
6676749 6676749 PRJNA1148190_P_NODE_673946_length_246_cov_2.034682_g662773_i0 PRJNA1148190 673946 246 2.034682 5.00531772 Symbiopectobacterium purcellii 2871826 Bacteria Bacteria 52.8 0.022   NTclustered gi|2087438146|gb|CP081864.1| 2871826 g662773 i0 100 0.113821138211382 28 0 11 0 82 109 4910854 4910881 Symbiopectobacterium purcellii strain SyEd1 chromosome, complete genome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Symbiopectobacterium Symbiopectobacterium purcellii
7412151 7412151 PRJNA1148190_P_NODE_208926_length_370_cov_0.774411_g197756_i0 PRJNA1148190 208926 370 0.774411 2.8653207 Candidatus Blochmanniella 203804 Bacteria Bacteria 130 1.09e-34   NR WP_275451392.1 1505596 g197756 i0 49.2 5.72432432432432 120 61 97.3 0 368 9 57 176 WP_275451392.1 polyprenyl diphosphate synthase [Blochmannia endosymbiont of Polyrhachis (Hedomyrma) turneri] diamond 2118 131 0.99236641221374 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Polyrhachis (Hedomyrma) turneri
9222986 9222986 PRJNA1148190_P_NODE_384808_length_289_cov_1.435185_g373635_i0 PRJNA1148190 384808 289 1.435185 4.14768465 Candidatus Stammera capleta 2608262 Bacteria Bacteria 78.7 4.41e-10   NTclustered gi|2676815308|gb|CP144771.1| 2608262 g373635 i0 81 0.477508650519031 100 17 34 2 143 241 35576 35674 MAG: Candidatus Stammera capleta isolate POADKOJP chromosome blastn 138 78.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
9223967 9223967 PRJNA1148190_P_NODE_454988_length_275_cov_1.698020_g443815_i0 PRJNA1148190 454988 275 1.69802 4.669555 Candidatus Stammera capleta 2608262 Bacteria Bacteria 167 8.65e-37   NTclustered gi|1925240913|gb|CP043983.1| 2608262 g443815 i0 80.172 9.09818181818182 232 38 83 4 1 228 30439 30666 MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome blastn 2502 167 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
9962201 9962201 PRJNA1148190_P_NODE_174008_length_400_cov_1.663609_g162839_i0 PRJNA1148190 174008 400 1.663609 6.654436 Candidatus Williamhamiltonella 568987 Bacteria Bacteria 52.8 0.038   NTclustered gi|1389176145|gb|CP021663.1| 138072 g162839 i0 100 0.76 28 0 7 0 38 65 620858 620831 Candidatus Hamiltonella defensa strain 5D chromosome blastn 304 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Williamhamiltonella Candidatus Williamhamiltonella defendens
14321376 14321376 PRJNA1148190_P_NODE_221912_length_360_cov_1.609756_g210742_i0 PRJNA1148190 221912 360 1.609756 5.7951216 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.034   NTclustered gi|2676815338|gb|CP144808.1| 2608262 g210742 i0 100 0.0777777777777778 28 0 8 0 1 28 83859 83832 MAG: Candidatus Stammera capleta isolate JNFEHELC chromosome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
14324076 14324076 PRJNA1148190_P_NODE_402052_length_286_cov_1.201878_g390879_i0 PRJNA1148190 402052 286 1.201878 3.43737108 Candidatus Purcelliella pentastirinorum 472834 Bacteria Bacteria 52.8 0.026   NTclustered gi|2446695481|gb|CP110496.1| 472834 g390879 i0 96.774 0.108391608391608 31 1 11 0 180 210 478031 478001 Candidatus Purcelliella pentastirinorum isolate OPOL2 chromosome, complete genome blastn 31 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Purcelliella Candidatus Purcelliella pentastirinorum
15063165 15063165 PRJNA1148190_P_NODE_479452_length_270_cov_2.776650_g468279_i0 PRJNA1148190 479452 270 2.77665 7.496955 Candidatus Regiella 568988 Bacteria Bacteria 80.5 3.7e-17   NR WP_176487892.1 138073 g468279 i0 59.3 7.2 59 24 65.6 0 91 267 1 59 WP_176487892.1 IS630 transposase-related protein [Candidatus Regiella insecticola] diamond 1944 80.9 0.995055624227441 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Regiella Candidatus Regiella insecticola
16868245 16868245 PRJNA1148190_P_NODE_143214_length_439_cov_1.939891_g132049_i0 PRJNA1148190 143214 439 1.939891 8.51612149 Candidatus Stammera capleta 2608262 Bacteria Bacteria 143 2.45e-29   NTclustered gi|2676815295|gb|CP144768.1| 2608262 g132049 i0 82.353 2.9248291571754 170 24 38 6 12 179 94429 94264 MAG: Candidatus Stammera capleta isolate AENCACNF chromosome blastn 1284 143 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
19419360 19419360 PRJNA1148190_P_NODE_272356_length_332_cov_1.482625_g261185_i0 PRJNA1148190 272356 332 1.482625 4.922315 Candidatus Annandia adelgestsuga 1302411 Bacteria Bacteria 56.5 0.002   NTclustered gi|1538953316|gb|CP026513.1| 1302411 g261185 i0 92.308 0.210843373493976 39 3 12 0 143 181 15474 15436 Candidatus Annandia adelgestsuga isolate ENA chromosome blastn 70 56.5 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Annandia Candidatus Annandia adelgestsuga
19419408 19419408 PRJNA1148190_P_NODE_276516_length_330_cov_1.575875_g265345_i0 PRJNA1148190 276516 330 1.575875 5.2003875 Candidatus Stammera capleta 2608262 Bacteria Bacteria 56.5 0.002   NTclustered gi|2676815332|gb|CP144805.1| 2608262 g265345 i0 96.97 0.184848484848485 33 1 10 0 29 61 192794 192762 MAG: Candidatus Stammera capleta isolate LBLEAMOG chromosome blastn 61 56.5 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
20699218 20699218 PRJNA1148190_P_NODE_587317_length_251_cov_0.865169_g576144_i0 PRJNA1148190 587317 251 0.865169 2.17157419 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.023   NTclustered gi|2676815303|gb|CP144777.1| 2608262 g576144 i0 100 0.111553784860558 28 0 11 0 122 149 240834 240861 MAG: Candidatus Stammera capleta isolate HOMCCPGJ chromosome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
22711153 22711153 PRJNA1148190_P_NODE_207578_length_371_cov_0.929530_g196408_i0 PRJNA1148190 207578 371 0.92953 3.4485563 root 1 Root_unresolved Root_unresolved 86.1 3.48e-12   NTclustered gi|2676815300|gb|CP144774.1| 2608262 g196408 i0 93.22 7.455525606469 59 3 16 1 185 242 97290 97232 MAG: Candidatus Stammera capleta isolate IBJCIBIM chromosome blastn 2766 86.1 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
26869939 26869939 PRJNA1148190_P_NODE_28241_length_1358_cov_3.228016_g18831_i0 PRJNA1148190 28241 1358 3.228016 43.83645728 Gammaproteobacteria 1236 Bacteria Bacteria 311 1.41e-95   NR WP_100096984.1 138072 g18831 i0 49.7 2.11855670103093 320 154 69.8 3 1358 411 319 635 WP_100096984.1 DNA polymerase [Candidatus Hamiltonella defensa] diamond 2877 313 0.993610223642173 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Williamhamiltonella Candidatus Williamhamiltonella defendens
30387270 30387270 PRJNA1148190_P_NODE_269013_length_334_cov_1.053640_g257842_i0 PRJNA1148190 269013 334 1.05364 3.5191576 Candidatus Hamiltonella defensa 138072 Bacteria Bacteria 70.9 2.86e-12   NR WP_095034123.1 138072 g257842 i0 79.5 1.58083832335329 44 9 39.5 0 135 4 1 44 WP_095034123.1 AAA family ATPase [Candidatus Hamiltonella defensa] diamond 528 70.9 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Williamhamiltonella Candidatus Williamhamiltonella defendens
31102185 31102185 PRJNA1148190_P_NODE_709635_length_245_cov_0.895349_g698462_i0 PRJNA1148190 709635 245 0.895349 2.19360505 Gammaproteobacteria 1236 Bacteria Bacteria 57.4 4.8e-8   NR WP_012737990.1 138072 g698462 i0 90 1.43265306122449 30 3 36.7 0 1 90 115 144 WP_012737990.1 type II toxin-antitoxin system VapC family toxin [Candidatus Hamiltonella defensa] diamond 351 57.4 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Williamhamiltonella Candidatus Williamhamiltonella defendens

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;