RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA661142" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA661142 · 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
7539525 7539525 PRJNA661142_P_NODE_10326_length_205_cov_1.307692_g10261_i0 PRJNA661142 10326 205 1.307692 2.6807686 Bacillales 1385 Bacteria Bacteria 138 3.08e-38   NR WP_142505271.1 910412 g10261 i0 83.8 21.7609756097561 68 11 99.5 0 1 204 134 201 WP_142505271.1 ectoine hydroxylase [Melghirimyces algeriensis] diamond 4461 138 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Melghirimyces Melghirimyces algeriensis
17739645 17739645 PRJNA661142_P_NODE_4714_length_358_cov_5.398058_g4649_i0 PRJNA661142 4714 358 5.398058 19.32504764 Bacillus benzoevorans 1456 Bacteria Bacteria 193 2.49e-60   NR WP_281391853.1 1456 g4649 i0 95.4 0.91340782122905 109 5 91.3 0 4 330 89 197 WP_281391853.1 sugar O-acetyltransferase [Bacillus benzoevorans] diamond 327 193 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus benzoevorans
27081378 27081378 PRJNA661142_P_NODE_7542_length_276_cov_2.722467_g7477_i0 PRJNA661142 7542 276 2.722467 7.51400892 Anaerococcus provencensis 938293 Bacteria Bacteria 54.3 1.6e-6   NR WP_049944467.1 938293 g7477 i0 65.8 0.826086956521739 38 13 41.3 0 224 111 1 38 WP_049944467.1 Ltp family lipoprotein [Anaerococcus provencensis] diamond 228 54.3 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus provencensis
27460759 27460759 PRJNA661142_P_NODE_10303_length_206_cov_0.974522_g10238_i0 PRJNA661142 10303 206 0.974522 2.00751532 Tuberibacillus sp. Marseille-P3662 1965358 Bacteria Bacteria 129 1.65e-34   NR WP_254901198.1 1965358 g10238 i0 92.6 0.990291262135922 68 5 99 0 204 1 186 253 WP_254901198.1 carbohydrate ABC transporter permease [Tuberibacillus sp. Marseille-P3662] diamond 204 129 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Tuberibacillus Tuberibacillus sp. Marseille-P3662
27965746 27965746 PRJNA661142_P_NODE_3865_length_398_cov_4.103152_g3801_i0 PRJNA661142 3865 398 4.103152 16.33054496 Tetzosporium hominis 2020506 Bacteria Bacteria 206 1.13e-58   NR WP_094944475.1 2020506 g3801 i0 95.1 0.92713567839196 123 6 92.7 0 371 3 525 647 WP_094944475.1 SbcC/MukB-like Walker B domain-containing protein [Tetzosporium hominis] diamond 369 206 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Tetzosporium Tetzosporium hominis
29228989 29228989 PRJNA661142_P_NODE_10709_length_191_cov_1.929577_g10644_i0 PRJNA661142 10709 191 1.929577 3.68549207 Peptoniphilus harei 54005 Bacteria Bacteria 87.4 5.2e-21   NR WP_285073990.1 54005 g10644 i0 81.4 0.926701570680628 59 3 80.1 1 155 3 1 59 WP_285073990.1 hypothetical protein [Peptoniphilus harei] diamond 177 87.4 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus harei
29291879 29291879 PRJNA661142_P_NODE_12489_length_162_cov_0.902655_g12424_i0 PRJNA661142 12489 162 0.902655 1.4623011 Clostridiales bacterium PH28_bin88 1605376 Bacteria Bacteria 84.3 1.93e-17   NR KKM11424.1 1605376 g12424 i0 71.7 1.96296296296296 53 14 96.3 1 4 159 128 180 KKM11424.1 hypothetical protein SY88_09140 [Clostridiales bacterium PH28_bin88] diamond 318 84.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium PH28_bin88
29777583 29777583 PRJNA661142_P_NODE_4151_length_383_cov_6.949102_g4086_i0 PRJNA661142 4151 383 6.949102 26.61506066 Anaerococcus 165779 Bacteria Bacteria 87.8 2.22e-19   NR WP_115595015.1 54007 g4086 i0 46.5 3.09399477806789 101 54 79.1 0 352 50 14 114 WP_115595015.1 hypothetical protein [Anaerococcus octavius] diamond 1185 88.2 0.99546485260771 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus octavius
29892034 29892034 PRJNA661142_P_NODE_10851_length_188_cov_1.100719_g10786_i0 PRJNA661142 10851 188 1.100719 2.06935172 Anoxybacteroides tepidamans 265948 Bacteria Bacteria 90.9 8.42e-21   NR WP_027409629.1 265948 g10786 i0 59.7 0.98936170212766 62 25 98.9 0 187 2 3 64 WP_027409629.1 GNAT family N-acetyltransferase [Anoxybacteroides tepidamans] diamond 186 90.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacteroides Anoxybacteroides tepidamans
29892038 29892038 PRJNA661142_P_NODE_5971_length_315_cov_7.417293_g5906_i0 PRJNA661142 5971 315 7.417293 23.36447295 uncultured Anaerococcus sp. 293428 Bacteria Bacteria 44.3 0.0251   NR WP_308655400.1 293428 g5906 i0 44.9 0.466666666666667 49 27 46.7 0 24 170 605 653 WP_308655400.1 phage tail spike protein [uncultured Anaerococcus sp.] diamond 147 44.3 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus uncultured Anaerococcus sp.
30112899 30112899 PRJNA661142_P_NODE_10792_length_189_cov_1.457143_g10727_i0 PRJNA661142 10792 189 1.457143 2.75400027 Atopostipes sp. 1872652 Bacteria Bacteria 42.7 0.0179   NR HZK23370.1 1872652 g10727 i0 95.2 0.333333333333333 21 1 33.3 0 126 188 1 21 HZK23370.1 IS1380 family transposase [Atopostipes sp.] diamond 63 42.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Atopostipes Atopostipes sp.
30239381 30239381 PRJNA661142_P_NODE_8992_length_242_cov_1.056995_g8927_i0 PRJNA661142 8992 242 1.056995 2.5579279 Bacillales bacterium 1904864 Bacteria Bacteria 76.3 6.31e-15   NR HEU5140247.1 1904864 g8927 i0 65.3 2.7396694214876 49 17 60.7 0 152 6 7 55 HEU5140247.1 CheB methylesterase domain-containing protein [Bacillales bacterium] diamond 663 76.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales     Bacillales bacterium
30409903 30409903 PRJNA661142_P_NODE_10013_length_215_cov_0.921687_g9948_i0 PRJNA661142 10013 215 0.921687 1.98162705 Bacillaceae 186817 Bacteria Bacteria 121 2.34e-30   NR WP_039234667.1 1221996 g9948 i0 81.7 10.8976744186047 71 13 99.1 0 215 3 55 125 WP_039234667.1 lysine--tRNA ligase [Bacillus thermotolerans] diamond 2343 122 0.991803278688525 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thermotolerans
30871248 30871248 PRJNA661142_P_NODE_12494_length_162_cov_0.902655_g12429_i0 PRJNA661142 12494 162 0.902655 1.4623011 Bacillota bacterium 1879010 Bacteria Bacteria 59.7 1.32e-8   NR MBT9136842.1 1879010 g12429 i0 55.6 1 54 22 100 1 162 1 505 556 MBT9136842.1 DNA topoisomerase 3 [Bacillota bacterium] diamond 162 59.7 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
31630043 31630043 PRJNA661142_P_NODE_9136_length_238_cov_1.486772_g9071_i0 PRJNA661142 9136 238 1.486772 3.53851736 Bacillales bacterium 1904864 Bacteria Bacteria 74.3 1.37e-13   NR HET7577753.1 1904864 g9071 i0 60.3 1.58823529411765 63 25 79.4 0 50 238 11 73 HET7577753.1 DMT family transporter [Bacillales bacterium] diamond 378 74.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales     Bacillales bacterium
31946164 31946164 PRJNA661142_P_NODE_11637_length_166_cov_0.871795_g11572_i0 PRJNA661142 11637 166 0.871795 1.4471797 Clostridia bacterium 2044939 Bacteria Bacteria 90.1 4.31e-22   NR HYG33282.1 2044939 g11572 i0 87.5 0.867469879518072 48 6 86.7 0 3 146 32 79 HYG33282.1 transposase domain-containing protein [Clostridia bacterium] diamond 144 90.1 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32041328 32041328 PRJNA661142_P_NODE_12558_length_162_cov_0.902655_g12493_i0 PRJNA661142 12558 162 0.902655 1.4623011 Limosilactobacillus ingluviei 148604 Bacteria Bacteria 112 1.64e-27   NR WP_019205292.1 148604 g12493 i0 100 1 54 0 100 0 162 1 436 489 WP_019205292.1 F0F1 ATP synthase subunit alpha [Limosilactobacillus ingluviei] diamond 162 112 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Limosilactobacillus Limosilactobacillus ingluviei
32116862 32116862 PRJNA661142_P_NODE_8758_length_248_cov_1.346734_g8693_i0 PRJNA661142 8758 248 1.346734 3.33990032 Bacillati 1783272 Bacteria Bacteria 52 1.25e-5   NR MCI6846949.1 2060878 g8693 i0 49 4.11290322580645 49 25 59.3 0 102 248 2 50 MCI6846949.1 TetR/AcrR family transcriptional regulator [Solobacterium sp.] diamond 1020 52 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Solobacterium Solobacterium sp.
32306915 32306915 PRJNA661142_P_NODE_11819_length_165_cov_0.879310_g11754_i0 PRJNA661142 11819 165 0.87931 1.4508615 Anaerococcus 165779 Bacteria Bacteria 112 8.559999999999999e-31   NR MDU3152735.1 33029 g11754 i0 100 4 55 0 100 0 165 1 16 70 MDU3152735.1 RNA-binding protein [Anaerococcus hydrogenalis] diamond 660 112 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus hydrogenalis
32528306 32528306 PRJNA661142_P_NODE_899_length_747_cov_70.435530_g847_i0 PRJNA661142 899 747 70.43553 526.1534091 Bacillales 1385 Bacteria Bacteria 133 7.65e-36   NR MBC1362578.1 1643 g847 i0 98.9 0.714859437751004 89 1 35.7 0 476 742 1 89 MBC1362578.1 hypothetical protein [Listeria welshimeri] diamond 534 134 0.992537313432836 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria welshimeri
32547790 32547790 PRJNA661142_P_NODE_10939_length_185_cov_1.500000_g10874_i0 PRJNA661142 10939 185 1.5 2.775 uncultured Clostridium sp. 59620 Bacteria Bacteria 77.4 1.03e-14   NR WP_304683132.1 59620 g10874 i0 80 0.72972972972973 45 9 73 0 183 49 575 619 WP_304683132.1 DEAD/DEAH box helicase family protein [uncultured Clostridium sp.] diamond 135 77.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium uncultured Clostridium sp.
32874610 32874610 PRJNA661142_P_NODE_11620_length_166_cov_0.871795_g11555_i0 PRJNA661142 11620 166 0.871795 1.4471797 Bacteria 2 Bacteria Bacteria 51.2 1.2e-5   NR MBO6158730.1 1879010 g11555 i0 49 4.46385542168675 49 25 88.6 0 15 161 182 230 MBO6158730.1 AraC family transcriptional regulator [Bacillota bacterium] diamond 741 51.6 0.992248062015504 Bacteria   Bacillati Bacillota         Bacillota 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);;