RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1067370" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 21 ✖

bioproject 1

  • PRJNA1067370 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
181219 181219 PRJNA1067370_P_NODE_87261_length_249_cov_0.875000_g86712_i0 PRJNA1067370 87261 249 0.875 2.17875 Deinococcus roseus 392414 Bacteria Bacteria 168 3.93e-50   NR WP_189002622.1 392414 g86712 i0 97.5 0.963855421686747 80 2 96.4 0 2 241 183 262 WP_189002622.1 PSP1 domain-containing protein [Deinococcus roseus] diamond 240 168 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus roseus
1455718 1455718 PRJNA1067370_P_NODE_69422_length_265_cov_2.208333_g68873_i0 PRJNA1067370 69422 265 2.208333 5.85208245 Deinococcus indicus 223556 Bacteria Bacteria 181 1.9e-51   NR WP_191299826.1 223556 g68873 i0 98.9 1.99245283018868 88 1 99.6 0 2 265 106 193 WP_191299826.1 beta-galactosidase [Deinococcus indicus] diamond 528 181 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus indicus
2731702 2731702 PRJNA1067370_P_NODE_91423_length_248_cov_0.880000_g90874_i0 PRJNA1067370 91423 248 0.88 2.1824 Deinococcus misasensis 392413 Bacteria Bacteria 164 2.82e-46   NR WP_051963397.1 392413 g90874 i0 98.8 0.991935483870968 82 1 99.2 0 247 2 343 424 WP_051963397.1 HD-GYP domain-containing protein [Deinococcus misasensis] diamond 246 164 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
11659775 11659775 PRJNA1067370_P_NODE_86370_length_249_cov_0.875000_g85821_i0 PRJNA1067370 86370 249 0.875 2.17875 Deinococcus taklimakanensis 536443 Bacteria Bacteria 154 2.99e-44   NR WP_386843663.1 536443 g85821 i0 100 0.987951807228916 82 0 98.8 0 247 2 99 180 WP_386843663.1 4-(cytidine 5'-diphospho)-2-C-methyl-D-erythritol kinase [Deinococcus taklimakanensis] diamond 246 154 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taklimakanensis
18032241 18032241 PRJNA1067370_P_NODE_103595_length_244_cov_0.900585_g103046_i0 PRJNA1067370 103595 244 0.900585 2.1974274 Trueperaceae bacterium 2026798 Bacteria Bacteria 120 2.06e-30   NR HNQ99805.1 2026798 g103046 i0 73.1 1.91803278688525 78 21 95.9 0 242 9 173 250 HNQ99805.1 ABC transporter substrate-binding protein [Trueperaceae bacterium] diamond 468 120 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
20582249 20582249 PRJNA1067370_P_NODE_82977_length_250_cov_0.870056_g82428_i0 PRJNA1067370 82977 250 0.870056 2.17514 Deinococcus taklimakanensis 536443 Bacteria Bacteria 162 8.73e-48   NR WP_386845242.1 536443 g82428 i0 100 0.984 82 0 98.4 0 3 248 82 163 WP_386845242.1 MetQ/NlpA family ABC transporter substrate-binding protein [Deinococcus taklimakanensis] diamond 246 162 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taklimakanensis
21857424 21857424 PRJNA1067370_P_NODE_112898_length_241_cov_1.190476_g112349_i0 PRJNA1067370 112898 241 1.190476 2.86904716 Deinococcus misasensis 392413 Bacteria Bacteria 151 9.23e-44   NR WP_245618286.1 392413 g112349 i0 97.3 0.908713692946058 73 2 90.9 0 221 3 115 187 WP_245618286.1 exodeoxyribonuclease III [Deinococcus misasensis] diamond 219 151 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
26592165 26592165 PRJNA1067370_P_NODE_72301_length_261_cov_1.468085_g71752_i0 PRJNA1067370 72301 261 1.468085 3.83170185 Deinococcus misasensis 392413 Bacteria Bacteria 139 2.2399999999999998e-38   NR WP_034342196.1 392413 g71752 i0 98.6 0.839080459770115 73 1 83.9 0 2 220 210 282 WP_034342196.1 ParB/RepB/Spo0J family partition protein [Deinococcus misasensis] diamond 219 139 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
27604523 27604523 PRJNA1067370_P_NODE_73004_length_260_cov_1.438503_g72455_i0 PRJNA1067370 73004 260 1.438503 3.7401078 Deinococcus sp. 47478 Bacteria Bacteria 140 5.759999999999999e-37   NR WP_409743967.1 47478 g72455 i0 94.8 0.888461538461538 77 4 88.8 0 260 30 477 553 WP_409743967.1 hypothetical protein, partial [Deinococcus sp.] diamond 231 140 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
27636072 27636072 PRJNA1067370_P_NODE_96464_length_246_cov_0.890173_g95915_i0 PRJNA1067370 96464 246 0.890173 2.18982558 Deinococcus misasensis 392413 Bacteria Bacteria 87 7.04e-18   NR WP_051964063.1 392413 g95915 i0 97.6 0.51219512195122 42 1 51.2 0 127 2 326 367 WP_051964063.1 glycoside hydrolase family 18 protein [Deinococcus misasensis] diamond 126 87 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
28614787 28614787 PRJNA1067370_P_NODE_98587_length_246_cov_0.890173_g98038_i0 PRJNA1067370 98587 246 0.890173 2.18982558 Deinococcus terrestris 2651870 Bacteria Bacteria 135 3.56e-35   NR WP_152872313.1 2651870 g98038 i0 79 1.97560975609756 81 17 98.8 0 2 244 136 216 WP_152872313.1 hypothetical protein [Deinococcus terrestris] diamond 486 135 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus terrestris
28803950 28803950 PRJNA1067370_P_NODE_99108_length_245_cov_1.680233_g98559_i0 PRJNA1067370 99108 245 1.680233 4.11657085 Deinococcus aerophilus 522488 Bacteria Bacteria 45.4 0.00289   NR WP_188905411.1 522488 g98559 i0 45.7 0.563265306122449 46 25 56.3 0 2 139 143 188 WP_188905411.1 hypothetical protein [Deinococcus aerophilus] diamond 138 45.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aerophilus
28835643 28835643 PRJNA1067370_P_NODE_20408_length_416_cov_1.513120_g19860_i0 PRJNA1067370 20408 416 1.51312 6.2945792 Thermotogaceae bacterium 2268206 Bacteria Bacteria 123 1.36e-32   NR MCD6450070.1 2268206 g19860 i0 53.2 1.85336538461538 126 56 90.9 2 379 2 1 123 MCD6450070.1 macro domain-containing protein [Thermotogaceae bacterium] diamond 771 123 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae bacterium
29719547 29719547 PRJNA1067370_P_NODE_84790_length_250_cov_0.870056_g84241_i0 PRJNA1067370 84790 250 0.870056 2.17514 Deinococcus indicus 223556 Bacteria Bacteria 103 1.3799999999999998e-23   NR WP_172418142.1 223556 g84241 i0 98.2 2.808 57 1 68.4 0 74 244 1 57 WP_172418142.1 polymer-forming cytoskeletal protein [Deinococcus indicus] diamond 702 103 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus indicus
29751020 29751020 PRJNA1067370_P_NODE_106631_length_243_cov_0.905882_g106082_i0 PRJNA1067370 106631 243 0.905882 2.20129326 Meiothermus sp. 1955249 Bacteria Bacteria 52 1.96e-5   NR MCX7783305.1 1955249 g106082 i0 36.6 1.96296296296296 82 45 96.3 2 242 9 287 365 MCX7783305.1 carboxypeptidase regulatory-like domain-containing protein [Meiothermus sp.] diamond 477 52 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus sp.
30035749 30035749 PRJNA1067370_P_NODE_97251_length_246_cov_0.890173_g96702_i0 PRJNA1067370 97251 246 0.890173 2.18982558 Deinococcus hopiensis 309885 Bacteria Bacteria 97.8 6.38e-22   NR WP_084050371.1 309885 g96702 i0 57.3 1 82 34 98.8 1 1 243 105 186 WP_084050371.1 pyridoxal phosphate-dependent aminotransferase [Deinococcus hopiensis] diamond 246 97.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hopiensis
30067209 30067209 PRJNA1067370_P_NODE_9672_length_583_cov_1.327451_g9138_i0 PRJNA1067370 9672 583 1.327451 7.73903933 Thermus sp. 275 Bacteria Bacteria 189 2.79e-53   NR MER3602653.1 275 g9138 i0 48.4 3.87478559176672 188 93 96.2 2 13 573 365 549 MER3602653.1 penicillin acylase family protein [Thermus sp.] diamond 2259 189 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp.
30225092 30225092 PRJNA1067370_P_NODE_10612_length_559_cov_1.582305_g10072_i0 PRJNA1067370 10612 559 1.582305 8.84508495 Pyramidobacter sp. 1943581 Bacteria Bacteria 45.8 0.0442   NR MBP5212806.1 1943581 g10072 i0 40.4 0.27906976744186 52 31 27.9 0 428 273 44 95 MBP5212806.1 ankyrin repeat domain-containing protein [Pyramidobacter sp.] diamond 156 45.8 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter sp.
30952027 30952027 PRJNA1067370_P_NODE_12094_length_526_cov_1.556291_g11549_i0 PRJNA1067370 12094 526 1.556291 8.18609066 Synergistaceae bacterium 2053624 Bacteria Bacteria 70.5 7.23e-11   NR MBQ6774219.1 2053624 g11549 i0 43.8 0.416349809885932 73 41 41.6 0 274 492 208 280 MBQ6774219.1 sel1 repeat family protein [Synergistaceae bacterium] diamond 219 70.5 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
31267983 31267983 PRJNA1067370_P_NODE_8495_length_619_cov_5.003663_g7966_i0 PRJNA1067370 8495 619 5.003663 30.97267397 Deinococcota bacterium 1913990 Bacteria Bacteria 110 9.54e-25   NR MDQ3398686.1 1913990 g7966 i0 43 0.688206785137318 142 72 67.4 4 90 506 113 248 MDQ3398686.1 hypothetical protein [Deinococcota bacterium] diamond 426 110 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
31805585 31805585 PRJNA1067370_P_NODE_63137_length_275_cov_1.301980_g62588_i0 PRJNA1067370 63137 275 1.30198 3.580445 Deinococcus indicus 223556 Bacteria Bacteria 69.3 3.56e-13   NR GHG37758.1 223556 g62588 i0 80 0.436363636363636 40 8 43.6 0 153 272 15 54 GHG37758.1 hypothetical protein GCM10017784_35270 [Deinococcus indicus] diamond 120 69.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus indicus

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