RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 34 ✖

tax_kingdom 1

bioproject 1

  • PRJEB83711 · 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
9072203 9072203 PRJEB83711_P_NODE_79448_length_242_cov_0.923077_g79182_i0 PRJEB83711 79448 242 0.923077 2.23384634 uncultured Truepera sp. 543023 Bacteria Bacteria 109 2.88e-28   NR CAA9587060.1 543023 g79182 i0 82.2 0.90495867768595 73 13 90.5 0 24 242 13 85 CAA9587060.1 MAG: hypothetical protein AVDCRST_MAG86-3710 [uncultured Truepera sp.] diamond 219 109 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
10346569 10346569 PRJEB83711_P_NODE_23989_length_363_cov_1.213793_g23723_i0 PRJEB83711 23989 363 1.213793 4.40606859 Deinococcus piscis 394230 Bacteria Bacteria 154 1.99e-46   NR WP_189643751.1 394230 g23723 i0 98.8 0.661157024793388 80 1 66.1 0 241 2 1 80 WP_189643751.1 IS66 family insertion sequence element accessory protein TnpA [Deinococcus piscis] diamond 240 154 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus piscis
20545751 20545751 PRJEB83711_P_NODE_72577_length_245_cov_0.906977_g72311_i0 PRJEB83711 72577 245 0.906977 2.22209365 Deinococcus yavapaiensis 309889 Bacteria Bacteria 159 3.39e-45   NR WP_110887679.1 309889 g72311 i0 95.1 0.991836734693878 81 4 99.2 0 245 3 95 175 WP_110887679.1 tyrosine--tRNA ligase [Deinococcus yavapaiensis] diamond 243 159 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yavapaiensis
23951191 23951191 PRJEB83711_P_NODE_55819_length_256_cov_1.278689_g55553_i0 PRJEB83711 55819 256 1.278689 3.27344384 Trueperaceae bacterium 2026798 Bacteria Bacteria 72 2.15e-12   NR MDZ7800489.1 2026798 g55553 i0 44.6 0.97265625 83 46 97.3 0 255 7 227 309 MDZ7800489.1 hypothetical protein [Trueperaceae bacterium] diamond 249 72 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
26932083 26932083 PRJEB83711_P_NODE_77742_length_242_cov_2.082840_g77476_i0 PRJEB83711 77742 242 2.08284 5.0404728 Truepera 332248 Bacteria Bacteria 114 8.22e-29   NR WP_013177464.1 332249 g77476 i0 70 1.98347107438017 80 24 99.2 0 3 242 10 89 WP_013177464.1 VOC family protein [Truepera radiovictrix] diamond 480 114 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
27160492 27160492 PRJEB83711_P_NODE_77342_length_243_cov_0.917647_g77076_i0 PRJEB83711 77342 243 0.917647 2.22988221 Truepera radiovictrix 332249 Bacteria Bacteria 56.2 6.2e-7   NR WP_013176790.1 332249 g77076 i0 65.9 0.506172839506173 41 14 50.6 0 241 119 345 385 WP_013176790.1 bifunctional diaminohydroxyphosphoribosylaminopyrimidine deaminase/5-amino-6-(5-phosphoribosylamino)uracil reductase RibD [Truepera radiovictrix] diamond 123 56.2 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
27160493 27160493 PRJEB83711_P_NODE_80322_length_237_cov_2.451220_g80056_i0 PRJEB83711 80322 237 2.45122 5.8093914 Truepera radiovictrix 332249 Bacteria Bacteria 124 2.3e-33   NR WP_013176954.1 332249 g80056 i0 78.2 0.987341772151899 78 17 98.7 0 2 235 94 171 WP_013176954.1 imidazole glycerol phosphate synthase subunit HisH [Truepera radiovictrix] diamond 234 124 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
27539988 27539988 PRJEB83711_P_NODE_65624_length_249_cov_0.886364_g65358_i0 PRJEB83711 65624 249 0.886364 2.20704636 Deinococcus kurensis 2662757 Bacteria Bacteria 92.8 4.1200000000000005e-21   NR WP_155298946.1 2662757 g65358 i0 50.6 1 83 41 100 0 1 249 92 174 WP_155298946.1 hypothetical protein [Deinococcus kurensis] diamond 249 92.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus kurensis
27911187 27911187 PRJEB83711_P_NODE_20125_length_395_cov_1.068323_g19859_i0 PRJEB83711 20125 395 1.068323 4.21987585 Deinococcus 1298 Bacteria Bacteria 93.6 2.44e-21   NR WP_415577200.1 1299 g19859 i0 92 1.13924050632911 50 4 38 0 152 3 22 71 WP_415577200.1 IS630 family transposase, partial [Deinococcus radiodurans] diamond 450 93.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans
28360673 28360673 PRJEB83711_P_NODE_69206_length_247_cov_0.896552_g68940_i0 PRJEB83711 69206 247 0.896552 2.21448344 Deinococcus roseus 392414 Bacteria Bacteria 113 4.7400000000000006e-27   NR WP_189009371.1 392414 g68940 i0 93.5 1.50607287449393 62 4 75.3 0 186 1 1 62 WP_189009371.1 group II intron reverse transcriptase/maturase [Deinococcus roseus] diamond 372 113 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus roseus
28763832 28763832 PRJEB83711_P_NODE_79167_length_242_cov_0.923077_g78901_i0 PRJEB83711 79167 242 0.923077 2.23384634 Deinococcus 1298 Bacteria Bacteria 104 5.99e-26   NR WP_229253510.1 32062 g78901 i0 58.8 2.82644628099174 80 33 99.2 0 240 1 3 82 WP_229253510.1 hypothetical protein [Deinococcus radiophilus] diamond 684 104 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus
29150546 29150546 PRJEB83711_P_NODE_44189_length_279_cov_1.456311_g43923_i0 PRJEB83711 44189 279 1.456311 4.06310769 uncultured Truepera sp. 543023 Bacteria Bacteria 125 3.4899999999999996e-31   NR CAA9560172.1 543023 g43923 i0 67.4 0.989247311827957 92 30 98.9 0 2 277 545 636 CAA9560172.1 MAG: DNA primase/helicase, phage-associated [uncultured Truepera sp.] diamond 276 125 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
29213555 29213555 PRJEB83711_P_NODE_61289_length_251_cov_0.876404_g61023_i0 PRJEB83711 61289 251 0.876404 2.19977404 Deinococcus radiophilus 32062 Bacteria Bacteria 65.5 1.18e-11   NR WP_380098883.1 32062 g61023 i0 62.5 1.33864541832669 56 17 66.9 1 82 249 2 53 WP_380098883.1 hypothetical protein [Deinococcus radiophilus] diamond 336 65.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus
29402755 29402755 PRJEB83711_P_NODE_76289_length_243_cov_0.917647_g76023_i0 PRJEB83711 76289 243 0.917647 2.22988221 Truepera radiovictrix DSM 17 332249 Bacteria Bacteria 112 2.64e-27   NR ADI14157.1 649638 g76023 i0 73.1 0.962962962962963 78 21 96.3 0 1 234 96 173 ADI14157.1 phosphoribosylaminoimidazole carboxylase, ATPase subunit [Truepera radiovictrix DSM 17093] diamond 234 112 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
29529153 29529153 PRJEB83711_P_NODE_37230_length_297_cov_1.473214_g36964_i0 PRJEB83711 37230 297 1.473214 4.37544558 Truepera sp. 2478917 Bacteria Bacteria 119 1.52e-29   NR MBS3965816.1 2478917 g36964 i0 65.6 8.77777777777778 93 32 93.9 0 3 281 70 162 MBS3965816.1 phosphoribosylamine--glycine ligase [Truepera sp.] diamond 2607 119 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera sp.
29591820 29591820 PRJEB83711_P_NODE_62810_length_250_cov_1.322034_g62544_i0 PRJEB83711 62810 250 1.322034 3.305085 uncultured Truepera sp. 543023 Bacteria Bacteria 139 4.31e-40   NR CAA9579251.1 543023 g62544 i0 75.6 0.984 82 20 98.4 0 3 248 54 135 CAA9579251.1 MAG: hypothetical protein AVDCRST_MAG86-2538 [uncultured Truepera sp.] diamond 246 139 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
29623283 29623283 PRJEB83711_P_NODE_72790_length_245_cov_0.906977_g72524_i0 PRJEB83711 72790 245 0.906977 2.22209365 Truepera radiovictrix 332249 Bacteria Bacteria 47.4 8.61e-4   NR WP_013178550.1 332249 g72524 i0 40.6 0.783673469387755 64 36 75.9 1 189 4 1 64 WP_013178550.1 DUF4397 domain-containing protein [Truepera radiovictrix] diamond 192 47.4 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
29781609 29781609 PRJEB83711_P_NODE_62571_length_250_cov_1.762712_g62305_i0 PRJEB83711 62571 250 1.762712 4.40678 Deinococcus marmoris 249408 Bacteria Bacteria 69.7 1.56e-12   NR WP_075833436.1 249408 g62305 i0 45.8 1.992 83 42 99.6 1 249 1 77 156 WP_075833436.1 hypothetical protein [Deinococcus marmoris] diamond 498 69.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus marmoris
29876504 29876504 PRJEB83711_P_NODE_63431_length_250_cov_0.881356_g63165_i0 PRJEB83711 63431 250 0.881356 2.20339 Deinococcus lacus 392561 Bacteria Bacteria 108 2.34e-28   NR WP_380082443.1 392561 g63165 i0 65.3 0.864 72 25 86.4 0 35 250 1 72 WP_380082443.1 DUF7674 family protein [Deinococcus lacus] diamond 216 108 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus lacus
29876507 29876507 PRJEB83711_P_NODE_71551_length_246_cov_0.901734_g71285_i0 PRJEB83711 71551 246 0.901734 2.21826564 Trueperaceae bacterium 2026798 Bacteria Bacteria 127 5.05e-34   NR MCA9838994.1 2026798 g71285 i0 75 0.975609756097561 80 20 97.6 0 245 6 204 283 MCA9838994.1 IS3 family transposase [Trueperaceae bacterium] diamond 240 127 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
29939748 29939748 PRJEB83711_P_NODE_56071_length_255_cov_2.142857_g55805_i0 PRJEB83711 56071 255 2.142857 5.46428535 Deinococcus sp. 47478 Bacteria Bacteria 138 1.34e-36   NR WP_291423199.1 47478 g55805 i0 82.1 0.988235294117647 84 15 98.8 0 2 253 315 398 WP_291423199.1 IS66 family transposase [Deinococcus sp.] diamond 252 138 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
30476835 30476835 PRJEB83711_P_NODE_37513_length_296_cov_1.636771_g37247_i0 PRJEB83711 37513 296 1.636771 4.84484216 Deinococcus fonticola 2528713 Bacteria Bacteria 167 2.15e-50   NR WP_135229027.1 2528713 g37247 i0 81.6 3.97297297297297 98 18 99.3 0 1 294 89 186 WP_135229027.1 IS630 family transposase [Deinococcus fonticola] diamond 1176 167 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus fonticola
30539832 30539832 PRJEB83711_P_NODE_56373_length_255_cov_1.285714_g56107_i0 PRJEB83711 56373 255 1.285714 3.2785707 Truepera radiovictrix 332249 Bacteria Bacteria 125 1.7199999999999995e-31   NR WP_013179288.1 332249 g56107 i0 65.9 2 85 29 100 0 255 1 198 282 WP_013179288.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Truepera radiovictrix] diamond 510 125 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
30602934 30602934 PRJEB83711_P_NODE_61653_length_251_cov_0.876404_g61387_i0 PRJEB83711 61653 251 0.876404 2.19977404 Deinococcota bacterium 1913990 Bacteria Bacteria 110 1.0600000000000002e-27   NR MDQ3399262.1 1913990 g61387 i0 74.7 0.99203187250996006 83 21 99.2 0 3 251 126 208 MDQ3399262.1 IS110 family transposase [Deinococcota bacterium] diamond 249 110 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
31329858 31329858 PRJEB83711_P_NODE_68316_length_247_cov_1.350575_g68050_i0 PRJEB83711 68316 247 1.350575 3.33592025 Deinococcota bacterium 1913990 Bacteria Bacteria 142 1.0499999999999999e-40   NR MDQ3399320.1 1913990 g68050 i0 86.6 0.995951417004049 82 11 99.6 0 247 2 48 129 MDQ3399320.1 IS630 family transposase [Deinococcota bacterium] diamond 246 142 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
31772644 31772644 PRJEB83711_P_NODE_70117_length_246_cov_1.445087_g69851_i0 PRJEB83711 70117 246 1.445087 3.55491402 Deinococcota bacterium 1913990 Bacteria Bacteria 94.4 8.44e-22   NR MDQ3398932.1 1913990 g69851 i0 60.5 0.98780487804878 81 31 98.8 1 3 245 81 160 MDQ3398932.1 IS5 family transposase [Deinococcota bacterium] diamond 243 94.4 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
31804197 31804197 PRJEB83711_P_NODE_78137_length_242_cov_1.242604_g77871_i0 PRJEB83711 78137 242 1.242604 3.00710168 Truepera radiovictrix 332249 Bacteria Bacteria 96.7 3.38e-22   NR WP_013177587.1 332249 g77871 i0 78.3 0.743801652892562 60 13 74.4 0 3 182 204 263 WP_013177587.1 TVP38/TMEM64 family protein [Truepera radiovictrix] diamond 180 96.7 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
31867466 31867466 PRJEB83711_P_NODE_74417_length_244_cov_0.912281_g74151_i0 PRJEB83711 74417 244 0.912281 2.22596564 Deinococcus sp. Marseille-Q64 47478 Bacteria Bacteria 110 3.97e-27   NR WP_261665268.1 2969223 g74151 i0 66.7 0.959016393442623 78 26 95.9 0 244 11 25 102 WP_261665268.1 adenine-specific methyltransferase EcoRI family protein [Deinococcus sp. Marseille-Q6407] diamond 234 110 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. Marseille-Q6407
31994181 31994181 PRJEB83711_P_NODE_74318_length_244_cov_0.912281_g74052_i0 PRJEB83711 74318 244 0.912281 2.22596564 uncultured Truepera sp. 543023 Bacteria Bacteria 147 3.23e-39   NR CAA9586279.1 543023 g74052 i0 88.9 0.995901639344262 81 9 99.6 0 2 244 575 655 CAA9586279.1 MAG: Polyribonucleotide nucleotidyltransferase [uncultured Truepera sp.] diamond 243 147 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
32500633 32500633 PRJEB83711_P_NODE_72899_length_245_cov_0.906977_g72633_i0 PRJEB83711 72899 245 0.906977 2.22209365 Deinococcus 1298 Bacteria Bacteria 68.6 2.49e-11   NR WP_041221973.1 1298 g72633 i0 82.5 0.991836734693878 40 7 49 0 243 124 304 343 WP_041221973.1 MULTISPECIES: DNA double-strand break repair nuclease NurA [Deinococcus] diamond 243 68.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
32563959 32563959 PRJEB83711_P_NODE_41719_length_285_cov_1.084906_g41453_i0 PRJEB83711 41719 285 1.084906 3.0919821 Deinococcus maricopensis 309887 Bacteria Bacteria 124 3.5600000000000004e-33   NR WP_013556182.1 309887 g41453 i0 63.7 0.957894736842105 91 33 95.8 0 275 3 15 105 WP_013556182.1 class I SAM-dependent methyltransferase [Deinococcus maricopensis] diamond 273 124 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus maricopensis
32563962 32563962 PRJEB83711_P_NODE_59459_length_252_cov_0.871508_g59193_i0 PRJEB83711 59459 252 0.871508 2.19620016 uncultured Meiothermus sp. 157471 Bacteria Bacteria 57 3.46e-7   NR WP_299428665.1 157471 g59193 i0 39.8 0.988095238095238 83 47 98.8 3 250 2 147 226 WP_299428665.1 DUF6094 domain-containing protein [uncultured Meiothermus sp.] diamond 249 57 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus uncultured Meiothermus sp.
32847037 32847037 PRJEB83711_P_NODE_61480_length_251_cov_0.876404_g61214_i0 PRJEB83711 61480 251 0.876404 2.19977404 Deinococcota bacterium 1913990 Bacteria Bacteria 162 1.5599999999999998e-45   NR MDQ3398781.1 1913990 g61214 i0 91.6 0.99203187250996006 83 7 99.2 0 250 2 25 107 MDQ3398781.1 DUF4158 domain-containing protein [Deinococcota bacterium] diamond 249 162 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
32878537 32878537 PRJEB83711_P_NODE_67700_length_248_cov_0.891429_g67434_i0 PRJEB83711 67700 248 0.891429 2.21074392 Truepera radiovictrix 332249 Bacteria Bacteria 103 1.88e-25   NR WP_013178549.1 332249 g67434 i0 67.9 0.979838709677419 81 22 98 1 3 245 46 122 WP_013178549.1 thymidine kinase [Truepera radiovictrix] diamond 243 103 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix

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