contig_metadata
11 rows where bioproject = "PRJNA1020854", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3987986 | 3987986 | PRJNA1020854_S_NODE_9184_length_445_cov_45.713942_g6478_i0 | PRJNA1020854 | 9184 | 445 | 45.713942 | 203.4270419 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 512 | 1.64e-140 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g6478 | i0 | 93.143 | 703.737078651685 | 350 | 22 | 78 | 2 | 98 | 445 | 7408058 | 7408407 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 313163 | 512 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 6106346 | 6106346 | PRJNA1020854_S_NODE_16985_length_276_cov_1267.740891_g14221_i0 | PRJNA1020854 | 16985 | 276 | 1267.740891 | 3498.96485916 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 84 | 1.81e-16 | NR | MFT3928156.1 | 2026763 | g14221 | i0 | 50 | 0.978260869565217 | 90 | 35 | 87 | 2 | 22 | 261 | 118 | 207 | MFT3928156.1 long-chain-acyl-CoA synthetase [Myxococcales bacterium] | diamond | 270 | 84 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 10364534 | 10364534 | PRJNA1020854_S_NODE_7629_length_540_cov_365.045010_g5002_i0 | PRJNA1020854 | 7629 | 540 | 365.04501 | 1971.243054 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 516 | 1.5699999999999998e-141 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g5002 | i0 | 89.877 | 261.862962962963 | 405 | 35 | 74 | 5 | 1 | 401 | 7408407 | 7408005 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 141406 | 516 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 21838114 | 21838114 | PRJNA1020854_S_NODE_6158_length_705_cov_778.832840_g3696_i0 | PRJNA1020854 | 6158 | 705 | 778.83284 | 5490.771522 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 265 | 3.11e-86 | NR | HEY0253327.1 | 2212474 | g3696 | i0 | 99.4 | 0.757446808510638 | 178 | 1 | 75.7 | 0 | 589 | 56 | 1 | 178 | HEY0253327.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 534 | 265 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 27761735 | 27761735 | PRJNA1020854_S_NODE_14284_length_314_cov_3.077193_g11520_i0 | PRJNA1020854 | 14284 | 314 | 3.077193 | 9.66238602 | Pyxidicoccus sp. MSG2 | 2996790 | Bacteria | Bacteria | 44.3 | 0.0225 | NR | WP_267856999.1 | 2996790 | g11520 | i0 | 34.4 | 0.582802547770701 | 61 | 40 | 58.3 | 0 | 269 | 87 | 32 | 92 | WP_267856999.1 Virginiamycin B lyase [Pyxidicoccus sp. MSG2] | diamond | 183 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pyxidicoccus | Pyxidicoccus sp. MSG2 | ||
| 28456236 | 28456236 | PRJNA1020854_S_NODE_30726_length_186_cov_2.407643_g27962_i0 | PRJNA1020854 | 30726 | 186 | 2.407643 | 4.47821598 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 57.4 | 1.24e-7 | NR | HIA01140.1 | 2026763 | g27962 | i0 | 54.9 | 0.82258064516129 | 51 | 22 | 82.3 | 1 | 19 | 171 | 679 | 728 | HIA01140.1 hypothetical protein [Myxococcales bacterium] | diamond | 153 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29434573 | 29434573 | PRJNA1020854_S_NODE_39850_length_158_cov_2.279070_g37086_i0 | PRJNA1020854 | 39850 | 158 | 2.27907 | 3.6009306 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 41.2 | 0.0409 | NR | TDJ16765.1 | 2026735 | g37086 | i0 | 48.6 | 0.70253164556962 | 37 | 19 | 70.3 | 0 | 113 | 3 | 147 | 183 | TDJ16765.1 MAG: FkbM family methyltransferase [Deltaproteobacteria bacterium] | diamond | 111 | 41.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29813666 | 29813666 | PRJNA1020854_S_NODE_19111_length_254_cov_6.071111_g16347_i0 | PRJNA1020854 | 19111 | 254 | 6.071111 | 15.42062194 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.9 | 0.0171 | NR | TNF32024.1 | 2026735 | g16347 | i0 | 37.5 | 0.566929133858268 | 48 | 30 | 56.7 | 0 | 92 | 235 | 721 | 768 | TNF32024.1 MAG: hypothetical protein EP329_11385 [Deltaproteobacteria bacterium] | diamond | 144 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30603502 | 30603502 | PRJNA1020854_S_NODE_15133_length_301_cov_3.952206_g12369_i0 | PRJNA1020854 | 15133 | 301 | 3.952206 | 11.89614006 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 55.1 | 2.25e-6 | NR | MCK4846512.1 | 2026735 | g12369 | i0 | 50.8 | 0.588039867109635 | 59 | 25 | 54.8 | 2 | 3 | 167 | 190 | 248 | MCK4846512.1 ZIP family metal transporter [Deltaproteobacteria bacterium] | diamond | 177 | 55.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31425275 | 31425275 | PRJNA1020854_S_NODE_17116_length_275_cov_3.130081_g14352_i0 | PRJNA1020854 | 17116 | 275 | 3.130081 | 8.60772275 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 50.1 | 1.41e-4 | NR | MCB9524676.1 | 2026763 | g14352 | i0 | 65.8 | 0.829090909090909 | 38 | 12 | 40.4 | 1 | 173 | 63 | 304 | 341 | MCB9524676.1 hypothetical protein [Myxococcales bacterium] | diamond | 228 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32113589 | 32113589 | PRJNA1020854_S_NODE_32578_length_179_cov_2.900000_g29814_i0 | PRJNA1020854 | 32578 | 179 | 2.9 | 5.191 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.5 | 1.37e-4 | NR | NOY89703.1 | 2026735 | g29814 | i0 | 40.7 | 5.14525139664805 | 59 | 35 | 98.9 | 0 | 1 | 177 | 195 | 253 | NOY89703.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Deltaproteobacteria bacterium] | diamond | 921 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria 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);;