RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA893346" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA893346 · 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
27276978 27276978 PRJNA893346_P_NODE_19043_length_354_cov_1.000000_g18554_i0 PRJNA893346 19043 354 1 3.54 Actinomycetota bacterium 2900548 Bacteria Bacteria 45.1 0.0152   NR MBO0808639.1 2900548 g18554 i0 33.3 0.889830508474576 105 59 87.3 3 309 1 4 99 MBO0808639.1 methyltransferase [Actinomycetota bacterium] diamond 315 45.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27656030 27656030 PRJNA893346_P_NODE_23204_length_318_cov_1.159184_g22714_i0 PRJNA893346 23204 318 1.159184 3.68620512 Pseudonocardiaceae bacterium 1873463 Bacteria Bacteria 44.3 0.0238   NR HWE88052.1 1873463 g22714 i0 49 0.462264150943396 49 24 45.3 1 244 101 172 220 HWE88052.1 MFS transporter [Pseudonocardiaceae bacterium] diamond 147 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae   Pseudonocardiaceae bacterium
27750817 27750817 PRJNA893346_P_NODE_33624_length_251_cov_0.865169_g33134_i0 PRJNA893346 33624 251 0.865169 2.17157419 Thermoleophilia bacterium 2026888 Bacteria Bacteria 53.9 4.32e-6   NR MBK5232827.1 2026888 g33134 i0 35.4 2.85657370517928 79 49 92 1 19 249 51 129 MBK5232827.1 SDR family oxidoreductase [Thermoleophilia bacterium] diamond 717 53.9 1 Bacteria   Bacillati Actinomycetota Thermoleophilia       Thermoleophilia bacterium
28287145 28287145 PRJNA893346_P_NODE_37406_length_245_cov_0.895349_g36916_i0 PRJNA893346 37406 245 0.895349 2.19360505 Umezawaea sp. 1955258 Bacteria Bacteria 42.7 0.0373   NR MEO6083571.1 1955258 g36916 i0 39.3 0.685714285714286 56 33 68.6 1 40 207 53 107 MEO6083571.1 helix-turn-helix transcriptional regulator [Umezawaea sp.] diamond 168 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Umezawaea Umezawaea sp.
28760833 28760833 PRJNA893346_P_NODE_22427_length_324_cov_1.227092_g21938_i0 PRJNA893346 22427 324 1.227092 3.97577808 Streptomyces sp. NBC_ 1931 Bacteria Bacteria 43.5 0.0463   NR WP_266849106.1 2975779 g21938 i0 39.4 0.611111111111111 66 35 56.5 1 214 32 28 93 WP_266849106.1 hypothetical protein [Streptomyces sp. NBC_00568] diamond 198 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_00568
29455194 29455194 PRJNA893346_P_NODE_33130_length_251_cov_1.662921_g32640_i0 PRJNA893346 33130 251 1.662921 4.17393171 Corynebacterium urealyticum 43771 Bacteria Bacteria 92 1.44e-19   NR PZO97195.1 43771 g32640 i0 48.8 0.9800796812749 82 42 98 0 249 4 322 403 PZO97195.1 MAG: hypothetical protein DI609_13745 [Corynebacterium urealyticum] diamond 246 92 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium urealyticum
29486932 29486932 PRJNA893346_P_NODE_19270_length_351_cov_1.733813_g18781_i0 PRJNA893346 19270 351 1.733813 6.08568363 Leifsonia kafniensis 475957 Bacteria Bacteria 159 1.4899999999999999e-47   NR WP_345065631.1 475957 g18781 i0 66.1 4.86324786324786 115 38 98.3 1 351 7 31 144 WP_345065631.1 RbsD/FucU family protein [Leifsonia kafniensis] diamond 1707 159 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia kafniensis
29644615 29644615 PRJNA893346_P_NODE_33710_length_251_cov_0.865169_g33220_i0 PRJNA893346 33710 251 0.865169 2.17157419 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 43.1 0.0257   NR HMS87165.1 2201156 g33220 i0 44.8 0.693227091633466 58 26 62.2 1 214 59 2 59 HMS87165.1 EAL domain-containing protein [Acidimicrobiales bacterium] diamond 174 43.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
29739467 29739467 PRJNA893346_P_NODE_34230_length_250_cov_0.870056_g33740_i0 PRJNA893346 34230 250 0.870056 2.17514 Actinokineospora pegani 2654637 Bacteria Bacteria 41.6 0.0277   NR WP_156754508.1 2654637 g33740 i0 35.9 0.768 64 40 76.8 1 231 40 23 85 WP_156754508.1 DUF1416 domain-containing protein [Actinokineospora pegani] diamond 192 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinokineospora Actinokineospora pegani
29929409 29929409 PRJNA893346_P_NODE_20771_length_338_cov_1.509434_g20282_i0 PRJNA893346 20771 338 1.509434 5.10188692 Mycobacterium sp. 1785 Bacteria Bacteria 151 2.45e-41   NR WP_324397568.1 1785 g20282 i0 68.2 0.949704142011834 107 34 95 0 17 337 1 107 WP_324397568.1 hypothetical protein, partial [Mycobacterium sp.] diamond 321 151 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
30024199 30024199 PRJNA893346_P_NODE_18811_length_356_cov_1.494700_g18322_i0 PRJNA893346 18811 356 1.4947 5.321132 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 43.9 0.0493   NR MEA2250029.1 2586742 g18322 i0 39.1 0.581460674157303 69 34 56.5 2 249 49 358 420 MEA2250029.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 207 43.9 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
30118666 30118666 PRJNA893346_P_NODE_19412_length_350_cov_1.111913_g18923_i0 PRJNA893346 19412 350 1.111913 3.8916955 Streptomyces 1883 Bacteria Bacteria 122 2.1e-32   NR WP_070014991.1 1883 g18923 i0 54.4 0.977142857142857 114 49 96 2 5 340 60 172 WP_070014991.1 MULTISPECIES: TerD family protein [Streptomyces] diamond 342 122 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
30277120 30277120 PRJNA893346_P_NODE_16752_length_379_cov_1.003268_g16264_i0 PRJNA893346 16752 379 1.003268 3.80238572 Actinomadura hibisca 68565 Bacteria Bacteria 92 7.88e-19   NR WP_067484158.1 68565 g16264 i0 43.8 1.57519788918206 105 58 83.1 1 329 15 24 127 WP_067484158.1 M28 family metallopeptidase [Actinomadura hibisca] diamond 597 92 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura hibisca
30466667 30466667 PRJNA893346_P_NODE_31073_length_264_cov_2.706806_g30583_i0 PRJNA893346 31073 264 2.706806 7.14596784 Nonomuraea sp. NPDC 1883105 Bacteria Bacteria 59.7 5.05e-8   NR WP_357978922.1 3157168 g30583 i0 42.9 1.93181818181818 84 34 95.5 1 258 7 59 128 WP_357978922.1 S8 family peptidase, partial [Nonomuraea sp. NPDC005692] diamond 510 59.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea sp. NPDC005692
31888771 31888771 PRJNA893346_P_NODE_18137_length_363_cov_1.841379_g17648_i0 PRJNA893346 18137 363 1.841379 6.68420577 Streptomyces mirabilis 68239 Bacteria Bacteria 47.8 0.00162   NR WP_388417723.1 68239 g17648 i0 32.6 0.710743801652893 86 53 71.1 1 39 296 32 112 WP_388417723.1 hypothetical protein [Streptomyces mirabilis] diamond 258 47.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces mirabilis
32110410 32110410 PRJNA893346_P_NODE_21058_length_336_cov_1.136882_g20569_i0 PRJNA893346 21058 336 1.136882 3.81992352 Actinocrinis sp. 1920516 Bacteria Bacteria 52.8 3.33e-5   NR HEU5331573.1 1920516 g20569 i0 41.4 0.625 70 40 62.5 1 335 126 364 432 HEU5331573.1 class IV lanthionine synthetase LanL [Actinocrinis sp.] diamond 210 52.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Actinospicaceae Actinocrinis Actinocrinis sp.
32149891 32149891 PRJNA893346_P_NODE_20078_length_344_cov_1.136531_g19589_i0 PRJNA893346 20078 344 1.136531 3.90966664 Bacteria 2 Bacteria Bacteria 50.4 8.76e-5   NR MCY7299568.1 2497619 g19589 i0 43.5 1.50872093023256 85 41 72.4 2 291 43 1 80 MCY7299568.1 fasciclin domain-containing protein [Ilumatobacteraceae bacterium] diamond 519 50.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae 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);;