contig_metadata
23 rows where bioproject = "PRJNA721440" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1193623 | 1193623 | PRJNA721440_S_NODE_10121_length_204_cov_1.058065_g9995_i0 | PRJNA721440 | 10121 | 204 | 1.058065 | 2.1584526 | Streptococcus | 1301 | Bacteria | Bacteria | 372 | 1.2e-98 | NTclustered | gi|2579561176|gb|CP134469.1| | 1307 | g9995 | i0 | 99.51 | 391.019607843137 | 204 | 1 | 100 | 0 | 1 | 204 | 21521 | 21724 | Streptococcus suis strain M104170_C2 chromosome, complete genome | blastn | 79768 | 372 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus suis | ||
| 1193627 | 1193627 | PRJNA721440_S_NODE_16081_length_172_cov_1.536585_g15955_i0 | PRJNA721440 | 16081 | 172 | 1.536585 | 2.6429262 | Catenibacterium | 135858 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|2299336055|gb|CP102271.1| | 100886 | g15955 | i0 | 100 | 0.348837209302326 | 30 | 0 | 17 | 0 | 113 | 142 | 577955 | 577926 | Catenibacterium mitsuokai strain DSM 15897 chromosome, complete genome | blastn | 60 | 56.5 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Coprobacillaceae | Catenibacterium | Catenibacterium mitsuokai | ||
| 1193628 | 1193628 | PRJNA721440_S_NODE_17721_length_167_cov_1.245763_g17595_i0 | PRJNA721440 | 17721 | 167 | 1.245763 | 2.08042421 | Bacillati | 1783272 | Bacteria | Bacteria | 298 | 1.63e-76 | NTclustered | gi|1176884116|gb|CP020463.1| | 1282 | g17595 | i0 | 98.802 | 496.850299401198 | 167 | 2 | 100 | 0 | 1 | 167 | 2278287 | 2278121 | Staphylococcus epidermidis strain 1457 chromosome, complete genome | blastn | 82974 | 298 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus epidermidis | ||
| 3261455 | 3261455 | PRJNA721440_S_NODE_21063_length_156_cov_3.598131_g20937_i0 | PRJNA721440 | 21063 | 156 | 3.598131 | 5.61308436 | FCB group | 1783270 | Bacteria | Bacteria | 73.6 | 5.5e-14 | NR | WP_203087144.1 | 79881 | g20937 | i0 | 59.6 | 9.88461538461539 | 52 | 21 | 100 | 0 | 156 | 1 | 24 | 75 | WP_203087144.1 PAS domain-containing protein [Alkalicoccobacillus gibsonii] | diamond | 1542 | 73.6 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Alkalicoccobacillus | Alkalicoccobacillus gibsonii | ||
| 4538520 | 4538520 | PRJNA721440_S_NODE_10004_length_205_cov_0.871795_g9878_i0 | PRJNA721440 | 10004 | 205 | 0.871795 | 1.78717975 | Lactobacillus sp. IBH004 | 2879107 | Bacteria | Bacteria | 329 | 7.39e-86 | NTclustered | gi|2426115884|gb|CP110217.2| | 2879107 | g9878 | i0 | 95.61 | 338.375609756098 | 205 | 9 | 100 | 0 | 1 | 205 | 1321156 | 1321360 | Lactobacillus sp. IBH004 chromosome, complete genome | blastn | 69367 | 329 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Lactobacillus | Lactobacillus sp. IBH004 | ||
| 6297672 | 6297672 | PRJNA721440_S_NODE_19325_length_163_cov_1.728070_g19199_i0 | PRJNA721440 | 19325 | 163 | 1.72807 | 2.8167541 | Pediococcus | 1253 | Bacteria | Bacteria | 298 | 1.58e-76 | NTclustered | gi|1035434175|gb|CP015918.1| | 1255 | g19199 | i0 | 100 | 450.398773006135 | 161 | 0 | 99 | 0 | 3 | 163 | 128686 | 128846 | Pediococcus pentosaceus strain wikim20, complete genome | blastn | 73415 | 298 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Pediococcus | Pediococcus pentosaceus | ||
| 6297677 | 6297677 | PRJNA721440_S_NODE_7385_length_229_cov_1.355556_g7259_i0 | PRJNA721440 | 7385 | 229 | 1.355556 | 3.10422324 | root | 1 | Root_unresolved | Root_unresolved | 424 | 3.76e-114 | NTclustered | gi|2556673542|gb|OR367734.1| | 1282 | g7259 | i0 | 100 | 174.991266375546 | 229 | 0 | 100 | 0 | 1 | 229 | 1410 | 1182 | Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence | blastn | 40073 | 424 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus epidermidis | ||
| 7571461 | 7571461 | PRJNA721440_S_NODE_8466_length_217_cov_3.398810_g8340_i0 | PRJNA721440 | 8466 | 217 | 3.39881 | 7.3754177 | root | 1 | Root_unresolved | Root_unresolved | 379 | 7.739999999999998e-101 | NTclustered | gi|1370563981|gb|CP027781.1| | 1491 | g8340 | i0 | 99.052 | 97.2073732718894 | 211 | 2 | 97 | 0 | 1 | 211 | 3985092 | 3985302 | Clostridium botulinum strain MAP 5 chromosome, complete genome | blastn | 21094 | 379 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium botulinum | ||
| 11397234 | 11397234 | PRJNA721440_S_NODE_4729_length_272_cov_2.376682_g4603_i0 | PRJNA721440 | 4729 | 272 | 2.376682 | 6.46457504 | Erysipelotrichales | 526525 | Bacteria | Bacteria | 62.1 | 4.15e-5 | NTclustered | gi|2777632677|dbj|AP031432.1| | 1982626 | g4603 | i0 | 97.297 | 0.544117647058823 | 37 | 0 | 13 | 1 | 27 | 62 | 1565408 | 1565444 | Faecalibacillus intestinalis i32-0019-2J8 DNA, complete genome | blastn | 148 | 62.1 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Coprobacillaceae | Faecalibacillus | Faecalibacillus intestinalis | ||
| 11397236 | 11397236 | PRJNA721440_S_NODE_6189_length_244_cov_3.769231_g6063_i0 | PRJNA721440 | 6189 | 244 | 3.769231 | 9.19692364 | root | 1 | Root_unresolved | Root_unresolved | 121 | 5.949999999999999e-23 | NTclustered | gi|1878067685|dbj|LC566215.1| | 1352 | g6063 | i0 | 93.976 | 34.4467213114754 | 83 | 0 | 32 | 4 | 161 | 239 | 128 | 47 | Enterococcus faecium EV0426-12 plasmid pIHVA-EV0426-12 DNA, complete sequence | blastn | 8405 | 122 | 0.991803278688525 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Enterococcaceae | Enterococcus | Enterococcus faecium | ||
| 12673244 | 12673244 | PRJNA721440_S_NODE_20930_length_157_cov_2.157407_g20804_i0 | PRJNA721440 | 20930 | 157 | 2.157407 | 3.38712899 | Pediococcus | 1253 | Bacteria | Bacteria | 279 | 5.46e-71 | NTclustered | gi|2811772618|gb|PQ396677.1| | 1255 | g20804 | i0 | 98.726 | 111.866242038217 | 157 | 2 | 100 | 0 | 1 | 157 | 675 | 831 | Pediococcus pentosaceus strain V9313 16S ribosomal RNA gene, partial sequence | blastn | 17563 | 279 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Pediococcus | Pediococcus pentosaceus | ||
| 13947469 | 13947469 | PRJNA721440_S_NODE_17851_length_167_cov_0.796610_g17725_i0 | PRJNA721440 | 17851 | 167 | 0.79661 | 1.3303387 | Staphylococcus | 1279 | Bacteria | Bacteria | 292 | 7.58e-75 | NTclustered | gi|1928723242|gb|CP042341.1| | 29388 | g17725 | i0 | 98.204 | 583.365269461078 | 167 | 3 | 100 | 0 | 1 | 167 | 786217 | 786051 | Staphylococcus capitis strain BN2 chromosome, complete genome | blastn | 97422 | 292 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus capitis | ||
| 15222183 | 15222183 | PRJNA721440_S_NODE_11492_length_195_cov_1.082192_g11366_i0 | PRJNA721440 | 11492 | 195 | 1.082192 | 2.1102744 | Pediococcus | 1253 | Bacteria | Bacteria | 361 | 2.46e-95 | NTclustered | gi|1035434175|gb|CP015918.1| | 1255 | g11366 | i0 | 100 | 472.676923076923 | 195 | 0 | 100 | 0 | 1 | 195 | 127266 | 127072 | Pediococcus pentosaceus strain wikim20, complete genome | blastn | 92172 | 361 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Pediococcus | Pediococcus pentosaceus | ||
| 17288175 | 17288175 | PRJNA721440_S_NODE_12614_length_188_cov_0.956835_g12488_i0 | PRJNA721440 | 12614 | 188 | 0.956835 | 1.7988498 | Staphylococcus epidermidis | 1282 | Bacteria | Bacteria | 315 | 1.8599999999999999e-81 | NTclustered | gi|2180323311|gb|CP090985.1| | 1282 | g12488 | i0 | 96.809 | 520.739361702128 | 188 | 6 | 100 | 0 | 1 | 188 | 1636913 | 1637100 | Staphylococcus epidermidis strain 50D chromosome, complete genome | blastn | 97899 | 315 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus epidermidis | ||
| 20320061 | 20320061 | PRJNA721440_S_NODE_9856_length_206_cov_1.528662_g9730_i0 | PRJNA721440 | 9856 | 206 | 1.528662 | 3.14904372 | Streptococcus | 1301 | Bacteria | Bacteria | 359 | 9.47e-95 | NTclustered | gi|1782758915|gb|CP018189.1| | 1304 | g9730 | i0 | 98.058 | 563.203883495146 | 206 | 4 | 100 | 0 | 1 | 206 | 17919 | 18124 | Streptococcus salivarius strain ICDC3 chromosome, complete genome | blastn | 116020 | 359 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus salivarius | ||
| 27589304 | 27589304 | PRJNA721440_S_NODE_5944_length_248_cov_1.743719_g5818_i0 | PRJNA721440 | 5944 | 248 | 1.743719 | 4.32442312 | Bacillota bacterium | 1879010 | Bacteria | Bacteria | 45.1 | 0.00472 | NR | MBT9153026.1 | 1879010 | g5818 | i0 | 47.1 | 0.616935483870968 | 51 | 26 | 60.5 | 1 | 202 | 53 | 32 | 82 | MBT9153026.1 Butyrate--acetoacetate CoA-transferase subunit B [Bacillota bacterium] | diamond | 153 | 45.1 | 1 | Bacteria | Bacillati | Bacillota | Bacillota bacterium | ||||||
| 28547090 | 28547090 | PRJNA721440_S_NODE_11487_length_195_cov_1.328767_g11361_i0 | PRJNA721440 | 11487 | 195 | 1.328767 | 2.59109565 | FCB group | 1783270 | Bacteria | Bacteria | 55.1 | 8.8e-7 | NR | MBP2654693.1 | 1879010 | g11361 | i0 | 42.2 | 3.86153846153846 | 64 | 37 | 98.5 | 0 | 194 | 3 | 621 | 684 | MBP2654693.1 amino acid adenylation domain protein [Bacillota bacterium] | diamond | 753 | 55.1 | 1 | Bacteria | Bacillati | Bacillota | Bacillota bacterium | ||||||
| 31632213 | 31632213 | PRJNA721440_S_NODE_1556_length_431_cov_2.900524_g1430_i0 | PRJNA721440 | 1556 | 431 | 2.900524 | 12.50125844 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 49.3 | 8.85e-5 | NR | MBQ6847602.1 | 2044939 | g1430 | i0 | 35.4 | 0.549883990719258 | 79 | 43 | 54.3 | 2 | 15 | 248 | 4 | 75 | MBQ6847602.1 acyl carrier protein [Clostridia bacterium] | diamond | 237 | 49.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 31990618 | 31990618 | PRJNA721440_S_NODE_8898_length_213_cov_2.530488_g8772_i0 | PRJNA721440 | 8898 | 213 | 2.530488 | 5.38993944 | Ructibacterium | 2884634 | Bacteria | Bacteria | 86.3 | 1.19e-17 | NR | MBQ8995572.1 | 2485925 | g8772 | i0 | 68.5 | 5.32394366197183 | 54 | 17 | 76.1 | 0 | 162 | 1 | 439 | 492 | MBQ8995572.1 ABC transporter ATP-binding protein [Oscillospiraceae bacterium] | diamond | 1134 | 86.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 32106781 | 32106781 | PRJNA721440_S_NODE_15538_length_174_cov_1.656000_g15412_i0 | PRJNA721440 | 15538 | 174 | 1.656 | 2.88144 | Anaerovoracaceae bacterium | 3030912 | Bacteria | Bacteria | 44.3 | 0.00434 | NR | MEF9921931.1 | 3030912 | g15412 | i0 | 45.1 | 2.6551724137931 | 51 | 25 | 82.8 | 1 | 28 | 171 | 293 | 343 | MEF9921931.1 HAMP domain-containing sensor histidine kinase [Anaerovoracaceae bacterium] | diamond | 462 | 44.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Anaerovoracaceae | Anaerovoracaceae bacterium | |||
| 32370606 | 32370606 | PRJNA721440_S_NODE_8519_length_217_cov_1.232143_g8393_i0 | PRJNA721440 | 8519 | 217 | 1.232143 | 2.67375031 | Bacteria | 2 | Bacteria | Bacteria | 111 | 9.039999999999999e-30 | NR | MCA9749906.1 | 1965302 | g8393 | i0 | 85.9 | 1.963133640553 | 71 | 10 | 98.2 | 0 | 3 | 215 | 32 | 102 | MCA9749906.1 F0F1 ATP synthase subunit A [Romboutsia sp.] | diamond | 426 | 111 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Peptostreptococcaceae | Romboutsia | Romboutsia sp. | ||
| 32528847 | 32528847 | PRJNA721440_S_NODE_4639_length_274_cov_3.311111_g4513_i0 | PRJNA721440 | 4639 | 274 | 3.311111 | 9.07244414 | Bacteria | 2 | Bacteria | Bacteria | 55.1 | 2.49e-6 | NR | MCI8599263.1 | 1898203 | g4513 | i0 | 47.5 | 3.47080291970803 | 61 | 30 | 66.8 | 2 | 274 | 92 | 131 | 189 | MCI8599263.1 VWA domain-containing protein [Lachnospiraceae bacterium] | diamond | 951 | 55.5 | 0.992792792792793 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 32896093 | 32896093 | PRJNA721440_S_NODE_15260_length_175_cov_2.365079_g15134_i0 | PRJNA721440 | 15260 | 175 | 2.365079 | 4.13888825 | Sporolactobacillus sp. STSJ-5 | 2965076 | Bacteria | Bacteria | 41.6 | 0.0299 | NR | WP_255746576.1 | 2965076 | g15134 | i0 | 37.7 | 0.908571428571429 | 53 | 33 | 90.9 | 0 | 163 | 5 | 8 | 60 | WP_255746576.1 hypothetical protein [Sporolactobacillus sp. STSJ-5] | diamond | 159 | 41.6 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Sporolactobacillaceae | Sporolactobacillus | Sporolactobacillus sp. STSJ-5 |
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);;