RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA588137" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA588137 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
2413951 2413951 PRJNA588137_S_NODE_9822_length_244_cov_0.888889_g9789_i0 PRJNA588137 9822 244 0.888889 2.16888916 Herbiconiux sp. 1871186 Bacteria Bacteria 134 7.6e-37   NR WP_291038116.1 1871186 g9789 i0 86.4 0.995901639344262 81 11 99.6 0 2 244 18 98 WP_291038116.1 SDR family NAD(P)-dependent oxidoreductase [Herbiconiux sp.] diamond 243 134 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Herbiconiux Herbiconiux sp.
5668508 5668508 PRJNA588137_S_NODE_7205_length_249_cov_0.875000_g7172_i0 PRJNA588137 7205 249 0.875 2.17875 Microbacterium yannicii 671622 Bacteria Bacteria 88.6 1.22e-18   NR WP_026059843.1 671622 g7172 i0 89.6 2.31325301204819 48 5 57.8 0 249 106 297 344 WP_026059843.1 NAD(P)-dependent alcohol dehydrogenase [Microbacterium yannicii] diamond 576 88.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium yannicii
8217986 8217986 PRJNA588137_S_NODE_8247_length_247_cov_0.885057_g8214_i0 PRJNA588137 8247 247 0.885057 2.18609079 Propionibacterium sp. 1977903 Bacteria Bacteria 75.9 3.14e-14   NR NMD46780.1 1977903 g8214 i0 97.3 0.449392712550607 37 1 44.9 0 113 3 1 37 NMD46780.1 hypothetical protein [Propionibacterium sp.] diamond 111 75.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Propionibacterium Propionibacterium sp.
24790959 24790959 PRJNA588137_S_NODE_8760_length_246_cov_0.890173_g8727_i0 PRJNA588137 8760 246 0.890173 2.18982558 Lawsonella clevelandensis 1528099 Bacteria Bacteria 122 1.26e-31   NR WP_237025130.1 1528099 g8727 i0 85.3 0.914634146341463 75 11 91.5 0 225 1 1 75 WP_237025130.1 class II fructose-bisphosphatase [Lawsonella clevelandensis] diamond 225 122 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
27205844 27205844 PRJNA588137_S_NODE_8262_length_247_cov_0.885057_g8229_i0 PRJNA588137 8262 247 0.885057 2.18609079 Solirubrobacterales bacterium 1909295 Bacteria Bacteria 64.7 5.03e-10   NR MBN8869093.1 1909295 g8229 i0 56.9 0.619433198380567 51 22 61.9 0 153 1 1 51 MBN8869093.1 PD40 domain-containing protein [Solirubrobacterales bacterium] diamond 153 64.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales     Solirubrobacterales bacterium
27869209 27869209 PRJNA588137_S_NODE_9725_length_244_cov_0.900585_g9692_i0 PRJNA588137 9725 244 0.900585 2.1974274 Lawsonella 1847725 Bacteria Bacteria 125 3.28e-33   NR WP_290598695.1 1847725 g9692 i0 100 0.786885245901639 64 0 78.7 0 193 2 1 64 WP_290598695.1 MULTISPECIES: universal stress protein [Lawsonella] diamond 192 125 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
28153738 28153738 PRJNA588137_S_NODE_3305_length_311_cov_1.739496_g3272_i0 PRJNA588137 3305 311 1.739496 5.40983256 Streptomyces lunaelactis 1535768 Bacteria Bacteria 167 5.24e-51   NR WP_175314560.1 1535768 g3272 i0 95.1 0.993569131832797 103 5 99.4 0 3 311 8 110 WP_175314560.1 hypothetical protein, partial [Streptomyces lunaelactis] diamond 309 167 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces lunaelactis
29321701 29321701 PRJNA588137_S_NODE_5549_length_263_cov_1.315789_g5516_i0 PRJNA588137 5549 263 1.315789 3.46052507 Actinacidiphila cocklensis 887465 Bacteria Bacteria 57.8 7.88e-9   NR CAG6391361.1 887465 g5516 i0 57.8 0.513307984790874 45 19 51.3 0 202 68 18 62 CAG6391361.1 hypothetical protein SCOCK_1180002 [Actinacidiphila cocklensis] diamond 135 57.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Actinacidiphila Actinacidiphila cocklensis
29668704 29668704 PRJNA588137_S_NODE_6770_length_250_cov_1.259887_g6737_i0 PRJNA588137 6770 250 1.259887 3.1497175 Pseudonocardia sp. H11422 2835866 Bacteria Bacteria 126 3.5e-32   NR WP_214368640.1 2835866 g6737 i0 78.3 0.996 83 18 99.6 0 249 1 220 302 WP_214368640.1 HAMP domain-containing sensor histidine kinase [Pseudonocardia sp. H11422] diamond 249 126 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia sp. H11422
30427673 30427673 PRJNA588137_S_NODE_6873_length_250_cov_0.870056_g6840_i0 PRJNA588137 6873 250 0.870056 2.17514 Amycolatopsis azurea 36819 Bacteria Bacteria 80.9 5.66e-18   NR WP_005155815.1 36819 g6840 i0 94.7 1.824 38 2 45.6 0 27 140 39 76 WP_005155815.1 DUF2188 domain-containing protein [Amycolatopsis azurea] diamond 456 80.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis azurea
31976199 31976199 PRJNA588137_S_NODE_10838_length_242_cov_0.857988_g10805_i0 PRJNA588137 10838 242 0.857988 2.07633096 Mycolicibacterium frederiksbergense 117567 Bacteria Bacteria 147 8.399999999999998e-44   NR MBX9921123.1 117567 g10805 i0 100 1.98347107438017 80 0 99.2 0 2 241 48 127 MBX9921123.1 diol dehydratase reactivase [Mycolicibacterium frederiksbergense] diamond 480 147 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium frederiksbergense
32356241 32356241 PRJNA588137_S_NODE_7439_length_249_cov_0.875000_g7406_i0 PRJNA588137 7439 249 0.875 2.17875 Nakamurella silvestris 1645681 Bacteria Bacteria 83.2 6.87e-17   NR RIJ70718.1 1645681 g7406 i0 55.1 1.66265060240964 69 31 83.1 0 249 43 134 202 RIJ70718.1 permease [Nakamurella silvestris] diamond 414 83.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Nakamurellales Nakamurellaceae Nakamurella Nakamurella silvestris
32608910 32608910 PRJNA588137_S_NODE_7380_length_249_cov_0.875000_g7347_i0 PRJNA588137 7380 249 0.875 2.17875 Amnibacterium kyonggiense 595671 Bacteria Bacteria 96.7 3.76e-21   NR WP_133767622.1 595671 g7347 i0 53.1 1.96385542168675 81 38 97.6 0 246 4 388 468 WP_133767622.1 ArnT family glycosyltransferase [Amnibacterium kyonggiense] diamond 489 96.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Amnibacterium Amnibacterium kyonggiense
32640113 32640113 PRJNA588137_S_NODE_7440_length_249_cov_0.875000_g7407_i0 PRJNA588137 7440 249 0.875 2.17875 Lawsonella 1847725 Bacteria Bacteria 177 3.13e-50   NR WP_290595468.1 1847725 g7407 i0 100 0.987951807228916 82 0 98.8 0 3 248 507 588 WP_290595468.1 MULTISPECIES: maltotransferase domain-containing protein [Lawsonella] diamond 246 177 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  

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