RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 3 ✖

tax_kingdom 1

tax_clade 1

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

bioproject 1

  • PRJNA946307 · 3 ✖
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
927511 927511 PRJNA946307_P_NODE_55681_length_210_cov_2.888199_g54807_i0 PRJNA946307 55681 210 2.888199 6.0652179 Symbiopectobacterium purcellii 2871826 Bacteria Bacteria 135 1.78e-27   NTclustered gi|2087438146|gb|CP081864.1| 2871826 g54807 i0 95.294 0.814285714285714 85 4 81 0 111 195 3868084 3868000 Symbiopectobacterium purcellii strain SyEd1 chromosome, complete genome blastn 171 135 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Symbiopectobacterium Symbiopectobacterium purcellii
13681172 13681172 PRJNA946307_P_NODE_54191_length_210_cov_2.913043_g53317_i0 PRJNA946307 54191 210 2.913043 6.1173903 Candidatus Stammera capleta 2608262 Bacteria Bacteria 87.9 5.05e-13   NTclustered gi|2676815380|gb|CP144850.1| 2608262 g53317 i0 87.179 0.719047619047619 78 9 37 1 17 93 89435 89358 MAG: Candidatus Stammera capleta isolate BHILEGBA chromosome blastn 151 87.9 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
26740065 26740065 PRJNA946307_P_NODE_120521_length_175_cov_1.531746_g119647_i0 PRJNA946307 120521 175 1.531746 2.6805555 Candidatus Annandia adelgestsuga 1302411 Bacteria Bacteria 67 4.12e-11   NR WP_126071638.1 1302411 g119647 i0 60.8 1.76571428571429 51 20 87.4 0 2 154 138 188 WP_126071638.1 methionine--tRNA ligase [Candidatus Annandia adelgestsuga] diamond 309 67 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Annandia Candidatus Annandia adelgestsuga

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