contig_metadata
24 rows where bioproject = "PRJNA716463", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 708231 | 708231 | PRJNA716463_P_NODE_61681_length_282_cov_3.129187_g61264_i0 | PRJNA716463 | 61681 | 282 | 3.129187 | 8.82430734 | Thermomicrobium roseum | 500 | Bacteria | Bacteria | 115 | 3.27e-21 | NTclustered | gi|221155340|gb|CP001275.1| | 309801 | g61264 | i0 | 94.595 | 0.26241134751773 | 74 | 4 | 26 | 0 | 209 | 282 | 1811771 | 1811844 | Thermomicrobium roseum DSM 5159, complete genome | blastn | 74 | 115 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium roseum | ||
| 9636359 | 9636359 | PRJNA716463_P_NODE_37628_length_299_cov_2.933628_g37211_i0 | PRJNA716463 | 37628 | 299 | 2.933628 | 8.77154772 | Thermomicrobium roseum | 500 | Bacteria | Bacteria | 139 | 2.07e-28 | NTclustered | gi|221155340|gb|CP001275.1| | 309801 | g37211 | i0 | 95.402 | 4.55852842809365 | 87 | 4 | 29 | 0 | 152 | 238 | 133728 | 133642 | Thermomicrobium roseum DSM 5159, complete genome | blastn | 1363 | 139 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium roseum | ||
| 13462099 | 13462099 | PRJNA716463_P_NODE_72791_length_274_cov_2.179104_g72374_i0 | PRJNA716463 | 72791 | 274 | 2.179104 | 5.97074496 | Thermomicrobium sp. CFH 7336 | 1969469 | Bacteria | Bacteria | 175 | 2.59e-50 | NR | WP_252126945.1 | 2951987 | g72374 | i0 | 91.1 | 0.985401459854015 | 90 | 8 | 98.5 | 0 | 272 | 3 | 1 | 90 | WP_252126945.1 glucose-6-phosphate dehydrogenase [Thermomicrobium sp. CFH 73360] | diamond | 270 | 175 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. CFH 73360 | ||
| 17285177 | 17285177 | PRJNA716463_P_NODE_102534_length_249_cov_2.187500_g102117_i0 | PRJNA716463 | 102534 | 249 | 2.1875 | 5.446875 | Thermalbibacter longus | 2951981 | Bacteria | Bacteria | 169 | 3.06e-50 | NR | WP_284057696.1 | 2951981 | g102117 | i0 | 100 | 0.987951807228916 | 82 | 0 | 98.8 | 0 | 248 | 3 | 165 | 246 | WP_284057696.1 metal ABC transporter ATP-binding protein [Thermalbibacter longus] | diamond | 246 | 169 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermalbibacter | Thermalbibacter longus | ||
| 17286011 | 17286011 | PRJNA716463_P_NODE_43954_length_296_cov_2.645740_g43537_i0 | PRJNA716463 | 43954 | 296 | 2.64574 | 7.8313904 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 124 | 5.28e-33 | NR | HLU34548.1 | 2482790 | g43537 | i0 | 66.7 | 0.881756756756757 | 87 | 26 | 85.1 | 1 | 294 | 43 | 156 | 242 | HLU34548.1 metallophosphoesterase family protein [Thermomicrobiales bacterium] | diamond | 261 | 124 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 21111246 | 21111246 | PRJNA716463_P_NODE_86797_length_263_cov_1.931579_g86380_i0 | PRJNA716463 | 86797 | 263 | 1.931579 | 5.08005277 | Thermomicrobium roseum | 500 | Bacteria | Bacteria | 228 | 3.719999999999999e-55 | NTclustered | gi|221157271|gb|CP001276.1| | 309801 | g86380 | i0 | 82.692 | 0.988593155893536 | 260 | 41 | 98 | 4 | 4 | 261 | 892565 | 892308 | Thermomicrobium roseum DSM 5159 plasmid, complete sequence | blastn | 260 | 228 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium roseum | ||
| 27020371 | 27020371 | PRJNA716463_P_NODE_29662_length_310_cov_2.506329_g29245_i0 | PRJNA716463 | 29662 | 310 | 2.506329 | 7.7696199 | Thermomicrobiales bacterium | 2482790 | Bacteria | Bacteria | 82 | 7.38e-17 | NR | HEV2072685.1 | 2482790 | g29245 | i0 | 77.6 | 1.42258064516129 | 49 | 11 | 47.4 | 0 | 308 | 162 | 91 | 139 | HEV2072685.1 ADP-ribosylation factor-like protein [Thermomicrobiales bacterium] | diamond | 441 | 82 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiales bacterium | ||||
| 27557329 | 27557329 | PRJNA716463_P_NODE_19664_length_310_cov_3.818565_g19247_i0 | PRJNA716463 | 19664 | 310 | 3.818565 | 11.8375515 | Thermomicrobium sp. | 1969469 | Bacteria | Bacteria | 98.2 | 2.2699999999999994e-23 | NR | MDW8060593.1 | 1969469 | g19247 | i0 | 100 | 0.474193548387097 | 49 | 0 | 47.4 | 0 | 162 | 308 | 4 | 52 | MDW8060593.1 hypothetical protein [Thermomicrobium sp.] | diamond | 147 | 98.2 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 27778720 | 27778720 | PRJNA716463_P_NODE_29524_length_310_cov_2.540084_g29107_i0 | PRJNA716463 | 29524 | 310 | 2.540084 | 7.8742604 | Thermomicrobium sp. | 1969469 | Bacteria | Bacteria | 181 | 8.479999999999999e-57 | NR | MCS7255197.1 | 1969469 | g29107 | i0 | 82.1 | 1.13225806451613 | 117 | 4 | 96.8 | 1 | 309 | 10 | 5 | 121 | MCS7255197.1 hypothetical protein [Thermomicrobium sp.] | diamond | 351 | 181 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 27915218 | 27915218 | PRJNA716463_P_NODE_25225_length_310_cov_2.966245_g24808_i0 | PRJNA716463 | 25225 | 310 | 2.966245 | 9.1953595 | Thermomicrobium | 499 | Bacteria | Bacteria | 94.4 | 1.2300000000000002e-21 | NR | MCS7256768.1 | 1969469 | g24808 | i0 | 100 | 2.38064516129032 | 49 | 0 | 47.4 | 0 | 148 | 2 | 88 | 136 | MCS7256768.1 CRISPR-associated protein Cas4 [Thermomicrobium sp.] | diamond | 738 | 94.4 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 27999811 | 27999811 | PRJNA716463_P_NODE_96425_length_254_cov_3.325967_g96008_i0 | PRJNA716463 | 96425 | 254 | 3.325967 | 8.44795618 | Thermomicrobium sp. | 1969469 | Bacteria | Bacteria | 77.4 | 4.5e-15 | NR | MDW8059768.1 | 1969469 | g96008 | i0 | 95 | 0.980314960629921 | 40 | 2 | 47.2 | 0 | 1 | 120 | 188 | 227 | MDW8059768.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Thermomicrobium sp.] | diamond | 249 | 77.4 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 28914946 | 28914946 | PRJNA716463_P_NODE_83468_length_266_cov_1.336788_g83051_i0 | PRJNA716463 | 83468 | 266 | 1.336788 | 3.55585608 | Thermalbibacter longus | 2951981 | Bacteria | Bacteria | 90.9 | 8.28e-20 | NR | WP_284057147.1 | 2951981 | g83051 | i0 | 100 | 0.473684210526316 | 42 | 0 | 47.4 | 0 | 265 | 140 | 235 | 276 | WP_284057147.1 DUF4232 domain-containing protein [Thermalbibacter longus] | diamond | 126 | 90.9 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermalbibacter | Thermalbibacter longus | ||
| 28989121 | 28989121 | PRJNA716463_P_NODE_118028_length_231_cov_6.715190_g117610_i0 | PRJNA716463 | 118028 | 231 | 6.71519 | 15.5120889 | Bacteria | 2 | Bacteria | Bacteria | 83.2 | 1.29e-18 | NR | WP_414484928.1 | 2057 | g117610 | i0 | 97.4 | 0.987012987012987 | 38 | 1 | 49.4 | 0 | 117 | 230 | 37 | 74 | WP_414484928.1 copper resistance protein CopC, partial [Sphaerobacter thermophilus] | diamond | 228 | 83.2 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Sphaerobacterales | Sphaerobacteraceae | Sphaerobacter | Sphaerobacter thermophilus | ||
| 29262339 | 29262339 | PRJNA716463_P_NODE_71369_length_275_cov_2.232673_g70952_i0 | PRJNA716463 | 71369 | 275 | 2.232673 | 6.13985075 | Thermomicrobium sp. | 1969469 | Bacteria | Bacteria | 190 | 1.7899999999999997e-57 | NR | MCS7255635.1 | 1969469 | g70952 | i0 | 98.9 | 1.95272727272727 | 91 | 1 | 99.3 | 0 | 275 | 3 | 110 | 200 | MCS7255635.1 copper-containing nitrite reductase [Thermomicrobium sp.] | diamond | 537 | 190 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 29514926 | 29514926 | PRJNA716463_P_NODE_121930_length_224_cov_4.072848_g121512_i0 | PRJNA716463 | 121930 | 224 | 4.072848 | 9.12317952 | Thermomicrobium sp. 4228-Ro | 2993937 | Bacteria | Bacteria | 139 | 8.47e-38 | NR | WP_265940291.1 | 2993937 | g121512 | i0 | 94.6 | 0.991071428571429 | 74 | 4 | 99.1 | 0 | 3 | 224 | 1 | 74 | WP_265940291.1 M24 family metallopeptidase [Thermomicrobium sp. 4228-Ro] | diamond | 222 | 139 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. 4228-Ro | ||
| 29704172 | 29704172 | PRJNA716463_P_NODE_60970_length_283_cov_1.666667_g60553_i0 | PRJNA716463 | 60970 | 283 | 1.666667 | 4.71666761 | Thermomicrobium sp. 4228-Ro | 2993937 | Bacteria | Bacteria | 137 | 1.6e-35 | NR | WP_265939306.1 | 2993937 | g60553 | i0 | 66.7 | 0.92226148409894 | 87 | 29 | 92.2 | 0 | 22 | 282 | 100 | 186 | WP_265939306.1 hypothetical protein [Thermomicrobium sp. 4228-Ro] | diamond | 261 | 137 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. 4228-Ro | ||
| 30936797 | 30936797 | PRJNA716463_P_NODE_108594_length_244_cov_1.678363_g108176_i0 | PRJNA716463 | 108594 | 244 | 1.678363 | 4.09520572 | Thermomicrobium roseum | 500 | Bacteria | Bacteria | 86.7 | 1.21e-17 | NR | WP_012641900.1 | 500 | g108176 | i0 | 86.3 | 0.627049180327869 | 51 | 7 | 62.7 | 0 | 242 | 90 | 472 | 522 | WP_012641900.1 malate synthase A [Thermomicrobium roseum] | diamond | 153 | 86.7 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium roseum | ||
| 31136433 | 31136433 | PRJNA716463_P_NODE_78775_length_269_cov_3.377551_g78358_i0 | PRJNA716463 | 78775 | 269 | 3.377551 | 9.08561219 | Thermomicrobium | 499 | Bacteria | Bacteria | 172 | 1.72e-51 | NR | MCS7255172.1 | 1969469 | g78358 | i0 | 98.8 | 1.85130111524164 | 83 | 1 | 92.6 | 0 | 3 | 251 | 146 | 228 | MCS7255172.1 peptidylprolyl isomerase [Thermomicrobium sp.] | diamond | 498 | 172 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 31379301 | 31379301 | PRJNA716463_P_NODE_117716_length_232_cov_3.276730_g117298_i0 | PRJNA716463 | 117716 | 232 | 3.27673 | 7.6020136 | Thermomicrobium sp. | 1969469 | Bacteria | Bacteria | 142 | 8.759999999999999e-40 | NR | MCS7256466.1 | 1969469 | g117298 | i0 | 89.6 | 0.995689655172414 | 77 | 8 | 99.6 | 0 | 2 | 232 | 143 | 219 | MCS7256466.1 16S rRNA (cytidine(1402)-2'-O)-methyltransferase [Thermomicrobium sp.] | diamond | 231 | 142 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 31474239 | 31474239 | PRJNA716463_P_NODE_98616_length_252_cov_3.050279_g98199_i0 | PRJNA716463 | 98616 | 252 | 3.050279 | 7.68670308 | Thermomicrobium sp. | 1969469 | Bacteria | Bacteria | 165 | 2.64e-46 | NR | MCS7256449.1 | 1969469 | g98199 | i0 | 98.8 | 0.988095238095238 | 83 | 1 | 98.8 | 0 | 251 | 3 | 42 | 124 | MCS7256449.1 hypothetical protein [Thermomicrobium sp.] | diamond | 249 | 165 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 32265235 | 32265235 | PRJNA716463_P_NODE_110238_length_242_cov_3.751479_g109820_i0 | PRJNA716463 | 110238 | 242 | 3.751479 | 9.07857918 | Thermomicrobium sp. | 1969469 | Bacteria | Bacteria | 163 | 4.32e-46 | NR | MCS7256007.1 | 1969469 | g109820 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 240 | 1 | 105 | 184 | MCS7256007.1 amylo-alpha-1,6-glucosidase [Thermomicrobium sp.] | diamond | 240 | 163 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 32265269 | 32265269 | PRJNA716463_P_NODE_85218_length_264_cov_2.842932_g84801_i0 | PRJNA716463 | 85218 | 264 | 2.842932 | 7.50534048 | Thermomicrobium sp. | 1969469 | Bacteria | Bacteria | 170 | 4.369999999999999e-47 | NR | MCS7256970.1 | 1969469 | g84801 | i0 | 100 | 0.988636363636364 | 87 | 0 | 98.9 | 0 | 3 | 263 | 306 | 392 | MCS7256970.1 primosomal protein N' [Thermomicrobium sp.] | diamond | 261 | 170 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. | ||
| 32581512 | 32581512 | PRJNA716463_P_NODE_56919_length_286_cov_1.338028_g56502_i0 | PRJNA716463 | 56919 | 286 | 1.338028 | 3.82676008 | Thermomicrobium sp. 4228-Ro | 2993937 | Bacteria | Bacteria | 199 | 5.280000000000001e-59 | NR | WP_265940293.1 | 2993937 | g56502 | i0 | 95.8 | 0.996503496503496 | 95 | 4 | 99.7 | 0 | 285 | 1 | 369 | 463 | WP_265940293.1 glycosyl hydrolase family 18 protein [Thermomicrobium sp. 4228-Ro] | diamond | 285 | 199 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermomicrobium | Thermomicrobium sp. 4228-Ro | ||
| 32644018 | 32644018 | PRJNA716463_P_NODE_91060_length_259_cov_2.844086_g90643_i0 | PRJNA716463 | 91060 | 259 | 2.844086 | 7.36618274 | Thermalbibacter longus | 2951981 | Bacteria | Bacteria | 158 | 3.2e-45 | NR | WP_284057862.1 | 2951981 | g90643 | i0 | 98.8 | 0.984555984555985 | 85 | 1 | 98.5 | 0 | 257 | 3 | 84 | 168 | WP_284057862.1 hypothetical protein [Thermalbibacter longus] | diamond | 255 | 158 | 1 | Bacteria | Pseudomonadati | Thermomicrobiota | Thermomicrobia | Thermomicrobiales | Thermomicrobiaceae | Thermalbibacter | Thermalbibacter longus |
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);;