RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA407087" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA407087 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
14443867 14443867 PRJNA407087_S_NODE_2112_length_452_cov_17.460993_g1653_i0 PRJNA407087 2112 452 17.460993 78.92368836 Bacteria 2 Bacteria Bacteria 204 7.94e-64   NR WP_357328706.1 58117 g1653 i0 70.7 47.5287610619469 140 37 92.9 2 452 33 67 202 WP_357328706.1 adenosylhomocysteinase, partial [Microbispora rosea] diamond 21483 206 0.990291262135922 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Microbispora Microbispora rosea
26695482 26695482 PRJNA407087_S_NODE_3001_length_353_cov_9.033951_g2539_i0 PRJNA407087 3001 353 9.033951 31.88984703 Frankiales bacterium 1909291 Bacteria Bacteria 46.6 0.00553   NR MCW2600036.1 1909291 g2539 i0 29.7 0.943342776203966 111 69 89.2 3 347 33 31 138 MCW2600036.1 hypothetical protein [Frankiales bacterium] diamond 333 46.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales     Frankiales bacterium
27043834 27043834 PRJNA407087_S_NODE_6942_length_187_cov_2.063291_g6479_i0 PRJNA407087 6942 187 2.063291 3.85835417 Candidatus Geothermincolales bacterium 2952926 Bacteria Bacteria 91.3 3.83e-20   NR MEJ5185983.1 2952926 g6479 i0 59.7 0.994652406417112 62 25 99.5 0 186 1 100 161 MEJ5185983.1 SDR family oxidoreductase [Candidatus Geothermincolales bacterium] diamond 186 91.3 1 Bacteria   Bacillati Actinomycetota Candidatus Geothermincolia Candidatus Geothermincolales     Candidatus Geothermincolales bacterium
27503094 27503094 PRJNA407087_S_NODE_5043_length_233_cov_2.176471_g4580_i0 PRJNA407087 5043 233 2.176471 5.07117743 Bacteria 2 Bacteria Bacteria 81.6 5.83e-16   NR WP_074506636.1 1718 g4580 i0 58.5 2.51072961373391 65 27 83.7 0 2 196 388 452 WP_074506636.1 NAD-dependent succinate-semialdehyde dehydrogenase [Corynebacterium glutamicum] diamond 585 81.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium glutamicum
28180640 28180640 PRJNA407087_S_NODE_2246_length_432_cov_4.325062_g1785_i0 PRJNA407087 2246 432 4.325062 18.68426784 Mycobacterium numidiamassiliense 1841861 Bacteria Bacteria 124 1.18e-30   NR WP_217348935.1 1841861 g1785 i0 44.9 0.958333333333333 138 75 95.8 1 431 18 284 420 WP_217348935.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Mycobacterium numidiamassiliense] diamond 414 124 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium numidiamassiliense
28717731 28717731 PRJNA407087_S_NODE_1307_length_613_cov_5.852740_g159_i5 PRJNA407087 1307 613 5.85274 35.8772962 Actinomycetota bacterium 2900548 Bacteria Bacteria 62 1.47e-7   NR MDQ6686043.1 2900548 g159 i5 27.3 0.68026101141925 139 90 67.5 3 435 22 3 131 MDQ6686043.1 kelch repeat-containing protein [Actinomycetota bacterium] diamond 417 62 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29176559 29176559 PRJNA407087_S_NODE_809_length_822_cov_4.986129_g517_i0 PRJNA407087 809 822 4.986129 40.98598038 Streptomyces 1883 Bacteria Bacteria 47.8 0.0365   NR WP_030929278.1 1476876 g517 i0 26 1.31021897810219 181 120 61.3 4 107 610 245 424 WP_030929278.1 FG-GAP-like repeat-containing protein [Streptomyces sp. NRRL B-24720] diamond 1077 47.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NRRL B-24720
29317482 29317482 PRJNA407087_S_NODE_2749_length_376_cov_8.132565_g2287_i0 PRJNA407087 2749 376 8.132565 30.5784444 Actinomycetota bacterium 2900548 Bacteria Bacteria 130 1.0099999999999999e-32   NR MBS1889662.1 2900548 g2287 i0 50 1.97872340425532 124 56 98.9 1 1 372 5 122 MBS1889662.1 ubiquitin-conjugating enzyme E2 [Actinomycetota bacterium] diamond 744 130 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29570014 29570014 PRJNA407087_S_NODE_270_length_1485_cov_7.292582_g159_i1 PRJNA407087 270 1485 7.292582 108.2948427 Actinomycetota bacterium 2900548 Bacteria Bacteria 70.1 3.35e-9   NR MDQ6686043.1 2900548 g159 i1 27 0.381818181818182 189 124 38 4 179 742 3 178 MDQ6686043.1 kelch repeat-containing protein [Actinomycetota bacterium] diamond 567 70.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30012415 30012415 PRJNA407087_S_NODE_5151_length_229_cov_5.055000_g4688_i0 PRJNA407087 5151 229 5.055 11.57595 Coriobacteriales bacterium 2478480 Bacteria Bacteria 54.3 1.23e-7   NR MBQ6453435.1 2478480 g4688 i0 55.3 0.615720524017467 47 21 61.6 0 141 1 9 55 MBQ6453435.1 hypothetical protein [Coriobacteriales bacterium] diamond 141 54.3 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales     Coriobacteriales bacterium
30328739 30328739 PRJNA407087_S_NODE_5312_length_223_cov_3.530928_g4849_i0 PRJNA407087 5312 223 3.530928 7.87396944 Solwaraspora sp. WMMA2 1912063 Bacteria Bacteria 42.4 0.0379   NR WP_289210000.1 3015161 g4849 i0 47.6 0.565022421524664 42 19 56.5 1 207 82 245 283 WP_289210000.1 ABC transporter permease [Solwaraspora sp. WMMA2056] diamond 126 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Solwaraspora Solwaraspora sp. WMMA2056
30423349 30423349 PRJNA407087_S_NODE_8333_length_166_cov_3.744526_g7870_i0 PRJNA407087 8333 166 3.744526 6.21591316 Actinomycetota bacterium 2900548 Bacteria Bacteria 46.2 8.01e-4   NR MBS1889663.1 2900548 g7870 i0 41.1 1.01204819277108 56 32 99.4 1 166 2 803 858 MBS1889663.1 hypothetical protein [Actinomycetota bacterium] diamond 168 46.2 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30597524 30597524 PRJNA407087_S_NODE_7553_length_177_cov_2.979730_g7090_i0 PRJNA407087 7553 177 2.97973 5.2741221 Actinomycetota 201174 Bacteria Bacteria 87.4 2.01e-19   NR MDH3539199.1 2080302 g7090 i0 61 3.94915254237288 59 23 100 0 177 1 87 145 MDH3539199.1 SDR family NAD(P)-dependent oxidoreductase [Acidimicrobiia bacterium] diamond 699 87.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
30833733 30833733 PRJNA407087_S_NODE_6494_length_195_cov_4.415663_g6031_i0 PRJNA407087 6494 195 4.415663 8.61054285 Geodermatophilus sp. 52020 Bacteria Bacteria 57 3.05e-8   NR HZH22794.1 52020 g6031 i0 50 7.83076923076923 64 21 96.9 2 193 5 82 135 HZH22794.1 DEAD/DEAH box helicase [Geodermatophilus sp.] diamond 1527 57 1 Bacteria   Bacillati Actinomycetota Actinomycetes Geodermatophilales Geodermatophilaceae Geodermatophilus Geodermatophilus sp.
31180957 31180957 PRJNA407087_S_NODE_4595_length_250_cov_4.049774_g4132_i0 PRJNA407087 4595 250 4.049774 10.124435 Actinomycetota bacterium 2900548 Bacteria Bacteria 48.5 3.66e-4   NR MBS1889663.1 2900548 g4132 i0 40.6 1.812 69 40 82.8 1 3 209 681 748 MBS1889663.1 hypothetical protein [Actinomycetota bacterium] diamond 453 48.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31497716 31497716 PRJNA407087_S_NODE_3736_length_293_cov_3.784091_g3273_i0 PRJNA407087 3736 293 3.784091 11.08738663 Streptomyces montanisoli 2798581 Bacteria Bacteria 53.9 8.03e-6   NR WP_209344675.1 2798581 g3273 i0 38.1 0.645051194539249 63 39 64.5 0 190 2 162 224 WP_209344675.1 aminopeptidase N [Streptomyces montanisoli] diamond 189 53.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces montanisoli
32193603 32193603 PRJNA407087_S_NODE_9518_length_154_cov_3.616000_g9055_i0 PRJNA407087 9518 154 3.616 5.56864 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 52.8 3.14e-6   NR HZL48270.1 2586742 g9055 i0 57.1 6.19480519480519 49 16 87.7 2 139 5 211 258 HZL48270.1 malate dehydrogenase [Solirubrobacteraceae bacterium] diamond 954 52.8 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
32257162 32257162 PRJNA407087_S_NODE_5338_length_222_cov_4.761658_g4875_i0 PRJNA407087 5338 222 4.761658 10.57088076 Rugosimonospora sp. 3069596 Bacteria Bacteria 75.1 1.15e-13   NR HEY2673232.1 3069596 g4875 i0 48.5 4.60810810810811 68 35 91.9 0 222 19 205 272 HEY2673232.1 aminopeptidase N [Rugosimonospora sp.] diamond 1023 75.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Rugosimonospora Rugosimonospora sp.
32415139 32415139 PRJNA407087_S_NODE_4759_length_243_cov_5.485981_g4296_i0 PRJNA407087 4759 243 5.485981 13.33093383 Micromonospora sp. KC6 1876 Bacteria Bacteria 74.3 2.68e-13   NR WP_132182642.1 2530379 g4296 i0 44 2.67901234567901 75 42 92.6 0 241 17 194 268 WP_132182642.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Micromonospora sp. KC606] diamond 651 74.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Micromonospora Micromonospora sp. KC606
32431813 32431813 PRJNA407087_S_NODE_4099_length_273_cov_3.463115_g3636_i0 PRJNA407087 4099 273 3.463115 9.45430395 Mycobacteriales 85007 Bacteria Bacteria 43.5 0.00976   NR WP_325613105.1 1785 g3636 i0 43.9 1.14285714285714 41 23 45.1 0 110 232 87 127 WP_325613105.1 hypothetical protein [Mycobacterium sp.] diamond 312 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.

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