contig_metadata
22 rows where bioproject = "PRJNA1175041" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1591112 | 1591112 | PRJNA1175041_P_NODE_103802_length_243_cov_0.894118_g100934_i0 | PRJNA1175041 | 103802 | 243 | 0.894118 | 2.17270674 | Streptococcus pasteurianus | 197614 | Bacteria | Bacteria | 449 | 6.65e-122 | NTclustered | gi|2605139866|gb|CP136943.1| | 197614 | g100934 | i0 | 100 | 22 | 243 | 0 | 100 | 0 | 1 | 243 | 831437 | 831195 | Streptococcus pasteurianus strain WUSP082 chromosome, complete genome | blastn | 5346 | 449 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus pasteurianus | ||
| 2316390 | 2316390 | PRJNA1175041_P_NODE_39102_length_553_cov_1.456250_g36248_i0 | PRJNA1175041 | 39102 | 553 | 1.45625 | 8.0530625 | Bacillus | 1386 | Bacteria | Bacteria | 1016 | 0 | NTclustered | gi|2798377728|gb|CP168764.1| | 1392 | g36248 | i0 | 99.819 | 100 | 553 | 1 | 100 | 0 | 1 | 553 | 3916615 | 3917167 | Bacillus anthracis strain Z03-J001 chromosome, complete genome | blastn | 55300 | 1016 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 6143960 | 6143960 | PRJNA1175041_P_NODE_27345_length_781_cov_1.593220_g24659_i0 | PRJNA1175041 | 27345 | 781 | 1.59322 | 12.4430482 | Bacillus | 1386 | Bacteria | Bacteria | 1432 | 0 | NTclustered | gi|2257786247|gb|CP085402.1| | 1392 | g24659 | i0 | 99.744 | 100.166453265045 | 781 | 2 | 100 | 0 | 1 | 781 | 3356875 | 3357655 | Bacillus anthracis strain CMF9 chromosome, complete genome | blastn | 78230 | 1432 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 8694047 | 8694047 | PRJNA1175041_P_NODE_50007_length_440_cov_1.408719_g47140_i0 | PRJNA1175041 | 50007 | 440 | 1.408719 | 6.1983636 | Bacillus | 1386 | Bacteria | Bacteria | 813 | 0 | NTclustered | gi|984728683|gb|CP014179.1| | 1392 | g47140 | i0 | 100 | 100 | 440 | 0 | 100 | 0 | 1 | 440 | 3948299 | 3947860 | Bacillus anthracis strain Stendal chromosome, complete genome | blastn | 44000 | 813 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 9244378 | 9244378 | PRJNA1175041_P_NODE_104108_length_242_cov_1.408284_g101240_i0 | PRJNA1175041 | 104108 | 242 | 1.408284 | 3.40804728 | Lachnospiraceae bacterium JLR.KK009 | 3114295 | Bacteria | Bacteria | 398 | 2.4299999999999994e-106 | NTclustered | gi|2692820420|gb|CP143549.1| | 3114295 | g101240 | i0 | 96.281 | 1.61157024793388 | 242 | 9 | 100 | 0 | 1 | 242 | 390155 | 389914 | Lachnospiraceae bacterium JLR.KK009 strain JLR.KK002 chromosome | blastn | 390 | 398 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium JLR.KK009 | |||
| 9969239 | 9969239 | PRJNA1175041_P_NODE_70868_length_325_cov_1.448413_g68000_i0 | PRJNA1175041 | 70868 | 325 | 1.448413 | 4.70734225 | Bacillus | 1386 | Bacteria | Bacteria | 590 | 5.2299999999999986e-164 | NTclustered | gi|2257786247|gb|CP085402.1| | 1392 | g68000 | i0 | 99.385 | 100 | 325 | 2 | 100 | 0 | 1 | 325 | 3971078 | 3971402 | Bacillus anthracis strain CMF9 chromosome, complete genome | blastn | 32500 | 590 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 12519810 | 12519810 | PRJNA1175041_P_NODE_96810_length_249_cov_0.863636_g93942_i0 | PRJNA1175041 | 96810 | 249 | 0.863636 | 2.15045364 | root | 1 | Root_unresolved | Root_unresolved | 399 | 6.989999999999999e-107 | NTclustered | gi|1796975023|gb|CP033086.1| | 1280 | g93942 | i0 | 95.582 | 99.566265060241 | 249 | 11 | 100 | 0 | 1 | 249 | 2463444 | 2463692 | Staphylococcus aureus strain WH9628 chromosome | blastn | 24792 | 399 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus aureus | ||
| 15619271 | 15619271 | PRJNA1175041_P_NODE_106713_length_240_cov_0.910180_g103845_i0 | PRJNA1175041 | 106713 | 240 | 0.91018 | 2.184432 | Streptococcus mitis | 28037 | Bacteria | Bacteria | 377 | 3.14e-100 | NTclustered | gi|2886508907|emb|OZ217344.1| | 28037 | g103845 | i0 | 95 | 100 | 240 | 12 | 100 | 0 | 1 | 240 | 785652 | 785891 | Streptococcus mitis isolate S. mitis E22 genome assembly, chromosome: 1 | blastn | 24000 | 377 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus mitis | ||
| 16343619 | 16343619 | PRJNA1175041_P_NODE_108173_length_239_cov_0.915663_g105305_i0 | PRJNA1175041 | 108173 | 239 | 0.915663 | 2.18843457 | Streptococcus | 1301 | Bacteria | Bacteria | 442 | 1.0899999999999994e-119 | NTclustered | gi|335369081|gb|CP002843.1| | 760570 | g105305 | i0 | 100 | 12.7531380753138 | 239 | 0 | 100 | 0 | 1 | 239 | 1698443 | 1698681 | Streptococcus parasanguinis ATCC 15912, complete genome | blastn | 3048 | 442 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus parasanguinis | ||
| 16893501 | 16893501 | PRJNA1175041_P_NODE_101494_length_245_cov_0.883721_g98626_i0 | PRJNA1175041 | 101494 | 245 | 0.883721 | 2.16511645 | Angelakisella sp. | 1935177 | Bacteria | Bacteria | 139 | 2.56e-36 | NR | MCI9667402.1 | 1935177 | g98626 | i0 | 96.2 | 1.91020408163265 | 79 | 3 | 96.7 | 0 | 238 | 2 | 1 | 79 | MCI9667402.1 hypothetical protein [Angelakisella sp.] | diamond | 468 | 139 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Angelakisella | Angelakisella sp. | ||
| 17618900 | 17618900 | PRJNA1175041_P_NODE_40814_length_531_cov_1.296943_g37952_i0 | PRJNA1175041 | 40814 | 531 | 1.296943 | 6.88676733 | Bacillus | 1386 | Bacteria | Bacteria | 754 | 0 | NTclustered | gi|2257786247|gb|CP085402.1| | 1392 | g37952 | i0 | 100 | 100.566854990584 | 408 | 0 | 100 | 0 | 124 | 531 | 3356178 | 3356585 | Bacillus anthracis strain CMF9 chromosome, complete genome | blastn | 53401 | 754 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 22718005 | 22718005 | PRJNA1175041_P_NODE_103818_length_243_cov_0.894118_g100950_i0 | PRJNA1175041 | 103818 | 243 | 0.894118 | 2.17270674 | Clostridia | 186801 | Bacteria | Bacteria | 438 | 1.4399999999999996e-118 | NTclustered | gi|2777750333|dbj|AP031452.1| | 39491 | g100950 | i0 | 99.177 | 20.7325102880658 | 243 | 2 | 100 | 0 | 1 | 243 | 2575854 | 2575612 | Agathobacter rectalis k41-0107-C12 DNA, complete genome | blastn | 5038 | 438 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Agathobacter | Agathobacter rectalis | ||
| 26964737 | 26964737 | PRJNA1175041_P_NODE_99382_length_247_cov_0.873563_g96514_i0 | PRJNA1175041 | 99382 | 247 | 0.873563 | 2.15770061 | Bacillati | 1783272 | Bacteria | Bacteria | 105 | 1.13e-25 | NR | WP_261197916.1 | 1423 | g96514 | i0 | 71.3 | 16.0931174089069 | 80 | 23 | 97.2 | 0 | 242 | 3 | 19 | 98 | WP_261197916.1 hypothetical protein [Bacillus subtilis] | diamond | 3975 | 105 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus subtilis | ||
| 27103675 | 27103675 | PRJNA1175041_P_NODE_99982_length_246_cov_0.878613_g97114_i0 | PRJNA1175041 | 99982 | 246 | 0.878613 | 2.16138798 | uncultured Dubosiella sp. | 1937011 | Bacteria | Bacteria | 168 | 1.63e-49 | NR | WP_289197645.1 | 1937011 | g97114 | i0 | 98.8 | 1 | 82 | 1 | 100 | 0 | 246 | 1 | 120 | 201 | WP_289197645.1 PolC-type DNA polymerase III [uncultured Dubosiella sp.] | diamond | 246 | 168 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Dubosiella | uncultured Dubosiella sp. | ||
| 27514595 | 27514595 | PRJNA1175041_P_NODE_82003_length_288_cov_1.093023_g79135_i0 | PRJNA1175041 | 82003 | 288 | 1.093023 | 3.14790624 | Eubacterium sp. | 142586 | Bacteria | Bacteria | 202 | 9.95e-63 | NR | MCI9209700.1 | 142586 | g79135 | i0 | 100 | 1 | 96 | 0 | 100 | 0 | 1 | 288 | 214 | 309 | MCI9209700.1 alpha/beta hydrolase [Eubacterium sp.] | diamond | 288 | 202 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriaceae | Eubacterium | Eubacterium sp. | ||
| 27577714 | 27577714 | PRJNA1175041_P_NODE_107804_length_239_cov_0.915663_g104936_i0 | PRJNA1175041 | 107804 | 239 | 0.915663 | 2.18843457 | Lachnospiraceae bacterium | 1898203 | Bacteria | Bacteria | 157 | 8.44e-44 | NR | MDY2789824.1 | 1898203 | g104936 | i0 | 94.9 | 6.94142259414226 | 79 | 4 | 99.2 | 0 | 2 | 238 | 285 | 363 | MDY2789824.1 amidophosphoribosyltransferase [Lachnospiraceae bacterium] | diamond | 1659 | 157 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 27798906 | 27798906 | PRJNA1175041_P_NODE_107224_length_240_cov_0.886228_g104356_i0 | PRJNA1175041 | 107224 | 240 | 0.886228 | 2.1269472 | Eubacterium sp. | 142586 | Bacteria | Bacteria | 89.4 | 3.27e-19 | NR | MCI9412796.1 | 142586 | g104356 | i0 | 73.1 | 0.65 | 52 | 14 | 65 | 0 | 3 | 158 | 250 | 301 | MCI9412796.1 restriction endonuclease [Eubacterium sp.] | diamond | 156 | 89.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriaceae | Eubacterium | Eubacterium sp. | ||
| 28619849 | 28619849 | PRJNA1175041_P_NODE_102187_length_244_cov_0.888889_g99319_i0 | PRJNA1175041 | 102187 | 244 | 0.888889 | 2.16888916 | unclassified Turicibacter | 2638206 | Bacteria | Bacteria | 67.8 | 1.6e-12 | NR | WP_262953588.1 | 2638206 | g99319 | i0 | 67.3 | 0.602459016393443 | 49 | 16 | 60.2 | 0 | 178 | 32 | 55 | 103 | WP_262953588.1 MULTISPECIES: helix-turn-helix domain-containing protein [unclassified Turicibacter] | diamond | 147 | 67.8 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Turicibacteraceae | Turicibacter | |||
| 30420088 | 30420088 | PRJNA1175041_P_NODE_96513_length_249_cov_0.863636_g93645_i0 | PRJNA1175041 | 96513 | 249 | 0.863636 | 2.15045364 | Lachnospiraceae bacterium 1 | 1898203 | Bacteria | Bacteria | 120 | 1.15e-31 | NR | EOS78106.1 | 1235800 | g93645 | i0 | 77.5 | 0.963855421686747 | 80 | 18 | 96.4 | 0 | 9 | 248 | 6 | 85 | EOS78106.1 hypothetical protein C819_00417 [Lachnospiraceae bacterium 10-1] | diamond | 240 | 120 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium 10-1 | |||
| 30862062 | 30862062 | PRJNA1175041_P_NODE_96934_length_249_cov_0.863636_g94066_i0 | PRJNA1175041 | 96934 | 249 | 0.863636 | 2.15045364 | Acetatifactor sp. | 1872090 | Bacteria | Bacteria | 166 | 1.92e-48 | NR | MFG6356014.1 | 1872090 | g94066 | i0 | 100 | 0.987951807228916 | 82 | 0 | 98.8 | 0 | 248 | 3 | 152 | 233 | MFG6356014.1 Rpn family recombination-promoting nuclease/putative transposase [Acetatifactor sp.] | diamond | 246 | 166 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Acetatifactor | Acetatifactor sp. | ||
| 31336035 | 31336035 | PRJNA1175041_P_NODE_78416_length_299_cov_1.039823_g75548_i0 | PRJNA1175041 | 78416 | 299 | 1.039823 | 3.10907077 | Fructilactobacillus sanfranciscensis | 1625 | Bacteria | Bacteria | 91.3 | 3.82e-21 | NR | POH17992.1 | 1625 | g75548 | i0 | 84.1 | 0.632107023411371 | 63 | 10 | 63.2 | 0 | 1 | 189 | 69 | 131 | POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] | diamond | 189 | 91.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Fructilactobacillus | Fructilactobacillus sanfranciscensis | ||
| 32664249 | 32664249 | PRJNA1175041_P_NODE_106680_length_240_cov_0.910180_g103812_i0 | PRJNA1175041 | 106680 | 240 | 0.91018 | 2.184432 | Dorea sp. | 2040332 | Bacteria | Bacteria | 148 | 4.56e-41 | NR | MCI8321910.1 | 2040332 | g103812 | i0 | 100 | 1 | 80 | 0 | 100 | 0 | 1 | 240 | 15 | 94 | MCI8321910.1 hypothetical protein [Dorea sp.] | diamond | 240 | 148 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Dorea | Dorea sp. |
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);;