RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA915212" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA915212 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
2170572 2170572 PRJNA915212_P_NODE_6422_length_231_cov_1.494505_g6384_i0 PRJNA915212 6422 231 1.494505 3.45230655 Phycicoccus sonneratiae 2807628 Bacteria Bacteria 106 1.28e-24   NR WP_204132036.1 2807628 g6384 i0 65.3 0.974025974025974 75 25 97.4 1 6 230 158 231 WP_204132036.1 phosphoenolpyruvate carboxykinase (GTP) [Phycicoccus sonneratiae] diamond 225 106 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Phycicoccus Phycicoccus sonneratiae
7273385 7273385 PRJNA915212_P_NODE_4486_length_286_cov_1.455696_g4448_i0 PRJNA915212 4486 286 1.455696 4.16329056 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 149 5.27e-44   NR MCP3885490.1 2021380 g4448 i0 72 0.975524475524476 93 26 97.6 0 3 281 27 119 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 279 149 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
13648707 13648707 PRJNA915212_P_NODE_11051_length_172_cov_1.658537_g11013_i0 PRJNA915212 11051 172 1.658537 2.85268364 Streptomyces tateyamensis 565073 Bacteria Bacteria 78.2 4.54e-15   NR WP_110672287.1 565073 g11013 i0 78.3 3.13953488372093 46 10 80.2 0 138 1 220 265 WP_110672287.1 aldehyde dehydrogenase family protein [Streptomyces tateyamensis] diamond 540 78.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces tateyamensis
22928693 22928693 PRJNA915212_P_NODE_10718_length_175_cov_2.023810_g10680_i0 PRJNA915212 10718 175 2.02381 3.5416675 Frankiaceae bacterium 2654182 Bacteria Bacteria 99.4 1.8199999999999994e-23   NR MDQ1679347.1 2654182 g10680 i0 75.9 0.994285714285714 58 14 99.4 0 174 1 140 197 MDQ1679347.1 ornithine decarboxylase [Frankiaceae bacterium] diamond 174 99.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales Frankiaceae   Frankiaceae bacterium
26739234 26739234 PRJNA915212_P_NODE_14981_length_161_cov_0.910714_g14943_i0 PRJNA915212 14981 161 0.910714 1.46624954 Actinocrinis sp. 1920516 Bacteria Bacteria 42.4 0.0132   NR HEY3869436.1 1920516 g14943 i0 45.7 0.652173913043478 35 18 65.2 1 137 33 56 89 HEY3869436.1 hypothetical protein [Actinocrinis sp.] diamond 105 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Actinospicaceae Actinocrinis Actinocrinis sp.
26771390 26771390 PRJNA915212_P_NODE_8621_length_198_cov_1.711409_g8583_i0 PRJNA915212 8621 198 1.711409 3.38858982 Streptomyces sp. DR7-3 2951170 Bacteria Bacteria 42.4 0.0282   NR WP_251771625.1 2951170 g8583 i0 48.6 0.560606060606061 37 19 56.1 0 157 47 581 617 WP_251771625.1 ATP-binding protein [Streptomyces sp. DR7-3] diamond 111 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. DR7-3
26992690 26992690 PRJNA915212_P_NODE_6202_length_236_cov_1.085561_g6164_i0 PRJNA915212 6202 236 1.085561 2.56192396 Cellulomonas endophytica 2494735 Bacteria Bacteria 50.1 9.12e-5   NR WP_129338357.1 2494735 g6164 i0 44 0.635593220338983 50 27 63.6 1 159 10 330 378 WP_129338357.1 kelch repeat-containing protein [Cellulomonas endophytica] diamond 150 50.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Cellulomonas Cellulomonas endophytica
27182417 27182417 PRJNA915212_P_NODE_6882_length_223_cov_1.172414_g6844_i0 PRJNA915212 6882 223 1.172414 2.61448322 Actinomycetota bacterium 2900548 Bacteria Bacteria 67 1.96e-11   NR MSY20126.1 2900548 g6844 i0 56.6 1.41255605381166 53 23 71.3 0 161 3 1 53 MSY20126.1 FMN-dependent NADH-azoreductase [Actinomycetota bacterium] diamond 315 67 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27656626 27656626 PRJNA915212_P_NODE_4304_length_293_cov_1.036885_g4266_i0 PRJNA915212 4304 293 1.036885 3.03807305 Actinomycetota bacterium 2900548 Bacteria Bacteria 63.5 2.55e-9   NR MDQ4144637.1 2900548 g4266 i0 38.8 0.870307167235495 85 50 85 2 7 255 185 269 MDQ4144637.1 hypothetical protein [Actinomycetota bacterium] diamond 255 63.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27688427 27688427 PRJNA915212_P_NODE_6084_length_239_cov_1.073684_g6046_i0 PRJNA915212 6084 239 1.073684 2.56610476 Sphaerisporangium sp. B11E5 3153563 Bacteria Bacteria 50.8 3.8e-5   NR WP_347637736.1 3153563 g6046 i0 39.3 2.37238493723849 61 37 76.6 0 37 219 6 66 WP_347637736.1 hypothetical protein [Sphaerisporangium sp. B11E5] diamond 567 50.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Sphaerisporangium Sphaerisporangium sp. B11E5
28192983 28192983 PRJNA915212_P_NODE_6926_length_222_cov_1.358382_g6888_i0 PRJNA915212 6926 222 1.358382 3.01560804 Yinghuangia aomiensis 676205 Bacteria Bacteria 42.7 0.0148   NR WP_345680412.1 676205 g6888 i0 40.8 0.662162162162162 49 24 59.5 1 11 142 43 91 WP_345680412.1 MarR family transcriptional regulator [Yinghuangia aomiensis] diamond 147 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Yinghuangia Yinghuangia aomiensis
28319446 28319446 PRJNA915212_P_NODE_7306_length_216_cov_1.526946_g7268_i0 PRJNA915212 7306 216 1.526946 3.29820336 Jatrophihabitans sp. 1932789 Bacteria Bacteria 48.5 2.28e-4   NR HET8583658.1 1932789 g7268 i0 50 0.833333333333333 60 30 83.3 0 29 208 252 311 HET8583658.1 trypsin-like peptidase domain-containing protein [Jatrophihabitans sp.] diamond 180 48.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Jatrophihabitantales Jatrophihabitantaceae Jatrophihabitans Jatrophihabitans sp.
28540733 28540733 PRJNA915212_P_NODE_13447_length_164_cov_0.886957_g13409_i0 PRJNA915212 13447 164 0.886957 1.45460948 Actinomycetales bacterium 1911520 Bacteria Bacteria 43.5 0.00689   NR MBU6278894.1 1911520 g13409 i0 50 1.71951219512195 50 25 91.5 0 14 163 114 163 MBU6278894.1 IPT/TIG domain-containing protein [Actinomycetales bacterium] diamond 282 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales     Actinomycetales bacterium
28579536 28579536 PRJNA915212_P_NODE_4427_length_288_cov_1.276151_g4389_i0 PRJNA915212 4427 288 1.276151 3.67531488 root 1 Root_unresolved Root_unresolved 106 2.6699999999999998e-24   NR HEY6575284.1 1785 g4389 i0 51.5 24.4895833333333 99 44 100 2 1 288 364 461 HEY6575284.1 glutaminase A [Mycobacterium sp.] diamond 7053 107 0.990654205607477 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
28768765 28768765 PRJNA915212_P_NODE_14547_length_162_cov_0.902655_g14509_i0 PRJNA915212 14547 162 0.902655 1.4623011 root 1 Root_unresolved Root_unresolved 42 0.00799   NR WP_371866031.1 66892 g14509 i0 42 5.55555555555556 50 28 92.6 1 2 151 4 52 WP_371866031.1 hypothetical protein [Streptomyces gardneri] diamond 900 42.4 0.990566037735849 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces gardneri
28824393 28824393 PRJNA915212_P_NODE_13668_length_163_cov_1.315789_g13630_i0 PRJNA915212 13668 163 1.315789 2.14473607 Actinomycetes bacterium 1883427 Bacteria Bacteria 82.8 9.65e-17   NR MCL2324580.1 1883427 g13630 i0 71.7 0.975460122699387 53 15 97.5 0 162 4 531 583 MCL2324580.1 acetate--CoA ligase [Actinomycetes bacterium] diamond 159 82.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
28831915 28831915 PRJNA915212_P_NODE_6928_length_222_cov_1.179191_g6890_i0 PRJNA915212 6928 222 1.179191 2.61780402 Bacteria 2 Bacteria Bacteria 87.8 1.37e-18   NR MBP0573113.1 1773 g6890 i0 58 15.4459459459459 69 28 93.2 1 14 220 155 222 MBP0573113.1 isocitrate lyase [Mycobacterium tuberculosis] diamond 3429 88.6 0.99097065462754 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
29053157 29053157 PRJNA915212_P_NODE_3868_length_313_cov_1.310606_g3830_i0 PRJNA915212 3868 313 1.310606 4.10219678 Bacillati 1783272 Bacteria Bacteria 112 1.15e-26   NR WP_306892402.1 205332 g3830 i0 54.2 17.5974440894569 96 44 92 0 22 309 195 290 WP_306892402.1 NAD-dependent succinate-semialdehyde dehydrogenase [Agromyces albus] diamond 5508 112 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Agromyces Agromyces albus
29172155 29172155 PRJNA915212_P_NODE_9389_length_189_cov_2.542857_g9351_i0 PRJNA915212 9389 189 2.542857 4.80599973 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 45.4 0.00113   NR HJQ86506.1 2021380 g9351 i0 43.5 0.73015873015873 46 26 73 0 187 50 116 161 HJQ86506.1 DUF4440 domain-containing protein [Propionibacteriaceae bacterium] diamond 138 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
29495071 29495071 PRJNA915212_P_NODE_14830_length_161_cov_0.910714_g14792_i0 PRJNA915212 14830 161 0.910714 1.46624954 Microbacteriaceae 85023 Bacteria Bacteria 55.1 5.35e-7   NR MET0780079.1 51671 g14792 i0 43.4 4.67701863354037 53 30 98.8 0 1 159 189 241 MET0780079.1 acyl-CoA dehydrogenase family protein [Microbacterium sp.] diamond 753 55.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp.
29961371 29961371 PRJNA915212_P_NODE_12131_length_166_cov_1.307692_g12093_i0 PRJNA915212 12131 166 1.307692 2.17076872 Gaiellaceae bacterium 2838783 Bacteria Bacteria 50.4 9.27e-6   NR HZQ64711.1 2838783 g12093 i0 46.2 0.939759036144578 52 28 94 0 157 2 93 144 HZQ64711.1 universal stress protein [Gaiellaceae bacterium] diamond 156 50.4 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
30063394 30063394 PRJNA915212_P_NODE_14651_length_161_cov_1.366071_g14613_i0 PRJNA915212 14651 161 1.366071 2.19937431 Bacteria 2 Bacteria Bacteria 65.5 1.1e-10   NR WP_163714929.1 1273442 g14613 i0 61.5 5.85093167701863 52 20 96.9 0 2 157 192 243 WP_163714929.1 zinc-binding dehydrogenase [Mycobacterium bourgelatii] diamond 942 65.9 0.993930197268589 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium bourgelatii
30687952 30687952 PRJNA915212_P_NODE_10573_length_177_cov_1.195312_g10535_i0 PRJNA915212 10573 177 1.195312 2.11570224 Actinomycetales bacterium 1911520 Bacteria Bacteria 87.4 1.86e-18   NR HZI97519.1 1911520 g10535 i0 68.4 1.93220338983051 57 18 96.6 0 175 5 169 225 HZI97519.1 NADP-dependent isocitrate dehydrogenase [Actinomycetales bacterium] diamond 342 87.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales     Actinomycetales bacterium
31225090 31225090 PRJNA915212_P_NODE_13655_length_163_cov_1.342105_g13617_i0 PRJNA915212 13655 163 1.342105 2.18763115 Nonomuraea guangzhouensis 1291555 Bacteria Bacteria 58.2 3.31e-8   NR WP_219529204.1 1291555 g13617 i0 61 0.754601226993865 41 16 75.5 0 130 8 142 182 WP_219529204.1 NBR1-Ig-like domain-containing protein [Nonomuraea guangzhouensis] diamond 123 58.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea guangzhouensis
31446689 31446689 PRJNA915212_P_NODE_7996_length_206_cov_1.617834_g7958_i0 PRJNA915212 7996 206 1.617834 3.33273804 Miltoncostaeaceae bacterium 2952967 Bacteria Bacteria 68.2 1.9e-11   NR HEX2508336.1 2952967 g7958 i0 71.7 4.22330097087379 46 13 67 0 55 192 1 46 HEX2508336.1 malate dehydrogenase [Miltoncostaeaceae bacterium] diamond 870 68.2 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Miltoncostaeales Miltoncostaeaceae   Miltoncostaeaceae bacterium
31510078 31510078 PRJNA915212_P_NODE_3076_length_363_cov_1.372611_g3039_i0 PRJNA915212 3076 363 1.372611 4.98257793 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 85.1 1.12e-17   NR HEY1737547.1 2080302 g3039 i0 43.4 4.19834710743802 99 56 81.8 0 6 302 96 194 HEY1737547.1 hypothetical protein [Acidimicrobiia bacterium] diamond 1524 85.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
31541643 31541643 PRJNA915212_P_NODE_12336_length_166_cov_0.871795_g12298_i0 PRJNA915212 12336 166 0.871795 1.4471797 Intrasporangium calvum 53358 Bacteria Bacteria 80.9 2.36e-16   NR WP_013491894.1 53358 g12298 i0 70.4 4.87951807228916 54 16 97.6 0 3 164 235 288 WP_013491894.1 quinone oxidoreductase family protein [Intrasporangium calvum] diamond 810 80.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Intrasporangium Intrasporangium calvum
31699743 31699743 PRJNA915212_P_NODE_6377_length_232_cov_1.393443_g6339_i0 PRJNA915212 6377 232 1.393443 3.23278776 Arthrobacter pullicola 2762224 Bacteria Bacteria 57 2.89e-7   NR WP_191745298.1 2762224 g6339 i0 43.3 2.71551724137931 67 38 86.6 0 227 27 42 108 WP_191745298.1 aldehyde dehydrogenase family protein [Arthrobacter pullicola] diamond 630 57 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter pullicola
31762880 31762880 PRJNA915212_P_NODE_12317_length_166_cov_0.871795_g12279_i0 PRJNA915212 12317 166 0.871795 1.4471797 Actinomycetota bacterium 2900548 Bacteria Bacteria 98.6 3.23e-23   NR MBM3687656.1 2900548 g12279 i0 84.9 14.3674698795181 53 8 95.8 0 6 164 103 155 MBM3687656.1 phosphoenolpyruvate carboxykinase (GTP) [Actinomycetota bacterium] diamond 2385 98.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
32332815 32332815 PRJNA915212_P_NODE_7699_length_210_cov_1.881988_g7661_i0 PRJNA915212 7699 210 1.881988 3.9521748 Actinomycetes bacterium 1883427 Bacteria Bacteria 44.3 0.00336   NR MEI6450101.1 1883427 g7661 i0 38.5 0.742857142857143 52 32 74.3 0 2 157 44 95 MEI6450101.1 hypothetical protein [Actinomycetes bacterium] diamond 156 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes 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);;