contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA898105" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13627653 | 13627653 | PRJNA898105_P_NODE_8351_length_241_cov_0.916667_g8151_i0 | PRJNA898105 | 8351 | 241 | 0.916667 | 2.20916747 | Alloiococcus otitis | 1652 | Bacteria | Bacteria | 120 | 1.27e-30 | NR | WP_003776677.1 | 1652 | g8151 | i0 | 87.5 | 0.995850622406639 | 80 | 10 | 99.6 | 0 | 1 | 240 | 64 | 143 | WP_003776677.1 molecular chaperone DnaJ [Alloiococcus otitis] | diamond | 240 | 120 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Carnobacteriaceae | Alloiococcus | Alloiococcus otitis | ||
| 18725302 | 18725302 | PRJNA898105_P_NODE_6915_length_247_cov_2.500000_g6715_i0 | PRJNA898105 | 6915 | 247 | 2.5 | 6.175 | Anaerococcus murdochii | 411577 | Bacteria | Bacteria | 141 | 1.27e-41 | NR | WP_223418707.1 | 411577 | g6715 | i0 | 94.7 | 0.910931174089069 | 75 | 4 | 91.1 | 0 | 246 | 22 | 36 | 110 | WP_223418707.1 PTS lactose/cellobiose transporter subunit IIA [Anaerococcus murdochii] | diamond | 225 | 141 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Anaerococcus | Anaerococcus murdochii | ||
| 20000452 | 20000452 | PRJNA898105_P_NODE_5916_length_254_cov_1.563536_g5716_i0 | PRJNA898105 | 5916 | 254 | 1.563536 | 3.97138144 | Urinicoccus timonensis | 2024205 | Bacteria | Bacteria | 173 | 3.9099999999999996e-48 | NR | WP_034437657.1 | 2024205 | g5716 | i0 | 100 | 0.992125984251969 | 84 | 0 | 99.2 | 0 | 3 | 254 | 803 | 886 | WP_034437657.1 preprotein translocase subunit SecA [Urinicoccus timonensis] | diamond | 252 | 173 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Urinicoccus | Urinicoccus timonensis | ||
| 20370535 | 20370535 | PRJNA898105_P_NODE_4236_length_285_cov_1.452830_g4036_i0 | PRJNA898105 | 4236 | 285 | 1.45283 | 4.1405655 | Peptoniphilus | 162289 | Bacteria | Bacteria | 164 | 4.12e-49 | NR | MDU1177054.1 | 54005 | g4036 | i0 | 94.7 | 4 | 95 | 5 | 100 | 0 | 1 | 285 | 84 | 178 | MDU1177054.1 30S ribosomal protein S3 [Peptoniphilus harei] | diamond | 1140 | 165 | 0.993939393939394 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Peptoniphilus | Peptoniphilus harei | ||
| 21275776 | 21275776 | PRJNA898105_P_NODE_3937_length_290_cov_1.317972_g3737_i0 | PRJNA898105 | 3937 | 290 | 1.317972 | 3.8221188 | root | 1 | Root_unresolved | Root_unresolved | 170 | 7.36e-48 | NR | HPT61047.1 | 1879010 | g3737 | i0 | 83.3 | 9.93103448275862 | 96 | 16 | 99.3 | 0 | 288 | 1 | 236 | 331 | HPT61047.1 terminase large subunit [Bacillota bacterium] | diamond | 2880 | 170 | 1 | Bacteria | Bacillati | Bacillota | Bacillota bacterium | ||||||
| 21275817 | 21275817 | PRJNA898105_P_NODE_7437_length_245_cov_0.895349_g7237_i0 | PRJNA898105 | 7437 | 245 | 0.895349 | 2.19360505 | Peptoniphilus lacrimalis | 33031 | Bacteria | Bacteria | 135 | 3.83e-36 | NR | WP_019035062.1 | 33031 | g7237 | i0 | 86.4 | 0.991836734693878 | 81 | 11 | 99.2 | 0 | 245 | 3 | 66 | 146 | WP_019035062.1 ATP-dependent Clp protease ATP-binding subunit ClpX [Peptoniphilus lacrimalis] | diamond | 243 | 135 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Peptoniphilus | Peptoniphilus lacrimalis | ||
| 26897669 | 26897669 | PRJNA898105_P_NODE_6361_length_250_cov_0.870056_g6161_i0 | PRJNA898105 | 6361 | 250 | 0.870056 | 2.17514 | Urinicoccus timonensis | 2024205 | Bacteria | Bacteria | 160 | 1.2299999999999996e-43 | NR | WP_099208954.1 | 2024205 | g6161 | i0 | 96.4 | 0.996 | 83 | 3 | 99.6 | 0 | 1 | 249 | 794 | 876 | WP_099208954.1 insulinase family protein [Urinicoccus timonensis] | diamond | 249 | 160 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Urinicoccus | Urinicoccus timonensis | ||
| 27118713 | 27118713 | PRJNA898105_P_NODE_5142_length_270_cov_1.045685_g4942_i0 | PRJNA898105 | 5142 | 270 | 1.045685 | 2.8233495 | Alloiococcus sp. | 1872467 | Bacteria | Bacteria | 144 | 2.1799999999999996e-41 | NR | HLQ74434.1 | 1872467 | g4942 | i0 | 89.8 | 0.977777777777778 | 88 | 9 | 97.8 | 0 | 6 | 269 | 4 | 91 | HLQ74434.1 ABC transporter permease [Alloiococcus sp.] | diamond | 264 | 144 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Carnobacteriaceae | Alloiococcus | Alloiococcus sp. | ||
| 27372139 | 27372139 | PRJNA898105_P_NODE_8163_length_242_cov_0.911243_g7963_i0 | PRJNA898105 | 8163 | 242 | 0.911243 | 2.20520806 | Alterileibacterium massiliense | 1870997 | Bacteria | Bacteria | 153 | 3.85e-46 | NR | WP_071132431.1 | 1870997 | g7963 | i0 | 98.8 | 0.991735537190083 | 80 | 1 | 99.2 | 0 | 2 | 241 | 3 | 82 | WP_071132431.1 metal-dependent transcriptional regulator [Alterileibacterium massiliense] | diamond | 240 | 153 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Anaerovoracaceae | Alterileibacterium | Alterileibacterium massiliense | ||
| 28413867 | 28413867 | PRJNA898105_P_NODE_7066_length_247_cov_0.885057_g6866_i0 | PRJNA898105 | 7066 | 247 | 0.885057 | 2.18609079 | Tissierellia bacterium | 2049431 | Bacteria | Bacteria | 73.9 | 2e-13 | NR | MDO5026771.1 | 2049431 | g6866 | i0 | 92.5 | 0.48582995951417 | 40 | 3 | 48.6 | 0 | 128 | 247 | 1 | 40 | MDO5026771.1 RNA-binding cell elongation regulator Jag/EloR [Tissierellia bacterium] | diamond | 120 | 73.9 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellia bacterium | |||||
| 28540310 | 28540310 | PRJNA898105_P_NODE_6767_length_248_cov_1.211429_g6567_i0 | PRJNA898105 | 6767 | 248 | 1.211429 | 3.00434392 | Blautia stercoris | 871664 | Bacteria | Bacteria | 127 | 3.61e-35 | NR | WP_187559071.1 | 871664 | g6567 | i0 | 100 | 0.798387096774194 | 66 | 0 | 79.8 | 0 | 248 | 51 | 121 | 186 | WP_187559071.1 signal peptidase I [Blautia stercoris] | diamond | 198 | 127 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Blautia | Blautia stercoris | ||
| 28603309 | 28603309 | PRJNA898105_P_NODE_6527_length_249_cov_1.079545_g6327_i0 | PRJNA898105 | 6527 | 249 | 1.079545 | 2.68806705 | Staphylococcus saprophyticus | 29385 | Bacteria | Bacteria | 163 | 3.2399999999999998e-46 | NR | WP_145460714.1 | 29385 | g6327 | i0 | 100 | 1 | 83 | 0 | 100 | 0 | 1 | 249 | 164 | 246 | WP_145460714.1 NAD(P)-binding domain-containing protein [Staphylococcus saprophyticus] | diamond | 249 | 163 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus saprophyticus | ||
| 28823945 | 28823945 | PRJNA898105_P_NODE_4108_length_287_cov_1.406542_g3908_i0 | PRJNA898105 | 4108 | 287 | 1.406542 | 4.03677554 | Paenibacillus lautus | 1401 | Bacteria | Bacteria | 121 | 4.649999999999999e-31 | NR | WP_251494184.1 | 1401 | g3908 | i0 | 65.5 | 1.75609756097561 | 84 | 29 | 87.8 | 0 | 35 | 286 | 27 | 110 | WP_251494184.1 hypothetical protein [Paenibacillus lautus] | diamond | 504 | 121 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus lautus | ||
| 29171675 | 29171675 | PRJNA898105_P_NODE_5549_length_262_cov_1.248677_g5349_i0 | PRJNA898105 | 5549 | 262 | 1.248677 | 3.27153374 | Evtepia sp. | 2773933 | Bacteria | Bacteria | 168 | 4.129999999999999e-48 | NR | WP_330004511.1 | 2773933 | g5349 | i0 | 97.7 | 0.99618320610687 | 87 | 2 | 99.6 | 0 | 261 | 1 | 344 | 430 | WP_330004511.1 glutamate synthase subunit beta [Evtepia sp.] | diamond | 261 | 168 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Evtepia | Evtepia sp. | |||
| 29581657 | 29581657 | PRJNA898105_P_NODE_6630_length_249_cov_0.875000_g6430_i0 | PRJNA898105 | 6630 | 249 | 0.875 | 2.17875 | Alloiococcus otitis | 1652 | Bacteria | Bacteria | 86.7 | 2.96e-18 | NR | WP_003778500.1 | 1652 | g6430 | i0 | 95.3 | 0.518072289156627 | 43 | 2 | 51.8 | 0 | 111 | 239 | 241 | 283 | WP_003778500.1 Rgg/GadR/MutR family transcriptional regulator [Alloiococcus otitis] | diamond | 129 | 86.7 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Carnobacteriaceae | Alloiococcus | Alloiococcus otitis | ||
| 29644738 | 29644738 | PRJNA898105_P_NODE_6970_length_247_cov_0.885057_g6770_i0 | PRJNA898105 | 6970 | 247 | 0.885057 | 2.18609079 | Atopostipes sp. | 1872652 | Bacteria | Bacteria | 140 | 8.389999999999999e-38 | NR | HLR91885.1 | 1872652 | g6770 | i0 | 87.8 | 0.995951417004049 | 82 | 10 | 99.6 | 0 | 246 | 1 | 10 | 91 | HLR91885.1 branched-chain amino acid transport system II carrier protein [Atopostipes sp.] | diamond | 246 | 140 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Carnobacteriaceae | Atopostipes | Atopostipes sp. | ||
| 29739606 | 29739606 | PRJNA898105_P_NODE_3850_length_292_cov_1.926941_g3650_i0 | PRJNA898105 | 3850 | 292 | 1.926941 | 5.62666772 | Ezakiella massiliensis | 1852374 | Bacteria | Bacteria | 152 | 1.03e-42 | NR | WP_075573803.1 | 1852374 | g3650 | i0 | 75 | 1.89041095890411 | 92 | 23 | 94.5 | 0 | 291 | 16 | 273 | 364 | WP_075573803.1 hypothetical protein [Ezakiella massiliensis] | diamond | 552 | 152 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Ezakiella | Ezakiella massiliensis | ||||
| 30182033 | 30182033 | PRJNA898105_P_NODE_4112_length_287_cov_1.322430_g3912_i0 | PRJNA898105 | 4112 | 287 | 1.32243 | 3.7953741 | Peptoniphilus catoniae | 1660341 | Bacteria | Bacteria | 145 | 2.88e-40 | NR | WP_138160363.1 | 1660341 | g3912 | i0 | 74.7 | 0.993031358885017 | 95 | 24 | 99.3 | 0 | 285 | 1 | 166 | 260 | WP_138160363.1 phosphoribosylformylglycinamidine cyclo-ligase [Peptoniphilus catoniae] | diamond | 285 | 145 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Peptoniphilus | Peptoniphilus catoniae | ||
| 30340655 | 30340655 | PRJNA898105_P_NODE_6832_length_248_cov_0.880000_g6632_i0 | PRJNA898105 | 6832 | 248 | 0.88 | 2.1824 | Peptoniphilus grossensis | 1465756 | Bacteria | Bacteria | 65.9 | 8.83e-12 | NR | WP_412261395.1 | 1465756 | g6632 | i0 | 97.1 | 0.423387096774194 | 35 | 1 | 42.3 | 0 | 1 | 105 | 43 | 77 | WP_412261395.1 DNA-directed RNA polymerase subunit omega [Peptoniphilus grossensis] | diamond | 105 | 65.9 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Peptoniphilus | Peptoniphilus grossensis | ||
| 30561007 | 30561007 | PRJNA898105_P_NODE_7833_length_243_cov_0.905882_g7633_i0 | PRJNA898105 | 7833 | 243 | 0.905882 | 2.20129326 | Lacicoccus qingdaonensis | 576118 | Bacteria | Bacteria | 141 | 8.54e-37 | NR | WP_092983687.1 | 576118 | g7633 | i0 | 97.5 | 0.987654320987654 | 80 | 2 | 98.8 | 0 | 2 | 241 | 296 | 375 | WP_092983687.1 chromosome segregation protein SMC [Lacicoccus qingdaonensis] | diamond | 240 | 141 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Salinicoccaceae | Lacicoccus | Lacicoccus qingdaonensis | ||
| 30624286 | 30624286 | PRJNA898105_P_NODE_5033_length_271_cov_2.484848_g4833_i0 | PRJNA898105 | 5033 | 271 | 2.484848 | 6.73393808 | Aliicoccus persicus | 930138 | Bacteria | Bacteria | 172 | 1.6999999999999998e-49 | NR | WP_091475747.1 | 930138 | g4833 | i0 | 100 | 0.996309963099631 | 90 | 0 | 99.6 | 0 | 270 | 1 | 66 | 155 | WP_091475747.1 nicotinate phosphoribosyltransferase [Aliicoccus persicus] | diamond | 270 | 172 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Aliicoccus | Aliicoccus persicus | ||
| 30853277 | 30853277 | PRJNA898105_P_NODE_8354_length_241_cov_0.916667_g8154_i0 | PRJNA898105 | 8354 | 241 | 0.916667 | 2.20916747 | Anaerococcus | 165779 | Bacteria | Bacteria | 55.5 | 1.13e-6 | NR | WP_044566626.1 | 938293 | g8154 | i0 | 46.9 | 1.20746887966805 | 49 | 26 | 61 | 0 | 241 | 95 | 302 | 350 | WP_044566626.1 hypothetical protein [Anaerococcus provencensis] | diamond | 291 | 55.5 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Anaerococcus | Anaerococcus provencensis | ||
| 31635899 | 31635899 | PRJNA898105_P_NODE_7396_length_245_cov_1.790698_g7196_i0 | PRJNA898105 | 7396 | 245 | 1.790698 | 4.3872101 | Aedoeadaptatus coli | 2058292 | Bacteria | Bacteria | 149 | 8.82e-40 | NR | WP_108830712.1 | 2058292 | g7196 | i0 | 92.6 | 0.991836734693878 | 81 | 6 | 99.2 | 0 | 3 | 245 | 247 | 327 | WP_108830712.1 transketolase [Aedoeadaptatus coli] | diamond | 243 | 149 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Aedoeadaptatus | Aedoeadaptatus coli | ||
| 31643470 | 31643470 | PRJNA898105_P_NODE_8036_length_242_cov_1.443787_g7836_i0 | PRJNA898105 | 8036 | 242 | 1.443787 | 3.49396454 | Bacillota | 1239 | Bacteria | Bacteria | 133 | 1.22e-34 | NR | HEN0393049.1 | 1311 | g7836 | i0 | 100 | 2.3801652892562 | 64 | 0 | 79.3 | 0 | 2 | 193 | 247 | 310 | HEN0393049.1 hypothetical protein [Streptococcus agalactiae] | diamond | 576 | 133 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus agalactiae | ||
| 31667520 | 31667520 | PRJNA898105_P_NODE_6357_length_250_cov_0.870056_g6157_i0 | PRJNA898105 | 6357 | 250 | 0.870056 | 2.17514 | Aliicoccus persicus | 930138 | Bacteria | Bacteria | 135 | 1.14e-36 | NR | WP_091474752.1 | 930138 | g6157 | i0 | 89 | 0.984 | 82 | 9 | 98.4 | 0 | 248 | 3 | 150 | 231 | WP_091474752.1 ABC transporter substrate-binding protein [Aliicoccus persicus] | diamond | 246 | 135 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Aliicoccus | Aliicoccus persicus | ||
| 31730741 | 31730741 | PRJNA898105_P_NODE_6137_length_251_cov_0.865169_g5937_i0 | PRJNA898105 | 6137 | 251 | 0.865169 | 2.17157419 | Peptoniphilaceae bacterium | 1891242 | Bacteria | Bacteria | 151 | 7.47e-41 | NR | MCI6660489.1 | 1891242 | g5937 | i0 | 88 | 3.9681274900398402 | 83 | 10 | 99.2 | 0 | 251 | 3 | 381 | 463 | MCI6660489.1 V-type ATP synthase subunit A [Peptoniphilaceae bacterium] | diamond | 996 | 151 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Peptoniphilaceae bacterium | |||
| 31762422 | 31762422 | PRJNA898105_P_NODE_7017_length_247_cov_0.885057_g6817_i0 | PRJNA898105 | 7017 | 247 | 0.885057 | 2.18609079 | Alloiococcus otitis | 1652 | Bacteria | Bacteria | 163 | 1.9099999999999998e-47 | NR | WP_003778570.1 | 1652 | g6817 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 2 | 247 | 132 | 213 | WP_003778570.1 NAD(P)H-dependent glycerol-3-phosphate dehydrogenase [Alloiococcus otitis] | diamond | 246 | 163 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Carnobacteriaceae | Alloiococcus | Alloiococcus otitis | ||
| 31825591 | 31825591 | PRJNA898105_P_NODE_8337_length_241_cov_0.916667_g8137_i0 | PRJNA898105 | 8337 | 241 | 0.916667 | 2.20916747 | Clostridiales bacterium | 1898207 | Bacteria | Bacteria | 172 | 4.22e-49 | NR | MCI6602839.1 | 1898207 | g8137 | i0 | 98.8 | 0.995850622406639 | 80 | 1 | 99.6 | 0 | 2 | 241 | 332 | 411 | MCI6602839.1 tryptophanase [Clostridiales bacterium] | diamond | 240 | 172 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiales bacterium | ||||
| 32836845 | 32836845 | PRJNA898105_P_NODE_4240_length_285_cov_1.448113_g4040_i0 | PRJNA898105 | 4240 | 285 | 1.448113 | 4.12712205 | Eubacteriales bacterium | 2831996 | Bacteria | Bacteria | 48.1 | 7.13e-4 | NR | MEZ4357688.1 | 2831996 | g4040 | i0 | 40.4 | 0.6 | 57 | 26 | 51.6 | 1 | 160 | 14 | 279 | 335 | MEZ4357688.1 SDR family oxidoreductase [Eubacteriales bacterium] | diamond | 171 | 48.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriales 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);;