contig_metadata
20 rows where bioproject = "PRJNA758088", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7114721 | 7114721 | PRJNA758088_P_NODE_225666_length_284_cov_0.838863_g218695_i0 | PRJNA758088 | 225666 | 284 | 0.838863 | 2.38237092 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 70.5 | 9.52e-13 | NR | MEE3328847.1 | 2818507 | g218695 | i0 | 58.1 | 0.654929577464789 | 62 | 25 | 65.5 | 1 | 70 | 255 | 56 | 116 | MEE3328847.1 (2Fe-2S)-binding protein [Myxococcota bacterium] | diamond | 186 | 70.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27115989 | 27115989 | PRJNA758088_P_NODE_338722_length_244_cov_0.900585_g331751_i0 | PRJNA758088 | 338722 | 244 | 0.900585 | 2.1974274 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 136 | 1.63e-38 | NR | MPZ77540.1 | 2026735 | g331751 | i0 | 84.8 | 1.94262295081967 | 79 | 12 | 97.1 | 0 | 6 | 242 | 24 | 102 | MPZ77540.1 NADH-quinone oxidoreductase subunit C [Deltaproteobacteria bacterium] | diamond | 474 | 136 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27242579 | 27242579 | PRJNA758088_P_NODE_243903_length_272_cov_1.547739_g236932_i0 | PRJNA758088 | 243903 | 272 | 1.547739 | 4.20985008 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 110 | 5.200000000000001e-28 | NR | MBI5587846.1 | 2026735 | g236932 | i0 | 60.9 | 0.959558823529412 | 87 | 34 | 96 | 0 | 272 | 12 | 91 | 177 | MBI5587846.1 NAD(P)H:quinone oxidoreductase [Deltaproteobacteria bacterium] | diamond | 261 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27400780 | 27400780 | PRJNA758088_P_NODE_350003_length_243_cov_0.905882_g343032_i0 | PRJNA758088 | 350003 | 243 | 0.905882 | 2.20129326 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 42.7 | 0.0391 | NR | MBL92312.1 | 2026763 | g343032 | i0 | 40 | 0.740740740740741 | 60 | 33 | 70.4 | 1 | 46 | 216 | 179 | 238 | MBL92312.1 hypothetical protein [Myxococcales bacterium] | diamond | 180 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27463931 | 27463931 | PRJNA758088_P_NODE_307443_length_248_cov_0.880000_g300472_i0 | PRJNA758088 | 307443 | 248 | 0.88 | 2.1824 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 50.1 | 9.93e-5 | NR | HJN74097.1 | 2818507 | g300472 | i0 | 40.4 | 0.689516129032258 | 57 | 28 | 69 | 1 | 1 | 171 | 265 | 315 | HJN74097.1 MopE-related protein [Myxococcota bacterium] | diamond | 171 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28231094 | 28231094 | PRJNA758088_P_NODE_216006_length_290_cov_1.064516_g209035_i0 | PRJNA758088 | 216006 | 290 | 1.064516 | 3.0870964 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 112 | 2.02e-27 | NR | MCA9534367.1 | 2026763 | g209035 | i0 | 55.2 | 4.90344827586207 | 96 | 43 | 99.3 | 0 | 3 | 290 | 84 | 179 | MCA9534367.1 methyltransferase domain-containing protein [Myxococcales bacterium] | diamond | 1422 | 112 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28695379 | 28695379 | PRJNA758088_P_NODE_299887_length_249_cov_0.875000_g292916_i0 | PRJNA758088 | 299887 | 249 | 0.875 | 2.17875 | Sandaracinaceae bacterium | 2510337 | Bacteria | Bacteria | 152 | 3.789999999999999e-42 | NR | MBK7778861.1 | 2510337 | g292916 | i0 | 93.9 | 0.987951807228916 | 82 | 5 | 98.8 | 0 | 247 | 2 | 90 | 171 | MBK7778861.1 tetratricopeptide repeat protein [Sandaracinaceae bacterium] | diamond | 246 | 152 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinaceae bacterium | ||||
| 28799460 | 28799460 | PRJNA758088_P_NODE_189287_length_309_cov_1.050847_g182316_i0 | PRJNA758088 | 189287 | 309 | 1.050847 | 3.24711723 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 86.7 | 2.79e-17 | NR | MBL8606644.1 | 2026763 | g182316 | i0 | 53.3 | 2.18446601941748 | 75 | 34 | 71.8 | 1 | 86 | 307 | 330 | 404 | MBL8606644.1 hypothetical protein [Myxococcales bacterium] | diamond | 675 | 87.4 | 0.991990846681922 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29042664 | 29042664 | PRJNA758088_P_NODE_294448_length_250_cov_0.870056_g287477_i0 | PRJNA758088 | 294448 | 250 | 0.870056 | 2.17514 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 44.7 | 0.00854 | NR | MBI5642274.1 | 2026735 | g287477 | i0 | 33.3 | 1.548 | 66 | 41 | 79.2 | 2 | 225 | 28 | 14 | 76 | MBI5642274.1 diguanylate cyclase [Deltaproteobacteria bacterium] | diamond | 387 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29168989 | 29168989 | PRJNA758088_P_NODE_89729_length_445_cov_1.241935_g82760_i0 | PRJNA758088 | 89729 | 445 | 1.241935 | 5.52661075 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 228 | 3.11e-69 | NR | MCP4669207.1 | 2026735 | g82760 | i0 | 77.7 | 0.997752808988764 | 148 | 33 | 99.8 | 0 | 444 | 1 | 180 | 327 | MCP4669207.1 molecular chaperone DnaK [Deltaproteobacteria bacterium] | diamond | 444 | 228 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30189078 | 30189078 | PRJNA758088_P_NODE_293372_length_250_cov_0.870056_g286401_i0 | PRJNA758088 | 293372 | 250 | 0.870056 | 2.17514 | Myxococcia | 32015 | Bacteria | Bacteria | 125 | 4.69e-33 | NR | MBL9020351.1 | 2026763 | g286401 | i0 | 71.6 | 2.916 | 81 | 23 | 97.2 | 0 | 8 | 250 | 231 | 311 | MBL9020351.1 Zn-dependent exopeptidase M28 [Myxococcales bacterium] | diamond | 729 | 125 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30401014 | 30401014 | PRJNA758088_P_NODE_263193_length_261_cov_1.015957_g256222_i0 | PRJNA758088 | 263193 | 261 | 1.015957 | 2.65164777 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 42.7 | 0.0313 | NR | HEY0479080.1 | 2212474 | g256222 | i0 | 35.2 | 0.816091954022989 | 71 | 41 | 77 | 2 | 59 | 259 | 11 | 80 | HEY0479080.1 GNAT family N-acetyltransferase [Kofleriaceae bacterium] | diamond | 213 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 30558281 | 30558281 | PRJNA758088_P_NODE_155633_length_338_cov_1.452830_g148662_i0 | PRJNA758088 | 155633 | 338 | 1.45283 | 4.9105654 | Sandaracinus sp. | 2024858 | Bacteria | Bacteria | 73.2 | 6.27e-13 | NR | MBJ70584.1 | 2024858 | g148662 | i0 | 38.4 | 0.994082840236686 | 112 | 66 | 96.7 | 2 | 10 | 336 | 50 | 161 | MBJ70584.1 hypothetical protein [Sandaracinus sp.] | diamond | 336 | 73.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus sp. | |||
| 30811258 | 30811258 | PRJNA758088_P_NODE_276814_length_253_cov_1.077778_g269843_i0 | PRJNA758088 | 276814 | 253 | 1.077778 | 2.72677834 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 44.7 | 0.00848 | NR | HYV44386.1 | 2484252 | g269843 | i0 | 37.7 | 0.723320158102767 | 61 | 37 | 72.3 | 1 | 215 | 33 | 163 | 222 | HYV44386.1 gliding motility protein [Myxococcaceae bacterium] | diamond | 183 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 30906259 | 30906259 | PRJNA758088_P_NODE_362214_length_241_cov_0.916667_g355243_i0 | PRJNA758088 | 362214 | 241 | 0.916667 | 2.20916747 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 77.8 | 1.13e-14 | NR | HEY4015300.1 | 2268199 | g355243 | i0 | 50.6 | 1.00829875518672 | 81 | 37 | 98.3 | 2 | 2 | 238 | 220 | 299 | HEY4015300.1 hybrid sensor histidine kinase/response regulator [Polyangiaceae bacterium] | diamond | 243 | 77.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31696464 | 31696464 | PRJNA758088_P_NODE_365717_length_241_cov_0.916667_g358746_i0 | PRJNA758088 | 365717 | 241 | 0.916667 | 2.20916747 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 119 | 3.8199999999999995e-30 | NR | MBP6743313.1 | 2026735 | g358746 | i0 | 85.9 | 0.970954356846473 | 78 | 11 | 97.1 | 0 | 234 | 1 | 1 | 78 | MBP6743313.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 234 | 119 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32139450 | 32139450 | PRJNA758088_P_NODE_313758_length_247_cov_0.885057_g306787_i0 | PRJNA758088 | 313758 | 247 | 0.885057 | 2.18609079 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 82 | 2.43e-16 | NR | HVJ21548.1 | 2268199 | g306787 | i0 | 50 | 0.995951417004049 | 82 | 41 | 99.6 | 0 | 246 | 1 | 87 | 168 | HVJ21548.1 transglutaminase family protein [Polyangiaceae bacterium] | diamond | 246 | 82 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32582464 | 32582464 | PRJNA758088_P_NODE_315419_length_247_cov_0.885057_g308448_i0 | PRJNA758088 | 315419 | 247 | 0.885057 | 2.18609079 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 67.8 | 5.74e-11 | NR | RLB48654.1 | 2026735 | g308448 | i0 | 42.9 | 1.90688259109312 | 77 | 41 | 93.5 | 1 | 1 | 231 | 294 | 367 | RLB48654.1 MAG: hypothetical protein DRJ42_22720 [Deltaproteobacteria bacterium] | diamond | 471 | 67.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32644949 | 32644949 | PRJNA758088_P_NODE_246920_length_270_cov_2.076142_g239949_i0 | PRJNA758088 | 246920 | 270 | 2.076142 | 5.6055834 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 52.4 | 8.59e-6 | NR | MCP4666834.1 | 2026735 | g239949 | i0 | 89.3 | 0.311111111111111 | 28 | 3 | 31.1 | 0 | 4 | 87 | 148 | 175 | MCP4666834.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 84 | 52.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32906802 | 32906802 | PRJNA758088_P_NODE_341120_length_244_cov_0.900585_g334149_i0 | PRJNA758088 | 341120 | 244 | 0.900585 | 2.1974274 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 51.6 | 2.92e-5 | NR | MFT3765888.1 | 1971901 | g334149 | i0 | 34.7 | 1.73360655737705 | 75 | 43 | 84.8 | 1 | 8 | 214 | 140 | 214 | MFT3765888.1 IPT/TIG domain-containing protein [Minicystis sp.] | diamond | 423 | 51.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis 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);;