contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA1137393" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7937805 | 7937805 | PRJNA1137393_P_NODE_52947_length_166_cov_0.888889_g52431_i0 | PRJNA1137393 | 52947 | 166 | 0.888889 | 1.47555574 | Bacteria | 2 | Bacteria | Bacteria | 88.6 | 4.68e-19 | NR | MEM7739150.1 | 1913990 | g52431 | i0 | 81.8 | 4.96987951807229 | 55 | 10 | 99.4 | 0 | 165 | 1 | 1 | 55 | MEM7739150.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Deinococcota bacterium] | diamond | 825 | 88.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 17609748 | 17609748 | PRJNA1137393_P_NODE_39974_length_169_cov_0.866667_g39458_i0 | PRJNA1137393 | 39974 | 169 | 0.866667 | 1.46466723 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 107 | 9.81e-29 | NR | WP_386846465.1 | 536443 | g39458 | i0 | 98.2 | 0.994082840236686 | 56 | 1 | 99.4 | 0 | 168 | 1 | 7 | 62 | WP_386846465.1 hypothetical protein [Deinococcus taklimakanensis] | diamond | 168 | 107 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis | ||
| 17609756 | 17609756 | PRJNA1137393_P_NODE_46854_length_168_cov_0.873950_g46338_i0 | PRJNA1137393 | 46854 | 168 | 0.87395 | 1.468236 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 103 | 7.03e-25 | NR | WP_013179062.1 | 332249 | g46338 | i0 | 91.1 | 2 | 56 | 5 | 100 | 0 | 168 | 1 | 119 | 174 | WP_013179062.1 class II fructose-bisphosphatase [Truepera radiovictrix] | diamond | 336 | 103 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 17609769 | 17609769 | PRJNA1137393_P_NODE_53114_length_166_cov_0.888889_g52598_i0 | PRJNA1137393 | 53114 | 166 | 0.888889 | 1.47555574 | Bacteria | 2 | Bacteria | Bacteria | 73.9 | 9.22e-14 | NR | HET9027433.1 | 2026798 | g52598 | i0 | 65.5 | 4.95180722891566 | 55 | 19 | 99.4 | 0 | 1 | 165 | 178 | 232 | HET9027433.1 threonine/serine dehydratase [Trueperaceae bacterium] | diamond | 822 | 74.3 | 0.994616419919246 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 23984417 | 23984417 | PRJNA1137393_P_NODE_53739_length_166_cov_0.888889_g53223_i0 | PRJNA1137393 | 53739 | 166 | 0.888889 | 1.47555574 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 105 | 1.38e-24 | NR | MCA9838136.1 | 2026798 | g53223 | i0 | 90.6 | 0.957831325301205 | 53 | 5 | 95.8 | 0 | 161 | 3 | 294 | 346 | MCA9838136.1 preprotein translocase subunit SecA [Trueperaceae bacterium] | diamond | 159 | 105 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 27038734 | 27038734 | PRJNA1137393_P_NODE_63262_length_164_cov_0.904348_g62746_i0 | PRJNA1137393 | 63262 | 164 | 0.904348 | 1.48313072 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 72.8 | 2.2e-13 | NR | CAA9569780.1 | 543023 | g62746 | i0 | 70.4 | 0.98780487804878 | 54 | 16 | 98.8 | 0 | 164 | 3 | 118 | 171 | CAA9569780.1 MAG: hypothetical protein AVDCRST_MAG86-1647 [uncultured Truepera sp.] | diamond | 162 | 72.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 27291688 | 27291688 | PRJNA1137393_P_NODE_36543_length_172_cov_1.626016_g36027_i0 | PRJNA1137393 | 36543 | 172 | 1.626016 | 2.79674752 | Deinococcus aestuarii | 2774531 | Bacteria | Bacteria | 75.1 | 5.66e-14 | NR | WP_246581011.1 | 2774531 | g36027 | i0 | 84.1 | 0.767441860465116 | 44 | 7 | 76.7 | 0 | 132 | 1 | 1 | 44 | WP_246581011.1 RecQ family ATP-dependent DNA helicase [Deinococcus aestuarii] | diamond | 132 | 75.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aestuarii | ||
| 27418289 | 27418289 | PRJNA1137393_P_NODE_50623_length_167_cov_0.881356_g50107_i0 | PRJNA1137393 | 50623 | 167 | 0.881356 | 1.47186452 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 94.7 | 6.370000000000001e-21 | NR | WP_013177725.1 | 332249 | g50107 | i0 | 83.6 | 1.97604790419162 | 55 | 9 | 98.8 | 0 | 167 | 3 | 233 | 287 | WP_013177725.1 3D-(3,5/4)-trihydroxycyclohexane-1,2-dione acylhydrolase (decyclizing) [Truepera radiovictrix] | diamond | 330 | 94.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 27734105 | 27734105 | PRJNA1137393_P_NODE_51264_length_167_cov_0.881356_g50748_i0 | PRJNA1137393 | 51264 | 167 | 0.881356 | 1.47186452 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 58.9 | 2.58e-8 | NR | CAA9588633.1 | 543023 | g50748 | i0 | 67.3 | 0.988023952095808 | 55 | 17 | 98.8 | 1 | 167 | 3 | 64 | 117 | CAA9588633.1 MAG: hypothetical protein AVDCRST_MAG86-4166 [uncultured Truepera sp.] | diamond | 165 | 58.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 28080992 | 28080992 | PRJNA1137393_P_NODE_55105_length_166_cov_0.888889_g54589_i0 | PRJNA1137393 | 55105 | 166 | 0.888889 | 1.47555574 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 102 | 1.0899999999999999e-23 | NR | WP_380079499.1 | 1298767 | g54589 | i0 | 98.1 | 0.975903614457831 | 54 | 1 | 97.6 | 0 | 3 | 164 | 58 | 111 | WP_380079499.1 ABC transporter permease subunit [Deinococcus antarcticus] | diamond | 162 | 102 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 28807019 | 28807019 | PRJNA1137393_P_NODE_63768_length_164_cov_0.904348_g63252_i0 | PRJNA1137393 | 63768 | 164 | 0.904348 | 1.48313072 | Deinococcus gobiensis | 502394 | Bacteria | Bacteria | 42.7 | 0.0129 | NR | WP_043803617.1 | 502394 | g63252 | i0 | 75 | 0.51219512195122 | 28 | 7 | 51.2 | 0 | 142 | 59 | 1 | 28 | WP_043803617.1 S8 family serine peptidase [Deinococcus gobiensis] | diamond | 84 | 42.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus gobiensis | ||
| 28870366 | 28870366 | PRJNA1137393_P_NODE_55588_length_166_cov_0.888889_g55072_i0 | PRJNA1137393 | 55588 | 166 | 0.888889 | 1.47555574 | Fretibacterium sp. OH122 | 2699746 | Bacteria | Bacteria | 108 | 6.39e-26 | NR | WP_124888786.1 | 2491047 | g55072 | i0 | 98.2 | 0.993975903614458 | 55 | 1 | 99.4 | 0 | 2 | 166 | 712 | 766 | WP_124888786.1 hydratase [Fretibacterium sp. OH1220_COT-178] | diamond | 165 | 108 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium sp. OH1220_COT-178 | ||
| 29028621 | 29028621 | PRJNA1137393_P_NODE_68128_length_163_cov_0.912281_g67612_i0 | PRJNA1137393 | 68128 | 163 | 0.912281 | 1.48701803 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 109 | 7.73e-29 | NR | WP_386843278.1 | 536443 | g67612 | i0 | 98 | 0.938650306748466 | 51 | 1 | 93.9 | 0 | 2 | 154 | 100 | 150 | WP_386843278.1 hypothetical protein [Deinococcus taklimakanensis] | diamond | 153 | 109 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis | ||
| 29785983 | 29785983 | PRJNA1137393_P_NODE_59391_length_165_cov_0.896552_g58875_i0 | PRJNA1137393 | 59391 | 165 | 0.896552 | 1.4793108 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 94.4 | 1.06e-21 | NR | CAA9584017.1 | 543023 | g58875 | i0 | 87 | 1.96363636363636 | 54 | 7 | 98.2 | 0 | 164 | 3 | 168 | 221 | CAA9584017.1 MAG: Purine nucleoside phosphorylase [uncultured Truepera sp.] | diamond | 324 | 94.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 30185731 | 30185731 | PRJNA1137393_P_NODE_47072_length_168_cov_0.873950_g46556_i0 | PRJNA1137393 | 47072 | 168 | 0.87395 | 1.468236 | Bacteria | 2 | Bacteria | Bacteria | 55.1 | 2.58e-7 | NR | WP_278912618.1 | 980427 | g46556 | i0 | 48.1 | 3.78571428571429 | 54 | 28 | 96.4 | 0 | 2 | 163 | 20 | 73 | WP_278912618.1 HdeD family acid-resistance protein [Deinococcus wulumuqiensis] | diamond | 636 | 55.5 | 0.992792792792793 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 30260226 | 30260226 | PRJNA1137393_P_NODE_70292_length_162_cov_0.920354_g69776_i0 | PRJNA1137393 | 70292 | 162 | 0.920354 | 1.49097348 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 52 | 6.37e-6 | NR | CAA9562222.1 | 543023 | g69776 | i0 | 59.6 | 0.87037037037037 | 47 | 19 | 87 | 0 | 21 | 161 | 157 | 203 | CAA9562222.1 MAG: Integral membrane protein [uncultured Truepera sp.] | diamond | 141 | 52 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 30418301 | 30418301 | PRJNA1137393_P_NODE_68753_length_163_cov_0.912281_g68237_i0 | PRJNA1137393 | 68753 | 163 | 0.912281 | 1.48701803 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 90.1 | 4.05e-20 | NR | CAA9559608.1 | 543023 | g68237 | i0 | 89.8 | 0.901840490797546 | 49 | 5 | 90.2 | 0 | 1 | 147 | 228 | 276 | CAA9559608.1 MAG: hypothetical protein AVDCRST_MAG86-666 [uncultured Truepera sp.] | diamond | 147 | 90.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 30955284 | 30955284 | PRJNA1137393_P_NODE_36734_length_172_cov_1.349593_g36218_i0 | PRJNA1137393 | 36734 | 172 | 1.349593 | 2.32129996 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 83.6 | 8.06e-19 | NR | MDZ7704030.1 | 2026798 | g36218 | i0 | 66.7 | 0.994186046511628 | 57 | 19 | 99.4 | 0 | 1 | 171 | 20 | 76 | MDZ7704030.1 transposase [Trueperaceae bacterium] | diamond | 171 | 83.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 31576517 | 31576517 | PRJNA1137393_P_NODE_73236_length_162_cov_0.920354_g72720_i0 | PRJNA1137393 | 73236 | 162 | 0.920354 | 1.49097348 | Truepera | 332248 | Bacteria | Bacteria | 99.4 | 8.119999999999999e-23 | NR | HEX7003125.1 | 2026798 | g72720 | i0 | 88.7 | 5.88888888888889 | 53 | 6 | 98.1 | 0 | 3 | 161 | 174 | 226 | HEX7003125.1 O-acetylhomoserine aminocarboxypropyltransferase/cysteine synthase [Trueperaceae bacterium] | diamond | 954 | 99.8 | 0.995991983967936 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 31587530 | 31587530 | PRJNA1137393_P_NODE_42596_length_169_cov_0.866667_g42080_i0 | PRJNA1137393 | 42596 | 169 | 0.866667 | 1.46466723 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 85.9 | 7.64e-18 | NR | WP_013177405.1 | 332249 | g42080 | i0 | 79.6 | 1.91715976331361 | 54 | 11 | 95.9 | 0 | 5 | 166 | 224 | 277 | WP_013177405.1 dihydrolipoyl dehydrogenase [Truepera radiovictrix] | diamond | 324 | 85.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 31608042 | 31608042 | PRJNA1137393_P_NODE_49236_length_167_cov_0.881356_g48720_i0 | PRJNA1137393 | 49236 | 167 | 0.881356 | 1.47186452 | Bacteria | 2 | Bacteria | Bacteria | 63.5 | 1.08e-10 | NR | OPZ34848.1 | 1852916 | g48720 | i0 | 57.4 | 4.83233532934132 | 54 | 23 | 97 | 0 | 167 | 6 | 114 | 167 | OPZ34848.1 MAG: hypothetical protein BWY99_02411 [Synergistetes bacterium ADurb.BinA166] | diamond | 807 | 63.9 | 0.993740219092332 | Bacteria | Thermotogati | Synergistota | Synergistetes bacterium ADurb.BinA166 | ||||||
| 31808791 | 31808791 | PRJNA1137393_P_NODE_43517_length_168_cov_1.310924_g43001_i0 | PRJNA1137393 | 43517 | 168 | 1.310924 | 2.20235232 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 87.8 | 7.03e-19 | NR | WP_013178521.1 | 332249 | g43001 | i0 | 70.9 | 0.982142857142857 | 55 | 16 | 98.2 | 0 | 166 | 2 | 216 | 270 | WP_013178521.1 nitrilase-related carbon-nitrogen hydrolase [Truepera radiovictrix] | diamond | 165 | 87.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 32030350 | 32030350 | PRJNA1137393_P_NODE_63758_length_164_cov_0.904348_g63242_i0 | PRJNA1137393 | 63758 | 164 | 0.904348 | 1.48313072 | Deinococcus aquatilis | 519440 | Bacteria | Bacteria | 56.6 | 1.61e-7 | NR | WP_026298575.1 | 519440 | g63242 | i0 | 44.4 | 0.98780487804878 | 54 | 30 | 98.8 | 0 | 163 | 2 | 507 | 560 | WP_026298575.1 hypothetical protein [Deinococcus aquatilis] | diamond | 162 | 56.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquatilis | ||
| 32536707 | 32536707 | PRJNA1137393_P_NODE_39939_length_169_cov_0.866667_g39423_i0 | PRJNA1137393 | 39939 | 169 | 0.866667 | 1.46466723 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 97.4 | 3.58e-22 | NR | WP_013177681.1 | 332249 | g39423 | i0 | 85.7 | 2.96449704142012 | 56 | 8 | 99.4 | 0 | 169 | 2 | 199 | 254 | WP_013177681.1 class I SAM-dependent rRNA methyltransferase [Truepera radiovictrix] | diamond | 501 | 97.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 32536710 | 32536710 | PRJNA1137393_P_NODE_65659_length_163_cov_0.912281_g65143_i0 | PRJNA1137393 | 65659 | 163 | 0.912281 | 1.48701803 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 43.9 | 0.0034 | NR | CAA9584662.1 | 543023 | g65143 | i0 | 60 | 0.552147239263804 | 30 | 12 | 55.2 | 0 | 162 | 73 | 143 | 172 | CAA9584662.1 MAG: hypothetical protein AVDCRST_MAG86-3323 [uncultured Truepera sp.] | diamond | 90 | 43.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. |
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);;