RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA459724" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA459724 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
4270005 4270005 PRJNA459724_P_NODE_2984_length_277_cov_2.455645_g2593_i0 PRJNA459724 2984 277 2.455645 6.80213665 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 171 5.7e-49   NR MBP6489522.1 2497619 g2593 i0 100 0.985559566787004 91 0 98.6 0 3 275 52 142 MBP6489522.1 phage major capsid protein [Ilumatobacteraceae bacterium] diamond 273 171 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
27392370 27392370 PRJNA459724_P_NODE_1803_length_412_cov_2.088773_g1431_i0 PRJNA459724 1803 412 2.088773 8.60574476 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 126 3.66e-33   NR MBP6489523.1 2497619 g1431 i0 76.7 0.655339805825243 90 1 51 1 411 202 137 226 MBP6489523.1 HK97 family phage prohead protease [Ilumatobacteraceae bacterium] diamond 270 126 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
27424028 27424028 PRJNA459724_P_NODE_1163_length_546_cov_2.216634_g863_i0 PRJNA459724 1163 546 2.216634 12.10282164 Nocardioides marinquilinus 1210400 Bacteria Bacteria 150 1.44e-38   NR WP_345462691.1 1210400 g863 i0 47.9 0.928571428571429 169 87 92.3 1 2 505 360 528 WP_345462691.1 hypothetical protein [Nocardioides marinquilinus] diamond 507 150 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides marinquilinus
27850288 27850288 PRJNA459724_P_NODE_4384_length_198_cov_2.828402_g3992_i0 PRJNA459724 4384 198 2.828402 5.60023596 Bacteria 2 Bacteria Bacteria 130 4.95e-35   NR NBR22973.1 2026762 g3992 i0 89.2 2.95454545454545 65 7 98.5 0 3 197 187 251 NBR22973.1 hypothetical protein [Micrococcales bacterium] diamond 585 130 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales     Micrococcales bacterium
27992250 27992250 PRJNA459724_P_NODE_4145_length_208_cov_1.597765_g3753_i0 PRJNA459724 4145 208 1.597765 3.3233512 Mycolicibacterium aubagnense 319707 Bacteria Bacteria 63.5 2.19e-10   NR WP_280109269.1 319707 g3753 i0 70 1.86057692307692 40 12 57.7 0 195 76 128 167 WP_280109269.1 hypothetical protein [Mycolicibacterium aubagnense] diamond 387 63.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium aubagnense
28355543 28355543 PRJNA459724_S_NODE_1866_length_171_cov_5.110294_g1863_i0 PRJNA459724 1866 171 5.110294 8.73860274 Gordoniaceae 85026 Bacteria Bacteria 63.2 8.96e-10   NR WP_354562172.1 2053 g1863 i0 63.8 2.56140350877193 47 17 82.5 0 13 153 431 477 WP_354562172.1 MULTISPECIES: type VII secretion protein EccB [Gordonia] diamond 438 63.5 0.995275590551181 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia  
28370983 28370983 PRJNA459724_P_NODE_4826_length_184_cov_1.935484_g4434_i0 PRJNA459724 4826 184 1.935484 3.56129056 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 99.4 2.56e-25   NR HRB02685.1 2497619 g4434 i0 78.6 0.91304347826087 56 12 91.3 0 183 16 17 72 HRB02685.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 168 99.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
28655270 28655270 PRJNA459724_P_NODE_5447_length_165_cov_1.808824_g5055_i0 PRJNA459724 5447 165 1.808824 2.9845596 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 99.8 1.01e-22   NR MBP9052028.1 2497619 g5055 i0 100 1 55 0 100 0 1 165 282 336 MBP9052028.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 165 99.8 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
28749921 28749921 PRJNA459724_P_NODE_2547_length_316_cov_1.648084_g2156_i0 PRJNA459724 2547 316 1.648084 5.20794544 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 175 1.16e-49   NR MBP9052028.1 2497619 g2156 i0 91.6 1.01582278481013 107 6 98.7 1 3 314 381 487 MBP9052028.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 321 175 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
28844447 28844447 PRJNA459724_S_NODE_348_length_251_cov_4.537037_g345_i0 PRJNA459724 348 251 4.537037 11.38796287 Olegusella massiliensis 1776381 Bacteria Bacteria 67.8 5.53e-11   NR WP_068539404.1 1776381 g345 i0 91.4 0.418326693227092 35 2 40.6 1 102 1 1 35 WP_068539404.1 site-specific integrase [Olegusella massiliensis] diamond 105 67.8 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales Coriobacteriaceae Olegusella Olegusella massiliensis
29034323 29034323 PRJNA459724_P_NODE_2988_length_277_cov_1.580645_g2597_i0 PRJNA459724 2988 277 1.580645 4.37838665 Cutibacterium granulosum 33011 Bacteria Bacteria 182 2.4799999999999998e-52   NR PZP22944.1 33011 g2597 i0 87 0.996389891696751 92 12 99.6 0 2 277 179 270 PZP22944.1 MAG: hypothetical protein DI600_03580 [Cutibacterium granulosum] diamond 276 182 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium granulosum
29160646 29160646 PRJNA459724_S_NODE_3149_length_150_cov_3.695652_g3146_i0 PRJNA459724 3149 150 3.695652 5.543478 Actinomycetes 1760 Bacteria Bacteria 97.4 1.35e-24   NR WP_023956329.1 1760 g3146 i0 97.9 0.96 48 1 96 0 5 148 3 50 WP_023956329.1 MULTISPECIES: hypothetical protein [Actinomycetes] diamond 144 97.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes        
29349898 29349898 PRJNA459724_P_NODE_2869_length_288_cov_2.189189_g2478_i0 PRJNA459724 2869 288 2.189189 6.30486432 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 175 1.18e-50   NR MBP6489522.1 2497619 g2478 i0 97.9 1 96 2 100 0 1 288 146 241 MBP6489522.1 phage major capsid protein [Ilumatobacteraceae bacterium] diamond 288 175 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
29760114 29760114 PRJNA459724_P_NODE_5591_length_161_cov_1.840909_g5199_i0 PRJNA459724 5591 161 1.840909 2.96386349 unclassified Streptomyces 2593676 Bacteria Bacteria 53.9 2.94e-7   NR WP_398861545.1 2593676 g5199 i0 55.6 1.93788819875776 54 19 95 3 8 160 75 126 WP_398861545.1 MULTISPECIES: HNH endonuclease signature motif containing protein [unclassified Streptomyces] diamond 312 53.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
30138959 30138959 PRJNA459724_P_NODE_5692_length_157_cov_2.578125_g5300_i0 PRJNA459724 5692 157 2.578125 4.04765625 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 108 5.26e-26   NR MBP6489525.1 2497619 g5300 i0 100 0.974522292993631 51 0 97.5 0 155 3 16 66 MBP6489525.1 terminase family protein [Ilumatobacteraceae bacterium] diamond 153 108 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
30329448 30329448 PRJNA459724_P_NODE_5032_length_178_cov_1.395973_g4640_i0 PRJNA459724 5032 178 1.395973 2.48483194 Cutibacterium granulosum 33011 Bacteria Bacteria 60.5 7.21e-10   NR PZP18157.1 33011 g4640 i0 100 0.471910112359551 28 0 47.2 0 93 176 1 28 PZP18157.1 MAG: hypothetical protein DI600_09895 [Cutibacterium granulosum] diamond 84 60.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium granulosum
30360987 30360987 PRJNA459724_P_NODE_3472_length_243_cov_1.836449_g3080_i0 PRJNA459724 3472 243 1.836449 4.46257107 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 164 4.63e-47   NR MBP8212051.1 2497619 g3080 i0 92.9 1.04938271604938 85 1 98.8 1 2 241 174 258 MBP8212051.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 255 164 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
30644704 30644704 PRJNA459724_P_NODE_2393_length_331_cov_2.463576_g2002_i0 PRJNA459724 2393 331 2.463576 8.15443656 Propionibacterium freudenreichii 1744 Bacteria Bacteria 139 1.86e-40   NR WP_404905140.1 1744 g2002 i0 85.4 0.743202416918429 82 9 74.3 1 248 3 1 79 WP_404905140.1 hypothetical protein, partial [Propionibacterium freudenreichii] diamond 246 139 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Propionibacterium Propionibacterium freudenreichii
30692584 30692584 PRJNA459724_P_NODE_5133_length_175_cov_1.500000_g4741_i0 PRJNA459724 5133 175 1.5 2.625 Actinomycetota 201174 Bacteria Bacteria 124 2.47e-34   NR MFI0434076.1 2518612 g4741 i0 98.2 1.95428571428571 57 1 97.7 0 171 1 4 60 MFI0434076.1 hypothetical protein [Candidatus Nanopelagicales bacterium] diamond 342 124 1 Bacteria   Bacillati Actinomycetota Actinomycetes Candidatus Nanopelagicales     Candidatus Nanopelagicales bacterium
30771422 30771422 PRJNA459724_P_NODE_3234_length_259_cov_2.117391_g2842_i0 PRJNA459724 3234 259 2.117391 5.48404269 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 120 7.75e-33   NR MBP9052030.1 2497619 g2842 i0 100 0.694980694980695 60 0 69.5 0 79 258 1 60 MBP9052030.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 180 120 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
30913985 30913985 PRJNA459724_P_NODE_3514_length_241_cov_1.594340_g3122_i0 PRJNA459724 3514 241 1.59434 3.8423594 Acidimicrobiales 84993 Bacteria Bacteria 61.6 2.33e-9   NR MBP6489519.1 2497619 g3122 i0 96.9 0.796680497925311 32 1 39.8 0 144 239 72 103 MBP6489519.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 192 61.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
31213167 31213167 PRJNA459724_P_NODE_4635_length_190_cov_2.043478_g4243_i0 PRJNA459724 4635 190 2.043478 3.8826082 Actinocrispum wychmicini 1213861 Bacteria Bacteria 42.7 0.0185   NR WP_132118180.1 1213861 g4243 i0 33.8 1.02631578947368 65 39 97.9 2 186 1 187 250 WP_132118180.1 Rieske 2Fe-2S domain-containing protein [Actinocrispum wychmicini] diamond 195 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinocrispum Actinocrispum wychmicini
31593353 31593353 PRJNA459724_P_NODE_5556_length_162_cov_1.503759_g5164_i0 PRJNA459724 5556 162 1.503759 2.43608958 Candidatus Microthrix sp. 2719034 Bacteria Bacteria 114 1.19e-28   NR WP_291835774.1 2719034 g5164 i0 98.1 1 54 1 100 0 162 1 277 330 WP_291835774.1 hypothetical protein [Candidatus Microthrix sp.] diamond 162 114 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Microthrixaceae Candidatus Neomicrothrix Candidatus Neomicrothrix sp.
31830556 31830556 PRJNA459724_P_NODE_817_length_657_cov_3.351911_g566_i0 PRJNA459724 817 657 3.351911 22.02205527 Bacteria 2 Bacteria Bacteria 87.4 4.18e-16   NR MDN6740750.1 160386 g566 i0 73.6 1.20091324200913 53 14 24.2 0 656 498 346 398 MDN6740750.1 PBSX family phage terminase large subunit [Corynebacterium casei] diamond 789 87.8 0.995444191343964 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium casei
31940922 31940922 PRJNA459724_P_NODE_3357_length_250_cov_3.067873_g2965_i0 PRJNA459724 3357 250 3.067873 7.6696825 Pseudarthrobacter psychrotolerans 2697569 Bacteria Bacteria 43.5 0.00273   NR WP_201762542.1 2697569 g2965 i0 40 0.66 55 33 66 0 170 6 15 69 WP_201762542.1 helix-turn-helix transcriptional regulator [Pseudarthrobacter psychrotolerans] diamond 165 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Pseudarthrobacter Pseudarthrobacter psychrotolerans
32415855 32415855 PRJNA459724_S_NODE_1739_length_174_cov_4.956835_g1736_i0 PRJNA459724 1739 174 4.956835 8.6248929 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 52.4 4.99e-6   NR MCU1463980.1 2201156 g1736 i0 62.9 2.12068965517241 35 13 60.3 0 174 70 219 253 MCU1463980.1 hypothetical protein [Acidimicrobiales bacterium] diamond 369 52.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
32527154 32527154 PRJNA459724_P_NODE_1679_length_436_cov_1.923833_g1316_i0 PRJNA459724 1679 436 1.923833 8.38791188 Bacteria 2 Bacteria Bacteria 47.4 0.00609   NR WP_161594084.1 2489212 g1316 i0 33.1 1.41743119266055 148 83 93.6 4 29 436 67 210 WP_161594084.1 SGNH/GDSL hydrolase family protein [Microbacterium sp. RG1] diamond 618 47.8 0.99163179916318 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. RG1
32542527 32542527 PRJNA459724_P_NODE_5359_length_168_cov_1.589928_g4967_i0 PRJNA459724 5359 168 1.589928 2.67107904 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 90.9 2.93e-22   NR HQY16694.1 2497619 g4967 i0 79.6 0.875 49 10 87.5 0 149 3 1 49 HQY16694.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 147 90.9 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
32574171 32574171 PRJNA459724_P_NODE_2619_length_309_cov_2.617857_g2228_i0 PRJNA459724 2619 309 2.617857 8.08917813 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 153 4.73e-46   NR HQY16233.1 2497619 g2228 i0 100 0.631067961165049 65 0 63.1 0 308 114 30 94 HQY16233.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 195 153 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
32605402 32605402 PRJNA459724_P_NODE_2460_length_324_cov_2.077966_g2069_i0 PRJNA459724 2460 324 2.077966 6.73260984 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 154 1.15e-43   NR MBP8212050.1 2497619 g2069 i0 100 0.675925925925926 73 0 67.6 0 323 105 228 300 MBP8212050.1 site-specific DNA-methyltransferase [Ilumatobacteraceae bacterium] diamond 219 154 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
32810396 32810396 PRJNA459724_P_NODE_4860_length_183_cov_1.759740_g4468_i0 PRJNA459724 4860 183 1.75974 3.2203242 Bacteria candidate phyla 1783234 Bacteria Bacteria 43.9 0.00645   NR WP_062160016.1 1771959 g4468 i0 36.6 3.39344262295082 41 26 67.2 0 59 181 55 95 WP_062160016.1 phage terminase large subunit [[Arthrobacter] sp. ATCC 21022] diamond 621 44.3 0.99097065462754 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Paenarthrobacter [Arthrobacter] sp. ATCC 21022

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