RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA812715" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 17 ✖

bioproject 1

  • PRJNA812715 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
2087870 2087870 PRJNA812715_P_NODE_119762_length_242_cov_0.911243_g117961_i0 PRJNA812715 119762 242 0.911243 2.20520806 Deinococcus budaensis 1665626 Bacteria Bacteria 111 7.590000000000001e-27   NR WP_184023819.1 1665626 g117961 i0 91.5 0.731404958677686 59 5 73.1 0 64 240 1 59 WP_184023819.1 lycopene cyclase family protein [Deinococcus budaensis] diamond 177 111 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
4643410 4643410 PRJNA812715_P_NODE_94544_length_261_cov_2.047872_g92743_i0 PRJNA812715 94544 261 2.047872 5.34494592 Bacteria 2 Bacteria Bacteria 106 1.82e-24   NR WP_093005720.1 482827 g92743 i0 60.5 7.90804597701149 86 34 98.9 0 259 2 15 100 WP_093005720.1 NAD-dependent malic enzyme [Thermus arciformis] diamond 2064 106 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus arciformis
9742508 9742508 PRJNA812715_P_NODE_79088_length_286_cov_1.197183_g77288_i0 PRJNA812715 79088 286 1.197183 3.42394338 Deinococcus cavernae 2320857 Bacteria Bacteria 131 1.0999999999999999e-33   NR WP_119762055.1 2320857 g77288 i0 69.1 1.99300699300699 94 29 98.6 0 284 3 349 442 WP_119762055.1 cysteine--tRNA ligase [Deinococcus cavernae] diamond 570 131 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
11017694 11017694 PRJNA812715_P_NODE_59269_length_341_cov_2.216418_g57470_i0 PRJNA812715 59269 341 2.216418 7.55798538 Truepera radiovictrix 332249 Bacteria Bacteria 125 2.8599999999999993e-34   NR WP_013178941.1 332249 g57470 i0 56.6 0.932551319648094 106 43 90.6 1 8 316 1 106 WP_013178941.1 Hsp20/alpha crystallin family protein [Truepera radiovictrix] diamond 318 125 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
13565592 13565592 PRJNA812715_P_NODE_112711_length_245_cov_1.790698_g110910_i0 PRJNA812715 112711 245 1.790698 4.3872101 Deinococcus antarcticus 1298767 Bacteria Bacteria 159 2.83e-44   NR WP_380076295.1 1298767 g110910 i0 97.5 0.991836734693878 81 2 99.2 0 245 3 431 511 WP_380076295.1 histidine ammonia-lyase [Deinococcus antarcticus] diamond 243 159 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
15253314 15253314 PRJNA812715_P_NODE_83132_length_279_cov_1.995146_g81332_i0 PRJNA812715 83132 279 1.995146 5.56645734 Thermus brevis 2862456 Bacteria Bacteria 180 1.97e-54   NR WP_219759343.1 2862456 g81332 i0 93.5 0.989247311827957 92 6 98.9 0 278 3 141 232 WP_219759343.1 type III-A CRISPR-associated RAMP protein Csm4 [Thermus brevis] diamond 276 180 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brevis
27086027 27086027 PRJNA812715_P_NODE_88122_length_271_cov_2.434343_g86321_i0 PRJNA812715 88122 271 2.434343 6.59706953 Deinococcus ficus 317577 Bacteria Bacteria 179 9.31e-53   NR WP_159065994.1 317577 g86321 i0 97.8 0.996309963099631 90 2 99.6 0 2 271 246 335 WP_159065994.1 hypothetical protein [Deinococcus ficus] diamond 270 179 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
27094688 27094688 PRJNA812715_P_NODE_92882_length_264_cov_1.387435_g91081_i0 PRJNA812715 92882 264 1.387435 3.6628284 Meiothermus 65551 Bacteria Bacteria 75.9 4.68e-14   NR WP_241768715.1 172827 g91081 i0 42 5.09090909090909 88 50 98.9 1 262 2 8 95 WP_241768715.1 pectinacetylesterase family protein [Meiothermus taiwanensis] diamond 1344 75.9 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus taiwanensis
27906915 27906915 PRJNA812715_P_NODE_82025_length_281_cov_1.480769_g80225_i0 PRJNA812715 82025 281 1.480769 4.16096089 Deinococcus 1298 Bacteria Bacteria 68.9 7.01e-13   NR WP_273988004.1 1298 g80225 i0 54.4 0.725978647686833 68 31 72.6 0 77 280 4 71 WP_273988004.1 MULTISPECIES: stage V sporulation protein S [Deinococcus] diamond 204 68.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
28096577 28096577 PRJNA812715_P_NODE_101985_length_251_cov_0.865169_g100184_i0 PRJNA812715 101985 251 0.865169 2.17157419 Deinococcus radiomollis 468916 Bacteria Bacteria 47.8 6.82e-4   NR WP_407542906.1 468916 g100184 i0 40.5 0.944223107569721 79 39 88.4 3 30 251 268 343 WP_407542906.1 hypothetical protein [Deinococcus radiomollis] diamond 237 47.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiomollis
28349156 28349156 PRJNA812715_P_NODE_31186_length_537_cov_1.644397_g29419_i0 PRJNA812715 31186 537 1.644397 8.83041189 Deinococcus sp. YIM 134 47478 Bacteria Bacteria 114 2.53e-26   NR WP_331823611.1 3118910 g29419 i0 57.6 0.659217877094972 118 40 65.9 1 86 439 1 108 WP_331823611.1 LCP family protein [Deinococcus sp. YIM 134068] diamond 354 114 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus lichenicola
29991153 29991153 PRJNA812715_P_NODE_106611_length_249_cov_0.875000_g104810_i0 PRJNA812715 106611 249 0.875 2.17875 Deinococcus planocerae 1737569 Bacteria Bacteria 138 7.82e-39   NR WP_102125592.1 1737569 g104810 i0 87.7 0.975903614457831 81 10 97.6 0 244 2 1 81 WP_102125592.1 SRPBCC family protein [Deinococcus planocerae] diamond 243 138 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus planocerae
31231949 31231949 PRJNA812715_P_NODE_21975_length_707_cov_2.154574_g20308_i0 PRJNA812715 21975 707 2.154574 15.23283818 Deinococcus 1298 Bacteria Bacteria 376 2.1e-126   NR WP_170928889.1 309885 g20308 i0 71.1 1.99434229137199 235 68 99.7 0 2 706 244 478 WP_170928889.1 glycoside hydrolase family 30 protein [Deinococcus hopiensis] diamond 1410 376 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hopiensis
31318239 31318239 PRJNA812715_P_NODE_77755_length_288_cov_1.432558_g75955_i0 PRJNA812715 77755 288 1.432558 4.12576704 Trueperaceae bacterium 2026798 Bacteria Bacteria 94.4 4.62e-22   NR HLU83722.1 2026798 g75955 i0 51.1 0.958333333333333 92 44 95.8 1 288 13 55 145 HLU83722.1 hypothetical protein [Trueperaceae bacterium] diamond 276 94.4 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
32583826 32583826 PRJNA812715_P_NODE_85579_length_275_cov_2.396040_g83778_i0 PRJNA812715 85579 275 2.39604 6.58911 Trueperaceae bacterium 2026798 Bacteria Bacteria 106 1.93e-25   NR MBX3139460.1 2026798 g83778 i0 57.8 2.95636363636364 90 38 98.2 0 273 4 24 113 MBX3139460.1 patatin-like phospholipase family protein [Trueperaceae bacterium] diamond 813 106 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
32677840 32677840 PRJNA812715_P_NODE_54660_length_360_cov_1.268293_g52861_i0 PRJNA812715 54660 360 1.268293 4.5658548 Marinitoga sp. 1197 1428449 Bacteria Bacteria 191 1.2599999999999998e-55   NR WP_047268736.1 1428449 g52861 i0 78.2 0.991666666666667 119 26 99.2 0 358 2 396 514 WP_047268736.1 L-glutamate gamma-semialdehyde dehydrogenase [Marinitoga sp. 1197] diamond 357 191 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Marinitoga Marinitoga sp. 1197
32866904 32866904 PRJNA812715_P_NODE_106160_length_249_cov_0.875000_g104359_i0 PRJNA812715 106160 249 0.875 2.17875 Truepera radiovictrix 332249 Bacteria Bacteria 66.2 2.14e-10   NR WP_148221269.1 332249 g104359 i0 48.8 0.987951807228916 82 42 98.8 0 1 246 59 140 WP_148221269.1 N-acetylmuramoyl-L-alanine amidase family protein [Truepera radiovictrix] diamond 246 66.2 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);;