RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA683902 · 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
27335212 27335212 PRJNA683902_S_NODE_31423_length_173_cov_2.860294_g30979_i0 PRJNA683902 31423 173 2.860294 4.94830862 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 48.5 1.32e-4   NR MDX1998535.1 2651171 g30979 i0 52.9 2.65317919075145 51 24 88.4 0 19 171 477 527 MDX1998535.1 tetratricopeptide repeat protein [Thermoanaerobaculia bacterium] diamond 459 48.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27714414 27714414 PRJNA683902_S_NODE_36744_length_157_cov_3.575000_g36300_i0 PRJNA683902 36744 157 3.575 5.61275 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 49.3 5.7e-5   NR HEY2819906.1 3069120 g36300 i0 51.1 1.91082802547771 47 21 89.8 1 1 141 95 139 HEY2819906.1 winged helix-turn-helix domain-containing protein [Candidatus Acidiferrum sp.] diamond 300 49.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
31536144 31536144 PRJNA683902_S_NODE_29276_length_181_cov_2.250000_g28832_i0 PRJNA683902 29276 181 2.25 4.0725 Acidobacteriota bacterium 1978231 Bacteria Bacteria 63.2 5e-11   NR UCF68959.1 1978231 g28832 i0 54.2 1.87292817679558 59 27 97.8 0 3 179 29 87 UCF68959.1 MAG: hypothetical protein JSV80_06650, partial [Acidobacteriota bacterium] diamond 339 63.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31599354 31599354 PRJNA683902_S_NODE_34316_length_164_cov_1.228346_g33872_i0 PRJNA683902 34316 164 1.228346 2.01448744 Acidobacteriota bacterium 1978231 Bacteria Bacteria 69.3 5.36e-12   NR MDJ0838682.1 1978231 g33872 i0 61.5 1.75609756097561 52 19 95.1 1 6 161 164 214 MDJ0838682.1 AAA family ATPase [Acidobacteriota bacterium] diamond 288 69.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32358764 32358764 PRJNA683902_S_NODE_27319_length_190_cov_2.594771_g26875_i0 PRJNA683902 27319 190 2.594771 4.9300649 Terriglobia bacterium 2081523 Bacteria Bacteria 41.6 0.046   NR MBZ5660623.1 2081523 g26875 i0 43.8 0.757894736842105 48 23 69.5 1 161 30 22 69 MBZ5660623.1 hypothetical protein [Terriglobia bacterium] diamond 144 41.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
32611409 32611409 PRJNA683902_S_NODE_38460_length_153_cov_2.577586_g38016_i0 PRJNA683902 38460 153 2.577586 3.94370658 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 71.2 9.85e-13   NR HEX7152041.1 2651171 g38016 i0 69.6 1.76470588235294 46 14 90.2 0 144 7 2666 2711 HEX7152041.1 PKD domain-containing protein [Thermoanaerobaculia bacterium] diamond 270 71.2 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia 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);;