contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax_kingdom = "Thermotogati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5999798 | 5999798 | PRJNA917598_P_NODE_65305_length_281_cov_1.480769_g64361_i0 | PRJNA917598 | 65305 | 281 | 1.480769 | 4.16096089 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 64.3 | 2.12e-10 | NR | WP_353541811.1 | 457454 | g64361 | i0 | 100 | 0.320284697508897 | 30 | 0 | 32 | 0 | 1 | 90 | 134 | 163 | WP_353541811.1 hypothetical protein [Deinococcus xinjiangensis] | diamond | 90 | 64.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 15279406 | 15279406 | PRJNA917598_P_NODE_54212_length_310_cov_1.299578_g53268_i0 | PRJNA917598 | 54212 | 310 | 1.299578 | 4.0286918 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 144 | 1.35e-37 | NR | WP_353542776.1 | 457454 | g53268 | i0 | 73.1 | 1.00645161290323 | 104 | 27 | 99.7 | 1 | 2 | 310 | 895 | 998 | WP_353542776.1 S-layer homology domain-containing protein [Deinococcus xinjiangensis] | diamond | 312 | 144 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 15279645 | 15279645 | PRJNA917598_P_NODE_80552_length_251_cov_0.865169_g79608_i0 | PRJNA917598 | 80552 | 251 | 0.865169 | 2.17157419 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 164 | 2.31e-45 | NR | WP_353540705.1 | 457454 | g79608 | i0 | 100 | 0.9800796812749 | 82 | 0 | 98 | 0 | 251 | 6 | 6 | 87 | WP_353540705.1 ribosomal protection-like ABC-F family protein [Deinococcus xinjiangensis] | diamond | 246 | 164 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 16199505 | 16199505 | PRJNA917598_P_NODE_65313_length_281_cov_1.480769_g64369_i0 | PRJNA917598 | 65313 | 281 | 1.480769 | 4.16096089 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 177 | 3.1699999999999993e-52 | NR | WP_353544036.1 | 457454 | g64369 | i0 | 100 | 0.99288256227758 | 93 | 0 | 99.3 | 0 | 280 | 2 | 248 | 340 | WP_353544036.1 S-layer homology domain-containing protein [Deinococcus xinjiangensis] | diamond | 279 | 177 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 26803011 | 26803011 | PRJNA917598_P_NODE_87581_length_246_cov_0.890173_g86637_i0 | PRJNA917598 | 87581 | 246 | 0.890173 | 2.18982558 | Deinococcus | 1298 | Bacteria | Bacteria | 73.9 | 3.8e-13 | NR | WP_011530842.1 | 1298 | g86637 | i0 | 85.4 | 0.926829268292683 | 41 | 6 | 50 | 0 | 244 | 122 | 464 | 504 | WP_011530842.1 MULTISPECIES: glycine--tRNA ligase [Deinococcus] | diamond | 228 | 73.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | |||
| 27467131 | 27467131 | PRJNA917598_P_NODE_22763_length_486_cov_1.317191_g21821_i0 | PRJNA917598 | 22763 | 486 | 1.317191 | 6.40154826 | Deinococcus arboris | 2682977 | Bacteria | Bacteria | 179 | 3.37e-51 | NR | WP_157461736.1 | 2682977 | g21821 | i0 | 66.4 | 3.23456790123457 | 131 | 44 | 80.9 | 0 | 1 | 393 | 307 | 437 | WP_157461736.1 RCC1 domain-containing protein [Deinococcus arboris] | diamond | 1572 | 179 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus arboris | ||
| 27656709 | 27656709 | PRJNA917598_P_NODE_94224_length_242_cov_0.911243_g93280_i0 | PRJNA917598 | 94224 | 242 | 0.911243 | 2.20520806 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 92 | 1.65e-19 | NR | WP_353543692.1 | 457454 | g93280 | i0 | 100 | 0.508264462809917 | 41 | 0 | 50.8 | 0 | 241 | 119 | 2 | 42 | WP_353543692.1 Tn3 family transposase [Deinococcus xinjiangensis] | diamond | 123 | 92 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 28193059 | 28193059 | PRJNA917598_P_NODE_84046_length_248_cov_1.542857_g83102_i0 | PRJNA917598 | 84046 | 248 | 1.542857 | 3.82628536 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 166 | 5.1699999999999994e-46 | NR | WP_353543852.1 | 457454 | g83102 | i0 | 100 | 0.991935483870968 | 82 | 0 | 99.2 | 0 | 1 | 246 | 4 | 85 | WP_353543852.1 heavy metal translocating P-type ATPase [Deinococcus xinjiangensis] | diamond | 246 | 166 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 28224637 | 28224637 | PRJNA917598_P_NODE_91126_length_244_cov_0.900585_g90182_i0 | PRJNA917598 | 91126 | 244 | 0.900585 | 2.1974274 | Deinococcus rhizophilus | 3049544 | Bacteria | Bacteria | 96.3 | 2.0900000000000002e-22 | NR | WP_285522141.1 | 3049544 | g90182 | i0 | 60.3 | 0.897540983606557 | 73 | 29 | 89.8 | 0 | 4 | 222 | 58 | 130 | WP_285522141.1 hypothetical protein [Deinococcus rhizophilus] | diamond | 219 | 96.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus rhizophilus | ||
| 28761504 | 28761504 | PRJNA917598_P_NODE_91467_length_244_cov_0.900585_g90523_i0 | PRJNA917598 | 91467 | 244 | 0.900585 | 2.1974274 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 117 | 6.49e-30 | NR | CAA9585753.1 | 543023 | g90523 | i0 | 69.1 | 0.995901639344262 | 81 | 25 | 99.6 | 0 | 243 | 1 | 152 | 232 | CAA9585753.1 MAG: Hydrolase, alpha/beta fold family [uncultured Truepera sp.] | diamond | 243 | 117 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 29077471 | 29077471 | PRJNA917598_P_NODE_67268_length_277_cov_1.887255_g66324_i0 | PRJNA917598 | 67268 | 277 | 1.887255 | 5.22769635 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 131 | 3.31e-33 | NR | WP_353542776.1 | 457454 | g66324 | i0 | 69.2 | 0.985559566787004 | 91 | 28 | 98.6 | 0 | 277 | 5 | 592 | 682 | WP_353542776.1 S-layer homology domain-containing protein [Deinococcus xinjiangensis] | diamond | 273 | 131 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 29140720 | 29140720 | PRJNA917598_P_NODE_84709_length_248_cov_0.880000_g83765_i0 | PRJNA917598 | 84709 | 248 | 0.88 | 2.1824 | Meiothermus sp. | 1955249 | Bacteria | Bacteria | 45.1 | 0.00279 | NR | MDX2008257.1 | 1955249 | g83765 | i0 | 46.3 | 0.653225806451613 | 54 | 29 | 65.3 | 0 | 247 | 86 | 90 | 143 | MDX2008257.1 DUF1320 domain-containing protein [Meiothermus sp.] | diamond | 162 | 45.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. | ||
| 29266591 | 29266591 | PRJNA917598_P_NODE_91569_length_244_cov_0.900585_g90625_i0 | PRJNA917598 | 91569 | 244 | 0.900585 | 2.1974274 | Deinococcus radiopugnans | 57497 | Bacteria | Bacteria | 99.8 | 1.15e-24 | NR | WP_139404967.1 | 57497 | g90625 | i0 | 81.7 | 1.54918032786885 | 60 | 11 | 73.8 | 0 | 243 | 64 | 77 | 136 | WP_139404967.1 response regulator [Deinococcus radiopugnans] | diamond | 378 | 99.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiopugnans | ||
| 29424475 | 29424475 | PRJNA917598_P_NODE_64149_length_283_cov_1.466667_g63205_i0 | PRJNA917598 | 64149 | 283 | 1.466667 | 4.15066761 | Deinococcus radiotolerans | 1309407 | Bacteria | Bacteria | 124 | 1.78e-30 | NR | WP_189068593.1 | 1309407 | g63205 | i0 | 71.3 | 0.996466431095406 | 94 | 23 | 99.6 | 1 | 282 | 1 | 142 | 231 | WP_189068593.1 PEP/pyruvate-binding domain-containing protein [Deinococcus radiotolerans] | diamond | 282 | 124 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiotolerans | ||
| 29487560 | 29487560 | PRJNA917598_P_NODE_24570_length_466_cov_2.888041_g23627_i0 | PRJNA917598 | 24570 | 466 | 2.888041 | 13.45827106 | Deinococcus aquatilis | 519440 | Bacteria | Bacteria | 91.3 | 4.84e-18 | NR | WP_019008990.1 | 519440 | g23627 | i0 | 37 | 0.888412017167382 | 138 | 83 | 86.3 | 1 | 407 | 6 | 391 | 528 | WP_019008990.1 polysaccharide deacetylase family protein [Deinococcus aquatilis] | diamond | 414 | 91.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquatilis | ||
| 29645254 | 29645254 | PRJNA917598_P_NODE_71290_length_269_cov_1.571429_g70346_i0 | PRJNA917598 | 71290 | 269 | 1.571429 | 4.22714401 | Synergistales bacterium | 2268201 | Bacteria | Bacteria | 117 | 2.2099999999999998e-32 | NR | MBC7078272.1 | 2268201 | g70346 | i0 | 81.8 | 1.47211895910781 | 66 | 12 | 73.6 | 0 | 2 | 199 | 19 | 84 | MBC7078272.1 DUF4065 domain-containing protein [Synergistales bacterium] | diamond | 396 | 117 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistales bacterium | ||||
| 29645277 | 29645277 | PRJNA917598_P_NODE_94190_length_242_cov_0.911243_g93246_i0 | PRJNA917598 | 94190 | 242 | 0.911243 | 2.20520806 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 145 | 1.44e-39 | NR | WP_380078214.1 | 1298767 | g93246 | i0 | 97.5 | 0.991735537190083 | 80 | 2 | 99.2 | 0 | 2 | 241 | 111 | 190 | WP_380078214.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Deinococcus antarcticus] | diamond | 240 | 145 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 30246006 | 30246006 | PRJNA917598_P_NODE_39052_length_367_cov_2.503401_g38108_i0 | PRJNA917598 | 39052 | 367 | 2.503401 | 9.18748167 | Deinococcus sp. VB343 | 3385567 | Bacteria | Bacteria | 62 | 2.8e-10 | NR | WP_339097875.1 | 3385567 | g38108 | i0 | 68.2 | 0.359673024523161 | 44 | 14 | 36 | 0 | 266 | 135 | 1 | 44 | WP_339097875.1 hypothetical protein [Deinococcus sp. VB343] | diamond | 132 | 62 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB343 | ||
| 30404254 | 30404254 | PRJNA917598_P_NODE_68453_length_275_cov_1.509901_g67509_i0 | PRJNA917598 | 68453 | 275 | 1.509901 | 4.15222775 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 66.6 | 1.12e-11 | NR | GAA5502076.1 | 457454 | g67509 | i0 | 62.7 | 0.643636363636364 | 59 | 21 | 64.4 | 1 | 40 | 216 | 18 | 75 | GAA5502076.1 hypothetical protein Dxin01_01815 [Deinococcus xinjiangensis] | diamond | 177 | 66.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 30909467 | 30909467 | PRJNA917598_P_NODE_96394_length_239_cov_2.355422_g95450_i0 | PRJNA917598 | 96394 | 239 | 2.355422 | 5.62945858 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 85.1 | 4.83e-20 | NR | WP_353541756.1 | 457454 | g95450 | i0 | 97.7 | 0.552301255230126 | 44 | 1 | 55.2 | 0 | 139 | 8 | 1 | 44 | WP_353541756.1 hypothetical protein [Deinococcus xinjiangensis] | diamond | 132 | 85.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 31193325 | 31193325 | PRJNA917598_P_NODE_94175_length_242_cov_0.911243_g93231_i0 | PRJNA917598 | 94175 | 242 | 0.911243 | 2.20520806 | Thermotogota bacterium | 2053689 | Bacteria | Bacteria | 70.5 | 3.51e-13 | NR | RKX41700.1 | 2053689 | g93231 | i0 | 43.5 | 0.855371900826446 | 69 | 39 | 85.5 | 0 | 4 | 210 | 48 | 116 | RKX41700.1 MAG: hypothetical protein DRP27_10445 [Thermotogota bacterium] | diamond | 207 | 70.5 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogota bacterium | ||||||
| 31510165 | 31510165 | PRJNA917598_P_NODE_94116_length_242_cov_0.911243_g93172_i0 | PRJNA917598 | 94116 | 242 | 0.911243 | 2.20520806 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 124 | 4.19e-32 | NR | WP_380075522.1 | 1298767 | g93172 | i0 | 77.5 | 1.98347107438017 | 80 | 18 | 99.2 | 0 | 241 | 2 | 36 | 115 | WP_380075522.1 permease prefix domain 1-containing protein [Deinococcus antarcticus] | diamond | 480 | 124 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 31604933 | 31604933 | PRJNA917598_P_NODE_83376_length_249_cov_0.875000_g82432_i0 | PRJNA917598 | 83376 | 249 | 0.875 | 2.17875 | Deinococcus soli (ex Cha et al. 2 | 1309411 | Bacteria | Bacteria | 159 | 6.01e-44 | NR | WP_309853062.1 | 1309411 | g82432 | i0 | 86.6 | 0.987951807228916 | 82 | 11 | 98.8 | 0 | 248 | 3 | 34 | 115 | WP_309853062.1 GAD-like domain-containing protein [Deinococcus soli (ex Cha et al. 2016)] | diamond | 246 | 159 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 32016077 | 32016077 | PRJNA917598_P_NODE_80698_length_251_cov_0.865169_g79754_i0 | PRJNA917598 | 80698 | 251 | 0.865169 | 2.17157419 | Deinococcus radiopugnans | 57497 | Bacteria | Bacteria | 121 | 1e-29 | NR | WP_039682724.1 | 57497 | g79754 | i0 | 67.5 | 0.99203187250996006 | 83 | 27 | 99.2 | 0 | 250 | 2 | 19 | 101 | WP_039682724.1 Z1 domain-containing protein [Deinococcus radiopugnans] | diamond | 249 | 121 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiopugnans | ||
| 32466639 | 32466639 | PRJNA917598_P_NODE_42139_length_354_cov_1.010676_g41195_i0 | PRJNA917598 | 42139 | 354 | 1.010676 | 3.57779304 | Bacteria | 2 | Bacteria | Bacteria | 237 | 5.500000000000001e-71 | NR | 1TAQ_A | 271 | g41195 | i0 | 98.3 | 4 | 118 | 2 | 100 | 0 | 354 | 1 | 118 | 235 | 1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus] | diamond | 1416 | 237 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 32522613 | 32522613 | PRJNA917598_P_NODE_39479_length_365_cov_2.256849_g38535_i0 | PRJNA917598 | 39479 | 365 | 2.256849 | 8.23749885 | Deinococcus aquatilis | 519440 | Bacteria | Bacteria | 78.2 | 5.84e-14 | NR | WP_019008990.1 | 519440 | g38535 | i0 | 38.3 | 0.879452054794521 | 107 | 64 | 87.9 | 1 | 363 | 43 | 534 | 638 | WP_019008990.1 polysaccharide deacetylase family protein [Deinococcus aquatilis] | diamond | 321 | 78.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquatilis | ||
| 32687141 | 32687141 | PRJNA917598_P_NODE_58820_length_295_cov_1.018018_g57876_i0 | PRJNA917598 | 58820 | 295 | 1.018018 | 3.0031531 | root | 1 | Root_unresolved | Root_unresolved | 197 | 1.17e-56 | NR | 1TAQ_A | 271 | g57876 | i0 | 100 | 5.97966101694915 | 98 | 0 | 99.7 | 0 | 294 | 1 | 284 | 381 | 1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus] | diamond | 1764 | 197 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus |
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);;