RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA195897" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA195897 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
19491974 19491974 PRJNA195897_P_NODE_3216_length_273_cov_1.598214_g3183_i0 PRJNA195897 3216 273 1.598214 4.36312422 root 1 Root_unresolved Root_unresolved 177 2.26e-49   NR MEC9373988.1 2026780 g3183 i0 85.4 10.6923076923077 89 13 97.8 0 2 268 1 89 MEC9373988.1 alanine--tRNA ligase [Planctomycetota bacterium] diamond 2919 178 0.99438202247191 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26598804 26598804 PRJNA195897_P_NODE_7301_length_185_cov_0.941176_g7268_i0 PRJNA195897 7301 185 0.941176 1.7411756 Bythopirellula goksoeyrii 1400387 Bacteria Bacteria 58.5 4.53e-8   NR WP_148072465.1 1400387 g7268 i0 54.8 1.7027027027027 42 19 68.1 0 34 159 352 393 WP_148072465.1 DUF1668 domain-containing protein [Bythopirellula goksoeyrii] diamond 315 58.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Bythopirellula Bythopirellula goksoeyrii
28021657 28021657 PRJNA195897_P_NODE_4145_length_235_cov_1.118280_g4112_i0 PRJNA195897 4145 235 1.11828 2.627958 Phycisphaerales bacterium 2052180 Bacteria Bacteria 64.3 3.3e-10   NR MBY0307717.1 2052180 g4112 i0 54.2 1.67234042553191 59 26 74 1 179 6 76 134 MBY0307717.1 S10 family peptidase [Phycisphaerales bacterium] diamond 393 64.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28305648 28305648 PRJNA195897_P_NODE_10426_length_166_cov_0.888889_g10393_i0 PRJNA195897 10426 166 0.888889 1.47555574 Planctomycetota bacterium 2026780 Bacteria Bacteria 100 5.73e-23   NR MDZ4773456.1 2026780 g10393 i0 94.4 0.975903614457831 54 3 97.6 0 166 5 368 421 MDZ4773456.1 OPT family oligopeptide transporter [Planctomycetota bacterium] diamond 162 100 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28400402 28400402 PRJNA195897_P_NODE_6146_length_198_cov_1.093960_g6113_i0 PRJNA195897 6146 198 1.09396 2.1660408 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 81.3 5.59e-16   NR MAT68475.1 2026779 g6113 i0 60.3 2 68 23 97 1 1 192 535 602 MAT68475.1 DUF885 domain-containing protein [Planctomycetaceae bacterium] diamond 396 81.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28779140 28779140 PRJNA195897_P_NODE_267_length_993_cov_2.957627_g247_i0 PRJNA195897 267 993 2.957627 29.36923611 Planctomycetota bacterium 2026780 Bacteria Bacteria 68.6 1.6e-8   NR MDQ7779968.1 2026780 g247 i0 36.8 0.377643504531722 125 57 37.5 3 87 458 1536 1639 MDQ7779968.1 fibronectin type III domain-containing protein [Planctomycetota bacterium] diamond 375 68.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29063560 29063560 PRJNA195897_P_NODE_1148_length_496_cov_2.447427_g1117_i0 PRJNA195897 1148 496 2.447427 12.13923792 Planctomycetota bacterium 2026780 Bacteria Bacteria 47 0.0148   NR MEM6473579.1 2026780 g1117 i0 32.5 1.875 163 84 93.8 9 11 475 168 312 MEM6473579.1 cadherin domain-containing protein [Planctomycetota bacterium] diamond 930 47 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29158357 29158357 PRJNA195897_P_NODE_449_length_797_cov_2.430481_g422_i0 PRJNA195897 449 797 2.430481 19.37093357 Fuerstiella sp. 1936112 Bacteria Bacteria 72 4.19e-10   NR MCP4855245.1 1936112 g422 i0 29.1 2.85696361355082 244 149 86.2 8 98 784 1456 1690 MCP4855245.1 tandem-95 repeat protein [Fuerstiella sp.] diamond 2277 72 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella sp.
29239187 29239187 PRJNA195897_P_NODE_10689_length_166_cov_0.888889_g10656_i0 PRJNA195897 10689 166 0.888889 1.47555574 root 1 Root_unresolved Root_unresolved 53.5 7.44e-7   NR WP_154931914.1 122 g10656 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
29333844 29333844 PRJNA195897_P_NODE_8469_length_173_cov_1.250000_g8436_i0 PRJNA195897 8469 173 1.25 2.1625 PVC group 1783257 Bacteria Bacteria 43.9 0.00575   NR MAE63693.1 2026777 g8436 i0 42.9 1.66473988439306 56 28 90.2 1 2 157 767 822 MAE63693.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 288 44.3 0.99097065462754 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
29396973 29396973 PRJNA195897_P_NODE_2289_length_334_cov_1.319298_g2256_i0 PRJNA195897 2289 334 1.319298 4.40645532 Planctomycetia 203683 Bacteria Bacteria 44.7 0.0221   NR MBL8848245.1 2026779 g2256 i0 29.8 6 114 70 97.9 4 329 3 85 193 MBL8848245.1 hypothetical protein [Planctomycetaceae bacterium] diamond 2004 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29757940 29757940 PRJNA195897_P_NODE_4071_length_237_cov_1.909574_g4038_i0 PRJNA195897 4071 237 1.909574 4.52569038 Singulisphaera sp. GP187 1882752 Bacteria Bacteria 53.1 7.36e-6   NR WP_074307778.1 1882752 g4038 i0 37.5 0.911392405063291 72 45 91.1 0 216 1 320 391 WP_074307778.1 sulfotransferase family protein [Singulisphaera sp. GP187] diamond 216 53.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. GP187
30028699 30028699 PRJNA195897_P_NODE_7591_length_181_cov_1.575758_g7558_i0 PRJNA195897 7591 181 1.575758 2.85212198 PVC group 1783257 Bacteria Bacteria 87.8 2.19e-18   NR MFM8413673.1 2026780 g7558 i0 73.2 6.77900552486188 56 15 92.8 0 177 10 470 525 MFM8413673.1 choice-of-anchor D domain-containing protein [Planctomycetota bacterium] diamond 1227 87.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30295540 30295540 PRJNA195897_P_NODE_9852_length_167_cov_1.288136_g9819_i0 PRJNA195897 9852 167 1.288136 2.15118712 Rubripirellula obstinata 406547 Bacteria Bacteria 53.9 1.31e-6   NR WP_149752632.1 406547 g9819 i0 43.6 2.92814371257485 55 31 98.8 0 3 167 167 221 WP_149752632.1 ankyrin repeat domain-containing protein [Rubripirellula obstinata] diamond 489 53.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula obstinata
30516259 30516259 PRJNA195897_P_NODE_1333_length_459_cov_2.204878_g1300_i0 PRJNA195897 1333 459 2.204878 10.12039002 Pirellulales bacterium 2715253 Bacteria Bacteria 61.2 1.17e-7   NR MEX2185332.1 2715253 g1300 i0 35.1 1.22222222222222 94 54 60.1 2 45 320 149 237 MEX2185332.1 lamin tail domain-containing protein [Pirellulales bacterium] diamond 561 61.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
30705734 30705734 PRJNA195897_P_NODE_10794_length_165_cov_1.344828_g10761_i0 PRJNA195897 10794 165 1.344828 2.2189662 Mariniblastus sp. 2005381 Bacteria Bacteria 59.7 1.23e-8   NR MDG2185377.1 2005381 g10761 i0 52.9 1.85454545454545 51 24 92.7 0 5 157 184 234 MDG2185377.1 NHL repeat-containing protein [Mariniblastus sp.] diamond 306 59.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Mariniblastus Mariniblastus sp.
31591122 31591122 PRJNA195897_P_NODE_3676_length_252_cov_2.142857_g3643_i0 PRJNA195897 3676 252 2.142857 5.39999964 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.4 0.00478   NR MBJ76560.1 2026780 g3643 i0 36.8 1.61904761904762 68 43 81 0 207 4 470 537 MBJ76560.1 hypothetical protein [Planctomycetota bacterium] diamond 408 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31717453 31717453 PRJNA195897_P_NODE_6537_length_193_cov_1.791667_g6504_i0 PRJNA195897 6537 193 1.791667 3.45791731 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 64.7 2.76e-11   NR HMO24805.1 2876886 g6504 i0 56.3 3.01554404145078 64 28 99.5 0 193 2 36 99 HMO24805.1 DCC1-like thiol-disulfide oxidoreductase family protein [Tepidisphaeraceae bacterium] diamond 582 64.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
32255680 32255680 PRJNA195897_P_NODE_12498_length_162_cov_0.920354_g12465_i0 PRJNA195897 12498 162 0.920354 1.49097348 Pirellulaceae bacterium 2699754 Bacteria Bacteria 103 1.9099999999999994e-24   NR MCC7335815.1 2699754 g12465 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
32666073 32666073 PRJNA195897_P_NODE_40_length_1991_cov_2.971679_g36_i0 PRJNA195897 40 1991 2.971679 59.16612889 Gemmataceae bacterium 2052164 Bacteria Bacteria 124 5.19e-25   NR MFO0800230.1 2052164 g36 i0 30.1 0.830236062280261 551 317 77.6 25 153 1697 9190 9708 MFO0800230.1 PKD domain-containing protein [Gemmataceae bacterium] diamond 1653 124 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32886365 32886365 PRJNA195897_P_NODE_3580_length_256_cov_1.004831_g3547_i0 PRJNA195897 3580 256 1.004831 2.57236736 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 62 7.22e-9   NR MBL8830435.1 2026779 g3547 i0 44.3 1.81640625 79 39 92.6 1 255 19 110 183 MBL8830435.1 LEPR-XLL domain-containing protein [Planctomycetaceae bacterium] diamond 465 62 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae 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);;