RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA283169 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
27263894 27263894 PRJNA283169_P_NODE_7763_length_163_cov_0.912281_g7700_i0 PRJNA283169 7763 163 0.912281 1.48701803 Streptomyces sp. B1866 3075431 Bacteria Bacteria 41.2 0.0446   NR MDT3397371.1 3075431 g7700 i0 47.4 0.699386503067485 38 20 69.9 0 43 156 10 47 MDT3397371.1 hypothetical protein [Streptomyces sp. B1866] diamond 114 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. B1866
27502754 27502754 PRJNA283169_S_NODE_3343_length_163_cov_0.192982_g3329_i0 PRJNA283169 3343 163 0.192982 0.31456066 Actinomycetota 201174 Bacteria Bacteria 83.6 4.59e-17   NR HTK66606.1 60912 g3329 i0 71.7 16.5828220858896 53 15 97.5 0 161 3 75 127 HTK66606.1 adenylosuccinate lyase [Pseudonocardia sp.] diamond 2703 84 0.995238095238095 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia sp.
27516480 27516480 PRJNA283169_P_NODE_1843_length_301_cov_0.952381_g1781_i0 PRJNA283169 1843 301 0.952381 2.86666681 Kineosporiaceae bacterium 2487580 Bacteria Bacteria 145 2.64e-38   NR HST86542.1 2487580 g1781 i0 67.7 0.98671096345515 99 32 98.7 0 1 297 478 576 HST86542.1 ABC transporter family substrate-binding protein [Kineosporiaceae bacterium] diamond 297 145 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kineosporiales Kineosporiaceae   Kineosporiaceae bacterium
27800789 27800789 PRJNA283169_P_NODE_2004_length_288_cov_1.560669_g1942_i0 PRJNA283169 2004 288 1.560669 4.49472672 Streptomyces sp. NPDC 1931 Bacteria Bacteria 66.2 4.03e-11   NR WP_352219457.1 3155541 g1942 i0 72.2 0.375 36 10 37.5 0 2 109 70 105 WP_352219457.1 HNH endonuclease signature motif containing protein [Streptomyces sp. NPDC096040] diamond 108 66.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC096040
28053161 28053161 PRJNA283169_S_NODE_2805_length_173_cov_0.161290_g2791_i0 PRJNA283169 2805 173 0.16129 0.2790317 Aurantimicrobium minutum 708131 Bacteria Bacteria 96.7 1.35e-21   NR WP_231951849.1 708131 g2791 i0 86 0.988439306358382 57 8 98.8 0 171 1 33 89 WP_231951849.1 arginine--tRNA ligase [Aurantimicrobium minutum] diamond 171 96.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aurantimicrobium Aurantimicrobium minutum
28432176 28432176 PRJNA283169_P_NODE_3646_length_217_cov_1.714286_g3583_i0 PRJNA283169 3646 217 1.714286 3.72000062 unclassified Streptomyces 2593676 Bacteria Bacteria 42 0.05   NR WP_328480840.1 2593676 g3583 i0 35.6 0.815668202764977 59 37 80.2 1 31 204 335 393 WP_328480840.1 MULTISPECIES: PLP-dependent aminotransferase family protein [unclassified Streptomyces] diamond 177 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
28463856 28463856 PRJNA283169_P_NODE_2326_length_270_cov_1.113122_g2264_i0 PRJNA283169 2326 270 1.113122 3.0054294 Solirubrobacterales bacterium 1909295 Bacteria Bacteria 77 8.89e-15   NR HYQ12160.1 1909295 g2264 i0 58.9 0.622222222222222 56 23 62.2 0 267 100 138 193 HYQ12160.1 glycosyltransferase [Solirubrobacterales bacterium] diamond 168 77 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales     Solirubrobacterales bacterium
28463864 28463864 PRJNA283169_S_NODE_2066_length_197_cov_0.108108_g2052_i0 PRJNA283169 2066 197 0.108108 0.21297276 Saccharomonospora iraqiensis 52698 Bacteria Bacteria 63.9 2.78e-10   NR WP_026453052.1 52698 g2052 i0 48.4 1.7817258883248701 64 30 97.5 1 194 3 66 126 WP_026453052.1 HD domain-containing protein [Saccharomonospora iraqiensis] diamond 351 63.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Saccharomonospora Saccharomonospora iraqiensis
28653217 28653217 PRJNA283169_S_NODE_1267_length_241_cov_0.140625_g1253_i0 PRJNA283169 1267 241 0.140625 0.33890625 Streptosporangium longisporum 46187 Bacteria Bacteria 49.3 7.39e-5   NR WP_344902011.1 46187 g1253 i0 55.6 1.07053941908714 27 12 33.6 0 145 225 136 162 WP_344902011.1 hypothetical protein [Streptosporangium longisporum] diamond 258 49.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Streptosporangium Streptosporangium longisporum
29207751 29207751 PRJNA283169_S_NODE_1509_length_223_cov_0.120690_g1495_i0 PRJNA283169 1509 223 0.12069 0.2691387 FCB group 1783270 Bacteria Bacteria 75.1 2.8e-14   NR TDZ92141.1 404941 g1495 i0 54.8 5.3677130044843 62 28 83.4 0 21 206 2 63 TDZ92141.1 hypothetical protein CCUG60885_04255 [Mycobacteroides salmoniphilum] diamond 1197 75.5 0.994701986754967 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacteroides Mycobacteroides salmoniphilum
29537193 29537193 PRJNA283169_P_NODE_7050_length_166_cov_0.880342_g6987_i0 PRJNA283169 7050 166 0.880342 1.46136772 Kineosporiaceae bacterium 2487580 Bacteria Bacteria 100 2.2099999999999994e-23   NR HST82854.1 2487580 g6987 i0 90.7 0.975903614457831 54 5 97.6 0 164 3 109 162 HST82854.1 ATP-dependent DNA ligase [Kineosporiaceae bacterium] diamond 162 100 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kineosporiales Kineosporiaceae   Kineosporiaceae bacterium
29758125 29758125 PRJNA283169_P_NODE_1831_length_301_cov_2.515873_g1769_i0 PRJNA283169 1831 301 2.515873 7.57277773 Actinomycetes bacterium 1883427 Bacteria Bacteria 58.9 1.46e-7   NR MEI7452779.1 1883427 g1769 i0 39.8 1.07641196013289 108 49 96.7 4 7 297 134 236 MEI7452779.1 hypothetical protein [Actinomycetes bacterium] diamond 324 58.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
30755345 30755345 PRJNA283169_P_NODE_7614_length_164_cov_0.886957_g7551_i0 PRJNA283169 7614 164 0.886957 1.45460948 Conyzicola 1648520 Bacteria Bacteria 84.3 2.14e-17   NR WP_246376073.1 1172621 g7551 i0 93.2 7.75609756097561 44 3 80.5 0 163 32 89 132 WP_246376073.1 molybdopterin-dependent oxidoreductase [Conyzicola lurida] diamond 1272 84.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Conyzicola Conyzicola lurida
31147948 31147948 PRJNA283169_S_NODE_3155_length_166_cov_0.059829_g3141_i0 PRJNA283169 3155 166 0.059829 0.09931614 Gryllotalpicola protaetiae 2419771 Bacteria Bacteria 50.4 8.74e-6   NR WP_162939969.1 2419771 g3141 i0 52.5 1.51807228915663 40 19 72.3 0 136 17 63 102 WP_162939969.1 hypothetical protein [Gryllotalpicola protaetiae] diamond 252 50.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Gryllotalpicola Gryllotalpicola protaetiae
31274782 31274782 PRJNA283169_P_NODE_7115_length_166_cov_0.863248_g7052_i0 PRJNA283169 7115 166 0.863248 1.43299168 Actinomycetota bacterium 2900548 Bacteria Bacteria 67.8 1.86e-11   NR MFM1954457.1 2900548 g7052 i0 72.2 0.975903614457831 54 14 95.8 1 161 3 519 572 MFM1954457.1 hypothetical protein [Actinomycetota bacterium] diamond 162 67.8 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31355891 31355891 PRJNA283169_S_NODE_1776_length_209_cov_0.068750_g1762_i0 PRJNA283169 1776 209 0.06875 0.1436875 root 1 Root_unresolved Root_unresolved 53.1 4.83e-6   NR WP_324092479.1 1931995 g1762 i0 47.4 0.990430622009569 38 20 54.5 0 6 119 294 331 WP_324092479.1 hypothetical protein [Glutamicibacter sp.] diamond 207 53.5 0.992523364485981 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Glutamicibacter Glutamicibacter sp.
31482563 31482563 PRJNA283169_P_NODE_4796_length_194_cov_1.213793_g4733_i0 PRJNA283169 4796 194 1.213793 2.35475842 Bacteria 2 Bacteria Bacteria 127 9.639999999999999e-34   NR GDX21024.1 1883427 g4733 i0 90.6 4.94845360824742 64 6 99 0 3 194 176 239 GDX21024.1 phosphotransferase [Actinomycetes bacterium] diamond 960 127 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
31591300 31591300 PRJNA283169_P_NODE_2556_length_258_cov_1.430622_g2494_i0 PRJNA283169 2556 258 1.430622 3.69100476 Actinomycetota bacterium 2900548 Bacteria Bacteria 156 2.27e-43   NR MEY4035285.1 2900548 g2494 i0 94.2 5 86 5 100 0 1 258 114 199 MEY4035285.1 hypothetical protein [Actinomycetota bacterium] diamond 1290 156 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
32034033 32034033 PRJNA283169_P_NODE_5638_length_180_cov_1.183206_g5575_i0 PRJNA283169 5638 180 1.183206 2.1297708 Actinacidiphila cocklensis 887465 Bacteria Bacteria 50.1 3.21e-6   NR CAG6391593.1 887465 g5575 i0 50 0.866666666666667 52 26 86.7 0 170 15 22 73 CAG6391593.1 hypothetical protein SCOCK_1230001 [Actinacidiphila cocklensis] diamond 156 50.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Actinacidiphila Actinacidiphila cocklensis
32160744 32160744 PRJNA283169_P_NODE_1858_length_299_cov_1.308000_g1796_i0 PRJNA283169 1858 299 1.308 3.91092 Microbacterium resistens 156977 Bacteria Bacteria 52 2.92e-5   NR WP_219085666.1 156977 g1796 i0 69 0.290969899665552 29 9 29.1 0 110 196 1 29 WP_219085666.1 DUF4326 domain-containing protein [Microbacterium resistens] diamond 87 52 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium resistens
32603371 32603371 PRJNA283169_P_NODE_3660_length_217_cov_1.214286_g3597_i0 PRJNA283169 3660 217 1.214286 2.63500062 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 62.4 1.29e-10   NR MDH3729554.1 2080302 g3597 i0 56.9 1.42396313364055 51 22 70.5 0 1 153 47 97 MDH3729554.1 hypothetical protein [Acidimicrobiia bacterium] diamond 309 62.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
32872749 32872749 PRJNA283169_P_NODE_8060_length_162_cov_0.920354_g7997_i0 PRJNA283169 8060 162 0.920354 1.49097348 root 1 Root_unresolved Root_unresolved 47 8.95e-5   NR MBQ9041451.1 1972561 g7997 i0 63.6 2.72222222222222 33 12 61.1 0 14 112 2 34 MBQ9041451.1 hypothetical protein [Eggerthellaceae bacterium] diamond 441 47 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Eggerthellales Eggerthellaceae   Eggerthellaceae 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);;