RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_phylum = "Thermomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermomicrobiota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1240804 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
16924673 16924673 PRJNA1240804_P_NODE_143514_length_163_cov_0.912281_g143148_i0 PRJNA1240804 143514 163 0.912281 1.48701803 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 94 1.1e-20   NR MCA9833176.1 2482790 g143148 i0 100 0.883435582822086 48 0 88.3 0 15 158 730 777 MCA9833176.1 ribonucleoside-diphosphate reductase subunit alpha [Thermomicrobiales bacterium] diamond 144 94 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
26630376 26630376 PRJNA1240804_P_NODE_49401_length_220_cov_1.116959_g49035_i0 PRJNA1240804 49401 220 1.116959 2.4573098 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 45.8 0.0023   NR MCC6704085.1 2482790 g49035 i0 50 0.736363636363636 54 27 73.6 0 205 44 628 681 MCC6704085.1 helicase-associated domain-containing protein [Thermomicrobiales bacterium] diamond 162 45.8 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
27041944 27041944 PRJNA1240804_P_NODE_71922_length_192_cov_1.342657_g71556_i0 PRJNA1240804 71922 192 1.342657 2.57790144 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 93.2 2.2400000000000003e-21   NR HET9660675.1 2482790 g71556 i0 87.8 0.765625 49 6 76.6 0 162 16 1 49 HET9660675.1 heme-copper oxidase subunit III [Thermomicrobiales bacterium] diamond 147 93.2 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
27073466 27073466 PRJNA1240804_P_NODE_28702_length_271_cov_0.864865_g28336_i0 PRJNA1240804 28702 271 0.864865 2.34378415 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 144 1.94e-38   NR MDF3041866.1 2482790 g28336 i0 77.6 0.940959409594096 85 19 94.1 0 14 268 77 161 MDF3041866.1 Sialic acid-specific 9-O-acetylesterase [Thermomicrobiales bacterium] diamond 255 144 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
28102216 28102216 PRJNA1240804_P_NODE_90465_length_179_cov_2.053846_g90099_i0 PRJNA1240804 90465 179 2.053846 3.67638434 Pseudomonadati 3379134 Bacteria Bacteria 107 2.29e-26   NR MCC6315333.1 2482790 g90099 i0 83.9 1.87709497206704 56 9 93.9 0 169 2 1 56 MCC6315333.1 phosphoglycerate mutase (2,3-diphosphoglycerate-independent) [Thermomicrobiales bacterium] diamond 336 108 0.990740740740741 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
28494822 28494822 PRJNA1240804_P_NODE_80447_length_186_cov_1.423358_g80081_i0 PRJNA1240804 80447 186 1.423358 2.64744588 Thermomicrobium sp. CFH 7336 1969469 Bacteria Bacteria 107 1.26e-26   NR WP_252128660.1 2951987 g80081 i0 91.1 0.903225806451613 56 5 90.3 0 172 5 181 236 WP_252128660.1 manganese catalase family protein [Thermomicrobium sp. CFH 73360] diamond 168 107 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales Thermomicrobiaceae Thermomicrobium Thermomicrobium sp. CFH 73360
29063161 29063161 PRJNA1240804_P_NODE_64428_length_199_cov_4.766667_g64062_i0 PRJNA1240804 64428 199 4.766667 9.48566733 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 49.3 1.01e-4   NR HET9661207.1 2482790 g64062 i0 72.4 0.437185929648241 29 8 43.7 0 17 103 28 56 HET9661207.1 FAD-dependent oxidoreductase [Thermomicrobiales bacterium] diamond 87 49.3 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
29630982 29630982 PRJNA1240804_P_NODE_141330_length_163_cov_1.254386_g140964_i0 PRJNA1240804 141330 163 1.254386 2.04464918 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 61.2 3.76e-9   NR HLU35241.1 2482790 g140964 i0 59.6 1.71165644171779 47 19 86.5 0 16 156 217 263 HLU35241.1 RNA polymerase sigma factor RpoD [Thermomicrobiales bacterium] diamond 279 61.2 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30010472 30010472 PRJNA1240804_P_NODE_145291_length_163_cov_0.912281_g144925_i0 PRJNA1240804 145291 163 0.912281 1.48701803 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 101 1.16e-23   NR HET9659423.1 2482790 g144925 i0 98 2.70552147239264 49 1 90.2 0 148 2 38 86 HET9659423.1 malic enzyme-like NAD(P)-binding protein [Thermomicrobiales bacterium] diamond 441 101 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30199624 30199624 PRJNA1240804_P_NODE_128112_length_166_cov_0.888889_g127746_i0 PRJNA1240804 128112 166 0.888889 1.47555574 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 66.2 6.46e-11   NR MDF3041866.1 2482790 g127746 i0 78.8 0.596385542168675 33 7 59.6 0 45 143 470 502 MDF3041866.1 Sialic acid-specific 9-O-acetylesterase [Thermomicrobiales bacterium] diamond 99 66.2 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30610518 30610518 PRJNA1240804_P_NODE_86633_length_182_cov_1.338346_g86267_i0 PRJNA1240804 86633 182 1.338346 2.43578972 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 91.7 7.290000000000001e-21   NR HEY8601822.1 2482790 g86267 i0 71.4 0.923076923076923 56 16 92.3 0 2 169 145 200 HEY8601822.1 Uma2 family endonuclease [Thermomicrobiales bacterium] diamond 168 91.7 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31305734 31305734 PRJNA1240804_P_NODE_142675_length_163_cov_0.912281_g142309_i0 PRJNA1240804 142675 163 0.912281 1.48701803 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 74.7 2.01e-15   NR MEJ7838513.1 2482790 g142309 i0 78.6 0.773006134969325 42 9 77.3 0 149 24 46 87 MEJ7838513.1 30S ribosomal protein S8 [Thermomicrobiales bacterium] diamond 126 74.7 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31780196 31780196 PRJNA1240804_P_NODE_76297_length_189_cov_1.342857_g75931_i0 PRJNA1240804 76297 189 1.342857 2.53799973 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 102 1.1699999999999997e-23   NR MCC6943408.1 2482790 g75931 i0 84.5 1.84126984126984 58 9 92.1 0 14 187 347 404 MCC6943408.1 ATP-binding protein [Thermomicrobiales bacterium] diamond 348 102 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
31843331 31843331 PRJNA1240804_P_NODE_108617_length_169_cov_0.866667_g108251_i0 PRJNA1240804 108617 169 0.866667 1.46466723 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 72.8 8.21e-15   NR MBX3071548.1 2482790 g108251 i0 88.9 0.63905325443787 36 4 63.9 0 60 167 65 100 MBX3071548.1 DUF86 domain-containing protein [Thermomicrobiales bacterium] diamond 108 72.8 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
32033322 32033322 PRJNA1240804_P_NODE_108278_length_169_cov_0.866667_g107912_i0 PRJNA1240804 108278 169 0.866667 1.46466723 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 51.2 1.4e-5   NR MCD6031830.1 2482790 g107912 i0 84 0.905325443786982 25 4 44.4 0 73 147 109 133 MCD6031830.1 sulfotransferase [Thermomicrobiales bacterium] diamond 153 51.2 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
32413200 32413200 PRJNA1240804_P_NODE_59559_length_205_cov_2.397436_g59193_i0 PRJNA1240804 59559 205 2.397436 4.9147438 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 107 5.22e-25   NR HLU34803.1 2482790 g59193 i0 79.7 3.73170731707317 64 13 93.7 0 14 205 484 547 HLU34803.1 NAD-dependent DNA ligase LigA [Thermomicrobiales bacterium] diamond 765 107 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales 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);;