RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA546018 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
511095 511095 PRJNA546018_S_NODE_42381_length_236_cov_1.320000_g42056_i0 PRJNA546018 42381 236 1.32 3.1152 Pirellulaceae bacterium 2699754 Bacteria Bacteria 84.3 7.76e-17   NR HEY2415109.1 2699754 g42056 i0 62.9 0.788135593220339 62 23 78.8 0 234 49 210 271 HEY2415109.1 secretin N-terminal domain-containing protein [Pirellulaceae bacterium] diamond 186 84.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
1786479 1786479 PRJNA546018_S_NODE_36302_length_257_cov_2.234694_g35977_i0 PRJNA546018 36302 257 2.234694 5.74316358 Gemmata sp. 1914242 Bacteria Bacteria 152 2.19e-42   NR HEY1190090.1 1914242 g35977 i0 87.7 1.89105058365759 81 10 94.6 0 255 13 162 242 HEY1190090.1 hypothetical protein [Gemmata sp.] diamond 486 152 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
3061850 3061850 PRJNA546018_S_NODE_32823_length_272_cov_2.417062_g32498_i0 PRJNA546018 32823 272 2.417062 6.57440864 Frigoriglobus tundricola 2774151 Bacteria Bacteria 130 1.6299999999999999e-34   NR WP_171471542.1 2774151 g32498 i0 80.5 3.39705882352941 77 15 84.9 0 21 251 1 77 WP_171471542.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Frigoriglobus tundricola] diamond 924 130 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Frigoriglobus Frigoriglobus tundricola
4338104 4338104 PRJNA546018_S_NODE_42864_length_234_cov_2.797688_g42539_i0 PRJNA546018 42864 234 2.797688 6.54658992 Phycisphaerales bacterium 2052180 Bacteria Bacteria 129 1.37e-36   NR HLP85523.1 2052180 g42539 i0 98.5 0.858974358974359 67 1 85.9 0 224 24 13 79 HLP85523.1 zinc ribbon domain-containing protein YjdM [Phycisphaerales bacterium] diamond 201 129 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
15813413 15813413 PRJNA546018_S_NODE_13713_length_452_cov_4.347826_g13389_i0 PRJNA546018 13713 452 4.347826 19.65217352 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 205 9.81e-63   NR HEX8199212.1 2691532 g13389 i0 71.2 2.78761061946903 139 37 90.3 1 430 23 129 267 HEX8199212.1 methionyl-tRNA formyltransferase [Isosphaeraceae bacterium] diamond 1260 205 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
19637441 19637441 PRJNA546018_S_NODE_51176_length_211_cov_2.566667_g50851_i0 PRJNA546018 51176 211 2.566667 5.41566737 Planctomycetia 203683 Bacteria Bacteria 111 2.84e-29   NR MBA4067861.1 41672 g50851 i0 88.7 5.28909952606635 62 7 88.2 0 209 24 32 93 MBA4067861.1 Swarming motility protein YbiA [Isosphaera sp.] diamond 1116 112 0.991071428571429 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Isosphaera Isosphaera sp.
20913127 20913127 PRJNA546018_S_NODE_40697_length_242_cov_1.077348_g40372_i0 PRJNA546018 40697 242 1.077348 2.60718216 Gemmata sp. 1914242 Bacteria Bacteria 110 5.04e-28   NR MCS6867067.1 1914242 g40372 i0 58.2 0.979338842975207 79 33 97.9 0 239 3 71 149 MCS6867067.1 glycosyltransferase [Gemmata sp.] diamond 237 110 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
22187813 22187813 PRJNA546018_S_NODE_35078_length_262_cov_1.940299_g34753_i0 PRJNA546018 35078 262 1.940299 5.08358338 Bacteria 2 Bacteria Bacteria 125 5.17e-31   NR HKA06321.1 2052164 g34753 i0 68.8 1.83206106870229 80 25 91.6 0 262 23 236 315 HKA06321.1 alkaline phosphatase family protein [Gemmataceae bacterium] diamond 480 126 0.992063492063492 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
26761297 26761297 PRJNA546018_S_NODE_34201_length_266_cov_1.243902_g33876_i0 PRJNA546018 34201 266 1.243902 3.30877932 Schlesneria sp. 2762018 Bacteria Bacteria 127 9.85e-32   NR MEI8018256.1 2762018 g33876 i0 71.3 0.981203007518797 87 25 98.1 0 4 264 508 594 MEI8018256.1 hypothetical protein [Schlesneria sp.] diamond 261 127 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Schlesneria Schlesneria sp.
26793137 26793137 PRJNA546018_S_NODE_4381_length_880_cov_3.545788_g4155_i0 PRJNA546018 4381 880 3.545788 31.2029344 Planctomyces sp. SH-PL14 1632864 Bacteria Bacteria 275 2.07e-89   NR WP_075091837.1 1632864 g4155 i0 71.9 1.26136363636364 185 50 63.1 1 4 558 41 223 WP_075091837.1 UbiX family flavin prenyltransferase [Planctomyces sp. SH-PL14] diamond 1110 275 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
27204128 27204128 PRJNA546018_S_NODE_13402_length_459_cov_4.703518_g13078_i0 PRJNA546018 13402 459 4.703518 21.58914762 Gemmata algarum 2975278 Bacteria Bacteria 194 5.259999999999998e-54   NR WP_320689527.1 2975278 g13078 i0 68.8 0.92156862745098 141 43 91.5 1 16 435 891 1031 WP_320689527.1 hypothetical protein [Gemmata algarum] diamond 423 194 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata algarum
27282501 27282501 PRJNA546018_S_NODE_35343_length_261_cov_1.610000_g35018_i0 PRJNA546018 35343 261 1.61 4.2021 Tautonia 2680020 Bacteria Bacteria 93.6 6.06e-20   NR MBX6312820.1 2691532 g35018 i0 79.6 5.58620689655172 54 11 62.1 0 20 181 489 542 MBX6312820.1 excinuclease ABC subunit UvrA [Isosphaeraceae bacterium] diamond 1458 93.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
27330898 27330898 PRJNA546018_S_NODE_30863_length_282_cov_2.493213_g30538_i0 PRJNA546018 30863 282 2.493213 7.03086066 Gemmata sp. 1914242 Bacteria Bacteria 108 2.21e-25   NR HEV3436528.1 1914242 g30538 i0 58.8 1.03191489361702 97 33 96.8 3 2 274 42 137 HEV3436528.1 GIY-YIG nuclease family protein [Gemmata sp.] diamond 291 108 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
27330899 27330899 PRJNA546018_S_NODE_35763_length_259_cov_2.954545_g35438_i0 PRJNA546018 35763 259 2.954545 7.65227155 Planctomyces sp. SH-PL14 1632864 Bacteria Bacteria 84 1.43e-17   NR WP_075091837.1 1632864 g35438 i0 88 0.579150579150579 50 6 57.9 0 151 2 1 50 WP_075091837.1 UbiX family flavin prenyltransferase [Planctomyces sp. SH-PL14] diamond 150 84 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
28877856 28877856 PRJNA546018_S_NODE_52628_length_209_cov_1.554054_g52303_i0 PRJNA546018 52628 209 1.554054 3.24797286 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.1 0.0175   NR MEY2746126.1 2026780 g52303 i0 35.9 0.91866028708134 64 37 91.9 1 8 199 261 320 MEY2746126.1 hypothetical protein [Planctomycetota bacterium] diamond 192 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29603824 29603824 PRJNA546018_S_NODE_28410_length_296_cov_2.153191_g28085_i0 PRJNA546018 28410 296 2.153191 6.37344536 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 117 3.04e-28   NR HEX5472861.1 2691534 g28085 i0 66 0.952702702702703 94 30 95.3 2 7 288 44 135 HEX5472861.1 PQQ-binding-like beta-propeller repeat protein [Lacipirellulaceae bacterium] diamond 282 117 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
29650144 29650144 PRJNA546018_S_NODE_44850_length_228_cov_3.197605_g44525_i0 PRJNA546018 44850 228 3.197605 7.2905394 Planctomycetia 203683 Bacteria Bacteria 122 1.7800000000000002e-33   NR MBA4064522.1 41672 g44525 i0 85.7 1.84210526315789 70 10 92.1 0 1 210 94 163 MBA4064522.1 hypothetical protein [Isosphaera sp.] diamond 420 123 0.991869918699187 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Isosphaera Isosphaera sp.
29888508 29888508 PRJNA546018_S_NODE_27571_length_301_cov_2.979167_g27246_i0 PRJNA546018 27571 301 2.979167 8.96729267 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 116 2.4899999999999996e-29   NR HEX8202932.1 2691532 g27246 i0 57.7 2.90033222591362 97 41 96.7 0 1 291 151 247 HEX8202932.1 alpha/beta hydrolase [Isosphaeraceae bacterium] diamond 873 116 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
29951560 29951560 PRJNA546018_S_NODE_39751_length_244_cov_1.852459_g39426_i0 PRJNA546018 39751 244 1.852459 4.51999996 Urbifossiella limnaea 2528023 Bacteria Bacteria 119 1.2699999999999998e-31   NR WP_145238002.1 2528023 g39426 i0 78.4 1.81967213114754 74 16 91 0 244 23 71 144 WP_145238002.1 Uma2 family endonuclease [Urbifossiella limnaea] diamond 444 119 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
30267808 30267808 PRJNA546018_S_NODE_16832_length_401_cov_2.700000_g16507_i0 PRJNA546018 16832 401 2.7 10.827 Planctomycetota bacterium 2026780 Bacteria Bacteria 174 1.75e-48   NR MBN9119699.1 2026780 g16507 i0 77.3 1.75810473815461 119 27 89 0 380 24 386 504 MBN9119699.1 DUF1592 domain-containing protein [Planctomycetota bacterium] diamond 705 174 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30804618 30804618 PRJNA546018_S_NODE_55094_length_205_cov_3.076389_g54769_i0 PRJNA546018 55094 205 3.076389 6.30659745 Planctomycetota bacterium 2026780 Bacteria Bacteria 91.3 2.21e-20   NR HAT09408.1 2026780 g54769 i0 83.1 0.863414634146341 59 10 86.3 0 7 183 148 206 HAT09408.1 hypothetical protein [Planctomycetota bacterium] diamond 177 91.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31214920 31214920 PRJNA546018_S_NODE_17435_length_393_cov_2.334337_g17110_i0 PRJNA546018 17435 393 2.334337 9.17394441 Planctomycetota bacterium 2026780 Bacteria Bacteria 203 7.47e-60   NR MBN9122206.1 2026780 g17110 i0 79.4 1.90076335877863 126 26 96.2 0 391 14 171 296 MBN9122206.1 hypothetical protein [Planctomycetota bacterium] diamond 747 203 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31341891 31341891 PRJNA546018_S_NODE_20976_length_352_cov_3.003436_g20651_i0 PRJNA546018 20976 352 3.003436 10.57209472 Gemmata sp. 1914242 Bacteria Bacteria 48.1 0.00176   NR HEY1190028.1 1914242 g20651 i0 48.1 0.673295454545455 79 39 67.3 2 324 88 135 211 HEY1190028.1 SdrD B-like domain-containing protein [Gemmata sp.] diamond 237 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
31341896 31341896 PRJNA546018_S_NODE_3236_length_1037_cov_8.305328_g3044_i0 PRJNA546018 3236 1037 8.305328 86.12625136 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 214 5.37e-66   NR HYO24468.1 2691534 g3044 i0 80.3 0.396335583413693 137 27 39.6 0 306 716 1 137 HYO24468.1 flagellar export chaperone FlgN [Lacipirellulaceae bacterium] diamond 411 214 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
31563551 31563551 PRJNA546018_S_NODE_44456_length_229_cov_3.869048_g44131_i0 PRJNA546018 44456 229 3.869048 8.86011992 Gemmataceae bacterium 2052164 Bacteria Bacteria 62.4 3.06e-9   NR MCI0380418.1 2052164 g44131 i0 50 0.707423580786026 54 27 70.7 0 175 14 79 132 MCI0380418.1 DUF1559 domain-containing protein [Gemmataceae bacterium] diamond 162 62.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31626483 31626483 PRJNA546018_S_NODE_57316_length_202_cov_1.567376_g56991_i0 PRJNA546018 57316 202 1.567376 3.16609952 Gemmata palustris 2822762 Bacteria Bacteria 94 2.01e-20   NR WP_210654049.1 2822762 g56991 i0 74.6 1.76732673267327 59 15 87.6 0 201 25 325 383 WP_210654049.1 sigma-70 family RNA polymerase sigma factor [Gemmata palustris] diamond 357 94 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata palustris
31816273 31816273 PRJNA546018_S_NODE_6017_length_738_cov_6.097489_g5748_i0 PRJNA546018 6017 738 6.097489 44.99946882 Gemmata sp. SH-PL17 1630693 Bacteria Bacteria 279 9.4e-89   NR WP_162271659.1 1630693 g5748 i0 66.7 1.7520325203252 216 71 87.4 1 715 71 224 439 WP_162271659.1 efflux RND transporter periplasmic adaptor subunit [Gemmata sp. SH-PL17] diamond 1293 279 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp. SH-PL17
31974489 31974489 PRJNA546018_S_NODE_21278_length_349_cov_5.871528_g20953_i0 PRJNA546018 21278 349 5.871528 20.49163272 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 105 1.17e-25   NR HEX3451122.1 2691532 g20953 i0 63.9 0.713467048710602 83 30 71.3 0 69 317 21 103 HEX3451122.1 RNA polymerase sigma factor [Isosphaeraceae bacterium] diamond 249 105 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
32132847 32132847 PRJNA546018_S_NODE_11618_length_500_cov_5.911162_g11294_i0 PRJNA546018 11618 500 5.911162 29.55581 Isosphaera sp. 41672 Bacteria Bacteria 171 9.870000000000001e-51   NR MBA4062546.1 41672 g11294 i0 70.3 1.536 128 37 76.2 1 33 413 81 208 MBA4062546.1 hypothetical protein [Isosphaera sp.] diamond 768 171 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Isosphaera Isosphaera sp.
32291344 32291344 PRJNA546018_S_NODE_24459_length_323_cov_1.824427_g24134_i0 PRJNA546018 24459 323 1.824427 5.89289921 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 156 6.07e-45   NR HEX8202932.1 2691532 g24134 i0 71.4 1.95046439628483 105 30 97.5 0 315 1 36 140 HEX8202932.1 alpha/beta hydrolase [Isosphaeraceae bacterium] diamond 630 156 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
32449359 32449359 PRJNA546018_S_NODE_12939_length_469_cov_3.004902_g12615_i0 PRJNA546018 12939 469 3.004902 14.09299038 Gemmataceae bacterium 2052164 Bacteria Bacteria 56.2 6.9e-6   NR MFO0841972.1 2052164 g12615 i0 77.1 0.223880597014925 35 8 22.4 0 447 343 198 232 MFO0841972.1 hypothetical protein [Gemmataceae bacterium] diamond 105 56.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32701460 32701460 PRJNA546018_S_NODE_17020_length_398_cov_10.252226_g16695_i0 PRJNA546018 17020 398 10.252226 40.80385948 Planctomycetota bacterium 2026780 Bacteria Bacteria 146 9.22e-38   NR MBN8524642.1 2026780 g16695 i0 57.6 0.889447236180904 118 50 88.9 0 21 374 943 1060 MBN8524642.1 DUF4388 domain-containing protein [Planctomycetota bacterium] diamond 354 146 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);;