RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1196438" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 22 ✖

bioproject 1

  • PRJNA1196438 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
1597840 1597840 PRJNA1196438_P_NODE_50182_length_273_cov_1.350000_g49755_i0 PRJNA1196438 50182 273 1.35 3.6855 Truepera 332248 Bacteria Bacteria 169 3.18e-47   NR WP_013177828.1 332249 g49755 i0 91.2 12 91 8 100 0 1 273 276 366 WP_013177828.1 ATP-dependent zinc metalloprotease FtsH [Truepera radiovictrix] diamond 3276 169 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
1598305 1598305 PRJNA1196438_P_NODE_82662_length_228_cov_2.941935_g82235_i0 PRJNA1196438 82662 228 2.941935 6.7076118 Synergistaceae bacterium 2053624 Bacteria Bacteria 162 3.37e-44   NR MBQ6772471.1 2053624 g82235 i0 88 13.8157894736842 75 9 98.7 0 227 3 395 469 MBQ6772471.1 isoleucine--tRNA ligase [Synergistaceae bacterium] diamond 3150 162 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
23275489 23275489 PRJNA1196438_P_NODE_53219_length_268_cov_2.389744_g52792_i0 PRJNA1196438 53219 268 2.389744 6.40451392 Truepera radiovictrix 332249 Bacteria Bacteria 162 7.99e-46   NR WP_013178496.1 332249 g52792 i0 92 0.973880597014925 87 7 97.4 0 6 266 369 455 WP_013178496.1 V-type ATP synthase subunit B [Truepera radiovictrix] diamond 261 162 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
26787786 26787786 PRJNA1196438_P_NODE_42101_length_285_cov_4.580189_g41674_i0 PRJNA1196438 42101 285 4.580189 13.05353865 Deinococcus sp. 47478 Bacteria Bacteria 103 1.93e-23   NR MDO4264595.1 47478 g41674 i0 77 1.27368421052632 61 14 64.2 0 26 208 122 182 MDO4264595.1 alkaline phosphatase D family protein [Deinococcus sp.] diamond 363 103 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
27325385 27325385 PRJNA1196438_P_NODE_60903_length_257_cov_1.548913_g60476_i0 PRJNA1196438 60903 257 1.548913 3.98070641 Deinococcus reticulitermitis 856736 Bacteria Bacteria 162 1.69e-48   NR WP_092265074.1 856736 g60476 i0 95.3 0.992217898832685 85 4 99.2 0 255 1 86 170 WP_092265074.1 GNAT family N-acetyltransferase [Deinococcus reticulitermitis] diamond 255 162 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
27420441 27420441 PRJNA1196438_P_NODE_82683_length_228_cov_2.890323_g82256_i0 PRJNA1196438 82683 228 2.890323 6.58993644 Cloacibacillus evryensis 508460 Bacteria Bacteria 99.4 2.31e-22   NR WP_008712088.1 508460 g82256 i0 62.2 0.973684210526316 74 28 97.4 0 226 5 302 375 WP_008712088.1 restriction endonuclease subunit S [Cloacibacillus evryensis] diamond 222 99.4 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Cloacibacillus Cloacibacillus evryensis
27546427 27546427 PRJNA1196438_P_NODE_36004_length_295_cov_3.058559_g35578_i0 PRJNA1196438 36004 295 3.058559 9.02274905 Deinococcus humi 662880 Bacteria Bacteria 60.8 1.26e-8   NR WP_184138351.1 662880 g35578 i0 74.4 0.396610169491525 39 9 38.6 1 116 3 16 54 WP_184138351.1 hypothetical protein [Deinococcus humi] diamond 117 60.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus humi
27672909 27672909 PRJNA1196438_P_NODE_75784_length_242_cov_1.846154_g75357_i0 PRJNA1196438 75784 242 1.846154 4.46769268 Fretibacterium sp. 2699746 Bacteria Bacteria 50.8 4.87e-5   NR MCR5346238.1 2699746 g75357 i0 49 0.632231404958678 51 21 63.2 1 158 6 4 49 MCR5346238.1 UDP-3-O-(3-hydroxymyristoyl)glucosamine N-acyltransferase [Fretibacterium sp.] diamond 153 50.8 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium sp.
28525382 28525382 PRJNA1196438_P_NODE_41287_length_287_cov_1.453271_g40860_i0 PRJNA1196438 41287 287 1.453271 4.17088777 Fretibacterium sp. 2699746 Bacteria Bacteria 105 1.59e-25   NR NLL36165.1 2699746 g40860 i0 50.5 0.993031358885017 95 47 99.3 0 285 1 105 199 NLL36165.1 hypothetical protein [Fretibacterium sp.] diamond 285 105 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium sp.
28777696 28777696 PRJNA1196438_P_NODE_52907_length_269_cov_1.377551_g52480_i0 PRJNA1196438 52907 269 1.377551 3.70561219 uncultured Fretibacterium sp. 1678694 Bacteria Bacteria 58.9 1.04e-7   NR WP_298780763.1 1678694 g52480 i0 40.7 3.72490706319703 81 46 90.3 1 23 265 391 469 WP_298780763.1 flagellar filament capping protein FliD [uncultured Fretibacterium sp.] diamond 1002 58.9 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium uncultured Fretibacterium sp.
29220038 29220038 PRJNA1196438_P_NODE_85789_length_212_cov_4.863309_g85361_i0 PRJNA1196438 85789 212 4.863309 10.31021508 Deinococcus multiflagellatus 1656887 Bacteria Bacteria 46.2 6.91e-4   NR WP_224607452.1 1656887 g85361 i0 84.6 0.367924528301887 26 4 36.8 0 81 4 1 26 WP_224607452.1 universal stress protein [Deinococcus multiflagellatus] diamond 78 46.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus multiflagellatus
30186133 30186133 PRJNA1196438_P_NODE_53012_length_268_cov_4.379487_g52585_i0 PRJNA1196438 53012 268 4.379487 11.73702516 Bacteria 2 Bacteria Bacteria 115 4.58e-29   NR WP_051682865.1 2754 g52585 i0 59.1 12.8619402985075 88 36 98.5 0 268 5 38 125 WP_051682865.1 patatin-like phospholipase family protein [Synergistes jonesii] diamond 3447 115 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Synergistes Synergistes jonesii
30376231 30376231 PRJNA1196438_P_NODE_38492_length_291_cov_2.091743_g38065_i0 PRJNA1196438 38492 291 2.091743 6.08697213 Deinococcus 1298 Bacteria Bacteria 135 8.230000000000001e-36   NR WP_322618643.1 2651870 g38065 i0 81.6 1.89690721649485 98 11 93.8 1 274 2 2 99 WP_322618643.1 HD domain-containing phosphohydrolase [Deinococcus terrestris] diamond 552 135 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus terrestris
30641057 30641057 PRJNA1196438_P_NODE_66333_length_251_cov_0.876404_g65906_i0 PRJNA1196438 66333 251 0.876404 2.19977404 Deinococcus koreensis 2054903 Bacteria Bacteria 107 6.260000000000001e-26   NR WP_103313286.1 2054903 g65906 i0 74.6 0.848605577689243 71 17 84.9 1 2 214 246 315 WP_103313286.1 DUF2268 domain-containing protein [Deinococcus koreensis] diamond 213 107 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus koreensis
30672687 30672687 PRJNA1196438_P_NODE_75133_length_243_cov_0.917647_g74706_i0 PRJNA1196438 75133 243 0.917647 2.22988221 Synergistaceae bacterium 2053624 Bacteria Bacteria 149 4.62e-42   NR MBQ4470446.1 2053624 g74706 i0 78.5 6.82716049382716 79 17 97.5 0 1 237 223 301 MBQ4470446.1 homoserine O-succinyltransferase [Synergistaceae bacterium] diamond 1659 149 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
30786524 30786524 PRJNA1196438_P_NODE_40074_length_289_cov_1.199074_g39647_i0 PRJNA1196438 40074 289 1.199074 3.46532386 Deinococcus 1298 Bacteria Bacteria 158 1.41e-44   NR WP_019586988.1 309886 g39647 i0 84.4 1.99307958477509 96 15 99.7 0 1 288 152 247 WP_019586988.1 TCR/Tet family MFS transporter [Deinococcus apachensis] diamond 576 159 0.993710691823899 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus apachensis
31114894 31114894 PRJNA1196438_P_NODE_36735_length_294_cov_2.040724_g36309_i0 PRJNA1196438 36735 294 2.040724 5.99972856 Thermotogota bacterium 2053689 Bacteria Bacteria 48.9 4.86e-4   NR HRW35710.1 2053689 g36309 i0 47.3 1.63265306122449 55 29 56.1 0 1 165 727 781 HRW35710.1 BREX system P-loop protein BrxC [Thermotogota bacterium] diamond 480 48.9 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
31146338 31146338 PRJNA1196438_P_NODE_87355_length_204_cov_4.282443_g86927_i0 PRJNA1196438 87355 204 4.282443 8.73618372 Thermus sp. 275 Bacteria Bacteria 139 3.3e-36   NR WP_370534255.1 275 g86927 i0 97.1 1 68 2 100 0 1 204 622 689 WP_370534255.1 hypothetical protein [Thermus sp.] diamond 204 139 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp.
31431306 31431306 PRJNA1196438_P_NODE_82036_length_229_cov_3.967949_g81609_i0 PRJNA1196438 82036 229 3.967949 9.08660321 Fretibacterium sp. 2699746 Bacteria Bacteria 134 1.0599999999999998e-37   NR MBR1672285.1 2699746 g81609 i0 84.2 1.99126637554585 76 12 99.6 0 2 229 21 96 MBR1672285.1 adenylate kinase [Fretibacterium sp.] diamond 456 134 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium sp.
31684193 31684193 PRJNA1196438_P_NODE_52537_length_269_cov_2.454082_g52110_i0 PRJNA1196438 52537 269 2.454082 6.60148058 Deinococcus koreensis 2054903 Bacteria Bacteria 155 3.7e-45   NR WP_103310167.1 2054903 g52110 i0 98.8 0.936802973977695 84 1 93.7 0 1 252 63 146 WP_103310167.1 hypothetical protein [Deinococcus koreensis] diamond 252 155 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus koreensis
32285798 32285798 PRJNA1196438_P_NODE_19559_length_312_cov_3.092050_g19133_i0 PRJNA1196438 19559 312 3.09205 9.647196 Deinococcus antarcticus 1298767 Bacteria Bacteria 108 3.05e-26   NR WP_380078377.1 1298767 g19133 i0 100 0.480769230769231 50 0 48.1 0 2 151 108 157 WP_380078377.1 metallophosphoesterase [Deinococcus antarcticus] diamond 150 108 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
32696109 32696109 PRJNA1196438_P_NODE_71060_length_246_cov_2.514451_g70633_i0 PRJNA1196438 71060 246 2.514451 6.18554946 Thermus scotoductus 37636 Bacteria Bacteria 185 1.1399999999999997e-52   NR WP_019551494.1 37636 g70633 i0 100 2 82 0 100 0 246 1 410 491 WP_019551494.1 type III-A CRISPR-associated protein Cas10/Csm1 [Thermus scotoductus] diamond 492 185 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus

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