RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA188516" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA188516 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
1640601 1640601 PRJNA188516_P_NODE_4762_length_167_cov_0.881356_g4712_i0 PRJNA188516 4762 167 0.881356 1.47186452 Fodinicola acaciae 2681555 Bacteria Bacteria 68.2 3.27e-12   NR WP_163511905.1 2681555 g4712 i0 85.3 12.5209580838323 34 5 61.1 0 103 2 3 36 WP_163511905.1 superoxide dismutase [Fodinicola acaciae] diamond 2091 68.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales   Fodinicola Fodinicola acaciae
10569885 10569885 PRJNA188516_P_NODE_4329_length_168_cov_0.873950_g4279_i0 PRJNA188516 4329 168 0.87395 1.468236 Salinibacterium 235888 Bacteria Bacteria 84.3 3.04e-17   NR MBX3098140.1 1915057 g4279 i0 73.2 2 56 15 100 0 168 1 1482 1537 MBX3098140.1 tandem-95 repeat protein [Salinibacterium sp.] diamond 336 85.1 0.990599294947121 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Salinibacterium Salinibacterium sp.
16943083 16943083 PRJNA188516_P_NODE_4254_length_169_cov_0.866667_g4204_i0 PRJNA188516 4254 169 0.866667 1.46466723 Dietzia sp. PP-33 2957500 Bacteria Bacteria 86.3 1.11e-18   NR WP_319029531.1 2957500 g4204 i0 76.8 0.994082840236686 56 13 99.4 0 169 2 54 109 WP_319029531.1 ABC transporter ATP-binding protein [Dietzia sp. PP-33] diamond 168 86.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Dietziaceae Dietzia Dietzia sp. PP-33
23317934 23317934 PRJNA188516_P_NODE_4659_length_167_cov_0.881356_g4609_i0 PRJNA188516 4659 167 0.881356 1.47186452 Aquihabitans sp. 1872585 Bacteria Bacteria 92 3.33e-20   NR HEX2577778.1 1872585 g4609 i0 81.5 0.970059880239521 54 10 97 0 1 162 159 212 HEX2577778.1 cytochrome P450 [Aquihabitans sp.] diamond 162 92 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Iamiaceae Aquihabitans Aquihabitans sp.
26662124 26662124 PRJNA188516_P_NODE_5861_length_163_cov_0.903509_g5811_i0 PRJNA188516 5861 163 0.903509 1.47271967 Solirubrobacterales bacterium 1909295 Bacteria Bacteria 102 1.0199999999999999e-23   NR HTU16365.1 1909295 g5811 i0 94.4 0.993865030674847 54 3 99.4 0 162 1 83 136 HTU16365.1 DUF4147 domain-containing protein [Solirubrobacterales bacterium] diamond 162 102 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales     Solirubrobacterales bacterium
27231954 27231954 PRJNA188516_P_NODE_2423_length_220_cov_1.520468_g2373_i0 PRJNA188516 2423 220 1.520468 3.3450296 Rathayibacter iranicus 59737 Bacteria Bacteria 45.4 0.00305   NR WP_104265120.1 59737 g2373 i0 41.3 0.859090909090909 63 37 85.9 0 196 8 299 361 WP_104265120.1 galactokinase [Rathayibacter iranicus] diamond 189 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rathayibacter Rathayibacter iranicus
27231959 27231959 PRJNA188516_P_NODE_5803_length_163_cov_0.912281_g5753_i0 PRJNA188516 5803 163 0.912281 1.48701803 Mycobacterium bourgelatii 1273442 Bacteria Bacteria 103 1.3999999999999999e-24   NR WP_240355781.1 1273442 g5753 i0 85.2 2.98159509202454 54 8 99.4 0 163 2 122 175 WP_240355781.1 HNH endonuclease [Mycobacterium bourgelatii] diamond 486 103 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium bourgelatii
27326847 27326847 PRJNA188516_P_NODE_5163_length_165_cov_0.896552_g5113_i0 PRJNA188516 5163 165 0.896552 1.4793108 Raoultibacter massiliensis 1852371 Bacteria Bacteria 84.3 8.63e-18   NR WP_270856773.1 1852371 g5113 i0 100 1.41818181818182 39 0 70.9 0 3 119 261 299 WP_270856773.1 phosphotransferase [Raoultibacter massiliensis] diamond 234 84.3 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Eggerthellales Eggerthellaceae Raoultibacter Raoultibacter massiliensis
28702470 28702470 PRJNA188516_P_NODE_5507_length_164_cov_0.904348_g5457_i0 PRJNA188516 5507 164 0.904348 1.48313072 Actinomyces 1654 Bacteria Bacteria 110 1.51e-26   NR WP_234415299.1 2083009 g5457 i0 94.4 1.97560975609756 54 3 98.8 0 162 1 480 533 WP_234415299.1 NlpC/P60 family protein [Actinomyces sp. Marseille-P3109] diamond 324 111 0.990990990990991 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces sp. Marseille-P3109
29000664 29000664 PRJNA188516_P_NODE_5168_length_165_cov_0.896552_g5118_i0 PRJNA188516 5168 165 0.896552 1.4793108 Corynebacterium bovis 36808 Bacteria Bacteria 49.7 4.75e-5   NR WP_125186499.1 36808 g5118 i0 54.7 0.963636363636364 53 24 96.4 0 7 165 230 282 WP_125186499.1 hypothetical protein [Corynebacterium bovis] diamond 159 49.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium bovis
29095137 29095137 PRJNA188516_P_NODE_3888_length_172_cov_0.845528_g3838_i0 PRJNA188516 3888 172 0.845528 1.45430816 Streptomyces fumanus 67302 Bacteria Bacteria 41.2 0.0489   NR WP_351056515.1 67302 g3838 i0 51.3 0.680232558139535 39 17 68 1 51 167 331 367 WP_351056515.1 acetoin utilization protein AcuC [Streptomyces fumanus] diamond 117 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces fumanus
29302267 29302267 PRJNA188516_P_NODE_4449_length_168_cov_0.873950_g4399_i0 PRJNA188516 4449 168 0.87395 1.468236 Lawsonella 1847725 Bacteria Bacteria 123 2.88e-31   NR WP_304161553.1 1528099 g4399 i0 100 2 56 0 100 0 1 168 24 79 WP_304161553.1 hypothetical protein [Lawsonella clevelandensis] diamond 336 123 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
29473618 29473618 PRJNA188516_P_NODE_4330_length_168_cov_0.873950_g4280_i0 PRJNA188516 4330 168 0.87395 1.468236 Yonghaparkia sp. Soil8 1913979 Bacteria Bacteria 104 3.07e-25   NR WP_162253775.1 1736417 g4280 i0 96.4 1 56 2 100 0 1 168 266 321 WP_162253775.1 NAD(P)-dependent alcohol dehydrogenase [Yonghaparkia sp. Soil809] diamond 168 104 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microcella Yonghaparkia sp. Soil809
29505357 29505357 PRJNA188516_P_NODE_5810_length_163_cov_0.912281_g5760_i0 PRJNA188516 5810 163 0.912281 1.48701803 Brevibacterium daeguense 909936 Bacteria Bacteria 94.4 5.64e-21   NR WP_236864790.1 909936 g5760 i0 87 0.993865030674847 54 7 99.4 0 162 1 347 400 WP_236864790.1 DUF2254 domain-containing protein [Brevibacterium daeguense] diamond 162 94.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium daeguense
29789499 29789499 PRJNA188516_P_NODE_4491_length_168_cov_0.873950_g4441_i0 PRJNA188516 4491 168 0.87395 1.468236 Corynebacterium jeikeium 38289 Bacteria Bacteria 92.4 6.09e-21   NR WP_071056121.1 38289 g4441 i0 72.7 1.92857142857143 55 15 98.2 0 1 165 134 188 WP_071056121.1 hypothetical protein [Corynebacterium jeikeium] diamond 324 92.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium jeikeium
29852883 29852883 PRJNA188516_P_NODE_6031_length_162_cov_0.920354_g5981_i0 PRJNA188516 6031 162 0.920354 1.49097348 Streptomyces sp. NBC_ 1931 Bacteria Bacteria 41.6 0.0319   NR WP_330460950.1 2975842 g5981 i0 49 0.944444444444444 51 24 94.4 1 9 161 206 254 WP_330460950.1 carbamoyltransferase HypF [Streptomyces sp. NBC_00820] diamond 153 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_00820
30927219 30927219 PRJNA188516_P_NODE_4334_length_168_cov_0.873950_g4284_i0 PRJNA188516 4334 168 0.87395 1.468236 Modestobacter versicolor 429133 Bacteria Bacteria 52 6.62e-6   NR WP_146251540.1 429133 g4284 i0 56.4 0.982142857142857 55 24 98.2 0 2 166 22 76 WP_146251540.1 hypothetical protein [Modestobacter versicolor] diamond 165 52 1 Bacteria   Bacillati Actinomycetota Actinomycetes Geodermatophilales Geodermatophilaceae Modestobacter Modestobacter versicolor
30958706 30958706 PRJNA188516_P_NODE_6114_length_162_cov_0.920354_g6064_i0 PRJNA188516 6114 162 0.920354 1.49097348 Mycobacterium sp. SMC-8 2857060 Bacteria Bacteria 98.6 3.039999999999999e-23   NR WP_260755745.1 2857060 g6064 i0 84.6 1.92592592592593 52 8 96.3 0 157 2 53 104 WP_260755745.1 tRNA glutamyl-Q(34) synthetase GluQRS [Mycobacterium sp. SMC-8] diamond 312 98.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp. SMC-8
31116344 31116344 PRJNA188516_P_NODE_5195_length_165_cov_0.896552_g5145_i0 PRJNA188516 5195 165 0.896552 1.4793108 Varibaculum prostatecancerukia 2811781 Bacteria Bacteria 115 3.48e-28   NR WP_215522748.1 2811781 g5145 i0 96.4 1 55 2 100 0 165 1 252 306 WP_215522748.1 PQQ-binding-like beta-propeller repeat protein [Varibaculum prostatecancerukia] diamond 165 115 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Varibaculum Varibaculum prostatecancerukia
31401358 31401358 PRJNA188516_P_NODE_2436_length_220_cov_0.912281_g2386_i0 PRJNA188516 2436 220 0.912281 2.0070182 Amycolatopsis azurea 36819 Bacteria Bacteria 42.7 0.00572   NR WP_005163464.1 36819 g2386 i0 42.9 0.668181818181818 49 25 62.7 1 204 67 35 83 WP_005163464.1 hypothetical protein [Amycolatopsis azurea] diamond 147 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis azurea
31653990 31653990 PRJNA188516_P_NODE_5317_length_165_cov_0.741379_g5267_i0 PRJNA188516 5317 165 0.741379 1.22327535 Streptomyces venezuelae 54571 Bacteria Bacteria 42 0.0238   NR WP_150207289.1 54571 g5267 i0 41.7 0.872727272727273 48 27 87.3 1 16 159 21 67 WP_150207289.1 tyrosine-protein phosphatase [Streptomyces venezuelae] diamond 144 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces venezuelae
31685661 31685661 PRJNA188516_P_NODE_5117_length_165_cov_0.896552_g5067_i0 PRJNA188516 5117 165 0.896552 1.4793108 Baekduia sp. 2600305 Bacteria Bacteria 41.2 0.045   NR HYF28640.1 2600305 g5067 i0 45.8 0.872727272727273 48 24 87.3 1 3 146 11 56 HYF28640.1 acyl-CoA dehydrogenase family protein [Baekduia sp.] diamond 144 41.2 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Baekduiaceae Baekduia Baekduia sp.
32033841 32033841 PRJNA188516_P_NODE_4678_length_167_cov_0.881356_g4628_i0 PRJNA188516 4678 167 0.881356 1.47186452 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 61.2 3.91e-9   NR HWT92533.1 2586742 g4628 i0 45.5 0.988023952095808 55 30 98.8 0 165 1 177 231 HWT92533.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 165 61.2 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
32445365 32445365 PRJNA188516_P_NODE_4499_length_168_cov_0.873950_g4449_i0 PRJNA188516 4499 168 0.87395 1.468236 Demequina sp. NBRC 11 2050685 Bacteria Bacteria 73.6 1.8e-13   NR WP_084126365.1 1570343 g4449 i0 67.3 1.98214285714286 55 18 98.2 0 166 2 500 554 WP_084126365.1 sodium-translocating pyrophosphatase [Demequina sp. NBRC 110054] diamond 333 73.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Demequinaceae Demequina Demequina sp. NBRC 110054
32589580 32589580 PRJNA188516_P_NODE_5879_length_163_cov_0.859649_g5829_i0 PRJNA188516 5879 163 0.859649 1.40122787 Microcella 337004 Bacteria Bacteria 76.3 1.94e-14   NR WP_297600541.1 1913979 g5829 i0 67.3 1.91411042944785 52 17 95.7 0 156 1 251 302 WP_297600541.1 helicase-related protein [Microcella sp.] diamond 312 76.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microcella Microcella 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);;