RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA1249535" and tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

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

bioproject 1

  • PRJNA1249535 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
355582 355582 PRJNA1249535_S_NODE_149341_length_335_cov_8.599237_g145958_i0 PRJNA1249535 149341 335 8.599237 28.80744395 Blochmannia endosymbiont of Camponotus (Colobopsis) obliquus 1505597 Bacteria Bacteria 52.8 0.032   NTclustered gi|808213333|gb|CP010049.1| 1505597 g145958 i0 100 0.0835820895522388 28 0 8 0 143 170 400113 400140 Blochmannia endosymbiont of Camponotus (Colobopsis) obliquus strain 757, complete genome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Camponotus (Colobopsis) obliquus
1052457 1052457 PRJNA1249535_S_NODE_186961_length_313_cov_4.466667_g183578_i0 PRJNA1249535 186961 313 4.466667 13.98066771 root 1 Root_unresolved Root_unresolved 54.7 0.008   NTclustered gi|1011040111|emb|LN999832.1| 1070130 g183578 i0 90.476 0.226837060702875 42 3 13 1 257 298 935923 935963 Enterobacteriaceae bacterium symbiont of Ferrisia virgata isolate GEFVIR genome assembly, chromosome: I blastn 71 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Gullanella Candidatus Gullanella endobia
1629827 1629827 PRJNA1249535_S_NODE_104702_length_370_cov_3.367003_g101319_i0 PRJNA1249535 104702 370 3.367003 12.4579111 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.035   NTclustered gi|2676815323|gb|CP144799.1| 2608262 g101319 i0 100 0.0756756756756757 28 0 8 0 256 283 241270 241243 MAG: Candidatus Stammera capleta isolate KBEPEHBJ chromosome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
2906098 2906098 PRJNA1249535_S_NODE_122383_length_354_cov_9.259786_g119000_i0 PRJNA1249535 122383 354 9.259786 32.77964244 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.033   NTclustered gi|2688290515|gb|CP145599.1| 2608262 g119000 i0 100 0.0790960451977401 28 0 8 0 124 151 77778 77805 MAG: Candidatus Stammera capleta isolate JMMFINPP_1 chromosome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
2909166 2909166 PRJNA1249535_S_NODE_52583_length_469_cov_3.472222_g49231_i0 PRJNA1249535 52583 469 3.472222 16.28472118 Candidatus Stammera capleta 2608262 Bacteria Bacteria 54.7 0.013   NTclustered gi|2676815292|gb|CP144859.1| 2608262 g49231 i0 100 0.0618336886993603 29 0 6 0 397 425 113978 114006 MAG: Candidatus Stammera capleta isolate NJFLPFMI chromosome blastn 29 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
5460795 5460795 PRJNA1249535_S_NODE_286185_length_260_cov_3.101604_g282802_i0 PRJNA1249535 286185 260 3.101604 8.0641704 Candidatus Gullanella endobia 1070130 Bacteria Bacteria 52.8 0.024   NTclustered gi|1011040111|emb|LN999832.1| 1070130 g282802 i0 100 0.107692307692308 28 0 11 0 3 30 236131 236104 Enterobacteriaceae bacterium symbiont of Ferrisia virgata isolate GEFVIR genome assembly, chromosome: I blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Gullanella Candidatus Gullanella endobia
9284348 9284348 PRJNA1249535_S_NODE_178568_length_318_cov_2.824490_g175185_i0 PRJNA1249535 178568 318 2.82449 8.9818782 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.03   NTclustered gi|2676815323|gb|CP144799.1| 2608262 g175185 i0 100 0.0880503144654088 28 0 9 0 242 269 241243 241270 MAG: Candidatus Stammera capleta isolate KBEPEHBJ chromosome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
11835213 11835213 PRJNA1249535_S_NODE_210430_length_300_cov_65.876652_g207047_i0 PRJNA1249535 210430 300 65.876652000000007 197.629956 Blochmannia endosymbiont of Camponotus nipponensis 2681986 Bacteria Bacteria 52.8 0.028   NTclustered gi|1789113682|gb|CP046534.1| 2681986 g207047 i0 100 0.0933333333333333 28 0 9 0 85 112 389951 389924 Blochmannia endosymbiont of Camponotus nipponensis isolate CNIEBac chromosome, complete genome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Camponotus nipponensis
13113062 13113062 PRJNA1249535_S_NODE_93551_length_382_cov_4.313916_g90169_i0 PRJNA1249535 93551 382 4.313916 16.47915912 Candidatus Blochmanniella vafra 251535 Bacteria Bacteria 52.8 0.036   NTclustered gi|358260579|gb|CP002189.2| 859654 g90169 i0 100 0.146596858638743 28 0 7 0 188 215 61683 61656 Candidatus Blochmannia vafer str. BVAF, complete genome blastn 56 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmanniella vafra

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