contig_metadata
23 rows where bioproject = "PRJNA1068513", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1013639 | 1013639 | PRJNA1068513_S_NODE_6801_length_350_cov_1.783394_g6755_i0 | PRJNA1068513 | 6801 | 350 | 1.783394 | 6.241879 | Clostridium | 1485 | Bacteria | Bacteria | 52.8 | 0.033 | NTclustered | gi|2385532608|gb|CP086246.1| | 2843318 | g6755 | i0 | 100 | 0.24 | 28 | 0 | 8 | 0 | 173 | 200 | 2436613 | 2436640 | Clostridium sp. CF011 chromosome, complete genome | blastn | 84 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium sp. CF011 | ||
| 2288886 | 2288886 | PRJNA1068513_S_NODE_6602_length_355_cov_8.248227_g6556_i0 | PRJNA1068513 | 6602 | 355 | 8.248227 | 29.28120585 | Blautia | 572511 | Bacteria | Bacteria | 52.8 | 0.034 | NTclustered | gi|2884834701|gb|CP176621.1| | 1532 | g6556 | i0 | 100 | 0.552112676056338 | 28 | 0 | 8 | 0 | 100 | 127 | 1870490 | 1870463 | Blautia coccoides strain RS-04 chromosome, complete genome | blastn | 196 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Blautia | Blautia coccoides | ||
| 6116803 | 6116803 | PRJNA1068513_S_NODE_7145_length_341_cov_2.764925_g7099_i0 | PRJNA1068513 | 7145 | 341 | 2.764925 | 9.42839425 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.009 | NTclustered | gi|2702638792|gb|CP148048.1| | 33033 | g7099 | i0 | 100 | 0.859237536656892 | 29 | 0 | 9 | 0 | 152 | 180 | 1540077 | 1540105 | Parvimonas micra strain JM503A chromosome, complete genome | blastn | 293 | 54.7 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Parvimonas | Parvimonas micra | ||
| 9941752 | 9941752 | PRJNA1068513_S_NODE_11328_length_262_cov_4.571429_g11282_i0 | PRJNA1068513 | 11328 | 262 | 4.571429 | 11.97714398 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|1878067685|dbj|LC566215.1| | 1352 | g11282 | i0 | 96.97 | 12.0572519083969 | 33 | 1 | 13 | 0 | 13 | 45 | 98 | 130 | Enterococcus faecium EV0426-12 plasmid pIHVA-EV0426-12 DNA, complete sequence | blastn | 3159 | 56.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Enterococcaceae | Enterococcus | Enterococcus faecium | ||
| 11660555 | 11660555 | PRJNA1068513_S_NODE_8370_length_313_cov_2.008333_g8324_i0 | PRJNA1068513 | 8370 | 313 | 2.008333 | 6.28608229 | Clostridium beijerinckii | 1520 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|2324517193|gb|CP107022.1| | 1520 | g8324 | i0 | 94.286 | 0.335463258785943 | 35 | 1 | 11 | 1 | 197 | 230 | 3529705 | 3529739 | Clostridium beijerinckii strain CloBei18h chromosome, complete genome | blastn | 105 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium beijerinckii | ||
| 12935610 | 12935610 | PRJNA1068513_S_NODE_3071_length_494_cov_4.187648_g3026_i0 | PRJNA1068513 | 3071 | 494 | 4.187648 | 20.68698112 | Bacteria | 2 | Bacteria | Bacteria | 64.7 | 1.03e-8 | NR | WP_005489056.1 | 43595 | g3026 | i0 | 30.2 | 2.73886639676113 | 116 | 78 | 69.2 | 3 | 454 | 113 | 352 | 466 | WP_005489056.1 PLP-dependent aminotransferase family protein [Halanaerobium saccharolyticum] | diamond | 1353 | 65.1 | 0.993855606758833 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiaceae | Halanaerobium | Halanaerobium saccharolyticum | ||
| 14210540 | 14210540 | PRJNA1068513_S_NODE_2512_length_529_cov_5.885965_g2469_i0 | PRJNA1068513 | 2512 | 529 | 5.885965 | 31.13675485 | Bacillus sp. Y1 | 352858 | Bacteria | Bacteria | 54.7 | 0.014 | NTclustered | gi|1480120062|gb|CP030028.1| | 352858 | g2469 | i0 | 100 | 0.054820415879017 | 29 | 0 | 5 | 0 | 352 | 380 | 3456154 | 3456126 | Bacillus sp. Y1 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus sp. Y1 | ||
| 14210577 | 14210577 | PRJNA1068513_S_NODE_5552_length_386_cov_1.923323_g5506_i0 | PRJNA1068513 | 5552 | 386 | 1.923323 | 7.42402678 | Clostridium intestinale | 36845 | Bacteria | Bacteria | 52.8 | 0.037 | NTclustered | gi|2651387689|gb|CP121166.1| | 36845 | g5506 | i0 | 100 | 0.0725388601036269 | 28 | 0 | 7 | 0 | 30 | 57 | 1563141 | 1563114 | Clostridium intestinale strain PC17 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium intestinale | ||
| 15041312 | 15041312 | PRJNA1068513_S_NODE_5592_length_384_cov_3.758842_g5546_i0 | PRJNA1068513 | 5592 | 384 | 3.758842 | 14.43395328 | Agathobacter | 1766253 | Bacteria | Bacteria | 54.7 | 0.01 | NTclustered | gi|2202783703|gb|CP092643.1| | 39491 | g5546 | i0 | 100 | 0.309895833333333 | 29 | 0 | 8 | 0 | 7 | 35 | 552712 | 552740 | Agathobacter rectalis strain VPI 0990 chromosome, complete genome | blastn | 119 | 54.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Agathobacter | Agathobacter rectalis | ||
| 17591402 | 17591402 | PRJNA1068513_S_NODE_12894_length_246_cov_1.092486_g12848_i0 | PRJNA1068513 | 12894 | 246 | 1.092486 | 2.68751556 | Clostridium | 1485 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2031304926|gb|CP073653.1| | 1520 | g12848 | i0 | 100 | 1.0609756097561 | 29 | 0 | 12 | 0 | 211 | 239 | 5633305 | 5633277 | Clostridium beijerinckii strain DSM 791 chromosome, complete genome | blastn | 261 | 54.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium beijerinckii | ||
| 23134188 | 23134188 | PRJNA1068513_S_NODE_3239_length_485_cov_6.266990_g3194_i0 | PRJNA1068513 | 3239 | 485 | 6.26699 | 30.3949015 | root | 1 | Root_unresolved | Root_unresolved | 157 | 3.72e-46 | NR | MFG1554821.1 | 1280 | g3194 | i0 | 67.9 | 2.77113402061856 | 112 | 35 | 68.7 | 1 | 484 | 152 | 16 | 127 | MFG1554821.1 ferritin [Staphylococcus aureus] | diamond | 1344 | 158 | 0.993670886075949 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus aureus | ||
| 28069587 | 28069587 | PRJNA1068513_S_NODE_10665_length_273_cov_1.210000_g10619_i0 | PRJNA1068513 | 10665 | 273 | 1.21 | 3.3033 | Peptostreptococcus | 1257 | Bacteria | Bacteria | 90.1 | 6.5700000000000005e-21 | NR | WP_106776846.1 | 215200 | g10619 | i0 | 67.2 | 3.49450549450549 | 64 | 21 | 70.3 | 0 | 256 | 65 | 59 | 122 | WP_106776846.1 RidA family protein [Peptostreptococcus russellii] | diamond | 954 | 90.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Peptostreptococcaceae | Peptostreptococcus | Peptostreptococcus russellii | ||
| 28141397 | 28141397 | PRJNA1068513_S_NODE_10965_length_268_cov_3.200000_g10919_i0 | PRJNA1068513 | 10965 | 268 | 3.2 | 8.576 | Eubacteriales bacterium | 2831996 | Bacteria | Bacteria | 65.5 | 2.66e-10 | NR | MDD5017307.1 | 2831996 | g10919 | i0 | 56.6 | 1.73507462686567 | 53 | 23 | 59.3 | 0 | 203 | 45 | 213 | 265 | MDD5017307.1 glucose 1-dehydrogenase [Eubacteriales bacterium] | diamond | 465 | 65.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriales bacterium | ||||
| 28141410 | 28141410 | PRJNA1068513_S_NODE_4285_length_434_cov_10.216066_g4240_i0 | PRJNA1068513 | 4285 | 434 | 10.216066 | 44.33772644 | Halalkalibacterium ligniniphilum | 1134413 | Bacteria | Bacteria | 45.4 | 0.0223 | NR | WP_017726131.1 | 1134413 | g4240 | i0 | 26.7 | 0.69815668202765 | 101 | 66 | 65 | 2 | 334 | 53 | 12 | 111 | WP_017726131.1 polyphosphate polymerase domain-containing protein [Halalkalibacterium ligniniphilum] | diamond | 303 | 45.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Halalkalibacterium (ex Joshi et al. 2022) | Halalkalibacterium ligniniphilum | ||
| 28204096 | 28204096 | PRJNA1068513_S_NODE_10466_length_276_cov_1.349754_g10420_i0 | PRJNA1068513 | 10466 | 276 | 1.349754 | 3.72532104 | Massilimicrobiota sp. An134 | 1965557 | Bacteria | Bacteria | 46.2 | 0.00259 | NR | WP_087298137.1 | 1965557 | g10420 | i0 | 39.7 | 1.43478260869565 | 68 | 40 | 72.8 | 1 | 74 | 274 | 14 | 81 | WP_087298137.1 ubiquitin-like protein [Massilimicrobiota sp. An134] | diamond | 396 | 46.2 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Massilimicrobiota | Massilimicrobiota sp. An134 | ||
| 29277658 | 29277658 | PRJNA1068513_S_NODE_11829_length_255_cov_2.142857_g11783_i0 | PRJNA1068513 | 11829 | 255 | 2.142857 | 5.46428535 | Lachnospira sp. | 2049031 | Bacteria | Bacteria | 42.4 | 0.0126 | NR | MBE5964096.1 | 2049031 | g11783 | i0 | 48.6 | 0.411764705882353 | 35 | 15 | 41.2 | 1 | 97 | 201 | 59 | 90 | MBE5964096.1 hypothetical protein [Lachnospira sp.] | diamond | 105 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospira | Lachnospira sp. | ||
| 29404153 | 29404153 | PRJNA1068513_S_NODE_3149_length_490_cov_1.474820_g3104_i0 | PRJNA1068513 | 3149 | 490 | 1.47482 | 7.226618 | Soehngenia longivitae | 2562294 | Bacteria | Bacteria | 46.2 | 0.0237 | NR | WP_135271281.1 | 2562294 | g3104 | i0 | 30.4 | 0.563265306122449 | 92 | 61 | 55.7 | 2 | 354 | 82 | 80 | 169 | WP_135271281.1 dihydrolipoyl dehydrogenase [Soehngenia longivitae] | diamond | 276 | 46.2 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Tissierellaceae | Soehngenia | Soehngenia longivitae | ||
| 29561850 | 29561850 | PRJNA1068513_S_NODE_2410_length_536_cov_12.485961_g2367_i0 | PRJNA1068513 | 2410 | 536 | 12.485961 | 66.92475096 | Brevibacillus fulvus | 1125967 | Bacteria | Bacteria | 143 | 1.08e-40 | NR | WP_204516782.1 | 1125967 | g2367 | i0 | 61.1 | 3.20708955223881 | 113 | 44 | 63.2 | 0 | 437 | 99 | 2 | 114 | WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus] | diamond | 1719 | 143 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Brevibacillus | Brevibacillus fulvus | ||
| 30952138 | 30952138 | PRJNA1068513_S_NODE_10194_length_280_cov_1.115942_g10148_i0 | PRJNA1068513 | 10194 | 280 | 1.115942 | 3.1246376 | Lactobacillus nasalidis | 2797258 | Bacteria | Bacteria | 42.4 | 0.0265 | NR | WP_280515418.1 | 2797258 | g10148 | i0 | 33.8 | 0.728571428571429 | 68 | 40 | 70.7 | 2 | 4 | 201 | 26 | 90 | WP_280515418.1 sigma factor, partial [Lactobacillus nasalidis] | diamond | 204 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Lactobacillus | Lactobacillus nasalidis | ||
| 31299601 | 31299601 | PRJNA1068513_S_NODE_9635_length_289_cov_2.791667_g9589_i0 | PRJNA1068513 | 9635 | 289 | 2.791667 | 8.06791763 | Anaerorhabdus sp. | 1872524 | Bacteria | Bacteria | 43.1 | 0.0487 | NR | MFV0380139.1 | 1872524 | g9589 | i0 | 42.3 | 0.539792387543253 | 52 | 24 | 47.8 | 1 | 32 | 169 | 336 | 387 | MFV0380139.1 FtsK/SpoIIIE domain-containing protein [Anaerorhabdus sp.] | diamond | 156 | 43.1 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Anaerorhabdus | Anaerorhabdus sp. | ||
| 31679052 | 31679052 | PRJNA1068513_S_NODE_3757_length_459_cov_2.727979_g3712_i0 | PRJNA1068513 | 3757 | 459 | 2.727979 | 12.52142361 | Bacilli bacterium | 1903720 | Bacteria | Bacteria | 45.1 | 0.0453 | NR | MCR5423065.1 | 1903720 | g3712 | i0 | 30.9 | 0.633986928104575 | 97 | 64 | 61.4 | 1 | 415 | 134 | 138 | 234 | MCR5423065.1 hypothetical protein [Bacilli bacterium] | diamond | 291 | 45.1 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacilli bacterium | |||||
| 31932120 | 31932120 | PRJNA1068513_S_NODE_7577_length_330_cov_4.568093_g7531_i0 | PRJNA1068513 | 7577 | 330 | 4.568093 | 15.0747069 | Clostridium chromiireducens | 225345 | Bacteria | Bacteria | 44.3 | 0.0285 | NR | WP_079439476.1 | 225345 | g7531 | i0 | 35.6 | 0.536363636363636 | 59 | 37 | 52.7 | 1 | 322 | 149 | 135 | 193 | WP_079439476.1 elongation factor G [Clostridium chromiireducens] | diamond | 177 | 44.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium chromiireducens | ||
| 32280506 | 32280506 | PRJNA1068513_S_NODE_8659_length_307_cov_4.893162_g8613_i0 | PRJNA1068513 | 8659 | 307 | 4.893162 | 15.02200734 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 45.1 | 0.0114 | NR | MCI8965784.1 | 2044939 | g8613 | i0 | 52 | 0.488599348534202 | 50 | 24 | 48.9 | 0 | 246 | 97 | 65 | 114 | MCI8965784.1 hypothetical protein [Clostridia bacterium] | diamond | 150 | 45.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia 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);;