contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA561212" and tax_phylum = "Bacillota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5649302 | 5649302 | PRJNA561212_P_NODE_3685_length_576_cov_2.658052_g3478_i0 | PRJNA561212 | 3685 | 576 | 2.658052 | 15.31037952 | Pseudogracilibacillus sp. | 1968904 | Bacteria | Bacteria | 194 | 1e-56 | NR | HLS23378.1 | 1968904 | g3478 | i0 | 58.8 | 10.671875 | 170 | 64 | 88.5 | 4 | 517 | 8 | 6 | 169 | HLS23378.1 acyl-CoA dehydrogenase [Pseudogracilibacillus sp.] | diamond | 6147 | 194 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Pseudogracilibacillus | Pseudogracilibacillus sp. | ||
| 5649321 | 5649321 | PRJNA561212_P_NODE_4745_length_509_cov_1.474771_g4536_i0 | PRJNA561212 | 4745 | 509 | 1.474771 | 7.50658439 | Bacillati | 1783272 | Bacteria | Bacteria | 180 | 1.3e-52 | NR | WP_257348982.1 | 163879 | g4536 | i0 | 52.7 | 38.139489194499 | 150 | 55 | 88.4 | 2 | 495 | 46 | 127 | 260 | WP_257348982.1 formylglycine-generating enzyme family protein [Pseudalkalibacillus decolorationis] | diamond | 19413 | 180 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Fictibacillaceae | Pseudalkalibacillus | Pseudalkalibacillus decolorationis | ||
| 18397297 | 18397297 | PRJNA561212_P_NODE_21175_length_251_cov_0.882022_g20964_i0 | PRJNA561212 | 21175 | 251 | 0.882022 | 2.21387522 | Halanaerobiales bacterium | 2094029 | Bacteria | Bacteria | 119 | 3.4800000000000003e-29 | NR | MBS3812162.1 | 2094029 | g20964 | i0 | 86.4 | 0.788844621513944 | 66 | 9 | 78.9 | 0 | 44 | 241 | 150 | 215 | MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] | diamond | 198 | 119 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiales bacterium | ||||
| 23497698 | 23497698 | PRJNA561212_P_NODE_16959_length_275_cov_1.806931_g16748_i0 | PRJNA561212 | 16959 | 275 | 1.806931 | 4.96906025 | Clostridium fallax | 1533 | Bacteria | Bacteria | 76.3 | 1.82e-15 | NR | WP_111944842.1 | 1533 | g16748 | i0 | 63.3 | 0.534545454545455 | 49 | 18 | 53.5 | 0 | 127 | 273 | 52 | 100 | WP_111944842.1 CoA-binding protein [Clostridium fallax] | diamond | 147 | 76.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium fallax | ||
| 24771495 | 24771495 | PRJNA561212_P_NODE_10460_length_342_cov_0.802974_g10249_i0 | PRJNA561212 | 10460 | 342 | 0.802974 | 2.74617108 | Paenibacillus | 44249 | Bacteria | Bacteria | 88.2 | 1.41e-17 | NR | WP_036667073.1 | 1449062 | g10249 | i0 | 41.4 | 8.06140350877193 | 116 | 57 | 97.4 | 4 | 2 | 334 | 223 | 332 | WP_036667073.1 S8 family serine peptidase [Paenibacillus sp. UNC217MF] | diamond | 2757 | 88.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus sp. UNC217MF | ||
| 26840147 | 26840147 | PRJNA561212_P_NODE_16101_length_282_cov_0.832536_g15890_i0 | PRJNA561212 | 16101 | 282 | 0.832536 | 2.34775152 | Bacteria | 2 | Bacteria | Bacteria | 118 | 1.45e-28 | NR | MCI9021244.1 | 142586 | g15890 | i0 | 57.6 | 7.76595744680851 | 92 | 39 | 97.9 | 0 | 280 | 5 | 38 | 129 | MCI9021244.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Eubacterium sp.] | diamond | 2190 | 119 | 0.991596638655462 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriaceae | Eubacterium | Eubacterium sp. | ||
| 26952377 | 26952377 | PRJNA561212_P_NODE_382_length_1565_cov_2.332440_g305_i0 | PRJNA561212 | 382 | 1565 | 2.33244 | 36.502686 | Clostridium cavendishii | 349931 | Bacteria | Bacteria | 49.7 | 0.0232 | NR | WP_159433218.1 | 349931 | g305 | i0 | 33.1 | 0.576996805111821 | 148 | 68 | 26.1 | 6 | 1188 | 781 | 165 | 293 | WP_159433218.1 patatin-like phospholipase family protein [Clostridium cavendishii] | diamond | 903 | 49.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium cavendishii | ||
| 27395384 | 27395384 | PRJNA561212_P_NODE_583_length_1331_cov_4.757552_g478_i0 | PRJNA561212 | 583 | 1331 | 4.757552 | 63.32301712 | Lysinibacillus sphaericus | 1421 | Bacteria | Bacteria | 66.6 | 2.54e-8 | NR | WP_197140054.1 | 1421 | g478 | i0 | 52.5 | 0.340345604808415 | 59 | 28 | 13.3 | 0 | 668 | 492 | 184 | 242 | WP_197140054.1 AP2 domain-containing protein [Lysinibacillus sphaericus] | diamond | 453 | 66.6 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Lysinibacillus | Lysinibacillus sphaericus | ||
| 27472334 | 27472334 | PRJNA561212_P_NODE_21963_length_250_cov_0.881356_g21752_i0 | PRJNA561212 | 21963 | 250 | 0.881356 | 2.20339 | Bacillati | 1783272 | Bacteria | Bacteria | 44.3 | 0.00504 | NR | MCI8692924.1 | 1898203 | g21752 | i0 | 41.3 | 4.188 | 46 | 27 | 55.2 | 0 | 80 | 217 | 81 | 126 | MCI8692924.1 zinc ribbon domain-containing protein [Lachnospiraceae bacterium] | diamond | 1047 | 44.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 27472337 | 27472337 | PRJNA561212_P_NODE_5863_length_456_cov_1.720627_g5652_i0 | PRJNA561212 | 5863 | 456 | 1.720627 | 7.84605912 | Candidatus Avimonas | 2720801 | Bacteria | Bacteria | 89.4 | 2.11e-17 | NR | HHV51481.1 | 1898207 | g5652 | i0 | 38.1 | 2.65789473684211 | 134 | 69 | 88.2 | 3 | 415 | 14 | 432 | 551 | HHV51481.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Clostridiales bacterium] | diamond | 1212 | 89.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiales bacterium | ||||
| 27616303 | 27616303 | PRJNA561212_P_NODE_3504_length_590_cov_1.050290_g3298_i0 | PRJNA561212 | 3504 | 590 | 1.05029 | 6.196711 | Eubacterium nodatum ATCC 33 | 35518 | Bacteria | Bacteria | 127 | 4.35e-34 | NR | ETK00367.1 | 1161902 | g3298 | i0 | 52.7 | 1.99830508474576 | 131 | 52 | 65.6 | 3 | 501 | 115 | 2 | 124 | ETK00367.1 reactive intermediate/imine deaminase [Eubacterium nodatum ATCC 33099] | diamond | 1179 | 127 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Anaerovoracaceae | [Eubacterium] nodatum | |||
| 27900159 | 27900159 | PRJNA561212_P_NODE_22085_length_249_cov_1.607955_g21874_i0 | PRJNA561212 | 22085 | 249 | 1.607955 | 4.00380795 | Psychrobacillus sp. FSL K6-2843 | 2921549 | Bacteria | Bacteria | 46.2 | 0.00244 | NR | WP_151109276.1 | 2921549 | g21874 | i0 | 31.9 | 0.867469879518072 | 72 | 46 | 86.7 | 1 | 231 | 16 | 284 | 352 | WP_151109276.1 metallophosphoesterase family protein [Psychrobacillus sp. FSL K6-2843] | diamond | 216 | 46.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Psychrobacillus | Psychrobacillus sp. FSL K6-2843 | ||
| 28595116 | 28595116 | PRJNA561212_P_NODE_10247_length_345_cov_0.966912_g10036_i0 | PRJNA561212 | 10247 | 345 | 0.966912 | 3.3358464 | Lacrimispora sp. | 2719234 | Bacteria | Bacteria | 47.4 | 0.00261 | NR | WP_312448477.1 | 2719234 | g10036 | i0 | 59 | 0.339130434782609 | 39 | 15 | 33.9 | 1 | 104 | 220 | 89 | 126 | WP_312448477.1 hypothetical protein [Lacrimispora sp.] | diamond | 117 | 47.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lacrimispora | Lacrimispora sp. | ||
| 28847414 | 28847414 | PRJNA561212_P_NODE_2688_length_670_cov_2.765494_g2483_i0 | PRJNA561212 | 2688 | 670 | 2.765494 | 18.5288098 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 135 | 2.48e-32 | NR | MDD4110734.1 | 2044939 | g2483 | i0 | 37.5 | 3.24179104477612 | 240 | 116 | 98.5 | 4 | 668 | 9 | 88 | 313 | MDD4110734.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Clostridia bacterium] | diamond | 2172 | 135 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 29131910 | 29131910 | PRJNA561212_P_NODE_22869_length_248_cov_0.891429_g22658_i0 | PRJNA561212 | 22869 | 248 | 0.891429 | 2.21074392 | Oscillospiraceae bacterium | 2485925 | Bacteria | Bacteria | 85.5 | 8.32e-18 | NR | MCH5185881.1 | 2485925 | g22658 | i0 | 53.2 | 1.83870967741935 | 79 | 32 | 95.6 | 1 | 244 | 8 | 174 | 247 | MCH5185881.1 peptide chain release factor N(5)-glutamine methyltransferase [Oscillospiraceae bacterium] | diamond | 456 | 85.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 29384418 | 29384418 | PRJNA561212_P_NODE_21609_length_250_cov_1.463277_g21398_i0 | PRJNA561212 | 21609 | 250 | 1.463277 | 3.6581925 | Bacilli bacterium | 1903720 | Bacteria | Bacteria | 140 | 1.34e-37 | NR | MBE3102865.1 | 1903720 | g21398 | i0 | 87 | 0.924 | 77 | 10 | 92.4 | 0 | 231 | 1 | 68 | 144 | MBE3102865.1 hypothetical protein [Bacilli bacterium] | diamond | 231 | 140 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacilli bacterium | |||||
| 29952710 | 29952710 | PRJNA561212_P_NODE_9671_length_354_cov_1.701068_g9460_i0 | PRJNA561212 | 9671 | 354 | 1.701068 | 6.02178072 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 64.7 | 1.23e-9 | NR | MDO5112239.1 | 2044939 | g9460 | i0 | 47 | 0.703389830508475 | 83 | 37 | 70.3 | 2 | 278 | 30 | 2 | 77 | MDO5112239.1 ParA family protein [Clostridia bacterium] | diamond | 249 | 64.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 30282976 | 30282976 | PRJNA561212_P_NODE_21372_length_251_cov_0.876404_g21161_i0 | PRJNA561212 | 21372 | 251 | 0.876404 | 2.19977404 | Paraclostridium | 1849822 | Bacteria | Bacteria | 100 | 3.55e-24 | NR | WP_373598596.1 | 1490 | g21161 | i0 | 56.4 | 1.87649402390438 | 78 | 34 | 93.2 | 0 | 246 | 13 | 6 | 83 | WP_373598596.1 hypothetical protein [Paraclostridium bifermentans] | diamond | 471 | 100 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Peptostreptococcaceae | Paraclostridium | Paraclostridium bifermentans | ||
| 30332362 | 30332362 | PRJNA561212_P_NODE_25012_length_244_cov_0.912281_g24801_i0 | PRJNA561212 | 25012 | 244 | 0.912281 | 2.22596564 | Eubacteriales bacterium | 2831996 | Bacteria | Bacteria | 66.2 | 8.32e-11 | NR | MDD4564165.1 | 2831996 | g24801 | i0 | 50 | 1.86885245901639 | 78 | 38 | 95.9 | 1 | 242 | 9 | 28 | 104 | MDD4564165.1 CatB-related O-acetyltransferase [Eubacteriales bacterium] | diamond | 456 | 66.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriales bacterium | ||||
| 30395452 | 30395452 | PRJNA561212_P_NODE_13533_length_304_cov_1.060606_g13322_i0 | PRJNA561212 | 13533 | 304 | 1.060606 | 3.22424224 | Symbiobacteriaceae bacterium | 2602712 | Bacteria | Bacteria | 50.4 | 1.55e-4 | NR | MCL2497126.1 | 2602712 | g13322 | i0 | 50.8 | 1.16447368421053 | 59 | 25 | 58.2 | 2 | 17 | 193 | 337 | 391 | MCL2497126.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Symbiobacteriaceae bacterium] | diamond | 354 | 50.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Symbiobacteriaceae | Symbiobacteriaceae bacterium | |||
| 30566646 | 30566646 | PRJNA561212_P_NODE_1213_length_978_cov_1.567956_g1050_i0 | PRJNA561212 | 1213 | 978 | 1.567956 | 15.33460968 | PVC group | 1783257 | Bacteria | Bacteria | 64.7 | 2e-8 | NR | WP_251525362.1 | 152268 | g1050 | i0 | 57.4 | 0.723926380368098 | 54 | 23 | 16.6 | 0 | 284 | 123 | 121 | 174 | WP_251525362.1 AP2 domain-containing protein [Metabacillus litoralis] | diamond | 708 | 64.7 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Metabacillus | Metabacillus litoralis | ||
| 30805819 | 30805819 | PRJNA561212_P_NODE_17114_length_274_cov_1.467662_g16903_i0 | PRJNA561212 | 17114 | 274 | 1.467662 | 4.02139388 | Bacillota bacterium | 1879010 | Bacteria | Bacteria | 133 | 3.0599999999999997e-35 | NR | MEW6274786.1 | 1879010 | g16903 | i0 | 68.6 | 3.73357664233577 | 86 | 27 | 94.2 | 0 | 265 | 8 | 183 | 268 | MEW6274786.1 aminotransferase class V-fold PLP-dependent enzyme [Bacillota bacterium] | diamond | 1023 | 133 | 1 | Bacteria | Bacillati | Bacillota | Bacillota bacterium | ||||||
| 30837380 | 30837380 | PRJNA561212_P_NODE_18354_length_265_cov_1.494792_g18143_i0 | PRJNA561212 | 18354 | 265 | 1.494792 | 3.9611988 | Phascolarctobacterium sp. | 2049039 | Bacteria | Bacteria | 78.6 | 6.72e-15 | NR | MBO5168642.1 | 2049039 | g18143 | i0 | 60 | 0.566037735849057 | 50 | 20 | 56.6 | 0 | 6 | 155 | 284 | 333 | MBO5168642.1 UDP-glucose 4-epimerase GalE [Phascolarctobacterium sp.] | diamond | 150 | 78.6 | 1 | Bacteria | Bacillati | Bacillota | Negativicutes | Acidaminococcales | Acidaminococcaceae | Phascolarctobacterium | Phascolarctobacterium sp. | ||
| 30837382 | 30837382 | PRJNA561212_P_NODE_20114_length_253_cov_1.261111_g19903_i0 | PRJNA561212 | 20114 | 253 | 1.261111 | 3.19061083 | Paenibacillus lacisoli | 3064525 | Bacteria | Bacteria | 54.3 | 3.29e-6 | NR | WP_305023095.1 | 3064525 | g19903 | i0 | 37.2 | 2.71541501976285 | 78 | 46 | 88.9 | 1 | 233 | 9 | 1 | 78 | WP_305023095.1 phosphotransferase enzyme family protein [Paenibacillus lacisoli] | diamond | 687 | 54.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus lacisoli | ||
| 31166958 | 31166958 | PRJNA561212_P_NODE_23715_length_246_cov_0.901734_g23504_i0 | PRJNA561212 | 23715 | 246 | 0.901734 | 2.21826564 | Paenibacillus | 44249 | Bacteria | Bacteria | 52.8 | 5.43e-6 | NR | WP_090789476.1 | 1882751 | g23504 | i0 | 41.8 | 5.14634146341463 | 67 | 29 | 81.7 | 1 | 10 | 210 | 10 | 66 | WP_090789476.1 histidine phosphatase family protein [Paenibacillus sp. GP183] | diamond | 1266 | 53.1 | 0.994350282485876 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus sp. GP183 | ||
| 31469761 | 31469761 | PRJNA561212_P_NODE_8436_length_378_cov_1.360656_g8225_i0 | PRJNA561212 | 8436 | 378 | 1.360656 | 5.14327968 | Lysinibacillus sphaericus | 1421 | Bacteria | Bacteria | 63.5 | 4.15e-9 | NR | WP_197140054.1 | 1421 | g8225 | i0 | 51.8 | 1.9047619047619 | 56 | 27 | 44.4 | 0 | 209 | 376 | 184 | 239 | WP_197140054.1 AP2 domain-containing protein [Lysinibacillus sphaericus] | diamond | 720 | 63.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Lysinibacillus | Lysinibacillus sphaericus | ||
| 31578461 | 31578461 | PRJNA561212_P_NODE_11896_length_322_cov_0.855422_g11685_i0 | PRJNA561212 | 11896 | 322 | 0.855422 | 2.75445884 | Bacteria | 2 | Bacteria | Bacteria | 92 | 1.16e-19 | NR | NCC48463.1 | 2044939 | g11685 | i0 | 55.2 | 3.37267080745342 | 96 | 34 | 81.1 | 3 | 271 | 11 | 1 | 96 | NCC48463.1 peptide-methionine (S)-S-oxide reductase [Clostridia bacterium] | diamond | 1086 | 92 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 31722508 | 31722508 | PRJNA561212_P_NODE_18737_length_263_cov_0.973684_g18526_i0 | PRJNA561212 | 18737 | 263 | 0.973684 | 2.56078892 | Oscillospiraceae bacterium | 2485925 | Bacteria | Bacteria | 43.1 | 0.035 | NR | MBR4473760.1 | 2485925 | g18526 | i0 | 42.9 | 0.638783269961977 | 56 | 30 | 63.9 | 1 | 28 | 195 | 130 | 183 | MBR4473760.1 hypothetical protein [Oscillospiraceae bacterium] | diamond | 168 | 43.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 32891543 | 32891543 | PRJNA561212_P_NODE_23500_length_247_cov_0.896552_g23289_i0 | PRJNA561212 | 23500 | 247 | 0.896552 | 2.21448344 | Bacillota bacterium | 1879010 | Bacteria | Bacteria | 84 | 1.16e-16 | NR | NMB01881.1 | 1879010 | g23289 | i0 | 54.7 | 5.45344129554656 | 75 | 31 | 91.1 | 1 | 12 | 236 | 3 | 74 | NMB01881.1 2Fe-2S iron-sulfur cluster binding domain-containing protein [Bacillota bacterium] | diamond | 1347 | 84 | 1 | Bacteria | Bacillati | Bacillota | Bacillota bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;