RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB12237 · 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
1294897 1294897 PRJEB12237_P_NODE_2362_length_460_cov_2.762353_g2166_i0 PRJEB12237 2362 460 2.762353 12.7068238 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 212 1.24e-67   NR MCP3885490.1 2021380 g2166 i0 72 0.932608695652174 143 40 93.3 0 429 1 3 145 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 429 212 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
6398795 6398795 PRJEB12237_P_NODE_1486_length_592_cov_5.269300_g1311_i0 PRJEB12237 1486 592 5.2693 31.194256 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 218 1.7499999999999998e-69   NR MCP3885490.1 2021380 g1311 i0 71.1 0.755067567567568 149 43 75.5 0 562 116 3 151 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 447 218 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
27096145 27096145 PRJEB12237_P_NODE_3442_length_358_cov_2.167183_g3246_i0 PRJEB12237 3442 358 2.167183 7.75851514 Actinomycetes bacterium 1883427 Bacteria Bacteria 131 1.25e-35   NR MEI6230221.1 1883427 g3246 i0 62.6 0.829608938547486 99 37 83 0 54 350 1 99 MEI6230221.1 NAD(P)H-dependent oxidoreductase [Actinomycetes bacterium] diamond 297 131 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
27254120 27254120 PRJEB12237_P_NODE_4863_length_281_cov_2.630081_g4667_i0 PRJEB12237 4863 281 2.630081 7.39052761 Salinibacterium hongtaonis 2079791 Bacteria Bacteria 43.1 0.0417   NR WP_108518238.1 2079791 g4667 i0 51.1 0.480427046263345 45 20 45.9 2 169 41 205 249 WP_108518238.1 MmgE/PrpD family protein [Salinibacterium hongtaonis] diamond 135 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Homoserinimonas Homoserinimonas hongtaonis
27538642 27538642 PRJEB12237_P_NODE_11884_length_152_cov_1.367521_g11688_i0 PRJEB12237 11884 152 1.367521 2.07863192 Streptomyces monomycini 371720 Bacteria Bacteria 63.5 4.86e-10   NR WP_238783068.1 371720 g11688 i0 61.7 5.72368421052632 47 18 92.8 0 8 148 131 177 WP_238783068.1 NHL repeat-containing protein [Streptomyces monomycini] diamond 870 63.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces monomycini
27885838 27885838 PRJEB12237_P_NODE_6725_length_220_cov_1.945946_g6529_i0 PRJEB12237 6725 220 1.945946 4.2810812 Actinomycetota bacterium 2900548 Bacteria Bacteria 70.5 9.61e-13   NR MEY2634385.1 2900548 g6529 i0 69.6 0.763636363636364 56 17 76.4 0 2 169 153 208 MEY2634385.1 hypothetical protein [Actinomycetota bacterium] diamond 168 70.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28138717 28138717 PRJEB12237_P_NODE_5565_length_253_cov_1.426606_g5369_i0 PRJEB12237 5565 253 1.426606 3.60931318 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 45.8 0.00134   NR MBX9717869.1 1873462 g5369 i0 43.9 0.486166007905138 41 23 48.6 0 123 1 40 80 MBX9717869.1 hypothetical protein [Microbacteriaceae bacterium] diamond 123 45.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
28422844 28422844 PRJEB12237_P_NODE_2426_length_452_cov_1.645084_g2230_i0 PRJEB12237 2426 452 1.645084 7.43577968 Coriobacteriales bacterium 2478480 Bacteria Bacteria 55.5 1.25e-5   NR MDR0500822.1 2478480 g2230 i0 33 1.06858407079646 100 55 58.4 3 452 189 277 376 MDR0500822.1 RICIN domain-containing protein [Coriobacteriales bacterium] diamond 483 55.5 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales     Coriobacteriales bacterium
28454402 28454402 PRJEB12237_P_NODE_6686_length_221_cov_1.505376_g6490_i0 PRJEB12237 6686 221 1.505376 3.32688096 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 42 0.0491   NR HEX9539934.1 2339230 g6490 i0 50 0.624434389140271 46 20 62.4 1 35 172 213 255 HEX9539934.1 hypothetical protein [Streptosporangiaceae bacterium] diamond 138 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
28833046 28833046 PRJEB12237_P_NODE_9148_length_179_cov_1.104167_g8952_i0 PRJEB12237 9148 179 1.104167 1.97645893 Thermobifida halotolerans 483545 Bacteria Bacteria 41.6 0.038   NR WP_068693089.1 483545 g8952 i0 38.6 0.955307262569832 57 34 93.9 1 3 170 132 188 WP_068693089.1 HAD family hydrolase [Thermobifida halotolerans] diamond 171 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Nocardiopsidaceae Thermobifida Thermobifida halotolerans
29338340 29338340 PRJEB12237_P_NODE_5249_length_264_cov_5.148472_g5053_i0 PRJEB12237 5249 264 5.148472 13.59196608 Actinomycetota bacterium 2900548 Bacteria Bacteria 91.3 1.64e-20   NR MBC7464176.1 2900548 g5053 i0 56 1.88636363636364 84 37 95.5 0 1 252 124 207 MBC7464176.1 NAD(P)H-dependent oxidoreductase [Actinomycetota bacterium] diamond 498 91.3 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29401429 29401429 PRJEB12237_P_NODE_8989_length_181_cov_1.095890_g8793_i0 PRJEB12237 8989 181 1.09589 1.9835609 Actinomycetota bacterium 2900548 Bacteria Bacteria 54.7 1e-6   NR MBS1889663.1 2900548 g8793 i0 42.6 1.01104972375691 61 34 99.4 1 2 181 812 872 MBS1889663.1 hypothetical protein [Actinomycetota bacterium] diamond 183 54.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30286193 30286193 PRJEB12237_P_NODE_10592_length_163_cov_1.171875_g10396_i0 PRJEB12237 10592 163 1.171875 1.91015625 Glycomyces niveus 2820287 Bacteria Bacteria 53.5 6.34e-7   NR WP_208495685.1 2820287 g10396 i0 47.1 0.938650306748466 51 25 93.9 1 11 163 49 97 WP_208495685.1 VOC family protein [Glycomyces niveus] diamond 153 53.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Glycomycetales Glycomycetaceae Glycomyces Glycomyces niveus
30286201 30286201 PRJEB12237_P_NODE_8492_length_188_cov_1.006536_g8296_i0 PRJEB12237 8492 188 1.006536 1.89228768 Rarobacter faecitabidus 13243 Bacteria Bacteria 69.7 4.2e-12   NR WP_142119636.1 13243 g8296 i0 46.8 3.84574468085106 62 33 98.9 0 186 1 268 329 WP_142119636.1 quinone oxidoreductase family protein [Rarobacter faecitabidus] diamond 723 69.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Rarobacteraceae Rarobacter Rarobacter faecitabidus
30759769 30759769 PRJEB12237_P_NODE_594_length_927_cov_2.841928_g486_i0 PRJEB12237 594 927 2.841928 26.34467256 Actinomycetota bacterium 2900548 Bacteria Bacteria 188 4.4699999999999985e-55   NR MEN9305899.1 2900548 g486 i0 45.9 1.2977346278317199 205 111 66.3 0 849 235 4 208 MEN9305899.1 hypothetical protein [Actinomycetota bacterium] diamond 1203 188 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31233470 31233470 PRJEB12237_P_NODE_7175_length_210_cov_2.742857_g6979_i0 PRJEB12237 7175 210 2.742857 5.7599997 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 54.3 1.89e-6   NR HEY3828221.1 2586742 g6979 i0 49.1 0.814285714285714 57 28 81.4 1 17 187 250 305 HEY3828221.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 171 54.3 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
31328500 31328500 PRJEB12237_P_NODE_10176_length_167_cov_1.060606_g9980_i0 PRJEB12237 10176 167 1.060606 1.77121202 Trebonia sp. 2767075 Bacteria Bacteria 44.3 0.003   NR HEX4830140.1 2767075 g9980 i0 42.6 0.970059880239521 54 29 97 1 1 162 146 197 HEX4830140.1 hypothetical protein [Trebonia sp.] diamond 162 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Treboniaceae Trebonia Trebonia sp.
31455145 31455145 PRJEB12237_P_NODE_7516_length_203_cov_1.958333_g7320_i0 PRJEB12237 7516 203 1.958333 3.97541599 Pseudonocardiaceae bacterium 1873463 Bacteria Bacteria 39.7 0.0463   NR MFL6150680.1 1873463 g7320 i0 41.3 0.679802955665025 46 27 68 0 152 15 21 66 MFL6150680.1 helix-turn-helix domain-containing protein [Pseudonocardiaceae bacterium] diamond 138 39.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae   Pseudonocardiaceae bacterium
31802840 31802840 PRJEB12237_P_NODE_8717_length_184_cov_1.731544_g8521_i0 PRJEB12237 8717 184 1.731544 3.18604096 Actinomycetota bacterium 2900548 Bacteria Bacteria 74.3 1.16e-13   NR MBI2169477.1 2900548 g8521 i0 86 2.78804347826087 43 6 70.1 0 175 47 8 50 MBI2169477.1 bifunctional 3,4-dihydroxy-2-butanone-4-phosphate synthase/GTP cyclohydrolase II [Actinomycetota bacterium] diamond 513 74.3 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
32087734 32087734 PRJEB12237_P_NODE_1778_length_539_cov_3.712302_g1594_i0 PRJEB12237 1778 539 3.712302 20.00930778 Coriobacteriales bacterium 2478480 Bacteria Bacteria 58.2 3.16e-6   NR MDR2196367.1 2478480 g1594 i0 31 0.862708719851577 155 104 85.7 2 519 58 143 295 MDR2196367.1 RICIN domain-containing protein [Coriobacteriales bacterium] diamond 465 58.2 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales     Coriobacteriales bacterium
32782590 32782590 PRJEB12237_P_NODE_10960_length_159_cov_2.830645_g10764_i0 PRJEB12237 10960 159 2.830645 4.50072555 Actinomycetota bacterium 2900548 Bacteria Bacteria 41.6 0.0283   NR MEA3075191.1 2900548 g10764 i0 51.4 0.69811320754717 37 18 69.8 0 127 17 152 188 MEA3075191.1 hypothetical protein [Actinomycetota bacterium] diamond 111 41.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
32814235 32814235 PRJEB12237_P_NODE_10440_length_164_cov_1.240310_g10244_i0 PRJEB12237 10440 164 1.24031 2.0341084 Collinsella aerofaciens 74426 Bacteria Bacteria 40 0.0323   NR WP_373570406.1 74426 g10244 i0 37.5 0.878048780487805 48 29 86 1 20 160 1 48 WP_373570406.1 hypothetical protein [Collinsella aerofaciens] diamond 144 40 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales Coriobacteriaceae Collinsella Collinsella aerofaciens

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