contig_metadata
27 rows where bioproject = "PRJNA700095", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 683264 | 683264 | PRJNA700095_P_NODE_44761_length_264_cov_2.062827_g43497_i0 | PRJNA700095 | 44761 | 264 | 2.062827 | 5.44586328 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 60.8 | 1.91e-8 | NR | MCZ6805859.1 | 2026735 | g43497 | i0 | 81.8 | 1.5 | 33 | 6 | 37.5 | 0 | 262 | 164 | 392 | 424 | MCZ6805859.1 pyruvate dehydrogenase complex dihydrolipoamide acetyltransferase [Deltaproteobacteria bacterium] | diamond | 396 | 60.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 2459429 | 2459429 | PRJNA700095_P_NODE_48362_length_257_cov_1.103261_g47098_i0 | PRJNA700095 | 48362 | 257 | 1.103261 | 2.83538077 | Corallococcus | 83461 | Bacteria | Bacteria | 436 | 5.52e-118 | NTclustered | gi|545790941|gb|KF270704.1| | 35 | g47098 | i0 | 97.276 | 245.194552529183 | 257 | 7 | 100 | 0 | 1 | 257 | 876 | 620 | Corallococcus macrosporus strain Ccm7 23S ribosomal RNA gene, partial sequence | blastn | 63015 | 436 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus macrosporus | ||
| 7061767 | 7061767 | PRJNA700095_P_NODE_33146_length_296_cov_2.304933_g31882_i0 | PRJNA700095 | 33146 | 296 | 2.304933 | 6.82260168 | Pyxidicoccus parkwayensis | 2813578 | Bacteria | Bacteria | 483 | 8.219999999999998e-132 | NTclustered | gi|1998505907|gb|CP071090.1| | 2813578 | g31882 | i0 | 96.259 | 267.804054054054 | 294 | 11 | 99 | 0 | 1 | 294 | 2161209 | 2161502 | Pyxidicoccus parkwaysis strain SCPEA02 chromosome | blastn | 79270 | 483 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pyxidicoccus | Pyxidicoccus parkwayensis | ||
| 27082737 | 27082737 | PRJNA700095_P_NODE_24722_length_346_cov_2.249084_g23458_i0 | PRJNA700095 | 24722 | 346 | 2.249084 | 7.78183064 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 179 | 6.089999999999999e-55 | NR | RYZ16037.1 | 2484252 | g23458 | i0 | 71.3 | 0.997109826589595 | 115 | 33 | 99.7 | 0 | 2 | 346 | 54 | 168 | RYZ16037.1 MAG: formate--tetrahydrofolate ligase [Myxococcaceae bacterium] | diamond | 345 | 179 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 27272405 | 27272405 | PRJNA700095_P_NODE_65003_length_241_cov_1.476190_g63739_i0 | PRJNA700095 | 65003 | 241 | 1.47619 | 3.5576179 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 52.4 | 1.27e-5 | NR | MBW1756897.1 | 2026735 | g63739 | i0 | 39.3 | 1.51867219917012 | 61 | 34 | 75.9 | 2 | 55 | 237 | 28 | 85 | MBW1756897.1 phosphotransferase [Deltaproteobacteria bacterium] | diamond | 366 | 52.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27367534 | 27367534 | PRJNA700095_P_NODE_50903_length_251_cov_2.146067_g49639_i0 | PRJNA700095 | 50903 | 251 | 2.146067 | 5.38662817 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 92 | 4.05e-20 | NR | RYZ16325.1 | 2484252 | g49639 | i0 | 60.9 | 0.824701195219124 | 69 | 27 | 82.5 | 0 | 3 | 209 | 144 | 212 | RYZ16325.1 MAG: solute carrier family 25 protein, partial [Myxococcaceae bacterium] | diamond | 207 | 92 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 27935619 | 27935619 | PRJNA700095_P_NODE_10525_length_597_cov_3.572519_g9287_i0 | PRJNA700095 | 10525 | 597 | 3.5725189999999998 | 21.32793843 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 84 | 1.68e-15 | NR | MBK7580488.1 | 2026763 | g9287 | i0 | 40.3 | 1.19597989949749 | 119 | 67 | 59.3 | 3 | 42 | 395 | 182 | 297 | MBK7580488.1 endonuclease/exonuclease/phosphatase family protein [Myxococcales bacterium] | diamond | 714 | 84 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27998930 | 27998930 | PRJNA700095_P_NODE_7725_length_714_cov_2.070203_g6574_i0 | PRJNA700095 | 7725 | 714 | 2.070203 | 14.78124942 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 101 | 1.37e-22 | NR | MEI7893546.1 | 2026763 | g6574 | i0 | 38.5 | 1.55042016806723 | 187 | 86 | 68.5 | 5 | 714 | 226 | 9 | 190 | MEI7893546.1 WGR domain-containing protein [Myxococcales bacterium] | diamond | 1107 | 101 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28187920 | 28187920 | PRJNA700095_P_NODE_22066_length_371_cov_3.291946_g20802_i0 | PRJNA700095 | 22066 | 371 | 3.291946 | 12.21311966 | Polyangium sp. 15x6 | 3042687 | Bacteria | Bacteria | 78.6 | 3.01e-14 | NR | WP_282422496.1 | 3042687 | g20802 | i0 | 36.2 | 2.02156334231806 | 127 | 65 | 97 | 5 | 10 | 369 | 201 | 318 | WP_282422496.1 DUF4419 domain-containing protein [Polyangium sp. 15x6] | diamond | 750 | 78.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. 15x6 | |||
| 28377514 | 28377514 | PRJNA700095_P_NODE_4266_length_954_cov_5.591373_g3363_i0 | PRJNA700095 | 4266 | 954 | 5.591373 | 53.34169842 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 240 | 1.41e-69 | NR | MCA9658185.1 | 2026763 | g3363 | i0 | 42.8 | 1.37421383647799 | 276 | 144 | 85.5 | 3 | 131 | 946 | 14 | 279 | MCA9658185.1 cupin-like domain-containing protein [Myxococcales bacterium] | diamond | 1311 | 240 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28693535 | 28693535 | PRJNA700095_P_NODE_13207_length_520_cov_1.986577_g11953_i0 | PRJNA700095 | 13207 | 520 | 1.986577 | 10.3302004 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 198 | 6.960000000000001e-59 | NR | RYZ12755.1 | 2484252 | g11953 | i0 | 57.6 | 0.992307692307692 | 172 | 73 | 99.2 | 0 | 4 | 519 | 114 | 285 | RYZ12755.1 MAG: hypothetical protein EOO70_08980, partial [Myxococcaceae bacterium] | diamond | 516 | 198 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 28693556 | 28693556 | PRJNA700095_P_NODE_29287_length_314_cov_1.726141_g28023_i0 | PRJNA700095 | 29287 | 314 | 1.726141 | 5.42008274 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 148 | 6.45e-39 | NR | RYZ17952.1 | 2484252 | g28023 | i0 | 69.7 | 1.04140127388535 | 109 | 26 | 99.4 | 2 | 2 | 313 | 1712 | 1818 | RYZ17952.1 MAG: DUF3385 domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 327 | 148 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 29009470 | 29009470 | PRJNA700095_P_NODE_2268_length_1264_cov_3.078925_g1647_i0 | PRJNA700095 | 2268 | 1264 | 3.078925 | 38.917612 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 140 | 2.16e-34 | NR | RYF04405.1 | 2026735 | g1647 | i0 | 46.5 | 0.377373417721519 | 159 | 70 | 34.2 | 2 | 309 | 740 | 130 | 288 | RYF04405.1 MAG: hypothetical protein EOO40_11245, partial [Deltaproteobacteria bacterium] | diamond | 477 | 140 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29356470 | 29356470 | PRJNA700095_P_NODE_21909_length_373_cov_2.223333_g20645_i0 | PRJNA700095 | 21909 | 373 | 2.223333 | 8.29303209 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 52.8 | 3.96e-5 | NR | RYF04405.1 | 2026735 | g20645 | i0 | 39.5 | 0.611260053619303 | 76 | 37 | 53.9 | 1 | 82 | 282 | 212 | 287 | RYF04405.1 MAG: hypothetical protein EOO40_11245, partial [Deltaproteobacteria bacterium] | diamond | 228 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30177434 | 30177434 | PRJNA700095_P_NODE_11232_length_575_cov_1.318725_g9990_i0 | PRJNA700095 | 11232 | 575 | 1.318725 | 7.58266875 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 150 | 1.17e-38 | NR | MEE8166805.1 | 2818507 | g9990 | i0 | 42.5 | 1.04347826086957 | 200 | 99 | 98.6 | 4 | 575 | 9 | 133 | 327 | MEE8166805.1 long-chain-acyl-CoA synthetase [Myxococcota bacterium] | diamond | 600 | 150 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30177440 | 30177440 | PRJNA700095_P_NODE_2112_length_1300_cov_12.862266_g1522_i0 | PRJNA700095 | 2112 | 1300 | 12.862266 | 167.209458 | Enhygromyxa salina | 215803 | Bacteria | Bacteria | 202 | 1.1299999999999998e-56 | NR | WP_181234181.1 | 215803 | g1522 | i0 | 38.5 | 1.9361538461538499 | 400 | 210 | 87.2 | 18 | 1235 | 102 | 2 | 387 | WP_181234181.1 phosphatidylinositol-specific phospholipase C [Enhygromyxa salina] | diamond | 2517 | 202 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Enhygromyxa | Enhygromyxa salina | |||
| 30682884 | 30682884 | PRJNA700095_P_NODE_24573_length_347_cov_3.010949_g23309_i0 | PRJNA700095 | 24573 | 347 | 3.010949 | 10.44799303 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 74.3 | 9.91e-14 | NR | MEL6347698.1 | 2818507 | g23309 | i0 | 41 | 0.717579250720461 | 83 | 49 | 71.8 | 0 | 26 | 274 | 9 | 91 | MEL6347698.1 hypothetical protein [Myxococcota bacterium] | diamond | 249 | 74.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30682900 | 30682900 | PRJNA700095_P_NODE_5453_length_845_cov_5.009067_g4433_i0 | PRJNA700095 | 5453 | 845 | 5.009067 | 42.32661615 | Hyalangium minutum | 394096 | Bacteria | Bacteria | 282 | 1.1299999999999999e-90 | NR | WP_044191788.1 | 394096 | g4433 | i0 | 63 | 4.61538461538461 | 219 | 80 | 77.8 | 1 | 669 | 13 | 2 | 219 | WP_044191788.1 zinc-dependent alcohol dehydrogenase [Hyalangium minutum] | diamond | 3900 | 282 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Hyalangium | Hyalangium minutum | ||
| 31441553 | 31441553 | PRJNA700095_P_NODE_58536_length_246_cov_0.867052_g57272_i0 | PRJNA700095 | 58536 | 246 | 0.867052 | 2.13294792 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 73.6 | 3.89e-14 | NR | MBV8451555.1 | 2026735 | g57272 | i0 | 75 | 0.98780487804878 | 40 | 10 | 48.8 | 0 | 244 | 125 | 112 | 151 | MBV8451555.1 GNAT family N-acetyltransferase [Deltaproteobacteria bacterium] | diamond | 243 | 73.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31579443 | 31579443 | PRJNA700095_P_NODE_65996_length_241_cov_0.904762_g64732_i0 | PRJNA700095 | 65996 | 241 | 0.904762 | 2.18047642 | Myxococcota | 2818505 | Bacteria | Bacteria | 115 | 6.900000000000001e-28 | NR | MBW2529197.1 | 2026735 | g64732 | i0 | 69.2 | 1.91701244813278 | 78 | 24 | 97.1 | 0 | 234 | 1 | 105 | 182 | MBW2529197.1 NAD-dependent dihydropyrimidine dehydrogenase subunit PreA [Deltaproteobacteria bacterium] | diamond | 462 | 116 | 0.991379310344828 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31757868 | 31757868 | PRJNA700095_P_NODE_52857_length_250_cov_0.864407_g51593_i0 | PRJNA700095 | 52857 | 250 | 0.864407 | 2.1610175 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 114 | 2.02e-27 | NR | RYZ17952.1 | 2484252 | g51593 | i0 | 68.3 | 0.984 | 82 | 26 | 98.4 | 0 | 4 | 249 | 719 | 800 | RYZ17952.1 MAG: DUF3385 domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 246 | 114 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 31884358 | 31884358 | PRJNA700095_P_NODE_40077_length_276_cov_0.866995_g38813_i0 | PRJNA700095 | 40077 | 276 | 0.866995 | 2.3929062 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 66.2 | 1.46e-10 | NR | MCP3678314.1 | 2026735 | g38813 | i0 | 45.9 | 1.33695652173913 | 74 | 40 | 80.4 | 0 | 228 | 7 | 1 | 74 | MCP3678314.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 369 | 66.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31979274 | 31979274 | PRJNA700095_P_NODE_39778_length_276_cov_2.315271_g38514_i0 | PRJNA700095 | 39778 | 276 | 2.315271 | 6.39014796 | Haliangium sp. | 2663208 | Bacteria | Bacteria | 67.4 | 3.06e-11 | NR | HWN70294.1 | 2663208 | g38514 | i0 | 44.4 | 0.684782608695652 | 63 | 35 | 68.5 | 0 | 191 | 3 | 66 | 128 | HWN70294.1 hypothetical protein [Haliangium sp.] | diamond | 189 | 67.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium sp. | |||
| 32528656 | 32528656 | PRJNA700095_P_NODE_36679_length_284_cov_2.672986_g35415_i0 | PRJNA700095 | 36679 | 284 | 2.672986 | 7.59128024 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 108 | 3.28e-25 | NR | HIO61209.1 | 2026735 | g35415 | i0 | 55.1 | 4.08802816901408 | 98 | 40 | 99.3 | 1 | 284 | 3 | 492 | 589 | HIO61209.1 5-oxoprolinase [Deltaproteobacteria bacterium] | diamond | 1161 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32749004 | 32749004 | PRJNA700095_P_NODE_7160_length_745_cov_1.857143_g6035_i0 | PRJNA700095 | 7160 | 745 | 1.857143 | 13.83571535 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 109 | 1.63e-24 | NR | WP_376762355.1 | 83451 | g6035 | i0 | 40.9 | 1.89261744966443 | 154 | 78 | 62 | 4 | 3 | 464 | 155 | 295 | WP_376762355.1 aldo/keto reductase [Archangium violaceum] | diamond | 1410 | 109 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 32800697 | 32800697 | PRJNA700095_P_NODE_21460_length_378_cov_2.747541_g20196_i0 | PRJNA700095 | 21460 | 378 | 2.747541 | 10.38570498 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 91.7 | 2.3400000000000003e-21 | NR | MBK06606.1 | 2026735 | g20196 | i0 | 58.8 | 0.634920634920635 | 80 | 29 | 63.5 | 1 | 136 | 375 | 4 | 79 | MBK06606.1 acyl-CoA-binding protein [Deltaproteobacteria bacterium] | diamond | 240 | 91.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32895169 | 32895169 | PRJNA700095_P_NODE_20160_length_393_cov_3.328125_g18897_i0 | PRJNA700095 | 20160 | 393 | 3.328125 | 13.07953125 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 96.3 | 2.19e-22 | NR | RYZ15473.1 | 2484252 | g18897 | i0 | 51.6 | 0.694656488549618 | 91 | 44 | 69.5 | 0 | 287 | 15 | 16 | 106 | RYZ15473.1 MAG: ankyrin repeat domain-containing protein [Myxococcaceae bacterium] | diamond | 273 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae 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);;