RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA436017 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
1705689 1705689 PRJNA436017_P_NODE_24702_length_164_cov_1.464567_g24404_i0 PRJNA436017 24702 164 1.464567 2.40188988 FCB group 1783270 Bacteria Bacteria 79 1.42e-15   NR MFT4043533.1 84139 g24404 i0 70.4 27.6585365853659 54 12 98.8 1 1 162 28 77 MFT4043533.1 NAD(P)-dependent alcohol dehydrogenase [Gordonia sp. (in: high G+C Gram-positive bacteria)] diamond 4536 79 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia Gordonia sp. (in: high G+C Gram-positive bacteria)
9358748 9358748 PRJNA436017_P_NODE_13328_length_230_cov_1.212435_g13030_i0 PRJNA436017 13328 230 1.212435 2.7886005 Streptomyces sp. NBC_ 1931 Bacteria Bacteria 63.2 2.03e-9   NR WP_329314370.1 2903803 g13030 i0 45.2 0.952173913043478 73 32 95.2 2 230 12 456 520 WP_329314370.1 non-ribosomal peptide synthetase [Streptomyces sp. NBC_01262] diamond 219 63.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_01262
26822826 26822826 PRJNA436017_P_NODE_23021_length_170_cov_1.436090_g22723_i0 PRJNA436017 23021 170 1.43609 2.441353 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 80.9 4.71e-16   NR MDH3192791.1 2080302 g22723 i0 70 0.882352941176471 50 15 88.2 0 169 20 48 97 MDH3192791.1 nitronate monooxygenase [Acidimicrobiia bacterium] diamond 150 80.9 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
27265571 27265571 PRJNA436017_P_NODE_22143_length_174_cov_0.963504_g21845_i0 PRJNA436017 22143 174 0.963504 1.67649696 Streptomyces griseocarneus 51201 Bacteria Bacteria 51.2 1.6e-6   NR RLU73210.1 51201 g21845 i0 60 0.689655172413793 40 16 69 0 140 21 4 43 RLU73210.1 hypothetical protein CTZ27_39075 [Streptomyces griseocarneus] diamond 120 51.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces griseocarneus
27297106 27297106 PRJNA436017_P_NODE_4183_length_452_cov_3.510843_g3892_i0 PRJNA436017 4183 452 3.510843 15.86901036 Rathayibacter sp. YIM 13335 1891630 Bacteria Bacteria 88.2 3e-17   NR WP_337852133.1 3131992 g3892 i0 34.8 0.935840707964602 141 84 90.9 3 415 5 3 139 WP_337852133.1 hypothetical protein [Rathayibacter sp. YIM 133350] diamond 423 88.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rathayibacter Rathayibacter sp. YIM 133350
27360475 27360475 PRJNA436017_P_NODE_18463_length_191_cov_0.987013_g18165_i0 PRJNA436017 18463 191 0.987013 1.88519483 Terrabacter terrae 318434 Bacteria Bacteria 112 7.84e-28   NR WP_343990150.1 318434 g18165 i0 81 0.989528795811518 63 12 99 0 190 2 263 325 WP_343990150.1 adenine-specific methyltransferase EcoRI family protein [Terrabacter terrae] diamond 189 112 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Terrabacter Terrabacter terrae
28086419 28086419 PRJNA436017_P_NODE_11745_length_248_cov_3.483412_g11447_i0 PRJNA436017 11745 248 3.483412 8.63886176 Solirubrobacterales bacterium 1909295 Bacteria Bacteria 42.4 0.0478   NR HEX2393313.1 1909295 g11447 i0 39.6 0.641129032258065 53 32 64.1 0 192 34 13 65 HEX2393313.1 hypothetical protein [Solirubrobacterales bacterium] diamond 159 42.4 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales     Solirubrobacterales bacterium
28686712 28686712 PRJNA436017_P_NODE_15567_length_210_cov_0.959538_g15269_i0 PRJNA436017 15567 210 0.959538 2.0150298 Kitasatospora sp. NPDC 1871188 Bacteria Bacteria 42 0.0468   NR WP_355669325.1 3154555 g15269 i0 45.1 0.728571428571429 51 22 67.1 2 70 210 96 144 WP_355669325.1 asparagine synthase-related protein [Kitasatospora sp. NPDC004669] diamond 153 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Kitasatospora Kitasatospora sp. NPDC004669
28907206 28907206 PRJNA436017_P_NODE_17108_length_199_cov_0.944444_g16810_i0 PRJNA436017 17108 199 0.944444 1.87944356 Coriobacteriia bacterium 2052159 Bacteria Bacteria 42 0.0174   NR MDZ4065179.1 2052159 g16810 i0 43.4 1.59798994974874 53 26 78.4 2 179 24 84 133 MDZ4065179.1 O-antigen ligase family protein [Coriobacteriia bacterium] diamond 318 42 1 Bacteria   Bacillati Actinomycetota Coriobacteriia       Coriobacteriia bacterium
29160305 29160305 PRJNA436017_P_NODE_24789_length_164_cov_1.196850_g24491_i0 PRJNA436017 24789 164 1.19685 1.962834 Gaiellaceae bacterium 2838783 Bacteria Bacteria 41.2 0.045   NR HUK96426.1 2838783 g24491 i0 40.4 0.951219512195122 52 27 95.1 2 9 164 287 334 HUK96426.1 hypothetical protein [Gaiellaceae bacterium] diamond 156 41.2 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
29428838 29428838 PRJNA436017_P_NODE_28949_length_152_cov_1.008696_g28651_i0 PRJNA436017 28949 152 1.008696 1.53321792 Bacteria 2 Bacteria Bacteria 62.8 9.05e-10   NR MBC8421290.1 2900548 g28651 i0 60.4 2.84210526315789 48 19 94.7 0 145 2 165 212 MBC8421290.1 HAD-IC family P-type ATPase [Actinomycetota bacterium] diamond 432 62.8 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30233809 30233809 PRJNA436017_P_NODE_5452_length_388_cov_1.484330_g5156_i0 PRJNA436017 5452 388 1.48433 5.7592004 Rubrobacteraceae bacterium 2740537 Bacteria Bacteria 44.7 0.0376   NR HSL00257.1 2740537 g5156 i0 28 0.912371134020619 118 77 88.9 2 351 7 410 522 HSL00257.1 diguanylate cyclase [Rubrobacteraceae bacterium] diamond 354 44.7 1 Bacteria   Bacillati Actinomycetota Rubrobacteria Rubrobacterales Rubrobacteraceae   Rubrobacteraceae bacterium
32257554 32257554 PRJNA436017_P_NODE_19218_length_187_cov_0.973333_g18920_i0 PRJNA436017 19218 187 0.973333 1.82013271 Thermopolyspora flexuosa 103836 Bacteria Bacteria 39.7 0.0483   NR WP_142259851.1 103836 g18920 i0 42.9 0.786096256684492 49 28 78.6 0 166 20 15 63 WP_142259851.1 hypothetical protein [Thermopolyspora flexuosa] diamond 147 39.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Thermopolyspora Thermopolyspora flexuosa
32273841 32273841 PRJNA436017_P_NODE_26698_length_158_cov_1.256198_g26400_i0 PRJNA436017 26698 158 1.256198 1.98479284 Actinomycetes 1760 Bacteria Bacteria 40.4 0.00891   NR GHG58069.1 285351 g26400 i0 47.5 1.51898734177215 40 21 75.9 0 127 8 8 47 GHG58069.1 hypothetical protein GCM10011331_26630 [Flavimobilis marinus] diamond 240 40.8 0.990196078431373 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Jonesiaceae Flavimobilis Flavimobilis marinus
32542202 32542202 PRJNA436017_P_NODE_15979_length_206_cov_2.248521_g15681_i0 PRJNA436017 15979 206 2.248521 4.63195326 Streptomyces tricolor 68277 Bacteria Bacteria 49.7 8.02e-5   NR MCE0445246.1 68277 g15681 i0 46 0.728155339805825 50 23 67 1 189 52 207 256 MCE0445246.1 MFS transporter [Streptomyces tricolor] diamond 150 49.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces tricolor
32605090 32605090 PRJNA436017_P_NODE_4940_length_411_cov_2.526738_g4644_i0 PRJNA436017 4940 411 2.526738 10.38489318 Herbiconiux ginsengi 381665 Bacteria Bacteria 58.5 6.24e-7   NR WP_139256756.1 381665 g4644 i0 29.1 0.978102189781022 134 95 97.8 0 3 404 264 397 WP_139256756.1 hypothetical protein [Herbiconiux ginsengi] diamond 402 58.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Herbiconiux Herbiconiux ginsengi

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