RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 32 ✖

bioproject 1

  • PRJNA1059246 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
2727709 2727709 PRJNA1059246_P_NODE_49763_length_290_cov_1.073733_g49137_i0 PRJNA1059246 49763 290 1.073733 3.1138257 Bacteria 2 Bacteria Bacteria 97.4 2.0200000000000003e-21   NR WP_103129475.1 200253 g49137 i0 50.5 9.84827586206896 101 45 99.3 1 288 1 113 213 WP_103129475.1 alginate lyase family protein [Deinococcus aerius] diamond 2856 97.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aerius
14206051 14206051 PRJNA1059246_P_NODE_66072_length_247_cov_0.885057_g65446_i0 PRJNA1059246 66072 247 0.885057 2.18609079 Truepera radiovictrix 332249 Bacteria Bacteria 71.2 3.64e-12   NR WP_013177749.1 332249 g65446 i0 52.3 1.04453441295547 86 34 96 1 246 10 664 749 WP_013177749.1 tetratricopeptide repeat protein [Truepera radiovictrix] diamond 258 71.2 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
18028788 18028788 PRJNA1059246_P_NODE_35375_length_363_cov_1.062069_g34749_i0 PRJNA1059246 35375 363 1.062069 3.85531047 Deinococcus 1298 Bacteria Bacteria 174 1.16e-52   NR WP_109828050.1 2202254 g34749 i0 70.5 12.1487603305785 122 34 100 2 363 1 44 164 WP_109828050.1 lysophospholipid acyltransferase family protein [Deinococcus irradiatisoli] diamond 4410 175 0.994285714285714 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus irradiatisoli
20578269 20578269 PRJNA1059246_P_NODE_49957_length_289_cov_1.425926_g49331_i0 PRJNA1059246 49957 289 1.425926 4.12092614 Deinococcus sonorensis 309891 Bacteria Bacteria 126 2.21e-31   NR WP_350243382.1 309891 g49331 i0 68.4 0.986159169550173 95 30 98.6 0 288 4 583 677 WP_350243382.1 insulinase family protein [Deinococcus sonorensis] diamond 285 126 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sonorensis
21853876 21853876 PRJNA1059246_P_NODE_35058_length_365_cov_0.982877_g34432_i0 PRJNA1059246 35058 365 0.982877 3.58750105 Deinococcus 1298 Bacteria Bacteria 127 1.7899999999999998e-32   NR WP_350243957.1 309891 g34432 i0 62.4 5.8027397260274 117 44 96.2 0 6 356 221 337 WP_350243957.1 glycosyltransferase [Deinococcus sonorensis] diamond 2118 128 0.9921875 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sonorensis
26591951 26591951 PRJNA1059246_P_NODE_53501_length_278_cov_1.843902_g52875_i0 PRJNA1059246 53501 278 1.843902 5.12604756 Trueperaceae bacterium 2026798 Bacteria Bacteria 83.6 2.45e-16   NR MDZ7703619.1 2026798 g52875 i0 43.5 1.98561151079137 92 52 99.3 0 277 2 60 151 MDZ7703619.1 MBL fold metallo-hydrolase [Trueperaceae bacterium] diamond 552 83.6 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
26750130 26750130 PRJNA1059246_P_NODE_72081_length_241_cov_0.916667_g71455_i0 PRJNA1059246 72081 241 0.916667 2.20916747 Deinococcus budaensis 1665626 Bacteria Bacteria 80.1 1.64e-16   NR WP_221269713.1 1665626 g71455 i0 85.1 0.5850622406639 47 7 58.5 0 142 2 1 47 WP_221269713.1 signal peptidase II [Deinococcus budaensis] diamond 141 80.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
27003623 27003623 PRJNA1059246_P_NODE_66602_length_247_cov_0.879310_g65976_i0 PRJNA1059246 66602 247 0.87931 2.1718957 Deinococcus sp. YIM 134 47478 Bacteria Bacteria 112 3.08e-28   NR WP_331823953.1 3118910 g65976 i0 75.9 0.959514170040486 79 19 96 0 240 4 150 228 WP_331823953.1 ABC transporter permease subunit [Deinococcus sp. YIM 134068] diamond 237 112 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus lichenicola
27098586 27098586 PRJNA1059246_P_NODE_58422_length_262_cov_1.349206_g57796_i0 PRJNA1059246 58422 262 1.349206 3.53491972 Deinococcus hopiensis 309885 Bacteria Bacteria 143 1.8e-39   NR WP_170928830.1 309885 g57796 i0 77 0.99618320610687 87 20 99.6 0 1 261 14 100 WP_170928830.1 phosphotransferase enzyme family protein [Deinococcus hopiensis] diamond 261 143 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hopiensis
27121708 27121708 PRJNA1059246_P_NODE_2802_length_1479_cov_2.923186_g2537_i0 PRJNA1059246 2802 1479 2.923186 43.23392094 Thermaceae 188786 Bacteria Bacteria 297 3.4e-88   NR WP_018465074.1 307124 g2537 i0 37.3 6.79918864097363 483 244 96.6 12 7 1434 355 785 WP_018465074.1 penicillin acylase family protein [Calidithermus timidus] diamond 10056 297 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus timidus
27532776 27532776 PRJNA1059246_P_NODE_71563_length_242_cov_0.911243_g70937_i0 PRJNA1059246 71563 242 0.911243 2.20520806 Deinococci 188787 Bacteria Bacteria 115 1.9499999999999999e-31   NR WP_013178875.1 332249 g70937 i0 72.5 3.96694214876033 80 22 99.2 0 2 241 16 95 WP_013178875.1 MGMT family protein [Truepera radiovictrix] diamond 960 115 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
28298687 28298687 PRJNA1059246_P_NODE_70646_length_243_cov_0.905882_g70020_i0 PRJNA1059246 70646 243 0.905882 2.20129326 Deinococcus irradiatisoli 2202254 Bacteria Bacteria 148 2.5699999999999998e-42   NR WP_109827483.1 2202254 g70020 i0 83.8 0.987654320987654 80 13 98.8 0 3 242 147 226 WP_109827483.1 hypothetical protein [Deinococcus irradiatisoli] diamond 240 148 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus irradiatisoli
28361796 28361796 PRJNA1059246_P_NODE_64986_length_248_cov_0.880000_g64360_i0 PRJNA1059246 64986 248 0.88 2.1824 Deinococcus aestuarii 2774531 Bacteria Bacteria 128 1.85e-32   NR WP_343216647.1 2774531 g64360 i0 95.6 0.82258064516129 68 3 82.3 0 44 247 1 68 WP_343216647.1 tetratricopeptide repeat protein [Deinococcus aestuarii] diamond 204 128 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aestuarii
28772288 28772288 PRJNA1059246_P_NODE_51347_length_285_cov_1.363208_g50721_i0 PRJNA1059246 51347 285 1.363208 3.8851428 Deinococcus alpinitundrae 468913 Bacteria Bacteria 93.2 6.72e-20   NR WP_161881238.1 468913 g50721 i0 58.8 1.88421052631579 85 30 89.5 1 3 257 98 177 WP_161881238.1 M16 family metallopeptidase [Deinococcus alpinitundrae] diamond 537 93.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus alpinitundrae
29592890 29592890 PRJNA1059246_P_NODE_67610_length_246_cov_0.890173_g66984_i0 PRJNA1059246 67610 246 0.890173 2.18982558 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 87 2.43e-18   NR WP_104992360.1 2080419 g66984 i0 84.3 0.621951219512195 51 8 62.2 0 155 3 1 51 WP_104992360.1 ABC transporter substrate-binding protein [Deinococcus sp. NW-56] diamond 153 87 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
29750900 29750900 PRJNA1059246_P_NODE_51071_length_286_cov_1.201878_g50445_i0 PRJNA1059246 51071 286 1.201878 3.43737108 Deinococcus peraridilitoris 432329 Bacteria Bacteria 144 9.98e-40   NR WP_015236214.1 432329 g50445 i0 83 0.986013986013986 94 16 98.6 0 5 286 181 274 WP_015236214.1 M20/M25/M40 family metallo-hydrolase [Deinococcus peraridilitoris] diamond 282 144 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
29940842 29940842 PRJNA1059246_P_NODE_66891_length_246_cov_0.890173_g66265_i0 PRJNA1059246 66891 246 0.890173 2.18982558 Deinococcus 1298 Bacteria Bacteria 57.8 4.29e-8   NR WP_012173350.1 1298 g66265 i0 38.5 0.951219512195122 78 48 95.1 0 242 9 51 128 WP_012173350.1 MULTISPECIES: hypothetical protein [Deinococcus] diamond 234 57.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
30003936 30003936 PRJNA1059246_P_NODE_64371_length_249_cov_0.875000_g63745_i0 PRJNA1059246 64371 249 0.875 2.17875 Synergistaceae bacterium 2053624 Bacteria Bacteria 69.7 1.31e-11   NR MDR2522629.1 2053624 g63745 i0 51.8 1.02409638554217 85 30 98.8 3 246 1 443 519 MDR2522629.1 response regulator [Synergistaceae bacterium] diamond 255 69.7 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
30066963 30066963 PRJNA1059246_P_NODE_61892_length_251_cov_0.865169_g61266_i0 PRJNA1059246 61892 251 0.865169 2.17157419 Deinococcus budaensis 1665626 Bacteria Bacteria 121 7.43e-30   NR WP_246363318.1 1665626 g61266 i0 88 0.99203187250996006 83 10 99.2 0 249 1 3 85 WP_246363318.1 ribonuclease R [Deinococcus budaensis] diamond 249 121 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
30320281 30320281 PRJNA1059246_P_NODE_16092_length_580_cov_2.126233_g15488_i0 PRJNA1059246 16092 580 2.126233 12.3321514 Thermaceae bacterium 2614257 Bacteria Bacteria 48.5 0.00381   NR MBF6595743.1 2614257 g15488 i0 44.9 0.253448275862069 49 27 25.3 0 579 433 3 51 MBF6595743.1 DUF4397 domain-containing protein [Thermaceae bacterium] diamond 147 48.5 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae   Thermaceae bacterium
30698844 30698844 PRJNA1059246_P_NODE_58014_length_263_cov_2.326316_g57388_i0 PRJNA1059246 58014 263 2.326316 6.11821108 Deinococcus sp. Marseille-Q64 47478 Bacteria Bacteria 117 1.11e-30   NR WP_261664435.1 2969223 g57388 i0 84.6 2.8745247148289 65 10 74.1 0 261 67 82 146 WP_261664435.1 single-stranded DNA-binding protein [Deinococcus sp. Marseille-Q6407] diamond 756 117 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. Marseille-Q6407
30880262 30880262 PRJNA1059246_P_NODE_61794_length_251_cov_0.865169_g61168_i0 PRJNA1059246 61794 251 0.865169 2.17157419 Deinococcus 1298 Bacteria Bacteria 109 1.99e-28   NR WP_013556596.1 309887 g61168 i0 59.8 4.94820717131474 82 33 98 0 5 250 4 85 WP_013556596.1 PA2169 family four-helix-bundle protein [Deinococcus maricopensis] diamond 1242 110 0.990909090909091 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus maricopensis
30888545 30888545 PRJNA1059246_P_NODE_67994_length_245_cov_0.895349_g67368_i0 PRJNA1059246 67994 245 0.895349 2.19360505 Deinococcus geothermalis 68909 Bacteria Bacteria 116 3.8599999999999998e-28   NR WP_011525904.1 68909 g67368 i0 73.1 1.9469387755102 78 21 95.5 0 238 5 478 555 WP_011525904.1 NPCBM/NEW2 domain-containing protein [Deinococcus geothermalis] diamond 477 116 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
31006674 31006674 PRJNA1059246_P_NODE_26514_length_431_cov_2.027933_g25889_i0 PRJNA1059246 26514 431 2.027933 8.74039123 FCB group 1783270 Bacteria Bacteria 106 7.52e-24   NR MBX3142005.1 2026798 g25889 i0 50.5 5.84686774941995 107 52 74.5 1 4 324 329 434 MBX3142005.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Trueperaceae bacterium] diamond 2520 107 0.990654205607477 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
31014822 31014822 PRJNA1059246_P_NODE_26475_length_432_cov_1.077994_g25850_i0 PRJNA1059246 26475 432 1.077994 4.65693408 Meiothermus sp. 1955249 Bacteria Bacteria 61.6 3.04e-8   NR WP_297563442.1 1955249 g25850 i0 30 0.902777777777778 130 78 83.3 3 59 418 82 208 WP_297563442.1 L-type lectin-domain containing protein [Meiothermus sp.] diamond 390 61.6 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus sp.
31235962 31235962 PRJNA1059246_P_NODE_60615_length_254_cov_1.276243_g59989_i0 PRJNA1059246 60615 254 1.276243 3.24165722 Deinococcota bacterium 1913990 Bacteria Bacteria 57 4.06e-7   NR NBC96904.1 1913990 g59989 i0 45.3 1.01574803149606 86 36 96.9 3 2 247 522 600 NBC96904.1 heavy metal translocating P-type ATPase [Deinococcota bacterium] diamond 258 57 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
31330900 31330900 PRJNA1059246_P_NODE_61296_length_251_cov_1.730337_g60670_i0 PRJNA1059246 61296 251 1.730337 4.34314587 Calidithermus terrae 1408545 Bacteria Bacteria 72.4 1.47e-12   NR WP_245971439.1 1408545 g60670 i0 48.2 1.9840637450199201 83 32 99.2 1 3 251 97 168 WP_245971439.1 penicillin acylase family protein [Calidithermus terrae] diamond 498 72.4 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus terrae
31330907 31330907 PRJNA1059246_P_NODE_67756_length_245_cov_1.720930_g67130_i0 PRJNA1059246 67756 245 1.72093 4.2162785 unclassified Meiothermus 370471 Bacteria Bacteria 82 5.67e-16   NR WP_110527275.1 370471 g67130 i0 54.4 0.96734693877551 79 36 96.7 0 6 242 722 800 WP_110527275.1 MULTISPECIES: efflux RND transporter permease subunit [unclassified Meiothermus] diamond 237 82 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus  
31868569 31868569 PRJNA1059246_P_NODE_71157_length_242_cov_0.911243_g70531_i0 PRJNA1059246 71157 242 0.911243 2.20520806 uncultured Truepera sp. 543023 Bacteria Bacteria 75.1 1.24e-14   NR CAA9568631.1 543023 g70531 i0 67.8 0.731404958677686 59 18 71.9 1 5 178 79 137 CAA9568631.1 MAG: hypothetical protein AVDCRST_MAG86-1321 [uncultured Truepera sp.] diamond 177 75.1 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
32113741 32113741 PRJNA1059246_P_NODE_62658_length_250_cov_0.870056_g62032_i0 PRJNA1059246 62658 250 0.870056 2.17514 Deinococcus 1298 Bacteria Bacteria 107 9.84e-25   NR WP_235514514.1 1736338 g62032 i0 65.1 7.956 83 28 98.4 1 247 2 605 687 WP_235514514.1 3'-5' exonuclease [Deinococcus sp. Leaf326] diamond 1989 107 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. Leaf326
32619544 32619544 PRJNA1059246_P_NODE_53560_length_278_cov_1.502439_g52934_i0 PRJNA1059246 53560 278 1.502439 4.17678042 root 1 Root_unresolved Root_unresolved 44.7 0.0112   NR HCL79919.1 2053624 g52934 i0 52.8 0.91726618705036 36 17 38.8 0 273 166 310 345 HCL79919.1 hypothetical protein [Synergistaceae bacterium] diamond 255 45.1 0.991130820399113 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
32753705 32753705 PRJNA1059246_P_NODE_70500_length_243_cov_0.905882_g69874_i0 PRJNA1059246 70500 243 0.905882 2.20129326 Deinococcota bacterium 1913990 Bacteria Bacteria 93.6 6.389999999999999e-23   NR MEY4531828.1 1913990 g69874 i0 63.8 0.851851851851852 69 25 85.2 0 207 1 1 69 MEY4531828.1 hypothetical protein [Deinococcota bacterium] diamond 207 93.6 1 Bacteria   Thermotogati Deinococcota         Deinococcota 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);;