contig_metadata
21 rows where bioproject = "PRJNA797655", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26642314 | 26642314 | PRJNA797655_S_NODE_213001_length_173_cov_1.346154_g212396_i0 | PRJNA797655 | 213001 | 173 | 1.346154 | 2.32884642 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.9 | 0.00577 | NR | MEQ8280587.1 | 2026735 | g212396 | i0 | 41.1 | 1.94219653179191 | 56 | 28 | 88.4 | 1 | 6 | 158 | 867 | 922 | MEQ8280587.1 PilZ domain-containing protein [Deltaproteobacteria bacterium] | diamond | 336 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26736965 | 26736965 | PRJNA797655_S_NODE_80601_length_267_cov_2.165179_g79996_i0 | PRJNA797655 | 80601 | 267 | 2.165179 | 5.78102793 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.1 | 0.0356 | NR | MCK4738882.1 | 2026735 | g79996 | i0 | 37.9 | 0.651685393258427 | 58 | 30 | 65.2 | 2 | 187 | 14 | 417 | 468 | MCK4738882.1 GAF domain-containing protein [Deltaproteobacteria bacterium] | diamond | 174 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26895945 | 26895945 | PRJNA797655_S_NODE_90381_length_256_cov_1.577465_g89776_i0 | PRJNA797655 | 90381 | 256 | 1.577465 | 4.0383104 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.1 | 0.0316 | NR | MCU0654026.1 | 2268199 | g89776 | i0 | 38 | 0.5859375 | 50 | 31 | 58.6 | 0 | 91 | 240 | 75 | 124 | MCU0654026.1 DUF4178 domain-containing protein [Polyangiaceae bacterium] | diamond | 150 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27116901 | 27116901 | PRJNA797655_S_NODE_133882_length_217_cov_1.931034_g133277_i0 | PRJNA797655 | 133882 | 217 | 1.931034 | 4.19034378 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 45.8 | 0.00156 | NR | MER2559374.1 | 2484252 | g133277 | i0 | 53.1 | 0.912442396313364 | 32 | 15 | 44.2 | 0 | 8 | 103 | 160 | 191 | MER2559374.1 2OG-Fe(II) oxygenase [Myxococcaceae bacterium] | diamond | 198 | 45.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 28254011 | 28254011 | PRJNA797655_S_NODE_231406_length_165_cov_1.967213_g230801_i0 | PRJNA797655 | 231406 | 165 | 1.967213 | 3.24590145 | Anaeromyxobacteraceae bacterium | 2510643 | Bacteria | Bacteria | 43.9 | 0.0012 | NR | HTP29346.1 | 2510643 | g230801 | i0 | 29.6 | 0.981818181818182 | 54 | 34 | 98.2 | 1 | 1 | 162 | 26 | 75 | HTP29346.1 hypothetical protein [Anaeromyxobacteraceae bacterium] | diamond | 162 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 28822095 | 28822095 | PRJNA797655_S_NODE_214208_length_172_cov_2.232558_g213603_i0 | PRJNA797655 | 214208 | 172 | 2.232558 | 3.83999976 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.9 | 0.00543 | NR | HTQ44796.1 | 2268199 | g213603 | i0 | 40.9 | 0.767441860465116 | 44 | 25 | 76.7 | 1 | 164 | 33 | 285 | 327 | HTQ44796.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 132 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29012169 | 29012169 | PRJNA797655_S_NODE_165688_length_196_cov_2.699346_g165083_i0 | PRJNA797655 | 165688 | 196 | 2.699346 | 5.29071816 | Sorangium aterium | 2995308 | Bacteria | Bacteria | 42.4 | 0.0269 | NR | WP_272101363.1 | 2995308 | g165083 | i0 | 39.3 | 0.933673469387755 | 61 | 33 | 87.2 | 1 | 26 | 196 | 173 | 233 | WP_272101363.1 tetratricopeptide repeat protein [Sorangium aterium] | diamond | 183 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium atrum | |||
| 29359237 | 29359237 | PRJNA797655_S_NODE_140269_length_212_cov_3.650888_g139664_i0 | PRJNA797655 | 140269 | 212 | 3.650888 | 7.73988256 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 42.4 | 0.0338 | NR | HEY4187214.1 | 3058050 | g139664 | i0 | 53.6 | 0.39622641509434 | 28 | 13 | 39.6 | 0 | 199 | 116 | 8 | 35 | HEY4187214.1 MFS transporter [Polyangia bacterium] | diamond | 84 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 29485193 | 29485193 | PRJNA797655_S_NODE_207850_length_175_cov_1.818182_g207245_i0 | PRJNA797655 | 207850 | 175 | 1.818182 | 3.1818185 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 42.7 | 0.0147 | NR | MBL8951875.1 | 2484252 | g207245 | i0 | 40 | 0.942857142857143 | 55 | 29 | 87.4 | 1 | 3 | 155 | 533 | 587 | MBL8951875.1 hypothetical protein [Myxococcaceae bacterium] | diamond | 165 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 29896085 | 29896085 | PRJNA797655_S_NODE_70891_length_280_cov_1.746835_g70286_i0 | PRJNA797655 | 70891 | 280 | 1.746835 | 4.891138 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.5 | 0.0287 | NR | MBI5491225.1 | 2026735 | g70286 | i0 | 31.1 | 0.792857142857143 | 74 | 51 | 79.3 | 0 | 9 | 230 | 169 | 242 | MBI5491225.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 222 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30243602 | 30243602 | PRJNA797655_S_NODE_78072_length_270_cov_2.502203_g77467_i0 | PRJNA797655 | 78072 | 270 | 2.502203 | 6.7559481 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.9 | 0.0208 | NR | MCK6512886.1 | 2818507 | g77467 | i0 | 35.2 | 0.788888888888889 | 71 | 33 | 67.8 | 3 | 82 | 264 | 472 | 539 | MCK6512886.1 hypothetical protein [Myxococcota bacterium] | diamond | 213 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30496378 | 30496378 | PRJNA797655_S_NODE_226593_length_167_cov_1.919355_g225988_i0 | PRJNA797655 | 226593 | 167 | 1.919355 | 3.20532285 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 41.6 | 0.0209 | NR | MFO0632440.1 | 2545255 | g225988 | i0 | 38.9 | 0.970059880239521 | 54 | 27 | 91.6 | 2 | 6 | 158 | 27 | 77 | MFO0632440.1 hypothetical protein [Nannocystaceae bacterium] | diamond | 162 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 30590950 | 30590950 | PRJNA797655_S_NODE_102473_length_243_cov_3.670000_g101868_i0 | PRJNA797655 | 102473 | 243 | 3.67 | 8.9181 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.5 | 0.0197 | NR | MFO0687825.1 | 2818507 | g101868 | i0 | 32.4 | 0.91358024691358 | 74 | 45 | 85.2 | 1 | 22 | 228 | 4 | 77 | MFO0687825.1 hypothetical protein [Myxococcota bacterium] | diamond | 222 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31033689 | 31033689 | PRJNA797655_S_NODE_52775_length_309_cov_2.706767_g52170_i0 | PRJNA797655 | 52775 | 309 | 2.706767 | 8.36391003 | Corallococcus sp. Z5C1 | 1898750 | Bacteria | Bacteria | 46.2 | 0.0037 | NR | TSC25858.1 | 2596829 | g52170 | i0 | 37.5 | 0.776699029126214 | 80 | 44 | 72.8 | 2 | 77 | 301 | 3 | 81 | TSC25858.1 YHYH domain-containing protein [Corallococcus sp. Z5C101001] | diamond | 240 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus sp. Z5C101001 | ||
| 31317817 | 31317817 | PRJNA797655_S_NODE_192755_length_182_cov_1.726619_g192150_i0 | PRJNA797655 | 192755 | 182 | 1.726619 | 3.14244658 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 42.7 | 0.0163 | NR | HMA93134.1 | 2268199 | g192150 | i0 | 38.3 | 0.774725274725275 | 47 | 27 | 74.2 | 1 | 40 | 174 | 251 | 297 | HMA93134.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 141 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31412769 | 31412769 | PRJNA797655_S_NODE_250596_length_158_cov_1.252174_g249991_i0 | PRJNA797655 | 250596 | 158 | 1.252174 | 1.97843492 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 42 | 0.0221 | NR | MDJ0766371.1 | 2818507 | g249991 | i0 | 35.1 | 1.08227848101266 | 57 | 25 | 85.4 | 1 | 6 | 140 | 234 | 290 | MDJ0766371.1 hypothetical protein [Myxococcota bacterium] | diamond | 171 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31665674 | 31665674 | PRJNA797655_S_NODE_144097_length_210_cov_1.437126_g143492_i0 | PRJNA797655 | 144097 | 210 | 1.437126 | 3.0179646 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 40.4 | 0.0409 | NR | MCA9617768.1 | 2026763 | g143492 | i0 | 30.3 | 0.942857142857143 | 66 | 40 | 85.7 | 1 | 199 | 20 | 26 | 91 | MCA9617768.1 hypothetical protein [Myxococcales bacterium] | diamond | 198 | 40.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32488538 | 32488538 | PRJNA797655_S_NODE_169179_length_194_cov_2.860927_g168574_i0 | PRJNA797655 | 169179 | 194 | 2.860927 | 5.55019838 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42.4 | 0.0265 | NR | MBM3301478.1 | 2026735 | g168574 | i0 | 43.8 | 0.742268041237113 | 48 | 27 | 74.2 | 0 | 187 | 44 | 135 | 182 | MBM3301478.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 144 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32614730 | 32614730 | PRJNA797655_S_NODE_66640_length_286_cov_1.917695_g66035_i0 | PRJNA797655 | 66640 | 286 | 1.917695 | 5.4846077 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 45.4 | 0.00678 | NR | HET8932956.1 | 3034171 | g66035 | i0 | 52.9 | 0.356643356643357 | 34 | 16 | 35.7 | 0 | 83 | 184 | 263 | 296 | HET8932956.1 hypothetical protein [Polyangiales bacterium] | diamond | 102 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 32772018 | 32772018 | PRJNA797655_S_NODE_44560_length_326_cov_3.261484_g43955_i0 | PRJNA797655 | 44560 | 326 | 3.261484 | 10.63243784 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.9 | 0.036 | NR | MFP6564162.1 | 2818507 | g43955 | i0 | 30.5 | 0.874233128834356 | 95 | 46 | 75.5 | 3 | 260 | 15 | 92 | 179 | MFP6564162.1 hypothetical protein [Myxococcota bacterium] | diamond | 285 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32835043 | 32835043 | PRJNA797655_S_NODE_273400_length_151_cov_2.000000_g272795_i0 | PRJNA797655 | 273400 | 151 | 2 | 3.02 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 40.8 | 0.0498 | NR | MBM4294940.1 | 2026735 | g272795 | i0 | 43.2 | 1.62913907284768 | 44 | 25 | 87.4 | 0 | 9 | 140 | 241 | 284 | MBM4294940.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 246 | 40.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria 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);;