RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJNA942359 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
2198216 2198216 PRJNA942359_P_NODE_13642_length_252_cov_0.871508_g13527_i0 PRJNA942359 13642 252 0.871508 2.19620016 Deinococcus reticulitermitis 856736 Bacteria Bacteria 146 3.49e-39   NR WP_092263076.1 856736 g13527 i0 85.7 1 84 12 100 0 252 1 457 540 WP_092263076.1 catalase [Deinococcus reticulitermitis] diamond 252 146 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
3810846 3810846 PRJNA942359_P_NODE_13723_length_252_cov_0.871508_g13608_i0 PRJNA942359 13723 252 0.871508 2.19620016 Deinococcus psychrotolerans 2489213 Bacteria Bacteria 152 1.1299999999999998e-41   NR WP_124875160.1 2489213 g13608 i0 83.3 1 84 14 100 0 252 1 360 443 WP_124875160.1 AMP-binding protein [Deinococcus psychrotolerans] diamond 252 152 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus psychrotolerans
8575917 8575917 PRJNA942359_P_NODE_19647_length_243_cov_0.917647_g19532_i0 PRJNA942359 19647 243 0.917647 2.22988221 Deinococcus reticulitermitis 856736 Bacteria Bacteria 174 1.04e-49   NR WP_092265743.1 856736 g19532 i0 98.8 0.987654320987654 80 1 98.8 0 2 241 450 529 WP_092265743.1 beta-glucuronidase [Deinococcus reticulitermitis] diamond 240 174 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
14950937 14950937 PRJNA942359_P_NODE_18012_length_245_cov_0.906977_g17897_i0 PRJNA942359 18012 245 0.906977 2.22209365 Deinococcus aerolatus 522487 Bacteria Bacteria 90.1 1.21e-21   NR WP_188968018.1 522487 g17897 i0 87 1.32244897959184 54 7 66.1 0 163 2 1 54 WP_188968018.1 hypothetical protein [Deinococcus aerolatus] diamond 324 90.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aerolatus
19110176 19110176 PRJNA942359_P_NODE_17795_length_246_cov_0.901734_g17680_i0 PRJNA942359 17795 246 0.901734 2.21826564 Deinococcus 1298 Bacteria Bacteria 152 6.55e-44   NR WP_303101563.1 47478 g17680 i0 87.7 2.95121951219512 81 10 98.8 0 245 3 62 142 WP_303101563.1 polyphosphate kinase 2 family protein [Deinococcus sp.] diamond 726 152 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
26898795 26898795 PRJNA942359_P_NODE_14021_length_252_cov_0.871508_g13906_i0 PRJNA942359 14021 252 0.871508 2.19620016 uncultured Truepera sp. 543023 Bacteria Bacteria 90.9 5.22e-22   NR CAA9562573.1 543023 g13906 i0 69.2 0.773809523809524 65 20 77.4 0 2 196 4 68 CAA9562573.1 MAG: hypothetical protein AVDCRST_MAG86-758 [uncultured Truepera sp.] diamond 195 90.9 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
27373247 27373247 PRJNA942359_P_NODE_14303_length_251_cov_0.876404_g14188_i0 PRJNA942359 14303 251 0.876404 2.19977404 Deinococcus cavernae 2320857 Bacteria Bacteria 145 5.96e-41   NR WP_147364095.1 2320857 g14188 i0 100 0.860557768924303 72 0 86.1 0 34 249 1 72 WP_147364095.1 alpha/beta hydrolase family protein [Deinococcus cavernae] diamond 216 145 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
27436318 27436318 PRJNA942359_P_NODE_16123_length_248_cov_0.891429_g16008_i0 PRJNA942359 16123 248 0.891429 2.21074392 Deinococcus sp. DB 47478 Bacteria Bacteria 64.3 8.63e-10   NR WP_198297477.1 2479203 g16008 i0 52 0.907258064516129 75 30 87.1 3 221 6 154 225 WP_198297477.1 hypothetical protein [Deinococcus sp. DB0503] diamond 225 64.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. DB0503
27562129 27562129 PRJNA942359_P_NODE_10104_length_280_cov_0.975845_g9989_i0 PRJNA942359 10104 280 0.975845 2.732366 Deinococcus reticulitermitis 856736 Bacteria Bacteria 134 4.519999999999999e-35   NR WP_092263268.1 856736 g9989 i0 80 1.01785714285714 95 17 99.6 1 1 279 25 119 WP_092263268.1 M17 family metallopeptidase [Deinococcus reticulitermitis] diamond 285 134 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
27632399 27632399 PRJNA942359_P_NODE_12984_length_253_cov_0.866667_g12869_i0 PRJNA942359 12984 253 0.866667 2.19266751 Deinococcus 1298 Bacteria Bacteria 140 1.62e-37   NR WP_161882857.1 468913 g12869 i0 77.8 6.86561264822134 81 18 96 0 253 11 234 314 WP_161882857.1 DUF2330 domain-containing protein [Deinococcus alpinitundrae] diamond 1737 140 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus alpinitundrae
27752031 27752031 PRJNA942359_P_NODE_13804_length_252_cov_0.871508_g13689_i0 PRJNA942359 13804 252 0.871508 2.19620016 Deinococcus reticulitermitis 856736 Bacteria Bacteria 110 3.0800000000000004e-27   NR WP_092263562.1 856736 g13689 i0 69 1 84 26 100 0 1 252 76 159 WP_092263562.1 PhzF family phenazine biosynthesis protein [Deinococcus reticulitermitis] diamond 252 110 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
28036102 28036102 PRJNA942359_P_NODE_13705_length_252_cov_0.871508_g13590_i0 PRJNA942359 13705 252 0.871508 2.19620016 Deinococcus reticulitermitis 856736 Bacteria Bacteria 169 5.52e-49   NR WP_092263380.1 856736 g13590 i0 96.4 1 84 3 100 0 1 252 122 205 WP_092263380.1 alpha/beta hydrolase family protein [Deinococcus reticulitermitis] diamond 252 169 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
28162441 28162441 PRJNA942359_P_NODE_5845_length_347_cov_0.784672_g5730_i0 PRJNA942359 5845 347 0.784672 2.72281184 Deinococcus planocerae 1737569 Bacteria Bacteria 110 1.26e-26   NR WP_102127977.1 1737569 g5730 i0 88.3 0.518731988472622 60 7 51.9 0 180 1 1 60 WP_102127977.1 hypothetical protein [Deinococcus planocerae] diamond 180 110 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus planocerae
28793631 28793631 PRJNA942359_P_NODE_13347_length_253_cov_0.866667_g13232_i0 PRJNA942359 13347 253 0.866667 2.19266751 Deinococcus cavernae 2320857 Bacteria Bacteria 158 3.88e-44   NR WP_119764944.1 2320857 g13232 i0 89.2 0.984189723320158 83 9 98.4 0 3 251 269 351 WP_119764944.1 UDP-N-acetylmuramate--L-alanine ligase [Deinococcus cavernae] diamond 249 158 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
28793633 28793633 PRJNA942359_P_NODE_15547_length_249_cov_0.886364_g15432_i0 PRJNA942359 15547 249 0.886364 2.20704636 Deinococcus fonticola 2528713 Bacteria Bacteria 127 1.0699999999999999e-34   NR WP_135229091.1 2528713 g15432 i0 82.7 0.975903614457831 81 14 97.6 0 245 3 46 126 WP_135229091.1 LysE family translocator [Deinococcus fonticola] diamond 243 127 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus fonticola
29298996 29298996 PRJNA942359_P_NODE_15149_length_250_cov_0.881356_g15034_i0 PRJNA942359 15149 250 0.881356 2.20339 Deinococcota bacterium 1913990 Bacteria Bacteria 99.8 1.7699999999999998e-24   NR MDQ3459620.1 1913990 g15034 i0 63.4 0.852 71 26 85.2 0 250 38 76 146 MDQ3459620.1 HIT family protein [Deinococcota bacterium] diamond 213 99.8 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
29330497 29330497 PRJNA942359_P_NODE_18709_length_244_cov_0.912281_g18594_i0 PRJNA942359 18709 244 0.912281 2.22596564 Deinococcus pimensis 309888 Bacteria Bacteria 139 2.14e-39   NR WP_027483471.1 309888 g18594 i0 84.2 0.934426229508197 76 12 93.4 0 229 2 82 157 WP_027483471.1 hypothetical protein [Deinococcus pimensis] diamond 228 139 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus pimensis
29519908 29519908 PRJNA942359_P_NODE_17190_length_247_cov_0.873563_g17075_i0 PRJNA942359 17190 247 0.873563 2.15770061 Deinococcus aestuarii 2774531 Bacteria Bacteria 93.2 9.35e-22   NR WP_216324346.1 2774531 g17075 i0 65.7 1.68825910931174 67 23 81.4 0 30 230 1 67 WP_216324346.1 DUF1641 domain-containing protein [Deinococcus aestuarii] diamond 417 93.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aestuarii
29589606 29589606 PRJNA942359_P_NODE_15190_length_250_cov_0.881356_g15075_i0 PRJNA942359 15190 250 0.881356 2.20339 Deinococcus 1298 Bacteria Bacteria 124 3.85e-32   NR WP_184028550.1 1665626 g15075 i0 81.5 1.944 81 11 97.2 1 7 249 1 77 WP_184028550.1 extracellular solute-binding protein [Deinococcus budaensis] diamond 486 125 0.992 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
29645872 29645872 PRJNA942359_P_NODE_17530_length_246_cov_0.901734_g17415_i0 PRJNA942359 17530 246 0.901734 2.21826564 Deinococcus reticulitermitis 856736 Bacteria Bacteria 170 7.43e-49   NR WP_092264817.1 856736 g17415 i0 98.8 1 82 1 100 0 1 246 192 273 WP_092264817.1 replication initiator protein A [Deinococcus reticulitermitis] diamond 246 170 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
29677493 29677493 PRJNA942359_P_NODE_7070_length_321_cov_0.979839_g6955_i0 PRJNA942359 7070 321 0.979839 3.14528319 Deinococcus reticulitermitis 856736 Bacteria Bacteria 187 1.9299999999999994e-54   NR WP_092265543.1 856736 g6955 i0 100 0.831775700934579 89 0 83.2 0 319 53 463 551 WP_092265543.1 maltose alpha-D-glucosyltransferase [Deinococcus reticulitermitis] diamond 267 187 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
29993770 29993770 PRJNA942359_P_NODE_17831_length_246_cov_0.901734_g17716_i0 PRJNA942359 17831 246 0.901734 2.21826564 Deinococcus budaensis 1665626 Bacteria Bacteria 112 3.57e-30   NR WP_184027761.1 1665626 g17716 i0 92.3 0.634146341463415 52 4 63.4 0 245 90 38 89 WP_184027761.1 hypothetical protein [Deinococcus budaensis] diamond 156 112 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
30056707 30056707 PRJNA942359_P_NODE_18311_length_245_cov_0.906977_g18196_i0 PRJNA942359 18311 245 0.906977 2.22209365 Deinococcus hopiensis 309885 Bacteria Bacteria 52 5.15e-6   NR WP_084045668.1 309885 g18196 i0 53.2 0.575510204081633 47 19 53.9 1 242 111 94 140 WP_084045668.1 hypothetical protein [Deinococcus hopiensis] diamond 141 52 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hopiensis
30720270 30720270 PRJNA942359_P_NODE_13614_length_252_cov_0.871508_g13499_i0 PRJNA942359 13614 252 0.871508 2.19620016 Deinococcus piscis 394230 Bacteria Bacteria 161 8.19e-46   NR WP_189643960.1 394230 g13499 i0 94 0.988095238095238 83 5 98.8 0 2 250 79 161 WP_189643960.1 replication initiator protein A [Deinococcus piscis] diamond 249 161 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus piscis
32396501 32396501 PRJNA942359_P_NODE_17439_length_246_cov_0.901734_g17324_i0 PRJNA942359 17439 246 0.901734 2.21826564 Deinococcus reticulitermitis 856736 Bacteria Bacteria 152 1.7799999999999994e-42   NR WP_092263680.1 856736 g17324 i0 88.9 0.98780487804878 81 9 98.8 0 244 2 296 376 WP_092263680.1 hypothetical protein [Deinococcus reticulitermitis] diamond 243 152 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
32523228 32523228 PRJNA942359_P_NODE_13559_length_252_cov_0.871508_g13444_i0 PRJNA942359 13559 252 0.871508 2.19620016 Deinococcus sp. QL22 2939437 Bacteria Bacteria 104 9.36e-24   NR WP_249393125.1 2939437 g13444 i0 63.1 1 84 31 100 0 252 1 659 742 WP_249393125.1 phage tail tape measure protein [Deinococcus sp. QL22] diamond 252 104 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. QL22

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