contig_metadata
24 rows where bioproject = "PRJEB7366", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5237789 | 5237789 | PRJEB7366_P_NODE_15425_length_199_cov_0.975610_g14991_i0 | PRJEB7366 | 15425 | 199 | 0.97561 | 1.9414639 | Minicystis rosea | 888845 | Bacteria | Bacteria | 217 | 5.79e-52 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g14991 | i0 | 87.179 | 177 | 195 | 20 | 96 | 4 | 1 | 191 | 768945 | 769138 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 35223 | 217 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 14163648 | 14163648 | PRJEB7366_P_NODE_16192_length_193_cov_1.265823_g15758_i0 | PRJEB7366 | 16192 | 193 | 1.265823 | 2.44303839 | Polyangiaceae | 49 | Bacteria | Bacteria | 114 | 1.26e-30 | NR | HMY20693.1 | 57 | g15758 | i0 | 84.1 | 2.92227979274611 | 63 | 10 | 97.9 | 0 | 3 | 191 | 5 | 67 | HMY20693.1 peptidylprolyl isomerase [Polyangium sp.] | diamond | 564 | 114 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 16298178 | 16298178 | PRJEB7366_P_NODE_15773_length_196_cov_1.559006_g15339_i0 | PRJEB7366 | 15773 | 196 | 1.559006 | 3.05565176 | Polyangiales | 3031712 | Bacteria | Bacteria | 252 | 1.56e-62 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g15339 | i0 | 90.155 | 300.811224489796 | 193 | 19 | 100 | 0 | 4 | 196 | 3451848 | 3451656 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 58959 | 254 | 0.992125984251969 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 23087090 | 23087090 | PRJEB7366_P_NODE_8959_length_282_cov_1.457490_g8525_i0 | PRJEB7366 | 8959 | 282 | 1.45749 | 4.1101218 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 160 | 4.72e-45 | NR | TMA69970.1 | 2026735 | g8525 | i0 | 84.8 | 60.6808510638298 | 92 | 14 | 97.9 | 0 | 5 | 280 | 314 | 405 | TMA69970.1 MAG: NADP-dependent isocitrate dehydrogenase [Deltaproteobacteria bacterium] | diamond | 17112 | 161 | 0.993788819875776 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26590640 | 26590640 | PRJEB7366_P_NODE_1561_length_790_cov_1.692715_g1249_i0 | PRJEB7366 | 1561 | 790 | 1.692715 | 13.3724485 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 58.9 | 6.18e-6 | NR | HZL16340.1 | 3058050 | g1249 | i0 | 42.5 | 0.854430379746835 | 80 | 41 | 30.4 | 3 | 733 | 494 | 83 | 157 | HZL16340.1 right-handed parallel beta-helix repeat-containing protein [Polyangia bacterium] | diamond | 675 | 58.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 26685825 | 26685825 | PRJEB7366_P_NODE_24841_length_150_cov_1.243478_g24407_i0 | PRJEB7366 | 24841 | 150 | 1.243478 | 1.865217 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 53.1 | 2.17e-6 | NR | MBM4353825.1 | 2026735 | g24407 | i0 | 62.5 | 2.36 | 40 | 11 | 80 | 1 | 5 | 124 | 922 | 957 | MBM4353825.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 354 | 53.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26907558 | 26907558 | PRJEB7366_P_NODE_11062_length_246_cov_1.587678_g10628_i0 | PRJEB7366 | 11062 | 246 | 1.587678 | 3.90568788 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 94 | 3.66e-20 | NR | MFT3924888.1 | 2026763 | g10628 | i0 | 55.6 | 1.98780487804878 | 81 | 36 | 98.8 | 0 | 243 | 1 | 494 | 574 | MFT3924888.1 acyl-CoA dehydrogenase C-terminal domain-containing protein [Myxococcales bacterium] | diamond | 489 | 94 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27445261 | 27445261 | PRJEB7366_P_NODE_14243_length_209_cov_1.609195_g13809_i0 | PRJEB7366 | 14243 | 209 | 1.609195 | 3.36321755 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 93.6 | 1.48e-20 | NR | MBW2616657.1 | 2026735 | g13809 | i0 | 65.2 | 1.98086124401914 | 69 | 24 | 99 | 0 | 207 | 1 | 162 | 230 | MBW2616657.1 thiolase family protein [Deltaproteobacteria bacterium] | diamond | 414 | 93.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27571224 | 27571224 | PRJEB7366_P_NODE_15784_length_196_cov_1.490683_g15350_i0 | PRJEB7366 | 15784 | 196 | 1.490683 | 2.92173868 | Enhygromyxa salina | 215803 | Bacteria | Bacteria | 48.9 | 1.32e-4 | NR | WP_181233537.1 | 215803 | g15350 | i0 | 36.4 | 3.01530612244898 | 66 | 39 | 99.5 | 2 | 195 | 1 | 197 | 260 | WP_181233537.1 Rieske 2Fe-2S domain-containing protein [Enhygromyxa salina] | diamond | 591 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Enhygromyxa | Enhygromyxa salina | |||
| 27627372 | 27627372 | PRJEB7366_P_NODE_24904_length_150_cov_1.043478_g24470_i0 | PRJEB7366 | 24904 | 150 | 1.043478 | 1.565217 | Bacteria | 2 | Bacteria | Bacteria | 52 | 4.66e-7 | NR | PRQ00564.1 | 215803 | g24470 | i0 | 43.5 | 6.16 | 46 | 25 | 92 | 1 | 13 | 150 | 24 | 68 | PRQ00564.1 Cysteine-rich secretory protein family protein [Enhygromyxa salina] | diamond | 924 | 52.4 | 0.99236641221374 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Enhygromyxa | Enhygromyxa salina | |||
| 27981781 | 27981781 | PRJEB7366_P_NODE_15045_length_202_cov_1.622754_g14611_i0 | PRJEB7366 | 15045 | 202 | 1.622754 | 3.27796308 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.9 | 0.00853 | NR | MCK6509442.1 | 2818507 | g14611 | i0 | 52.2 | 0.683168316831683 | 46 | 17 | 66.8 | 3 | 139 | 5 | 240 | 281 | MCK6509442.1 hypothetical protein [Myxococcota bacterium] | diamond | 138 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28258535 | 28258535 | PRJEB7366_P_NODE_5506_length_383_cov_2.836207_g5073_i0 | PRJEB7366 | 5506 | 383 | 2.836207 | 10.86267281 | Myxococcia | 32015 | Bacteria | Bacteria | 52 | 9.69e-5 | NR | NMB76287.1 | 2026763 | g5073 | i0 | 34.7 | 4.50391644908616 | 121 | 48 | 79.9 | 8 | 368 | 63 | 96 | 204 | NMB76287.1 hypothetical protein [Myxococcales bacterium] | diamond | 1725 | 52.4 | 0.99236641221374 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28518584 | 28518584 | PRJEB7366_P_NODE_5527_length_382_cov_1.945245_g5094_i0 | PRJEB7366 | 5527 | 382 | 1.945245 | 7.4308359 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 47 | 0.0051 | NR | MBI5526680.1 | 2026735 | g5094 | i0 | 33 | 0.714659685863874 | 91 | 55 | 71.5 | 3 | 52 | 324 | 242 | 326 | MBI5526680.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 273 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29213361 | 29213361 | PRJEB7366_P_NODE_4429_length_440_cov_1.733333_g4000_i0 | PRJEB7366 | 4429 | 440 | 1.733333 | 7.6266652 | Archangium sp. Cb G35 | 1920190 | Bacteria | Bacteria | 46.2 | 0.0174 | NR | WP_073567540.1 | 1920190 | g4000 | i0 | 44.3 | 0.415909090909091 | 61 | 32 | 41.6 | 1 | 440 | 258 | 126 | 184 | WP_073567540.1 GON domain-containing protein [Archangium sp. Cb G35] | diamond | 183 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. Cb G35 | ||
| 29907935 | 29907935 | PRJEB7366_P_NODE_15271_length_200_cov_1.345455_g14837_i0 | PRJEB7366 | 15271 | 200 | 1.345455 | 2.69091 | Myxococcus sp. RHSTA-1-4 | 2874601 | Bacteria | Bacteria | 55.5 | 2.21e-8 | NR | WP_223760390.1 | 2874601 | g14837 | i0 | 63.3 | 0.9 | 30 | 11 | 45 | 0 | 9 | 98 | 10 | 39 | WP_223760390.1 hypothetical protein [Myxococcus sp. RHSTA-1-4] | diamond | 180 | 55.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus sp. RHSTA-1-4 | ||
| 30563747 | 30563747 | PRJEB7366_P_NODE_11053_length_246_cov_1.838863_g10619_i0 | PRJEB7366 | 11053 | 246 | 1.838863 | 4.52360298 | Polyangium | 55 | Bacteria | Bacteria | 43.1 | 0.0279 | NR | HMY17848.1 | 57 | g10619 | i0 | 37.1 | 2.46341463414634 | 62 | 37 | 73.2 | 1 | 59 | 238 | 110 | 171 | HMY17848.1 choice-of-anchor L domain-containing protein [Polyangium sp.] | diamond | 606 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 30855561 | 30855561 | PRJEB7366_P_NODE_12914_length_223_cov_1.063830_g12480_i0 | PRJEB7366 | 12914 | 223 | 1.06383 | 2.3723409 | Sandaracinus sp. | 2024858 | Bacteria | Bacteria | 57.4 | 1.39e-7 | NR | MCB9612965.1 | 2024858 | g12480 | i0 | 51.1 | 1.62780269058296 | 45 | 22 | 60.5 | 0 | 135 | 1 | 54 | 98 | MCB9612965.1 CAP domain-containing protein [Sandaracinus sp.] | diamond | 363 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus sp. | |||
| 31101019 | 31101019 | PRJEB7366_P_NODE_8875_length_283_cov_3.645161_g8441_i0 | PRJEB7366 | 8875 | 283 | 3.645161 | 10.31580563 | Bacteria | 2 | Bacteria | Bacteria | 137 | 2.05e-36 | NR | MCP4679037.1 | 2026735 | g8441 | i0 | 65.6 | 4.92932862190813 | 93 | 32 | 98.6 | 0 | 282 | 4 | 206 | 298 | MCP4679037.1 GTPase [Deltaproteobacteria bacterium] | diamond | 1395 | 137 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31139598 | 31139598 | PRJEB7366_P_NODE_8935_length_282_cov_3.599190_g8501_i0 | PRJEB7366 | 8935 | 282 | 3.59919 | 10.1497158 | Polyangium aurulentum | 2567896 | Bacteria | Bacteria | 43.9 | 0.022 | NR | WP_136921029.1 | 2567896 | g8501 | i0 | 38.2 | 0.723404255319149 | 68 | 42 | 72.3 | 0 | 54 | 257 | 327 | 394 | WP_136921029.1 YeeE/YedE family protein [Polyangium aurulentum] | diamond | 204 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum | |||
| 31614340 | 31614340 | PRJEB7366_P_NODE_2656_length_589_cov_2.523466_g2261_i0 | PRJEB7366 | 2656 | 589 | 2.523466 | 14.86321474 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 65.9 | 1.02e-8 | NR | MCU0654460.1 | 2268199 | g2261 | i0 | 34.3 | 1.6553480475382 | 137 | 72 | 67.7 | 8 | 148 | 546 | 183 | 305 | MCU0654460.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 975 | 65.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31709265 | 31709265 | PRJEB7366_P_NODE_12277_length_230_cov_1.887179_g11843_i0 | PRJEB7366 | 12277 | 230 | 1.887179 | 4.3405117 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 63.5 | 3.29e-10 | NR | HEX4475590.1 | 2268199 | g11843 | i0 | 68.6 | 0.939130434782609 | 35 | 11 | 45.7 | 0 | 119 | 15 | 151 | 185 | HEX4475590.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 216 | 63.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31891796 | 31891796 | PRJEB7366_P_NODE_19657_length_172_cov_1.167883_g19223_i0 | PRJEB7366 | 19657 | 172 | 1.167883 | 2.00875876 | root | 1 | Root_unresolved | Root_unresolved | 105 | 1.41e-24 | NR | MBN8538494.1 | 2026735 | g19223 | i0 | 80.4 | 3.90697674418605 | 56 | 11 | 97.7 | 0 | 3 | 170 | 92 | 147 | MBN8538494.1 phosphoenolpyruvate carboxykinase (GTP) [Deltaproteobacteria bacterium] | diamond | 672 | 105 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32461471 | 32461471 | PRJEB7366_P_NODE_18519_length_178_cov_1.167832_g18085_i0 | PRJEB7366 | 18519 | 178 | 1.167832 | 2.07874096 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 75.9 | 3.28e-14 | NR | GMV42537.1 | 2026763 | g18085 | i0 | 52.5 | 1.97191011235955 | 59 | 28 | 99.4 | 0 | 2 | 178 | 398 | 456 | GMV42537.1 MAG: hypothetical protein AMXMBFR64_42530 [Myxococcales bacterium] | diamond | 351 | 76.3 | 0.99475753604194 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32878348 | 32878348 | PRJEB7366_P_NODE_720_length_1131_cov_2.185219_g528_i0 | PRJEB7366 | 720 | 1131 | 2.185219 | 24.71482689 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 48.9 | 0.0249 | NR | MCK6508598.1 | 2818507 | g528 | i0 | 29.8 | 0.302387267904509 | 114 | 56 | 27.9 | 4 | 141 | 455 | 187 | 285 | MCK6508598.1 hypothetical protein [Myxococcota bacterium] | diamond | 342 | 48.9 | 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);;