RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA854078" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA854078 · 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
2117075 2117075 PRJNA854078_P_NODE_15742_length_244_cov_0.900585_g15530_i0 PRJNA854078 15742 244 0.900585 2.1974274 Abyssicoccus albus 1817405 Bacteria Bacteria 407 4.08e-109   NTclustered gi|1142909432|gb|CP019573.1| 1817405 g15530 i0 96.721 1 244 8 100 0 1 244 750843 751086 Abyssicoccus albus strain S31 chromosome, complete genome blastn 244 407 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Abyssicoccaceae Abyssicoccus Abyssicoccus albus
5062818 5062818 PRJNA854078_P_NODE_10524_length_290_cov_1.373272_g10312_i0 PRJNA854078 10524 290 1.373272 3.9824888 Bacillaceae 186817 Bacteria Bacteria 536 6.079999999999999e-148   NTclustered gi|1893059056|gb|CP060137.1| 2760090 g10312 i0 100 935.641379310345 290 0 100 0 1 290 915390 915679 Bacillus sp. PAMC26568 chromosome, complete genome blastn 271336 536 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. PAMC26568
23793923 23793923 PRJNA854078_P_NODE_3899_length_482_cov_1.264059_g3687_i0 PRJNA854078 3899 482 1.264059 6.09276438 Floricoccus penangensis 1859475 Bacteria Bacteria 56.5 0.004   NTclustered gi|2252512656|gb|CP075561.1| 1859475 g3687 i0 100 0.0622406639004149 30 0 6 0 20 49 1589670 1589699 Floricoccus penangensis strain ML061-4 chromosome, complete genome blastn 30 56.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Floricoccus Floricoccus penangensis
26651486 26651486 PRJNA854078_P_NODE_8161_length_329_cov_2.160156_g7949_i0 PRJNA854078 8161 329 2.160156 7.10691324 PVC group 1783257 Bacteria Bacteria 68.6 8.13e-11   NR MBQ6498126.1 1903720 g7949 i0 41 12.209726443769 78 46 71.1 0 56 289 293 370 MBQ6498126.1 hypothetical protein [Bacilli bacterium] diamond 4017 68.6 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
27750263 27750263 PRJNA854078_P_NODE_5344_length_410_cov_0.913947_g5132_i0 PRJNA854078 5344 410 0.913947 3.7471827 Jutongia huaianensis 2763668 Bacteria Bacteria 44.3 0.0414   NR WP_118679447.1 2763668 g5132 i0 25 0.731707317073171 100 70 73.2 1 409 110 12 106 WP_118679447.1 Ig-like domain-containing protein [Jutongia huaianensis] diamond 300 44.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Jutongia Jutongia huaianensis
28034341 28034341 PRJNA854078_P_NODE_2685_length_582_cov_1.603143_g2477_i0 PRJNA854078 2685 582 1.603143 9.33029226 Thermoanaerobacter sp. 1755 Bacteria Bacteria 57.8 5.54e-6   NR MBE3584943.1 1755 g2477 i0 30 0.979381443298969 190 100 97.4 7 15 581 327 484 MBE3584943.1 hypothetical protein [Thermoanaerobacter sp.] diamond 570 57.8 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacter Thermoanaerobacter sp.
28823261 28823261 PRJNA854078_P_NODE_12148_length_270_cov_1.563452_g11936_i0 PRJNA854078 12148 270 1.563452 4.2213204 Eubacteriales bacterium 2831996 Bacteria Bacteria 61.6 1.15e-8   NR MFR8974575.1 2831996 g11936 i0 42.1 1.05555555555556 95 47 98.9 3 1 267 24 116 MFR8974575.1 RCC1 domain-containing protein [Eubacteriales bacterium] diamond 285 61.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
28886577 28886577 PRJNA854078_P_NODE_3808_length_487_cov_2.717391_g3596_i0 PRJNA854078 3808 487 2.717391 13.23369417 Selenomonadaceae bacterium 2652289 Bacteria Bacteria 60.5 2.69e-7   NR MBR1730363.1 2652289 g3596 i0 32.8 0.751540041067762 122 73 73.9 4 98 457 245 359 MBR1730363.1 hypothetical protein [Selenomonadaceae bacterium] diamond 366 60.5 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Selenomonadaceae   Selenomonadaceae bacterium
29013292 29013292 PRJNA854078_P_NODE_4648_length_441_cov_1.046196_g4436_i0 PRJNA854078 4648 441 1.046196 4.61372436 Paenibacillus haidiansis 1574488 Bacteria Bacteria 45.4 0.0163   NR WP_331846031.1 1574488 g4436 i0 26.8 0.659863945578231 97 69 64.6 1 439 155 52 148 WP_331846031.1 nitrate reductase molybdenum cofactor assembly chaperone [Paenibacillus haidiansis] diamond 291 45.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus haidiansis
29076288 29076288 PRJNA854078_P_NODE_16368_length_242_cov_0.911243_g16156_i0 PRJNA854078 16368 242 0.911243 2.20520806 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 43.1 0.0244   NR MCI8461668.1 1898203 g16156 i0 34.6 0.966942148760331 78 42 93 2 18 242 73 144 MCI8461668.1 hypothetical protein [Lachnospiraceae bacterium] diamond 234 43.1 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29273572 29273572 PRJNA854078_P_NODE_11649_length_276_cov_1.463054_g11437_i0 PRJNA854078 11649 276 1.463054 4.03802904 Streptococcus 1301 Bacteria Bacteria 92.4 2.46e-20   NR WP_348538382.1 1334 g11437 i0 50.5 2.02173913043478 93 44 98.9 1 276 4 78 170 WP_348538382.1 hypothetical protein [Streptococcus dysgalactiae] diamond 558 92.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
29328664 29328664 PRJNA854078_P_NODE_10209_length_294_cov_2.090498_g9997_i0 PRJNA854078 10209 294 2.090498 6.14606412 Dolosigranulum pigrum 29394 Bacteria Bacteria 43.9 0.0199   NR WP_208958025.1 29394 g9997 i0 32.6 0.969387755102041 95 55 87.8 3 33 290 70 164 WP_208958025.1 V-type ATP synthase subunit D [Dolosigranulum pigrum] diamond 285 43.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Dolosigranulum Dolosigranulum pigrum
29336943 29336943 PRJNA854078_P_NODE_16249_length_242_cov_1.349112_g16037_i0 PRJNA854078 16249 242 1.349112 3.26485104 Bacillati 1783272 Bacteria Bacteria 47.8 6.15e-4   NR WP_102872125.1 33945 g16037 i0 39.4 1.5 66 36 76.9 1 237 52 212 277 WP_102872125.1 reverse transcriptase/maturase family protein [Enterococcus avium] diamond 363 47.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus avium
29494775 29494775 PRJNA854078_P_NODE_13410_length_256_cov_4.344262_g13198_i0 PRJNA854078 13410 256 4.344262 11.12131072 root 1 Root_unresolved Root_unresolved 73.6 9.98e-15   NR MFC2694777.1 1591 g13198 i0 45 1.93359375 80 44 93.8 0 1 240 8 87 MFC2694777.1 thioredoxin [Lactobacillus sp.] diamond 495 73.9 0.995940460081191 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus sp.
29991904 29991904 PRJNA854078_P_NODE_1251_length_856_cov_1.831418_g1074_i0 PRJNA854078 1251 856 1.831418 15.67693808 Paenibacillus sp. FSL R5- 58172 Bacteria Bacteria 54.7 2.96e-4   NR WP_339179303.1 2921654 g1074 i0 28.1 0.760514018691589 217 141 72.5 8 679 59 708 919 WP_339179303.1 S8 family serine peptidase [Paenibacillus sp. FSL R5-0701] diamond 651 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. FSL R5-0701
30276546 30276546 PRJNA854078_P_NODE_4652_length_440_cov_4.771117_g4440_i0 PRJNA854078 4652 440 4.771117 20.9929148 Eubacteriaceae bacterium 2049045 Bacteria Bacteria 45.8 0.0158   NR MEL7570171.1 2049045 g4440 i0 39.4 0.709090909090909 104 46 59.3 5 413 153 16 119 MEL7570171.1 hypothetical protein [Eubacteriaceae bacterium] diamond 312 45.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae   Eubacteriaceae bacterium
30442505 30442505 PRJNA854078_P_NODE_4853_length_431_cov_2.581006_g4641_i0 PRJNA854078 4853 431 2.581006 11.12413586 Bacillota 1239 Bacteria Bacteria 147 5.66e-41   NR WP_088291193.1 1405 g4641 i0 58.6 21.07656612529 116 47 80 1 430 86 127 242 WP_088291193.1 UDP-glucose 4-epimerase GalE, partial [Bacillus mycoides] diamond 9084 147 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus mycoides
30821547 30821547 PRJNA854078_P_NODE_3034_length_545_cov_1.461864_g2822_i0 PRJNA854078 3034 545 1.461864 7.9671588 Bacteria 2 Bacteria Bacteria 52.4 3.29e-4   NR WP_248758344.1 1759312 g2822 i0 33.7 3.63302752293578 104 57 57.2 1 41 352 878 969 WP_248758344.1 S-layer homology domain-containing protein [Paenibacillus sp. ATY16] diamond 1980 52.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. ATY16
31034817 31034817 PRJNA854078_P_NODE_16615_length_241_cov_0.916667_g16403_i0 PRJNA854078 16615 241 0.916667 2.20916747 Aliicoccus persicus 930138 Bacteria Bacteria 157 9.42e-46   NR HJE20105.1 930138 g16403 i0 96.3 0.995850622406639 80 3 99.6 0 241 2 53 132 HJE20105.1 hypothetical protein [Aliicoccus persicus] diamond 240 157 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Aliicoccus Aliicoccus persicus
31160515 31160515 PRJNA854078_P_NODE_16215_length_242_cov_1.810651_g16003_i0 PRJNA854078 16215 242 1.810651 4.38177542 Paenibacillus elgii 189691 Bacteria Bacteria 43.5 0.0202   NR WP_189597290.1 189691 g16003 i0 45.7 1.1404958677686 46 24 57 1 97 234 568 612 WP_189597290.1 S-layer homology domain-containing protein [Paenibacillus elgii] diamond 276 43.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus elgii
31223911 31223911 PRJNA854078_P_NODE_9715_length_302_cov_1.008734_g9503_i0 PRJNA854078 9715 302 1.008734 3.04637668 Sporosarcina sp. JAI121 2723064 Bacteria Bacteria 46.6 0.00272   NR WP_179391370.1 2723064 g9503 i0 59.5 0.814569536423841 37 15 36.8 0 222 112 19 55 WP_179391370.1 ribonuclease III [Sporosarcina sp. JAI121] diamond 246 46.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Sporosarcina Sporosarcina sp. JAI121
31413908 31413908 PRJNA854078_P_NODE_11096_length_283_cov_1.100000_g10884_i0 PRJNA854078 11096 283 1.1 3.113 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 52.8 4.52e-6   NR MDE6476014.1 2049044 g10884 i0 38.8 2.92579505300353 67 40 70 1 279 82 68 134 MDE6476014.1 ribosomal protein S18-alanine N-acetyltransferase [Erysipelotrichaceae bacterium] diamond 828 52.8 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium

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