RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA541476", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 21 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 21 ✖

bioproject 1

  • PRJNA541476 · 21 ✖
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
4335319 4335319 PRJNA541476_P_NODE_11704_length_339_cov_1.819549_g11498_i0 PRJNA541476 11704 339 1.819549 6.16827111 Bremerella sp. P1 3026424 Bacteria Bacteria 52.8 0.032   NTclustered gi|2446655020|gb|CP118164.1| 3026424 g11498 i0 96.774 0.0914454277286136 31 1 9 0 81 111 2376164 2376134 Bremerella sp. P1 chromosome, complete genome blastn 31 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Bremerella Bremerella sp. P1
9437542 9437542 PRJNA541476_P_NODE_6668_length_438_cov_1.432877_g6464_i0 PRJNA541476 6668 438 1.432877 6.27600126 root 1 Root_unresolved Root_unresolved 111 9.37e-28   NR NBV44241.1 2052181 g6464 i0 86.7 2.43150684931507 60 8 41.1 0 2 181 129 188 NBV44241.1 peptidylprolyl isomerase [Planctomycetia bacterium] diamond 1065 111 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
14538078 14538078 PRJNA541476_P_NODE_8912_length_380_cov_1.332248_g8708_i0 PRJNA541476 8912 380 1.332248 5.0625424 Pseudomonadati 3379134 Bacteria Bacteria 202 2.04e-60   NR MEM8946022.1 2026780 g8708 i0 78.6 22.2947368421053 117 25 92.4 0 379 29 353 469 MEM8946022.1 3-isopropylmalate dehydratase large subunit [Planctomycetota bacterium] diamond 8472 204 0.990196078431373 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
23461529 23461529 PRJNA541476_P_NODE_7979_length_400_cov_1.550459_g7775_i0 PRJNA541476 7979 400 1.550459 6.201836 Tautonia 2680020 Bacteria Bacteria 173 1.43e-48   NR MBA3938248.1 2026780 g7775 i0 69.2 6.825 130 38 97.5 2 397 8 420 547 MBA3938248.1 glucose-6-phosphate isomerase [Planctomycetota bacterium] diamond 2730 174 0.994252873563218 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27187400 27187400 PRJNA541476_P_NODE_9042_length_377_cov_2.315789_g8836_i0 PRJNA541476 9042 377 2.315789 8.73052453 Candidatus Uabimicrobium 2897349 Bacteria Bacteria 79.3 2.72e-14   NR WP_151970871.1 2596890 g8836 i0 68 0.795755968169761 50 16 39.8 0 266 117 1168 1217 WP_151970871.1 DEAD/DEAH box helicase [Candidatus Uabimicrobium amorphum] diamond 300 79.7 0.994981179422836 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Uabimicrobiia Candidatus Uabimicrobiales Candidatus Uabimicrobiaceae Candidatus Uabimicrobium Candidatus Uabimicrobium amorphum
27330847 27330847 PRJNA541476_P_NODE_22103_length_273_cov_1.985000_g21897_i0 PRJNA541476 22103 273 1.985 5.41905 Planctomycetota bacterium 2026780 Bacteria Bacteria 115 1.8499999999999999e-28   NR MEM7559870.1 2026780 g21897 i0 67.9 3.38461538461538 78 25 85.7 0 10 243 275 352 MEM7559870.1 NAD-dependent epimerase/dehydratase family protein [Planctomycetota bacterium] diamond 924 115 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27362633 27362633 PRJNA541476_P_NODE_38643_length_243_cov_0.917647_g38437_i0 PRJNA541476 38643 243 0.917647 2.22988221 Planctomycetota bacterium 2026780 Bacteria Bacteria 87 1.51e-18   NR HYF48200.1 2026780 g38437 i0 52.6 1.83950617283951 76 36 93.8 0 238 11 164 239 HYF48200.1 phytanoyl-CoA dioxygenase family protein [Planctomycetota bacterium] diamond 447 87 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27898939 27898939 PRJNA541476_P_NODE_11085_length_346_cov_2.494505_g10879_i0 PRJNA541476 11085 346 2.494505 8.6309873 Phycisphaerales bacterium 2052180 Bacteria Bacteria 49.7 1.68e-4   NR HLO41328.1 2052180 g10879 i0 46.3 1.13583815028902 41 22 35.5 0 332 210 24 64 HLO41328.1 deaminase [Phycisphaerales bacterium] diamond 393 49.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27898956 27898956 PRJNA541476_P_NODE_30625_length_250_cov_0.881356_g30419_i0 PRJNA541476 30625 250 0.881356 2.20339 Planctomycetota bacterium 2026780 Bacteria Bacteria 54.3 3.4e-6   NR MCH7870486.1 2026780 g30419 i0 44.1 0.708 59 33 70.8 0 73 249 258 316 MCH7870486.1 FG-GAP repeat protein [Planctomycetota bacterium] diamond 177 54.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28341154 28341154 PRJNA541476_P_NODE_15386_length_307_cov_1.290598_g15180_i0 PRJNA541476 15386 307 1.290598 3.96213586 Planctomycetota bacterium 2026780 Bacteria Bacteria 47.4 0.00183   NR MFH0983663.1 2026780 g15180 i0 43.9 0.801302931596091 82 42 76.2 2 241 8 90 171 MFH0983663.1 hypothetical protein [Planctomycetota bacterium] diamond 246 47.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28435968 28435968 PRJNA541476_P_NODE_18666_length_288_cov_2.474419_g18460_i0 PRJNA541476 18666 288 2.474419 7.12632672 Planctomycetota bacterium 2026780 Bacteria Bacteria 76.6 1.98e-14   NR MCI0589339.1 2026780 g18460 i0 56.5 0.645833333333333 62 27 64.6 0 283 98 193 254 MCI0589339.1 SDR family oxidoreductase [Planctomycetota bacterium] diamond 186 76.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29761854 29761854 PRJNA541476_P_NODE_14771_length_311_cov_1.310924_g14565_i0 PRJNA541476 14771 311 1.310924 4.07697364 Planctomycetota bacterium 2026780 Bacteria Bacteria 63.2 2.58e-9   NR TAH34579.1 2026780 g14565 i0 33.7 1.0032154340836 104 67 99.4 2 311 3 114 216 TAH34579.1 MAG: hypothetical protein EYC70_16735 [Planctomycetota bacterium] diamond 312 63.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29761881 29761881 PRJNA541476_P_NODE_8771_length_383_cov_1.180645_g8567_i0 PRJNA541476 8771 383 1.180645 4.52187035 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.0273   NR MBS0263274.1 2026780 g8567 i0 28.3 0.830287206266319 106 62 81.5 3 70 381 1021 1114 MBS0263274.1 hypothetical protein [Planctomycetota bacterium] diamond 318 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29793424 29793424 PRJNA541476_P_NODE_5951_length_464_cov_1.872123_g5748_i0 PRJNA541476 5951 464 1.872123 8.68665072 Planctomycetota bacterium 2026780 Bacteria Bacteria 201 1.27e-58   NR MBA3700225.1 2026780 g5748 i0 67.3 1.93318965517241 150 49 97 0 14 463 79 228 MBA3700225.1 glucose-6-phosphate isomerase [Planctomycetota bacterium] diamond 897 201 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29871675 29871675 PRJNA541476_P_NODE_14091_length_316_cov_2.246914_g13885_i0 PRJNA541476 14091 316 2.246914 7.10024824 PVC group 1783257 Bacteria Bacteria 164 8.66e-46   NR MAB83997.1 2026778 g13885 i0 78.6 20.629746835443 103 18 97.8 1 3 311 224 322 MAB83997.1 hypothetical protein [Phycisphaerae bacterium] diamond 6519 164 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29903311 29903311 PRJNA541476_P_NODE_19911_length_282_cov_1.688995_g19705_i0 PRJNA541476 19911 282 1.688995 4.7629659 root 1 Root_unresolved Root_unresolved 45.8 0.00517   NR MCH7592240.1 2026780 g19705 i0 59 1.74468085106383 39 12 37.2 1 270 166 539 577 MCH7592240.1 hypothetical protein [Planctomycetota bacterium] diamond 492 45.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30962643 30962643 PRJNA541476_P_NODE_8894_length_380_cov_2.465798_g8690_i0 PRJNA541476 8894 380 2.465798 9.3700324 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 81.3 1.82e-17   NR HWB54745.1 2876886 g8690 i0 60.3 0.497368421052632 63 25 49.7 0 44 232 1 63 HWB54745.1 DUF2892 domain-containing protein [Tepidisphaeraceae bacterium] diamond 189 81.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
31088913 31088913 PRJNA541476_P_NODE_8355_length_391_cov_2.462264_g8151_i0 PRJNA541476 8355 391 2.462264 9.62745224 Planctomycetota bacterium 2026780 Bacteria Bacteria 60.1 1.21e-7   NR MEM7316506.1 2026780 g8151 i0 29.2 0.867007672634271 113 72 86.7 2 47 385 130 234 MEM7316506.1 serine/threonine-protein kinase [Planctomycetota bacterium] diamond 339 60.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31246893 31246893 PRJNA541476_P_NODE_22095_length_273_cov_2.120000_g21889_i0 PRJNA541476 22095 273 2.12 5.7876 Planctomycetota bacterium 2026780 Bacteria Bacteria 74.3 3.02e-13   NR MEC7233350.1 2026780 g21889 i0 46.2 1 91 46 98.9 2 1 270 179 267 MEC7233350.1 hypothetical protein [Planctomycetota bacterium] diamond 273 74.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31626429 31626429 PRJNA541476_P_NODE_19276_length_285_cov_1.981132_g19070_i0 PRJNA541476 19276 285 1.981132 5.6462262 Phycisphaerales bacterium 2052180 Bacteria Bacteria 102 4.0999999999999997e-23   NR HEX2838543.1 2052180 g19070 i0 57 1.92631578947368 93 38 95.8 2 6 278 457 549 HEX2838543.1 MmgE/PrpD family protein [Phycisphaerales bacterium] diamond 549 102 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31704633 31704633 PRJNA541476_P_NODE_30417_length_250_cov_1.621469_g30211_i0 PRJNA541476 30417 250 1.621469 4.0536725 Bacteria 2 Bacteria Bacteria 60.1 2.08e-8   NR MEM6331064.1 2026780 g30211 i0 45.2 6.3 73 33 84 2 6 215 198 266 MEM6331064.1 peroxiredoxin-like family protein [Planctomycetota bacterium] diamond 1575 60.5 0.993388429752066 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;