RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA1115053", 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

  • PRJNA1115053 · 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
224635 224635 PRJNA1115053_S_NODE_197281_length_195_cov_1.578947_g195464_i0 PRJNA1115053 197281 195 1.578947 3.07894665 Planctomyces sp. SH-PL14 1632864 Bacteria Bacteria 250 5.57e-62   NTclustered gi|1015434452|gb|CP011270.1| 1632864 g195464 i0 89.744 2.10769230769231 195 20 100 0 1 195 4955579 4955773 Planctomyces sp. SH-PL14, complete genome blastn 411 250 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
225291 225291 PRJNA1115053_S_NODE_223541_length_184_cov_4.000000_g221724_i0 PRJNA1115053 223541 184 4 7.36 Phycisphaerales bacterium 2052180 Bacteria Bacteria 161 2.5e-35   NTclustered gi|1958061316|gb|CP064987.1| 2052180 g221724 i0 82.703 252.451086956522 185 28 99 4 1 183 2190484 2190302 Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome blastn 46451 161 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
6607202 6607202 PRJNA1115053_S_NODE_66926_length_302_cov_4.532819_g65109_i0 PRJNA1115053 66926 302 4.532819 13.68911338 Humisphaera borealis 2807512 Bacteria Bacteria 220 7.28e-53   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g65109 i0 82.8 141.778145695364 250 39 82 4 5 252 5063090 5062843 Humisphaera borealis strain M1803 chromosome, complete genome blastn 42817 220 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
7402101 7402101 PRJNA1115053_S_NODE_163426_length_211_cov_3.232143_g161609_i0 PRJNA1115053 163426 211 3.232143 6.81982173 Gemmata 113 Bacteria Bacteria 374 3.4799999999999995e-99   NTclustered gi|12583965|gb|AF245369.1|AF245369 114 g161609 i0 98.578 161.199052132701 211 3 100 0 1 211 2437 2647 Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence blastn 34013 374 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
7876648 7876648 PRJNA1115053_S_NODE_159267_length_214_cov_1.397661_g157450_i0 PRJNA1115053 159267 214 1.397661 2.99099454 Planctomycetales bacterium 10988 2603660 Bacteria Bacteria 265 2.22e-66   NTclustered gi|1775855904|gb|CP043547.1| 2603660 g157450 i0 89.904 258.327102803738 208 18 97 3 1 207 2223143 2223348 Planctomycetales bacterium 10988 chromosome, complete genome blastn 55282 265 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium 10988
7878618 7878618 PRJNA1115053_S_NODE_240667_length_179_cov_0.889706_g238850_i0 PRJNA1115053 240667 179 0.889706 1.59257374 Humisphaera borealis 2807512 Bacteria Bacteria 156 1.12e-33   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g238850 i0 87.879 10.7486033519553 132 16 77 0 10 141 5062814 5062683 Humisphaera borealis strain M1803 chromosome, complete genome blastn 1924 156 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
10432443 10432443 PRJNA1115053_S_NODE_59989_length_315_cov_2.275735_g58172_i0 PRJNA1115053 59989 315 2.275735 7.16856525 Urbifossiella limnaea 2528023 Bacteria Bacteria 346 1.21e-90   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g58172 i0 86.667 127.101587301587 315 39 100 3 1 315 2017982 2018293 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 40037 346 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
11228055 11228055 PRJNA1115053_S_NODE_56729_length_321_cov_8.705036_g54912_i0 PRJNA1115053 56729 321 8.705036 27.94316556 Gemmata 113 Bacteria Bacteria 505 1.9199999999999995e-138   NTclustered gi|1015440974|gb|CP011271.1| 1630693 g54912 i0 95.046 160.545171339564 323 12 100 4 1 321 559490 559170 Gemmata sp. SH-PL17, complete genome blastn 51535 505 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp. SH-PL17
12503642 12503642 PRJNA1115053_S_NODE_990_length_1687_cov_17.725061_g585_i0 PRJNA1115053 990 1687 17.725061 299.02177907 Frigoriglobus 2774146 Bacteria Bacteria 2488 0   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g585 i0 93.668 182.708358032009 1674 88 99 17 26 1687 2001625 2003292 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 308229 2505 0.993213572854291 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
19349947 19349947 PRJNA1115053_S_NODE_1676_length_1224_cov_7.557155_g809_i1 PRJNA1115053 1676 1224 7.557155 92.4995772 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 1184 0   NTclustered gi|2874253799|emb|OY969783.1| 2876886 g809 i1 85.714 148.976307189542 1148 135 92 24 94 1224 2503715 2502580 MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1 blastn 182347 1184 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
19351217 19351217 PRJNA1115053_S_NODE_222036_length_185_cov_1.633803_g220219_i0 PRJNA1115053 222036 185 1.633803 3.02253555 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 169 1.5e-37   NTclustered gi|2874253847|emb|OY969903.1| 904075 g220219 i0 85.455 34.2 165 20 89 3 22 185 1831291 1831452 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 6327 169 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
23175496 23175496 PRJNA1115053_S_NODE_1319_length_1398_cov_7.240590_g809_i0 PRJNA1115053 1319 1398 7.24059 101.22344820000001 Humisphaera borealis 2807512 Bacteria Bacteria 1373 0   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g809 i0 86.113 334.152360515021 1289 162 92 16 24 1305 5064120 5062842 Humisphaera borealis strain M1803 chromosome, complete genome blastn 467145 1373 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
26719436 26719436 PRJNA1115053_S_NODE_148521_length_220_cov_2.440678_g146704_i0 PRJNA1115053 148521 220 2.440678 5.3694916 Phycisphaerales bacterium 2052180 Bacteria Bacteria 42.7 0.0266   NR MCH2162800.1 2052180 g146704 i0 39.5 0.518181818181818 38 23 51.8 0 63 176 270 307 MCH2162800.1 hypothetical protein [Phycisphaerales bacterium] diamond 114 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
26878428 26878428 PRJNA1115053_S_NODE_124221_length_237_cov_3.051546_g122404_i0 PRJNA1115053 124221 237 3.051546 7.23216402 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.6 0.0443   NR REJ79784.1 2026780 g122404 i0 46.3 0.518987341772152 41 22 51.9 0 13 135 99 139 REJ79784.1 MAG: YkgJ family cysteine cluster protein [Planctomycetota bacterium] diamond 123 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27004612 27004612 PRJNA1115053_S_NODE_198722_length_194_cov_2.543046_g196905_i0 PRJNA1115053 198722 194 2.543046 4.93350924 Planctomycetia bacterium 2052181 Bacteria Bacteria 41.6 0.0498   NR MDO4571097.1 2052181 g196905 i0 37.5 0.865979381443299 56 34 86.6 1 174 7 190 244 MDO4571097.1 PmoA family protein [Planctomycetia bacterium] diamond 168 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
27185348 27185348 PRJNA1115053_S_NODE_60822_length_313_cov_3.833333_g59005_i0 PRJNA1115053 60822 313 3.833333 11.99833229 PVC group 1783257 Bacteria Bacteria 43.9 0.03   NR MCC6406572.1 2026780 g59005 i0 41.8 1.53354632587859 67 33 62.3 4 114 308 1 63 MCC6406572.1 hypothetical protein [Planctomycetota bacterium] diamond 480 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28394393 28394393 PRJNA1115053_S_NODE_215306_length_188_cov_0.875862_g213489_i0 PRJNA1115053 215306 188 0.875862 1.64662056 Planctomycetota bacterium 2026780 Bacteria Bacteria 39.3 0.0482   NR HKB15928.1 2026780 g213489 i0 56.3 0.51063829787234 32 13 49.5 1 28 120 10 41 HKB15928.1 hypothetical protein [Planctomycetota bacterium] diamond 96 39.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30636557 30636557 PRJNA1115053_S_NODE_129413_length_233_cov_2.857895_g127596_i0 PRJNA1115053 129413 233 2.857895 6.65889535 Rhodopirellula sp. 2024855 Bacteria Bacteria 43.1 0.0216   NR MAQ91336.1 2024855 g127596 i0 43.5 0.592274678111588 46 21 52.8 1 189 67 206 251 MAQ91336.1 hypothetical protein [Rhodopirellula sp.] diamond 138 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rhodopirellula Rhodopirellula sp.
30889564 30889564 PRJNA1115053_S_NODE_360574_length_150_cov_0.897196_g358757_i0 PRJNA1115053 360574 150 0.897196 1.345794 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0195   NR MEZ6194240.1 2026780 g358757 i0 48.9 0.94 47 24 94 0 3 143 176 222 MEZ6194240.1 hypothetical protein [Planctomycetota bacterium] diamond 141 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31395364 31395364 PRJNA1115053_S_NODE_291576_length_163_cov_2.400000_g289759_i0 PRJNA1115053 291576 163 2.4 3.912 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 42 0.0228   NR MEZ6058101.1 2026779 g289759 i0 50 0.552147239263804 30 15 55.2 0 63 152 245 274 MEZ6058101.1 formylglycine-generating enzyme family protein [Planctomycetaceae bacterium] diamond 90 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32376035 32376035 PRJNA1115053_S_NODE_206879_length_191_cov_1.459459_g205062_i0 PRJNA1115053 206879 191 1.459459 2.78756669 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0261   NR MDG1983274.1 2026780 g205062 i0 42.6 0.848167539267016 54 29 84.8 1 11 172 714 765 MDG1983274.1 PSD1 and planctomycete cytochrome C domain-containing protein [Planctomycetota bacterium] diamond 162 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32471078 32471078 PRJNA1115053_S_NODE_63119_length_309_cov_2.165414_g61302_i0 PRJNA1115053 63119 309 2.165414 6.69112926 Planctomycetota bacterium 2026780 Bacteria Bacteria 48.5 5.88e-4   NR MEM1329189.1 2026780 g61302 i0 32.9 1.36893203883495 70 47 68 0 305 96 136 205 MEM1329189.1 hypothetical protein [Planctomycetota bacterium] diamond 423 48.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32597361 32597361 PRJNA1115053_S_NODE_210740_length_189_cov_2.630137_g208923_i0 PRJNA1115053 210740 189 2.630137 4.97095893 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0243   NR MCC6406572.1 2026780 g208923 i0 43.1 0.920634920634921 58 28 88.9 3 181 14 1 55 MCC6406572.1 hypothetical protein [Planctomycetota bacterium] diamond 174 42.4 1 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);;