contig_metadata
12 rows where bioproject = "PRJNA893346", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13621713 | 13621713 | PRJNA893346_P_NODE_19271_length_351_cov_1.661871_g18782_i0 | PRJNA893346 | 19271 | 351 | 1.661871 | 5.83316721 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 168 | 4.87e-49 | NR | MFO0692503.1 | 3034171 | g18782 | i0 | 75.7 | 4.76923076923077 | 111 | 26 | 94.9 | 1 | 341 | 9 | 115 | 224 | MFO0692503.1 class I fructose-bisphosphate aldolase [Polyangiales bacterium] | diamond | 1674 | 168 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 17446640 | 17446640 | PRJNA893346_P_NODE_36994_length_245_cov_1.203488_g36504_i0 | PRJNA893346 | 36994 | 245 | 1.203488 | 2.9485456 | root | 1 | Root_unresolved | Root_unresolved | 106 | 1.24e-24 | NR | WP_236514608.1 | 927083 | g36504 | i0 | 65.3 | 6.19591836734694 | 72 | 25 | 88.2 | 0 | 241 | 26 | 93 | 164 | WP_236514608.1 5-methyltetrahydropteroyltriglutamate--homocysteine S-methyltransferase [Sandaracinus amylolyticus] | diamond | 1518 | 106 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 27435070 | 27435070 | PRJNA893346_P_NODE_13603_length_423_cov_1.894286_g13117_i0 | PRJNA893346 | 13603 | 423 | 1.894286 | 8.01282978 | Pyxidicoccus fallax | 394095 | Bacteria | Bacteria | 46.6 | 0.0118 | NR | AIT55263.1 | 394095 | g13117 | i0 | 43.1 | 0.51063829787234 | 72 | 39 | 49.6 | 2 | 332 | 123 | 1611 | 1682 | AIT55263.1 GulF [Pyxidicoccus fallax] | diamond | 216 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pyxidicoccus | Pyxidicoccus fallax | ||
| 27695496 | 27695496 | PRJNA893346_P_NODE_16844_length_378_cov_0.908197_g16356_i0 | PRJNA893346 | 16844 | 378 | 0.908197 | 3.43298466 | root | 1 | Root_unresolved | Root_unresolved | 74.7 | 1.09e-12 | NR | WP_324949294.1 | 1872627 | g16356 | i0 | 37.1 | 6.11904761904762 | 140 | 59 | 90.5 | 6 | 365 | 24 | 465 | 601 | WP_324949294.1 RTX toxin [Archangium sp.] | diamond | 2313 | 74.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28129566 | 28129566 | PRJNA893346_P_NODE_25425_length_301_cov_1.350877_g24935_i0 | PRJNA893346 | 25425 | 301 | 1.350877 | 4.06613977 | Chondromyces crocatus | 52 | Bacteria | Bacteria | 49.3 | 3.36e-4 | NR | WP_082362723.1 | 52 | g24935 | i0 | 34.6 | 2.33222591362126 | 78 | 43 | 72.8 | 2 | 228 | 10 | 210 | 284 | WP_082362723.1 C-type lectin domain-containing protein [Chondromyces crocatus] | diamond | 702 | 49.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 28255645 | 28255645 | PRJNA893346_P_NODE_29126_length_277_cov_1.348039_g28636_i0 | PRJNA893346 | 29126 | 277 | 1.348039 | 3.73406803 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 87.4 | 1.41e-19 | NR | MBI4510343.1 | 2026735 | g28636 | i0 | 43.8 | 1.71119133574007 | 80 | 45 | 86.6 | 0 | 34 | 273 | 1 | 80 | MBI4510343.1 SRPBCC family protein [Deltaproteobacteria bacterium] | diamond | 474 | 87.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29771157 | 29771157 | PRJNA893346_P_NODE_22271_length_325_cov_1.515873_g21782_i0 | PRJNA893346 | 22271 | 325 | 1.515873 | 4.92658725 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 66.2 | 4.28e-11 | NR | KYF56378.1 | 56 | g21782 | i0 | 43.9 | 0.756923076923077 | 82 | 45 | 74.8 | 1 | 8 | 250 | 57 | 138 | KYF56378.1 hypothetical protein BE08_41265 [Sorangium cellulosum] | diamond | 246 | 66.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 30118674 | 30118674 | PRJNA893346_P_NODE_4932_length_731_cov_1.326748_g4485_i0 | PRJNA893346 | 4932 | 731 | 1.326748 | 9.69852788 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 65.5 | 3.11e-8 | NR | MBI3782678.1 | 2026735 | g4485 | i0 | 30.6 | 0.792065663474692 | 193 | 99 | 71.8 | 4 | 592 | 68 | 52 | 227 | MBI3782678.1 trypsin-like serine protease [Deltaproteobacteria bacterium] | diamond | 579 | 65.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30853253 | 30853253 | PRJNA893346_P_NODE_36034_length_247_cov_0.885057_g35544_i0 | PRJNA893346 | 36034 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 101 | 8.719999999999999e-23 | NR | HVJ94932.1 | 1971228 | g35544 | i0 | 54.3 | 2.92712550607287 | 81 | 37 | 98.4 | 0 | 3 | 245 | 182 | 262 | HVJ94932.1 FAD-binding oxidoreductase [Labilithrix sp.] | diamond | 723 | 101 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 32142084 | 32142084 | PRJNA893346_P_NODE_38518_length_243_cov_0.905882_g38028_i0 | PRJNA893346 | 38518 | 243 | 0.905882 | 2.20129326 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 59.3 | 5.06e-8 | NR | MCA9523410.1 | 2026763 | g38028 | i0 | 38.7 | 0.925925925925926 | 75 | 42 | 88.9 | 2 | 243 | 28 | 61 | 134 | MCA9523410.1 glutathione S-transferase family protein [Myxococcales bacterium] | diamond | 225 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32585099 | 32585099 | PRJNA893346_P_NODE_19759_length_347_cov_1.072993_g19270_i0 | PRJNA893346 | 19759 | 347 | 1.072993 | 3.72328571 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 90.9 | 4.08e-19 | NR | HYJ08966.1 | 2268199 | g19270 | i0 | 60.9 | 0.596541786743516 | 69 | 26 | 58.8 | 1 | 214 | 11 | 75 | 143 | HYJ08966.1 Kazal-type serine protease inhibitor family protein [Polyangiaceae bacterium] | diamond | 207 | 90.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32647545 | 32647545 | PRJNA893346_P_NODE_36500_length_246_cov_0.890173_g36010_i0 | PRJNA893346 | 36500 | 246 | 0.890173 | 2.18982558 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 44.7 | 0.00138 | NR | HMR09041.1 | 2268199 | g36010 | i0 | 35.6 | 3.29268292682927 | 73 | 41 | 81.7 | 3 | 40 | 240 | 5 | 77 | HMR09041.1 protein kinase [Polyangiaceae bacterium] | diamond | 810 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae 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);;