contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJEB10320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22659465 | 22659465 | PRJEB10320_P_NODE_7838_length_363_cov_1.335366_g7581_i0 | PRJEB10320 | 7838 | 363 | 1.335366 | 4.84737858 | Bacillales | 1385 | Bacteria | Bacteria | 137 | 7.73e-36 | NR | WP_168412441.1 | 51173 | g7581 | i0 | 58 | 4.83471074380165 | 119 | 49 | 98.3 | 1 | 361 | 5 | 220 | 337 | WP_168412441.1 aldehyde dehydrogenase [Ureibacillus thermosphaericus] | diamond | 1755 | 137 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Caryophanaceae | Ureibacillus | Ureibacillus thermosphaericus | ||
| 27506923 | 27506923 | PRJEB10320_P_NODE_9923_length_312_cov_1.429603_g9665_i0 | PRJEB10320 | 9923 | 312 | 1.429603 | 4.46036136 | Candidatus Fimenecus stercoravium | 2840817 | Bacteria | Bacteria | 44.3 | 0.0243 | NR | HIS05328.1 | 2840817 | g9665 | i0 | 33.3 | 0.663461538461538 | 69 | 45 | 66.3 | 1 | 8 | 214 | 582 | 649 | HIS05328.1 metallophosphoesterase [Candidatus Fimenecus stercoravium] | diamond | 207 | 44.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Candidatus Fimenecus | Candidatus Fimenecus stercoravium | ||||
| 27885593 | 27885593 | PRJEB10320_P_NODE_26125_length_159_cov_1.290323_g25867_i0 | PRJEB10320 | 26125 | 159 | 1.290323 | 2.05161357 | Anoxybacteroides amylolyticum | 294699 | Bacteria | Bacteria | 105 | 2.37e-26 | NR | WP_066325682.1 | 294699 | g25867 | i0 | 98.1 | 2.94339622641509 | 52 | 1 | 98.1 | 0 | 157 | 2 | 120 | 171 | WP_066325682.1 DnaD domain-containing protein [Anoxybacteroides amylolyticum] | diamond | 468 | 105 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Anoxybacillaceae | Anoxybacteroides | Anoxybacteroides amylolyticum | ||
| 28169760 | 28169760 | PRJEB10320_P_NODE_18726_length_202_cov_0.958084_g18468_i0 | PRJEB10320 | 18726 | 202 | 0.958084 | 1.93532968 | Parasporobacterium sp. | 2740533 | Bacteria | Bacteria | 42.4 | 0.0214 | NR | MCR5083670.1 | 2740533 | g18468 | i0 | 38.8 | 0.727722772277228 | 49 | 26 | 72.8 | 1 | 189 | 43 | 129 | 173 | MCR5083670.1 ECF transporter S component [Parasporobacterium sp.] | diamond | 147 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Parasporobacterium | Parasporobacterium sp. | ||
| 28226540 | 28226540 | PRJEB10320_P_NODE_17786_length_209_cov_1.580460_g17528_i0 | PRJEB10320 | 17786 | 209 | 1.58046 | 3.3031614 | Lactobacillaceae | 33958 | Bacteria | Bacteria | 44.3 | 0.00101 | NR | WP_023860568.1 | 137357 | g17528 | i0 | 39.3 | 4.62200956937799 | 56 | 33 | 78.9 | 1 | 23 | 187 | 1 | 56 | WP_023860568.1 acyl carrier protein [Ligilactobacillus equi] | diamond | 966 | 44.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Ligilactobacillus | Ligilactobacillus equi | ||
| 28264349 | 28264349 | PRJEB10320_P_NODE_9926_length_312_cov_1.299639_g9668_i0 | PRJEB10320 | 9926 | 312 | 1.299639 | 4.05487368 | Gracilibacillus marinus | 630535 | Bacteria | Bacteria | 98.2 | 4.36e-22 | NR | WP_390198764.1 | 630535 | g9668 | i0 | 51.5 | 0.990384615384615 | 103 | 50 | 99 | 0 | 2 | 310 | 74 | 176 | WP_390198764.1 NADP-dependent oxidoreductase [Gracilibacillus marinus] | diamond | 309 | 98.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Gracilibacillus | Gracilibacillus marinus | ||
| 29268587 | 29268587 | PRJEB10320_P_NODE_28309_length_151_cov_1.379310_g28051_i0 | PRJEB10320 | 28309 | 151 | 1.37931 | 2.0827581 | Bacillota | 1239 | Bacteria | Bacteria | 44.7 | 0.00216 | NR | WP_259394446.1 | 1547 | g28051 | i0 | 40 | 7.41059602649007 | 45 | 26 | 87.4 | 1 | 142 | 11 | 42 | 86 | WP_259394446.1 sensor histidine kinase [Thomasclavelia ramosa] | diamond | 1119 | 44.7 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Coprobacillaceae | Thomasclavelia | Thomasclavelia ramosa | ||
| 29837003 | 29837003 | PRJEB10320_P_NODE_26911_length_156_cov_1.305785_g26653_i0 | PRJEB10320 | 26911 | 156 | 1.305785 | 2.0370246 | PVC group | 1783257 | Bacteria | Bacteria | 62.4 | 4.95e-10 | NR | WP_207751048.1 | 474960 | g26653 | i0 | 59.1 | 5.13461538461539 | 44 | 18 | 84.6 | 0 | 133 | 2 | 80 | 123 | WP_207751048.1 GNAT family N-acetyltransferase [Hydrogenoanaerobacterium saccharovorans] | diamond | 801 | 62.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Hydrogenoanaerobacterium | Hydrogenoanaerobacterium saccharovorans | ||
| 29932056 | 29932056 | PRJEB10320_P_NODE_19271_length_198_cov_1.104294_g19013_i0 | PRJEB10320 | 19271 | 198 | 1.104294 | 2.18650212 | Bacillota | 1239 | Bacteria | Bacteria | 48.9 | 1.37e-4 | NR | MBQ8719670.1 | 2044939 | g19013 | i0 | 51 | 5.07575757575758 | 51 | 21 | 71.2 | 1 | 148 | 8 | 958 | 1008 | MBQ8719670.1 TIR domain-containing protein [Clostridia bacterium] | diamond | 1005 | 49.3 | 0.991886409736308 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 30532066 | 30532066 | PRJEB10320_P_NODE_13713_length_251_cov_1.481481_g13455_i0 | PRJEB10320 | 13713 | 251 | 1.481481 | 3.71851731 | Bacteria | 2 | Bacteria | Bacteria | 50.1 | 1.01e-4 | NR | WP_379866935.1 | 110101 | g13455 | i0 | 43.6 | 3.43027888446215 | 55 | 30 | 64.5 | 1 | 234 | 73 | 268 | 322 | WP_379866935.1 zinc-dependent alcohol dehydrogenase family protein [Laceyella putida] | diamond | 861 | 50.1 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Thermoactinomycetaceae | Laceyella | Laceyella putida | ||
| 30664635 | 30664635 | PRJEB10320_P_NODE_18433_length_204_cov_1.538462_g18175_i0 | PRJEB10320 | 18433 | 204 | 1.538462 | 3.13846248 | Exiguobacterium mexicanum | 340146 | Bacteria | Bacteria | 68.2 | 3.18e-12 | NR | MFN3367734.1 | 340146 | g18175 | i0 | 65.2 | 0.676470588235294 | 46 | 16 | 67.6 | 0 | 1 | 138 | 127 | 172 | MFN3367734.1 hypothetical protein [Exiguobacterium mexicanum] | diamond | 138 | 68.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Exiguobacterium | Exiguobacterium mexicanum | |||
| 30759504 | 30759504 | PRJEB10320_P_NODE_24334_length_167_cov_1.515152_g24076_i0 | PRJEB10320 | 24334 | 167 | 1.515152 | 2.53030384 | Halalkalibacter nanhaiisediminis | 688079 | Bacteria | Bacteria | 72.4 | 2.44e-14 | NR | WP_144449783.1 | 688079 | g24076 | i0 | 54.5 | 3.93413173652695 | 55 | 25 | 98.8 | 0 | 167 | 3 | 53 | 107 | WP_144449783.1 OsmC family protein [Halalkalibacter nanhaiisediminis] | diamond | 657 | 72.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Halalkalibacter | Halalkalibacter nanhaiisediminis | ||
| 30854175 | 30854175 | PRJEB10320_P_NODE_9034_length_331_cov_1.317568_g8776_i0 | PRJEB10320 | 9034 | 331 | 1.317568 | 4.36115008 | Parasporobacterium sp. | 2740533 | Bacteria | Bacteria | 49.3 | 5.1e-4 | NR | MCF0228404.1 | 2740533 | g8776 | i0 | 35.7 | 0.634441087613293 | 70 | 45 | 63.4 | 0 | 288 | 79 | 122 | 191 | MCF0228404.1 MATE family efflux transporter [Parasporobacterium sp.] | diamond | 210 | 49.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Parasporobacterium | Parasporobacterium sp. | ||
| 30885772 | 30885772 | PRJEB10320_P_NODE_19214_length_198_cov_1.521472_g18956_i0 | PRJEB10320 | 19214 | 198 | 1.521472 | 3.01251456 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 53.1 | 1.05e-6 | NR | MBQ8425913.1 | 2044939 | g18956 | i0 | 41.2 | 0.772727272727273 | 51 | 29 | 75.8 | 1 | 48 | 197 | 5 | 55 | MBQ8425913.1 NUDIX domain-containing protein [Clostridia bacterium] | diamond | 153 | 53.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 30917573 | 30917573 | PRJEB10320_P_NODE_27214_length_155_cov_1.000000_g26956_i0 | PRJEB10320 | 27214 | 155 | 1 | 1.55 | Mammaliicoccus sciuri | 1296 | Bacteria | Bacteria | 76.3 | 1.26e-16 | NR | MCH5142011.1 | 1296 | g26956 | i0 | 69.6 | 0.890322580645161 | 46 | 14 | 89 | 0 | 3 | 140 | 37 | 82 | MCH5142011.1 hypothetical protein [Mammaliicoccus sciuri] | diamond | 138 | 76.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Mammaliicoccus | Mammaliicoccus sciuri | ||
| 30949172 | 30949172 | PRJEB10320_P_NODE_12754_length_264_cov_1.017467_g12496_i0 | PRJEB10320 | 12754 | 264 | 1.017467 | 2.68611288 | Sporomusa sp. KB1 | 943346 | Bacteria | Bacteria | 40.4 | 0.0413 | NR | WP_222427951.1 | 943346 | g12496 | i0 | 40.5 | 0.477272727272727 | 42 | 24 | 46.6 | 1 | 69 | 191 | 17 | 58 | WP_222427951.1 hypothetical protein [Sporomusa sp. KB1] | diamond | 126 | 40.4 | 1 | Bacteria | Bacillati | Bacillota | Negativicutes | Selenomonadales | Sporomusaceae | Sporomusa | Sporomusa sp. KB1 | ||
| 31834170 | 31834170 | PRJEB10320_P_NODE_14277_length_244_cov_1.497608_g14019_i0 | PRJEB10320 | 14277 | 244 | 1.497608 | 3.65416352 | Ruminococcus sp. | 41978 | Bacteria | Bacteria | 51.2 | 4.05e-5 | NR | MCM1328977.1 | 41978 | g14019 | i0 | 46.4 | 2.52049180327869 | 56 | 30 | 68.9 | 0 | 20 | 187 | 416 | 471 | MCM1328977.1 amino acid adenylation domain-containing protein [Ruminococcus sp.] | diamond | 615 | 51.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Ruminococcus | Ruminococcus sp. | ||
| 32024271 | 32024271 | PRJEB10320_P_NODE_11798_length_278_cov_0.971193_g11540_i0 | PRJEB10320 | 11798 | 278 | 0.971193 | 2.69991654 | Anoxybacteroides tepidamans | 265948 | Bacteria | Bacteria | 109 | 2.0900000000000003e-27 | NR | WP_183254399.1 | 265948 | g11540 | i0 | 100 | 0.60431654676259 | 56 | 0 | 60.4 | 0 | 111 | 278 | 1 | 56 | WP_183254399.1 PspA/IM30 family protein [Anoxybacteroides tepidamans] | diamond | 168 | 109 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Anoxybacillaceae | Anoxybacteroides | Anoxybacteroides tepidamans | ||
| 32113106 | 32113106 | PRJEB10320_P_NODE_25138_length_163_cov_1.562500_g24880_i0 | PRJEB10320 | 25138 | 163 | 1.5625 | 2.546875 | Clostridia | 186801 | Bacteria | Bacteria | 41.6 | 0.0318 | NR | WP_006780523.1 | 154046 | g24880 | i0 | 48.7 | 5.98159509202454 | 39 | 20 | 71.8 | 0 | 131 | 15 | 433 | 471 | WP_006780523.1 sensor histidine kinase [Hungatella hathewayi] | diamond | 975 | 41.6 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Hungatella | Hungatella hathewayi | ||
| 32208017 | 32208017 | PRJEB10320_P_NODE_14198_length_245_cov_1.509524_g13940_i0 | PRJEB10320 | 14198 | 245 | 1.509524 | 3.6983338 | Paenibacillus | 44249 | Bacteria | Bacteria | 42.4 | 0.0184 | NR | MBG9732894.1 | 44250 | g13940 | i0 | 58.3 | 0.906122448979592 | 36 | 15 | 44.1 | 0 | 195 | 88 | 77 | 112 | MBG9732894.1 hypothetical protein [Paenibacillus alvei] | diamond | 222 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus alvei | ||
| 32271347 | 32271347 | PRJEB10320_P_NODE_23578_length_171_cov_1.176471_g23320_i0 | PRJEB10320 | 23578 | 171 | 1.176471 | 2.01176541 | root | 1 | Root_unresolved | Root_unresolved | 58.9 | 3.36e-9 | NR | MRA94127.1 | 1428 | g23320 | i0 | 100 | 95.2982456140351 | 26 | 0 | 45.6 | 0 | 170 | 93 | 106 | 131 | MRA94127.1 30S ribosomal protein S9 [Bacillus thuringiensis] | diamond | 16296 | 58.9 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus thuringiensis | ||
| 32499049 | 32499049 | PRJEB10320_P_NODE_6479_length_408_cov_4.506702_g6225_i0 | PRJEB10320 | 6479 | 408 | 4.506702 | 18.38734416 | Clostridium sp. | 1506 | Bacteria | Bacteria | 47.4 | 0.00484 | NR | MCM1107739.1 | 1506 | g6225 | i0 | 50 | 1.52941176470588 | 70 | 30 | 51.5 | 4 | 341 | 132 | 58 | 122 | MCM1107739.1 ATP-binding protein [Clostridium sp.] | diamond | 624 | 47.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium sp. | ||
| 32530691 | 32530691 | PRJEB10320_P_NODE_8219_length_352_cov_2.211356_g7961_i0 | PRJEB10320 | 8219 | 352 | 2.211356 | 7.78397312 | Paenibacillus | 44249 | Bacteria | Bacteria | 60.8 | 5.94e-8 | NR | WP_127509577.1 | 44249 | g7961 | i0 | 42.9 | 0.715909090909091 | 84 | 47 | 71.6 | 1 | 339 | 88 | 739 | 821 | WP_127509577.1 MULTISPECIES: ankyrin repeat domain-containing protein [Paenibacillus] | diamond | 252 | 60.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | |||
| 32719556 | 32719556 | PRJEB10320_P_NODE_20380_length_190_cov_1.548387_g20122_i0 | PRJEB10320 | 20380 | 190 | 1.548387 | 2.9419353 | unclassified Halanaerobium | 2641197 | Bacteria | Bacteria | 77.4 | 1.07e-14 | NR | WP_114457031.1 | 2641197 | g20122 | i0 | 58.1 | 0.978947368421053 | 62 | 26 | 97.9 | 0 | 3 | 188 | 346 | 407 | WP_114457031.1 MULTISPECIES: translation initiation factor IF-2 [unclassified Halanaerobium] | diamond | 186 | 77.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiaceae | Halanaerobium | |||
| 32745050 | 32745050 | PRJEB10320_P_NODE_26020_length_159_cov_1.879032_g25762_i0 | PRJEB10320 | 26020 | 159 | 1.879032 | 2.98766088 | Caryophanon | 33976 | Bacteria | Bacteria | 50.4 | 2.21e-5 | NR | WP_066466411.1 | 33977 | g25762 | i0 | 47.8 | 1.75471698113208 | 46 | 24 | 86.8 | 0 | 21 | 158 | 176 | 221 | WP_066466411.1 AAA family ATPase [Caryophanon latum] | diamond | 279 | 50.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Caryophanaceae | Caryophanon | Caryophanon latum |
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);;