contig_metadata
17 rows where bioproject = "PRJNA688414" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15969741 | 15969741 | PRJNA688414_P_NODE_7393_length_246_cov_0.901734_g7359_i0 | PRJNA688414 | 7393 | 246 | 0.901734 | 2.21826564 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 165 | 2.74e-36 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g7359 | i0 | 79.661 | 3.76829268292683 | 236 | 43 | 95 | 4 | 14 | 246 | 10383962 | 10383729 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 927 | 165 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 26639042 | 26639042 | PRJNA688414_P_NODE_7681_length_245_cov_0.906977_g7647_i0 | PRJNA688414 | 7681 | 245 | 0.906977 | 2.22209365 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 144 | 7.65e-40 | NR | TMA31923.1 | 2026735 | g7647 | i0 | 85.2 | 1.98367346938776 | 81 | 12 | 99.2 | 0 | 2 | 244 | 234 | 314 | TMA31923.1 MAG: long-chain fatty acid--CoA ligase, partial [Deltaproteobacteria bacterium] | diamond | 486 | 144 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27082247 | 27082247 | PRJNA688414_P_NODE_7962_length_244_cov_0.883041_g7928_i0 | PRJNA688414 | 7962 | 244 | 0.883041 | 2.15462004 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 168 | 2.36e-51 | NR | TMA65010.1 | 2026735 | g7928 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 1 | 243 | 63 | 143 | TMA65010.1 MAG: sulfopyruvate decarboxylase [Deltaproteobacteria bacterium] | diamond | 243 | 168 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27840136 | 27840136 | PRJNA688414_P_NODE_7684_length_245_cov_0.906977_g7650_i0 | PRJNA688414 | 7684 | 245 | 0.906977 | 2.22209365 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 135 | 9.319999999999999e-35 | NR | HEY5950321.1 | 2212474 | g7650 | i0 | 77.8 | 0.991836734693878 | 81 | 18 | 99.2 | 0 | 2 | 244 | 411 | 491 | HEY5950321.1 CehA/McbA family metallohydrolase [Kofleriaceae bacterium] | diamond | 243 | 135 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28092915 | 28092915 | PRJNA688414_P_NODE_7165_length_247_cov_0.896552_g7131_i0 | PRJNA688414 | 7165 | 247 | 0.896552 | 2.21448344 | Hyalangium sp. | 2028555 | Bacteria | Bacteria | 138 | 1.12e-35 | NR | WP_324992885.1 | 2028555 | g7131 | i0 | 88.9 | 0.983805668016194 | 81 | 9 | 98.4 | 0 | 247 | 5 | 1323 | 1403 | WP_324992885.1 trifunctional serine/threonine-protein kinase/ATP-binding protein/sensor histidine kinase [Hyalangium sp.] | diamond | 243 | 138 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Hyalangium | Hyalangium sp. | ||
| 28882196 | 28882196 | PRJNA688414_P_NODE_6128_length_252_cov_0.871508_g6094_i0 | PRJNA688414 | 6128 | 252 | 0.871508 | 2.19620016 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 157 | 1.59e-42 | NR | HYV47096.1 | 2484252 | g6094 | i0 | 97.6 | 2 | 84 | 2 | 100 | 0 | 1 | 252 | 380 | 463 | HYV47096.1 error-prone DNA polymerase [Myxococcaceae bacterium] | diamond | 504 | 157 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 29260980 | 29260980 | PRJNA688414_P_NODE_6369_length_251_cov_0.876404_g6335_i0 | PRJNA688414 | 6369 | 251 | 0.876404 | 2.19977404 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 96.7 | 1.3100000000000002e-21 | NR | HXU84038.1 | 3058050 | g6335 | i0 | 63.9 | 0.99203187250996006 | 83 | 30 | 99.2 | 0 | 1 | 249 | 63 | 145 | HXU84038.1 hypothetical protein [Polyangia bacterium] | diamond | 249 | 96.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 29355996 | 29355996 | PRJNA688414_P_NODE_8349_length_242_cov_0.923077_g8315_i0 | PRJNA688414 | 8349 | 242 | 0.923077 | 2.23384634 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 90.5 | 5.58e-19 | NR | MBX3197200.1 | 1971228 | g8315 | i0 | 68.8 | 2.98760330578512 | 64 | 20 | 79.3 | 0 | 223 | 32 | 138 | 201 | MBX3197200.1 hypothetical protein [Labilithrix sp.] | diamond | 723 | 90.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 29829458 | 29829458 | PRJNA688414_P_NODE_8351_length_242_cov_0.923077_g8317_i0 | PRJNA688414 | 8351 | 242 | 0.923077 | 2.23384634 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 123 | 6.69e-31 | NR | HVJ22268.1 | 2268199 | g8317 | i0 | 83.1 | 0.954545454545455 | 77 | 13 | 95.5 | 0 | 242 | 12 | 98 | 174 | HVJ22268.1 YifB family Mg chelatase-like AAA ATPase [Polyangiaceae bacterium] | diamond | 231 | 123 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30208338 | 30208338 | PRJNA688414_P_NODE_6332_length_251_cov_0.876404_g6298_i0 | PRJNA688414 | 6332 | 251 | 0.876404 | 2.19977404 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 55.5 | 1.33e-6 | NR | TMB49044.1 | 2026735 | g6298 | i0 | 70.6 | 1.13545816733068 | 34 | 10 | 40.6 | 0 | 6 | 107 | 392 | 425 | TMB49044.1 MAG: hypothetical protein E6J60_13550 [Deltaproteobacteria bacterium] | diamond | 285 | 55.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30335417 | 30335417 | PRJNA688414_P_NODE_7912_length_244_cov_0.912281_g7878_i0 | PRJNA688414 | 7912 | 244 | 0.912281 | 2.22596564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 134 | 1.11e-35 | NR | MBI3756824.1 | 2026735 | g7878 | i0 | 86.3 | 2.95081967213115 | 80 | 11 | 98.4 | 0 | 242 | 3 | 335 | 414 | MBI3756824.1 AAA family ATPase [Deltaproteobacteria bacterium] | diamond | 720 | 134 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30587619 | 30587619 | PRJNA688414_P_NODE_6693_length_250_cov_0.881356_g6659_i0 | PRJNA688414 | 6693 | 250 | 0.881356 | 2.20339 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 51.6 | 2.46e-5 | NR | MBM4254261.1 | 2026735 | g6659 | i0 | 44.4 | 0.756 | 63 | 34 | 75.6 | 1 | 194 | 6 | 130 | 191 | MBM4254261.1 PEP-CTERM sorting domain-containing protein [Deltaproteobacteria bacterium] | diamond | 189 | 51.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30788922 | 30788922 | PRJNA688414_P_NODE_6914_length_249_cov_0.886364_g6880_i0 | PRJNA688414 | 6914 | 249 | 0.886364 | 2.20704636 | Bacteria | 2 | Bacteria | Bacteria | 51.2 | 3.91e-5 | NR | WP_044247881.1 | 51 | g6880 | i0 | 35.4 | 2.90361445783133 | 79 | 51 | 95.2 | 0 | 12 | 248 | 126 | 204 | WP_044247881.1 DUF1444 family protein [Chondromyces apiculatus] | diamond | 723 | 51.6 | 0.992248062015504 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces apiculatus | |||
| 30967057 | 30967057 | PRJNA688414_P_NODE_6474_length_251_cov_0.876404_g6440_i0 | PRJNA688414 | 6474 | 251 | 0.876404 | 2.19977404 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 87.8 | 5.66e-18 | NR | MCB9563607.1 | 2212474 | g6440 | i0 | 67.1 | 0.9800796812749 | 82 | 23 | 98 | 2 | 3 | 248 | 8 | 85 | MCB9563607.1 HAMP domain-containing histidine kinase [Kofleriaceae bacterium] | diamond | 246 | 87.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31757381 | 31757381 | PRJNA688414_P_NODE_7057_length_248_cov_0.891429_g7023_i0 | PRJNA688414 | 7057 | 248 | 0.891429 | 2.21074392 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 112 | 4.05e-27 | NR | HEY0478142.1 | 2212474 | g7023 | i0 | 67.6 | 0.895161290322581 | 74 | 24 | 89.5 | 0 | 25 | 246 | 1 | 74 | HEY0478142.1 ATP-binding protein [Kofleriaceae bacterium] | diamond | 222 | 112 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32453730 | 32453730 | PRJNA688414_P_NODE_6859_length_249_cov_0.886364_g6825_i0 | PRJNA688414 | 6859 | 249 | 0.886364 | 2.20704636 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.9 | 0.00941 | NR | MDX2019878.1 | 2026735 | g6825 | i0 | 74.1 | 0.650602409638554 | 27 | 7 | 32.5 | 0 | 2 | 82 | 146 | 172 | MDX2019878.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 162 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32548637 | 32548637 | PRJNA688414_P_NODE_6659_length_250_cov_0.881356_g6625_i0 | PRJNA688414 | 6659 | 250 | 0.881356 | 2.20339 | Polyangium mundeleinium | 2995306 | Bacteria | Bacteria | 56.6 | 5.38e-7 | NR | WP_271916737.1 | 2995306 | g6625 | i0 | 41.6 | 0.924 | 77 | 43 | 92.4 | 2 | 249 | 19 | 728 | 802 | WP_271916737.1 hypothetical protein [Polyangium mundeleinium] | diamond | 231 | 56.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium mundeleinium |
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);;