RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1108487" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1108487 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
26972723 26972723 PRJNA1108487_P_NODE_5222_length_310_cov_0.877637_g5156_i0 PRJNA1108487 5222 310 0.877637 2.7206747 Nocardioides sp. Soil8 35761 Bacteria Bacteria 43.5 0.0455   NR WP_156411716.1 1736416 g5156 i0 40.6 0.619354838709677 64 36 60 2 310 125 92 155 WP_156411716.1 M36 family metallopeptidase [Nocardioides sp. Soil805] diamond 192 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp. Soil805
27004352 27004352 PRJNA1108487_P_NODE_6462_length_282_cov_2.229665_g6396_i0 PRJNA1108487 6462 282 2.229665 6.2876553 Actinomycetota bacterium 2900548 Bacteria Bacteria 47 0.002   NR MEI8126507.1 2900548 g6396 i0 55 0.425531914893617 40 17 41.5 1 145 29 5505 5544 MEI8126507.1 fibronectin type III domain-containing protein [Actinomycetota bacterium] diamond 120 47 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27036104 27036104 PRJNA1108487_P_NODE_6782_length_277_cov_0.931373_g6716_i0 PRJNA1108487 6782 277 0.931373 2.57990321 Streptomyces lydicus 47763 Bacteria Bacteria 41.6 0.0202   NR WP_129295673.1 47763 g6716 i0 42.6 0.996389891696751 47 24 50.9 1 58 198 14 57 WP_129295673.1 DUF397 domain-containing protein [Streptomyces lydicus] diamond 276 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces lydicus
27099272 27099272 PRJNA1108487_P_NODE_3162_length_383_cov_1.509677_g3096_i0 PRJNA1108487 3162 383 1.509677 5.78206291 Amycolatopsis sp. NPDC 37632 Bacteria Bacteria 44.7 0.0337   NR WP_395889824.1 3363936 g3096 i0 31.1 0.932114882506527 119 69 90.9 4 23 370 150 258 WP_395889824.1 dihydrolipoyl dehydrogenase family protein [Amycolatopsis sp. NPDC051903] diamond 357 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis sp. NPDC051903
27099279 27099279 PRJNA1108487_P_NODE_8042_length_257_cov_1.271739_g7976_i0 PRJNA1108487 8042 257 1.271739 3.26836923 Actinomycetota bacterium 2900548 Bacteria Bacteria 140 8.86e-41   NR MBS1889789.1 2900548 g7976 i0 77.6 0.992217898832685 85 19 99.2 0 1 255 21 105 MBS1889789.1 hypothetical protein [Actinomycetota bacterium] diamond 255 140 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27194033 27194033 PRJNA1108487_P_NODE_11122_length_242_cov_1.846154_g11056_i0 PRJNA1108487 11122 242 1.846154 4.46769268 Pseudonocardia sp. 60912 Bacteria Bacteria 42.4 0.0494   NR MDN5934016.1 60912 g11056 i0 49 0.607438016528926 49 23 58.3 1 3 143 405 453 MDN5934016.1 AAA family ATPase [Pseudonocardia sp.] diamond 147 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia sp.
27447198 27447198 PRJNA1108487_P_NODE_5123_length_312_cov_1.305439_g5057_i0 PRJNA1108487 5123 312 1.305439 4.07296968 Actinomycetales bacterium 1911520 Bacteria Bacteria 109 2.81e-27   NR MCP4741343.1 1911520 g5057 i0 56.4 1.95192307692308 101 44 97.1 0 1 303 34 134 MCP4741343.1 FMN-dependent NADH-azoreductase [Actinomycetales bacterium] diamond 609 109 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales     Actinomycetales bacterium
27573252 27573252 PRJNA1108487_P_NODE_9784_length_247_cov_1.793103_g9718_i0 PRJNA1108487 9784 247 1.793103 4.42896441 Actinomycetes bacterium 1883427 Bacteria Bacteria 83.2 1.49e-17   NR MEI6294978.1 1883427 g9718 i0 46.9 1.96761133603239 81 43 98.4 0 245 3 16 96 MEI6294978.1 NAD(P)H-dependent oxidoreductase [Actinomycetes bacterium] diamond 486 83.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
27825951 27825951 PRJNA1108487_P_NODE_10684_length_244_cov_0.912281_g10618_i0 PRJNA1108487 10684 244 0.912281 2.22596564 Mycobacterium sp. IDR2 1785 Bacteria Bacteria 51.2 3.81e-5   NR WP_238888805.1 2867005 g10618 i0 35.6 0.725409836065574 59 37 71.3 1 17 190 9 67 WP_238888805.1 hypothetical protein [Mycobacterium sp. IDR2000157661] diamond 177 51.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp. IDR2000157661
27888882 27888882 PRJNA1108487_P_NODE_10245_length_246_cov_0.901734_g10179_i0 PRJNA1108487 10245 246 0.901734 2.21826564 Thermoleophilaceae bacterium 2732252 Bacteria Bacteria 45.4 0.00299   NR HZC14358.1 2732252 g10179 i0 44.2 0.634146341463415 52 26 59.8 1 57 203 127 178 HZC14358.1 hypothetical protein [Thermoleophilaceae bacterium] diamond 156 45.4 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Thermoleophilales Thermoleophilaceae   Thermoleophilaceae bacterium
27983662 27983662 PRJNA1108487_P_NODE_3685_length_358_cov_1.687719_g3619_i0 PRJNA1108487 3685 358 1.687719 6.04203402 Jatrophihabitans sp. 1932789 Bacteria Bacteria 44.7 0.0254   NR HEY2044222.1 1932789 g3619 i0 46.4 0.578212290502793 69 31 57.8 2 2 208 68 130 HEY2044222.1 porphobilinogen synthase [Jatrophihabitans sp.] diamond 207 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Jatrophihabitantales Jatrophihabitantaceae Jatrophihabitans Jatrophihabitans sp.
28046841 28046841 PRJNA1108487_P_NODE_725_length_759_cov_1.373178_g666_i0 PRJNA1108487 725 759 1.373178 10.42242102 Streptomyces showdoensis 68268 Bacteria Bacteria 50.1 0.00602   NR GAA2810065.1 68268 g666 i0 37.1 0.458498023715415 116 48 36 2 509 237 654 769 GAA2810065.1 excinuclease ABC subunit UvrA [Streptomyces showdoensis] diamond 348 50.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces showdoensis
28330954 28330954 PRJNA1108487_P_NODE_6366_length_285_cov_1.103774_g6300_i0 PRJNA1108487 6366 285 1.103774 3.1457559 Actinomycetota bacterium 2900548 Bacteria Bacteria 87.4 1.1e-17   NR MCL4418116.1 2900548 g6300 i0 72.6 0.652631578947368 62 17 65.3 0 284 99 201 262 MCL4418116.1 hypothetical protein [Actinomycetota bacterium] diamond 186 87.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28385433 28385433 PRJNA1108487_P_NODE_5146_length_311_cov_2.142857_g5080_i0 PRJNA1108487 5146 311 2.142857 6.66428527 Bacillati 1783272 Bacteria Bacteria 71.6 2.67e-12   NR HEY5245432.1 2201156 g5080 i0 56.4 3.32797427652733 55 23 53.1 1 143 307 28 81 HEY5245432.1 C39 family peptidase [Acidimicrobiales bacterium] diamond 1035 71.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
29057345 29057345 PRJNA1108487_P_NODE_9988_length_247_cov_0.896552_g9922_i0 PRJNA1108487 9988 247 0.896552 2.21448344 Phytohabitans aurantiacus 3016789 Bacteria Bacteria 42.7 0.0393   NR WP_407676941.1 3016789 g9922 i0 63.9 0.437246963562753 36 11 42.5 2 90 194 869 903 WP_407676941.1 caspase, EACC1-associated type [Phytohabitans aurantiacus] diamond 108 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Phytohabitans Phytohabitans aurantiacus
29088877 29088877 PRJNA1108487_P_NODE_6048_length_291_cov_1.243119_g5982_i0 PRJNA1108487 6048 291 1.243119 3.61747629 Micropruina sp. 2737536 Bacteria Bacteria 46.6 0.00252   NR WP_415108310.1 2737536 g5982 i0 39 1.22680412371134 59 36 60.8 0 104 280 6 64 WP_415108310.1 hypothetical protein [Micropruina sp.] diamond 357 46.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Micropruina Micropruina sp.
29215312 29215312 PRJNA1108487_P_NODE_11169_length_242_cov_0.923077_g11103_i0 PRJNA1108487 11169 242 0.923077 2.23384634 Actinomycetota bacterium 2900548 Bacteria Bacteria 92.8 4.51e-20   NR MBS1890115.1 2900548 g11103 i0 57.3 0.929752066115702 75 28 90.5 2 4 222 317 389 MBS1890115.1 hypothetical protein [Actinomycetota bacterium] diamond 225 92.8 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29656743 29656743 PRJNA1108487_P_NODE_7470_length_265_cov_1.625000_g7404_i0 PRJNA1108487 7470 265 1.625 4.30625 Actinomycetota bacterium 2900548 Bacteria Bacteria 85.1 5.87e-18   NR NDA81105.1 2900548 g7404 i0 51.2 4.4377358490566 82 39 92.8 1 20 265 2 82 NDA81105.1 NAD(P)-dependent alcohol dehydrogenase [Actinomycetota bacterium] diamond 1176 85.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29878317 29878317 PRJNA1108487_P_NODE_4851_length_319_cov_1.268293_g4785_i0 PRJNA1108487 4851 319 1.268293 4.04585467 unclassified Streptomyces 2593676 Bacteria Bacteria 43.9 0.0238   NR WP_365919296.1 2593676 g4785 i0 45.1 0.959247648902821 51 24 44.2 1 153 13 131 181 WP_365919296.1 MULTISPECIES: hypothetical protein [unclassified Streptomyces] diamond 306 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
30036183 30036183 PRJNA1108487_P_NODE_9371_length_249_cov_0.886364_g9305_i0 PRJNA1108487 9371 249 0.886364 2.20704636 Conexibacter sp. 1929289 Bacteria Bacteria 76.6 4.48e-14   NR MCW2952570.1 1929289 g9305 i0 47.6 0.987951807228916 82 40 98.8 2 247 2 222 300 MCW2952570.1 hypothetical protein [Conexibacter sp.] diamond 246 76.6 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Conexibacteraceae Conexibacter Conexibacter sp.
30067669 30067669 PRJNA1108487_P_NODE_9192_length_250_cov_0.881356_g9126_i0 PRJNA1108487 9192 250 0.881356 2.20339 Actinomycetota bacterium 2900548 Bacteria Bacteria 42.7 0.0218   NR MCA1681748.1 2900548 g9126 i0 38.5 0.624 52 32 62.4 0 60 215 73 124 MCA1681748.1 hypothetical protein [Actinomycetota bacterium] diamond 156 42.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30153521 30153521 PRJNA1108487_P_NODE_8832_length_251_cov_0.876404_g8766_i0 PRJNA1108487 8832 251 0.876404 2.19977404 root 1 Root_unresolved Root_unresolved 107 7.92e-26   NR MFC2646340.1 2047 g8766 i0 67.5 26.7250996015936 83 25 99.2 1 3 251 167 247 MFC2646340.1 FGGY family carbohydrate kinase [Rothia dentocariosa] diamond 6708 108 0.990740740740741 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Rothia Rothia dentocariosa
31006877 31006877 PRJNA1108487_P_NODE_6534_length_281_cov_1.125000_g6468_i0 PRJNA1108487 6534 281 1.125 3.16125 Myceligenerans 253183 Bacteria Bacteria 61.2 1.78e-8   NR WP_242637001.1 1230528 g6468 i0 36.6 2.58362989323843 82 51 86.5 1 38 280 45 126 WP_242637001.1 family 43 glycosylhydrolase [Myceligenerans salitolerans] diamond 726 61.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Promicromonosporaceae Myceligenerans Myceligenerans salitolerans
31078924 31078924 PRJNA1108487_P_NODE_3475_length_367_cov_1.591837_g3409_i0 PRJNA1108487 3475 367 1.591837 5.84204179 Actinomycetota bacterium 2900548 Bacteria Bacteria 73.6 3.71e-13   NR MEN9305899.1 2900548 g3409 i0 67.2 0.956403269754768 58 19 47.4 0 353 180 150 207 MEN9305899.1 hypothetical protein [Actinomycetota bacterium] diamond 351 73.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31458340 31458340 PRJNA1108487_P_NODE_6416_length_283_cov_2.628571_g6350_i0 PRJNA1108487 6416 283 2.628571 7.43885593 Euzebya sp. 1971409 Bacteria Bacteria 42.7 0.038   NR HUG86549.1 1971409 g6350 i0 55.3 0.402826855123675 38 17 40.3 0 282 169 137 174 HUG86549.1 ATP synthase F1 subunit delta [Euzebya sp.] diamond 114 42.7 1 Bacteria   Bacillati Actinomycetota Nitriliruptoria Euzebyales Euzebyaceae Euzebya Euzebya sp.
31553343 31553343 PRJNA1108487_P_NODE_7496_length_265_cov_1.322917_g7430_i0 PRJNA1108487 7496 265 1.322917 3.50573005 Streptomyces sp. NPDC 1931 Bacteria Bacteria 43.1 0.0355   NR WP_366480223.1 3154643 g7430 i0 38.3 0.679245283018868 60 35 67.9 1 255 76 474 531 WP_366480223.1 transporter [Streptomyces sp. NPDC051211] diamond 180 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC051211
31616311 31616311 PRJNA1108487_P_NODE_11316_length_242_cov_0.923077_g11250_i0 PRJNA1108487 11316 242 0.923077 2.23384634 Pseudonocardiaceae bacterium 1873463 Bacteria Bacteria 43.5 0.0196   NR MQA10140.1 1873463 g11250 i0 35.5 0.768595041322314 62 39 75.6 1 21 203 128 189 MQA10140.1 GMC family oxidoreductase [Pseudonocardiaceae bacterium] diamond 186 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae   Pseudonocardiaceae bacterium
31774407 31774407 PRJNA1108487_P_NODE_9917_length_247_cov_0.896552_g9851_i0 PRJNA1108487 9917 247 0.896552 2.21448344 Streptosporangiaceae bacterium NEAU-GS5 2820291 Bacteria Bacteria 42.7 0.037   NR MBO3749174.1 2820291 g9851 i0 53.3 0.364372469635628 30 14 36.4 0 203 114 16 45 MBO3749174.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Streptosporangiaceae bacterium NEAU-GS5] diamond 90 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium NEAU-GS5

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