contig_metadata
23 rows where bioproject = "PRJNA550047", tax_kingdom = "Bacillati" and tax_phylum = "Vulcanimicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3064992 | 3064992 | PRJNA550047_P_NODE_248603_length_300_cov_9.960352_g246634_i0 | PRJNA550047 | 248603 | 300 | 9.960352 | 29.881056 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 139 | 2.08e-28 | NTclustered | gi|2874253918|emb|OY970243.1| | 3107663 | g246634 | i0 | 82.558 | 18.5833333333333 | 172 | 17 | 56 | 10 | 8 | 174 | 59067 | 58904 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 | blastn | 5575 | 139 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 3069713 | 3069713 | PRJNA550047_P_NODE_89043_length_345_cov_9.562500_g87083_i0 | PRJNA550047 | 89043 | 345 | 9.5625 | 32.990625 | Candidatus Elarobacter sp. | 3047550 | Bacteria | Bacteria | 85.9 | 4.98e-17 | NR | HTD26928.1 | 3047550 | g87083 | i0 | 84 | 1.73913043478261 | 50 | 8 | 43.5 | 0 | 151 | 2 | 234 | 283 | HTD26928.1 hypothetical protein [Candidatus Elarobacter sp.] | diamond | 600 | 85.9 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Elarobacter | Candidatus Elarobacter sp. | ||
| 6895241 | 6895241 | PRJNA550047_P_NODE_516306_length_225_cov_7.138158_g514333_i0 | PRJNA550047 | 516306 | 225 | 7.138158 | 16.0608555 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 193 | 1.13e-44 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g514333 | i0 | 86.441 | 91.4266666666667 | 177 | 23 | 79 | 1 | 1 | 177 | 5031750 | 5031575 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 20571 | 193 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 9442047 | 9442047 | PRJNA550047_P_NODE_208128_length_317_cov_15.926230_g206160_i0 | PRJNA550047 | 208128 | 317 | 15.92623 | 50.4861491 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 475 | 1.49e-129 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g206160 | i0 | 93.711 | 598.826498422713 | 318 | 19 | 100 | 1 | 1 | 317 | 5032101 | 5031784 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 189828 | 475 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 9447081 | 9447081 | PRJNA550047_P_NODE_82508_length_345_cov_10.363971_g80548_i0 | PRJNA550047 | 82508 | 345 | 10.363971 | 35.75569995 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 130 | 1.47e-25 | NTclustered | gi|2874253918|emb|OY970243.1| | 3107663 | g80548 | i0 | 82.667 | 16.1275362318841 | 150 | 23 | 43 | 3 | 2 | 149 | 117038 | 117186 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 | blastn | 5564 | 130 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 10719706 | 10719706 | PRJNA550047_P_NODE_360989_length_280_cov_13.652174_g359018_i0 | PRJNA550047 | 360989 | 280 | 13.652174 | 38.2260872 | Candidatus Eremiobacteraceae bacterium | 3069296 | Bacteria | Bacteria | 159 | 2.34e-45 | NR | HXX16407.1 | 3069296 | g359018 | i0 | 82.8 | 4.98214285714286 | 93 | 16 | 99.6 | 0 | 1 | 279 | 137 | 229 | HXX16407.1 IS5 family transposase [Candidatus Eremiobacteraceae bacterium] | diamond | 1395 | 159 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Candidatus Eremiobacterales | Candidatus Eremiobacteraceae | Candidatus Eremiobacteraceae bacterium | |||
| 10721361 | 10721361 | PRJNA550047_P_NODE_503909_length_229_cov_8.089744_g501936_i0 | PRJNA550047 | 503909 | 229 | 8.089744 | 18.52551376 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 187 | 5.37e-43 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g501936 | i0 | 82.174 | 5.58078602620087 | 230 | 30 | 97 | 10 | 6 | 227 | 5032833 | 5032607 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 1278 | 187 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 11993327 | 11993327 | PRJNA550047_P_NODE_277670_length_299_cov_5.942478_g275701_i0 | PRJNA550047 | 277670 | 299 | 5.942478 | 17.76800922 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 122 | 2.0899999999999994e-23 | NTclustered | gi|2874254122|emb|OY970207.1| | 3107663 | g275701 | i0 | 82.609 | 0.919732441471572 | 138 | 24 | 46 | 0 | 153 | 290 | 2789831 | 2789968 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1 | blastn | 275 | 122 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 20918076 | 20918076 | PRJNA550047_P_NODE_399557_length_265_cov_7.505208_g397585_i0 | PRJNA550047 | 399557 | 265 | 7.505208 | 19.8888012 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 132 | 3.83e-36 | NR | MFN8613536.1 | 3107663 | g397585 | i0 | 77.9 | 0.973584905660377 | 86 | 19 | 97.4 | 0 | 263 | 6 | 55 | 140 | MFN8613536.1 ABC transporter ATP-binding protein [Vulcanimicrobiota bacterium] | diamond | 258 | 132 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 24740932 | 24740932 | PRJNA550047_P_NODE_311740_length_295_cov_18.545045_g309771_i0 | PRJNA550047 | 311740 | 295 | 18.545044999999998 | 54.70788275 | Candidatus Elarobacter sp. | 3047550 | Bacteria | Bacteria | 75.5 | 9.37e-14 | NR | HTD27462.1 | 3047550 | g309771 | i0 | 75.5 | 0.996610169491525 | 49 | 12 | 49.8 | 0 | 149 | 3 | 168 | 216 | HTD27462.1 DUF3131 domain-containing protein [Candidatus Elarobacter sp.] | diamond | 294 | 75.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Elarobacter | Candidatus Elarobacter sp. | ||
| 27362937 | 27362937 | PRJNA550047_P_NODE_88923_length_345_cov_9.577206_g86963_i0 | PRJNA550047 | 88923 | 345 | 9.577206 | 33.0413607 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 81.6 | 8.27e-18 | NR | HKU69134.1 | 2952909 | g86963 | i0 | 81.4 | 0.373913043478261 | 43 | 8 | 37.4 | 0 | 21 | 149 | 4 | 46 | HKU69134.1 CDGSH iron-sulfur domain-containing protein [Candidatus Baltobacteraceae bacterium] | diamond | 129 | 81.6 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 27836046 | 27836046 | PRJNA550047_P_NODE_368004_length_277_cov_20.289216_g366033_i0 | PRJNA550047 | 368004 | 277 | 20.289216 | 56.20112832 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 80.1 | 2.35e-15 | NR | MFN8612733.1 | 3107663 | g366033 | i0 | 47.7 | 0.931407942238267 | 86 | 45 | 93.1 | 0 | 20 | 277 | 49 | 134 | MFN8612733.1 type II secretion system F family protein [Vulcanimicrobiota bacterium] | diamond | 258 | 80.1 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 28152119 | 28152119 | PRJNA550047_P_NODE_387705_length_270_cov_2.142132_g385733_i0 | PRJNA550047 | 387705 | 270 | 2.142132 | 5.7837564 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 73.9 | 5.25e-13 | NR | MFA7480541.1 | 3107663 | g385733 | i0 | 46.9 | 0.9 | 81 | 42 | 90 | 1 | 248 | 6 | 397 | 476 | MFA7480541.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 243 | 73.9 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 28499404 | 28499404 | PRJNA550047_P_NODE_414047_length_259_cov_16.403226_g412075_i0 | PRJNA550047 | 414047 | 259 | 16.403226 | 42.48435534 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 44.3 | 0.00652 | NR | HYM31810.1 | 2952917 | g412075 | i0 | 64.9 | 0.428571428571429 | 37 | 13 | 42.9 | 0 | 40 | 150 | 1 | 37 | HYM31810.1 hypothetical protein [Candidatus Cybelea sp.] | diamond | 111 | 44.3 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 28562573 | 28562573 | PRJNA550047_P_NODE_574747_length_205_cov_20.954545_g572774_i0 | PRJNA550047 | 574747 | 205 | 20.954545 | 42.95681725 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 115 | 3.5499999999999996e-30 | NR | MFA5509127.1 | 3107663 | g572774 | i0 | 80.9 | 0.995121951219512 | 68 | 13 | 99.5 | 0 | 204 | 1 | 14 | 81 | MFA5509127.1 ABC transporter ATP-binding protein [Vulcanimicrobiota bacterium] | diamond | 204 | 115 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29225725 | 29225725 | PRJNA550047_P_NODE_386909_length_270_cov_6.649746_g384937_i0 | PRJNA550047 | 386909 | 270 | 6.649746 | 17.9543142 | Candidatus Elarobacter sp. | 3047550 | Bacteria | Bacteria | 58.9 | 9.92e-8 | NR | HEV3086875.1 | 3047550 | g384937 | i0 | 32.6 | 2.92222222222222 | 86 | 58 | 95.6 | 0 | 11 | 268 | 140 | 225 | HEV3086875.1 hypothetical protein [Candidatus Elarobacter sp.] | diamond | 789 | 58.9 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Elarobacter | Candidatus Elarobacter sp. | ||
| 29429339 | 29429339 | PRJNA550047_P_NODE_267029_length_299_cov_17.955752_g265060_i0 | PRJNA550047 | 267029 | 299 | 17.955752 | 53.68769848 | Bacillati | 1783272 | Bacteria | Bacteria | 117 | 3.39e-30 | NR | HEV2878745.1 | 3069296 | g265060 | i0 | 48.4 | 3.75250836120401 | 124 | 39 | 99.3 | 1 | 2 | 298 | 53 | 176 | HEV2878745.1 hypothetical protein [Candidatus Eremiobacteraceae bacterium] | diamond | 1122 | 118 | 0.991525423728814 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Candidatus Eremiobacterales | Candidatus Eremiobacteraceae | Candidatus Eremiobacteraceae bacterium | |||
| 30078015 | 30078015 | PRJNA550047_P_NODE_536232_length_218_cov_9.544828_g534259_i0 | PRJNA550047 | 536232 | 218 | 9.544828 | 20.80772504 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 63.5 | 1.25e-9 | NR | HUD45259.1 | 2952909 | g534259 | i0 | 66 | 2.6697247706422 | 53 | 12 | 64.7 | 1 | 1 | 141 | 347 | 399 | HUD45259.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] | diamond | 582 | 63.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 30204229 | 30204229 | PRJNA550047_P_NODE_485992_length_235_cov_7.425926_g484019_i0 | PRJNA550047 | 485992 | 235 | 7.425926 | 17.4509261 | Candidatus Elarobacter sp. | 3047550 | Bacteria | Bacteria | 114 | 7.01e-30 | NR | HTD26925.1 | 3047550 | g484019 | i0 | 71.4 | 0.982978723404255 | 77 | 20 | 98.3 | 1 | 233 | 3 | 106 | 180 | HTD26925.1 histidine phosphatase family protein [Candidatus Elarobacter sp.] | diamond | 231 | 114 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Elarobacter | Candidatus Elarobacter sp. | ||
| 30299697 | 30299697 | PRJNA550047_P_NODE_429352_length_254_cov_5.359116_g427380_i0 | PRJNA550047 | 429352 | 254 | 5.359116 | 13.61215464 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 86.7 | 2.35e-19 | NR | GMU52963.1 | 3036772 | g427380 | i0 | 48.1 | 0.933070866141732 | 79 | 38 | 93.3 | 1 | 250 | 14 | 68 | 143 | GMU52963.1 MAG: hypothetical protein AMXMBFR33_21090 [Candidatus Xenobia bacterium] | diamond | 237 | 86.7 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Candidatus Xenobia | Candidatus Xenobia bacterium | |||||
| 32670160 | 32670160 | PRJNA550047_P_NODE_382160_length_272_cov_5.512563_g380188_i0 | PRJNA550047 | 382160 | 272 | 5.512563 | 14.99417136 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 72.8 | 1.01e-12 | NR | MFN8606712.1 | 3107663 | g380188 | i0 | 42.5 | 0.959558823529412 | 87 | 50 | 96 | 0 | 263 | 3 | 199 | 285 | MFN8606712.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 261 | 72.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32701644 | 32701644 | PRJNA550047_P_NODE_374220_length_275_cov_7.272277_g372248_i0 | PRJNA550047 | 374220 | 275 | 7.272277 | 19.99876175 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 91.3 | 7.19e-20 | NR | HTW24464.1 | 2952909 | g372248 | i0 | 57 | 1.88727272727273 | 86 | 36 | 92.7 | 1 | 17 | 271 | 188 | 273 | HTW24464.1 ParB N-terminal domain-containing protein [Candidatus Baltobacteraceae bacterium] | diamond | 519 | 91.3 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 32701679 | 32701679 | PRJNA550047_P_NODE_441940_length_249_cov_21.125000_g439968_i0 | PRJNA550047 | 441940 | 249 | 21.125 | 52.60125 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 42.4 | 0.0405 | NR | HTW24998.1 | 2952909 | g439968 | i0 | 50 | 0.506024096385542 | 42 | 19 | 48.2 | 1 | 120 | 1 | 83 | 124 | HTW24998.1 isoprenylcysteine carboxylmethyltransferase family protein [Candidatus Baltobacteraceae bacterium] | diamond | 126 | 42.4 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae 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);;