RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • PVC group · 20 ✖

bioproject 1

  • PRJNA725806 · 20 ✖
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
711804 711804 PRJNA725806_P_NODE_1941_length_571_cov_1.552434_g1713_i0 PRJNA725806 1941 571 1.552434 8.86439814 Singulisphaera sp. GP187 1882752 Bacteria Bacteria 121 3.84e-28   NR WP_074311168.1 1882752 g1713 i0 90.6 0.336252189141856 64 6 33.6 0 2 193 699 762 WP_074311168.1 DUF4159 domain-containing protein [Singulisphaera sp. GP187] diamond 192 121 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. GP187
18563776 18563776 PRJNA725806_P_NODE_90155_length_205_cov_1.255952_g89853_i0 PRJNA725806 90155 205 1.255952 2.5747016 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 281 2.1e-71   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g89853 i0 92 40.5219512195122 200 16 98 0 6 205 1600555 1600754 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 8307 281 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
19838702 19838702 PRJNA725806_P_NODE_134076_length_176_cov_5.719424_g133774_i0 PRJNA725806 134076 176 5.719424 10.06618624 Candidatus Uabimicrobium amorphum 2596890 Bacteria Bacteria 54.7 0.004   NTclustered gi|1732437785|dbj|AP019860.1| 2596890 g133774 i0 92.308 0.221590909090909 39 2 22 1 112 150 2507158 2507195 Planctomycetes bacterium SRT547 DNA, complete genome blastn 39 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Uabimicrobiia Candidatus Uabimicrobiales Candidatus Uabimicrobiaceae Candidatus Uabimicrobium Candidatus Uabimicrobium amorphum
24938404 24938404 PRJNA725806_P_NODE_540_length_883_cov_7.758865_g413_i0 PRJNA725806 540 883 7.758865 68.51077795 Maioricimonas rarisocia 2528026 Bacteria Bacteria 63.9 4.11e-5   NTclustered gi|1712603021|gb|CP036275.1| 2528026 g413 i0 97.297 18.2785956964892 37 1 4 0 270 306 1111013 1110977 Maioricimonas rarisocia strain Mal4 chromosome, complete genome blastn 16140 63.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Maioricimonas Maioricimonas rarisocia
26767442 26767442 PRJNA725806_P_NODE_69461_length_224_cov_1.491979_g69160_i0 PRJNA725806 69461 224 1.491979 3.34203296 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.7 0.0299   NR MBL8694746.1 2026780 g69160 i0 29.4 0.683035714285714 51 32 62.9 1 160 20 256 306 MBL8694746.1 DUF1080 domain-containing protein [Planctomycetota bacterium] diamond 153 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27305229 27305229 PRJNA725806_P_NODE_122003_length_183_cov_2.801370_g121701_i0 PRJNA725806 122003 183 2.80137 5.1265071 Rhodopirellula sp. 2024855 Bacteria Bacteria 43.1 0.00389   NR MDA7873697.1 2024855 g121701 i0 42.1 0.934426229508197 57 20 72.1 3 35 166 45 101 MDA7873697.1 hypothetical protein [Rhodopirellula sp.] diamond 171 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rhodopirellula Rhodopirellula sp.
27336871 27336871 PRJNA725806_P_NODE_190303_length_152_cov_1.686957_g190001_i0 PRJNA725806 190303 152 1.686957 2.56417464 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 43.5 0.00581   NR MAB71004.1 2026779 g190001 i0 47.7 2.82236842105263 44 23 86.8 0 144 13 651 694 MAB71004.1 hypothetical protein [Planctomycetaceae bacterium] diamond 429 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27810596 27810596 PRJNA725806_P_NODE_44864_length_257_cov_1.740909_g44567_i0 PRJNA725806 44864 257 1.740909 4.47413613 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 96.7 3.9900000000000005e-21   NR HEX3450905.1 2691532 g44567 i0 57.8 0.968871595330739 83 35 96.9 0 6 254 180 262 HEX3450905.1 hypothetical protein [Isosphaeraceae bacterium] diamond 249 96.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
28252338 28252338 PRJNA725806_P_NODE_169926_length_160_cov_1.260163_g169624_i0 PRJNA725806 169926 160 1.260163 2.0162608 Gemmataceae bacterium 2052164 Bacteria Bacteria 92.8 5.45e-22   NR MDB5312363.1 2052164 g169624 i0 88.5 0.975 52 6 97.5 0 158 3 123 174 MDB5312363.1 hypothetical protein [Gemmataceae bacterium] diamond 156 92.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28315668 28315668 PRJNA725806_P_NODE_26586_length_296_cov_2.625483_g26289_i0 PRJNA725806 26586 296 2.625483 7.77142968 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 67.8 8.89e-11   NR HEV7299936.1 2876886 g26289 i0 61.9 3.26351351351351 42 16 42.6 0 21 146 308 349 HEV7299936.1 zinc-binding dehydrogenase [Tepidisphaeraceae bacterium] diamond 966 67.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
29010605 29010605 PRJNA725806_P_NODE_162768_length_163_cov_1.547619_g162466_i0 PRJNA725806 162768 163 1.547619 2.52261897 Pirellulaceae bacterium 2699754 Bacteria Bacteria 96.7 3.01e-24   NR HEY6564998.1 2699754 g162466 i0 87 0.993865030674847 54 7 99.4 0 163 2 36 89 HEY6564998.1 restriction endonuclease [Pirellulaceae bacterium] diamond 162 96.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
29483563 29483563 PRJNA725806_P_NODE_126070_length_181_cov_1.076389_g125768_i0 PRJNA725806 126070 181 1.076389 1.94826409 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 74.3 1.18e-13   NR HEX3450905.1 2691532 g125768 i0 55 1.98895027624309 60 27 99.4 0 2 181 363 422 HEX3450905.1 hypothetical protein [Isosphaeraceae bacterium] diamond 360 74.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
30146780 30146780 PRJNA725806_P_NODE_59072_length_236_cov_3.311558_g58775_i0 PRJNA725806 59072 236 3.311558 7.81527688 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 42 0.0496   NR MDR2704663.1 2026779 g58775 i0 41.3 0.584745762711864 46 27 58.5 0 4 141 133 178 MDR2704663.1 hypothetical protein [Planctomycetaceae bacterium] diamond 138 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30347514 30347514 PRJNA725806_P_NODE_93772_length_202_cov_2.012121_g93470_i0 PRJNA725806 93772 202 2.012121 4.06448442 Mariniblastus 2005380 Bacteria Bacteria 51.2 2.08e-5   NR MCH2180739.1 2005381 g93470 i0 70 2.67326732673267 30 9 44.6 0 92 3 118 147 MCH2180739.1 N(4)-(beta-N-acetylglucosaminyl)-L-asparaginase [Mariniblastus sp.] diamond 540 51.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Mariniblastus Mariniblastus sp.
30463437 30463437 PRJNA725806_P_NODE_6893_length_410_cov_2.171582_g6609_i0 PRJNA725806 6893 410 2.171582 8.9034862 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 123 6.54e-30   NR HEX3450905.1 2691532 g6609 i0 79.7 0.541463414634146 74 15 54.1 0 188 409 16 89 HEX3450905.1 hypothetical protein [Isosphaeraceae bacterium] diamond 222 123 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
30842260 30842260 PRJNA725806_P_NODE_35954_length_273_cov_6.220339_g35657_i0 PRJNA725806 35954 273 6.220339 16.98152547 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 41.6 0.0245   NR HEY4762011.1 2691551 g35657 i0 42.9 0.538461538461538 49 28 53.8 0 23 169 19 67 HEY4762011.1 dCTP deaminase [Thermoguttaceae bacterium] diamond 147 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
30968727 30968727 PRJNA725806_P_NODE_97674_length_199_cov_2.216049_g97372_i0 PRJNA725806 97674 199 2.216049 4.40993751 Planctomycetota bacterium 2026780 Bacteria Bacteria 100 1.32e-22   NR MEE9391311.1 2026780 g97372 i0 68.3 5.69849246231156 63 20 95 0 198 10 673 735 MEE9391311.1 RNase H-like domain-containing protein [Planctomycetota bacterium] diamond 1134 100 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31221031 31221031 PRJNA725806_P_NODE_147775_length_170_cov_1.127820_g147473_i0 PRJNA725806 147775 170 1.12782 1.917294 Planctomycetia bacterium 2052181 Bacteria Bacteria 64.7 2.49e-10   NR GDY10888.1 2052181 g147473 i0 63.5 1.88823529411765 52 19 91.8 0 158 3 1 52 GDY10888.1 hypothetical protein LBMAG52_43760 [Planctomycetia bacterium] diamond 321 64.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
32770385 32770385 PRJNA725806_P_NODE_43660_length_259_cov_1.202703_g43363_i0 PRJNA725806 43660 259 1.202703 3.11500077 Gemmatales bacterium 2838789 Bacteria Bacteria 127 4.76e-35   NR HMO34528.1 2838789 g43363 i0 80 2.77992277992278 80 16 92.7 0 241 2 3 82 HMO34528.1 glutamate 5-kinase [Gemmatales bacterium] diamond 720 127 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales     Gemmatales bacterium
32864888 32864888 PRJNA725806_P_NODE_112380_length_189_cov_1.756579_g112078_i0 PRJNA725806 112380 189 1.756579 3.31993431 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 77.4 1.05e-14   NR HEX3450905.1 2691532 g112078 i0 65.6 0.968253968253968 61 21 96.8 0 6 188 94 154 HEX3450905.1 hypothetical protein [Isosphaeraceae bacterium] diamond 183 77.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae 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);;