contig_metadata
25 rows where bioproject = "PRJNA474426", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2998203 | 2998203 | PRJNA474426_P_NODE_23323_length_204_cov_1.148387_g23118_i0 | PRJNA474426 | 23323 | 204 | 1.148387 | 2.34270948 | Caulifigura coniformis | 2527983 | Bacteria | Bacteria | 189 | 1.2999999999999996e-43 | NTclustered | gi|1712508784|gb|CP036271.1| | 2527983 | g23118 | i0 | 86.441 | 171.617647058824 | 177 | 19 | 86 | 5 | 1 | 175 | 2926760 | 2926933 | Caulifigura coniformis strain Pan44 chromosome | blastn | 35010 | 189 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Caulifigura | Caulifigura coniformis | |
| 4274549 | 4274549 | PRJNA474426_P_NODE_9304_length_354_cov_1.177049_g9099_i0 | PRJNA474426 | 9304 | 354 | 1.177049 | 4.16675346 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 302 | 3.01e-77 | NTclustered | gi|1958061316|gb|CP064987.1| | 2052180 | g9099 | i0 | 83.333 | 377.661016949153 | 348 | 36 | 97 | 16 | 12 | 354 | 2190485 | 2190815 | Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome | blastn | 133692 | 302 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 15750149 | 15750149 | PRJNA474426_P_NODE_27653_length_184_cov_1.525926_g27448_i0 | PRJNA474426 | 27653 | 184 | 1.525926 | 2.80770384 | Bacteria | 2 | Bacteria | Bacteria | 89 | 9.42e-20 | NR | MCA9199412.1 | 2053591 | g27448 | i0 | 93.8 | 3.11413043478261 | 48 | 3 | 78.3 | 0 | 183 | 40 | 6 | 53 | MCA9199412.1 ParA family protein [Planctomycetales bacterium] | diamond | 573 | 89 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetales bacterium | |||
| 22123924 | 22123924 | PRJNA474426_P_NODE_24318_length_198_cov_2.966443_g24113_i0 | PRJNA474426 | 24318 | 198 | 2.966443 | 5.87355714 | Sedimentisphaerales bacterium | 2813034 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|2874254109|emb|OY970194.1| | 2813034 | g24113 | i0 | 100 | 0.151515151515152 | 30 | 0 | 15 | 0 | 82 | 111 | 1744381 | 1744352 | MAG: Sedimentisphaerales bacterium isolate MFD00905.bin.c.1 genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Sedimentisphaerales | Sedimentisphaerales bacterium | |||
| 26601128 | 26601128 | PRJNA474426_P_NODE_29161_length_178_cov_1.589147_g28956_i0 | PRJNA474426 | 29161 | 178 | 1.589147 | 2.82868166 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 91.7 | 7.5e-20 | NR | MBC7782520.1 | 2026778 | g28956 | i0 | 91.3 | 1.58426966292135 | 46 | 4 | 77.5 | 0 | 145 | 8 | 144 | 189 | MBC7782520.1 asparagine--tRNA ligase [Phycisphaerae bacterium] | diamond | 282 | 91.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 26696309 | 26696309 | PRJNA474426_P_NODE_32881_length_167_cov_0.872881_g32676_i0 | PRJNA474426 | 32881 | 167 | 0.872881 | 1.45771127 | Thermoguttaceae bacterium | 2691551 | Bacteria | Bacteria | 53.9 | 1.51e-6 | NR | MBQ2619791.1 | 2691551 | g32676 | i0 | 51 | 0.916167664670659 | 51 | 25 | 91.6 | 0 | 167 | 15 | 430 | 480 | MBQ2619791.1 hypothetical protein [Thermoguttaceae bacterium] | diamond | 153 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Thermoguttaceae | Thermoguttaceae bacterium | ||
| 27202492 | 27202492 | PRJNA474426_P_NODE_37642_length_152_cov_2.019417_g37437_i0 | PRJNA474426 | 37642 | 152 | 2.019417 | 3.06951384 | Planctomycetales bacterium | 2053591 | Bacteria | Bacteria | 92.4 | 3.35e-20 | NR | MCA9199410.1 | 2053591 | g37437 | i0 | 82 | 0.986842105263158 | 50 | 9 | 98.7 | 0 | 3 | 152 | 712 | 761 | MCA9199410.1 hypothetical protein [Planctomycetales bacterium] | diamond | 150 | 92.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetales bacterium | |||
| 27676747 | 27676747 | PRJNA474426_P_NODE_16464_length_252_cov_5.261084_g16259_i0 | PRJNA474426 | 16464 | 252 | 5.261084 | 13.25793168 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 122 | 4.989999999999999e-31 | NR | MBX9627204.1 | 2052164 | g16259 | i0 | 100 | 0.738095238095238 | 62 | 0 | 73.8 | 0 | 241 | 56 | 235 | 296 | MBX9627204.1 glycosyltransferase family 4 protein [Gemmataceae bacterium] | diamond | 186 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 27708510 | 27708510 | PRJNA474426_P_NODE_24244_length_199_cov_1.173333_g24039_i0 | PRJNA474426 | 24244 | 199 | 1.173333 | 2.33493267 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 62 | 2.9e-9 | NR | HRP64274.1 | 2052180 | g24039 | i0 | 90.3 | 0.934673366834171 | 31 | 3 | 46.7 | 0 | 95 | 3 | 1 | 31 | HRP64274.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 186 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 27771412 | 27771412 | PRJNA474426_P_NODE_5464_length_461_cov_2.662621_g5266_i0 | PRJNA474426 | 5464 | 461 | 2.662621 | 12.27468281 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 124 | 1.52e-29 | NR | HUT58991.1 | 2026778 | g5266 | i0 | 53.7 | 0.787418655097614 | 121 | 52 | 76.1 | 2 | 110 | 460 | 2 | 122 | HUT58991.1 right-handed parallel beta-helix repeat-containing protein [Phycisphaerae bacterium] | diamond | 363 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 27802942 | 27802942 | PRJNA474426_P_NODE_20344_length_221_cov_2.866279_g20139_i0 | PRJNA474426 | 20344 | 221 | 2.866279 | 6.33447659 | Candidatus Brocadiales bacterium | 2760054 | Bacteria | Bacteria | 59.7 | 1.49e-8 | NR | MBC8553828.1 | 2760054 | g20139 | i0 | 54.2 | 0.65158371040724 | 48 | 22 | 65.2 | 0 | 219 | 76 | 143 | 190 | MBC8553828.1 glycosyltransferase [Candidatus Brocadiales bacterium] | diamond | 144 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiales | Candidatus Brocadiales bacterium | |||
| 28023911 | 28023911 | PRJNA474426_P_NODE_28265_length_182_cov_1.105263_g28060_i0 | PRJNA474426 | 28265 | 182 | 1.105263 | 2.01157866 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 46.2 | 9.77e-4 | NR | MFN9721371.1 | 2026780 | g28060 | i0 | 44.9 | 0.807692307692308 | 49 | 25 | 77.5 | 1 | 154 | 14 | 184 | 232 | MFN9721371.1 BspA family leucine-rich repeat surface protein [Planctomycetota bacterium] | diamond | 147 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28055258 | 28055258 | PRJNA474426_P_NODE_32805_length_167_cov_0.881356_g32600_i0 | PRJNA474426 | 32805 | 167 | 0.881356 | 1.47186452 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 69.3 | 2.52e-12 | NR | MEK6260395.1 | 2026780 | g32600 | i0 | 82.2 | 1.61676646706587 | 45 | 6 | 77.2 | 1 | 141 | 13 | 141 | 185 | MEK6260395.1 ABC transporter ATP-binding protein [Planctomycetota bacterium] | diamond | 270 | 69.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28655373 | 28655373 | PRJNA474426_P_NODE_18807_length_232_cov_1.136612_g18602_i0 | PRJNA474426 | 18807 | 232 | 1.136612 | 2.63693984 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 81.3 | 3.2e-17 | NR | MAO25171.1 | 2026778 | g18602 | i0 | 42.1 | 2.01724137931034 | 76 | 42 | 98.3 | 1 | 232 | 5 | 69 | 142 | MAO25171.1 hypothetical protein [Phycisphaerae bacterium] | diamond | 468 | 81.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 28876258 | 28876258 | PRJNA474426_P_NODE_20148_length_223_cov_0.885057_g19943_i0 | PRJNA474426 | 20148 | 223 | 0.885057 | 1.97367711 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 80.9 | 3.49e-17 | NR | MSU80748.1 | 2052164 | g19943 | i0 | 62.1 | 3.12107623318386 | 58 | 20 | 75.3 | 1 | 2 | 169 | 24 | 81 | MSU80748.1 hypothetical protein [Gemmataceae bacterium] | diamond | 696 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 29003061 | 29003061 | PRJNA474426_P_NODE_25448_length_193_cov_1.458333_g25243_i0 | PRJNA474426 | 25448 | 193 | 1.458333 | 2.81458269 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 71.2 | 1.71e-12 | NR | MCU0878331.1 | 2699754 | g25243 | i0 | 64.8 | 0.839378238341969 | 54 | 19 | 83.9 | 0 | 192 | 31 | 412 | 465 | MCU0878331.1 ATP-binding protein [Pirellulaceae bacterium] | diamond | 162 | 71.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 29223817 | 29223817 | PRJNA474426_P_NODE_36589_length_162_cov_0.911504_g36384_i0 | PRJNA474426 | 36589 | 162 | 0.911504 | 1.47663648 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 67.4 | 2.44e-11 | NR | MBL8826867.1 | 2026779 | g36384 | i0 | 63.3 | 1.61111111111111 | 49 | 18 | 90.7 | 0 | 151 | 5 | 341 | 389 | MBL8826867.1 right-handed parallel beta-helix repeat-containing protein [Planctomycetaceae bacterium] | diamond | 261 | 67.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 29934588 | 29934588 | PRJNA474426_P_NODE_23851_length_201_cov_1.342105_g23646_i0 | PRJNA474426 | 23851 | 201 | 1.342105 | 2.69763105 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.5 | 1.68e-4 | NR | MBP7747031.1 | 2026778 | g23646 | i0 | 75 | 1.43283582089552 | 32 | 7 | 46.3 | 1 | 190 | 98 | 55 | 86 | MBP7747031.1 hypothetical protein [Phycisphaerae bacterium] | diamond | 288 | 48.9 | 0.991820040899796 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 30518587 | 30518587 | PRJNA474426_P_NODE_25213_length_194_cov_1.420690_g25008_i0 | PRJNA474426 | 25213 | 194 | 1.42069 | 2.7561386 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 68.6 | 1.54e-11 | NR | MBW7988686.1 | 2026780 | g25008 | i0 | 49.2 | 0.912371134020619 | 59 | 30 | 91.2 | 0 | 3 | 179 | 872 | 930 | MBW7988686.1 metallophosphoesterase [Planctomycetota bacterium] | diamond | 177 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30661066 | 30661066 | PRJNA474426_P_NODE_11833_length_308_cov_6.069498_g11628_i0 | PRJNA474426 | 11833 | 308 | 6.069498 | 18.69405384 | Bacteria | 2 | Bacteria | Bacteria | 95.1 | 1.63e-22 | NR | MFO1006502.1 | 2026779 | g11628 | i0 | 56 | 6.58441558441558 | 75 | 33 | 73.1 | 0 | 294 | 70 | 55 | 129 | MFO1006502.1 DUF5684 domain-containing protein [Planctomycetaceae bacterium] | diamond | 2028 | 95.5 | 0.995811518324607 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 30676421 | 30676421 | PRJNA474426_P_NODE_14593_length_272_cov_1.502242_g14388_i0 | PRJNA474426 | 14593 | 272 | 1.502242 | 4.08609824 | Planctomycetia bacterium | 2052181 | Bacteria | Bacteria | 50.8 | 1.7e-5 | NR | NDC64728.1 | 2052181 | g14388 | i0 | 44 | 0.827205882352941 | 75 | 31 | 82.7 | 2 | 32 | 256 | 39 | 102 | NDC64728.1 hypothetical protein [Planctomycetia bacterium] | diamond | 225 | 50.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetia bacterium | ||||
| 30866074 | 30866074 | PRJNA474426_P_NODE_30154_length_174_cov_3.552000_g29949_i0 | PRJNA474426 | 30154 | 174 | 3.552 | 6.18048 | Humisphaera borealis | 2807512 | Bacteria | Bacteria | 78.2 | 4.65e-15 | NR | WP_206291681.1 | 2807512 | g29949 | i0 | 75 | 1.67241379310345 | 48 | 12 | 82.8 | 0 | 14 | 157 | 675 | 722 | WP_206291681.1 PSD1 and planctomycete cytochrome C domain-containing protein [Humisphaera borealis] | diamond | 291 | 78.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Tepidisphaerales | Tepidisphaeraceae | Humisphaera | Humisphaera borealis | |
| 30897879 | 30897879 | PRJNA474426_P_NODE_11514_length_313_cov_2.852273_g11309_i0 | PRJNA474426 | 11514 | 313 | 2.852273 | 8.92761449 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 181 | 1.41e-51 | NR | MBU6412997.1 | 2026780 | g11309 | i0 | 85.2 | 0.843450479233227 | 88 | 13 | 84.3 | 0 | 37 | 300 | 134 | 221 | MBU6412997.1 beta-N-acetylhexosaminidase [Planctomycetota bacterium] | diamond | 264 | 181 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30992603 | 30992603 | PRJNA474426_P_NODE_36034_length_163_cov_0.894737_g35829_i0 | PRJNA474426 | 36034 | 163 | 0.894737 | 1.45842131 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 61.2 | 1.62e-10 | NR | MCY2936241.1 | 2026780 | g35829 | i0 | 94.7 | 0.699386503067485 | 38 | 2 | 69.9 | 0 | 114 | 1 | 1 | 38 | MCY2936241.1 hypothetical protein [Planctomycetota bacterium] | diamond | 114 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32668372 | 32668372 | PRJNA474426_P_NODE_2900_length_600_cov_5.299456_g2733_i0 | PRJNA474426 | 2900 | 600 | 5.299456 | 31.796736 | Fuerstiella sp. | 1936112 | Bacteria | Bacteria | 95.5 | 7.19e-19 | NR | MCP4783352.1 | 1936112 | g2733 | i0 | 42.6 | 0.61 | 122 | 69 | 61 | 1 | 11 | 376 | 1154 | 1274 | MCP4783352.1 hypothetical protein [Fuerstiella sp.] | diamond | 366 | 95.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Fuerstiella | Fuerstiella sp. |
Advanced export
JSON shape: default, array, newline-delimited
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);;