RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA792582" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 13 ✖

bioproject 1

  • PRJNA792582 · 13 ✖

analysis 1

  • diamond · 13 ✖

tax_clade 0

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
17793145 17793145 PRJNA792582_P_NODE_37794_length_283_cov_3.171429_g36980_i0 PRJNA792582 37794 283 3.171429 8.97514407 Deinococcus yavapaiensis 309889 Bacteria Bacteria 162 5.71e-44   NR WP_110887571.1 309889 g36980 i0 91.4 0.985865724381625 93 8 98.6 0 279 1 250 342 WP_110887571.1 type I DNA topoisomerase [Deinococcus yavapaiensis] diamond 279 162 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yavapaiensis
18628548 18628548 PRJNA792582_P_NODE_40775_length_275_cov_3.267327_g39961_i0 PRJNA792582 40775 275 3.267327 8.98514925 Deinococcus yavapaiensis 309889 Bacteria Bacteria 156 7.71e-44   NR WP_110884858.1 309889 g39961 i0 81.3 0.992727272727273 91 17 99.3 0 275 3 67 157 WP_110884858.1 serine--tRNA ligase [Deinococcus yavapaiensis] diamond 273 156 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yavapaiensis
21179377 21179377 PRJNA792582_P_NODE_30957_length_310_cov_2.945148_g30143_i0 PRJNA792582 30957 310 2.945148 9.1299588 Deinococcus yavapaiensis 309889 Bacteria Bacteria 82.8 6.25e-17   NR WP_110885701.1 309889 g30143 i0 84 0.483870967741935 50 8 48.4 0 309 160 114 163 WP_110885701.1 GGDEF domain-containing protein [Deinococcus yavapaiensis] diamond 150 82.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yavapaiensis
28096067 28096067 PRJNA792582_P_NODE_49465_length_251_cov_1.730337_g48651_i0 PRJNA792582 49465 251 1.730337 4.34314587 uncultured Truepera sp. 543023 Bacteria Bacteria 147 1.46e-41   NR CAA9557753.1 543023 g48651 i0 86.7 0.99203187250996006 83 11 99.2 0 251 3 14 96 CAA9557753.1 MAG: Metallophosphoesterase [uncultured Truepera sp.] diamond 249 147 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
29012055 29012055 PRJNA792582_P_NODE_60548_length_230_cov_2.834395_g59734_i0 PRJNA792582 60548 230 2.834395 6.5191085 Deinococcus aestuarii 2774531 Bacteria Bacteria 111 1.87e-29   NR WP_216321676.1 2774531 g59734 i0 75.3 1.00434782608696 77 18 99.1 1 3 230 36 112 WP_216321676.1 hypothetical protein [Deinococcus aestuarii] diamond 231 111 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aestuarii
29674414 29674414 PRJNA792582_P_NODE_36490_length_287_cov_1.359813_g35676_i0 PRJNA792582 36490 287 1.359813 3.90266331 Deinococcus peraridilitoris 432329 Bacteria Bacteria 130 7.04e-33   NR WP_169316626.1 432329 g35676 i0 72.3 0.982578397212544 94 26 98.3 0 282 1 114 207 WP_169316626.1 UvrD-helicase domain-containing protein [Deinococcus peraridilitoris] diamond 282 130 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
30085259 30085259 PRJNA792582_P_NODE_41752_length_273_cov_1.535000_g40938_i0 PRJNA792582 41752 273 1.535 4.19055 Deinococcus cavernae 2320857 Bacteria Bacteria 176 6.5e-54   NR WP_199698478.1 2320857 g40938 i0 96.7 1 91 3 100 0 1 273 64 154 WP_199698478.1 hypothetical protein [Deinococcus cavernae] diamond 273 176 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
30780454 30780454 PRJNA792582_P_NODE_47154_length_258_cov_1.524324_g46340_i0 PRJNA792582 47154 258 1.524324 3.93275592 Deinococcus yavapaiensis 309889 Bacteria Bacteria 117 1.09e-29   NR WP_110886334.1 309889 g46340 i0 83.9 0.720930232558139 62 10 72.1 0 257 72 259 320 WP_110886334.1 hypothetical protein [Deinococcus yavapaiensis] diamond 186 117 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yavapaiensis
30812016 30812016 PRJNA792582_P_NODE_58574_length_242_cov_0.911243_g57760_i0 PRJNA792582 58574 242 0.911243 2.20520806 Deinobacterium chartae 521158 Bacteria Bacteria 52 1.96e-5   NR WP_183986515.1 521158 g57760 i0 46.3 0.669421487603306 54 21 57 1 242 105 388 441 WP_183986515.1 ammonium transporter [Deinobacterium chartae] diamond 162 52 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinobacterium Deinobacterium chartae
31190873 31190873 PRJNA792582_P_NODE_56475_length_244_cov_0.900585_g55661_i0 PRJNA792582 56475 244 0.900585 2.1974274 Truepera radiovictrix 332249 Bacteria Bacteria 151 6.67e-42   NR WP_221401673.1 332249 g55661 i0 92.6 0.995901639344262 81 6 99.6 0 243 1 14 94 WP_221401673.1 replicative DNA helicase [Truepera radiovictrix] diamond 243 151 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
31381146 31381146 PRJNA792582_P_NODE_49096_length_252_cov_1.720670_g48282_i0 PRJNA792582 49096 252 1.72067 4.3360884 uncultured Fretibacterium sp. 1678694 Bacteria Bacteria 162 3.86e-44   NR WP_299302331.1 1678694 g48282 i0 97.6 2 84 2 100 0 252 1 516 599 WP_299302331.1 dynamin family protein [uncultured Fretibacterium sp.] diamond 504 162 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium uncultured Fretibacterium sp.
31665542 31665542 PRJNA792582_P_NODE_29397_length_318_cov_1.938776_g28583_i0 PRJNA792582 29397 318 1.938776 6.16530768 Trueperaceae bacterium 2026798 Bacteria Bacteria 44.7 0.0172   NR MBX3140573.1 2026798 g28583 i0 31.6 1.07547169811321 114 60 90.6 6 304 17 192 305 MBX3140573.1 tellurite resistance/C4-dicarboxylate transporter family protein [Trueperaceae bacterium] diamond 342 44.7 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
32298765 32298765 PRJNA792582_P_NODE_54239_length_246_cov_1.780347_g53425_i0 PRJNA792582 54239 246 1.780347 4.37965362 Trueperaceae bacterium 2026798 Bacteria Bacteria 54.3 2.76e-6   NR MCA9838103.1 2026798 g53425 i0 75 0.439024390243902 36 9 43.9 0 137 244 8 43 MCA9838103.1 ABC transporter permease [Trueperaceae bacterium] diamond 108 54.3 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;