RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA811237" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA811237 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_clade 0

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
26714546 26714546 PRJNA811237_S_NODE_34401_length_162_cov_0.902655_g34161_i0 PRJNA811237 34401 162 0.902655 1.4623011 PVC group 1783257 Bacteria Bacteria 42.7 0.0121   NR MFI5386157.1 2682145 g34161 i0 48.6 2.68518518518519 37 19 68.5 0 50 160 190 226 MFI5386157.1 hypothetical protein [Fimbriimonadales bacterium] diamond 435 42.7 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
27718060 27718060 PRJNA811237_S_NODE_17984_length_197_cov_1.283784_g17744_i0 PRJNA811237 17984 197 1.283784 2.52905448 Armatimonadota bacterium 2033014 Bacteria Bacteria 52.4 3.97e-6   NR MCA1996805.1 2033014 g17744 i0 41.3 10.5685279187817 46 27 70.1 0 3 140 99 144 MCA1996805.1 glutathione peroxidase [Armatimonadota bacterium] diamond 2082 52.4 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
28696642 28696642 PRJNA811237_S_NODE_29827_length_165_cov_1.318966_g29587_i0 PRJNA811237 29827 165 1.318966 2.1762939 Fimbriimonas sp. 1936159 Bacteria Bacteria 62.8 1.12e-9   NR MEZ0326077.1 1936159 g29587 i0 72.5 0.727272727272727 40 11 72.7 0 1 120 34 73 MEZ0326077.1 MmgE/PrpD family protein [Fimbriimonas sp.] diamond 120 62.8 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas sp.
30939075 30939075 PRJNA811237_S_NODE_23094_length_179_cov_1.300000_g22854_i0 PRJNA811237 23094 179 1.3 2.327 Armatimonadota bacterium 2033014 Bacteria Bacteria 46.2 9.49e-4   NR MBI2252315.1 2033014 g22854 i0 48.9 0.787709497206704 47 24 78.8 0 7 147 376 422 MBI2252315.1 GAF domain-containing protein [Armatimonadota bacterium] diamond 141 46.2 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31002214 31002214 PRJNA811237_S_NODE_26454_length_169_cov_1.700000_g26214_i0 PRJNA811237 26454 169 1.7 2.873 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 84.7 1.08e-18   NR MEJ5169988.1 2682145 g26214 i0 69.6 0.994082840236686 56 16 97.6 1 167 3 117 172 MEJ5169988.1 glutathione peroxidase [Fimbriimonadales bacterium] diamond 168 84.7 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
32434542 32434542 PRJNA811237_S_NODE_15159_length_209_cov_1.275000_g14919_i0 PRJNA811237 15159 209 1.275 2.66475 Bacillati 1783272 Bacteria Bacteria 50.8 3.27e-5   NR MBI3974883.1 2033014 g14919 i0 40 3.44497607655502 65 39 93.3 0 15 209 193 257 MBI3974883.1 S41 family peptidase [Armatimonadota bacterium] diamond 720 50.8 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium

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