contig_metadata
24 rows where bioproject = "PRJNA682078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3211183 | 3211183 | PRJNA682078_P_NODE_21283_length_740_cov_1.430285_g19668_i0 | PRJNA682078 | 21283 | 740 | 1.430285 | 10.584109 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 571 | 4.6e-158 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g19668 | i0 | 81.06 | 133.977027027027 | 755 | 110 | 100 | 31 | 4 | 740 | 5033180 | 5032441 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 99143 | 571 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 10863561 | 10863561 | PRJNA682078_P_NODE_181369_length_274_cov_1.174129_g179592_i0 | PRJNA682078 | 181369 | 274 | 1.174129 | 3.21711346 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 167 | 6.11e-48 | NR | MFA5508407.1 | 3107663 | g179592 | i0 | 84.4 | 1.97080291970803 | 90 | 14 | 98.5 | 0 | 272 | 3 | 267 | 356 | MFA5508407.1 NADH dehydrogenase (quinone) subunit D [Vulcanimicrobiota bacterium] | diamond | 540 | 167 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 12137096 | 12137096 | PRJNA682078_P_NODE_105170_length_344_cov_1.420664_g103393_i0 | PRJNA682078 | 105170 | 344 | 1.420664 | 4.88708416 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 475 | 1.63e-129 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g103393 | i0 | 91.594 | 635.997093023256 | 345 | 27 | 100 | 2 | 1 | 344 | 5033481 | 5033824 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 218783 | 475 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 24885827 | 24885827 | PRJNA682078_P_NODE_184420_length_272_cov_1.487437_g182643_i0 | PRJNA682078 | 184420 | 272 | 1.487437 | 4.04582864 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 387 | 6.02e-103 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g182643 | i0 | 92.308 | 93.2352941176471 | 273 | 19 | 99 | 1 | 2 | 272 | 5032749 | 5032477 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 25360 | 387 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 26986990 | 26986990 | PRJNA682078_P_NODE_101262_length_350_cov_1.046931_g99486_i0 | PRJNA682078 | 101262 | 350 | 1.046931 | 3.6642585 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 75.1 | 2.71e-13 | NR | MFA7480860.1 | 3107663 | g99486 | i0 | 57.6 | 0.565714285714286 | 66 | 28 | 56.6 | 0 | 229 | 32 | 10 | 75 | MFA7480860.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 198 | 75.1 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 27398273 | 27398273 | PRJNA682078_P_NODE_174203_length_278_cov_1.478049_g172426_i0 | PRJNA682078 | 174203 | 278 | 1.478049 | 4.10897622 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 53.9 | 6.15e-6 | NR | MFA5506010.1 | 3107663 | g172426 | i0 | 66.7 | 0.453237410071942 | 42 | 14 | 45.3 | 0 | 126 | 1 | 2 | 43 | MFA5506010.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 126 | 53.9 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 27524457 | 27524457 | PRJNA682078_P_NODE_277083_length_243_cov_0.905882_g275306_i0 | PRJNA682078 | 277083 | 243 | 0.905882 | 2.20129326 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 60.5 | 1.24e-9 | NR | MFN8607505.1 | 3107663 | g275306 | i0 | 61.5 | 0.481481481481481 | 39 | 15 | 48.1 | 0 | 3 | 119 | 68 | 106 | MFN8607505.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 117 | 60.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 27587682 | 27587682 | PRJNA682078_P_NODE_189684_length_269_cov_1.362245_g187907_i0 | PRJNA682078 | 189684 | 269 | 1.362245 | 3.66443905 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 81.6 | 8.5e-17 | NR | MFN8607585.1 | 3107663 | g187907 | i0 | 46.1 | 0.992565055762082 | 89 | 48 | 99.3 | 0 | 1 | 267 | 33 | 121 | MFN8607585.1 hemerythrin domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 267 | 81.6 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 27934961 | 27934961 | PRJNA682078_P_NODE_190285_length_269_cov_0.954082_g188508_i0 | PRJNA682078 | 190285 | 269 | 0.954082 | 2.56648058 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 95.9 | 9.8e-21 | NR | MFA7481775.1 | 3107663 | g188508 | i0 | 59.3 | 0.903345724907063 | 81 | 32 | 90.3 | 1 | 25 | 267 | 159 | 238 | MFA7481775.1 DUF1998 domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 243 | 95.9 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 28503258 | 28503258 | PRJNA682078_P_NODE_265107_length_245_cov_0.895349_g263330_i0 | PRJNA682078 | 265107 | 245 | 0.895349 | 2.19360505 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 77.8 | 1.54e-14 | NR | MFN8610905.1 | 3107663 | g263330 | i0 | 75.5 | 0.6 | 49 | 11 | 58.8 | 1 | 100 | 243 | 1 | 49 | MFN8610905.1 tetratricopeptide repeat protein [Vulcanimicrobiota bacterium] | diamond | 147 | 77.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 28787186 | 28787186 | PRJNA682078_P_NODE_188227_length_270_cov_1.177665_g186450_i0 | PRJNA682078 | 188227 | 270 | 1.177665 | 3.1796955 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 121 | 8.08e-33 | NR | MFA5504030.1 | 3107663 | g186450 | i0 | 64.4 | 2.96666666666667 | 90 | 32 | 100 | 0 | 1 | 270 | 6 | 95 | MFA5504030.1 tyrosine-type recombinase/integrase [Vulcanimicrobiota bacterium] | diamond | 801 | 121 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29229673 | 29229673 | PRJNA682078_P_NODE_269429_length_244_cov_0.900585_g267652_i0 | PRJNA682078 | 269429 | 244 | 0.900585 | 2.1974274 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 55.5 | 7.04e-8 | NR | GMU52672.1 | 3036772 | g267652 | i0 | 61.9 | 0.516393442622951 | 42 | 16 | 51.6 | 0 | 119 | 244 | 1 | 42 | GMU52672.1 MAG: hypothetical protein AMXMBFR33_18180 [Candidatus Xenobia bacterium] | diamond | 126 | 55.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Candidatus Xenobia | Candidatus Xenobia bacterium | |||||
| 29355829 | 29355829 | PRJNA682078_P_NODE_199929_length_263_cov_1.331579_g198152_i0 | PRJNA682078 | 199929 | 263 | 1.331579 | 3.50205277 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 62.4 | 3.3e-9 | NR | MFA7483607.1 | 3107663 | g198152 | i0 | 39.3 | 2.03041825095057 | 89 | 52 | 99.2 | 1 | 1 | 261 | 52 | 140 | MFA7483607.1 NAD-binding protein [Vulcanimicrobiota bacterium] | diamond | 534 | 62.4 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29387401 | 29387401 | PRJNA682078_P_NODE_112049_length_335_cov_1.351145_g110272_i0 | PRJNA682078 | 112049 | 335 | 1.351145 | 4.52633575 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 112 | 2.41e-26 | NR | MFA5504199.1 | 3107663 | g110272 | i0 | 76.4 | 1.28955223880597 | 72 | 17 | 64.5 | 0 | 120 | 335 | 1 | 72 | MFA5504199.1 hydantoinase B/oxoprolinase family protein [Vulcanimicrobiota bacterium] | diamond | 432 | 112 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29671111 | 29671111 | PRJNA682078_P_NODE_222570_length_251_cov_0.865169_g220793_i0 | PRJNA682078 | 222570 | 251 | 0.865169 | 2.17157419 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 82.8 | 3.21e-16 | NR | MFN8607882.1 | 3107663 | g220793 | i0 | 75.5 | 0.585657370517928 | 49 | 12 | 58.6 | 0 | 150 | 4 | 4 | 52 | MFN8607882.1 alpha-amylase family glycosyl hydrolase [Vulcanimicrobiota bacterium] | diamond | 147 | 82.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29892683 | 29892683 | PRJNA682078_P_NODE_152331_length_292_cov_2.018265_g150554_i0 | PRJNA682078 | 152331 | 292 | 2.018265 | 5.8933338 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 135 | 1.77e-34 | NR | MFN8611263.1 | 3107663 | g150554 | i0 | 70.2 | 0.965753424657534 | 94 | 28 | 96.6 | 0 | 284 | 3 | 579 | 672 | MFN8611263.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 282 | 135 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29955714 | 29955714 | PRJNA682078_P_NODE_179131_length_275_cov_1.514851_g177354_i0 | PRJNA682078 | 179131 | 275 | 1.514851 | 4.16584025 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 140 | 1.12e-37 | NR | MFA5504373.1 | 3107663 | g177354 | i0 | 78 | 1.98545454545455 | 91 | 20 | 99.3 | 0 | 2 | 274 | 149 | 239 | MFA5504373.1 glutamyl-tRNA reductase [Vulcanimicrobiota bacterium] | diamond | 546 | 140 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 30081886 | 30081886 | PRJNA682078_P_NODE_199792_length_263_cov_1.410526_g198015_i0 | PRJNA682078 | 199792 | 263 | 1.410526 | 3.70968338 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 71.2 | 4.38e-12 | NR | MFN8610437.1 | 3107663 | g198015 | i0 | 46 | 1.98479087452471 | 87 | 46 | 99.2 | 1 | 2 | 262 | 355 | 440 | MFN8610437.1 ATP-dependent helicase [Vulcanimicrobiota bacterium] | diamond | 522 | 71.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 30998420 | 30998420 | PRJNA682078_P_NODE_269354_length_244_cov_0.900585_g267577_i0 | PRJNA682078 | 269354 | 244 | 0.900585 | 2.1974274 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 128 | 3.22e-32 | NR | MFN8610881.1 | 3107663 | g267577 | i0 | 77.5 | 0.983606557377049 | 80 | 18 | 98.4 | 0 | 3 | 242 | 265 | 344 | MFN8610881.1 DEAD/DEAH box helicase family protein [Vulcanimicrobiota bacterium] | diamond | 240 | 128 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 31630682 | 31630682 | PRJNA682078_P_NODE_289596_length_241_cov_0.916667_g287819_i0 | PRJNA682078 | 289596 | 241 | 0.916667 | 2.20916747 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 125 | 2.8499999999999995e-31 | NR | MFA5506223.1 | 3107663 | g287819 | i0 | 78.8 | 0.995850622406639 | 80 | 17 | 99.6 | 0 | 1 | 240 | 237 | 316 | MFA5506223.1 FtsX-like permease family protein [Vulcanimicrobiota bacterium] | diamond | 240 | 125 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32390032 | 32390032 | PRJNA682078_P_NODE_265179_length_245_cov_0.895349_g263402_i0 | PRJNA682078 | 265179 | 245 | 0.895349 | 2.19360505 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 96.7 | 7.209999999999999e-23 | NR | MFN8611481.1 | 3107663 | g263402 | i0 | 70 | 0.857142857142857 | 70 | 21 | 85.7 | 0 | 243 | 34 | 125 | 194 | MFN8611481.1 SHOCT domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 210 | 96.7 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32579999 | 32579999 | PRJNA682078_P_NODE_238759_length_249_cov_0.875000_g236982_i0 | PRJNA682078 | 238759 | 249 | 0.875 | 2.17875 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 48.9 | 2.43e-4 | NR | MFA5508349.1 | 3107663 | g236982 | i0 | 41.8 | 2.19277108433735 | 55 | 32 | 66.3 | 0 | 193 | 29 | 38 | 92 | MFA5508349.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 546 | 48.9 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32768606 | 32768606 | PRJNA682078_P_NODE_218420_length_253_cov_0.788889_g216643_i0 | PRJNA682078 | 218420 | 253 | 0.788889 | 1.99588917 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 111 | 5.270000000000001e-27 | NR | MFN8608568.1 | 3107663 | g216643 | i0 | 98.1 | 0.640316205533597 | 54 | 1 | 64 | 0 | 164 | 3 | 248 | 301 | MFN8608568.1 hypothetical protein [Vulcanimicrobiota bacterium] | diamond | 162 | 111 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 32894527 | 32894527 | PRJNA682078_P_NODE_270040_length_244_cov_0.900585_g268263_i0 | PRJNA682078 | 270040 | 244 | 0.900585 | 2.1974274 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 110 | 2.43e-26 | NR | MFA7483641.1 | 3107663 | g268263 | i0 | 62 | 1.94262295081967 | 79 | 30 | 97.1 | 0 | 237 | 1 | 40 | 118 | MFA7483641.1 S8 family peptidase [Vulcanimicrobiota bacterium] | diamond | 474 | 110 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota 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);;