RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJEB50332", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 15 ✖

tax_phylum 1

  • Acidobacteriota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJEB50332 · 15 ✖

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
1393874 1393874 PRJEB50332_P_NODE_4582_length_282_cov_1.063348_g4500_i0 PRJEB50332 4582 282 1.063348 2.99864136 Acidobacteriota bacterium 1978231 Bacteria Bacteria 62.4 4.18e-9   NR MEK7723144.1 1978231 g4500 i0 35.6 4.67021276595745 90 58 95.7 0 270 1 78 167 MEK7723144.1 CAP domain-containing protein [Acidobacteriota bacterium] diamond 1317 62.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
14147866 14147866 PRJEB50332_P_NODE_9032_length_230_cov_1.307692_g8950_i0 PRJEB50332 9032 230 1.307692 3.0076916 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 121 5.55e-23   NTclustered gi|2874253744|emb|OY969603.1| 171953 g8950 i0 86.364 2.71739130434783 110 15 48 0 121 230 1208125 1208234 MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1 blastn 625 121 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
27633937 27633937 PRJEB50332_P_NODE_17044_length_203_cov_1.584507_g16962_i0 PRJEB50332 17044 203 1.584507 3.21654921 Blastocatellia bacterium 2052146 Bacteria Bacteria 84.3 4.86e-17   NR HTG15783.1 2052146 g16962 i0 65.7 1.98029556650246 67 22 99 1 202 2 712 777 HTG15783.1 CusA/CzcA family heavy metal efflux RND transporter [Blastocatellia bacterium] diamond 402 84.3 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
28581149 28581149 PRJEB50332_P_NODE_107_length_1443_cov_3.898698_g79_i0 PRJEB50332 107 1443 3.898698 56.25821214 Acidobacteriota bacterium 1978231 Bacteria Bacteria 59.3 1.62e-5   NR MBS1873370.1 1978231 g79 i0 34.4 0.25987525987526 125 60 25.4 5 438 73 112 217 MBS1873370.1 hypothetical protein [Acidobacteriota bacterium] diamond 375 59.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28770433 28770433 PRJEB50332_P_NODE_1907_length_406_cov_1.791304_g1826_i0 PRJEB50332 1907 406 1.791304 7.27269424 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 97.1 2.22e-20   NR MFN7919619.1 2212468 g1826 i0 45.8 1.58866995073892 120 54 87.9 3 9 365 441 550 MFN7919619.1 RICIN domain-containing protein [Bryobacteraceae bacterium] diamond 645 97.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
28991829 28991829 PRJEB50332_P_NODE_8048_length_235_cov_2.045977_g7966_i0 PRJEB50332 8048 235 2.045977 4.80804595 Acidobacteriota bacterium 1978231 Bacteria Bacteria 140 1.59e-41   NR MBA4185321.1 1978231 g7966 i0 90.9 1.96595744680851 77 7 98.3 0 5 235 5 81 MBA4185321.1 hypothetical protein [Acidobacteriota bacterium] diamond 462 140 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29237501 29237501 PRJEB50332_P_NODE_3409_length_315_cov_1.748031_g3327_i0 PRJEB50332 3409 315 1.748031 5.50629765 Terracidiphilus 1768185 Bacteria Bacteria 144 2.95e-40   NR HUH63403.1 1964191 g3327 i0 73 10.4761904761905 100 27 95.2 0 2 301 160 259 HUH63403.1 aldolase/citrate lyase family protein [Terracidiphilus sp.] diamond 3300 144 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
29591025 29591025 PRJEB50332_P_NODE_11230_length_217_cov_2.910256_g11148_i0 PRJEB50332 11230 217 2.910256 6.31525552 Blastocatellia bacterium 2052146 Bacteria Bacteria 129 1.11e-32   NR HEX5734783.1 2052146 g11148 i0 81.9 0.995391705069124 72 13 99.5 0 217 2 212 283 HEX5734783.1 hypothetical protein [Blastocatellia bacterium] diamond 216 129 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
29812290 29812290 PRJEB50332_P_NODE_8451_length_233_cov_1.511628_g8369_i0 PRJEB50332 8451 233 1.511628 3.52209324 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 135 5.82e-35   NR MFL6373222.1 2283092 g8369 i0 97.4 3.95278969957082 77 2 99.1 0 2 232 420 496 MFL6373222.1 efflux RND transporter permease subunit [Pyrinomonadaceae bacterium] diamond 921 135 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30350052 30350052 PRJEB50332_P_NODE_11812_length_214_cov_2.228758_g11730_i0 PRJEB50332 11812 214 2.228758 4.76954212 Acidobacteria bacterium SCN 69-37 1660160 Bacteria Bacteria 104 4.3799999999999995e-25   NR ODS53960.1 1660160 g11730 i0 70 3.85514018691589 70 20 98.1 1 210 1 221 289 ODS53960.1 MAG: oxidoreductase [Acidobacteria bacterium SCN 69-37] diamond 825 104 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteria bacterium SCN 69-37
30633662 30633662 PRJEB50332_P_NODE_12053_length_213_cov_1.638158_g11971_i0 PRJEB50332 12053 213 1.638158 3.48927654 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 107 5.77e-25   NR HMJ88798.1 3069120 g11971 i0 75.7 0.985915492957746 70 17 98.6 0 3 212 478 547 HMJ88798.1 secretin N-terminal domain-containing protein [Candidatus Acidiferrum sp.] diamond 210 107 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
30633667 30633667 PRJEB50332_P_NODE_6933_length_242_cov_1.237569_g6851_i0 PRJEB50332 6933 242 1.237569 2.99491698 Blastocatellia bacterium 2052146 Bacteria Bacteria 90.5 3.38e-20   NR HJQ68150.1 2052146 g6851 i0 87.2 1.74793388429752 47 6 58.3 0 100 240 1 47 HJQ68150.1 nicotinate-nucleotide adenylyltransferase [Blastocatellia bacterium] diamond 423 90.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30665418 30665418 PRJEB50332_P_NODE_14533_length_207_cov_2.383562_g14451_i0 PRJEB50332 14533 207 2.383562 4.93397334 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 88.6 1.52e-18   NR MCY7348661.1 2283092 g14451 i0 64.7 0.985507246376812 68 24 98.6 0 205 2 419 486 MCY7348661.1 oligosaccharide flippase family protein [Pyrinomonadaceae bacterium] diamond 204 88.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31139053 31139053 PRJEB50332_P_NODE_5815_length_257_cov_1.841837_g5733_i0 PRJEB50332 5815 257 1.841837 4.73352109 Candidatus Angelobacter sp. 2976921 Bacteria Bacteria 97.1 1.3700000000000002e-21   NR HLJ88798.1 2976921 g5733 i0 53.6 2.68482490272374 84 38 96.9 1 255 7 197 280 HLJ88798.1 alkene reductase [Candidatus Angelobacter sp.] diamond 690 97.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia     Candidatus Angelobacter Candidatus Angelobacter sp.
31297424 31297424 PRJEB50332_P_NODE_9495_length_227_cov_1.566265_g9413_i0 PRJEB50332 9495 227 1.566265 3.55542155 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 41.2 0.0283   NR MBY0373032.1 2212468 g9413 i0 52.6 0.502202643171806 38 14 44.9 1 215 114 11 48 MBY0373032.1 hypothetical protein [Bryobacteraceae bacterium] diamond 114 41.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae 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);;