RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • PVC group · 18 ✖

bioproject 1

  • PRJNA797655 · 18 ✖
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
2063451 2063451 PRJNA797655_S_NODE_43402_length_329_cov_2.181818_g42797_i0 PRJNA797655 43402 329 2.181818 7.17818122 Roseimaritima 1579506 Bacteria Bacteria 137 1.28e-36   NR MBU6172826.1 2026780 g42797 i0 63.2 2.01519756838906 114 35 97.6 1 324 4 7 120 MBU6172826.1 DUF1559 domain-containing protein [Planctomycetota bacterium] diamond 663 138 0.992753623188406 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
12268191 12268191 PRJNA797655_S_NODE_77830_length_270_cov_4.057269_g77225_i0 PRJNA797655 77830 270 4.057269 10.9546263 Candidatus Uabimicrobium helgolandensis 3095367 Bacteria Bacteria 54.7 0.007   NTclustered gi|2793194503|gb|CP165719.1| 3095367 g77225 i0 100 0.537037037037037 29 0 11 0 35 63 344505 344533 Candidatus Uabimicrobium helgolandensis strain HlEnr_7 chromosome blastn 145 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Uabimicrobiia Candidatus Uabimicrobiales Candidatus Uabimicrobiaceae Candidatus Uabimicrobium Candidatus Uabimicrobium helgolandensis
27275214 27275214 PRJNA797655_S_NODE_151803_length_205_cov_1.481481_g151198_i0 PRJNA797655 151803 205 1.481481 3.03703605 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 42 0.0371   NR MDX1681814.1 2026777 g151198 i0 36.4 0.64390243902439 44 28 64.4 0 58 189 106 149 MDX1681814.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 132 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
27464854 27464854 PRJNA797655_S_NODE_118903_length_229_cov_1.629032_g118298_i0 PRJNA797655 118903 229 1.629032 3.73048328 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.00469   NR MFM1871646.1 2026780 g118298 i0 34.7 0.943231441048035 72 40 94.3 1 11 226 15 79 MFM1871646.1 hypothetical protein [Planctomycetota bacterium] diamond 216 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27496369 27496369 PRJNA797655_S_NODE_249923_length_158_cov_1.669565_g249318_i0 PRJNA797655 249923 158 1.669565 2.6379127000000002 Phycisphaerae bacterium 2026778 Bacteria Bacteria 41.2 0.0412   NR MFO0837951.1 2026778 g249318 i0 42.5 0.759493670886076 40 21 75.9 1 145 26 311 348 MFO0837951.1 ferric reductase-like transmembrane domain-containing protein [Phycisphaerae bacterium] diamond 120 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27654352 27654352 PRJNA797655_S_NODE_87444_length_259_cov_2.222222_g86839_i0 PRJNA797655 87444 259 2.222222 5.75555498 Gemmataceae bacterium 2052164 Bacteria Bacteria 42.7 0.0441   NR HKA06075.1 2052164 g86839 i0 50 0.486486486486487 42 18 45.2 1 88 204 214 255 HKA06075.1 aspartate aminotransferase family protein [Gemmataceae bacterium] diamond 126 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28475145 28475145 PRJNA797655_S_NODE_50126_length_314_cov_3.583026_g49521_i0 PRJNA797655 50126 314 3.583026 11.25070164 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0451   NR MEW6197564.1 2026780 g49521 i0 41.7 0.936305732484076 60 25 47.8 1 223 74 280 339 MEW6197564.1 hypothetical protein [Planctomycetota bacterium] diamond 294 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29012165 29012165 PRJNA797655_S_NODE_117088_length_230_cov_3.475936_g116483_i0 PRJNA797655 117088 230 3.475936 7.9946528 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0422   NR MBS0208492.1 2026780 g116483 i0 41.5 0.691304347826087 53 31 69.1 0 206 48 131 183 MBS0208492.1 tryptophan synthase subunit beta [Planctomycetota bacterium] diamond 159 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29138390 29138390 PRJNA797655_S_NODE_156049_length_202_cov_1.968553_g155444_i0 PRJNA797655 156049 202 1.968553 3.97647706 Gemmataceae bacterium 2052164 Bacteria Bacteria 42.7 0.00901   NR MFO0841988.1 2052164 g155444 i0 53.8 0.386138613861386 26 12 38.6 0 120 43 81 106 MFO0841988.1 hypothetical protein [Gemmataceae bacterium] diamond 78 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29264241 29264241 PRJNA797655_S_NODE_280389_length_150_cov_1.065421_g279784_i0 PRJNA797655 280389 150 1.065421 1.5981315 Pirellulaceae bacterium 2699754 Bacteria Bacteria 41.2 0.0382   NR MBC7857034.1 2699754 g279784 i0 37.5 0.8 40 25 80 0 1 120 600 639 MBC7857034.1 squalene/phytoene synthase family protein [Pirellulaceae bacterium] diamond 120 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
29905198 29905198 PRJNA797655_S_NODE_209231_length_174_cov_3.297710_g208626_i0 PRJNA797655 209231 174 3.29771 5.7380154 Planctomycetia 203683 Bacteria Bacteria 43.1 0.0045   NR MCE9529368.1 2053591 g208626 i0 50 1.31034482758621 38 17 65.5 1 9 122 56 91 MCE9529368.1 hypothetical protein [Planctomycetales bacterium] diamond 228 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
30053756 30053756 PRJNA797655_S_NODE_88611_length_258_cov_1.562791_g88006_i0 PRJNA797655 88611 258 1.562791 4.03200078 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0225   NR MDA0836984.1 2026780 g88006 i0 35.4 0.755813953488372 65 42 75.6 0 232 38 10 74 MDA0836984.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium] diamond 195 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30907204 30907204 PRJNA797655_S_NODE_210634_length_174_cov_1.465649_g210029_i0 PRJNA797655 210634 174 1.465649 2.55022926 Gemmataceae bacterium 2052164 Bacteria Bacteria 42.4 0.0201   NR HLN27799.1 2052164 g210029 i0 44.7 0.655172413793103 38 20 63.8 1 173 63 206 243 HLN27799.1 sodium:solute symporter family protein [Gemmataceae bacterium] diamond 114 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31571064 31571064 PRJNA797655_S_NODE_107076_length_239_cov_2.316327_g106471_i0 PRJNA797655 107076 239 2.316327 5.53602153 Pirellulaceae 2691357 Bacteria Bacteria 42 0.0263   NR WP_230262523.1 2691357 g106471 i0 36.4 0.690376569037657 55 30 69 1 199 35 3 52 WP_230262523.1 MULTISPECIES: hypothetical protein [Pirellulaceae] diamond 165 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae    
31823784 31823784 PRJNA797655_S_NODE_273297_length_151_cov_2.222222_g272692_i0 PRJNA797655 273297 151 2.222222 3.35555522 Planctomycetia bacterium 2052181 Bacteria Bacteria 41.2 0.038   NR MFM8979317.1 2052181 g272692 i0 56.3 0.635761589403974 32 12 59.6 1 61 150 62 93 MFM8979317.1 DUF1800 family protein [Planctomycetia bacterium] diamond 96 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
31832825 31832825 PRJNA797655_S_NODE_137677_length_214_cov_2.526316_g137072_i0 PRJNA797655 137677 214 2.526316 5.40631624 Planctomycetia 203683 Bacteria Bacteria 55.8 4.75e-7   NR MSU78880.1 2052164 g137072 i0 75.8 6.14018691588785 33 8 46.3 0 1 99 234 266 MSU78880.1 FAA hydrolase family protein [Gemmataceae bacterium] diamond 1314 56.2 0.99288256227758 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32583418 32583418 PRJNA797655_S_NODE_260659_length_154_cov_2.162162_g260054_i0 PRJNA797655 260659 154 2.162162 3.32972948 Planctomycetota bacterium 2026780 Bacteria Bacteria 40.8 0.0404   NR MCP4712170.1 2026780 g260054 i0 43.2 0.720779220779221 37 21 72.1 0 9 119 89 125 MCP4712170.1 DUF1080 domain-containing protein [Planctomycetota bacterium] diamond 111 40.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32645859 32645859 PRJNA797655_S_NODE_199300_length_179_cov_1.735294_g198695_i0 PRJNA797655 199300 179 1.735294 3.10617626 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 44.3 0.00452   NR MEN6452554.1 2691551 g198695 i0 50 0.569832402234637 34 16 57 1 9 110 250 282 MEN6452554.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Thermoguttaceae bacterium] diamond 102 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae 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);;