RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 23 ✖

bioproject 1

  • PRJNA695273 · 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
1183676 1183676 PRJNA695273_P_NODE_99901_length_280_cov_1.178744_g99143_i0 PRJNA695273 99901 280 1.178744 3.3004832 uncultured Truepera sp. 543023 Bacteria Bacteria 123 1.6699999999999999e-31   NR CAA9587527.1 543023 g99143 i0 91.2 0.728571428571429 68 6 72.9 0 75 278 2 69 CAA9587527.1 MAG: Cell division protein FtsZ [uncultured Truepera sp.] diamond 204 123 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
2457144 2457144 PRJNA695273_P_NODE_124522_length_251_cov_1.730337_g123764_i0 PRJNA695273 124522 251 1.730337 4.34314587 Acetomicrobium mobile DSM 13181 891968 Bacteria Bacteria 58.5 1.02e-7   NR AFM22532.1 891968 g123764 i0 51 1.74501992031873 49 24 58.6 0 250 104 297 345 AFM22532.1 leucyl aminopeptidase (aminopeptidase T) [Acetomicrobium mobile DSM 13181] diamond 438 58.5 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Acetomicrobiaceae Acetomicrobium Acetomicrobium mobile
10110767 10110767 PRJNA695273_P_NODE_139468_length_247_cov_0.885057_g138710_i0 PRJNA695273 139468 247 0.885057 2.18609079 Deinococcota bacterium 1913990 Bacteria Bacteria 100 1.16e-22   NR MDQ3459487.1 1913990 g138710 i0 69.1 0.983805668016194 81 24 98.4 1 245 3 26 105 MDQ3459487.1 DNA repair protein RecN [Deinococcota bacterium] diamond 243 100 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
17255012 17255012 PRJNA695273_P_NODE_140994_length_247_cov_0.885057_g140236_i0 PRJNA695273 140994 247 0.885057 2.18609079 Deinococcus 1298 Bacteria Bacteria 99 4.159999999999999e-23   NR GHF79131.1 317577 g140236 i0 65.4 2.96356275303644 81 28 98.4 0 1 243 121 201 GHF79131.1 phosphoribosyltransferase [Deinococcus ficus] diamond 732 99.8 0.991983967935872 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
18530862 18530862 PRJNA695273_P_NODE_80495_length_308_cov_1.310638_g79737_i0 PRJNA695273 80495 308 1.310638 4.03676504 Bacteria 2 Bacteria Bacteria 126 3.0599999999999996e-32   NR WP_027893287.1 52023 g79737 i0 60.4 1.96753246753247 101 40 98.4 0 2 304 171 271 WP_027893287.1 ABC transporter substrate-binding protein [Calidithermus chliarophilus] diamond 606 126 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus chliarophilus
26670831 26670831 PRJNA695273_P_NODE_132681_length_249_cov_0.875000_g131923_i0 PRJNA695273 132681 249 0.875 2.17875 Deinococcus apachensis 309886 Bacteria Bacteria 85.5 1.44e-17   NR WP_019586183.1 309886 g131923 i0 59.4 0.831325301204819 69 28 83.1 0 207 1 1 69 WP_019586183.1 NPCBM/NEW2 domain-containing protein [Deinococcus apachensis] diamond 207 85.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus apachensis
26893083 26893083 PRJNA695273_P_NODE_97841_length_282_cov_1.473684_g97083_i0 PRJNA695273 97841 282 1.473684 4.15578888 Deinococcus antarcticus 1298767 Bacteria Bacteria 172 3.04e-49   NR WP_380077332.1 1298767 g97083 i0 100 0.98936170212766 93 0 98.9 0 280 2 205 297 WP_380077332.1 sensor histidine kinase [Deinococcus antarcticus] diamond 279 172 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
27082648 27082648 PRJNA695273_P_NODE_113462_length_264_cov_1.612565_g112704_i0 PRJNA695273 113462 264 1.612565 4.2571716 Thermaceae bacterium 2614257 Bacteria Bacteria 48.5 4.35e-4   NR MBF6594060.1 2614257 g112704 i0 95.8 0.545454545454545 24 1 27.3 0 262 191 626 649 MBF6594060.1 acetate--CoA ligase [Thermaceae bacterium] diamond 144 48.5 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae   Thermaceae bacterium
27208907 27208907 PRJNA695273_P_NODE_141362_length_246_cov_1.780347_g140604_i0 PRJNA695273 141362 246 1.780347 4.37965362 Pyramidobacter piscolens 638849 Bacteria Bacteria 95.5 9.33e-21   NR WP_321822916.1 638849 g140604 i0 53.8 0.975609756097561 80 37 97.6 0 242 3 362 441 WP_321822916.1 phage portal protein [Pyramidobacter piscolens] diamond 240 95.5 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter piscolens
27599620 27599620 PRJNA695273_P_NODE_98884_length_281_cov_1.317308_g98126_i0 PRJNA695273 98884 281 1.317308 3.70163548 Bacteria 2 Bacteria Bacteria 125 5.36e-35   NR MDR1622529.1 2053624 g98126 i0 81.1 2.45551601423488 74 14 79 0 223 2 11 84 MDR1622529.1 type II toxin-antitoxin system PemK/MazF family toxin [Synergistaceae bacterium] diamond 690 126 0.992063492063492 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
27903671 27903671 PRJNA695273_P_NODE_123085_length_253_cov_1.416667_g122327_i0 PRJNA695273 123085 253 1.416667 3.58416751 Deinococcus sp. YIM 134 47478 Bacteria Bacteria 110 1.41e-26   NR WP_331824844.1 3118910 g122327 i0 100 0.628458498023715 53 0 62.8 0 54 212 374 426 WP_331824844.1 type II glyceraldehyde-3-phosphate dehydrogenase [Deinococcus sp. YIM 134068] diamond 159 110 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus lichenicola
28661803 28661803 PRJNA695273_P_NODE_124627_length_251_cov_1.657303_g123869_i0 PRJNA695273 124627 251 1.657303 4.15983053 Deinococcus ficus 317577 Bacteria Bacteria 165 1.63e-46   NR WP_159066068.1 317577 g123869 i0 96.4 0.99203187250996006 83 3 99.2 0 251 3 309 391 WP_159066068.1 hypothetical protein [Deinococcus ficus] diamond 249 165 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
29103857 29103857 PRJNA695273_P_NODE_139168_length_247_cov_0.885057_g138410_i0 PRJNA695273 139168 247 0.885057 2.18609079 Deinococcus enclensis 1049582 Bacteria Bacteria 155 3.2e-45   NR WP_307464941.1 1049582 g138410 i0 97.6 0.995951417004049 82 2 99.6 0 246 1 121 202 WP_307464941.1 hypothetical protein [Deinococcus enclensis] diamond 246 155 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus enclensis
29324701 29324701 PRJNA695273_P_NODE_92349_length_288_cov_1.432558_g91591_i0 PRJNA695273 92349 288 1.432558 4.12576704 Deinococcus reticulitermitis 856736 Bacteria Bacteria 183 3.04e-54   NR WP_092264948.1 856736 g91591 i0 98.9 0.979166666666667 94 1 97.9 0 282 1 268 361 WP_092264948.1 alanine--glyoxylate aminotransferase family protein [Deinococcus reticulitermitis] diamond 282 183 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
29671739 29671739 PRJNA695273_P_NODE_122930_length_253_cov_1.711111_g122172_i0 PRJNA695273 122930 253 1.711111 4.32911083 Deinococcus reticulitermitis 856736 Bacteria Bacteria 117 9.23e-29   NR WP_092262572.1 856736 g122172 i0 100 0.66403162055336 56 0 66.4 0 252 85 467 522 WP_092262572.1 ABC transporter substrate-binding protein [Deinococcus reticulitermitis] diamond 168 117 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
30335822 30335822 PRJNA695273_P_NODE_140532_length_247_cov_0.885057_g139774_i0 PRJNA695273 140532 247 0.885057 2.18609079 Deinococcus yavapaiensis 309889 Bacteria Bacteria 89.4 1.6e-18   NR WP_170131096.1 309889 g139774 i0 56 0.910931174089069 75 33 91.1 0 22 246 666 740 WP_170131096.1 RecQ family ATP-dependent DNA helicase [Deinococcus yavapaiensis] diamond 225 89.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yavapaiensis
31283271 31283271 PRJNA695273_P_NODE_17455_length_678_cov_4.808264_g16712_i0 PRJNA695273 17455 678 4.808264 32.60002992 Thermotogaceae bacterium 2268206 Bacteria Bacteria 72.8 1.59e-12   NR MCD6449480.1 2268206 g16712 i0 40.6 0.469026548672566 106 58 46.5 3 172 486 14 115 MCD6449480.1 Hsp20/alpha crystallin family protein [Thermotogaceae bacterium] diamond 318 72.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae bacterium
31346716 31346716 PRJNA695273_P_NODE_104056_length_275_cov_1.519802_g103298_i0 PRJNA695273 104056 275 1.519802 4.1794555 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 57.4 1.85e-8   NR WP_104992328.1 2080419 g103298 i0 44.6 0.709090909090909 65 28 63.3 2 3 176 22 85 WP_104992328.1 hypothetical protein [Deinococcus sp. NW-56] diamond 195 57.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
31409941 31409941 PRJNA695273_P_NODE_125596_length_251_cov_0.865169_g124838_i0 PRJNA695273 125596 251 0.865169 2.17157419 Deinococcus terrestris 2651870 Bacteria Bacteria 155 1.9999999999999998e-42   NR WP_194165389.1 2651870 g124838 i0 94 2.97609561752988 83 5 99.2 0 250 2 108 190 WP_194165389.1 type IV secretory system conjugative DNA transfer family protein [Deinococcus terrestris] diamond 747 155 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus terrestris
31800468 31800468 PRJNA695273_P_NODE_151457_length_243_cov_1.811765_g150699_i0 PRJNA695273 151457 243 1.811765 4.40258895 Deinococcus 1298 Bacteria Bacteria 112 6.160000000000001e-27   NR WP_188846776.1 1309411 g150699 i0 100 1.71604938271605 59 0 72.8 0 66 242 272 330 WP_188846776.1 hypothetical protein, partial [Deinococcus soli (ex Cha et al. 2016)] diamond 417 113 0.991150442477876 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
31979164 31979164 PRJNA695273_P_NODE_119638_length_257_cov_1.673913_g118880_i0 PRJNA695273 119638 257 1.673913 4.30195641 Deinococcus sp. 47478 Bacteria Bacteria 145 6.67e-39   NR MDO4264762.1 47478 g118880 i0 85.2 0.945525291828794 81 12 94.6 0 249 7 400 480 MDO4264762.1 hypothetical protein [Deinococcus sp.] diamond 243 145 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
32737973 32737973 PRJNA695273_P_NODE_134380_length_249_cov_0.875000_g133622_i0 PRJNA695273 134380 249 0.875 2.17875 Deinococcus reticulitermitis 856736 Bacteria Bacteria 99.4 7.87e-24   NR WP_245745224.1 856736 g133622 i0 77.6 0.91566265060241 76 15 91.6 1 245 18 19 92 WP_245745224.1 hypothetical protein [Deinococcus reticulitermitis] diamond 228 99.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
32800636 32800636 PRJNA695273_P_NODE_59280_length_355_cov_1.634752_g58522_i0 PRJNA695273 59280 355 1.634752 5.8033696 Synergistaceae bacterium 2053624 Bacteria Bacteria 50.8 1.73e-4   NR MBQ6774128.1 2053624 g58522 i0 36.1 0.608450704225352 72 43 58.3 1 127 333 3 74 MBQ6774128.1 hypothetical protein [Synergistaceae bacterium] diamond 216 50.8 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium

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