RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA792582", tax_phylum = "Planctomycetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 22 ✖

tax_phylum 1

  • Planctomycetota · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA792582 · 22 ✖
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
777111 777111 PRJNA792582_P_NODE_54661_length_246_cov_0.890173_g53847_i0 PRJNA792582 54661 246 0.890173 2.18982558 Lignipirellula cremea 2528010 Bacteria Bacteria 239 1.59e-58   NTclustered gi|1712668320|gb|CP036433.1| 2528010 g53847 i0 85.59 1.73577235772358 229 31 93 2 4 231 6914594 6914367 Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome blastn 427 239 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Lignipirellula Lignipirellula cremea
14805364 14805364 PRJNA792582_P_NODE_16712_length_422_cov_1.501433_g15898_i0 PRJNA792582 16712 422 1.501433 6.33604726 Caulifigura coniformis 2527983 Bacteria Bacteria 510 5.58e-140   NTclustered gi|1712508784|gb|CP036271.1| 2527983 g15898 i0 89.383 151.791469194313 405 43 96 0 18 422 2926116 2925712 Caulifigura coniformis strain Pan44 chromosome blastn 64056 510 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Caulifigura Caulifigura coniformis
16518176 16518176 PRJNA792582_P_NODE_22093_length_366_cov_3.064846_g21279_i0 PRJNA792582 22093 366 3.064846 11.21733636 Bacteria 2 Bacteria Bacteria 466 1.05e-126   NTclustered gi|1712658140|gb|CP036290.1| 2528008 g21279 i0 90.055 282.448087431694 362 32 98 4 3 362 3893881 3894240 Planctomycetes bacterium Pla163 chromosome, complete genome blastn 103376 466 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Rohdeia Rohdeia mirabilis
21179289 21179289 PRJNA792582_P_NODE_20057_length_384_cov_2.424437_g19243_i0 PRJNA792582 20057 384 2.424437 9.30983808 Rohdeia mirabilis 2528008 Bacteria Bacteria 449 1.11e-121   NTclustered gi|1712658140|gb|CP036290.1| 2528008 g19243 i0 88.021 176.213541666667 384 40 99 5 4 384 3894999 3894619 Planctomycetes bacterium Pla163 chromosome, complete genome blastn 67666 449 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Rohdeia Rohdeia mirabilis
21179423 21179423 PRJNA792582_P_NODE_3557_length_862_cov_2.861850_g2913_i0 PRJNA792582 3557 862 2.86185 24.669147 planctomycete str. 139 149588 Bacteria Bacteria 994 0   NTclustered gi|12583967|gb|AF245371.1|AF245371 149588 g2913 i0 89.122 113.185614849188 809 75 93 10 18 815 630 1436 Planctomycete str. 139 23S ribosomal RNA gene, partial sequence blastn 97566 994 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   planctomycete str. 139
25003421 25003421 PRJNA792582_P_NODE_36600_length_287_cov_0.976636_g35786_i0 PRJNA792582 36600 287 0.976636 2.80294532 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 357 5.02e-94   NTclustered gi|2874253799|emb|OY969783.1| 2876886 g35786 i0 89.236 206.219512195122 288 28 100 2 1 287 2502481 2502766 MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1 blastn 59185 357 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
26673576 26673576 PRJNA792582_P_NODE_37621_length_284_cov_1.379147_g36807_i0 PRJNA792582 37621 284 1.379147 3.91677748 Pirellulales bacterium 2715253 Bacteria Bacteria 76.3 5.35e-15   NR HEY1064969.1 2715253 g36807 i0 81 0.887323943661972 42 7 44.4 1 3 128 124 164 HEY1064969.1 pyridoxamine 5'-phosphate oxidase family protein [Pirellulales bacterium] diamond 252 76.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
26832308 26832308 PRJNA792582_P_NODE_51201_length_250_cov_0.870056_g50387_i0 PRJNA792582 51201 250 0.870056 2.17514 Thalassoroseus pseudoceratinae 2713176 Bacteria Bacteria 56.6 5.28e-7   NR WP_166831288.1 2713176 g50387 i0 45.5 0.924 77 38 88.8 2 12 233 1064 1139 WP_166831288.1 beta strand repeat-containing protein [Thalassoroseus pseudoceratinae] diamond 231 56.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Thalassoroseus Thalassoroseus pseudoceratinae
27211617 27211617 PRJNA792582_P_NODE_48042_length_255_cov_2.263736_g47228_i0 PRJNA792582 48042 255 2.263736 5.7725268 Planctomycetota bacterium 2026780 Bacteria Bacteria 165 1.6399999999999998e-47   NR MFM1874172.1 2026780 g47228 i0 85.7 0.988235294117647 84 12 98.8 0 253 2 246 329 MFM1874172.1 hypothetical protein [Planctomycetota bacterium] diamond 252 165 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27496232 27496232 PRJNA792582_P_NODE_53043_length_248_cov_0.880000_g52229_i0 PRJNA792582 53043 248 0.88 2.1824 Pirellulaceae bacterium 2699754 Bacteria Bacteria 125 2.3e-31   NR HEV7281369.1 2699754 g52229 i0 75.6 0.991935483870968 82 20 99.2 0 3 248 299 380 HEV7281369.1 ABC transporter permease [Pirellulaceae bacterium] diamond 246 125 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
27685928 27685928 PRJNA792582_P_NODE_41304_length_274_cov_1.542289_g40490_i0 PRJNA792582 41304 274 1.542289 4.22587186 Pirellulaceae bacterium 2699754 Bacteria Bacteria 43.1 0.0389   NR HND55463.1 2699754 g40490 i0 33.3 0.656934306569343 60 40 65.7 0 94 273 145 204 HND55463.1 hypothetical protein [Pirellulaceae bacterium] diamond 180 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
27717571 27717571 PRJNA792582_P_NODE_10604_length_522_cov_1.781737_g9798_i0 PRJNA792582 10604 522 1.781737 9.30066714 Phycisphaerales bacterium 2052180 Bacteria Bacteria 68.2 4.54e-11   NR MBL4590776.1 2052180 g9798 i0 31.3 0.936781609195402 163 83 92.5 5 506 24 1 136 MBL4590776.1 hypothetical protein [Phycisphaerales bacterium] diamond 489 68.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28253870 28253870 PRJNA792582_P_NODE_25406_length_343_cov_1.137037_g24592_i0 PRJNA792582 25406 343 1.137037 3.90003691 Planctomycetota bacterium 2026780 Bacteria Bacteria 78.2 2.49e-14   NR MEM7205140.1 2026780 g24592 i0 62.3 5.73760932944606 61 21 53.4 1 184 2 1 59 MEM7205140.1 type I glyceraldehyde-3-phosphate dehydrogenase [Planctomycetota bacterium] diamond 1968 78.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29106522 29106522 PRJNA792582_P_NODE_37888_length_283_cov_1.828571_g37074_i0 PRJNA792582 37888 283 1.828571 5.17485593 Planctomycetota bacterium 2026780 Bacteria Bacteria 106 3.08e-25   NR MEM8758334.1 2026780 g37074 i0 61.4 4.36749116607774 83 27 84.8 2 3 242 191 271 MEM8758334.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Planctomycetota bacterium] diamond 1236 106 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30559078 30559078 PRJNA792582_P_NODE_54793_length_246_cov_0.890173_g53979_i0 PRJNA792582 54793 246 0.890173 2.18982558 Planctomycetota bacterium 2026780 Bacteria Bacteria 127 1.33e-32   NR MBL8863869.1 2026780 g53979 i0 80 3.86585365853659 80 16 97.6 0 6 245 326 405 MBL8863869.1 hypothetical protein [Planctomycetota bacterium] diamond 951 127 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31033539 31033539 PRJNA792582_P_NODE_61095_length_202_cov_4.062016_g60281_i0 PRJNA792582 61095 202 4.062016 8.20527232 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0413   NR HUW29971.1 2026780 g60281 i0 33.9 0.831683168316832 56 36 81.7 1 168 4 311 366 HUW29971.1 PQQ-binding-like beta-propeller repeat protein [Planctomycetota bacterium] diamond 168 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31728791 31728791 PRJNA792582_P_NODE_50057_length_251_cov_0.865169_g49243_i0 PRJNA792582 50057 251 0.865169 2.17157419 Pirellulales bacterium 2715253 Bacteria Bacteria 62 6.73e-9   NR MFO0912579.1 2715253 g49243 i0 45.2 1.00398406374502 84 45 99.2 1 3 251 431 514 MFO0912579.1 transglutaminase-like domain-containing protein [Pirellulales bacterium] diamond 252 62 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
31950233 31950233 PRJNA792582_P_NODE_53017_length_248_cov_0.880000_g52203_i0 PRJNA792582 53017 248 0.88 2.1824 Isosphaerales bacterium 3107438 Bacteria Bacteria 122 4.589999999999999e-31   NR MFI5460944.1 3107438 g52203 i0 65.9 1.98387096774194 82 28 99.2 0 2 247 209 290 MFI5460944.1 non-hydrolyzing UDP-N-acetylglucosamine 2-epimerase [Isosphaerales bacterium] diamond 492 122 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales     Isosphaerales bacterium
32045319 32045319 PRJNA792582_P_NODE_26778_length_334_cov_1.072797_g25964_i0 PRJNA792582 26778 334 1.072797 3.58314198 Planctomycetota bacterium 2026780 Bacteria Bacteria 67.8 1.78e-10   NR MEY3173688.1 2026780 g25964 i0 48.3 2.98203592814371 58 30 52.1 0 177 4 234 291 MEY3173688.1 Metalloprotease StcE precursor [Planctomycetota bacterium] diamond 996 67.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32045332 32045332 PRJNA792582_P_NODE_35738_length_289_cov_1.333333_g34924_i0 PRJNA792582 35738 289 1.333333 3.85333237 Planctomycetota bacterium 2026780 Bacteria Bacteria 56.6 8.55e-7   NR HYC76686.1 2026780 g34924 i0 45.5 0.799307958477509 77 42 79.9 0 285 55 290 366 HYC76686.1 long-chain fatty acid--CoA ligase [Planctomycetota bacterium] diamond 231 56.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32708941 32708941 PRJNA792582_P_NODE_39600_length_279_cov_1.038835_g38786_i0 PRJNA792582 39600 279 1.038835 2.89834965 Gemmataceae bacterium 2052164 Bacteria Bacteria 75.9 1.87e-15   NR MCI0381233.1 2052164 g38786 i0 55.7 0.655913978494624 61 27 65.6 0 277 95 47 107 MCI0381233.1 hypothetical protein [Gemmataceae bacterium] diamond 183 75.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32866383 32866383 PRJNA792582_P_NODE_55880_length_245_cov_0.895349_g55066_i0 PRJNA792582 55880 245 0.895349 2.19360505 Pirellulaceae bacterium 2699754 Bacteria Bacteria 110 4.1e-27   NR MCO6457732.1 2699754 g55066 i0 63.8 0.979591836734694 80 29 98 0 5 244 114 193 MCO6457732.1 dihydroorotate dehydrogenase-like protein [Pirellulaceae bacterium] diamond 240 110 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae 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);;