RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1108487" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1108487 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
21890268 21890268 PRJNA1108487_P_NODE_7858_length_260_cov_1.021390_g7792_i0 PRJNA1108487 7858 260 1.02139 2.655614 Bacillati 1783272 Bacteria Bacteria 113 1.29e-30   NR OPX91280.1 1811694 g7792 i0 70.7 5.28461538461538 75 22 86.5 0 260 36 7 81 OPX91280.1 MAG: ATP synthase subunit beta [Pelotomaculum sp. PtaB.Bin117] diamond 1374 113 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfotomaculaceae Pelotomaculum Pelotomaculum sp. PtaB.Bin117
22697536 22697536 PRJNA1108487_P_NODE_1738_length_510_cov_2.318078_g1672_i0 PRJNA1108487 1738 510 2.318078 11.8221978 Bacteria 2 Bacteria Bacteria 259 4.72e-81   NR WP_069800110.1 1883407 g1672 i0 77.6 20.5058823529412 161 35 94.7 1 5 487 145 304 WP_069800110.1 malate synthase A [Tepidibacillus sp. HK-1] diamond 10458 259 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Tepidibacillus Tepidibacillus sp. HK-1
26805803 26805803 PRJNA1108487_P_NODE_7661_length_262_cov_2.201058_g7595_i0 PRJNA1108487 7661 262 2.201058 5.76677196 Paenibacillaceae 186822 Bacteria Bacteria 109 8.4e-29   NR WP_204516782.1 1125967 g7595 i0 68.5 5.90839694656489 73 23 83.6 0 40 258 2 74 WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus] diamond 1548 110 0.990909090909091 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus fulvus
26909561 26909561 PRJNA1108487_P_NODE_10682_length_244_cov_0.912281_g10616_i0 PRJNA1108487 10682 244 0.912281 2.22596564 Brevibacillus sp. HB1.3 2738842 Bacteria Bacteria 45.1 0.00541   NR WP_172142141.1 2738842 g10616 i0 35.5 1.88114754098361 76 41 83.6 1 242 39 49 124 WP_172142141.1 RCC1 domain-containing protein [Brevibacillus sp. HB1.3] diamond 459 45.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus sp. HB1.3
27194034 27194034 PRJNA1108487_P_NODE_1622_length_527_cov_1.030837_g1556_i0 PRJNA1108487 1622 527 1.030837 5.43251099 Paenibacillus mendelii 206163 Bacteria Bacteria 74.7 1.15e-12   NR WP_204821101.1 206163 g1556 i0 41.1 0.734345351043643 129 48 73.4 3 394 8 8 108 WP_204821101.1 NAD(P)H-binding protein [Paenibacillus mendelii] diamond 387 74.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus mendelii
27880274 27880274 PRJNA1108487_P_NODE_8205_length_254_cov_1.309392_g8139_i0 PRJNA1108487 8205 254 1.309392 3.32585568 Tepidibacillus 1494427 Bacteria Bacteria 42.7 0.0416   NR PZN12808.1 1879010 g8139 i0 26.8 1.57086614173228 71 49 83.9 1 237 25 21 88 PZN12808.1 MAG: 6-phospho-beta-glucosidase [Bacillota bacterium] diamond 399 43.1 0.990719257540603 Bacteria   Bacillati Bacillota         Bacillota bacterium
28543563 28543563 PRJNA1108487_P_NODE_4087_length_343_cov_1.155556_g4021_i0 PRJNA1108487 4087 343 1.155556 3.96355708 Bacillati 1783272 Bacteria Bacteria 132 1.7999999999999998e-35   NR WP_307338314.1 353224 g4021 i0 57 2.88629737609329 107 46 93.6 0 21 341 67 173 WP_307338314.1 phytanoyl-CoA dioxygenase family protein [Caldalkalibacillus uzonensis] diamond 990 132 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Caldalkalibacillus Caldalkalibacillus uzonensis
28615281 28615281 PRJNA1108487_P_NODE_8907_length_251_cov_0.876404_g8841_i0 PRJNA1108487 8907 251 0.876404 2.19977404 Clostridia bacterium 2044939 Bacteria Bacteria 77.8 1.84e-14   NR MBQ1995221.1 2044939 g8841 i0 54 3.02390438247012 63 29 75.3 0 250 62 95 157 MBQ1995221.1 beta-galactosidase [Clostridia bacterium] diamond 759 77.8 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28994373 28994373 PRJNA1108487_P_NODE_7068_length_272_cov_1.185930_g7002_i0 PRJNA1108487 7068 272 1.18593 3.2257296 Clostridium perfringens 1502 Bacteria Bacteria 44.3 0.0144   NR MDU7069709.1 1502 g7002 i0 32.4 0.783088235294118 71 45 78.3 1 269 57 32 99 MDU7069709.1 hypothetical protein [Clostridium perfringens] diamond 213 44.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
29341488 29341488 PRJNA1108487_P_NODE_4949_length_316_cov_1.925926_g4883_i0 PRJNA1108487 4949 316 1.925926 6.08592616 Bacilli bacterium 1903720 Bacteria Bacteria 130 4.65e-33   NR MBP3799570.1 1903720 g4883 i0 60 0.996835443037975 105 39 99.7 2 316 2 58 159 MBP3799570.1 dynamin family protein [Bacilli bacterium] diamond 315 130 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
29783371 29783371 PRJNA1108487_P_NODE_2611_length_420_cov_1.342939_g2545_i0 PRJNA1108487 2611 420 1.342939 5.6403438 Eubacteriales bacterium 2831996 Bacteria Bacteria 165 1.4200000000000001e-44   NR MDO4266391.1 2831996 g2545 i0 55.4 4.95 139 61 99.3 1 418 2 175 312 MDO4266391.1 glutamine synthetase III [Eubacteriales bacterium] diamond 2079 165 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
30384087 30384087 PRJNA1108487_P_NODE_11273_length_242_cov_0.923077_g11207_i0 PRJNA1108487 11273 242 0.923077 2.23384634 Gracilibacillus alcaliphilus 1401441 Bacteria Bacteria 47.4 8.29e-4   NR WP_204670683.1 1401441 g11207 i0 40.5 1.95867768595041 79 25 97.9 2 4 240 127 183 WP_204670683.1 GTP-binding protein [Gracilibacillus alcaliphilus] diamond 474 47.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Gracilibacillus Gracilibacillus alcaliphilus
30478566 30478566 PRJNA1108487_P_NODE_5073_length_313_cov_1.300000_g5007_i0 PRJNA1108487 5073 313 1.3 4.069 Brevibacillus brevis 1393 Bacteria Bacteria 42 0.023   NR WP_354142440.1 1393 g5007 i0 31.8 0.63258785942492 66 42 63.3 1 307 110 8 70 WP_354142440.1 stalk domain-containing protein [Brevibacillus brevis] diamond 198 42 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus brevis
30921004 30921004 PRJNA1108487_P_NODE_5634_length_300_cov_1.039648_g5568_i0 PRJNA1108487 5634 300 1.039648 3.118944 Marinisporobacter sp. 2018664 Bacteria Bacteria 44.3 0.0211   NR MCT4604912.1 2018664 g5568 i0 25.9 0.81 81 58 79 1 10 246 16 96 MCT4604912.1 diguanylate cyclase [Marinisporobacter sp.] diamond 243 44.3 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Thermotaleaceae Marinisporobacter Marinisporobacter sp.
31837582 31837582 PRJNA1108487_P_NODE_6257_length_287_cov_1.448598_g6191_i0 PRJNA1108487 6257 287 1.448598 4.15747626 Clostridium sp. 1506 Bacteria Bacteria 44.7 0.0114   NR MCM1111114.1 1506 g6191 i0 72.4 0.303135888501742 29 8 30.3 0 199 113 109 137 MCM1111114.1 hypothetical protein [Clostridium sp.] diamond 87 44.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
31869306 31869306 PRJNA1108487_P_NODE_4297_length_336_cov_0.889734_g4231_i0 PRJNA1108487 4297 336 0.889734 2.98950624 Paenibacillus agaridevorans 171404 Bacteria Bacteria 99 2.08e-21   NR WP_108994029.1 171404 g4231 i0 38.7 1.0625 119 65 99.1 1 335 3 144 262 WP_108994029.1 AAA family ATPase [Paenibacillus agaridevorans] diamond 357 99 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus agaridevorans
32628285 32628285 PRJNA1108487_P_NODE_6100_length_290_cov_1.359447_g6034_i0 PRJNA1108487 6100 290 1.359447 3.9423963 Ruminococcus sp. 41978 Bacteria Bacteria 47.8 0.0011   NR MBQ7999854.1 41978 g6034 i0 38.2 1.27241379310345 55 34 56.9 0 235 71 288 342 MBQ7999854.1 HAMP domain-containing histidine kinase [Ruminococcus sp.] diamond 369 47.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus 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);;