RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA976345", tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 4 ✖

tax_kingdom 1

tax_clade 1

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

bioproject 1

  • PRJNA976345 · 4 ✖

analysis 1

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
948657 948657 PRJNA976345_P_NODE_59441_length_230_cov_2.661538_g57833_i0 PRJNA976345 59441 230 2.661538 6.1215374 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.021   NTclustered gi|2676815292|gb|CP144859.1| 2608262 g57833 i0 100 0.121739130434783 28 0 12 0 90 117 64792 64765 MAG: Candidatus Stammera capleta isolate NJFLPFMI chromosome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
5095510 5095510 PRJNA976345_P_NODE_198304_length_150_cov_1.852174_g196696_i0 PRJNA976345 198304 150 1.852174 2.778261 Candidatus Blochmanniella 203804 Bacteria Bacteria 52.8 0.012   NTclustered gi|2246419161|gb|CP097764.1| 2945588 g196696 i0 100 0.373333333333333 28 0 19 0 11 38 78339 78366 Blochmannia endosymbiont of Camponotus sp. C-003 chromosome, complete genome blastn 56 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Camponotus sp. C-003
14975597 14975597 PRJNA976345_P_NODE_118412_length_179_cov_1.104167_g116804_i0 PRJNA976345 118412 179 1.104167 1.97645893 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.015   NTclustered gi|2676815339|gb|CP144809.1| 2608262 g116804 i0 100 0.156424581005587 28 0 16 0 57 84 1388 1361 MAG: Candidatus Stammera capleta isolate JNFEHELC plasmid pStDsp1, complete sequence blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
17526187 17526187 PRJNA976345_P_NODE_183974_length_154_cov_2.067227_g182366_i0 PRJNA976345 183974 154 2.067227 3.18352958 Candidatus Tachikawaea gelatinosa 1410383 Bacteria Bacteria 52.8 0.013   NTclustered gi|686207191|dbj|AP014521.1| 1410383 g182366 i0 100 0.181818181818182 28 0 18 0 44 71 622910 622883 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

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