RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 34 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 34 ✖

analysis 1

  • diamond · 34 ✖

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
25516757 25516757 PRJEB20058_P_NODE_191833_length_263_cov_3.376238_g189009_i0 PRJEB20058 191833 263 3.376238 8.87950594 Sulfolobales archaeon 2268200 Archaea Archaea 92.8 1.78e-20   NR MEM4591831.1 2268200 g189009 i0 75.4 0.650190114068441 57 14 65 0 254 84 227 283 MEM4591831.1 MYG1 family protein [Sulfolobales archaeon] diamond 171 92.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales     Sulfolobales archaeon
25517246 25517246 PRJEB20058_P_NODE_203153_length_254_cov_1.393782_g200329_i0 PRJEB20058 203153 254 1.393782 3.54020628 Thermoproteota archaeon 2056631 Archaea Archaea 89 2.32e-18   NR MEM3368524.1 2056631 g200329 i0 90.2 0.602362204724409 51 5 60.2 0 91 243 580 630 MEM3368524.1 hypothetical protein [Thermoproteota archaeon] diamond 153 89 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
25518983 25518983 PRJEB20058_P_NODE_25201_length_831_cov_15.180519_g22946_i0 PRJEB20058 25201 831 15.180519 126.15011289 Thermoproteota archaeon 2056631 Archaea Archaea 223 1.34e-65   NR MEM3368575.1 2056631 g22946 i0 93.8 0.404332129963899 112 7 40.4 0 813 478 384 495 MEM3368575.1 hypothetical protein [Thermoproteota archaeon] diamond 336 223 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
25794098 25794098 PRJEB20058_P_NODE_83467_length_452_cov_3.818414_g80681_i0 PRJEB20058 83467 452 3.818414 17.25923128 Thermofilum sp. 1961369 Archaea Archaea 153 3.64e-42   NR WP_287908136.1 1961369 g80681 i0 84.6 0.517699115044248 78 12 51.8 0 217 450 273 350 WP_287908136.1 radical SAM protein [Thermofilum sp.] diamond 234 153 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermofilales Thermofilaceae Thermofilum Thermofilum sp.
27096321 27096321 PRJEB20058_S_NODE_1722_length_518_cov_41.214442_g1684_i0 PRJEB20058 1722 518 41.214442 213.49080956 Thermoproteota archaeon 2056631 Archaea Archaea 197 9.13e-61   NR MEM3368514.1 2056631 g1684 i0 90.2 0.648648648648649 112 11 64.9 0 338 3 101 212 MEM3368514.1 hypothetical protein [Thermoproteota archaeon] diamond 336 197 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30248147 30248147 PRJEB20058_S_NODE_4812_length_281_cov_5.454545_g4774_i0 PRJEB20058 4812 281 5.454545 15.32727145 root 1 Root_unresolved Root_unresolved 167 2.6899999999999998e-48   NR WP_345803936.1 121277 g4774 i0 97.8 1.92170818505338 90 2 96.1 0 270 1 167 256 WP_345803936.1 complex I subunit 5 family protein [Pyrobaculum arsenaticum] diamond 540 167 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
32910396 32910396 PRJEB20058_P_NODE_110801_length_383_cov_3.947205_g107989_i0 PRJEB20058 110801 383 3.947205 15.11779515 Thermoproteota archaeon 2056631 Archaea Archaea 235 4.1700000000000004e-77   NR MEM3368590.1 2056631 g107989 i0 93.6 0.97911227154047 125 8 97.9 0 3 377 50 174 MEM3368590.1 N-acetylmuramoyl-L-alanine amidase [Thermoproteota archaeon] diamond 375 235 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32910452 32910452 PRJEB20058_P_NODE_121353_length_362_cov_2.249169_g118536_i0 PRJEB20058 121353 362 2.249169 8.14199178 Candidatus Methanosuratincola sp. 2495426 Archaea Archaea 213 5.62e-64   NR MEM2126567.1 2495426 g118536 i0 99.1 0.911602209944751 110 1 91.2 0 331 2 1 110 MEM2126567.1 hypothetical protein [Candidatus Methanosuratincola sp.] diamond 330 213 1 Archaea   Thermoproteati Thermoproteota Methanosuratincolia Candidatus Methanomethylicales Candidatus Methanomethylicaceae Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016) Candidatus Methanosuratincola sp.
32911472 32911472 PRJEB20058_P_NODE_74353_length_482_cov_4.883610_g71576_i0 PRJEB20058 74353 482 4.88361 23.5390002 Thermoproteota archaeon 2056631 Archaea Archaea 262 1.54e-79   NR MEM3368578.1 2056631 g71576 i0 89.8 0.977178423236514 157 16 97.7 0 481 11 358 514 MEM3368578.1 hypothetical protein [Thermoproteota archaeon] diamond 471 262 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32957259 32957259 PRJEB20058_P_NODE_180634_length_275_cov_3.481308_g177811_i0 PRJEB20058 180634 275 3.481308 9.573597 Archaea 2157 Archaea Archaea 43.9 0.0207   NR MEM0326648.1 2184738 g177811 i0 72.4 0.632727272727273 29 7 30.5 1 88 171 400 428 MEM0326648.1 hypothetical protein [Desulfurococcaceae archaeon] diamond 174 43.9 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae   Desulfurococcaceae archaeon
32962513 32962513 PRJEB20058_P_NODE_206626_length_251_cov_23.205263_g203802_i0 PRJEB20058 206626 251 23.205263 58.24521013 Thermoproteota archaeon 2056631 Archaea Archaea 132 5.3999999999999995e-36   NR MEM3368592.1 2056631 g203802 i0 80.3 0.908366533864542 76 15 90.8 0 228 1 55 130 MEM3368592.1 hypothetical protein [Thermoproteota archaeon] diamond 228 132 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32979089 32979089 PRJEB20058_P_NODE_116619_length_371_cov_2.367742_g113804_i0 PRJEB20058 116619 371 2.367742 8.78432282 Thermoproteota archaeon 2056631 Archaea Archaea 206 9.17e-60   NR MEM3368524.1 2056631 g113804 i0 95.3 0.865229110512129 107 5 86.5 0 371 51 510 616 MEM3368524.1 hypothetical protein [Thermoproteota archaeon] diamond 321 206 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32979404 32979404 PRJEB20058_P_NODE_173547_length_283_cov_3.306306_g170724_i0 PRJEB20058 173547 283 3.306306 9.35684598 Thermoproteota archaeon 2056631 Archaea Archaea 90.9 7.21e-19   NR MEM3368525.1 2056631 g170724 i0 49.4 0.92226148409894 87 43 92.2 1 10 270 551 636 MEM3368525.1 hypothetical protein [Thermoproteota archaeon] diamond 261 90.9 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32979471 32979471 PRJEB20058_P_NODE_182427_length_273_cov_3.349057_g179604_i0 PRJEB20058 182427 273 3.349057 9.14292561 Thermoproteota archaeon 2056631 Archaea Archaea 43.1 0.0149   NR MDP8886934.1 2056631 g179604 i0 30.1 0.912087912087912 83 52 84.6 1 36 266 3 85 MDP8886934.1 peptide-methionine (R)-S-oxide reductase MsrB [Thermoproteota archaeon] diamond 249 43.1 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32996040 32996040 PRJEB20058_P_NODE_133939_length_339_cov_2.287770_g131119_i0 PRJEB20058 133939 339 2.28777 7.7555403 Candidatus Methanosuratincola sp. 2495426 Archaea Archaea 207 9.45e-62   NR MEM2126567.1 2495426 g131119 i0 97.2 0.955752212389381 108 3 95.6 0 14 337 413 520 MEM2126567.1 hypothetical protein [Candidatus Methanosuratincola sp.] diamond 324 207 1 Archaea   Thermoproteati Thermoproteota Methanosuratincolia Candidatus Methanomethylicales Candidatus Methanomethylicaceae Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016) Candidatus Methanosuratincola sp.
32996063 32996063 PRJEB20058_P_NODE_137939_length_332_cov_2.723247_g135118_i0 PRJEB20058 137939 332 2.723247 9.04118004 Thermoproteota archaeon 2056631 Archaea Archaea 231 2.89e-70   NR MEM3368511.1 2056631 g135118 i0 99.1 0.993975903614458 110 1 99.4 0 332 3 380 489 MEM3368511.1 hypothetical protein [Thermoproteota archaeon] diamond 330 231 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32996639 32996639 PRJEB20058_P_NODE_239667_length_216_cov_4.877419_g236842_i0 PRJEB20058 239667 216 4.877419 10.53522504 Thermoproteota archaeon 2056631 Archaea Archaea 111 1.3600000000000002e-26   NR MEM3368504.1 2056631 g236842 i0 79.1 0.930555555555556 67 14 93.1 0 215 15 325 391 MEM3368504.1 hypothetical protein [Thermoproteota archaeon] diamond 201 111 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32997118 32997118 PRJEB20058_P_NODE_98827_length_410_cov_3.713467_g96021_i0 PRJEB20058 98827 410 3.713467 15.2252147 Ignisphaera sp. 2268142 Archaea Archaea 52 1.44e-4   NR MCI4435493.1 2268142 g96021 i0 29.4 0.870731707317073 119 82 85.6 1 409 59 1325 1443 MCI4435493.1 hypothetical protein [Ignisphaera sp.] diamond 357 52 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
33008414 33008414 PRJEB20058_P_NODE_63219_length_526_cov_7.189247_g60457_i0 PRJEB20058 63219 526 7.189247 37.81543922 Thermoproteati 1783275 Archaea Archaea 140 3.0599999999999995e-37   NR MEK6877239.1 2056631 g60457 i0 93.8 1.44296577946768 64 4 36.5 0 516 325 259 322 MEK6877239.1 radical SAM protein [Thermoproteota archaeon] diamond 759 140 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33013357 33013357 PRJEB20058_P_NODE_180596_length_275_cov_4.102804_g177773_i0 PRJEB20058 180596 275 4.102804 11.282711 Sulfolobales archaeon 2268200 Archaea Archaea 148 5.609999999999999e-42   NR MEM4591831.1 2268200 g177773 i0 89.3 0.916363636363636 84 9 91.6 0 253 2 155 238 MEM4591831.1 MYG1 family protein [Sulfolobales archaeon] diamond 252 148 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales     Sulfolobales archaeon
33014131 33014131 PRJEB20058_P_NODE_92436_length_426_cov_23.468493_g89637_i0 PRJEB20058 92436 426 23.468493 99.97578018 Thermoproteota archaeon 2056631 Archaea Archaea 265 1.68e-85   NR MDQ4013289.1 2056631 g89637 i0 91 1.01408450704225 144 6 96.5 1 416 6 25 168 MDQ4013289.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Thermoproteota archaeon] diamond 432 265 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33064868 33064868 PRJEB20058_P_NODE_240309_length_214_cov_24.398693_g237484_i0 PRJEB20058 240309 214 24.398693 52.21320302 Thermoproteota archaeon 2056631 Archaea Archaea 104 5.84e-27   NR MDT7864681.1 2056631 g237484 i0 87.9 0.813084112149533 58 7 81.3 0 23 196 1 58 MDT7864681.1 hypothetical protein [Thermoproteota archaeon] diamond 174 104 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33065257 33065257 PRJEB20058_P_NODE_83613_length_451_cov_102.623077_g80826_i0 PRJEB20058 83613 451 102.623077 462.83007727 Thermoproteota archaeon 2056631 Archaea Archaea 200 9.13e-59   NR MEM3368600.1 2056631 g80826 i0 96.2 0.69179600886918 104 4 69.2 0 357 46 299 402 MEM3368600.1 toprim domain-containing protein [Thermoproteota archaeon] diamond 312 200 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33065318 33065318 PRJEB20058_P_NODE_94301_length_421_cov_269.302778_g91501_i0 PRJEB20058 94301 421 269.302778 1133.76469538 Thermoproteota archaeon 2056631 Archaea Archaea 162 2.329999999999999e-47   NR MEM3368514.1 2056631 g91501 i0 87 0.655581947743468 92 12 65.6 0 145 420 126 217 MEM3368514.1 hypothetical protein [Thermoproteota archaeon] diamond 276 162 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33093640 33093640 PRJEB20058_P_NODE_105678_length_394_cov_4.096096_g102870_i0 PRJEB20058 105678 394 4.096096 16.13861824 root 1 Root_unresolved Root_unresolved 142 1.0299999999999998e-37   NR WP_345803936.1 121277 g102870 i0 94 1.27918781725888 84 5 64 0 256 5 49 132 WP_345803936.1 complex I subunit 5 family protein [Pyrobaculum arsenaticum] diamond 504 142 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
33098820 33098820 PRJEB20058_P_NODE_204086_length_253_cov_4.234375_g201262_i0 PRJEB20058 204086 253 4.234375 10.71296875 Pyrobaculum arsenaticum 121277 Archaea Archaea 54.7 1.5e-7   NR WP_345803930.1 121277 g201262 i0 96.6 0.343873517786561 29 1 34.4 0 166 252 1 29 WP_345803930.1 cytochrome c [Pyrobaculum arsenaticum] diamond 87 54.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
33099116 33099116 PRJEB20058_P_NODE_38510_length_678_cov_6.609400_g35886_i0 PRJEB20058 38510 678 6.6094 44.811732 Thermoproteota archaeon 2056631 Archaea Archaea 229 1.08e-65   NR MEM3368643.1 2056631 g35886 i0 96.7 0.539823008849557 122 4 54 0 368 3 1 122 MEM3368643.1 hypothetical protein [Thermoproteota archaeon] diamond 366 229 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33116497 33116497 PRJEB20058_P_NODE_95991_length_417_cov_4.865169_g93189_i0 PRJEB20058 95991 417 4.865169 20.28775473 Desulfurococcaceae archaeon 2184738 Archaea Archaea 64.3 6.47e-9   NR MEM0326648.1 2184738 g93189 i0 67.3 0.705035971223022 49 15 34.5 1 155 298 380 428 MEM0326648.1 hypothetical protein [Desulfurococcaceae archaeon] diamond 294 64.3 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae   Desulfurococcaceae archaeon
33127734 33127734 PRJEB20058_P_NODE_170823_length_286_cov_7.613333_g168000_i0 PRJEB20058 170823 286 7.613333 21.77413238 root 1 Root_unresolved Root_unresolved 147 1.4599999999999996e-40   NR WP_345803936.1 121277 g168000 i0 96.4 1.74125874125874 83 3 87.1 0 27 275 177 259 WP_345803936.1 complex I subunit 5 family protein [Pyrobaculum arsenaticum] diamond 498 147 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
33133294 33133294 PRJEB20058_P_NODE_34151_length_718_cov_139.744292_g31585_i0 PRJEB20058 34151 718 139.744292 1003.36401656 Thermoproteota archaeon 2056631 Archaea Archaea 232 1.0199999999999999e-69   NR MEM3368555.1 2056631 g31585 i0 97.5 0.497214484679666 119 3 49.7 0 672 316 1 119 MEM3368555.1 hypothetical protein [Thermoproteota archaeon] diamond 357 232 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33144838 33144838 PRJEB20058_P_NODE_177743_length_278_cov_11.207373_g174920_i0 PRJEB20058 177743 278 11.207373 31.15649694 Thermoproteati 1783275 Archaea Archaea 162 2.48e-49   NR MDQ6724149.1 2056631 g174920 i0 98.8 1.83453237410072 85 1 91.7 0 24 278 37 121 MDQ6724149.1 hypothetical protein [Thermoproteota archaeon] diamond 510 162 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33166461 33166461 PRJEB20058_P_NODE_10824_length_1265_cov_14.196844_g9311_i0 PRJEB20058 10824 1265 14.196844 179.5900766 Thermoproteota archaeon 2056631 Archaea Archaea 210 1.58e-63   NR MDP8906039.1 2056631 g9311 i0 90.4 0.296442687747036 125 12 29.6 0 115 489 1 125 MDP8906039.1 RNA polymerase Rpb4 [Thermoproteota archaeon] diamond 375 210 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33166742 33166742 PRJEB20058_P_NODE_155872_length_305_cov_7.762295_g153049_i0 PRJEB20058 155872 305 7.762295 23.67499975 Thermoproteota archaeon 2056631 Archaea Archaea 69.7 2.14e-11   NR RDJ35592.1 2056631 g153049 i0 42.6 0.924590163934426 94 50 88.5 2 28 297 263 356 RDJ35592.1 MAG: hypothetical protein DWQ19_12305 [Thermoproteota archaeon] diamond 282 69.7 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33167280 33167280 PRJEB20058_P_NODE_36720_length_693_cov_251.566456_g34123_i0 PRJEB20058 36720 693 251.566456 1743.35554008 Thermoproteota archaeon 2056631 Archaea Archaea 262 9.24e-84   NR MEM3368611.1 2056631 g34123 i0 93.4 0.588744588744589 136 9 58.9 0 414 7 92 227 MEM3368611.1 hypothetical protein [Thermoproteota archaeon] diamond 408 262 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon

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