contig_metadata
22 rows where bioproject = "PRJNA914897", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7273077 | 7273077 | PRJNA914897_P_NODE_26606_length_313_cov_1.845833_g26182_i0 | PRJNA914897 | 26606 | 313 | 1.845833 | 5.77745729 | Verrucomicrobium spinosum | 2736 | Bacteria | Bacteria | 224 | 5.86e-54 | NTclustered | gi|12583973|gb|AF245377.1| | 240016 | g26182 | i0 | 83.267 | 52.6837060702875 | 251 | 34 | 79 | 8 | 68 | 313 | 190 | 437 | Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence | blastn | 16490 | 224 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 17473206 | 17473206 | PRJNA914897_P_NODE_41814_length_242_cov_1.284024_g41390_i0 | PRJNA914897 | 41814 | 242 | 1.284024 | 3.10733808 | Luteolibacter luteus | 2728835 | Bacteria | Bacteria | 91.6 | 4.62e-14 | NTclustered | gi|1835317346|gb|CP051774.1| | 2728835 | g41390 | i0 | 91.176 | 6.85123966942149 | 68 | 4 | 27 | 2 | 37 | 102 | 3804777 | 3804710 | Luteolibacter luteus strain G-1-1-1 chromosome, complete genome | blastn | 1658 | 91.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 27372530 | 27372530 | PRJNA914897_P_NODE_22243_length_353_cov_1.300000_g21819_i0 | PRJNA914897 | 22243 | 353 | 1.3 | 4.589 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 99.4 | 1.87e-21 | NR | MDB6029266.1 | 2026801 | g21819 | i0 | 49.5 | 4.68271954674221 | 99 | 49 | 84.1 | 1 | 299 | 3 | 426 | 523 | MDB6029266.1 lipid exporter, fused ATPase and inner rane subunit MsbA [Verrucomicrobiales bacterium] | diamond | 1653 | 99.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 27720040 | 27720040 | PRJNA914897_P_NODE_9304_length_625_cov_2.943841_g8889_i0 | PRJNA914897 | 9304 | 625 | 2.943841 | 18.39900625 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 52 | 3.52e-4 | NR | MBS0655522.1 | 2026799 | g8889 | i0 | 41.1 | 0.84 | 56 | 29 | 26.9 | 1 | 502 | 335 | 74 | 125 | MBS0655522.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 525 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28003934 | 28003934 | PRJNA914897_P_NODE_6705_length_758_cov_29.423358_g6329_i0 | PRJNA914897 | 6705 | 758 | 29.423358 | 223.02905364 | Methylacidiphilum sp. Yel | 1847730 | Bacteria | Bacteria | 50.1 | 0.00328 | NR | WP_134391042.1 | 1847730 | g6329 | i0 | 28.3 | 0.546174142480211 | 138 | 85 | 49.5 | 5 | 583 | 209 | 33 | 169 | WP_134391042.1 class I SAM-dependent methyltransferase [Methylacidiphilum sp. Yel] | diamond | 414 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Methylacidiphilae | Methylacidiphilales | Methylacidiphilaceae | Methylacidiphilum (ex Ratnadevi et al. 2023) | Methylacidiphilum sp. Yel | |
| 28192944 | 28192944 | PRJNA914897_P_NODE_30466_length_286_cov_0.995305_g30042_i0 | PRJNA914897 | 30466 | 286 | 0.995305 | 2.8465723 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 61.6 | 1.42e-8 | NR | HYG84357.1 | 2499141 | g30042 | i0 | 39.3 | 0.881118881118881 | 84 | 51 | 88.1 | 0 | 31 | 282 | 196 | 279 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 252 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 28231799 | 28231799 | PRJNA914897_P_NODE_19486_length_386_cov_0.824281_g19064_i0 | PRJNA914897 | 19486 | 386 | 0.824281 | 3.18172466 | Roseibacillus | 518755 | Bacteria | Bacteria | 53.1 | 4.4e-5 | NR | MBQ97065.1 | 2024856 | g19064 | i0 | 28.3 | 2.82901554404145 | 120 | 86 | 93.3 | 0 | 25 | 384 | 1068 | 1187 | MBQ97065.1 hypothetical protein [Roseibacillus sp.] | diamond | 1092 | 53.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseibacillus | Roseibacillus sp. | |
| 28800202 | 28800202 | PRJNA914897_P_NODE_36827_length_251_cov_0.865169_g36403_i0 | PRJNA914897 | 36827 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 145 | 1.93e-38 | NR | MEO6245189.1 | 2006848 | g36403 | i0 | 79.5 | 1.9840637450199201 | 83 | 17 | 99.2 | 0 | 2 | 250 | 640 | 722 | MEO6245189.1 HEAT repeat domain-containing protein [Opitutaceae bacterium] | diamond | 498 | 146 | 0.993150684931507 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 28887664 | 28887664 | PRJNA914897_P_NODE_2328_length_1266_cov_2.960604_g2119_i0 | PRJNA914897 | 2328 | 1266 | 2.960604 | 37.48124664 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 88.2 | 4.77e-16 | NR | MEO5753320.1 | 2201154 | g2119 | i0 | 30.3 | 0.462085308056872 | 195 | 108 | 42.4 | 6 | 1200 | 664 | 34 | 216 | MEO5753320.1 CAP domain-containing protein [Chthoniobacterales bacterium] | diamond | 585 | 88.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 28919190 | 28919190 | PRJNA914897_P_NODE_41228_length_243_cov_1.035294_g40804_i0 | PRJNA914897 | 41228 | 243 | 1.035294 | 2.51576442 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 42.4 | 0.0486 | NR | HEV2328609.1 | 2499141 | g40804 | i0 | 41.4 | 0.716049382716049 | 58 | 31 | 71.6 | 1 | 16 | 189 | 143 | 197 | HEV2328609.1 GGDEF domain-containing protein [Verrucomicrobiia bacterium] | diamond | 174 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29266485 | 29266485 | PRJNA914897_P_NODE_32369_length_275_cov_0.777228_g31945_i0 | PRJNA914897 | 32369 | 275 | 0.777228 | 2.137377 | Verrucomicrobiaceae bacterium NT6N | 2979115 | Bacteria | Bacteria | 124 | 6.09e-32 | NR | BDS05028.1 | 2979115 | g31945 | i0 | 69.7 | 5.82545454545455 | 89 | 27 | 97.1 | 0 | 6 | 272 | 196 | 284 | BDS05028.1 alcohol dehydrogenase [Verrucomicrobiaceae bacterium NT6N] | diamond | 1602 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Oceaniferula | Oceaniferula spumae | |
| 29652566 | 29652566 | PRJNA914897_P_NODE_41110_length_243_cov_1.747059_g40686_i0 | PRJNA914897 | 41110 | 243 | 1.747059 | 4.24535337 | Bacteria | 2 | Bacteria | Bacteria | 50.4 | 6.76e-5 | NR | WP_338688151.1 | 490095 | g40686 | i0 | 45.1 | 3.23456790123457 | 71 | 26 | 87.7 | 3 | 242 | 30 | 215 | 272 | WP_338688151.1 aldose epimerase family protein [Haloferula helveola] | diamond | 786 | 50.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula helveola | |
| 29676793 | 29676793 | PRJNA914897_P_NODE_750_length_1830_cov_5.412066_g658_i0 | PRJNA914897 | 750 | 1830 | 5.412066 | 99.0408078 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 402 | 3.7299999999999997e-129 | NR | HYG84357.1 | 2499141 | g658 | i0 | 50.6 | 0.80327868852459 | 490 | 217 | 76.7 | 8 | 280 | 1683 | 41 | 527 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 1470 | 402 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29771676 | 29771676 | PRJNA914897_P_NODE_1851_length_1372_cov_7.587375_g1674_i0 | PRJNA914897 | 1851 | 1372 | 7.587375 | 104.098785 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 75.9 | 1.16e-11 | NR | MEO5753320.1 | 2201154 | g1674 | i0 | 30 | 0.459183673469388 | 210 | 119 | 42.4 | 6 | 35 | 616 | 23 | 220 | MEO5753320.1 CAP domain-containing protein [Chthoniobacterales bacterium] | diamond | 630 | 75.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 29993056 | 29993056 | PRJNA914897_P_NODE_35971_length_254_cov_1.027624_g35547_i0 | PRJNA914897 | 35971 | 254 | 1.027624 | 2.61016496 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 57.8 | 2.14e-7 | NR | HYG84357.1 | 2499141 | g35547 | i0 | 34.5 | 0.992125984251969 | 84 | 55 | 99.2 | 0 | 252 | 1 | 351 | 434 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 252 | 57.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30277661 | 30277661 | PRJNA914897_P_NODE_27172_length_309_cov_0.987288_g26748_i0 | PRJNA914897 | 27172 | 309 | 0.987288 | 3.05071992 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 79 | 1.57e-14 | NR | HYG84357.1 | 2499141 | g26748 | i0 | 49.4 | 1.57281553398058 | 81 | 41 | 78.6 | 0 | 246 | 4 | 338 | 418 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 486 | 79 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30277667 | 30277667 | PRJNA914897_P_NODE_33432_length_268_cov_2.815385_g33008_i0 | PRJNA914897 | 33432 | 268 | 2.815385 | 7.5452318 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 61.6 | 1.16e-9 | NR | MDP6307261.1 | 2026799 | g33008 | i0 | 48.4 | 0.716417910447761 | 64 | 33 | 71.6 | 0 | 265 | 74 | 4 | 67 | MDP6307261.1 ankyrin repeat domain-containing protein [Verrucomicrobiota bacterium] | diamond | 192 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30435585 | 30435585 | PRJNA914897_P_NODE_4493_length_947_cov_2.184211_g4176_i0 | PRJNA914897 | 4493 | 947 | 2.184211 | 20.68447817 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 71.6 | 9.39e-10 | NR | HYG84357.1 | 2499141 | g4176 | i0 | 31.6 | 0.500527983104541 | 158 | 90 | 49.4 | 3 | 745 | 278 | 115 | 256 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 474 | 71.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30498506 | 30498506 | PRJNA914897_P_NODE_11693_length_540_cov_1.633833_g11273_i0 | PRJNA914897 | 11693 | 540 | 1.633833 | 8.8226982 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 50.4 | 4.05e-4 | NR | MDQ6655298.1 | 2026799 | g11273 | i0 | 30.6 | 0.616666666666667 | 111 | 72 | 61.7 | 2 | 39 | 371 | 32 | 137 | MDQ6655298.1 FHA domain-containing protein [Verrucomicrobiota bacterium] | diamond | 333 | 50.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31794319 | 31794319 | PRJNA914897_P_NODE_30037_length_288_cov_1.241860_g29613_i0 | PRJNA914897 | 30037 | 288 | 1.24186 | 3.5765568 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 126 | 1.3499999999999998e-31 | NR | HYG84357.1 | 2499141 | g29613 | i0 | 65.5 | 0.90625 | 87 | 30 | 90.6 | 0 | 285 | 25 | 218 | 304 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 261 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31833346 | 31833346 | PRJNA914897_P_NODE_32917_length_271_cov_1.757576_g32493_i0 | PRJNA914897 | 32917 | 271 | 1.757576 | 4.76303096 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.5 | 5.22e-10 | NR | MBS0652631.1 | 2026799 | g32493 | i0 | 48 | 1.66051660516605 | 75 | 33 | 79.7 | 3 | 255 | 40 | 192 | 263 | MBS0652631.1 glycosyltransferase family 2 protein [Verrucomicrobiota bacterium] | diamond | 450 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32150008 | 32150008 | PRJNA914897_P_NODE_26718_length_312_cov_1.828452_g26294_i0 | PRJNA914897 | 26718 | 312 | 1.828452 | 5.70477024 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 63.9 | 1.78e-9 | NR | HUF62473.1 | 2026801 | g26294 | i0 | 48.1 | 2.08653846153846 | 52 | 25 | 50 | 1 | 225 | 70 | 22 | 71 | HUF62473.1 thioredoxin [Verrucomicrobiales bacterium] | diamond | 651 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales 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);;