RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • PVC group · 19 ✖

bioproject 1

  • PRJNA222400 · 19 ✖
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
6744808 6744808 PRJNA222400_P_NODE_1926_length_364_cov_2.400000_g1893_i0 PRJNA222400 1926 364 2.4 8.736 Candidatus Uabimicrobium helgolandensis 3095367 Bacteria Bacteria 52.8 0.035   NTclustered gi|2793194503|gb|CP165719.1| 3095367 g1893 i0 100 0.0769230769230769 28 0 8 0 41 68 1374378 1374351 Candidatus Uabimicrobium helgolandensis strain HlEnr_7 chromosome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Uabimicrobiia Candidatus Uabimicrobiales Candidatus Uabimicrobiaceae Candidatus Uabimicrobium Candidatus Uabimicrobium helgolandensis
14396266 14396266 PRJNA222400_P_NODE_5152_length_197_cov_1.054054_g5119_i0 PRJNA222400 5152 197 1.054054 2.07648638 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 137 4.58e-28   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g5119 i0 91.919 33.7258883248731 99 7 50 1 99 197 1867664 1867761 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 6644 137 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
18218907 18218907 PRJNA222400_P_NODE_7855_length_167_cov_0.881356_g7822_i0 PRJNA222400 7855 167 0.881356 1.47186452 Rubripirellula lacrimiformis 1930273 Bacteria Bacteria 60.2 8.37e-5   NTclustered gi|1712455066|gb|CP036525.1| 1930273 g7822 i0 92.683 0.81437125748503 41 3 25 0 15 55 4362915 4362955 Rubripirellula lacrimiformis strain K22.7 chromosome, complete genome blastn 136 60.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula lacrimiformis
27737689 27737689 PRJNA222400_P_NODE_2104_length_345_cov_1.179054_g2071_i0 PRJNA222400 2104 345 1.179054 4.0677363 Rubripirellula sp. 1973111 Bacteria Bacteria 45.4 0.014   NR MDE0865248.1 1973111 g2071 i0 35.4 0.834782608695652 96 54 76.5 1 63 326 1940 2035 MDE0865248.1 Ig-like domain-containing protein [Rubripirellula sp.] diamond 288 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula sp.
28007895 28007895 PRJNA222400_P_NODE_8225_length_166_cov_0.888889_g8192_i0 PRJNA222400 8225 166 0.888889 1.47555574 root 1 Root_unresolved Root_unresolved 53.5 7.44e-7   NR WP_154931914.1 122 g8192 i0 50 5.53012048192771 52 25 92.2 1 12 164 58 109 WP_154931914.1 ankyrin repeat domain-containing protein [Gimesia maris] diamond 918 53.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia maris
28021694 28021694 PRJNA222400_P_NODE_7165_length_169_cov_0.866667_g7132_i0 PRJNA222400 7165 169 0.866667 1.46466723 Planctomycetota bacterium 2026780 Bacteria Bacteria 82 1.97e-16   NR MBI2560779.1 2026780 g7132 i0 69.2 2.87573964497041 52 16 92.3 0 156 1 623 674 MBI2560779.1 glycosyltransferase [Planctomycetota bacterium] diamond 486 82 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28495304 28495304 PRJNA222400_P_NODE_9347_length_162_cov_0.920354_g9314_i0 PRJNA222400 9347 162 0.920354 1.49097348 Pirellulaceae bacterium 2699754 Bacteria Bacteria 103 1.9099999999999994e-24   NR MCC7335815.1 2699754 g9314 i0 94.3 0.981481481481482 53 3 98.1 0 161 3 354 406 MCC7335815.1 DUF1501 domain-containing protein [Pirellulaceae bacterium] diamond 159 103 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
28670903 28670903 PRJNA222400_P_NODE_7567_length_168_cov_0.873950_g7534_i0 PRJNA222400 7567 168 0.87395 1.468236 Bacteria 2 Bacteria Bacteria 56.2 2.25e-7   NR MEQ9409136.1 1936112 g7534 i0 47.3 1.91071428571429 55 29 98.2 0 167 3 116 170 MEQ9409136.1 hypothetical protein [Fuerstiella sp.] diamond 321 56.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella sp.
28796873 28796873 PRJNA222400_P_NODE_2947_length_276_cov_0.894273_g2914_i0 PRJNA222400 2947 276 0.894273 2.46819348 Bacteria 2 Bacteria Bacteria 94 5.21e-20   NR OHB45662.1 1801952 g2914 i0 53.3 4.71739130434783 90 39 97.8 1 2 271 329 415 OHB45662.1 MAG: arginine--tRNA ligase [Planctomycetes bacterium GWC2_45_44] diamond 1302 94 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium GWC2_45_44
28968847 28968847 PRJNA222400_P_NODE_9208_length_162_cov_1.380531_g9175_i0 PRJNA222400 9208 162 1.380531 2.23646022 Gemmata sp. 1914242 Bacteria Bacteria 60.1 9.67e-9   NR HEV3386825.1 1914242 g9175 i0 50 1.72222222222222 54 27 100 0 162 1 185 238 HEV3386825.1 hypothetical protein [Gemmata sp.] diamond 279 60.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
29032138 29032138 PRJNA222400_P_NODE_5548_length_190_cov_1.475177_g5515_i0 PRJNA222400 5548 190 1.475177 2.8028363 Phycisphaerales bacterium 2052180 Bacteria Bacteria 73.6 2.43e-13   NR MFN0131981.1 2052180 g5515 i0 52.5 3.80526315789474 59 28 93.2 0 179 3 249 307 MFN0131981.1 M14 family zinc carboxypeptidase [Phycisphaerales bacterium] diamond 723 73.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29126892 29126892 PRJNA222400_P_NODE_6889_length_171_cov_2.098361_g6856_i0 PRJNA222400 6889 171 2.098361 3.58819731 Phycisphaerales bacterium 2052180 Bacteria Bacteria 62.4 1.62e-9   NR MBY0307194.1 2052180 g6856 i0 53.3 2.33333333333333 45 21 78.9 0 1 135 304 348 MBY0307194.1 cation transporter [Phycisphaerales bacterium] diamond 399 62.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29554664 29554664 PRJNA222400_P_NODE_8690_length_164_cov_0.904348_g8657_i0 PRJNA222400 8690 164 0.904348 1.48313072 Pseudomonadati 3379134 Bacteria Bacteria 44.7 0.00267   NR HUQ70134.1 2026779 g8657 i0 42.6 1.8109756097561 47 27 86 0 20 160 365 411 HUQ70134.1 ankyrin repeat domain-containing protein [Planctomycetaceae bacterium] diamond 297 45.1 0.991130820399113 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30263869 30263869 PRJNA222400_P_NODE_6752_length_173_cov_1.258065_g6719_i0 PRJNA222400 6752 173 1.258065 2.17645245 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 60.8 5.9e-9   NR HEX4052836.1 2876886 g6719 i0 54.4 0.988439306358382 57 26 98.8 0 2 172 610 666 HEX4052836.1 alanine--tRNA ligase [Tepidisphaeraceae bacterium] diamond 171 60.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
30421900 30421900 PRJNA222400_P_NODE_213_length_1013_cov_3.742739_g196_i0 PRJNA222400 213 1013 3.742739 37.91394607 Planctomycetota bacterium 2026780 Bacteria Bacteria 68.6 1.74e-8   NR MDQ7779968.1 2026780 g196 i0 36.8 0.370187561697927 125 57 36.7 3 909 538 1536 1639 MDQ7779968.1 fibronectin type III domain-containing protein [Planctomycetota bacterium] diamond 375 68.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30895616 30895616 PRJNA222400_P_NODE_3254_length_256_cov_1.444444_g3221_i0 PRJNA222400 3254 256 1.444444 3.69777664 Planctomycetota bacterium 2026780 Bacteria Bacteria 127 1.98e-32   NR MFN0007456.1 2026780 g3221 i0 71.8 2.9765625 85 22 99.6 1 2 256 177 259 MFN0007456.1 cystathionine beta-synthase [Planctomycetota bacterium] diamond 762 127 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31496288 31496288 PRJNA222400_P_NODE_8476_length_165_cov_0.896552_g8443_i0 PRJNA222400 8476 165 0.896552 1.4793108 Fuerstiella sp. 1936112 Bacteria Bacteria 52.4 4.98e-6   NR MEQ9409136.1 1936112 g8443 i0 51.9 3.89090909090909 52 25 94.5 0 157 2 116 167 MEQ9409136.1 hypothetical protein [Fuerstiella sp.] diamond 642 52.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella sp.
31622536 31622536 PRJNA222400_P_NODE_5016_length_199_cov_1.340000_g4983_i0 PRJNA222400 5016 199 1.34 2.6666 Gemmataceae bacterium 2052164 Bacteria Bacteria 73.2 3.96e-13   NR HVK07938.1 2052164 g4983 i0 54.2 2.68341708542714 59 27 88.9 0 199 23 451 509 HVK07938.1 S8 family serine peptidase [Gemmataceae bacterium] diamond 534 73.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32697533 32697533 PRJNA222400_P_NODE_3600_length_238_cov_1.867725_g3567_i0 PRJNA222400 3600 238 1.867725 4.4451855 Thalassoroseus pseudoceratinae 2713176 Bacteria Bacteria 48.1 4.6e-4   NR WP_166819882.1 2713176 g3567 i0 38 0.995798319327731 79 49 99.6 0 1 237 4087 4165 WP_166819882.1 Calx-beta domain-containing protein [Thalassoroseus pseudoceratinae] diamond 237 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Thalassoroseus Thalassoroseus pseudoceratinae

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