RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA682078" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 23 ✖

bioproject 1

  • PRJNA682078 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
1935345 1935345 PRJNA682078_P_NODE_174362_length_278_cov_1.346341_g172585_i0 PRJNA682078 174362 278 1.346341 3.74282798 Deinococcus koreensis 2054903 Bacteria Bacteria 169 1.93e-50   NR WP_165795168.1 2054903 g172585 i0 87 1.98561151079137 92 12 99.3 0 277 2 70 161 WP_165795168.1 signal peptidase I [Deinococcus koreensis] diamond 552 169 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus koreensis
3210739 3210739 PRJNA682078_P_NODE_194703_length_266_cov_1.388601_g192926_i0 PRJNA682078 194703 266 1.388601 3.69367866 Deinococcus antarcticus 1298767 Bacteria Bacteria 170 4.43e-50   NR WP_380078945.1 1298767 g192926 i0 98.9 0.992481203007519 88 1 99.2 0 264 1 201 288 WP_380078945.1 MDR family oxidoreductase [Deinococcus antarcticus] diamond 264 170 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
7549800 7549800 PRJNA682078_P_NODE_13366_length_947_cov_2.479405_g12003_i0 PRJNA682078 13366 947 2.479405 23.47996535 Bacteria 2 Bacteria Bacteria 593 2.6299999999999993e-205   NR 1TAQ_A 271 g12003 i0 100 2.78775079197466 295 0 93.5 0 885 1 1 295 1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus] diamond 2640 593 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
10864500 10864500 PRJNA682078_P_NODE_217289_length_253_cov_1.666667_g215512_i0 PRJNA682078 217289 253 1.666667 4.21666751 Deinococcus roseus 392414 Bacteria Bacteria 164 2.52e-47   NR WP_189002566.1 392414 g215512 i0 94 0.99604743083004 84 5 99.6 0 2 253 119 202 WP_189002566.1 thiolase family protein [Deinococcus roseus] diamond 252 164 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus roseus
13414867 13414867 PRJNA682078_P_NODE_235971_length_249_cov_0.875000_g234194_i0 PRJNA682078 235971 249 0.875 2.17875 Deinococcus reticulitermitis 856736 Bacteria Bacteria 79 1.9e-16   NR WP_092264984.1 856736 g234194 i0 97.3 0.44578313253012 37 1 44.6 0 247 137 108 144 WP_092264984.1 hypothetical protein [Deinococcus reticulitermitis] diamond 111 79 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
21063700 21063700 PRJNA682078_P_NODE_245177_length_248_cov_0.880000_g243400_i0 PRJNA682078 245177 248 0.88 2.1824 Deinococcus antarcticus 1298767 Bacteria Bacteria 169 4.459999999999999e-48   NR WP_380079822.1 1298767 g243400 i0 98.8 0.991935483870968 82 1 99.2 0 3 248 159 240 WP_380079822.1 amidohydrolase [Deinococcus antarcticus] diamond 246 169 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
21064281 21064281 PRJNA682078_P_NODE_269457_length_244_cov_0.900585_g267680_i0 PRJNA682078 269457 244 0.900585 2.1974274 Deinococcus reticulitermitis 856736 Bacteria Bacteria 163 1.36e-48   NR WP_092263046.1 856736 g267680 i0 98.8 0.983606557377049 80 1 98.4 0 240 1 23 102 WP_092263046.1 HAD family hydrolase [Deinococcus reticulitermitis] diamond 240 163 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
21064630 21064630 PRJNA682078_P_NODE_283617_length_242_cov_0.911243_g281840_i0 PRJNA682078 283617 242 0.911243 2.20520806 Deinococcus caeni 569127 Bacteria Bacteria 146 1.18e-41   NR WP_380064576.1 569127 g281840 i0 98.8 1.98347107438017 80 1 99.2 0 242 3 66 145 WP_380064576.1 S8 family serine peptidase [Deinococcus caeni] diamond 480 146 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus caeni
26607082 26607082 PRJNA682078_P_NODE_274021_length_243_cov_1.411765_g272244_i0 PRJNA682078 274021 243 1.411765 3.43058895 Trueperaceae bacterium 2026798 Bacteria Bacteria 139 1.17e-38   NR HZW98916.1 2026798 g272244 i0 85 3.95061728395062 80 12 98.8 0 241 2 84 163 HZW98916.1 undecaprenyl-diphosphate phosphatase [Trueperaceae bacterium] diamond 960 139 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
26745256 26745256 PRJNA682078_P_NODE_159141_length_287_cov_4.345794_g157364_i0 PRJNA682078 159141 287 4.345794 12.47242878 root 1 Root_unresolved Root_unresolved 192 5.049999999999999e-55   NR 1TAQ_A 271 g157364 i0 100 5.9581881533101 95 0 99.3 0 286 2 354 448 1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus] diamond 1710 192 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
27082079 27082079 PRJNA682078_P_NODE_225722_length_251_cov_0.865169_g223945_i0 PRJNA682078 225722 251 0.865169 2.17157419 Deinococcus sp. DB 47478 Bacteria Bacteria 43.9 0.0161   NR WP_198297268.1 2479203 g223945 i0 54.1 0.442231075697211 37 17 44.2 0 116 6 5 41 WP_198297268.1 DEAD/DEAH box helicase [Deinococcus sp. DB0503] diamond 111 43.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. DB0503
27208311 27208311 PRJNA682078_P_NODE_275062_length_243_cov_0.905882_g273285_i0 PRJNA682078 275062 243 0.905882 2.20129326 Deinococcus aetherius 200252 Bacteria Bacteria 114 3.1000000000000003e-30   NR BDP41774.1 200252 g273285 i0 67.5 0.987654320987654 80 26 98.8 0 3 242 59 138 BDP41774.1 hypothetical protein DAETH_17430 [Deinococcus aetherius] diamond 240 114 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aetherius
27271720 27271720 PRJNA682078_P_NODE_259143_length_246_cov_0.890173_g257366_i0 PRJNA682078 259143 246 0.890173 2.18982558 Aminivibrio pyruvatiphilus 1005740 Bacteria Bacteria 118 3.8599999999999997e-32   NR WP_133957322.1 1005740 g257366 i0 72.8 1.97560975609756 81 22 98.8 0 2 244 33 113 WP_133957322.1 hypothetical protein [Aminivibrio pyruvatiphilus] diamond 486 118 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminivibrio Aminivibrio pyruvatiphilus
28913428 28913428 PRJNA682078_P_NODE_186708_length_271_cov_1.166667_g184931_i0 PRJNA682078 186708 271 1.166667 3.16166757 Deinococcus antarcticus 1298767 Bacteria Bacteria 168 1.86e-51   NR WP_380075508.1 1298767 g184931 i0 97.8 0.985239852398524 89 2 98.5 0 269 3 10 98 WP_380075508.1 LEA type 2 family protein [Deinococcus antarcticus] diamond 267 168 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
29576525 29576525 PRJNA682078_P_NODE_263570_length_245_cov_0.895349_g261793_i0 PRJNA682078 263570 245 0.895349 2.19360505 Deinococcus fonticola 2528713 Bacteria Bacteria 162 4.59e-44   NR WP_135230645.1 2528713 g261793 i0 100 0.906122448979592 74 0 90.6 0 243 22 971 1044 WP_135230645.1 hypothetical protein [Deinococcus fonticola] diamond 222 162 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus fonticola
30430015 30430015 PRJNA682078_P_NODE_289113_length_241_cov_0.916667_g287336_i0 PRJNA682078 289113 241 0.916667 2.20916747 uncultured Truepera sp. 543023 Bacteria Bacteria 159 1.36e-45   NR CAA9587975.1 543023 g287336 i0 91.1 0.983402489626556 79 7 98.3 0 241 5 63 141 CAA9587975.1 MAG: hypothetical protein AVDCRST_MAG86-3957 [uncultured Truepera sp.] diamond 237 159 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
30430030 30430030 PRJNA682078_P_NODE_90113_length_368_cov_1.061017_g88338_i0 PRJNA682078 90113 368 1.061017 3.90454256 Thermus tengchongensis 1214928 Bacteria Bacteria 44.7 0.0219   NR WP_206201867.1 1214928 g88338 i0 33.3 0.733695652173913 90 52 72.6 2 94 360 98 180 WP_206201867.1 M23 family metallopeptidase [Thermus tengchongensis] diamond 270 44.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus tengchongensis
30619153 30619153 PRJNA682078_P_NODE_285513_length_242_cov_0.911243_g283736_i0 PRJNA682078 285513 242 0.911243 2.20520806 Deinococcus antarcticus 1298767 Bacteria Bacteria 160 1.12e-47   NR WP_380075848.1 1298767 g283736 i0 98.8 0.991735537190083 80 1 99.2 0 3 242 118 197 WP_380075848.1 HAD family hydrolase [Deinococcus antarcticus] diamond 240 160 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
30713925 30713925 PRJNA682078_P_NODE_220994_length_251_cov_1.657303_g219217_i0 PRJNA682078 220994 251 1.657303 4.15983053 Deinococcus radiotolerans 1309407 Bacteria Bacteria 180 2.4499999999999994e-52   NR WP_189070822.1 1309407 g219217 i0 98.8 0.99203187250996006 83 1 99.2 0 250 2 248 330 WP_189070822.1 glycoside hydrolase family 36 protein [Deinococcus radiotolerans] diamond 249 180 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiotolerans
31377832 31377832 PRJNA682078_P_NODE_288376_length_241_cov_0.916667_g286599_i0 PRJNA682078 288376 241 0.916667 2.20916747 Deinococcus geothermalis 68909 Bacteria Bacteria 106 1.1399999999999999e-24   NR WP_272976536.1 68909 g286599 i0 68.8 1.99170124481328 80 23 98.3 2 3 239 249 327 WP_272976536.1 DUF11 domain-containing protein [Deinococcus geothermalis] diamond 480 106 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
31504391 31504391 PRJNA682078_P_NODE_269236_length_244_cov_0.900585_g267459_i0 PRJNA682078 269236 244 0.900585 2.1974274 Deinococcus antarcticus 1298767 Bacteria Bacteria 150 3.749999999999999e-40   NR WP_380075697.1 1298767 g267459 i0 100 0.995901639344262 81 0 99.6 0 1 243 479 559 WP_380075697.1 transcriptional regulator [Deinococcus antarcticus] diamond 243 150 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
31567729 31567729 PRJNA682078_P_NODE_291136_length_241_cov_0.916667_g289359_i0 PRJNA682078 291136 241 0.916667 2.20916747 Deinococcus antarcticus 1298767 Bacteria Bacteria 160 6.72e-44   NR WP_380080365.1 1298767 g289359 i0 100 1.99170124481328 80 0 99.6 0 1 240 471 550 WP_380080365.1 tyrosine-type recombinase/integrase [Deinococcus antarcticus] diamond 480 160 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
32105189 32105189 PRJNA682078_P_NODE_191438_length_268_cov_1.297436_g189661_i0 PRJNA682078 191438 268 1.297436 3.47712848 Deinococcus reticulitermitis 856736 Bacteria Bacteria 160 1.8899999999999999e-47   NR WP_177183026.1 856736 g189661 i0 97.8 0.996268656716418 89 2 99.6 0 2 268 95 183 WP_177183026.1 hypothetical protein [Deinococcus reticulitermitis] diamond 267 160 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis

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