contig_metadata
6 rows where bioproject = "PRJNA682370", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10103229 | 10103229 | PRJNA682370_S_NODE_11188_length_217_cov_1.752747_g10576_i0 | PRJNA682370 | 11188 | 217 | 1.752747 | 3.80346099 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 69.4 | 1.9e-7 | NTclustered | gi|2869653495|gb|CP175551.1| | 33 | g10576 | i0 | 93.478 | 4.16129032258065 | 46 | 3 | 21 | 0 | 169 | 214 | 6892199 | 6892244 | Myxococcus fulvus strain KYC1117 chromosome, complete genome | blastn | 903 | 69.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 14693564 | 14693564 | PRJNA682370_S_NODE_9512_length_239_cov_1.607843_g8900_i0 | PRJNA682370 | 9512 | 239 | 1.607843 | 3.84274477 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g8900 | i0 | 100 | 0.121338912133891 | 29 | 0 | 12 | 0 | 67 | 95 | 8621703 | 8621675 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 27524478 | 27524478 | PRJNA682370_S_NODE_15963_length_179_cov_1.451389_g15351_i0 | PRJNA682370 | 15963 | 179 | 1.451389 | 2.59798631 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 48.5 | 1.44e-4 | NR | HEX2736392.1 | 2268199 | g15351 | i0 | 37.9 | 0.972067039106145 | 58 | 30 | 88.8 | 3 | 2 | 160 | 398 | 454 | HEX2736392.1 matrixin family metalloprotease [Polyangiaceae bacterium] | diamond | 174 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28345376 | 28345376 | PRJNA682370_S_NODE_11306_length_216_cov_1.314917_g10694_i0 | PRJNA682370 | 11306 | 216 | 1.314917 | 2.84022072 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 51.6 | 1.9e-5 | NR | HTJ44394.1 | 2212474 | g10694 | i0 | 46.7 | 2.31944444444444 | 60 | 31 | 83.3 | 1 | 36 | 215 | 394 | 452 | HTJ44394.1 Glu/Leu/Phe/Val dehydrogenase [Kofleriaceae bacterium] | diamond | 501 | 51.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28755845 | 28755845 | PRJNA682370_S_NODE_12727_length_201_cov_4.006024_g12115_i0 | PRJNA682370 | 12727 | 201 | 4.006024 | 8.05210824 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 68.9 | 6.13e-13 | NR | MCP4669365.1 | 2026735 | g12115 | i0 | 51.6 | 1.70149253731343 | 64 | 29 | 94 | 2 | 1 | 189 | 67 | 129 | MCP4669365.1 50S ribosomal protein L24 [Deltaproteobacteria bacterium] | diamond | 342 | 68.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29198075 | 29198075 | PRJNA682370_S_NODE_16149_length_178_cov_1.503497_g15537_i0 | PRJNA682370 | 16149 | 178 | 1.503497 | 2.67622466 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 71.2 | 6.79e-14 | NR | HVJ94850.1 | 1971228 | g15537 | i0 | 63 | 0.775280898876405 | 46 | 17 | 77.5 | 0 | 145 | 8 | 12 | 57 | HVJ94850.1 hypothetical protein [Labilithrix sp.] | diamond | 138 | 71.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. |
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);;