RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA657343 · 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
13377256 13377256 PRJNA657343_P_NODE_43151_length_163_cov_0.912281_g43127_i0 PRJNA657343 43151 163 0.912281 1.48701803 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 81.3 2.41e-16   NR MCB0998317.1 2201156 g43127 i0 71.2 6.69938650306749 52 15 95.7 0 158 3 144 195 MCB0998317.1 type I methionyl aminopeptidase [Acidimicrobiales bacterium] diamond 1092 81.3 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
18475538 18475538 PRJNA657343_P_NODE_7975_length_291_cov_3.342975_g7951_i0 PRJNA657343 7975 291 3.342975 9.72805725 Actinomycetota bacterium 2900548 Bacteria Bacteria 155 2.2799999999999998e-46   NR MBS1889789.1 2900548 g7951 i0 77.9 0.979381443298969 95 18 97.9 1 287 3 28 119 MBS1889789.1 hypothetical protein [Actinomycetota bacterium] diamond 285 155 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
26764824 26764824 PRJNA657343_P_NODE_32121_length_174_cov_2.368000_g32097_i0 PRJNA657343 32121 174 2.368 4.12032 Glycomyces tenuis 58116 Bacteria Bacteria 42 0.0267   NR WP_156037545.1 58116 g32097 i0 48.7 2.24137931034483 39 20 67.2 0 124 8 215 253 WP_156037545.1 serine/threonine-protein kinase, partial [Glycomyces tenuis] diamond 390 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Glycomycetales Glycomycetaceae Glycomyces Glycomyces tenuis
26764831 26764831 PRJNA657343_P_NODE_42921_length_163_cov_0.912281_g42897_i0 PRJNA657343 42921 163 0.912281 1.48701803 Actinomyces massiliensis 461393 Bacteria Bacteria 108 2.12e-26   NR WP_315208798.1 461393 g42897 i0 100 0.975460122699387 53 0 97.5 0 3 161 11 63 WP_315208798.1 ATP-binding protein [Actinomyces massiliensis] diamond 159 108 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces massiliensis
27081326 27081326 PRJNA657343_P_NODE_35342_length_169_cov_0.866667_g35318_i0 PRJNA657343 35342 169 0.866667 1.46466723 Spirillospora albida 58123 Bacteria Bacteria 41.6 0.0343   NR WP_051712584.1 58123 g35318 i0 47.5 0.710059171597633 40 21 71 0 12 131 166 205 WP_051712584.1 serine/threonine-protein kinase [Spirillospora albida] diamond 120 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Spirillospora Spirillospora albida
27207537 27207537 PRJNA657343_P_NODE_11242_length_257_cov_0.947115_g11218_i0 PRJNA657343 11242 257 0.947115 2.43408555 Actinomycetota bacterium 2900548 Bacteria Bacteria 66.6 1.52e-10   NR MDA8379435.1 2900548 g11218 i0 50.8 0.75875486381323 65 30 73.5 1 192 4 2 66 MDA8379435.1 J domain-containing protein [Actinomycetota bacterium] diamond 195 66.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28060422 28060422 PRJNA657343_P_NODE_33905_length_171_cov_1.262295_g33881_i0 PRJNA657343 33905 171 1.262295 2.15852445 Thermoleophilaceae bacterium 2732252 Bacteria Bacteria 80.5 6.77e-16   NR MFL5867966.1 2732252 g33881 i0 65.5 2.82456140350877 55 19 96.5 0 168 4 298 352 MFL5867966.1 acid phosphatase [Thermoleophilaceae bacterium] diamond 483 80.5 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Thermoleophilales Thermoleophilaceae   Thermoleophilaceae bacterium
28376131 28376131 PRJNA657343_P_NODE_37966_length_167_cov_0.881356_g37942_i0 PRJNA657343 37966 167 0.881356 1.47186452 Streptomyces lincolnensis 1915 Bacteria Bacteria 53.9 1.45e-6   NR WP_232029192.1 1915 g37942 i0 44.9 3.59281437125748 49 27 88 0 11 157 279 327 WP_232029192.1 enoyl-CoA hydratase/isomerase family protein [Streptomyces lincolnensis] diamond 600 53.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces lincolnensis
28546581 28546581 PRJNA657343_P_NODE_33127_length_172_cov_2.260163_g33103_i0 PRJNA657343 33127 172 2.260163 3.88748036 Bacteria 2 Bacteria Bacteria 48.9 1.04e-5   NR WP_189082361.1 1751298 g33103 i0 38.3 6.68023255813953 47 29 82 0 157 17 1 47 WP_189082361.1 RICIN domain-containing protein, partial [Mangrovihabitans endophyticus] diamond 1149 49.3 0.991886409736308 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Mangrovihabitans Mangrovihabitans endophyticus
28577928 28577928 PRJNA657343_P_NODE_13347_length_241_cov_1.505208_g13323_i0 PRJNA657343 13347 241 1.505208 3.62755128 PVC group 1783257 Bacteria Bacteria 81.6 4.24e-17   NR WP_156198477.1 1348467 g13323 i0 62.3 3.6597510373444 61 23 75.9 0 241 59 126 186 WP_156198477.1 adenine phosphoribosyltransferase [Actinotalea caeni] diamond 882 81.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Actinotalea Actinotalea caeni
29102550 29102550 PRJNA657343_P_NODE_20008_length_207_cov_3.208861_g19984_i0 PRJNA657343 20008 207 3.208861 6.64234227 Mycolicibacterium flavescens 1776 Bacteria Bacteria 45.4 0.00213   NR WP_131815754.1 1776 g19984 i0 40.3 6.59420289855072 77 33 92.8 3 201 10 62 138 WP_131815754.1 tandem-95 repeat protein, partial [Mycolicibacterium flavescens] diamond 1365 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium flavescens
29860172 29860172 PRJNA657343_P_NODE_36651_length_168_cov_0.873950_g36627_i0 PRJNA657343 36651 168 0.87395 1.468236 Corynebacterium otitidis 29321 Bacteria Bacteria 110 2.5200000000000003e-27   NR WP_004601625.1 29321 g36627 i0 98.2 0.982142857142857 55 1 98.2 0 2 166 269 323 WP_004601625.1 2,3-butanediol dehydrogenase [Corynebacterium otitidis] diamond 165 110 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium otitidis
30018307 30018307 PRJNA657343_P_NODE_2971_length_421_cov_4.403226_g2948_i0 PRJNA657343 2971 421 4.403226 18.53758146 Mycolicibacterium sp. 2320850 Bacteria Bacteria 51.2 2.81e-4   NR WP_185976292.1 2592069 g2948 i0 38.9 1.6104513064133 113 58 80.5 4 348 10 587 688 WP_185976292.1 Ig-like domain-containing protein [Mycolicibacterium sp. 018/SC-01/001] diamond 678 51.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium sp. 018/SC-01/001
30207435 30207435 PRJNA657343_P_NODE_35072_length_169_cov_0.866667_g35048_i0 PRJNA657343 35072 169 0.866667 1.46466723 Streptomyces sp. NPDC 1931 Bacteria Bacteria 51.2 2.91e-6   NR WP_363059874.1 3154726 g35048 i0 43.6 0.976331360946746 55 30 95.9 1 169 8 25 79 WP_363059874.1 C2 domain-containing protein [Streptomyces sp. NPDC048606] diamond 165 51.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC048606
30662284 30662284 PRJNA657343_P_NODE_8493_length_285_cov_2.338983_g8469_i0 PRJNA657343 8493 285 2.338983 6.66610155 Bacteria 2 Bacteria Bacteria 50.1 1.63e-4   NR WP_170224792.1 1348852 g8469 i0 46.4 1.37894736842105 69 34 69.5 1 220 23 647 715 WP_170224792.1 Ig-like domain-containing protein [Mumia flava] diamond 393 50.4 0.994047619047619 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Mumia Mumia flava
30776558 30776558 PRJNA657343_S_NODE_23834_length_184_cov_1.925926_g23809_i0 PRJNA657343 23834 184 1.925926 3.54370384 Actinomycetota bacterium 2900548 Bacteria Bacteria 41.6 0.036   NR MEY4000863.1 2900548 g23809 i0 43.6 0.635869565217391 39 21 62 1 159 46 156 194 MEY4000863.1 hypothetical protein [Actinomycetota bacterium] diamond 117 41.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30934532 30934532 PRJNA657343_P_NODE_28674_length_182_cov_1.511278_g28650_i0 PRJNA657343 28674 182 1.511278 2.75052596 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 60.8 5.67e-9   NR HZM54877.1 2201156 g28650 i0 55.6 3.59340659340659 54 23 89 1 7 168 252 304 HZM54877.1 phosphoenolpyruvate carboxykinase domain-containing protein [Acidimicrobiales bacterium] diamond 654 60.8 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
31218401 31218401 PRJNA657343_P_NODE_16295_length_224_cov_1.131429_g16271_i0 PRJNA657343 16295 224 1.131429 2.53440096 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 87.4 1.55e-20   NR MCW5953410.1 2021380 g16271 i0 52.1 0.950892857142857 71 34 95.1 0 5 217 7 77 MCW5953410.1 hypothetical protein [Propionibacteriaceae bacterium] diamond 213 87.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
32275139 32275139 PRJNA657343_P_NODE_11558_length_254_cov_2.624390_g11534_i0 PRJNA657343 11558 254 2.62439 6.6659506 Actinomycetota 201174 Bacteria Bacteria 103 1.9599999999999994e-23   NR NLA29947.1 1977903 g11534 i0 58.5 3.8740157480315 82 32 96.9 2 2 247 56 135 NLA29947.1 phosphoenolpyruvate carboxykinase (GTP) [Propionibacterium sp.] diamond 984 103 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Propionibacterium Propionibacterium sp.
32579248 32579248 PRJNA657343_P_NODE_23579_length_195_cov_1.335616_g23555_i0 PRJNA657343 23579 195 1.335616 2.6044512 Actinomycetota bacterium 2900548 Bacteria Bacteria 96.7 1.58e-21   NR MEY4079183.1 2900548 g23555 i0 67.7 1.92307692307692 62 20 95.4 0 194 9 99 160 MEY4079183.1 hypothetical protein [Actinomycetota bacterium] diamond 375 96.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
32717223 32717223 PRJNA657343_P_NODE_28000_length_183_cov_3.962687_g27976_i0 PRJNA657343 28000 183 3.962687 7.25171721 Actinomycetes 1760 Bacteria Bacteria 49.7 5.88e-5   NR WP_076988187.1 1933779 g27976 i0 46 5.54098360655738 50 27 82 0 158 9 614 663 WP_076988187.1 beta-galactosidase [Actinosynnema sp. ALI-1.44] diamond 1014 49.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinosynnema Actinosynnema sp. ALI-1.44
32874603 32874603 PRJNA657343_P_NODE_42680_length_163_cov_1.307018_g42656_i0 PRJNA657343 42680 163 1.307018 2.13043934 Actinomycetes 1760 Bacteria Bacteria 97.1 1.0799999999999999e-23   NR WP_090770336.1 683260 g42656 i0 84 1.89570552147239 50 8 92 0 154 5 45 94 WP_090770336.1 C40 family peptidase [Nonomuraea maritima] diamond 309 97.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea maritima

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