RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA492363" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA492363 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
25566999 25566999 PRJNA492363_S_NODE_81441_length_212_cov_1.523179_g80620_i0 PRJNA492363 81441 212 1.523179 3.22913948 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 73.2 1.58e-13   NR HTL29911.1 2876886 g80620 i0 55.6 2.49056603773585 54 24 76.4 0 30 191 158 211 HTL29911.1 acetolactate decarboxylase [Tepidisphaeraceae bacterium] diamond 528 73.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
25839603 25839603 PRJNA492363_S_NODE_9811_length_307_cov_1.715447_g8990_i0 PRJNA492363 9811 307 1.715447 5.26642229 Bacteria 2 Bacteria Bacteria 125 4.19e-32   NR WP_148597670.1 406548 g8990 i0 73.2 6.58631921824104 82 22 80.1 0 299 54 255 336 WP_148597670.1 PDDEXK nuclease domain-containing protein [Aquisphaera giovannonii] diamond 2022 125 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
25975331 25975331 PRJNA492363_S_NODE_78596_length_216_cov_2.051613_g77775_i0 PRJNA492363 78596 216 2.051613 4.43148408 Planctomycetales bacterium 12-6 2053591 Bacteria Bacteria 107 3.19e-26   NR OYW25093.1 1970541 g77775 i0 84.5 1.97222222222222 71 11 98.6 0 3 215 110 180 OYW25093.1 MAG: DDE transposase [Planctomycetales bacterium 12-60-4] diamond 426 107 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium 12-60-4
25975516 25975516 PRJNA492363_S_NODE_86188_length_209_cov_0.864865_g85367_i0 PRJNA492363 86188 209 0.864865 1.80756785 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 97.8 9.72e-22   NR MEO6435848.1 2876886 g85367 i0 69.6 1.7511961722488 69 21 99 0 207 1 1 69 MEO6435848.1 glycoside hydrolase family 95 protein [Tepidisphaeraceae bacterium] diamond 366 97.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
26033235 26033235 PRJNA492363_S_NODE_101076_length_201_cov_0.914286_g100255_i0 PRJNA492363 101076 201 0.914286 1.83771486 Pirellulales bacterium 2715253 Bacteria Bacteria 109 4.83e-26   NR MFO0898228.1 2715253 g100255 i0 85.5 0.925373134328358 62 9 92.5 0 186 1 132 193 MFO0898228.1 potassium-transporting ATPase subunit KdpA [Pirellulales bacterium] diamond 186 109 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
26110296 26110296 PRJNA492363_S_NODE_12957_length_274_cov_1.089202_g12136_i0 PRJNA492363 12957 274 1.089202 2.98441348 Planctomycetota bacterium 2026780 Bacteria Bacteria 70.5 8.35e-13   NR MBU0718477.1 2026780 g12136 i0 57.7 1.13868613138686 52 19 56.9 1 95 250 1 49 MBU0718477.1 toll/interleukin-1 receptor domain-containing protein [Planctomycetota bacterium] diamond 312 70.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26247758 26247758 PRJNA492363_S_NODE_8750_length_321_cov_1.338462_g7929_i0 PRJNA492363 8750 321 1.338462 4.29646302 Sedimentisphaerales bacterium 2813034 Bacteria Bacteria 168 5.04e-47   NR MDO8302292.1 2813034 g7929 i0 98.8 0.803738317757009 86 1 80.4 0 50 307 30 115 MDO8302292.1 TonB-dependent receptor [Sedimentisphaerales bacterium] diamond 258 168 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Sedimentisphaerales     Sedimentisphaerales bacterium
26381980 26381980 PRJNA492363_S_NODE_101127_length_201_cov_0.914286_g100306_i0 PRJNA492363 101127 201 0.914286 1.83771486 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 137 2.32e-37   NR MCA9073989.1 2026779 g100306 i0 84.8 1.97014925373134 66 10 98.5 0 3 200 274 339 MCA9073989.1 DUF3500 domain-containing protein [Planctomycetaceae bacterium] diamond 396 137 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
26383852 26383852 PRJNA492363_S_NODE_96919_length_203_cov_1.352113_g96098_i0 PRJNA492363 96919 203 1.352113 2.74478939 Gemmataceae bacterium 2052164 Bacteria Bacteria 115 2.78e-28   NR MFO0852105.1 2052164 g96098 i0 80.3 2.91133004926108 66 13 97.5 0 198 1 230 295 MFO0852105.1 leishmanolysin-related zinc metalloendopeptidase [Gemmataceae bacterium] diamond 591 115 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
26519863 26519863 PRJNA492363_S_NODE_89616_length_207_cov_1.315068_g88795_i0 PRJNA492363 89616 207 1.315068 2.72219076 Planctomycetota bacterium 2026780 Bacteria Bacteria 131 3.45e-34   NR HVS18267.1 2026780 g88795 i0 91.3 1 69 6 100 0 207 1 327 395 HVS18267.1 amidohydrolase family protein [Planctomycetota bacterium] diamond 207 131 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32941405 32941405 PRJNA492363_S_NODE_51673_length_232_cov_1.777778_g50852_i0 PRJNA492363 51673 232 1.777778 4.12444496 Pseudomonadati 3379134 Bacteria Bacteria 105 6.16e-25   NR GMV79984.1 2026780 g50852 i0 70.8 6.49137931034483 72 21 93.1 0 1 216 255 326 GMV79984.1 MAG: hypothetical protein AMXMBFR7_11680 [Planctomycetota bacterium] diamond 1506 105 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32952399 32952399 PRJNA492363_S_NODE_101002_length_201_cov_0.914286_g100181_i0 PRJNA492363 101002 201 0.914286 1.83771486 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 57 1.91e-7   NR MBA4189238.1 2026779 g100181 i0 42.4 1.97014925373134 66 38 98.5 0 2 199 164 229 MBA4189238.1 hypothetical protein [Planctomycetaceae bacterium] diamond 396 57 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32952598 32952598 PRJNA492363_S_NODE_85826_length_209_cov_1.959459_g85005_i0 PRJNA492363 85826 209 1.959459 4.09526931 Gemmataceae bacterium 2052164 Bacteria Bacteria 69.7 4.38e-12   NR HJT75738.1 2052164 g85005 i0 78.6 0.602870813397129 42 9 60.3 0 126 1 1 42 HJT75738.1 replication initiation protein [Gemmataceae bacterium] diamond 126 69.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32952629 32952629 PRJNA492363_S_NODE_89874_length_207_cov_0.876712_g89053_i0 PRJNA492363 89874 207 0.876712 1.81479384 Planctomycetota bacterium 2026780 Bacteria Bacteria 108 3.78e-27   NR MCY3000920.1 2026780 g89053 i0 73.9 3 69 18 100 0 1 207 135 203 MCY3000920.1 lipoyl(octanoyl) transferase LipB [Planctomycetota bacterium] diamond 621 108 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32952659 32952659 PRJNA492363_S_NODE_95338_length_204_cov_0.895105_g94517_i0 PRJNA492363 95338 204 0.895105 1.8260142 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 105 4.56e-26   NR MBI1383199.1 2026779 g94517 i0 70.1 1.97058823529412 67 20 98.5 0 4 204 42 108 MBI1383199.1 DUF1549 domain-containing protein [Planctomycetaceae bacterium] diamond 402 105 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32986784 32986784 PRJNA492363_S_NODE_96931_length_203_cov_1.352113_g96110_i0 PRJNA492363 96931 203 1.352113 2.74478939 Planctomycetales bacterium 2053591 Bacteria Bacteria 82.4 2.29e-16   NR MCA9261609.1 2053591 g96110 i0 56.1 1.69950738916256 66 29 97.5 0 2 199 181 246 MCA9261609.1 sulfatase-like hydrolase/transferase [Planctomycetales bacterium] diamond 345 82.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
33037841 33037841 PRJNA492363_S_NODE_87956_length_208_cov_1.095238_g87135_i0 PRJNA492363 87956 208 1.095238 2.27809504 Gemmataceae bacterium 2052164 Bacteria Bacteria 108 2.8e-27   NR HKI30795.1 2052164 g87135 i0 73.9 1.99038461538462 69 18 99.5 0 2 208 64 132 HKI30795.1 TIGR04283 family arsenosugar biosynthesis glycosyltransferase [Gemmataceae bacterium] diamond 414 108 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
33054890 33054890 PRJNA492363_S_NODE_89749_length_207_cov_0.876712_g88928_i0 PRJNA492363 89749 207 0.876712 1.81479384 Isosphaera sp. 41672 Bacteria Bacteria 72.4 2.73e-14   NR MBA4067670.1 41672 g88928 i0 54.4 1.97101449275362 68 31 98.6 0 205 2 8 75 MBA4067670.1 PIN domain nuclease [Isosphaera sp.] diamond 408 72.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Isosphaera Isosphaera sp.
33054896 33054896 PRJNA492363_S_NODE_91589_length_206_cov_0.882759_g90768_i0 PRJNA492363 91589 206 0.882759 1.81848354 Planctomycetota bacterium 2026780 Bacteria Bacteria 44.7 0.00482   NR MBL8857405.1 2026780 g90768 i0 41.2 0.990291262135922 68 38 96.1 2 199 2 584 651 MBL8857405.1 hypothetical protein [Planctomycetota bacterium] diamond 204 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33060795 33060795 PRJNA492363_S_NODE_95389_length_204_cov_0.895105_g94568_i0 PRJNA492363 95389 204 0.895105 1.8260142 Bacteria 2 Bacteria Bacteria 101 6.31e-25   NR MBL9118570.1 2026778 g94568 i0 80.6 9.85294117647059 67 13 98.5 0 203 3 109 175 MBL9118570.1 helix-turn-helix transcriptional regulator [Phycisphaerae bacterium] diamond 2010 102 0.990196078431373 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
33060796 33060796 PRJNA492363_S_NODE_96797_length_203_cov_1.704225_g95976_i0 PRJNA492363 96797 203 1.704225 3.45957675 Pseudomonadati 3379134 Bacteria Bacteria 105 3.8e-26   NR WP_105359176.1 124 g95976 i0 79.4 5.55665024630542 63 13 93.1 0 1 189 133 195 WP_105359176.1 SDR family oxidoreductase [Blastopirellula marina] diamond 1128 105 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Blastopirellula Blastopirellula marina
33106050 33106050 PRJNA492363_S_NODE_77878_length_217_cov_1.641026_g77057_i0 PRJNA492363 77878 217 1.641026 3.56102642 Pirellulales bacterium 2715253 Bacteria Bacteria 134 1.57e-34   NR MFO0896309.1 2715253 g77057 i0 85.9 0.981566820276498 71 10 98.2 0 215 3 268 338 MFO0896309.1 excinuclease ABC subunit UvrA [Pirellulales bacterium] diamond 213 134 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
33106064 33106064 PRJNA492363_S_NODE_79934_length_214_cov_1.254902_g79113_i0 PRJNA492363 79934 214 1.254902 2.68549028 Gemmataceae bacterium 2052164 Bacteria Bacteria 62 4.17e-9   NR HKB02029.1 2052164 g79113 i0 46.6 1.02336448598131 73 37 99.5 1 2 214 255 327 HKB02029.1 Ig-like domain-containing protein [Gemmataceae bacterium] diamond 219 62 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
33106129 33106129 PRJNA492363_S_NODE_95294_length_204_cov_0.895105_g94473_i0 PRJNA492363 95294 204 0.895105 1.8260142 Phycisphaerales bacterium 2052180 Bacteria Bacteria 77 1.08e-14   NR MFN7021004.1 2052180 g94473 i0 57.4 1 68 29 100 0 204 1 197 264 MFN7021004.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium] diamond 204 77 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
33129175 33129175 PRJNA492363_S_NODE_86295_length_209_cov_0.864865_g85474_i0 PRJNA492363 86295 209 0.864865 1.80756785 Bacteria 2 Bacteria Bacteria 63.2 1.48e-9   NR MFO0911175.1 2691532 g85474 i0 53.6 2.97129186602871 69 32 99 0 207 1 383 451 MFO0911175.1 DUF3320 domain-containing protein [Isosphaeraceae bacterium] diamond 621 63.5 0.995275590551181 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
33140065 33140065 PRJNA492363_S_NODE_49119_length_233_cov_1.767442_g48298_i0 PRJNA492363 49119 233 1.767442 4.11813986 Planctomycetota bacterium 2026780 Bacteria Bacteria 125 2.74e-31   NR MEY4942006.1 2026780 g48298 i0 77 0.952789699570815 74 17 95.3 0 1 222 143 216 MEY4942006.1 hypothetical protein [Planctomycetota bacterium] diamond 222 125 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33140152 33140152 PRJNA492363_S_NODE_88135_length_208_cov_0.870748_g87314_i0 PRJNA492363 88135 208 0.870748 1.81115584 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 55.1 1.03e-6   NR MCP4097545.1 2026779 g87314 i0 84.4 0.461538461538462 32 5 46.2 0 11 106 1 32 MCP4097545.1 hypothetical protein [Planctomycetaceae bacterium] diamond 96 55.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
33174448 33174448 PRJNA492363_S_NODE_89656_length_207_cov_1.315068_g88835_i0 PRJNA492363 89656 207 1.315068 2.72219076 Anatilimnocola aggregata 2528021 Bacteria Bacteria 114 7.61e-28   NR WP_202921580.1 2528021 g88835 i0 80 0.942028985507246 65 13 94.2 0 2 196 5 69 WP_202921580.1 ATP-binding protein [Anatilimnocola aggregata] diamond 195 114 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Anatilimnocola Anatilimnocola aggregata

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);;