contig_metadata
17 rows where bioproject = "PRJNA1108009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13773781 | 13773781 | PRJNA1108009_P_NODE_24491_length_252_cov_1.284916_g24173_i0 | PRJNA1108009 | 24491 | 252 | 1.284916 | 3.23798832 | Chondromyces | 50 | Bacteria | Bacteria | 377 | 3.32e-100 | NTclustered | gi|169977285|emb|AM946600.1| | 52 | g24173 | i0 | 93.651 | 142.892857142857 | 252 | 16 | 100 | 0 | 1 | 252 | 1952 | 2203 | Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 | blastn | 36009 | 377 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 26678938 | 26678938 | PRJNA1108009_P_NODE_16481_length_323_cov_0.924000_g16163_i0 | PRJNA1108009 | 16481 | 323 | 0.924 | 2.98452 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47 | 0.00292 | NR | MDD5307824.1 | 2026735 | g16163 | i0 | 44.2 | 2.1640866873065 | 52 | 29 | 48.3 | 0 | 317 | 162 | 160 | 211 | MDD5307824.1 kelch repeat-containing protein [Deltaproteobacteria bacterium] | diamond | 699 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27216792 | 27216792 | PRJNA1108009_P_NODE_31782_length_241_cov_0.916667_g31464_i0 | PRJNA1108009 | 31782 | 241 | 0.916667 | 2.20916747 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 108 | 1.16e-26 | NR | HMY21013.1 | 57 | g31464 | i0 | 63.3 | 4.96680497925311 | 79 | 29 | 98.3 | 0 | 240 | 4 | 102 | 180 | HMY21013.1 hypothetical protein [Polyangium sp.] | diamond | 1197 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 27636521 | 27636521 | PRJNA1108009_P_NODE_28264_length_246_cov_0.890173_g27946_i0 | PRJNA1108009 | 28264 | 246 | 0.890173 | 2.18982558 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 40.4 | 0.0364 | NR | MBV5337252.1 | 2026735 | g27946 | i0 | 42.3 | 0.634146341463415 | 52 | 27 | 63.4 | 2 | 3 | 158 | 2 | 50 | MBV5337252.1 ankyrin repeat domain-containing protein [Deltaproteobacteria bacterium] | diamond | 156 | 40.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27794411 | 27794411 | PRJNA1108009_P_NODE_28364_length_246_cov_0.890173_g28046_i0 | PRJNA1108009 | 28364 | 246 | 0.890173 | 2.18982558 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 50.1 | 1.24e-5 | NR | MBM4313495.1 | 2026735 | g28046 | i0 | 33.3 | 0.731707317073171 | 60 | 39 | 72 | 1 | 201 | 25 | 36 | 95 | MBM4313495.1 barstar family protein [Deltaproteobacteria bacterium] | diamond | 180 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28078336 | 28078336 | PRJNA1108009_P_NODE_29085_length_245_cov_0.895349_g28767_i0 | PRJNA1108009 | 29085 | 245 | 0.895349 | 2.19360505 | Myxococcus sp. XM-1-1-1 | 2874602 | Bacteria | Bacteria | 42.7 | 0.0373 | NR | WP_223751411.1 | 2874602 | g28767 | i0 | 33.3 | 0.881632653061225 | 72 | 42 | 80.8 | 2 | 245 | 48 | 127 | 198 | WP_223751411.1 hypothetical protein [Myxococcus sp. XM-1-1-1] | diamond | 216 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus sp. XM-1-1-1 | ||
| 28173034 | 28173034 | PRJNA1108009_P_NODE_23846_length_257_cov_0.994565_g23528_i0 | PRJNA1108009 | 23846 | 257 | 0.994565 | 2.5560320500000002 | Anaeromyxobacter sp. | 1872521 | Bacteria | Bacteria | 51.6 | 3.34e-5 | NR | HEY6005564.1 | 1872521 | g23528 | i0 | 36 | 1.03891050583658 | 89 | 45 | 95.7 | 4 | 255 | 10 | 40 | 123 | HEY6005564.1 Ig-like domain-containing protein [Anaeromyxobacter sp.] | diamond | 267 | 51.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. | ||
| 28488937 | 28488937 | PRJNA1108009_P_NODE_20367_length_285_cov_0.877358_g20049_i0 | PRJNA1108009 | 20367 | 285 | 0.877358 | 2.5004703 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 59.7 | 6.6e-8 | NR | HMF42392.1 | 3058050 | g20049 | i0 | 64.1 | 0.957894736842105 | 39 | 14 | 41.1 | 0 | 244 | 128 | 6 | 44 | HMF42392.1 DUF1592 domain-containing protein [Polyangia bacterium] | diamond | 273 | 59.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 28804396 | 28804396 | PRJNA1108009_P_NODE_29968_length_243_cov_1.541176_g29650_i0 | PRJNA1108009 | 29968 | 243 | 1.541176 | 3.74505768 | Cystobacter ferrugineus | 83449 | Bacteria | Bacteria | 84.7 | 1.26e-17 | NR | WP_084736591.1 | 83449 | g29650 | i0 | 52.4 | 1.01234567901235 | 82 | 37 | 98.8 | 1 | 4 | 243 | 81 | 162 | WP_084736591.1 YdcF family protein [Cystobacter ferrugineus] | diamond | 246 | 84.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter ferrugineus | ||
| 28962729 | 28962729 | PRJNA1108009_P_NODE_12748_length_372_cov_1.906355_g12430_i0 | PRJNA1108009 | 12748 | 372 | 1.906355 | 7.0916406 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 44.7 | 0.0327 | NR | WP_020732738.1 | 56 | g12430 | i0 | 44 | 0.403225806451613 | 50 | 27 | 40.3 | 1 | 73 | 222 | 415 | 463 | WP_020732738.1 serine/threonine-protein kinase [Sorangium cellulosum] | diamond | 150 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 29309749 | 29309749 | PRJNA1108009_P_NODE_27309_length_247_cov_1.149425_g26991_i0 | PRJNA1108009 | 27309 | 247 | 1.149425 | 2.83907975 | Archangium sp. | 1872627 | Bacteria | Bacteria | 85.9 | 8.11e-18 | NR | HEY0095906.1 | 1872627 | g26991 | i0 | 52.4 | 3.95951417004049 | 82 | 35 | 99.6 | 1 | 247 | 2 | 232 | 309 | HEY0095906.1 LysM peptidoglycan-binding domain-containing protein [Archangium sp.] | diamond | 978 | 85.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 29972915 | 29972915 | PRJNA1108009_P_NODE_14531_length_346_cov_1.780220_g14213_i0 | PRJNA1108009 | 14531 | 346 | 1.78022 | 6.1595612 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 70.1 | 3.21e-11 | NR | NUQ72474.1 | 2268199 | g14213 | i0 | 46 | 0.754335260115607 | 87 | 46 | 75.4 | 1 | 300 | 40 | 90 | 175 | NUQ72474.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 261 | 70.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30478542 | 30478542 | PRJNA1108009_P_NODE_11493_length_395_cov_1.201863_g11175_i0 | PRJNA1108009 | 11493 | 395 | 1.201863 | 4.74735885 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 55.8 | 5.6e-6 | NR | MEW5847593.1 | 2818507 | g11175 | i0 | 40 | 0.911392405063291 | 120 | 63 | 89.6 | 8 | 40 | 393 | 809 | 921 | MEW5847593.1 hypothetical protein [Myxococcota bacterium] | diamond | 360 | 55.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30636233 | 30636233 | PRJNA1108009_P_NODE_27173_length_248_cov_0.880000_g26855_i0 | PRJNA1108009 | 27173 | 248 | 0.88 | 2.1824 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 53.5 | 6.44e-6 | NR | MEW5847593.1 | 2818507 | g26855 | i0 | 43.4 | 1.875 | 76 | 39 | 91.9 | 2 | 1 | 228 | 1085 | 1156 | MEW5847593.1 hypothetical protein [Myxococcota bacterium] | diamond | 465 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31015568 | 31015568 | PRJNA1108009_P_NODE_27115_length_248_cov_0.880000_g26797_i0 | PRJNA1108009 | 27115 | 248 | 0.88 | 2.1824 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.1 | 0.00575 | NR | MCP4664832.1 | 2026735 | g26797 | i0 | 29.2 | 0.870967741935484 | 72 | 51 | 87.1 | 0 | 243 | 28 | 101 | 172 | MCP4664832.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 216 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31679459 | 31679459 | PRJNA1108009_P_NODE_9757_length_434_cov_1.706371_g9439_i0 | PRJNA1108009 | 9757 | 434 | 1.706371 | 7.40565014 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 50.8 | 3.72e-4 | NR | MCB9737160.1 | 2026735 | g9439 | i0 | 48.9 | 0.324884792626728 | 47 | 24 | 32.5 | 0 | 431 | 291 | 3 | 49 | MCB9737160.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 141 | 50.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31837568 | 31837568 | PRJNA1108009_P_NODE_31137_length_242_cov_0.911243_g30819_i0 | PRJNA1108009 | 31137 | 242 | 0.911243 | 2.20520806 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 61.2 | 1.1e-8 | NR | MCB9640167.1 | 2026763 | g30819 | i0 | 61.9 | 2.08264462809917 | 42 | 16 | 52.1 | 0 | 240 | 115 | 538 | 579 | MCB9640167.1 ATP-binding cassette domain-containing protein [Myxococcales bacterium] | diamond | 504 | 61.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales 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);;