contig_metadata
6 rows where bioproject = "PRJNA889065", tax_kingdom = "Pseudomonadati" and tax_phylum = "Myxococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17441512 | 17441512 | PRJNA889065_S_NODE_1774_length_621_cov_6.513841_g1587_i0 | PRJNA889065 | 1774 | 621 | 6.513841 | 40.45095261 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 256 | 4.25e-76 | NR | MCB9640303.1 | 2026763 | g1587 | i0 | 59.6 | 8.39130434782609 | 193 | 78 | 93.2 | 0 | 2 | 580 | 761 | 953 | MCB9640303.1 aminomethyl-transferring glycine dehydrogenase [Myxococcales bacterium] | diamond | 5211 | 256 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29834376 | 29834376 | PRJNA889065_S_NODE_2371_length_556_cov_24.727096_g2157_i0 | PRJNA889065 | 2371 | 556 | 24.727096 | 137.48265376 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 127 | 7.02e-33 | NR | MFO0727083.1 | 2818507 | g2157 | i0 | 41 | 1.72661870503597 | 161 | 85 | 83.6 | 3 | 504 | 40 | 69 | 225 | MFO0727083.1 cyclin-dependent kinase inhibitor 3 family protein [Myxococcota bacterium] | diamond | 960 | 127 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30371890 | 30371890 | PRJNA889065_S_NODE_7412_length_348_cov_1.324590_g7174_i0 | PRJNA889065 | 7412 | 348 | 1.32459 | 4.6095732 | Vitiosangium sp. GDMCC 1.1324 | 2138576 | Bacteria | Bacteria | 94.4 | 8.76e-20 | NR | WP_108075257.1 | 2138576 | g7174 | i0 | 44.6 | 3.66379310344828 | 112 | 59 | 96.6 | 3 | 3 | 338 | 230 | 338 | WP_108075257.1 CocE/NonD family hydrolase [Vitiosangium sp. GDMCC 1.1324] | diamond | 1275 | 94.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Vitiosangium | Vitiosangium sp. GDMCC 1.1324 | ||
| 31540945 | 31540945 | PRJNA889065_S_NODE_13116_length_266_cov_2.730942_g12878_i0 | PRJNA889065 | 13116 | 266 | 2.730942 | 7.26430572 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.5 | 0.0247 | NR | MEM6730674.1 | 2818507 | g12878 | i0 | 47.7 | 0.496240601503759 | 44 | 23 | 49.6 | 0 | 199 | 68 | 231 | 274 | MEM6730674.1 endonuclease [Myxococcota bacterium] | diamond | 132 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32363616 | 32363616 | PRJNA889065_S_NODE_30599_length_174_cov_1.702290_g30361_i0 | PRJNA889065 | 30599 | 174 | 1.70229 | 2.9619846 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 64.7 | 2.14e-10 | NR | MBL8679326.1 | 2026763 | g30361 | i0 | 59.1 | 1.51724137931034 | 44 | 18 | 75.9 | 0 | 160 | 29 | 207 | 250 | MBL8679326.1 phytanoyl-CoA dioxygenase family protein [Myxococcales bacterium] | diamond | 264 | 64.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32584998 | 32584998 | PRJNA889065_S_NODE_33019_length_167_cov_1.112903_g32781_i0 | PRJNA889065 | 33019 | 167 | 1.112903 | 1.85854801 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 50.1 | 3.35e-5 | NR | MFT5686820.1 | 2818507 | g32781 | i0 | 57.5 | 1.32934131736527 | 40 | 17 | 71.9 | 0 | 146 | 27 | 254 | 293 | MFT5686820.1 ectoine hydroxylase-related dioxygenase (phytanoyl-CoA dioxygenase family) [Myxococcota bacterium] | diamond | 222 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota 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);;