contig_metadata
26 rows where bioproject = "PRJEB41113", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5161385 | 5161385 | PRJEB41113_S_NODE_12465_length_154_cov_0.940171_g12456_i0 | PRJEB41113 | 12465 | 154 | 0.940171 | 1.44786334 | Verrucomicrobiaceae | 203557 | Bacteria | Bacteria | 98.2 | 3.26e-22 | NR | WP_050028726.1 | 1396418 | g12456 | i0 | 93.9 | 8.59090909090909 | 49 | 3 | 95.5 | 0 | 148 | 2 | 18 | 66 | WP_050028726.1 fumarate reductase/succinate dehydrogenase flavoprotein subunit [Verrucomicrobium sp. BvORR034] | diamond | 1323 | 99 | 0.991919191919192 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium sp. BvORR034 | |
| 11537306 | 11537306 | PRJEB41113_S_NODE_15470_length_150_cov_1.017699_g15461_i0 | PRJEB41113 | 15470 | 150 | 1.017699 | 1.5265485 | Horticoccus sp. 23ND18S-11 | 3391832 | Bacteria | Bacteria | 78.6 | 2.39e-15 | NR | WP_414662907.1 | 3391832 | g15461 | i0 | 93 | 0.86 | 43 | 3 | 86 | 0 | 18 | 146 | 725 | 767 | WP_414662907.1 DUF1553 domain-containing protein [Horticoccus sp. 23ND18S-11] | diamond | 129 | 78.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Horticoccus | Horticoccus sp. 23ND18S-11 | |
| 14087516 | 14087516 | PRJEB41113_S_NODE_5692_length_183_cov_1.595890_g5683_i0 | PRJEB41113 | 5692 | 183 | 1.59589 | 2.9204787 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 105 | 1.1399999999999999e-24 | NR | PYK80264.1 | 2026799 | g5683 | i0 | 96 | 2.45901639344262 | 50 | 2 | 82 | 0 | 150 | 1 | 1 | 50 | PYK80264.1 MAG: MFS transporter [Verrucomicrobiota bacterium] | diamond | 450 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 17910697 | 17910697 | PRJEB41113_S_NODE_4035_length_194_cov_13.363057_g4026_i0 | PRJEB41113 | 4035 | 194 | 13.363057 | 25.92433058 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 337 | 4.13e-88 | NTclustered | gi|226525339|gb|FJ872375.1| | 156588 | g4026 | i0 | 97.938 | 68.5257731958763 | 194 | 4 | 100 | 0 | 1 | 194 | 28649 | 28456 | Uncultured Verrucomicrobia bacterium clone 286 genomic sequence | blastn | 13294 | 337 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 25215954 | 25215954 | PRJEB41113_S_NODE_260_length_353_cov_163826.895570_g251_i0 | PRJEB41113 | 260 | 353 | 163826.89557 | 578308.9413621 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 129 | 9.52e-34 | NR | NLH73032.1 | 2026799 | g251 | i0 | 74.4 | 0.730878186968839 | 86 | 22 | 73.1 | 0 | 353 | 96 | 248 | 333 | NLH73032.1 NAD(P)-dependent alcohol dehydrogenase [Verrucomicrobiota bacterium] | diamond | 258 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26615083 | 26615083 | PRJEB41113_S_NODE_3021_length_207_cov_4.500000_g3012_i0 | PRJEB41113 | 3021 | 207 | 4.5 | 9.315 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 120 | 1.01e-31 | NR | WP_009962404.1 | 2736 | g3012 | i0 | 87.7 | 6.59420289855072 | 65 | 8 | 94.2 | 0 | 196 | 2 | 52 | 116 | WP_009962404.1 hypothetical protein [Verrucomicrobium spinosum] | diamond | 1365 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 26780372 | 26780372 | PRJEB41113_S_NODE_10961_length_157_cov_3.058333_g10952_i0 | PRJEB41113 | 10961 | 157 | 3.058333 | 4.80158281 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 50.4 | 2.1e-6 | NR | MCZ7636652.1 | 2026799 | g10952 | i0 | 85.7 | 0.535031847133758 | 28 | 4 | 53.5 | 0 | 86 | 3 | 42 | 69 | MCZ7636652.1 UPF0175 family protein [Verrucomicrobiota bacterium] | diamond | 84 | 50.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26906920 | 26906920 | PRJEB41113_S_NODE_1102_length_257_cov_5.472727_g1093_i0 | PRJEB41113 | 1102 | 257 | 5.472727 | 14.06490839 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 183 | 1.45e-56 | NR | PYK75288.1 | 2026799 | g1093 | i0 | 96.5 | 2.97665369649805 | 85 | 3 | 99.2 | 0 | 257 | 3 | 39 | 123 | PYK75288.1 MAG: hypothetical protein DME42_02880 [Verrucomicrobiota bacterium] | diamond | 765 | 183 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27191371 | 27191371 | PRJEB41113_S_NODE_15262_length_150_cov_3.327434_g15253_i0 | PRJEB41113 | 15262 | 150 | 3.327434 | 4.991151 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 68.2 | 1.02e-11 | NR | HEX4639883.1 | 2201154 | g15253 | i0 | 97.1 | 0.7 | 35 | 1 | 70 | 0 | 30 | 134 | 355 | 389 | HEX4639883.1 cysteine desulfurase NifS [Chthoniobacterales bacterium] | diamond | 105 | 68.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 27286303 | 27286303 | PRJEB41113_S_NODE_4723_length_189_cov_4.506579_g4714_i0 | PRJEB41113 | 4723 | 189 | 4.506579 | 8.51743431 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 88.6 | 5.5e-19 | NR | MCU0749161.1 | 2562705 | g4714 | i0 | 79.6 | 0.857142857142857 | 54 | 11 | 85.7 | 0 | 11 | 172 | 297 | 350 | MCU0749161.1 HAD hydrolase-like protein [Akkermansiaceae bacterium] | diamond | 162 | 88.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 27981106 | 27981106 | PRJEB41113_S_NODE_12365_length_154_cov_1.871795_g12356_i0 | PRJEB41113 | 12365 | 154 | 1.871795 | 2.8825643 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 79.3 | 1.34e-15 | NR | MBL9209078.1 | 2006848 | g12356 | i0 | 90.7 | 1.67532467532468 | 43 | 4 | 83.8 | 0 | 24 | 152 | 1 | 43 | MBL9209078.1 alpha-glucan family phosphorylase [Opitutaceae bacterium] | diamond | 258 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 28069081 | 28069081 | PRJEB41113_S_NODE_9565_length_161_cov_3.959677_g9556_i0 | PRJEB41113 | 9565 | 161 | 3.959677 | 6.37507997 | Bacteria | 2 | Bacteria | Bacteria | 79.3 | 1.53e-15 | NR | PYK75258.1 | 2026799 | g9556 | i0 | 64.8 | 1.97515527950311 | 54 | 17 | 96.9 | 1 | 159 | 4 | 649 | 702 | PYK75258.1 MAG: hypothetical protein DME42_03025, partial [Verrucomicrobiota bacterium] | diamond | 318 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28170489 | 28170489 | PRJEB41113_S_NODE_806_length_274_cov_4.767932_g797_i0 | PRJEB41113 | 806 | 274 | 4.767932 | 13.06413368 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 51.2 | 5.43e-5 | NR | QTN31265.1 | 2562705 | g797 | i0 | 29.8 | 1.02919708029197 | 94 | 52 | 97.4 | 2 | 1 | 267 | 112 | 196 | QTN31265.1 hypothetical protein HZ994_02600 [Akkermansiaceae bacterium] | diamond | 282 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 28549578 | 28549578 | PRJEB41113_S_NODE_7527_length_171_cov_2.686567_g7518_i0 | PRJEB41113 | 7527 | 171 | 2.686567 | 4.59402957 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 77.8 | 6.06e-15 | NR | HVU35120.1 | 2006848 | g7518 | i0 | 62.5 | 1.96491228070175 | 56 | 21 | 98.2 | 0 | 2 | 169 | 178 | 233 | HVU35120.1 hypothetical protein [Opitutaceae bacterium] | diamond | 336 | 77.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 28865077 | 28865077 | PRJEB41113_S_NODE_9388_length_162_cov_2.248000_g9379_i0 | PRJEB41113 | 9388 | 162 | 2.248 | 3.64176 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 76.3 | 4.87e-15 | NR | PYK80681.1 | 2026799 | g9379 | i0 | 92.5 | 0.740740740740741 | 40 | 3 | 74.1 | 0 | 162 | 43 | 191 | 230 | PYK80681.1 MAG: YggS family pyridoxal phosphate-dependent enzyme [Verrucomicrobiota bacterium] | diamond | 120 | 76.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29528260 | 29528260 | PRJEB41113_S_NODE_610_length_292_cov_4.050980_g601_i0 | PRJEB41113 | 610 | 292 | 4.05098 | 11.8288616 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 73.9 | 7.849999999999999e-14 | NR | PYL00618.1 | 2026799 | g601 | i0 | 68.8 | 1.47945205479452 | 48 | 15 | 49.3 | 0 | 18 | 161 | 115 | 162 | PYL00618.1 MAG: hypothetical protein DME32_10570 [Verrucomicrobiota bacterium] | diamond | 432 | 73.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29654086 | 29654086 | PRJEB41113_S_NODE_10950_length_157_cov_3.391667_g10941_i0 | PRJEB41113 | 10950 | 157 | 3.391667 | 5.32491719 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 99 | 1.84e-22 | NR | PYL00384.1 | 2026799 | g10941 | i0 | 90.4 | 1.98726114649682 | 52 | 5 | 99.4 | 0 | 1 | 156 | 760 | 811 | PYL00384.1 MAG: aconitate hydratase [Verrucomicrobiota bacterium] | diamond | 312 | 99 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29654090 | 29654090 | PRJEB41113_S_NODE_5190_length_186_cov_2.503356_g5181_i0 | PRJEB41113 | 5190 | 186 | 2.503356 | 4.65624216 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 122 | 5.91e-34 | NR | PYL02402.1 | 2026799 | g5181 | i0 | 96.4 | 1.80645161290323 | 56 | 2 | 90.3 | 0 | 186 | 19 | 86 | 141 | PYL02402.1 MAG: hypothetical protein DME32_06540, partial [Verrucomicrobiota bacterium] | diamond | 336 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29843916 | 29843916 | PRJEB41113_S_NODE_11411_length_156_cov_1.521008_g11402_i0 | PRJEB41113 | 11411 | 156 | 1.521008 | 2.37277248 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 80.5 | 5.5e-16 | NR | PYK98345.1 | 2026799 | g11402 | i0 | 72.5 | 0.980769230769231 | 51 | 14 | 98.1 | 0 | 155 | 3 | 541 | 591 | PYK98345.1 MAG: hypothetical protein DME32_14405 [Verrucomicrobiota bacterium] | diamond | 153 | 80.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30222960 | 30222960 | PRJEB41113_S_NODE_6872_length_175_cov_2.869565_g6863_i0 | PRJEB41113 | 6872 | 175 | 2.869565 | 5.02173875 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 48.9 | 9.09e-5 | NR | PYJ39391.1 | 2026799 | g6863 | i0 | 50.9 | 3.89142857142857 | 57 | 22 | 90.9 | 2 | 16 | 174 | 33 | 87 | PYJ39391.1 MAG: HNH endonuclease [Verrucomicrobiota bacterium] | diamond | 681 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30563606 | 30563606 | PRJEB41113_S_NODE_6273_length_179_cov_2.154930_g6264_i0 | PRJEB41113 | 6273 | 179 | 2.15493 | 3.8573247 | Bacteria | 2 | Bacteria | Bacteria | 82 | 1.79e-18 | NR | PYK80061.1 | 2026799 | g6264 | i0 | 100 | 2.74860335195531 | 41 | 0 | 68.7 | 0 | 2 | 124 | 67 | 107 | PYK80061.1 MAG: thioredoxin [Verrucomicrobiota bacterium] | diamond | 492 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30658705 | 30658705 | PRJEB41113_S_NODE_12373_length_154_cov_1.777778_g12364_i0 | PRJEB41113 | 12373 | 154 | 1.777778 | 2.73777812 | Bacteria | 2 | Bacteria | Bacteria | 106 | 1.03e-26 | NR | PYI78415.1 | 2026799 | g12364 | i0 | 90 | 2.9025974025974 | 50 | 5 | 97.4 | 0 | 3 | 152 | 24 | 73 | PYI78415.1 MAG: hypothetical protein DMF04_03410, partial [Verrucomicrobiota bacterium] | diamond | 447 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31645148 | 31645148 | PRJEB41113_S_NODE_6717_length_176_cov_2.309353_g6708_i0 | PRJEB41113 | 6717 | 176 | 2.309353 | 4.06446128 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 63.9 | 2.98e-10 | NR | MDB6035164.1 | 2026801 | g6708 | i0 | 49.1 | 1.96022727272727 | 57 | 29 | 97.2 | 0 | 174 | 4 | 95 | 151 | MDB6035164.1 transposase family protein [Verrucomicrobiales bacterium] | diamond | 345 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 32310000 | 32310000 | PRJEB41113_S_NODE_1819_length_231_cov_2.804124_g1810_i0 | PRJEB41113 | 1819 | 231 | 2.804124 | 6.47752644 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 72 | 1.49e-12 | NR | KAB2645041.1 | 2026799 | g1810 | i0 | 44.7 | 0.987012987012987 | 76 | 42 | 98.7 | 0 | 3 | 230 | 142 | 217 | KAB2645041.1 MAG: lipopolysaccharide biosynthesis protein [Verrucomicrobiota bacterium] | diamond | 228 | 72 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32468145 | 32468145 | PRJEB41113_S_NODE_10499_length_158_cov_13.611570_g10490_i0 | PRJEB41113 | 10499 | 158 | 13.61157 | 21.5062806 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 59.7 | 1.2e-8 | NR | HET7227175.1 | 2201154 | g10490 | i0 | 80.5 | 0.778481012658228 | 41 | 8 | 77.8 | 0 | 2 | 124 | 415 | 455 | HET7227175.1 cytochrome bc complex cytochrome b subunit [Chthoniobacterales bacterium] | diamond | 123 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32688641 | 32688641 | PRJEB41113_S_NODE_720_length_281_cov_2.893443_g711_i0 | PRJEB41113 | 720 | 281 | 2.893443 | 8.13057483 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 103 | 1.08e-25 | NR | MEY4485109.1 | 2026799 | g711 | i0 | 88.1 | 0.629893238434164 | 59 | 6 | 61.9 | 1 | 2 | 175 | 94 | 152 | MEY4485109.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 177 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota 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);;