RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA804229" 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

  • PRJNA804229 · 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
26714506 26714506 PRJNA804229_S_NODE_103841_length_200_cov_1.222930_g102883_i0 PRJNA804229 103841 200 1.22293 2.44586 root 1 Root_unresolved Root_unresolved 50.8 2.64e-6   NR MES6786315.1 1747 g102883 i0 58.8 1.515 51 19 76.5 2 42 194 35 83 MES6786315.1 hypothetical protein [Cutibacterium acnes] diamond 303 50.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
27275469 27275469 PRJNA804229_S_NODE_147783_length_168_cov_1.152000_g146825_i0 PRJNA804229 147783 168 1.152 1.93536 Streptomyces sp. 1931 Bacteria Bacteria 46.6 5.73e-4   NR WP_415940400.1 2789263 g146825 i0 76.7 0.535714285714286 30 7 53.6 0 128 39 130 159 WP_415940400.1 endonuclease/exonuclease/phosphatase family protein, partial [Streptomyces sp. 039-1] diamond 90 46.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. 039-1
27496637 27496637 PRJNA804229_S_NODE_154883_length_164_cov_1.190083_g153925_i0 PRJNA804229 154883 164 1.190083 1.95173612 Gleimia hominis 595468 Bacteria Bacteria 43.5 0.00693   NR WP_146003059.1 595468 g153925 i0 37.3 1.07926829268293 59 21 78.7 1 147 19 358 416 WP_146003059.1 glycosyltransferase [Gleimia hominis] diamond 177 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Gleimia Gleimia hominis
27591467 27591467 PRJNA804229_S_NODE_79784_length_228_cov_1.037838_g78826_i0 PRJNA804229 79784 228 1.037838 2.36627064 Mycobacterium tuberculosis variant bovis 1765 Bacteria Bacteria 40.4 0.0322   NR OPF78998.1 1765 g78826 i0 34.7 0.644736842105263 49 32 64.5 0 150 4 19 67 OPF78998.1 hypothetical protein BXP24_21485, partial [Mycobacterium tuberculosis variant bovis] diamond 147 40.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
27686346 27686346 PRJNA804229_S_NODE_151124_length_166_cov_1.170732_g150166_i0 PRJNA804229 151124 166 1.170732 1.94341512 Kocuria sp. 1871328 Bacteria Bacteria 42 0.0235   NR WP_303177222.1 1871328 g150166 i0 32.1 1.01204819277108 56 30 86.7 1 146 3 84 139 WP_303177222.1 MBL fold metallo-hydrolase [Kocuria sp.] diamond 168 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria sp.
27821335 27821335 PRJNA804229_S_NODE_40984_length_307_cov_2.106061_g40026_i0 PRJNA804229 40984 307 2.106061 6.46560727 Bacillati 1783272 Bacteria Bacteria 120 4.89e-31   NR PYC99595.1 57043 g40026 i0 67.4 1.85667752442997 95 31 92.8 0 23 307 127 221 PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum] diamond 570 120 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
27947500 27947500 PRJNA804229_S_NODE_160745_length_161_cov_1.169492_g159787_i0 PRJNA804229 160745 161 1.169492 1.88288212 root 1 Root_unresolved Root_unresolved 62 2.34e-10   NR MES9109313.1 1747 g159787 i0 60.4 8.90683229813665 53 20 96.9 1 3 158 43 95 MES9109313.1 hypothetical protein [Cutibacterium acnes] diamond 1434 62 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
28168512 28168512 PRJNA804229_S_NODE_152385_length_165_cov_1.573770_g151427_i0 PRJNA804229 152385 165 1.57377 2.5967205 root 1 Root_unresolved Root_unresolved 44.7 0.00266   NR MES8310468.1 1747 g151427 i0 61.1 2.07272727272727 36 13 63.6 1 21 125 367 402 MES8310468.1 hypothetical protein [Cutibacterium acnes] diamond 342 45.1 0.991130820399113 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
28199844 28199844 PRJNA804229_S_NODE_105286_length_198_cov_3.477419_g104328_i0 PRJNA804229 105286 198 3.477419 6.88528962 Bacillati 1783272 Bacteria Bacteria 126 9.13e-34   NR PYC99595.1 57043 g104328 i0 96.6 1.75757575757576 58 2 87.9 0 174 1 47 104 PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum] diamond 348 126 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
28799722 28799722 PRJNA804229_S_NODE_136247_length_175_cov_1.090909_g135289_i0 PRJNA804229 136247 175 1.090909 1.90909075 Bacillati 1783272 Bacteria Bacteria 80.1 3.38e-16   NR PYC99595.1 57043 g135289 i0 62.1 1.98857142857143 58 22 99.4 0 1 174 66 123 PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum] diamond 348 80.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
28980723 28980723 PRJNA804229_S_NODE_63528_length_254_cov_1.137441_g62570_i0 PRJNA804229 63528 254 1.137441 2.88910014 Microbacterium esteraromaticum 57043 Bacteria Bacteria 131 7.579999999999999e-37   NR PYC99674.1 57043 g62570 i0 100 0.68503937007874 58 0 68.5 0 3 176 113 170 PYC99674.1 hypothetical protein B4U78_015025 [Microbacterium esteraromaticum] diamond 174 131 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
30157592 30157592 PRJNA804229_S_NODE_178872_length_153_cov_0.872727_g177914_i0 PRJNA804229 178872 153 0.872727 1.33527231 Bacillati 1783272 Bacteria Bacteria 96.3 1.35e-24   NR PYC99652.1 57043 g177914 i0 94 1.96078431372549 50 3 98 0 152 3 9 58 PYC99652.1 hypothetical protein B4U78_015305 [Microbacterium esteraromaticum] diamond 300 96.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
30180446 30180446 PRJNA804229_S_NODE_113772_length_191_cov_1.621622_g112814_i0 PRJNA804229 113772 191 1.621622 3.09729802 Gaiellaceae bacterium 2838783 Bacteria Bacteria 41.2 0.0433   NR HXV33145.1 2838783 g112814 i0 51.4 0.581151832460733 37 18 58.1 0 50 160 100 136 HXV33145.1 tetratricopeptide repeat protein [Gaiellaceae bacterium] diamond 111 41.2 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
30654353 30654353 PRJNA804229_S_NODE_110293_length_194_cov_1.589404_g109335_i0 PRJNA804229 110293 194 1.589404 3.08344376 Cutibacterium acnes 1747 Bacteria Bacteria 53.9 7.39e-7   NR MES8137701.1 1747 g109335 i0 57.1 0.541237113402062 35 15 54.1 0 8 112 111 145 MES8137701.1 hypothetical protein [Cutibacterium acnes] diamond 105 53.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
30726468 30726468 PRJNA804229_S_NODE_53154_length_275_cov_1.366379_g52196_i0 PRJNA804229 53154 275 1.366379 3.75754225 Actinomycetota 201174 Bacteria Bacteria 43.1 0.0378   NR HEY7437989.1 2080302 g52196 i0 35.5 1.89818181818182 93 30 77.5 4 223 11 263 347 HEY7437989.1 glutaconate CoA-transferase [Acidimicrobiia bacterium] diamond 522 43.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
31760861 31760861 PRJNA804229_S_NODE_143537_length_170_cov_1.889764_g142579_i0 PRJNA804229 143537 170 1.889764 3.2125988 Lentzea waywayandensis 84724 Bacteria Bacteria 41.2 0.0488   NR WP_177320475.1 84724 g142579 i0 46.2 0.688235294117647 39 19 68.8 1 156 40 197 233 WP_177320475.1 DUF418 domain-containing protein [Lentzea waywayandensis] diamond 117 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Lentzea Lentzea waywayandensis
32749712 32749712 PRJNA804229_S_NODE_151140_length_166_cov_1.170732_g150182_i0 PRJNA804229 151140 166 1.170732 1.94341512 root 1 Root_unresolved Root_unresolved 55.5 1.04e-7   NR MES7066515.1 1747 g150182 i0 72.7 3 33 9 59.6 0 67 165 109 141 MES7066515.1 reverse transcriptase domain-containing protein [Cutibacterium acnes] diamond 498 55.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes

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);;