RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where bioproject = "PRJEB3181", tax_phylum = "Actinomycetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 33 ✖

tax_phylum 1

  • Actinomycetota · 33 ✖

tax_kingdom 1

bioproject 1

  • PRJEB3181 · 33 ✖

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
56172 56172 PRJEB3181_S_NODE_541_length_594_cov_35.762075_g307_i0 PRJEB3181 541 594 35.762075 212.4267255 Microbacterium schleiferi 69362 Bacteria Bacteria 867 0   NTclustered gi|1933612020|gb|CP064760.1| 69362 g307 i0 95.888 159.397306397306 535 22 90 0 25 559 1098892 1099426 Microbacterium schleiferi strain A32-1 chromosome, complete genome blastn 94682 867 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium schleiferi
988834 988834 PRJEB3181_P_NODE_9801_length_271_cov_3.858333_g9537_i0 PRJEB3181 9801 271 3.858333 10.45608243 Microbacterium 33882 Bacteria Bacteria 377 3.61e-100   NTclustered gi|1933612020|gb|CP064760.1| 69362 g9537 i0 93.023 151.217712177122 258 18 95 0 14 271 1099421 1099164 Microbacterium schleiferi strain A32-1 chromosome, complete genome blastn 40980 377 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium schleiferi
3882122 3882122 PRJEB3181_P_NODE_7884_length_301_cov_1.877778_g7622_i0 PRJEB3181 7884 301 1.877778 5.65211178 Actinomycetota bacterium 2900548 Bacteria Bacteria 83.6 3.49e-16   NR MEY3331002.1 2900548 g7622 i0 61.5 3.90697674418605 78 26 73.8 1 1 222 305 382 MEY3331002.1 hypothetical protein [Actinomycetota bacterium] diamond 1176 83.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
4816730 4816730 PRJEB3181_S_NODE_15284_length_166_cov_2.343511_g14991_i0 PRJEB3181 15284 166 2.343511 3.89022826 Microbacterium 33882 Bacteria Bacteria 307 2.69e-79   NTclustered gi|1547066608|gb|CP031338.1| 82380 g14991 i0 100 4 166 0 100 0 1 166 824332 824167 Microbacterium oxydans strain VIU2A chromosome, complete genome blastn 664 307 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium oxydans
6091973 6091973 PRJEB3181_S_NODE_16125_length_162_cov_0.944882_g15832_i0 PRJEB3181 16125 162 0.944882 1.53070884 Actinomycetes 1760 Bacteria Bacteria 300 4.36e-77   NTclustered gi|1547066608|gb|CP031338.1| 82380 g15832 i0 100 4 162 0 100 0 1 162 824513 824352 Microbacterium oxydans strain VIU2A chromosome, complete genome blastn 648 300 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium oxydans
7366397 7366397 PRJEB3181_P_NODE_10286_length_264_cov_30.412017_g10022_i0 PRJEB3181 10286 264 30.412017 80.28772488 Streptomycetaceae 2062 Bacteria Bacteria 329 9.95e-86   NTclustered gi|1442643274|gb|CP031320.1| 83291 g10022 i0 92.92 480.901515151515 226 16 86 0 1 226 7990910 7990685 Streptomyces armeniacus strain ATCC 15676 chromosome blastn 126958 329 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces armeniacus
7366436 7366436 PRJEB3181_S_NODE_15506_length_165_cov_1.230769_g15213_i0 PRJEB3181 15506 165 1.230769 2.03076885 Microbacterium 33882 Bacteria Bacteria 305 9.59e-79   NTclustered gi|1547066608|gb|CP031338.1| 82380 g15213 i0 100 17.5757575757576 165 0 100 0 1 165 817539 817703 Microbacterium oxydans strain VIU2A chromosome, complete genome blastn 2900 305 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium oxydans
8642048 8642048 PRJEB3181_S_NODE_15427_length_165_cov_3.061538_g15134_i0 PRJEB3181 15427 165 3.061538 5.0515377 Microbacterium 33882 Bacteria Bacteria 222 9.939999999999999e-54   NTclustered gi|2636116595|gb|CP139779.1| 515415 g15134 i0 100 138.775757575758 120 0 73 0 1 120 2287548 2287429 Microbacterium invictum strain X-18 chromosome, complete genome blastn 22898 222 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium invictum
8983172 8983172 PRJEB3181_S_NODE_17108_length_157_cov_1.655738_g16815_i0 PRJEB3181 17108 157 1.655738 2.59950866 Streptomyces sp. NBC_01176 2903760 Bacteria Bacteria 52.8 0.013   NTclustered gi|2654850809|gb|CP108600.1| 2903760 g16815 i0 100 0.178343949044586 28 0 18 0 46 73 2038646 2038673 Streptomyces sp. NBC_01176 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_01176
8983274 8983274 PRJEB3181_S_NODE_848_length_494_cov_10118.344227_g582_i0 PRJEB3181 848 494 10118.344227 49984.62048138 Bacteria 2 Bacteria Bacteria 109 2.43e-26   NR MEI6867845.1 1883427 g582 i0 52.9 1.87044534412955 104 45 63.2 1 2 313 106 205 MEI6867845.1 NAD(P)H-dependent oxidoreductase [Actinomycetes bacterium] diamond 924 110 0.990909090909091 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
9917034 9917034 PRJEB3181_S_NODE_15448_length_165_cov_2.430769_g15155_i0 PRJEB3181 15448 165 2.430769 4.01076885 Micrococcales 85006 Bacteria Bacteria 305 9.59e-79   NTclustered gi|1933612020|gb|CP064760.1| 69362 g15155 i0 100 166.363636363636 165 0 100 0 1 165 1100904 1100740 Microbacterium schleiferi strain A32-1 chromosome, complete genome blastn 27450 305 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium schleiferi
11192185 11192185 PRJEB3181_P_NODE_7349_length_309_cov_18.672662_g7088_i0 PRJEB3181 7349 309 18.672662 57.69852558 Micrococcus 1269 Bacteria Bacteria 464 3.13e-126   NTclustered gi|1891023613|gb|CP058971.1| 1270 g7088 i0 97.426 271.126213592233 272 7 89 0 38 309 345728 345457 Micrococcus luteus strain V017 chromosome, complete genome blastn 83778 464 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
11534328 11534328 PRJEB3181_S_NODE_4990_length_269_cov_291.333333_g4697_i0 PRJEB3181 4990 269 291.333333 783.68666577 uncultured Actinomycetales bacterium 239730 Bacteria Bacteria 67.6 8.8e-7   NTclustered gi|310754897|gb|HQ212787.1| 239730 g4697 i0 81.609 13.9516728624535 87 11 31 5 142 225 984 900 Uncultured Actinomycetales bacterium clone 2_D10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 3753 67.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales     uncultured Actinomycetales bacterium
11534381 11534381 PRJEB3181_S_NODE_8790_length_213_cov_1.550562_g8497_i0 PRJEB3181 8790 213 1.550562 3.30269706 Microbacterium paraoxydans 199592 Bacteria Bacteria 337 4.62e-88   NTclustered gi|2059376513|gb|CP064874.1| 199592 g8497 i0 100 3.56807511737089 182 0 85 0 1 182 112089 111908 Microbacterium paraoxydans strain 70447 plasmid unnamed1, complete sequence blastn 760 337 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium paraoxydans
15016680 15016680 PRJEB3181_P_NODE_5692_length_343_cov_7.993590_g5438_i0 PRJEB3181 5692 343 7.99359 27.4180137 Cutibacterium 1912216 Bacteria Bacteria 468 2.72e-127   NTclustered gi|1446500593|gb|CP031442.1| 1747 g5438 i0 100 253.241982507289 253 0 97 0 14 266 55728 55476 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 86862 468 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
15016744 15016744 PRJEB3181_S_NODE_9012_length_210_cov_39566.828571_g8719_i0 PRJEB3181 9012 210 39566.828571 83090.3399991 Actinomycetes 1760 Bacteria Bacteria 200 6.22e-47   NTclustered gi|1886976265|gb|CP059903.1| 2760089 g8719 i0 95.935 209.37619047619 123 5 59 0 1 123 1983265 1983387 Nocardioides dongkuii strain S-713 chromosome, complete genome blastn 43969 200 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides dongkuii
15358042 15358042 PRJEB3181_P_NODE_12993_length_235_cov_1.975490_g12729_i0 PRJEB3181 12993 235 1.97549 4.6424015 Nocardioides anomalus 2712223 Bacteria Bacteria 52.8 0.021   NTclustered gi|1817480961|gb|CP049257.1| 2712223 g12729 i0 100 0.119148936170213 28 0 12 0 203 230 1337691 1337664 Nocardioides anomalus strain HKS04 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides anomalus
17566684 17566684 PRJEB3181_S_NODE_16134_length_162_cov_0.944882_g15841_i0 PRJEB3181 16134 162 0.944882 1.53070884 Streptomyces 1883 Bacteria Bacteria 56.5 0.001   NTclustered gi|2578917038|gb|CP134213.1| 67308 g15841 i0 96.97 14.4691358024691 33 1 20 0 23 55 1984096 1984128 Streptomyces janthinus strain JCM 4387 chromosome, complete genome blastn 2344 56.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces janthinus
17907537 17907537 PRJEB3181_P_NODE_16075_length_209_cov_1.668539_g15811_i0 PRJEB3181 16075 209 1.668539 3.48724651 Rhodococcus sp. AH-ZY2 3047468 Bacteria Bacteria 54.7 0.005   NTclustered gi|2570993224|gb|CP126458.1| 3047468 g15811 i0 100 0.138755980861244 29 0 14 0 31 59 268067 268095 Rhodococcus sp. AH-ZY2 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus sp. AH-ZY2
18840562 18840562 PRJEB3181_S_NODE_4795_length_274_cov_2.610879_g4502_i0 PRJEB3181 4795 274 2.610879 7.15380846 Cutibacterium 1912216 Bacteria Bacteria 490 4.499999999999999e-134   NTclustered gi|1446500593|gb|CP031442.1| 1747 g4502 i0 98.905 263.069343065693 274 3 100 0 1 274 55521 55794 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 72081 490 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
20115302 20115302 PRJEB3181_P_NODE_13516_length_230_cov_1.748744_g13252_i0 PRJEB3181 13516 230 1.748744 4.0221112 Streptomyces 1883 Bacteria Bacteria 56.5 0.002   NTclustered gi|2652094521|gb|CP109104.1| 2975939 g13252 i0 100 0.665217391304348 30 0 13 0 135 164 4863304 4863333 Streptomyces sp. NBC_01775 chromosome, complete genome blastn 153 56.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_01775
21391022 21391022 PRJEB3181_S_NODE_9477_length_206_cov_2.888889_g9184_i0 PRJEB3181 9477 206 2.888889 5.95111134 Cutibacterium 1912216 Bacteria Bacteria 381 2.0199999999999994e-101   NTclustered gi|1898669123|emb|LR588480.1| 1747 g9184 i0 100 235.771844660194 206 0 100 0 1 206 387 182 Cutibacterium acnes partial 16S rRNA gene, isolate PD1MD blastn 48569 381 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
21732878 21732878 PRJEB3181_S_NODE_538_length_595_cov_6.626786_g305_i0 PRJEB3181 538 595 6.626786 39.4293767 Microbacterium sp. JZ31 1906274 Bacteria Bacteria 418 5.039999999999999e-112   NTclustered gi|1972867151|gb|CP017661.1| 1906274 g305 i0 96.457 75.472268907563 254 8 43 1 1 253 2156968 2156715 Microbacterium sp. JZ31, complete genome blastn 44906 418 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. JZ31
22665711 22665711 PRJEB3181_S_NODE_15478_length_165_cov_1.684615_g15185_i0 PRJEB3181 15478 165 1.684615 2.77961475 Microbacterium 33882 Bacteria Bacteria 305 9.59e-79   NTclustered gi|1547066608|gb|CP031338.1| 82380 g15185 i0 100 4 165 0 100 0 1 165 817398 817234 Microbacterium oxydans strain VIU2A chromosome, complete genome blastn 660 305 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium oxydans
22665725 22665725 PRJEB3181_S_NODE_2318_length_353_cov_28.235849_g2025_i0 PRJEB3181 2318 353 28.235849 99.67254697 PVC group 1783257 Bacteria Bacteria 652 0   NTclustered gi|2060203558|gb|MZ473238.1| 51671 g2025 i0 100 100.008498583569 353 0 100 0 1 353 810 458 Microbacterium sp. strain PW36_R2A_8 16S ribosomal RNA gene, partial sequence blastn 35303 652 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp.
22665743 22665743 PRJEB3181_S_NODE_7158_length_233_cov_4.272727_g6865_i0 PRJEB3181 7158 233 4.272727 9.95545391 Microbacterium 33882 Bacteria Bacteria 401 1.7999999999999993e-107   NTclustered gi|1084379694|gb|CP017674.1| 1906742 g6865 i0 97.854 172.703862660944 233 4 99 1 2 233 483856 483624 Microbacterium sp. BH-3-3-3 chromosome, complete genome blastn 40240 403 0.995037220843672 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. BH-3-3-3
29180900 29180900 PRJEB3181_P_NODE_2589_length_448_cov_8.352518_g2386_i0 PRJEB3181 2589 448 8.352518 37.41928064 Solirubrobacterales bacterium 1909295 Bacteria Bacteria 56.6 3.86e-6   NR MFL5891499.1 1909295 g2386 i0 40.5 0.529017857142857 79 35 44.9 4 14 214 217 295 MFL5891499.1 hypothetical protein [Solirubrobacterales bacterium] diamond 237 56.6 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales     Solirubrobacterales bacterium
29370214 29370214 PRJEB3181_S_NODE_1289_length_427_cov_10.821429_g1006_i0 PRJEB3181 1289 427 10.821429 46.20750183 Actinomycetota bacterium 2900548 Bacteria Bacteria 112 5.119999999999999e-28   NR MEY2634385.1 2900548 g1006 i0 59.8 1.43325526932084 102 41 71.7 0 2 307 106 207 MEY2634385.1 hypothetical protein [Actinomycetota bacterium] diamond 612 112 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29622290 29622290 PRJEB3181_S_NODE_13490_length_176_cov_1.397163_g13197_i0 PRJEB3181 13490 176 1.397163 2.45900688 Actinomycetes bacterium 1883427 Bacteria Bacteria 75.1 8.84e-15   NR MEI6230221.1 1883427 g13197 i0 61.4 0.971590909090909 57 22 97.2 0 5 175 18 74 MEI6230221.1 NAD(P)H-dependent oxidoreductase [Actinomycetes bacterium] diamond 171 75.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
31201888 31201888 PRJEB3181_P_NODE_10575_length_261_cov_3.634783_g10311_i0 PRJEB3181 10575 261 3.634783 9.48678363 Actinomycetota bacterium 2900548 Bacteria Bacteria 53.5 3.93e-6   NR MEY2634385.1 2900548 g10311 i0 62.5 1.64367816091954 48 18 55.2 0 260 117 160 207 MEY2634385.1 hypothetical protein [Actinomycetota bacterium] diamond 429 53.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31613515 31613515 PRJEB3181_P_NODE_21056_length_178_cov_2.251701_g20792_i0 PRJEB3181 21056 178 2.251701 4.00802778 Catenulispora acidiphila 304895 Bacteria Bacteria 48.1 1.98e-4   NR WP_015794835.1 304895 g20792 i0 61.1 0.606741573033708 36 14 60.7 0 7 114 560 595 WP_015794835.1 alpha-galactosidase [Catenulispora acidiphila] diamond 108 48.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Catenulisporaceae Catenulispora Catenulispora acidiphila
31929791 31929791 PRJEB3181_S_NODE_14117_length_172_cov_2.321168_g13824_i0 PRJEB3181 14117 172 2.321168 3.99240896 Microbacterium sp. LRZ72 2942481 Bacteria Bacteria 60.8 8.41e-10   NR WP_319035189.1 2942481 g13824 i0 72.2 3.73255813953488 36 10 62.8 0 3 110 112 147 WP_319035189.1 50S ribosomal protein L13 [Microbacterium sp. LRZ72] diamond 642 60.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. LRZ72
31954845 31954845 PRJEB3181_P_NODE_16697_length_204_cov_2.554913_g16433_i0 PRJEB3181 16697 204 2.554913 5.21202252 FCB group 1783270 Bacteria Bacteria 46.6 9.55e-4   NR MFD1046374.1 1497396 g16433 i0 45.5 4.58823529411765 44 24 64.7 0 194 63 378 421 MFD1046374.1 RICIN domain-containing protein [Kibdelosporangium lantanae] diamond 936 47 0.991489361702128 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Kibdelosporangium Kibdelosporangium lantanae

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