RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

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

bioproject 1

  • PRJNA737474 · 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
25704221 25704221 PRJNA737474b_S_NODE_19802_length_360_cov_4.174216_g18763_i0 PRJNA737474 19802 360 4.174216 15.0271776 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.034   NTclustered gi|2676815323|gb|CP144799.1| 2608262 g18763 i0 100 0.155555555555556 28 0 8 0 252 279 146767 146794 MAG: Candidatus Stammera capleta isolate KBEPEHBJ chromosome blastn 56 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
25724186 25724186 PRJNA737474g_S_NODE_44770_length_430_cov_6.201681_g43480_i0 PRJNA737474 44770 430 6.201681 26.6672283 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.041   NTclustered gi|2676815323|gb|CP144799.1| 2608262 g43480 i0 100 0.130232558139535 28 0 7 0 99 126 146794 146767 MAG: Candidatus Stammera capleta isolate KBEPEHBJ chromosome blastn 56 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
32938116 32938116 PRJNA737474g_S_NODE_68297_length_367_cov_3.183673_g67003_i0 PRJNA737474 68297 367 3.183673 11.68407991 Candidatus Blochmanniella floridana 203907 Bacteria Bacteria 59.7 1.33e-8   NR Q7VQC6.1 203907 g67003 i0 42.2 0.735694822888283 90 50 72.8 2 364 98 20 108 Q7VQC6.1 RecName: Full=Small ribosomal subunit protein uS13; AltName: Full=30S ribosomal protein S13 [Candidatus Blochmanniella floridana] diamond 270 59.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmanniella floridana

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