RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA725806" 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 · 7 ✖

bioproject 1

  • PRJNA725806 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
5815456 5815456 PRJNA725806_P_NODE_22685_length_308_cov_3.099631_g22389_i0 PRJNA725806 22685 308 3.099631 9.54686348 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.029   NTclustered gi|2676815338|gb|CP144808.1| 2608262 g22389 i0 100 0.0909090909090909 28 0 9 0 3 30 271915 271942 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
16014309 16014309 PRJNA725806_P_NODE_17773_length_327_cov_3.558621_g17479_i0 PRJNA725806 17773 327 3.558621 11.63669067 Candidatus Stammera capleta 2608262 Bacteria Bacteria 58.4 6.61e-4   NTclustered gi|1269271234|gb|CP024013.1| 2608262 g17479 i0 94.595 0.113149847094801 37 2 11 0 74 110 21171 21207 MAG: Candidatus Stammera capleta isolate NZ1215 chromosome, complete genome blastn 37 58.4 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
17289905 17289905 PRJNA725806_P_NODE_35454_length_274_cov_7.603376_g35157_i0 PRJNA725806 35454 274 7.603376 20.83325024 Candidatus Annandia pinicola 1345117 Bacteria Bacteria 52.8 0.025   NTclustered gi|2119946787|gb|CP045876.1| 1345117 g35157 i0 100 0.102189781021898 28 0 10 0 41 68 88340 88367 Candidatus Annandia pinicola isolate Ad13-065 chromosome, complete genome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Annandia Candidatus Annandia pinicola
18563617 18563617 PRJNA725806_P_NODE_25735_length_298_cov_5.517241_g25438_i0 PRJNA725806 25735 298 5.517241 16.44137818 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.028   NTclustered gi|1925240934|gb|CP043991.1| 2608262 g25438 i0 100 0.0939597315436242 28 0 9 0 32 59 221196 221169 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
21114270 21114270 PRJNA725806_P_NODE_110497_length_190_cov_3.098039_g110195_i0 PRJNA725806 110497 190 3.098039 5.8862741 Candidatus Stammera capleta 2608262 Bacteria Bacteria 54.7 0.005   NTclustered gi|1925240903|gb|CP043978.1| 2608262 g110195 i0 86.275 0.268421052631579 51 5 27 1 115 165 219198 219150 MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome blastn 51 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
21114480 21114480 PRJNA725806_P_NODE_38057_length_269_cov_3.870690_g37760_i0 PRJNA725806 38057 269 3.87069 10.4121561 Candidatus Stammera capleta 2608262 Bacteria Bacteria 54.7 0.007   NTclustered gi|2676815345|gb|CP144816.1| 2608262 g37760 i0 100 0.107806691449814 29 0 11 0 80 108 5474 5446 MAG: Candidatus Stammera capleta isolate KGPCFMKM plasmid pStChg1, complete sequence blastn 29 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
24938337 24938337 PRJNA725806_P_NODE_26500_length_296_cov_3.714286_g26203_i0 PRJNA725806 26500 296 3.714286 10.99428656 Blochmannia endosymbiont of Camponotus nipponensis 2681986 Bacteria Bacteria 52.8 0.027   NTclustered gi|1789113682|gb|CP046534.1| 2681986 g26203 i0 100 0.0945945945945946 28 0 9 0 40 67 493590 493617 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

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