RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA890871", 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 · 2 ✖

tax_kingdom 1

tax_clade 1

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

bioproject 1

  • PRJNA890871 · 2 ✖
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
5967688 5967688 PRJNA890871_P_NODE_3785_length_778_cov_4.228369_g3654_i0 PRJNA890871 3785 778 4.228369 32.89671082 Candidatus Purcelliella pentastirinorum 472834 Bacteria Bacteria 54.7 0.022   NTclustered gi|2446695914|gb|CP110499.1| 472834 g3654 i0 100 0.111825192802057 29 0 4 0 736 764 272197 272169 Candidatus Purcelliella pentastirinorum isolate OFIL1 chromosome, complete genome blastn 87 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Purcelliella Candidatus Purcelliella pentastirinorum
27221138 27221138 PRJNA890871_P_NODE_82902_length_242_cov_1.573964_g82767_i0 PRJNA890871 82902 242 1.573964 3.80899288 Candidatus Blochmanniella 203804 Bacteria Bacteria 42.4 0.0489   NR WP_046304506.1 1505597 g82767 i0 40.4 1.41322314049587 57 34 70.7 0 37 207 169 225 WP_046304506.1 UDP-N-acetylglucosamine 1-carboxyvinyltransferase [Blochmannia endosymbiont of Camponotus (Colobopsis) obliquus] diamond 342 42.4 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Blochmannia endosymbiont of Camponotus (Colobopsis) obliquus

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