contig_metadata
28 rows where bioproject = "PRJNA908278", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7268370 | 7268370 | PRJNA908278_P_NODE_22246_length_275_cov_1.425743_g22143_i0 | PRJNA908278 | 22246 | 275 | 1.425743 | 3.92079325 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 86.7 | 7.36e-18 | NR | MBT3293848.1 | 2026799 | g22143 | i0 | 48.4 | 9.52363636363636 | 91 | 42 | 99.3 | 1 | 2 | 274 | 197 | 282 | MBT3293848.1 3'(2'),5'-bisphosphate nucleotidase [Verrucomicrobiota bacterium] | diamond | 2619 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 20017026 | 20017026 | PRJNA908278_P_NODE_8436_length_411_cov_1.594675_g8333_i0 | PRJNA908278 | 8436 | 411 | 1.594675 | 6.55411425 | Bacteria | 2 | Bacteria | Bacteria | 175 | 1.18e-50 | NR | MDR3815495.1 | 1872421 | g8333 | i0 | 60.3 | 20.7445255474453 | 131 | 52 | 95.6 | 0 | 19 | 411 | 33 | 163 | MDR3815495.1 phosphoenolpyruvate carboxykinase (GTP) [Akkermansia sp.] | diamond | 8526 | 176 | 0.994318181818182 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 26644306 | 26644306 | PRJNA908278_P_NODE_18641_length_296_cov_1.461883_g18538_i0 | PRJNA908278 | 18641 | 296 | 1.461883 | 4.32717368 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 44.3 | 0.0198 | NR | HZE57439.1 | 2201154 | g18538 | i0 | 35.8 | 0.679054054054054 | 67 | 43 | 67.9 | 0 | 87 | 287 | 266 | 332 | HZE57439.1 CAP domain-containing protein [Chthoniobacterales bacterium] | diamond | 201 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 26675877 | 26675877 | PRJNA908278_P_NODE_20321_length_286_cov_1.244131_g20218_i0 | PRJNA908278 | 20321 | 286 | 1.244131 | 3.55821466 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 94.4 | 1.05e-20 | NR | MFM1941488.1 | 2026799 | g20218 | i0 | 46.2 | 5.67482517482518 | 93 | 50 | 97.6 | 0 | 279 | 1 | 189 | 281 | MFM1941488.1 Choline-sulfatase [Verrucomicrobiota bacterium] | diamond | 1623 | 94.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26842196 | 26842196 | PRJNA908278_P_NODE_31661_length_245_cov_0.895349_g31558_i0 | PRJNA908278 | 31661 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 113 | 1.2799999999999999e-28 | NR | SPE59516.1 | 2026799 | g31558 | i0 | 69.1 | 7.93469387755102 | 81 | 25 | 99.2 | 0 | 1 | 243 | 137 | 217 | SPE59516.1 Uncharacterized oxidoreductase YvaG [Verrucomicrobiota bacterium] | diamond | 1944 | 114 | 0.991228070175439 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27157984 | 27157984 | PRJNA908278_P_NODE_5162_length_510_cov_3.304348_g5059_i0 | PRJNA908278 | 5162 | 510 | 3.304348 | 16.8521748 | root | 1 | Root_unresolved | Root_unresolved | 133 | 1.38e-32 | NR | MEO1825153.1 | 2024856 | g5059 | i0 | 44.7 | 4.59411764705882 | 152 | 77 | 87.1 | 5 | 53 | 496 | 665 | 813 | MEO1825153.1 Kazal-type serine protease inhibitor domain-containing protein [Roseibacillus sp.] | diamond | 2343 | 134 | 0.992537313432836 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseibacillus | Roseibacillus sp. | |
| 27189784 | 27189784 | PRJNA908278_P_NODE_33702_length_243_cov_0.905882_g33599_i0 | PRJNA908278 | 33702 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 50.1 | 9.24e-5 | NR | MBV9733672.1 | 2026799 | g33599 | i0 | 45.9 | 3.87654320987654 | 74 | 38 | 88.9 | 2 | 15 | 230 | 290 | 363 | MBV9733672.1 ABC transporter substrate-binding protein [Verrucomicrobiota bacterium] | diamond | 942 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27853089 | 27853089 | PRJNA908278_P_NODE_18024_length_301_cov_1.179825_g17921_i0 | PRJNA908278 | 18024 | 301 | 1.179825 | 3.55127325 | root | 1 | Root_unresolved | Root_unresolved | 113 | 6.3e-27 | NR | WP_184341484.1 | 48466 | g17921 | i0 | 59.4 | 6.8671096345515 | 101 | 38 | 97.7 | 2 | 295 | 2 | 18 | 118 | WP_184341484.1 UTP--glucose-1-phosphate uridylyltransferase [Prosthecobacter vanneervenii] | diamond | 2067 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 28035242 | 28035242 | PRJNA908278_P_NODE_18245_length_299_cov_1.362832_g18142_i0 | PRJNA908278 | 18245 | 299 | 1.362832 | 4.07486768 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 121 | 2.3199999999999997e-30 | NR | MCX7712056.1 | 2201154 | g18142 | i0 | 58 | 1.00334448160535 | 100 | 41 | 99.3 | 1 | 298 | 2 | 207 | 306 | MCX7712056.1 diaminopimelate decarboxylase [Chthoniobacterales bacterium] | diamond | 300 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 28035246 | 28035246 | PRJNA908278_P_NODE_2005_length_780_cov_11.287129_g1912_i0 | PRJNA908278 | 2005 | 780 | 11.287129 | 88.0396062 | Rubritalea spongiae | 430797 | Bacteria | Bacteria | 196 | 2.17e-56 | NR | WP_377092613.1 | 430797 | g1912 | i0 | 52.5 | 1.52307692307692 | 198 | 85 | 74.6 | 5 | 632 | 51 | 210 | 402 | WP_377092613.1 glycoside hydrolase family 75 protein [Rubritalea spongiae] | diamond | 1188 | 196 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Rubritaleaceae | Rubritalea | Rubritalea spongiae | |
| 28350829 | 28350829 | PRJNA908278_P_NODE_28226_length_249_cov_0.875000_g28123_i0 | PRJNA908278 | 28226 | 249 | 0.875 | 2.17875 | Pedosphaera sp. | 2024890 | Bacteria | Bacteria | 64.3 | 4.63e-10 | NR | MDB6112030.1 | 2024890 | g28123 | i0 | 37.8 | 0.987951807228916 | 82 | 46 | 94 | 2 | 1 | 234 | 131 | 211 | MDB6112030.1 lipase class 3 [Pedosphaera sp.] | diamond | 246 | 64.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. | |
| 28737289 | 28737289 | PRJNA908278_P_NODE_9247_length_395_cov_0.757764_g9144_i0 | PRJNA908278 | 9247 | 395 | 0.757764 | 2.9931678 | Bacteria | 2 | Bacteria | Bacteria | 176 | 2e-49 | NR | HVS51339.1 | 2006848 | g9144 | i0 | 62.6 | 11.9392405063291 | 131 | 49 | 99.5 | 0 | 3 | 395 | 382 | 512 | HVS51339.1 NAD-dependent malic enzyme [Opitutaceae bacterium] | diamond | 4716 | 177 | 0.994350282485876 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 29298113 | 29298113 | PRJNA908278_P_NODE_11629_length_360_cov_5.898955_g11526_i0 | PRJNA908278 | 11629 | 360 | 5.898955 | 21.236238 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 62 | 1.25e-9 | NR | MDA0346509.1 | 2026799 | g11526 | i0 | 44.6 | 0.9 | 56 | 29 | 46.7 | 1 | 80 | 247 | 18 | 71 | MDA0346509.1 thioredoxin [Verrucomicrobiota bacterium] | diamond | 324 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29455581 | 29455581 | PRJNA908278_P_NODE_11290_length_365_cov_1.054795_g11187_i0 | PRJNA908278 | 11290 | 365 | 1.054795 | 3.85000175 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 79 | 3.1e-14 | NR | MDB4537232.1 | 2562705 | g11187 | i0 | 46.2 | 2.12054794520548 | 93 | 42 | 71.5 | 3 | 266 | 6 | 164 | 254 | MDB4537232.1 serine/threonine protein kinase [Akkermansiaceae bacterium] | diamond | 774 | 79 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 29487362 | 29487362 | PRJNA908278_P_NODE_29530_length_248_cov_0.880000_g29427_i0 | PRJNA908278 | 29530 | 248 | 0.88 | 2.1824 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 78.6 | 9.8e-15 | NR | PYK02913.1 | 2026799 | g29427 | i0 | 57 | 2.84274193548387 | 79 | 31 | 95.6 | 1 | 4 | 240 | 45 | 120 | PYK02913.1 MAG: hypothetical protein DME23_00700 [Verrucomicrobiota bacterium] | diamond | 705 | 78.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29645005 | 29645005 | PRJNA908278_P_NODE_31150_length_246_cov_0.890173_g31047_i0 | PRJNA908278 | 31150 | 246 | 0.890173 | 2.18982558 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 55.8 | 9.25e-7 | NR | MFM2297213.1 | 2026799 | g31047 | i0 | 42 | 0.98780487804878 | 81 | 47 | 98.8 | 0 | 3 | 245 | 736 | 816 | MFM2297213.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 243 | 55.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29929807 | 29929807 | PRJNA908278_P_NODE_1671_length_845_cov_5.546632_g1587_i0 | PRJNA908278 | 1671 | 845 | 5.546632 | 46.8690404 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 57.4 | 3.19e-5 | NR | WP_348214599.1 | 1962973 | g1587 | i0 | 27.7 | 0.67810650887574 | 191 | 115 | 65.3 | 9 | 585 | 34 | 318 | 492 | WP_348214599.1 RICIN domain-containing protein [Luteolibacter sp.] | diamond | 573 | 57.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 29961185 | 29961185 | PRJNA908278_P_NODE_20251_length_286_cov_1.446009_g20148_i0 | PRJNA908278 | 20251 | 286 | 1.446009 | 4.13558574 | Puniceicoccus vermicola | 388746 | Bacteria | Bacteria | 103 | 1.9499999999999994e-23 | NR | WP_185694143.1 | 388746 | g20148 | i0 | 65.9 | 2.67482517482518 | 85 | 28 | 89.2 | 1 | 286 | 32 | 738 | 821 | WP_185694143.1 FAD-dependent oxidoreductase [Puniceicoccus vermicola] | diamond | 765 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Puniceicoccaceae | Puniceicoccus | Puniceicoccus vermicola | |
| 30245775 | 30245775 | PRJNA908278_P_NODE_22412_length_274_cov_1.378109_g22309_i0 | PRJNA908278 | 22412 | 274 | 1.378109 | 3.77601866 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 59.3 | 2.73e-8 | NR | HWB59675.1 | 2811408 | g22309 | i0 | 44.8 | 0.952554744525547 | 87 | 42 | 95.3 | 3 | 9 | 269 | 58 | 138 | HWB59675.1 hypothetical protein [Chthoniobacteraceae bacterium] | diamond | 261 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 30505859 | 30505859 | PRJNA908278_P_NODE_12153_length_354_cov_1.096085_g12050_i0 | PRJNA908278 | 12153 | 354 | 1.096085 | 3.8801409 | Bacteria | 2 | Bacteria | Bacteria | 65.5 | 3.58e-10 | NR | WP_039721357.1 | 431057 | g12050 | i0 | 34.7 | 4.63559322033898 | 118 | 68 | 92.4 | 2 | 5 | 331 | 4 | 121 | WP_039721357.1 MIP/aquaporin family protein [Methylacidiphilum kamchatkense] | diamond | 1641 | 65.9 | 0.993930197268589 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Methylacidiphilae | Methylacidiphilales | Methylacidiphilaceae | Methylacidiphilum (ex Ratnadevi et al. 2023) | Methylacidiphilum kamchatkense | |
| 30561262 | 30561262 | PRJNA908278_P_NODE_11093_length_367_cov_1.534014_g10990_i0 | PRJNA908278 | 11093 | 367 | 1.534014 | 5.62983138 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 165 | 4.97e-46 | NR | HEV7923786.1 | 2499141 | g10990 | i0 | 58.9 | 2.02724795640327 | 124 | 48 | 98.9 | 2 | 365 | 3 | 359 | 482 | HEV7923786.1 glycosyl hydrolase family 28-related protein [Verrucomicrobiia bacterium] | diamond | 744 | 165 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30782678 | 30782678 | PRJNA908278_P_NODE_30154_length_247_cov_0.885057_g30051_i0 | PRJNA908278 | 30154 | 247 | 0.885057 | 2.18609079 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 73.2 | 2.02e-13 | NR | MDH4454272.1 | 2026799 | g30051 | i0 | 54.1 | 0.898785425101215 | 74 | 32 | 89.9 | 1 | 17 | 238 | 22 | 93 | MDH4454272.1 ubiquitin-like protein [Verrucomicrobiota bacterium] | diamond | 222 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31509899 | 31509899 | PRJNA908278_P_NODE_25076_length_258_cov_1.664865_g24973_i0 | PRJNA908278 | 25076 | 258 | 1.664865 | 4.2953517 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 51.2 | 4.3e-5 | NR | MBU6383445.1 | 2026799 | g24973 | i0 | 38.8 | 1.80232558139535 | 80 | 41 | 83.7 | 2 | 217 | 2 | 218 | 297 | MBU6383445.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 465 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31509907 | 31509907 | PRJNA908278_P_NODE_34536_length_242_cov_0.911243_g34433_i0 | PRJNA908278 | 34536 | 242 | 0.911243 | 2.20520806 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 54.3 | 3.19e-6 | NR | MDI9401759.1 | 2026799 | g34433 | i0 | 43.7 | 3.65702479338843 | 71 | 34 | 80.6 | 2 | 38 | 232 | 842 | 912 | MDI9401759.1 S8 family serine peptidase [Verrucomicrobiota bacterium] | diamond | 885 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32237699 | 32237699 | PRJNA908278_P_NODE_32678_length_244_cov_0.900585_g32575_i0 | PRJNA908278 | 32678 | 244 | 0.900585 | 2.1974274 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 82.8 | 2.81e-16 | NR | MBU4200851.1 | 2026799 | g32575 | i0 | 54.4 | 0.971311475409836 | 79 | 32 | 97.1 | 2 | 6 | 242 | 374 | 448 | MBU4200851.1 carbohydrate kinase [Verrucomicrobiota bacterium] | diamond | 237 | 82.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32395636 | 32395636 | PRJNA908278_P_NODE_2899_length_661_cov_2.323129_g2796_i0 | PRJNA908278 | 2899 | 661 | 2.3231290000000002 | 15.35588269 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 184 | 9.4e-53 | NR | HEV7924992.1 | 2499141 | g2796 | i0 | 53.4 | 2.90922844175492 | 176 | 79 | 79 | 2 | 137 | 658 | 7 | 181 | HEV7924992.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 1923 | 184 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32554059 | 32554059 | PRJNA908278_P_NODE_26499_length_251_cov_0.865169_g26396_i0 | PRJNA908278 | 26499 | 251 | 0.865169 | 2.17157419 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 126 | 2.96e-33 | NR | MBT3470899.1 | 2026771 | g26396 | i0 | 72.7 | 0.920318725099602 | 77 | 21 | 92 | 0 | 1 | 231 | 108 | 184 | MBT3470899.1 Gfo/Idh/MocA family oxidoreductase [Opitutia bacterium] | diamond | 231 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 32868610 | 32868610 | PRJNA908278_P_NODE_13960_length_335_cov_1.175573_g13857_i0 | PRJNA908278 | 13960 | 335 | 1.175573 | 3.93816955 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 68.6 | 9.6e-11 | NR | MBL9131746.1 | 2026800 | g13857 | i0 | 39.8 | 0.967164179104478 | 108 | 57 | 90.4 | 3 | 304 | 2 | 594 | 700 | MBL9131746.1 nucleoside hydrolase [Verrucomicrobiaceae bacterium] | diamond | 324 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae 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);;