RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA339266", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 5 ✖

tax_kingdom 1

  • Bacillati · 5 ✖

bioproject 1

  • PRJNA339266 · 5 ✖

analysis 1

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
27769883 27769883 PRJNA339266_S_NODE_3904_length_228_cov_0.989529_g3893_i0 PRJNA339266 3904 228 0.989529 2.25612612 Capsulimonas sp. 2494211 Bacteria Bacteria 53.1 4.21e-6   NR MCW3058866.1 2494211 g3893 i0 36.5 0.973684210526316 74 46 97.4 1 5 226 28 100 MCW3058866.1 hypothetical protein [Capsulimonas sp.] diamond 222 53.1 1 Bacteria   Bacillati Armatimonadota Armatimonadia Capsulimonadales Capsulimonadaceae Capsulimonas Capsulimonas sp.
27895832 27895832 PRJNA339266_S_NODE_13505_length_166_cov_2.232558_g13494_i0 PRJNA339266 13505 166 2.232558 3.70604628 Armatimonadota bacterium 2033014 Bacteria Bacteria 113 1.11e-27   NR MES2459559.1 2033014 g13494 i0 100 1.98795180722892 55 0 99.4 0 2 166 303 357 MES2459559.1 DUF87 domain-containing protein [Armatimonadota bacterium] diamond 330 113 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
27990789 27990789 PRJNA339266_S_NODE_19865_length_150_cov_2.522124_g19854_i0 PRJNA339266 19865 150 2.522124 3.783186 Armatimonadota bacterium 2033014 Bacteria Bacteria 53.1 1.64e-6   NR MBC7807358.1 2033014 g19854 i0 59.1 0.88 44 18 88 0 147 16 190 233 MBC7807358.1 hypothetical protein [Armatimonadota bacterium] diamond 132 53.1 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
28355139 28355139 PRJNA339266_S_NODE_18126_length_154_cov_1.273504_g18115_i0 PRJNA339266 18126 154 1.273504 1.96119616 Bacillati 1783272 Bacteria Bacteria 83.6 1.89e-17   NR MBV9851412.1 2033014 g18115 i0 77.1 1.87012987012987 48 11 93.5 0 11 154 160 207 MBV9851412.1 Gfo/Idh/MocA family oxidoreductase [Armatimonadota bacterium] diamond 288 84.3 0.991696322657177 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
30137491 30137491 PRJNA339266_S_NODE_5492_length_209_cov_3.674419_g5481_i0 PRJNA339266 5492 209 3.674419 7.67953571 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 74.7 1.27e-13   NR HTQ09779.1 2682144 g5481 i0 47.8 0.990430622009569 69 36 99 0 208 2 521 589 HTQ09779.1 Qat anti-phage system ATPase QatA [Fimbriimonadaceae bacterium] diamond 207 74.7 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae 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);;