RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11523 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
2257743 2257743 PRJEB11523_P_NODE_2802_length_304_cov_2.274510_g2724_i0 PRJEB11523 2802 304 2.27451 6.9145104 Sporomusa aerivorans 204936 Bacteria Bacteria 136 1.7999999999999998e-36   NR WP_371371377.1 204936 g2724 i0 63.2 1.875 95 35 93.8 0 286 2 179 273 WP_371371377.1 HD-GYP domain-containing protein [Sporomusa aerivorans] diamond 570 136 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Sporomusaceae Sporomusa Sporomusa aerivorans
24239691 24239691 PRJEB11523_P_NODE_7920_length_165_cov_0.879310_g7842_i0 PRJEB11523 7920 165 0.87931 1.4508615 Bacillati 1783272 Bacteria Bacteria 57.4 9.04e-8   NR WP_260052342.1 582851 g7842 i0 55.6 11.5090909090909 54 24 98.2 0 165 4 868 921 WP_260052342.1 efflux RND transporter permease subunit [Oceanobacillus sojae] diamond 1899 57.8 0.993079584775087 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Oceanobacillus Oceanobacillus sojae
26779613 26779613 PRJEB11523_P_NODE_3441_length_265_cov_2.430556_g3363_i0 PRJEB11523 3441 265 2.430556 6.4409734 Holdemania massiliensis 1468449 Bacteria Bacteria 45.4 0.00526   NR WP_020224118.1 1468449 g3363 i0 33.3 0.713207547169811 63 38 66.8 1 81 257 87 149 WP_020224118.1 DUF2075 domain-containing protein [Holdemania massiliensis] diamond 189 45.4 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Holdemania Holdemania massiliensis
27032652 27032652 PRJEB11523_P_NODE_6382_length_182_cov_2.872180_g6304_i0 PRJEB11523 6382 182 2.87218 5.2273676 Clostridium omnivorum 1604902 Bacteria Bacteria 47.8 2.78e-5   NR GLC32446.1 1604902 g6304 i0 54.8 0.692307692307692 42 19 69.2 0 180 55 31 72 GLC32446.1 hypothetical protein bsdE14_38560 [Clostridium omnivorum] diamond 126 47.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium omnivorum
27222167 27222167 PRJEB11523_P_NODE_3703_length_252_cov_2.305419_g3625_i0 PRJEB11523 3703 252 2.305419 5.80965588 Firmicutes bacterium CAG:321 1263018 Bacteria Bacteria 119 2.19e-31   NR CDE39627.1 1263018 g3625 i0 65.9 2.94047619047619 82 28 97.6 0 252 7 11 92 CDE39627.1 tRNA (guanine-N(7)-)-methyltransferase [Firmicutes bacterium CAG:321] diamond 741 119 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium CAG:321
27349059 27349059 PRJEB11523_P_NODE_1823_length_409_cov_37.916667_g1745_i0 PRJEB11523 1823 409 37.916667 155.07916803 Clostridia bacterium 2044939 Bacteria Bacteria 82 2.46e-15   NR MBQ6003594.1 2044939 g1745 i0 68.5 1.68704156479218 54 17 39.6 0 386 225 294 347 MBQ6003594.1 site-specific integrase [Clostridia bacterium] diamond 690 82 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27538399 27538399 PRJEB11523_P_NODE_1204_length_535_cov_4.584362_g1127_i0 PRJEB11523 1204 535 4.584362 24.5263367 Clostridium lundense 319475 Bacteria Bacteria 175 2.48e-51   NR WP_027625775.1 319475 g1127 i0 49.1 2.77570093457944 165 84 92.5 0 534 40 22 186 WP_027625775.1 GGDEF domain-containing protein [Clostridium lundense] diamond 1485 175 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium lundense
27696492 27696492 PRJEB11523_P_NODE_5404_length_200_cov_3.715232_g5326_i0 PRJEB11523 5404 200 3.715232 7.430464 Finegoldia magna BVS 1260 Bacteria Bacteria 51.2 8.74e-7   NR EFL53913.1 866773 g5326 i0 92.6 0.405 27 2 40.5 0 176 96 25 51 EFL53913.1 hypothetical protein HMPREF9289_0820 [Finegoldia magna BVS033A4] diamond 81 51.2 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Finegoldia Finegoldia magna
27759653 27759653 PRJEB11523_P_NODE_4904_length_212_cov_11.361963_g4826_i0 PRJEB11523 4904 212 11.361963 24.08736156 Terrisporobacter sp. 1965305 Bacteria Bacteria 86.3 1.22e-18   NR WP_312286885.1 1965305 g4826 i0 73.3 0.849056603773585 60 15 84.9 1 11 190 1 59 WP_312286885.1 DNA adenine methylase [Terrisporobacter sp.] diamond 180 86.3 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Terrisporobacter Terrisporobacter sp.
28226544 28226544 PRJEB11523_P_NODE_2046_length_380_cov_26.051360_g1968_i0 PRJEB11523 2046 380 26.05136 98.995168 Clostridium 1485 Bacteria Bacteria 50.1 1.88e-4   NR WP_309449903.1 1506 g1968 i0 34 1.48421052631579 97 56 70.3 1 102 368 6 102 WP_309449903.1 GIY-YIG nuclease family protein [Clostridium sp.] diamond 564 50.4 0.994047619047619 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
28542785 28542785 PRJEB11523_P_NODE_3927_length_243_cov_4.025773_g3849_i0 PRJEB11523 3927 243 4.025773 9.78262839 Clostridium 1485 Bacteria Bacteria 94 1.11e-20   NR WP_226125244.1 198347 g3849 i0 63 2.7037037037037 73 27 90.1 0 241 23 161 233 WP_226125244.1 calcium/proton exchanger [Clostridium algoriphilum] diamond 657 94.4 0.995762711864407 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium algoriphilum
28675081 28675081 PRJEB11523_P_NODE_4487_length_223_cov_4.977011_g4409_i0 PRJEB11523 4487 223 4.977011 11.09873453 Clostridiaceae bacterium 1898204 Bacteria Bacteria 128 1.19e-32   NR HJJ13919.1 1898204 g4409 i0 91.8 0.982062780269058 73 6 98.2 0 5 223 87 159 HJJ13919.1 VanW family protein [Clostridiaceae bacterium] diamond 219 128 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
28738151 28738151 PRJEB11523_P_NODE_647_length_749_cov_2.824286_g584_i0 PRJEB11523 647 749 2.824286 21.15390214 Longicatena caecimuris 1796635 Bacteria Bacteria 191 6.71e-57   NR WP_196029330.1 1796635 g584 i0 47.4 1.61415220293725 209 97 83.7 5 648 22 1 196 WP_196029330.1 hypothetical protein [Longicatena caecimuris] diamond 1209 191 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Longicatena Longicatena caecimuris
28801094 28801094 PRJEB11523_P_NODE_4268_length_230_cov_21.756906_g4190_i0 PRJEB11523 4268 230 21.756906 50.0408838 Bacillota bacterium 1879010 Bacteria Bacteria 82 1.35e-16   NR MDI9504179.1 1879010 g4190 i0 60.3 1.77391304347826 68 27 88.7 0 206 3 71 138 MDI9504179.1 hypothetical protein [Bacillota bacterium] diamond 408 82 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
28991027 28991027 PRJEB11523_P_NODE_7888_length_165_cov_0.879310_g7810_i0 PRJEB11523 7888 165 0.87931 1.4508615 Tissierellia bacterium 2049431 Bacteria Bacteria 66.6 4.73e-11   NR NLD16363.1 2049431 g7810 i0 50 2.8 52 26 94.5 0 163 8 385 436 NLD16363.1 leucine-rich repeat domain-containing protein [Tissierellia bacterium] diamond 462 66.6 1 Bacteria   Bacillati Bacillota Tissierellia       Tissierellia bacterium
29047872 29047872 PRJEB11523_P_NODE_1668_length_435_cov_7.712435_g1590_i0 PRJEB11523 1668 435 7.712435 33.54909225 FCB group 1783270 Bacteria Bacteria 113 1.13e-26   NR WP_003869364.1 1757 g1590 i0 56.5 5.26896551724138 108 46 74.5 1 14 337 294 400 WP_003869364.1 Tm-1-like ATP-binding domain-containing protein [Thermoanaerobacter ethanolicus] diamond 2292 113 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacter Thermoanaerobacter ethanolicus
29274711 29274711 PRJEB11523_P_NODE_1929_length_394_cov_2.918841_g1851_i0 PRJEB11523 1929 394 2.918841 11.50023354 Paenibacillus sp. Soil522 1736388 Bacteria Bacteria 190 1.38e-59   NR WP_056629428.1 1736388 g1851 i0 74.6 3.83756345177665 126 31 95.9 1 17 394 8 132 WP_056629428.1 VOC family protein [Paenibacillus sp. Soil522] diamond 1512 190 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. Soil522
29426452 29426452 PRJEB11523_P_NODE_3489_length_263_cov_1.429907_g3411_i0 PRJEB11523 3489 263 1.429907 3.76065541 Anaerococcus 165779 Bacteria Bacteria 94.4 1.56e-22   NR MDU1316471.1 33029 g3411 i0 100 2.09885931558935 46 0 52.5 0 12 149 88 133 MDU1316471.1 3-dehydroquinate synthase [Anaerococcus hydrogenalis] diamond 552 94.4 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus hydrogenalis
29621719 29621719 PRJEB11523_P_NODE_2990_length_291_cov_38.623967_g2912_i0 PRJEB11523 2990 291 38.623967 112.39574397 Clostridiaceae bacterium 1898204 Bacteria Bacteria 135 3.3499999999999996e-37   NR MFA9397368.1 1898204 g2912 i0 73.6 1.80412371134021 87 23 89.7 0 5 265 36 122 MFA9397368.1 ABC transporter permease [Clostridiaceae bacterium] diamond 525 135 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
31201374 31201374 PRJEB11523_P_NODE_7915_length_165_cov_0.879310_g7837_i0 PRJEB11523 7915 165 0.87931 1.4508615 Bacillales bacterium 1904864 Bacteria Bacteria 98.6 3.1499999999999995e-23   NR HEX6923140.1 1904864 g7837 i0 76.4 1 55 13 100 0 165 1 87 141 HEX6923140.1 sporulation peptidase YabG [Bacillales bacterium] diamond 165 98.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales     Bacillales bacterium
31328235 31328235 PRJEB11523_P_NODE_5916_length_190_cov_1.843972_g5838_i0 PRJEB11523 5916 190 1.843972 3.5035468 Pelosinus propionicus 380084 Bacteria Bacteria 52 9.74e-6   NR WP_090936738.1 380084 g5838 i0 64.7 0.536842105263158 34 12 53.7 0 116 15 152 185 WP_090936738.1 chemotaxis protein CheA [Pelosinus propionicus] diamond 102 52 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Sporomusaceae Pelosinus Pelosinus propionicus
31448770 31448770 PRJEB11523_P_NODE_916_length_625_cov_3.381944_g843_i0 PRJEB11523 916 625 3.381944 21.13715 Bacillota 1239 Bacteria Bacteria 198 3.86e-58   NR WP_018662847.1 53422 g843 i0 71.8 6.648 124 35 59.5 0 607 236 90 213 WP_018662847.1 methionine gamma-lyase [Thermobrachium celere] diamond 4155 199 0.994974874371859 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Thermobrachium Thermobrachium celere
31454882 31454882 PRJEB11523_P_NODE_1396_length_486_cov_61.798627_g1318_i0 PRJEB11523 1396 486 61.798627 300.34132722 Clostridium algidicarnis 37659 Bacteria Bacteria 173 1.11e-46   NR WP_216101233.1 37659 g1318 i0 58.3 0.962962962962963 156 65 96.3 0 19 486 470 625 WP_216101233.1 LPXTG cell wall anchor domain-containing protein [Clostridium algidicarnis] diamond 468 173 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium algidicarnis
31612966 31612966 PRJEB11523_P_NODE_6836_length_175_cov_12.722222_g6758_i0 PRJEB11523 6836 175 12.722222 22.2638885 Salipaludibacillus sp. CUR1 2820003 Bacteria Bacteria 43.9 0.00549   NR WP_230896641.1 2820003 g6758 i0 42.9 0.84 49 28 84 0 24 170 10 58 WP_230896641.1 HNH endonuclease [Salipaludibacillus sp. CUR1] diamond 147 43.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Salipaludibacillus Salipaludibacillus sp. CUR1
31707828 31707828 PRJEB11523_P_NODE_5617_length_196_cov_1.938776_g5539_i0 PRJEB11523 5617 196 1.938776 3.80000096 Firmicutes bacterium ADurb.BinA 1879010 Bacteria Bacteria 67 5.31e-11   NR OPZ50953.1 1852896 g5539 i0 54.2 0.903061224489796 59 27 90.3 0 9 185 332 390 OPZ50953.1 MAG: DNA polymerase I [Firmicutes bacterium ADurb.BinA052] diamond 177 67 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium ADurb.BinA052
31891512 31891512 PRJEB11523_P_NODE_5737_length_194_cov_1.268966_g5659_i0 PRJEB11523 5737 194 1.268966 2.46179404 Bacteria 2 Bacteria Bacteria 50.1 5.06e-5   NR EEG29360.1 537013 g5659 i0 51.4 2.22680412371134 35 17 54.1 0 191 87 512 546 EEG29360.1 hypothetical protein CLOSTMETH_03010 [[Clostridium] methylpentosum DSM 5476] diamond 432 50.4 0.994047619047619 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   [Clostridium] methylpentosum
32055789 32055789 PRJEB11523_P_NODE_1338_length_498_cov_26.220490_g1260_i0 PRJEB11523 1338 498 26.22049 130.5780402 Ruminococcus sp. 41978 Bacteria Bacteria 58.9 2.11e-7   NR WP_330225736.1 41978 g1260 i0 37.9 0.524096385542169 87 47 48.2 2 442 203 51 137 WP_330225736.1 hypothetical protein, partial [Ruminococcus sp.] diamond 261 58.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
32246020 32246020 PRJEB11523_P_NODE_4578_length_220_cov_7.327485_g4500_i0 PRJEB11523 4578 220 7.327485 16.120467 Anaerovoracaceae bacterium 3030912 Bacteria Bacteria 42.7 0.024   NR MFR7989412.1 3030912 g4500 i0 37.9 0.9 66 36 90 1 218 21 168 228 MFR7989412.1 pyruvate formate-lyase-activating protein [Anaerovoracaceae bacterium] diamond 198 42.7 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   Anaerovoracaceae bacterium
32309315 32309315 PRJEB11523_P_NODE_2299_length_351_cov_1.509934_g2221_i0 PRJEB11523 2299 351 1.509934 5.29986834 Priestia flexa 86664 Bacteria Bacteria 43.1 0.0184   NR WP_253346706.1 86664 g2221 i0 38.2 0.64957264957265 76 45 65 1 260 33 1 74 WP_253346706.1 replicative helicase loader/inhibitor [Priestia flexa] diamond 228 43.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia flexa
32562382 32562382 PRJEB11523_P_NODE_2159_length_366_cov_3.239748_g2081_i0 PRJEB11523 2159 366 3.239748 11.85747768 Paenibacillus xylanexedens 528191 Bacteria Bacteria 58.9 5.16e-9   NR WP_222128603.1 528191 g2081 i0 66.7 0.319672131147541 39 13 32 0 351 235 11 49 WP_222128603.1 hypothetical protein [Paenibacillus xylanexedens] diamond 117 58.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus xylanexedens
32656236 32656236 PRJEB11523_P_NODE_7540_length_167_cov_0.864407_g7462_i0 PRJEB11523 7540 167 0.864407 1.44355969 Listeria monocytogenes 1639 Bacteria Bacteria 119 1.14e-33   NR MBN9981032.1 1639 g7462 i0 98.2 0.988023952095808 55 1 98.8 0 167 3 22 76 MBN9981032.1 SMP-30/gluconolactonase/LRE family protein [Listeria monocytogenes] diamond 165 119 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32687932 32687932 PRJEB11523_P_NODE_400_length_950_cov_65.003330_g344_i0 PRJEB11523 400 950 65.00333 617.531635 Paenisporosarcina sp. 1932001 Bacteria Bacteria 418 1.02e-140   NR MET0787083.1 1932001 g344 i0 64.4 1.88842105263158 295 102 93.2 3 931 47 55 346 MET0787083.1 terminase family protein [Paenisporosarcina sp.] diamond 1794 418 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Paenisporosarcina Paenisporosarcina sp.

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