RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA395690" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 29 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA395690 · 29 ✖

analysis 1

  • diamond · 29 ✖
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
2962428 2962428 PRJNA395690_P_NODE_29223_length_166_cov_1.717949_g29071_i0 PRJNA395690 29223 166 1.717949 2.85179534 Phycisphaerales bacterium 2052180 Bacteria Bacteria 110 6.35e-28   NR MBY0113874.1 2052180 g29071 i0 100 2.98192771084337 55 0 99.4 0 1 165 124 178 MBY0113874.1 alpha/beta hydrolase [Phycisphaerales bacterium] diamond 495 110 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
5515281 5515281 PRJNA395690_P_NODE_19045_length_189_cov_1.185714_g18893_i0 PRJNA395690 19045 189 1.185714 2.24099946 Planctomycetota bacterium 2026780 Bacteria Bacteria 85.9 2.64e-18   NR MBA3847331.1 2026780 g18893 i0 71.2 0.936507936507937 59 17 93.7 0 2 178 16 74 MBA3847331.1 formyltetrahydrofolate deformylase [Planctomycetota bacterium] diamond 177 85.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
8065087 8065087 PRJNA395690_P_NODE_34927_length_162_cov_0.902655_g34775_i0 PRJNA395690 34927 162 0.902655 1.4623011 Phycisphaerales bacterium 2052180 Bacteria Bacteria 75.5 3.11e-14   NR MCC6675878.1 2052180 g34775 i0 74.1 1 54 13 98.1 1 2 160 64 117 MCC6675878.1 hypothetical protein [Phycisphaerales bacterium] diamond 162 75.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
23363798 23363798 PRJNA395690_P_NODE_29799_length_166_cov_0.871795_g29647_i0 PRJNA395690 29799 166 0.871795 1.4471797 Phycisphaerales bacterium 2052180 Bacteria Bacteria 115 1.9000000000000003e-28   NR MBY0113978.1 2052180 g29647 i0 98.1 0.975903614457831 54 1 97.6 0 164 3 243 296 MBY0113978.1 proline--tRNA ligase [Phycisphaerales bacterium] diamond 162 115 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
26726788 26726788 PRJNA395690_P_NODE_5161_length_350_cov_1.634551_g5012_i0 PRJNA395690 5161 350 1.634551 5.7209285 Planctomycetota bacterium 2026780 Bacteria Bacteria 50.4 2.53e-4   NR RMG19022.1 2026780 g5012 i0 37.5 0.822857142857143 96 51 77.1 2 283 14 99 191 RMG19022.1 MAG: hypothetical protein D6731_00715 [Planctomycetota bacterium] diamond 288 50.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26885742 26885742 PRJNA395690_P_NODE_781_length_877_cov_1.998792_g670_i0 PRJNA395690 781 877 1.998792 17.52940584 Planctomycetota bacterium 2026780 Bacteria Bacteria 84.7 2.96e-14   NR MEL6430850.1 2026780 g670 i0 32 0.523375142531357 153 103 52.3 1 733 275 338 489 MEL6430850.1 diguanylate cyclase [Planctomycetota bacterium] diamond 459 84.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27138123 27138123 PRJNA395690_P_NODE_31542_length_164_cov_3.173913_g31390_i0 PRJNA395690 31542 164 3.173913 5.20521732 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 48.1 1.02e-4   NR MCA9081007.1 2026779 g31390 i0 48.1 0.98780487804878 54 26 97 2 4 162 72 124 MCA9081007.1 hypothetical protein [Planctomycetaceae bacterium] diamond 162 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27486163 27486163 PRJNA395690_P_NODE_19543_length_188_cov_1.071942_g19391_i0 PRJNA395690 19543 188 1.071942 2.01525096 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 42.7 0.00299   NR HWE94227.1 2876886 g19391 i0 87 0.765957446808511 23 3 36.7 0 115 183 52 74 HWE94227.1 hypothetical protein [Tepidisphaeraceae bacterium] diamond 144 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
27644245 27644245 PRJNA395690_P_NODE_25084_length_174_cov_2.104000_g24932_i0 PRJNA395690 25084 174 2.104 3.66096 Pirellulales bacterium 2715253 Bacteria Bacteria 104 8.3e-25   NR MFO0791622.1 2715253 g24932 i0 87.5 0.96551724137931 56 7 96.6 0 3 170 282 337 MFO0791622.1 aldose epimerase family protein [Pirellulales bacterium] diamond 168 104 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
27787251 27787251 PRJNA395690_P_NODE_13204_length_224_cov_1.371429_g13052_i0 PRJNA395690 13204 224 1.371429 3.07200096 Bacteria 2 Bacteria Bacteria 79 6.25e-16   NR NUO15764.1 2026779 g13052 i0 52.9 1.82142857142857 68 30 91.1 1 223 20 47 112 NUO15764.1 metallophosphoesterase [Planctomycetaceae bacterium] diamond 408 79 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27928211 27928211 PRJNA395690_P_NODE_33605_length_163_cov_0.894737_g33453_i0 PRJNA395690 33605 163 0.894737 1.45842131 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 45.1 0.00197   NR HUE17142.1 2026779 g33453 i0 45.8 4.03067484662577 48 26 88.3 0 162 19 184 231 HUE17142.1 2OG-Fe(II) oxygenase [Planctomycetaceae bacterium] diamond 657 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28180557 28180557 PRJNA395690_P_NODE_26806_length_170_cov_1.702479_g26654_i0 PRJNA395690 26806 170 1.702479 2.8942143 Planctomyces sp. SH-PL14 1632864 Bacteria Bacteria 85.1 1.61e-17   NR WP_075093792.1 1632864 g26654 i0 76.4 0.970588235294118 55 13 97.1 0 2 166 415 469 WP_075093792.1 serine/threonine-protein kinase [Planctomyces sp. SH-PL14] diamond 165 85.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
28307094 28307094 PRJNA395690_P_NODE_29786_length_166_cov_0.871795_g29634_i0 PRJNA395690 29786 166 0.871795 1.4471797 Planctomycetota bacterium 2026780 Bacteria Bacteria 60.8 5.42e-9   NR MBU6386086.1 2026780 g29634 i0 53.8 0.939759036144578 52 23 92.2 1 1 153 1064 1115 MBU6386086.1 tandem-95 repeat protein [Planctomycetota bacterium] diamond 156 60.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28639778 28639778 PRJNA395690_P_NODE_8527_length_277_cov_1.342105_g8375_i0 PRJNA395690 8527 277 1.342105 3.71763085 Pseudomonadati 3379134 Bacteria Bacteria 87 1.53e-17   NR WP_146524602.1 2528016 g8375 i0 48.9 3.99638989169675 94 42 95.3 2 4 267 30 123 WP_146524602.1 Ig-like domain-containing protein [Novipirellula artificiosorum] diamond 1107 87.4 0.995423340961098 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Novipirellula Novipirellula artificiosorum
28686203 28686203 PRJNA395690_P_NODE_23547_length_178_cov_1.558140_g23395_i0 PRJNA395690 23547 178 1.55814 2.7734892 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 85.1 1.85e-17   NR MCE5187467.1 2026779 g23395 i0 70.7 0.97752808988764 58 17 97.8 0 175 2 410 467 MCE5187467.1 hypothetical protein [Planctomycetaceae bacterium] diamond 174 85.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28686210 28686210 PRJNA395690_P_NODE_30207_length_166_cov_0.871795_g30055_i0 PRJNA395690 30207 166 0.871795 1.4471797 Planctomycetota bacterium 2026780 Bacteria Bacteria 80.5 8.44e-17   NR MEW6249877.1 2026780 g30055 i0 76.4 0.993975903614458 55 13 99.4 0 1 165 42 96 MEW6249877.1 HEPN domain-containing protein [Planctomycetota bacterium] diamond 165 80.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29113276 29113276 PRJNA395690_P_NODE_25728_length_173_cov_1.266129_g25576_i0 PRJNA395690 25728 173 1.266129 2.19040317 Bacteria 2 Bacteria Bacteria 96.7 1.78e-22   NR MBL8873533.1 2026779 g25576 i0 96.2 1.80346820809249 52 2 90.2 0 2 157 115 166 MBL8873533.1 HlyD family efflux transporter periplasmic adaptor subunit [Planctomycetaceae bacterium] diamond 312 96.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30218409 30218409 PRJNA395690_P_NODE_29512_length_166_cov_0.871795_g29360_i0 PRJNA395690 29512 166 0.871795 1.4471797 Pseudomonadati 3379134 Bacteria Bacteria 117 3.63e-29   NR MDZ4772913.1 2026780 g29360 i0 98.1 72.2168674698795 54 1 97.6 0 3 164 249 302 MDZ4772913.1 M1 family metallopeptidase [Planctomycetota bacterium] diamond 11988 118 0.991525423728814 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30328648 30328648 PRJNA395690_P_NODE_15732_length_205_cov_1.307692_g15580_i0 PRJNA395690 15732 205 1.307692 2.6807686 Planctomycetota bacterium 2026780 Bacteria Bacteria 62.4 2.39e-9   NR MCA8974671.1 2026780 g15580 i0 56.8 0.64390243902439 44 19 64.4 0 161 30 18 61 MCA8974671.1 hypothetical protein [Planctomycetota bacterium] diamond 132 62.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30770610 30770610 PRJNA395690_P_NODE_25354_length_174_cov_1.224000_g25202_i0 PRJNA395690 25354 174 1.224 2.12976 Phycisphaerales bacterium 2052180 Bacteria Bacteria 70.5 1.4e-12   NR MFM9996566.1 2052180 g25202 i0 64.2 0.913793103448276 53 19 91.4 0 173 15 179 231 MFM9996566.1 alpha/beta fold hydrolase [Phycisphaerales bacterium] diamond 159 70.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31117761 31117761 PRJNA395690_P_NODE_3315_length_431_cov_2.026178_g3166_i0 PRJNA395690 3315 431 2.026178 8.73282718 Planctomycetia bacterium 2052181 Bacteria Bacteria 52.4 1.13e-4   NR MDZ4780285.1 2052181 g3166 i0 34.1 1.58700696055684 138 77 89.1 4 4 387 77 210 MDZ4780285.1 tetratricopeptide repeat protein [Planctomycetia bacterium] diamond 684 52.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
31750349 31750349 PRJNA395690_P_NODE_21017_length_184_cov_1.488889_g20865_i0 PRJNA395690 21017 184 1.488889 2.73955576 Planctomycetia bacterium 2052181 Bacteria Bacteria 41.6 0.0425   NR MCX7419228.1 2052181 g20865 i0 52.6 0.619565217391304 38 17 62 1 9 122 184 220 MCX7419228.1 trigger factor [Planctomycetia bacterium] diamond 114 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
32066770 32066770 PRJNA395690_P_NODE_30118_length_166_cov_0.871795_g29966_i0 PRJNA395690 30118 166 0.871795 1.4471797 Pirellulaceae bacterium 2699754 Bacteria Bacteria 108 1.19e-25   NR MDX1927623.1 2699754 g29966 i0 89.1 1.98795180722892 55 6 99.4 0 2 166 30 84 MDX1927623.1 pyruvate, phosphate dikinase [Pirellulaceae bacterium] diamond 330 108 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
32242157 32242157 PRJNA395690_P_NODE_17958_length_192_cov_1.069930_g17806_i0 PRJNA395690 17958 192 1.06993 2.0542656 Pseudomonadati 3379134 Bacteria Bacteria 52 9.87e-6   NR MEI6235788.1 2026780 g17806 i0 45.2 1.890625 62 23 96.9 1 2 187 136 186 MEI6235788.1 WGR domain-containing protein [Planctomycetota bacterium] diamond 363 52.4 0.99236641221374 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32288714 32288714 PRJNA395690_P_NODE_23999_length_177_cov_1.437500_g23847_i0 PRJNA395690 23999 177 1.4375 2.544375 Phycisphaerales bacterium 2052180 Bacteria Bacteria 123 6.979999999999999e-31   NR MCC6675961.1 2052180 g23847 i0 94.8 0.983050847457627 58 3 98.3 0 176 3 621 678 MCC6675961.1 polyphosphate kinase 1 [Phycisphaerales bacterium] diamond 174 123 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32383278 32383278 PRJNA395690_P_NODE_36159_length_161_cov_0.910714_g36007_i0 PRJNA395690 36159 161 0.910714 1.46624954 Phycisphaerales bacterium 2052180 Bacteria Bacteria 85.9 6.37e-19   NR HEX8877128.1 2052180 g36007 i0 95.1 0.763975155279503 41 2 76.4 0 38 160 1 41 HEX8877128.1 isoprenoid biosynthesis glyoxalase ElbB [Phycisphaerales bacterium] diamond 123 85.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32415037 32415037 PRJNA395690_P_NODE_1879_length_570_cov_1.783109_g1732_i0 PRJNA395690 1879 570 1.783109 10.1637213 Phycisphaerales bacterium 2052180 Bacteria Bacteria 234 3.13e-70   NR MFN0133905.1 2052180 g1732 i0 63.1 0.984210526315789 187 69 98.4 0 568 8 144 330 MFN0133905.1 alpha/beta fold hydrolase [Phycisphaerales bacterium] diamond 561 234 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32793253 32793253 PRJNA395690_P_NODE_4860_length_361_cov_1.307692_g4711_i0 PRJNA395690 4860 361 1.307692 4.72076812 Phycisphaerales bacterium 2052180 Bacteria Bacteria 191 2.5099999999999996e-56   NR MBY0113429.1 2052180 g4711 i0 97.2 0.880886426592798 106 3 88.1 0 42 359 1 106 MBY0113429.1 OprO/OprP family phosphate-selective porin [Phycisphaerales bacterium] diamond 318 191 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32825011 32825011 PRJNA395690_P_NODE_30480_length_165_cov_1.732759_g30328_i0 PRJNA395690 30480 165 1.732759 2.85905235 Phycisphaerales bacterium 2052180 Bacteria Bacteria 51.6 9.84e-6   NR MEN6336784.1 2052180 g30328 i0 51.8 1.01818181818182 56 23 94.5 1 162 7 356 411 MEN6336784.1 hypothetical protein [Phycisphaerales bacterium] diamond 168 51.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales 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);;