RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA1004255" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1004255 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
27223921 27223921 PRJNA1004255_S_NODE_3503_length_297_cov_3.039370_g3295_i0 PRJNA1004255 3503 297 3.03937 9.0269289 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 159 3.0699999999999992e-43   NR HEV3374398.1 3069120 g3295 i0 71.7 2 99 28 100 0 297 1 360 458 HEV3374398.1 hypothetical protein [Candidatus Acidiferrum sp.] diamond 594 159 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
27375045 27375045 PRJNA1004255_S_NODE_12463_length_182_cov_4.395683_g12255_i0 PRJNA1004255 12463 182 4.395683 8.00014306 Pseudomonadati 3379134 Bacteria Bacteria 97.8 1.19e-22   NR HUL15191.1 2282142 g12255 i0 81.4 2.88461538461538 59 11 97.3 0 4 180 4 62 HUL15191.1 ABC transporter ATP-binding protein [Terriglobales bacterium] diamond 525 98.2 0.995926680244399 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
29024377 29024377 PRJNA1004255_S_NODE_7028_length_232_cov_2.079365_g6820_i0 PRJNA1004255 7028 232 2.079365 4.8241268 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 89.4 2.11e-20   NR HKV62756.1 3069120 g6820 i0 70.2 2.59913793103448 57 17 73.7 0 61 231 1 57 HKV62756.1 DUF3291 domain-containing protein [Candidatus Acidiferrum sp.] diamond 603 89.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
29150662 29150662 PRJNA1004255_S_NODE_5689_length_251_cov_3.201923_g5481_i0 PRJNA1004255 5689 251 3.201923 8.03682673 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 48.1 4.93e-4   NR HEV3200494.1 2212468 g5481 i0 38.8 0.585657370517928 49 30 58.6 0 105 251 6 54 HEV3200494.1 PQQ-binding-like beta-propeller repeat protein [Bryobacteraceae bacterium] diamond 147 48.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
29371375 29371375 PRJNA1004255_S_NODE_8549_length_215_cov_2.459302_g8341_i0 PRJNA1004255 8549 215 2.459302 5.2874993 Telmatobacter sp. DSM 11 2171561 Bacteria Bacteria 67.8 3.84e-11   NR WP_348262889.1 3036704 g8341 i0 58.6 0.976744186046512 70 29 97.7 0 210 1 15 84 WP_348262889.1 Ig domain-containing protein [Telmatobacter sp. DSM 110680] diamond 210 67.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Telmatobacter Telmatobacter sp. DSM 110680
29623400 29623400 PRJNA1004255_S_NODE_2450_length_334_cov_2.969072_g2242_i0 PRJNA1004255 2450 334 2.969072 9.91670048 Acidobacteriota bacterium 1978231 Bacteria Bacteria 94.4 1.57e-20   NR PYT51179.1 1978231 g2242 i0 81.8 0.988023952095808 55 10 49.4 0 159 323 28 82 PYT51179.1 MAG: hypothetical protein DMG44_03620 [Acidobacteriota bacterium] diamond 330 94.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30058440 30058440 PRJNA1004255_S_NODE_8071_length_220_cov_3.265537_g7863_i0 PRJNA1004255 8071 220 3.265537 7.1841814 Bacteria 2 Bacteria Bacteria 42.4 0.0177   NR MBS1872546.1 1978231 g7863 i0 35.7 2.49545454545455 56 33 72.3 1 201 43 18 73 MBS1872546.1 hypothetical protein [Acidobacteriota bacterium] diamond 549 42.7 0.992974238875878 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31583231 31583231 PRJNA1004255_S_NODE_6276_length_242_cov_3.070352_g6068_i0 PRJNA1004255 6276 242 3.070352 7.43025184 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 109 3.0800000000000004e-27   NR HEY2546964.1 3069120 g6068 i0 63.8 4.8099173553719 80 29 99.2 0 240 1 128 207 HEY2546964.1 GNAT family N-acyltransferase [Candidatus Acidiferrum sp.] diamond 1164 109 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
32089201 32089201 PRJNA1004255_S_NODE_5398_length_256_cov_3.276995_g5190_i0 PRJNA1004255 5398 256 3.276995 8.3891072 Acidobacteriales bacterium 13_2_2 2282142 Bacteria Bacteria 121 1.26e-32   NR OLB21298.1 1803470 g5190 i0 64.7 1.9921875 85 29 98.4 1 253 2 44 128 OLB21298.1 MAG: hypothetical protein AUH15_09435 [Acidobacteriales bacterium 13_2_20CM_55_8] diamond 510 121 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Acidobacteriales bacterium 13_2_20CM_55_8
32437523 32437523 PRJNA1004255_S_NODE_1399_length_402_cov_2.793872_g1191_i0 PRJNA1004255 1399 402 2.793872 11.23136544 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 140 4.409999999999999e-37   NR HEV3375634.1 3069120 g1191 i0 88.2 0.567164179104478 76 9 56.7 0 3 230 304 379 HEV3375634.1 vanadium-dependent haloperoxidase [Candidatus Acidiferrum sp.] diamond 228 140 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.

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