contig_metadata
27 rows where bioproject = "PRJNA278119", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3609363 | 3609363 | PRJNA278119_P_NODE_33483_length_171_cov_2.311475_g33234_i0 | PRJNA278119 | 33483 | 171 | 2.311475 | 3.95262225 | Sandaracinaceae bacterium LLY-WYZ-13_1 | 3034333 | Bacteria | Bacteria | 96.3 | 3.5399999999999995e-23 | NR | HJL14404.1 | 3034333 | g33234 | i0 | 76.8 | 8.8421052631579 | 56 | 13 | 98.2 | 0 | 169 | 2 | 66 | 121 | HJL14404.1 superoxide dismutase [Sandaracinaceae bacterium LLY-WYZ-13_1] | diamond | 1512 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinaceae bacterium LLY-WYZ-13_1 | ||||
| 6161588 | 6161588 | PRJNA278119_P_NODE_2445_length_782_cov_3.725784_g2228_i0 | PRJNA278119 | 2445 | 782 | 3.725784 | 29.13563088 | Haliangium | 162027 | Bacteria | Bacteria | 529 | 2.9699999999999992e-145 | NTclustered | gi|470485361|ref|NR_076697.1| | 80816 | g2228 | i0 | 79.193 | 117.218670076726 | 793 | 141 | 100 | 22 | 1 | 782 | 10 | 789 | Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence | blastn | 91665 | 529 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium ochraceum | |||
| 6748860 | 6748860 | PRJNA278119_P_NODE_23006_length_206_cov_1.324841_g22757_i0 | PRJNA278119 | 23006 | 206 | 1.324841 | 2.72917246 | Minicystis rosea | 888845 | Bacteria | Bacteria | 195 | 2.83e-45 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g22757 | i0 | 86.022 | 36.5533980582524 | 186 | 21 | 89 | 5 | 13 | 195 | 7473510 | 7473693 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 7530 | 195 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 11849694 | 11849694 | PRJNA278119_P_NODE_16230_length_263_cov_1.457944_g15981_i0 | PRJNA278119 | 16230 | 263 | 1.457944 | 3.83439272 | Nannocystis sp. | 1962667 | Bacteria | Bacteria | 283 | 7.819999999999999e-72 | NTclustered | gi|1386873111|gb|MF774778.1| | 1962667 | g15981 | i0 | 89.64 | 143.072243346008 | 222 | 23 | 84 | 0 | 42 | 263 | 440 | 661 | Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence | blastn | 37628 | 283 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis sp. | |||
| 16948682 | 16948682 | PRJNA278119_P_NODE_29874_length_181_cov_1.431818_g29625_i0 | PRJNA278119 | 29874 | 181 | 1.431818 | 2.59159058 | root | 1 | Root_unresolved | Root_unresolved | 91.3 | 1.3e-19 | NR | HRI65696.1 | 57 | g29625 | i0 | 71.2 | 70.5082872928177 | 59 | 17 | 97.8 | 0 | 177 | 1 | 453 | 511 | HRI65696.1 ABC transporter transmembrane domain-containing protein [Polyangium sp.] | diamond | 12762 | 92 | 0.992391304347826 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 18222790 | 18222790 | PRJNA278119_P_NODE_17115_length_252_cov_1.275862_g16866_i0 | PRJNA278119 | 17115 | 252 | 1.275862 | 3.21517224 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 122 | 2.44e-33 | NR | MCK6502336.1 | 2818507 | g16866 | i0 | 72.8 | 0.964285714285714 | 81 | 20 | 96.4 | 1 | 248 | 6 | 77 | 155 | MCK6502336.1 peptidylprolyl isomerase [Myxococcota bacterium] | diamond | 243 | 122 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 22047722 | 22047722 | PRJNA278119_P_NODE_25438_length_196_cov_1.061224_g25189_i0 | PRJNA278119 | 25438 | 196 | 1.061224 | 2.07999904 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 87.9 | 4.65e-13 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g25189 | i0 | 83.333 | 0.969387755102041 | 96 | 14 | 48 | 2 | 71 | 165 | 12710780 | 12710874 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 190 | 87.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 24597371 | 24597371 | PRJNA278119_P_NODE_27680_length_188_cov_1.122302_g27431_i0 | PRJNA278119 | 27680 | 188 | 1.122302 | 2.10992776 | Corallococcus sp. EGB | 1521117 | Bacteria | Bacteria | 148 | 2e-31 | NTclustered | gi|2094564806|gb|CP079946.1| | 1521117 | g27431 | i0 | 93.069 | 4.02659574468085 | 101 | 7 | 54 | 0 | 88 | 188 | 3510007 | 3509907 | Corallococcus sp. EGB chromosome, complete genome | blastn | 757 | 148 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus sp. EGB | ||
| 24597430 | 24597430 | PRJNA278119_P_NODE_31460_length_177_cov_1.210938_g31211_i0 | PRJNA278119 | 31460 | 177 | 1.210938 | 2.14336026 | Vulgatibacter incomptus | 1391653 | Bacteria | Bacteria | 117 | 5.23e-22 | NTclustered | gi|913607065|gb|CP012332.1| | 1391653 | g31211 | i0 | 81.507 | 34.6214689265537 | 146 | 23 | 81 | 4 | 1 | 144 | 2731936 | 2731793 | Vulgatibacter incomptus strain DSM 27710, complete genome | blastn | 6128 | 117 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Vulgatibacteraceae | Vulgatibacter | Vulgatibacter incomptus | ||
| 26598938 | 26598938 | PRJNA278119_P_NODE_26161_length_193_cov_1.402778_g25912_i0 | PRJNA278119 | 26161 | 193 | 1.402778 | 2.70736154 | Archangium lipolyticum | 2970465 | Bacteria | Bacteria | 57.4 | 1.26e-7 | NR | WP_257450705.1 | 2970465 | g25912 | i0 | 42.6 | 1.89637305699482 | 61 | 35 | 94.8 | 0 | 188 | 6 | 528 | 588 | WP_257450705.1 discoidin domain-containing protein [Archangium lipolyticum] | diamond | 366 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium lipolyticum | ||
| 27263864 | 27263864 | PRJNA278119_P_NODE_42363_length_165_cov_0.896552_g42114_i0 | PRJNA278119 | 42363 | 165 | 0.896552 | 1.4793108 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 52 | 6.9e-6 | NR | MSP60021.1 | 2026763 | g42114 | i0 | 55.6 | 0.818181818181818 | 45 | 19 | 81.8 | 1 | 3 | 137 | 171 | 214 | MSP60021.1 porin [Myxococcales bacterium] | diamond | 135 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27313249 | 27313249 | PRJNA278119_P_NODE_19923_length_224_cov_1.537143_g19674_i0 | PRJNA278119 | 19923 | 224 | 1.537143 | 3.44320032 | Myxococcia | 32015 | Bacteria | Bacteria | 62 | 3.03e-10 | NR | MBL8744555.1 | 2026763 | g19674 | i0 | 43.8 | 3.96428571428571 | 73 | 39 | 97.8 | 2 | 5 | 223 | 30 | 100 | MBL8744555.1 hypothetical protein [Myxococcales bacterium] | diamond | 888 | 62 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27484914 | 27484914 | PRJNA278119_P_NODE_39923_length_166_cov_0.888889_g39674_i0 | PRJNA278119 | 39923 | 166 | 0.888889 | 1.47555574 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 88.2 | 6.59e-21 | NR | MCB9543525.1 | 2026763 | g39674 | i0 | 80 | 0.993975903614458 | 55 | 11 | 99.4 | 0 | 165 | 1 | 48 | 102 | MCB9543525.1 transcription initiation protein [Myxococcales bacterium] | diamond | 165 | 88.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28021800 | 28021800 | PRJNA278119_P_NODE_28045_length_187_cov_1.130435_g27796_i0 | PRJNA278119 | 28045 | 187 | 1.130435 | 2.11391345 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 63.5 | 8.27e-10 | NR | RYZ17952.1 | 2484252 | g27796 | i0 | 48.3 | 0.962566844919786 | 60 | 31 | 96.3 | 0 | 5 | 184 | 314 | 373 | RYZ17952.1 MAG: DUF3385 domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 180 | 63.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 28355001 | 28355001 | PRJNA278119_P_NODE_3626_length_635_cov_1.540956_g3389_i0 | PRJNA278119 | 3626 | 635 | 1.540956 | 9.7850706 | Myxococcales | 29 | Bacteria | Bacteria | 165 | 3.54e-44 | NR | WP_239470296.1 | 83451 | g3389 | i0 | 62.9 | 13.2661417322835 | 140 | 49 | 66.1 | 1 | 422 | 3 | 373 | 509 | WP_239470296.1 LysM peptidoglycan-binding domain-containing protein [Archangium violaceum] | diamond | 8424 | 165 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 28386584 | 28386584 | PRJNA278119_P_NODE_36206_length_168_cov_1.310924_g35957_i0 | PRJNA278119 | 36206 | 168 | 1.310924 | 2.20235232 | Myxococcales | 29 | Bacteria | Bacteria | 70.1 | 3.1e-13 | NR | ATB34764.1 | 43 | g35957 | i0 | 68.8 | 2.60714285714286 | 48 | 15 | 85.7 | 0 | 6 | 149 | 76 | 123 | ATB34764.1 peptidase S8 [Cystobacter fuscus] | diamond | 438 | 70.5 | 0.994326241134752 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 28653174 | 28653174 | PRJNA278119_P_NODE_40647_length_166_cov_0.888889_g40398_i0 | PRJNA278119 | 40647 | 166 | 0.888889 | 1.47555574 | Archangium sp. | 1872627 | Bacteria | Bacteria | 65.1 | 1.74e-10 | NR | HYO70214.1 | 1872627 | g40398 | i0 | 65.2 | 2.49397590361446 | 46 | 16 | 83.1 | 0 | 139 | 2 | 142 | 187 | HYO70214.1 kelch repeat-containing protein [Archangium sp.] | diamond | 414 | 65.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28747855 | 28747855 | PRJNA278119_P_NODE_4667_length_556_cov_2.222880_g4424_i0 | PRJNA278119 | 4667 | 556 | 2.22288 | 12.3592128 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 140 | 1.11e-38 | NR | MEZ4236421.1 | 2818507 | g4424 | i0 | 62.2 | 1.18705035971223 | 111 | 41 | 59.9 | 1 | 157 | 489 | 49 | 158 | MEZ4236421.1 peroxiredoxin [Myxococcota bacterium] | diamond | 660 | 140 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29112943 | 29112943 | PRJNA278119_P_NODE_4268_length_583_cov_2.288390_g4026_i0 | PRJNA278119 | 4268 | 583 | 2.28839 | 13.3413137 | Bacteria | 2 | Bacteria | Bacteria | 81.3 | 9.95e-15 | NR | MBS2018596.1 | 2026735 | g4026 | i0 | 46.5 | 0.972555746140652 | 86 | 43 | 43.2 | 2 | 239 | 490 | 116 | 200 | MBS2018596.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 567 | 81.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30547993 | 30547993 | PRJNA278119_P_NODE_3953_length_606_cov_7.736086_g3714_i0 | PRJNA278119 | 3953 | 606 | 7.736086 | 46.88068116 | Hyalangium sp. | 2028555 | Bacteria | Bacteria | 46.6 | 0.0216 | NR | HVG59182.1 | 2028555 | g3714 | i0 | 38.5 | 0.321782178217822 | 65 | 37 | 32.2 | 1 | 74 | 268 | 71 | 132 | HVG59182.1 Isoquinoline 1-oxidoreductase subunit [Hyalangium sp.] | diamond | 195 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Hyalangium | Hyalangium sp. | ||
| 30800667 | 30800667 | PRJNA278119_P_NODE_41194_length_165_cov_1.344828_g40945_i0 | PRJNA278119 | 41194 | 165 | 1.344828 | 2.2189662 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 63.5 | 5.78e-10 | NR | MCU0655228.1 | 2268199 | g40945 | i0 | 51.1 | 1.76363636363636 | 47 | 23 | 85.5 | 0 | 155 | 15 | 47 | 93 | MCU0655228.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 291 | 63.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31102677 | 31102677 | PRJNA278119_P_NODE_20335_length_221_cov_2.459302_g20086_i0 | PRJNA278119 | 20335 | 221 | 2.459302 | 5.43505742 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 81.6 | 1.1e-16 | NR | MDP3938502.1 | 2026735 | g20086 | i0 | 50 | 6.74660633484163 | 74 | 36 | 99.1 | 1 | 1 | 219 | 34 | 107 | MDP3938502.1 glucose 1-dehydrogenase [Deltaproteobacteria bacterium] | diamond | 1491 | 81.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31843961 | 31843961 | PRJNA278119_P_NODE_11017_length_349_cov_2.843333_g10770_i0 | PRJNA278119 | 11017 | 349 | 2.843333 | 9.92323217 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 51.2 | 1.28e-4 | NR | MBW2593237.1 | 2026735 | g10770 | i0 | 51.1 | 0.404011461318052 | 47 | 23 | 40.4 | 0 | 163 | 23 | 451 | 497 | MBW2593237.1 tetratricopeptide repeat protein [Deltaproteobacteria bacterium] | diamond | 141 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31843994 | 31843994 | PRJNA278119_P_NODE_43137_length_164_cov_0.982609_g42888_i0 | PRJNA278119 | 43137 | 164 | 0.982609 | 1.61147876 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.1 | 0.00939 | NR | MEM9113965.1 | 2818507 | g42888 | i0 | 50 | 2.52439024390244 | 46 | 20 | 84.1 | 2 | 27 | 164 | 427 | 469 | MEM9113965.1 class I SAM-dependent DNA methyltransferase [Myxococcota bacterium] | diamond | 414 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32192242 | 32192242 | PRJNA278119_P_NODE_23078_length_206_cov_0.993631_g22829_i0 | PRJNA278119 | 23078 | 206 | 0.993631 | 2.04687986 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 98.2 | 5.600000000000001e-23 | NR | MDD9802787.1 | 2026735 | g22829 | i0 | 57.4 | 6.78640776699029 | 68 | 29 | 99 | 0 | 205 | 2 | 91 | 158 | MDD9802787.1 enoyl-CoA hydratase/isomerase family protein [Deltaproteobacteria bacterium] | diamond | 1398 | 98.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32382065 | 32382065 | PRJNA278119_P_NODE_39779_length_166_cov_0.888889_g39530_i0 | PRJNA278119 | 39779 | 166 | 0.888889 | 1.47555574 | Bradymonadia bacterium | 3121696 | Bacteria | Bacteria | 41.2 | 0.0456 | NR | MFN3197790.1 | 3121696 | g39530 | i0 | 38 | 0.903614457831325 | 50 | 29 | 86.7 | 1 | 3 | 146 | 10 | 59 | MFN3197790.1 GGDEF domain-containing protein [Bradymonadia bacterium] | diamond | 150 | 41.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Bradymonadia | Bradymonadia bacterium | |||||
| 32886503 | 32886503 | PRJNA278119_P_NODE_36520_length_168_cov_0.873950_g36271_i0 | PRJNA278119 | 36520 | 168 | 0.87395 | 1.468236 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 54.3 | 1.1e-6 | NR | MFO0734377.1 | 1971228 | g36271 | i0 | 86.2 | 0.517857142857143 | 29 | 4 | 51.8 | 0 | 1 | 87 | 298 | 326 | MFO0734377.1 glutathione synthase [Labilithrix sp.] | diamond | 87 | 54.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix 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);;