RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA853194 · 3 ✖

analysis 1

  • blastn · 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
8493333 8493333 PRJNA853194_S_NODE_43127_length_328_cov_1.686275_g42036_i0 PRJNA853194 43127 328 1.686275 5.530982 Blochmannia endosymbiont of Camponotus modoc 2945587 Bacteria Bacteria 52.8 0.031   NTclustered gi|2246427729|gb|CP097758.1| 2945587 g42036 i0 100 0.0853658536585366 28 0 9 0 4 31 267501 267474 Blochmannia endosymbiont of Camponotus modoc strain C-019 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 modoc
8493607 8493607 PRJNA853194_S_NODE_56207_length_291_cov_2.055046_g55116_i0 PRJNA853194 56207 291 2.055046 5.98018386 Candidatus Annandia pinicola 1345117 Bacteria Bacteria 56.5 0.002   NTclustered gi|2119946787|gb|CP045876.1| 1345117 g55116 i0 100 0.103092783505155 30 0 10 0 109 138 58821 58792 Candidatus Annandia pinicola isolate Ad13-065 chromosome, complete genome blastn 30 56.5 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Annandia Candidatus Annandia pinicola
9768584 9768584 PRJNA853194_S_NODE_49368_length_309_cov_1.669492_g48277_i0 PRJNA853194 49368 309 1.669492 5.15873028 Candidatus Dasytiphilus stammeri 1895663 Bacteria Bacteria 52.8 0.029   NTclustered gi|2689074019|gb|CP145877.1| 1895663 g48277 i0 100 0.0906148867313916 28 0 9 0 237 264 19782 19755 MAG: Candidatus Dasytiphilus stammeri isolate Dnig chromosome, complete genome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Dasytiphilus Candidatus Dasytiphilus stammeri

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