RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA1169999", tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Pseudomonadati · 10 ✖

tax_clade 1

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

bioproject 1

  • PRJNA1169999 · 10 ✖
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
1589892 1589892 PRJNA1169999_P_NODE_3022_length_249_cov_0.875000_g2986_i0 PRJNA1169999 3022 249 0.875 2.17875 Candidatus Blochmannia ocreatus (nom. nud.) 251538 Bacteria Bacteria 156 1.67e-33   NTclustered gi|2246420991|gb|CP097762.1| 251538 g2986 i0 77.912 14.6385542168675 249 55 100 0 1 249 306866 307114 Candidatus Blochmannia ocreatus strain C-006 chromosome, complete genome blastn 3645 156 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmannia ocreatus (nom. nud.)
7968524 7968524 PRJNA1169999_P_NODE_2947_length_250_cov_0.870056_g2911_i0 PRJNA1169999 2947 250 0.870056 2.17514 Blochmannia endosymbiont of Camponotus sp. C- 2945588 Bacteria Bacteria 132 6.0599999999999995e-37   NR WP_250259543.1 2945588 g2911 i0 73.5 0.996 83 22 99.6 0 249 1 102 184 WP_250259543.1 50S ribosomal protein L6 [Blochmannia endosymbiont of Camponotus sp. C-003] diamond 249 132 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Camponotus sp. C-003
7968531 7968531 PRJNA1169999_P_NODE_3567_length_246_cov_0.867052_g3531_i0 PRJNA1169999 3567 246 0.867052 2.13294792 Blochmannia endosymbiont of Camponotus modoc 2945587 Bacteria Bacteria 318 1.98e-82   NTclustered gi|2246427729|gb|CP097758.1| 2945587 g3531 i0 89.96 14.0528455284553 249 22 100 3 1 246 217151 217399 Blochmannia endosymbiont of Camponotus modoc strain C-019 chromosome, complete genome blastn 3457 318 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Camponotus modoc
7968533 7968533 PRJNA1169999_P_NODE_3667_length_245_cov_0.895349_g3631_i0 PRJNA1169999 3667 245 0.895349 2.19360505 Candidatus Blochmanniella floridana 203907 Bacteria Bacteria 67.6 7.9e-7   NTclustered gi|33518905|emb|BX248583.1| 203907 g3631 i0 100 0.314285714285714 36 0 15 0 206 241 94573 94538 Blochmannia floridanus complete genome blastn 77 67.6 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmanniella floridana
13068820 13068820 PRJNA1169999_P_NODE_3811_length_244_cov_0.900585_g3775_i0 PRJNA1169999 3811 244 0.900585 2.1974274 Candidatus Blochmanniella camponoti 108080 Bacteria Bacteria 211 3.43e-50   NTclustered gi|2246423453|gb|CP097751.1| 108080 g3775 i0 87.5 11.483606557377 184 21 75 2 59 241 204094 204276 Candidatus Blochmanniella camponoti strain C-049 chromosome, complete genome blastn 2802 211 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmanniella camponoti
16342770 16342770 PRJNA1169999_P_NODE_2753_length_251_cov_0.865169_g2717_i0 PRJNA1169999 2753 251 0.865169 2.17157419 Candidatus Blochmanniella 203804 Bacteria Bacteria 320 5.65e-83   NTclustered gi|2224893745|gb|CP095401.1| 101534 g2717 i0 89.641 17 251 26 100 0 1 251 654136 653886 Candidatus Blochmanniella pennsylvanica isolate B_Penn7 chromosome, complete genome blastn 4267 320 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmanniella pennsylvanica
16892303 16892303 PRJNA1169999_P_NODE_2694_length_251_cov_0.865169_g2658_i0 PRJNA1169999 2694 251 0.865169 2.17157419 Blochmannia endosymbiont of Camponotus sp. 700220 Bacteria Bacteria 150 7.84e-32   NTclustered gi|2246421582|gb|CP097760.1| 700220 g2658 i0 81.959 74 194 19 76 12 10 201 190087 189908 Blochmannia endosymbiont of Camponotus sp. strain C-016 chromosome, complete genome blastn 18574 150 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Camponotus sp.
16892309 16892309 PRJNA1169999_P_NODE_3314_length_247_cov_0.885057_g3278_i0 PRJNA1169999 3314 247 0.885057 2.18609079 Blochmannia endosymbiont of Camponotus modoc 2945587 Bacteria Bacteria 178 3.53e-40   NTclustered gi|2246425272|gb|CP097754.1| 2945587 g3278 i0 81.172 11.7085020242915 239 29 96 12 10 247 725775 725552 Blochmannia endosymbiont of Camponotus modoc strain C-036 chromosome, complete genome blastn 2892 178 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Camponotus modoc
16892312 16892312 PRJNA1169999_P_NODE_3534_length_246_cov_0.890173_g3498_i0 PRJNA1169999 3534 246 0.890173 2.18982558 Blochmannia endosymbiont of Camponotus sp. 700220 Bacteria Bacteria 339 1.5199999999999998e-88   NTclustered gi|2246419766|gb|CP097761.1| 700220 g3498 i0 91.77 16.9552845528455 243 20 99 0 4 246 713983 714225 Blochmannia endosymbiont of Camponotus sp. strain C-010 chromosome, complete genome blastn 4171 339 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Camponotus sp.
18891835 18891835 PRJNA1169999_P_NODE_2715_length_251_cov_0.865169_g2679_i0 PRJNA1169999 2715 251 0.865169 2.17157419 Candidatus Blochmanniella 203804 Bacteria Bacteria 340 4.33e-89   NTclustered gi|2224893745|gb|CP095401.1| 101534 g2679 i0 91.2 14.9521912350598 250 22 99 0 1 250 720603 720852 Candidatus Blochmanniella pennsylvanica isolate B_Penn7 chromosome, complete genome blastn 3753 340 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmanniella pennsylvanica

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