RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA1249535", 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 · 23 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 23 ✖

bioproject 1

  • PRJNA1249535 · 23 ✖
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
4183608 4183608 PRJNA1249535_S_NODE_206604_length_303_cov_1.017391_g203221_i0 PRJNA1249535 206604 303 1.017391 3.08269473 Roseimaritima ulvae 980254 Bacteria Bacteria 459 1.4199999999999996e-124   NTclustered gi|1727550343|gb|CP042914.1| 980254 g203221 i0 94.059 212.3300330033 303 16 99 1 3 303 6160309 6160007 Roseimaritima ulvae strain UC8 chromosome, complete genome blastn 64336 459 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Roseimaritima Roseimaritima ulvae
6735071 6735071 PRJNA1249535_S_NODE_275546_length_266_cov_2.720207_g272163_i0 PRJNA1249535 275546 266 2.720207 7.23575062 Stieleria varia 2528005 Bacteria Bacteria 470 5.669999999999999e-128   NTclustered gi|2720418917|gb|CP151726.1| 2528005 g272163 i0 98.496 141.868421052632 266 4 100 0 1 266 2278152 2278417 Stieleria varia strain Pla52n chromosome, complete genome blastn 37737 470 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Stieleria Stieleria varia
9286814 9286814 PRJNA1249535_S_NODE_60188_length_445_cov_4.231183_g56819_i0 PRJNA1249535 60188 445 4.231183 18.82876435 Sedimentisphaerales bacterium 2813034 Bacteria Bacteria 60.2 2.57e-4   NTclustered gi|2621701142|emb|OY759675.1| 2813034 g56819 i0 100 0.0719101123595506 32 0 7 0 314 345 3644773 3644742 MAG: Sedimentisphaerales bacterium isolate f0e5d044-1a19-4baf-a299-9636c83af3ad genome assembly, chromosome: 1 blastn 32 60.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Sedimentisphaerales     Sedimentisphaerales bacterium
19483214 19483214 PRJNA1249535_S_NODE_260776_length_274_cov_2.706468_g257393_i0 PRJNA1249535 260776 274 2.706468 7.41572232 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 398 2.8099999999999998e-106   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g257393 i0 92.78 108.934306569343 277 17 100 3 1 274 7052242 7052518 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 29848 398 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
20757081 20757081 PRJNA1249535_S_NODE_139777_length_342_cov_2.401487_g136394_i0 PRJNA1249535 139777 342 2.401487 8.21308554 Roseimaritima ulvae 980254 Bacteria Bacteria 235 2.99e-57   NTclustered gi|1727550343|gb|CP042914.1| 980254 g136394 i0 87.624 19.7017543859649 202 25 59 0 141 342 6157414 6157615 Roseimaritima ulvae strain UC8 chromosome, complete genome blastn 6738 235 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Roseimaritima Roseimaritima ulvae
26915549 26915549 PRJNA1249535_S_NODE_327422_length_236_cov_4.490798_g324039_i0 PRJNA1249535 327422 236 4.490798 10.59828328 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.00513   NR REK18466.1 2026780 g324039 i0 40.3 0.788135593220339 62 36 77.5 1 196 14 215 276 REK18466.1 MAG: hypothetical protein DWQ42_19895 [Planctomycetota bacterium] diamond 186 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26947104 26947104 PRJNA1249535_S_NODE_273382_length_267_cov_3.427835_g269999_i0 PRJNA1249535 273382 267 3.427835 9.15231945 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.6 0.036   NR MBS0211107.1 2026780 g269999 i0 32 0.842696629213483 75 47 82 2 246 28 22 94 MBS0211107.1 transposase [Planctomycetota bacterium] diamond 225 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27073662 27073662 PRJNA1249535_S_NODE_169982_length_323_cov_2.496000_g166599_i0 PRJNA1249535 169982 323 2.496 8.06208 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 44.7 0.0192   NR HET6328520.1 2026779 g166599 i0 57.6 0.613003095975232 33 14 30.7 0 322 224 427 459 HET6328520.1 ankyrin repeat domain-containing protein [Planctomycetaceae bacterium] diamond 198 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27894936 27894936 PRJNA1249535_S_NODE_69105_length_422_cov_4.664756_g65725_i0 PRJNA1249535 69105 422 4.664756 19.68527032 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 54.3 5.52e-6   NR MCP4253438.1 2268189 g65725 i0 46 0.718009478672986 50 26 35.5 1 273 422 26 74 MCP4253438.1 hypothetical protein [Candidatus Scalindua sp.] diamond 303 54.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
28052824 28052824 PRJNA1249535_S_NODE_324985_length_238_cov_6.096970_g321602_i0 PRJNA1249535 324985 238 6.09697 14.5107886 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 43.1 0.0249   NR NLS96947.1 2026779 g321602 i0 42.6 0.76890756302521 61 34 75.6 1 12 191 333 393 NLS96947.1 hypothetical protein [Planctomycetaceae bacterium] diamond 183 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28305459 28305459 PRJNA1249535_S_NODE_296306_length_255_cov_1.214286_g292923_i0 PRJNA1249535 296306 255 1.214286 3.0964293 Pirellulales bacterium 2715253 Bacteria Bacteria 42.4 0.0184   NR MEO2046903.1 2715253 g292923 i0 35.2 0.635294117647059 54 34 62.4 1 188 30 46 99 MEO2046903.1 serine O-acetyltransferase [Pirellulales bacterium] diamond 162 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
28589764 28589764 PRJNA1249535_S_NODE_251867_length_279_cov_2.072816_g248484_i0 PRJNA1249535 251867 279 2.072816 5.78315664 Gemmataceae bacterium 2052164 Bacteria Bacteria 45.4 0.00613   NR HEX3315219.1 2052164 g248484 i0 41.9 0.462365591397849 43 25 46.2 0 263 135 294 336 HEX3315219.1 PQQ-binding-like beta-propeller repeat protein [Gemmataceae bacterium] diamond 129 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28715951 28715951 PRJNA1249535_S_NODE_132747_length_347_cov_1.850365_g129364_i0 PRJNA1249535 132747 347 1.850365 6.42076655 Planctomycetota bacterium JB042 3343268 Bacteria Bacteria 44.7 0.0246   NR MFG0316185.1 3343268 g129364 i0 35.8 0.9164265129683 106 49 86.5 4 324 25 29 121 MFG0316185.1 lipopolysaccharide kinase InaA family protein [Planctomycetota bacterium JB042] diamond 318 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium JB042
29536800 29536800 PRJNA1249535_S_NODE_174590_length_320_cov_3.898785_g171207_i0 PRJNA1249535 174590 320 3.898785 12.476112 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 43.9 0.0359   NR MBA63788.1 2026779 g171207 i0 31.5 0.8625 92 57 84.4 2 314 45 428 515 MBA63788.1 hypothetical protein [Planctomycetaceae bacterium] diamond 276 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29820742 29820742 PRJNA1249535_S_NODE_136571_length_344_cov_3.479705_g133188_i0 PRJNA1249535 136571 344 3.479705 11.9701852 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 45.4 0.00572   NR MCP4253438.1 2268189 g133188 i0 33 0.845930232558139 97 59 83.7 3 290 3 56 147 MCP4253438.1 hypothetical protein [Candidatus Scalindua sp.] diamond 291 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
29915982 29915982 PRJNA1249535_S_NODE_331431_length_233_cov_2.325000_g328048_i0 PRJNA1249535 331431 233 2.325 5.41725 Phycisphaerae bacterium 2026778 Bacteria Bacteria 42.4 0.0441   NR MBL8760587.1 2026778 g328048 i0 40.8 0.630901287553648 49 29 63.1 0 47 193 385 433 MBL8760587.1 amino acid permease [Phycisphaerae bacterium] diamond 147 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
30168343 30168343 PRJNA1249535_S_NODE_236952_length_287_cov_1.598131_g233569_i0 PRJNA1249535 236952 287 1.598131 4.58663597 Gemmataceae bacterium 2052164 Bacteria Bacteria 44.7 0.0132   NR MCI0464063.1 2052164 g233569 i0 42 2.67595818815331 50 27 52.3 1 59 208 71 118 MCI0464063.1 type VI secretion system tip protein VgrG [Gemmataceae bacterium] diamond 768 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
30263539 30263539 PRJNA1249535_S_NODE_126512_length_351_cov_4.902878_g123129_i0 PRJNA1249535 126512 351 4.902878 17.20910178 Candidatus Brocadia carolinensis 1004156 Bacteria Bacteria 44.7 0.0183   NR OOP57401.1 1004156 g123129 i0 35.7 0.478632478632479 56 34 47.9 1 13 180 127 180 OOP57401.1 MAG: hypothetical protein AYP45_03540 [Candidatus Brocadia carolinensis] diamond 168 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae Candidatus Brocadia Candidatus Brocadia carolinensis
31210707 31210707 PRJNA1249535_S_NODE_336275_length_228_cov_3.161290_g332892_i0 PRJNA1249535 336275 228 3.16129 7.2077412 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.4 0.00346   NR RLS96368.1 2026780 g332892 i0 41.1 0.736842105263158 56 29 68.4 1 59 214 202 257 RLS96368.1 MAG: asparagine synthase (glutamine-hydrolyzing) [Planctomycetota bacterium] diamond 168 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31305932 31305932 PRJNA1249535_S_NODE_138415_length_343_cov_2.192593_g135032_i0 PRJNA1249535 138415 343 2.192593 7.52059399 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.0152   NR MEL7338267.1 2026780 g135032 i0 31.3 1.11953352769679 64 40 52.5 1 263 84 77 140 MEL7338267.1 hypothetical protein [Planctomycetota bacterium] diamond 384 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31495999 31495999 PRJNA1249535_S_NODE_213316_length_299_cov_3.048673_g209933_i0 PRJNA1249535 213316 299 3.048673 9.11553227 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 46.2 0.00389   NR MCP4254340.1 2268189 g209933 i0 40.4 1.07357859531773 57 32 55.2 1 196 32 76 132 MCP4254340.1 hypothetical protein [Candidatus Scalindua sp.] diamond 321 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
31527569 31527569 PRJNA1249535_S_NODE_261216_length_274_cov_1.845771_g257833_i0 PRJNA1249535 261216 274 1.845771 5.05741254 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 44.7 0.0111   NR MCA9033742.1 2026779 g257833 i0 40.7 0.591240875912409 54 30 59.1 1 91 252 48 99 MCA9033742.1 anthranilate synthase component I family protein [Planctomycetaceae bacterium] diamond 162 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31938516 31938516 PRJNA1249535_S_NODE_231217_length_290_cov_1.811060_g227834_i0 PRJNA1249535 231217 290 1.81106 5.252074 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 43.5 0.0341   NR MCE2967256.1 2026777 g227834 i0 25.7 1.0448275862069 101 70 99.3 2 3 290 178 278 MCE2967256.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 303 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae 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);;