contig_metadata
17 rows where bioproject = "PRJNA399133" and tax_clade = "PVC group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4240287 | 4240287 | PRJNA399133_P_NODE_11944_length_153_cov_1.694915_g11856_i0 | PRJNA399133 | 11944 | 153 | 1.694915 | 2.59321995 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 156 | 9.29e-34 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g11856 | i0 | 85.906 | 19.8954248366013 | 149 | 18 | 97 | 3 | 4 | 151 | 1931529 | 1931383 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 3044 | 156 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 27123408 | 27123408 | PRJNA399133_P_NODE_6142_length_212_cov_2.254237_g6054_i0 | PRJNA399133 | 6142 | 212 | 2.254237 | 4.77898244 | Bacteria | 2 | Bacteria | Bacteria | 105 | 9.13e-25 | NR | MAO21141.1 | 2026778 | g6054 | i0 | 68.6 | 4.95283018867925 | 70 | 22 | 99.1 | 0 | 212 | 3 | 164 | 233 | MAO21141.1 PBSX family phage terminase large subunit [Phycisphaerae bacterium] | diamond | 1050 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 27138169 | 27138169 | PRJNA399133_P_NODE_5242_length_229_cov_1.773196_g5154_i0 | PRJNA399133 | 5242 | 229 | 1.773196 | 4.06061884 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 43.5 | 0.016 | NR | MBA3815693.1 | 2052176 | g5154 | i0 | 38.5 | 1.02183406113537 | 78 | 45 | 98.3 | 1 | 3 | 227 | 325 | 402 | MBA3815693.1 insulinase family protein [Parachlamydiaceae bacterium] | diamond | 234 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27233462 | 27233462 | PRJNA399133_P_NODE_5783_length_219_cov_2.929348_g5695_i0 | PRJNA399133 | 5783 | 219 | 2.929348 | 6.41527212 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 68.9 | 2.66e-12 | NR | MDB4418055.1 | 2562705 | g5695 | i0 | 62.5 | 0.767123287671233 | 56 | 21 | 76.7 | 0 | 50 | 217 | 44 | 99 | MDB4418055.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 168 | 68.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 27391638 | 27391638 | PRJNA399133_P_NODE_11303_length_157_cov_1.967213_g11215_i0 | PRJNA399133 | 11303 | 157 | 1.967213 | 3.08852441 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 48.9 | 7.76e-5 | NR | MBX3461222.1 | 2026780 | g11215 | i0 | 52.2 | 0.878980891719745 | 46 | 22 | 87.9 | 0 | 1 | 138 | 462 | 507 | MBX3461222.1 YifB family Mg chelatase-like AAA ATPase [Planctomycetota bacterium] | diamond | 138 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27454839 | 27454839 | PRJNA399133_P_NODE_463_length_785_cov_3.044000_g304_i1 | PRJNA399133 | 463 | 785 | 3.044 | 23.8954 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 80.5 | 4.03e-14 | NR | NBQ64003.1 | 2026799 | g304 | i1 | 46.1 | 1.03566878980892 | 89 | 43 | 33.6 | 3 | 10 | 273 | 119 | 203 | NBQ64003.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 813 | 80.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29128278 | 29128278 | PRJNA399133_P_NODE_4929_length_229_cov_2.340206_g4841_i0 | PRJNA399133 | 4929 | 229 | 2.340206 | 5.35907174 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 75.9 | 6.76e-14 | NR | MFN3241241.1 | 2026780 | g4841 | i0 | 52.6 | 0.995633187772926 | 76 | 25 | 99.6 | 1 | 1 | 228 | 939 | 1003 | MFN3241241.1 Ig-like domain-containing protein [Planctomycetota bacterium] | diamond | 228 | 75.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29128280 | 29128280 | PRJNA399133_P_NODE_5549_length_225_cov_1.473684_g5461_i0 | PRJNA399133 | 5549 | 225 | 1.473684 | 3.315789 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 84.3 | 6.83e-18 | NR | NDG63678.1 | 2026780 | g5461 | i0 | 54.7 | 1 | 75 | 34 | 100 | 0 | 225 | 1 | 148 | 222 | NDG63678.1 polynucleotide kinase [Planctomycetota bacterium] | diamond | 225 | 84.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29506846 | 29506846 | PRJNA399133_P_NODE_9490_length_171_cov_1.176471_g9402_i0 | PRJNA399133 | 9490 | 171 | 1.176471 | 2.01176541 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 43.5 | 0.00711 | NR | HAM40894.1 | 2035772 | g9402 | i0 | 38.6 | 1.98245614035088 | 57 | 32 | 100 | 1 | 1 | 171 | 160 | 213 | HAM40894.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 339 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30580724 | 30580724 | PRJNA399133_P_NODE_4413_length_241_cov_2.160194_g4325_i0 | PRJNA399133 | 4413 | 241 | 2.160194 | 5.20606754 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 44.3 | 0.00985 | NR | NBV48909.1 | 2026799 | g4325 | i0 | 76.9 | 0.323651452282158 | 26 | 6 | 32.4 | 0 | 83 | 6 | 52 | 77 | NBV48909.1 phage major capsid protein [Verrucomicrobiota bacterium] | diamond | 78 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31117801 | 31117801 | PRJNA399133_P_NODE_5135_length_229_cov_1.876289_g5047_i0 | PRJNA399133 | 5135 | 229 | 1.876289 | 4.29670181 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 47.8 | 5.11e-4 | NR | MCD6049097.1 | 2026799 | g5047 | i0 | 36.8 | 0.890829694323144 | 68 | 30 | 89.1 | 1 | 206 | 3 | 1 | 55 | MCD6049097.1 sensor hybrid histidine kinase [Verrucomicrobiota bacterium] | diamond | 204 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31940186 | 31940186 | PRJNA399133_P_NODE_6417_length_207_cov_2.174419_g6329_i0 | PRJNA399133 | 6417 | 207 | 2.174419 | 4.50104733 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 106 | 2.32e-25 | NR | MDB4418045.1 | 2562705 | g6329 | i0 | 69.6 | 1 | 69 | 21 | 100 | 0 | 1 | 207 | 163 | 231 | MDB4418045.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 207 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 32130377 | 32130377 | PRJNA399133_P_NODE_12158_length_152_cov_1.358974_g12070_i0 | PRJNA399133 | 12158 | 152 | 1.358974 | 2.06564048 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 82.4 | 8.96e-18 | NR | MFN5329251.1 | 2026780 | g12070 | i0 | 80.9 | 0.927631578947368 | 47 | 9 | 92.8 | 0 | 152 | 12 | 148 | 194 | MFN5329251.1 lambda exonuclease family protein [Planctomycetota bacterium] | diamond | 141 | 82.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32383323 | 32383323 | PRJNA399133_P_NODE_10979_length_159_cov_2.169355_g10891_i0 | PRJNA399133 | 10979 | 159 | 2.169355 | 3.44927445 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 62 | 1.54e-9 | NR | MFT6108405.1 | 2026780 | g10891 | i0 | 48.1 | 1.9622641509434 | 52 | 27 | 98.1 | 0 | 3 | 158 | 130 | 181 | MFT6108405.1 UDP-3-O-[3-hydroxymyristoyl] glucosamine N-acyltransferase [Planctomycetota bacterium] | diamond | 312 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32478470 | 32478470 | PRJNA399133_P_NODE_919_length_532_cov_2.917505_g841_i0 | PRJNA399133 | 919 | 532 | 2.917505 | 15.5211266 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 105 | 5.85e-23 | NR | MCH2572347.1 | 2026780 | g841 | i0 | 62.1 | 0.490601503759398 | 87 | 31 | 48.5 | 2 | 2 | 259 | 342 | 427 | MCH2572347.1 hypothetical protein [Planctomycetota bacterium] | diamond | 261 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32635885 | 32635885 | PRJNA399133_P_NODE_2100_length_345_cov_2.154839_g2013_i0 | PRJNA399133 | 2100 | 345 | 2.154839 | 7.43419455 | Victivallales bacterium | 2212475 | Bacteria | Bacteria | 53.5 | 1.16e-5 | NR | MFA7185129.1 | 2212475 | g2013 | i0 | 30.6 | 1.05217391304348 | 121 | 56 | 84.3 | 2 | 6 | 296 | 109 | 225 | MFA7185129.1 hypothetical protein [Victivallales bacterium] | diamond | 363 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallales bacterium | |||
| 32793290 | 32793290 | PRJNA399133_P_NODE_8120_length_184_cov_1.610738_g8032_i0 | PRJNA399133 | 8120 | 184 | 1.610738 | 2.96375792 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 66.6 | 6.46e-11 | NR | MDB4571673.1 | 2562705 | g8032 | i0 | 50 | 1.89130434782609 | 58 | 29 | 94.6 | 0 | 181 | 8 | 470 | 527 | MDB4571673.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 348 | 66.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium |
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);;