contig_metadata
28 rows where bioproject = "PRJEB43370", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26780380 | 26780380 | PRJEB43370_P_NODE_10901_length_162_cov_0.920354_g10858_i0 | PRJEB43370 | 10901 | 162 | 0.920354 | 1.49097348 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 65.1 | 1.59e-10 | NR | MBI5501983.1 | 2026735 | g10858 | i0 | 62.8 | 2.44444444444444 | 43 | 16 | 79.6 | 0 | 140 | 12 | 85 | 127 | MBI5501983.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 396 | 65.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27159605 | 27159605 | PRJEB43370_P_NODE_8922_length_166_cov_0.888889_g8879_i0 | PRJEB43370 | 8922 | 166 | 0.888889 | 1.47555574 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 83.2 | 6.67e-17 | NR | HLV65013.1 | 2268199 | g8879 | i0 | 63.6 | 1.98795180722892 | 55 | 20 | 99.4 | 0 | 1 | 165 | 138 | 192 | HLV65013.1 aldehyde dehydrogenase family protein [Polyangiaceae bacterium] | diamond | 330 | 83.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27318097 | 27318097 | PRJEB43370_P_NODE_5683_length_191_cov_1.408451_g5640_i0 | PRJEB43370 | 5683 | 191 | 1.408451 | 2.69014141 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 40.8 | 0.0319 | NR | MBN2725149.1 | 2026735 | g5640 | i0 | 48.6 | 0.549738219895288 | 35 | 15 | 55 | 1 | 1 | 105 | 3 | 34 | MBN2725149.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 105 | 40.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27381313 | 27381313 | PRJEB43370_P_NODE_3723_length_228_cov_2.301676_g3680_i0 | PRJEB43370 | 3723 | 228 | 2.301676 | 5.24782128 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 44.3 | 0.00866 | NR | MCC6993871.1 | 2026735 | g3680 | i0 | 41.1 | 2.57894736842105 | 56 | 31 | 71.1 | 2 | 63 | 224 | 377 | 432 | MCC6993871.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 588 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27406293 | 27406293 | PRJEB43370_P_NODE_3963_length_223_cov_0.896552_g3920_i0 | PRJEB43370 | 3963 | 223 | 0.896552 | 1.99931096 | Bacteria | 2 | Bacteria | Bacteria | 55.5 | 9.12e-7 | NR | HWN71616.1 | 2663208 | g3920 | i0 | 42.5 | 2.65022421524664 | 73 | 37 | 96.9 | 3 | 6 | 221 | 209 | 277 | HWN71616.1 lysyl oxidase family protein [Haliangium sp.] | diamond | 591 | 55.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium sp. | |||
| 27627249 | 27627249 | PRJEB43370_P_NODE_3464_length_235_cov_2.231183_g3421_i0 | PRJEB43370 | 3464 | 235 | 2.231183 | 5.24328005 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 54.3 | 2.91e-6 | NR | OQX70311.1 | 1970199 | g3421 | i0 | 61 | 6.20425531914894 | 41 | 15 | 51.1 | 1 | 213 | 94 | 1396 | 1436 | OQX70311.1 MAG: hypothetical protein B6A08_00330 [Sorangiineae bacterium NIC37A_2] | diamond | 1458 | 54.7 | 0.992687385740402 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Sorangiineae bacterium NIC37A_2 | ||||
| 27886287 | 27886287 | PRJEB43370_P_NODE_1845_length_321_cov_2.415441_g1802_i0 | PRJEB43370 | 1845 | 321 | 2.415441 | 7.75356561 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 55.8 | 2.08e-6 | NR | MBK9070054.1 | 2026763 | g1802 | i0 | 47.1 | 0.476635514018692 | 51 | 20 | 42.1 | 2 | 138 | 4 | 217 | 266 | MBK9070054.1 PPC domain-containing protein [Myxococcales bacterium] | diamond | 153 | 55.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27942923 | 27942923 | PRJEB43370_P_NODE_2165_length_295_cov_1.268293_g2122_i0 | PRJEB43370 | 2165 | 295 | 1.268293 | 3.74146435 | Myxococcia | 32015 | Bacteria | Bacteria | 49.3 | 3.63e-4 | NR | MCB9548328.1 | 2026763 | g2122 | i0 | 40.6 | 1.68813559322034 | 69 | 39 | 68.1 | 1 | 225 | 25 | 1584 | 1652 | MCB9548328.1 hypothetical protein [Myxococcales bacterium] | diamond | 498 | 49.7 | 0.991951710261569 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28549604 | 28549604 | PRJEB43370_P_NODE_9207_length_165_cov_1.387931_g9164_i0 | PRJEB43370 | 9207 | 165 | 1.387931 | 2.29008615 | Vulgatibacter incomptus | 1391653 | Bacteria | Bacteria | 47.8 | 2.15e-4 | NR | AKU92739.1 | 1391653 | g9164 | i0 | 53.8 | 3.09090909090909 | 39 | 15 | 70.9 | 1 | 42 | 158 | 26 | 61 | AKU92739.1 hypothetical protein AKJ08_3126 [Vulgatibacter incomptus] | diamond | 510 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Vulgatibacteraceae | Vulgatibacter | Vulgatibacter incomptus | ||
| 28770354 | 28770354 | PRJEB43370_P_NODE_6087_length_186_cov_1.087591_g6044_i0 | PRJEB43370 | 6087 | 186 | 1.087591 | 2.02291926 | Bradymonadia bacterium | 3121696 | Bacteria | Bacteria | 47.8 | 3.13e-4 | NR | MFN3199957.1 | 3121696 | g6044 | i0 | 51.2 | 0.661290322580645 | 41 | 15 | 66.1 | 1 | 10 | 132 | 4396 | 4431 | MFN3199957.1 thrombospondin type 3 repeat-containing protein [Bradymonadia bacterium] | diamond | 123 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Bradymonadia | Bradymonadia bacterium | |||||
| 28833536 | 28833536 | PRJEB43370_P_NODE_7768_length_169_cov_0.866667_g7725_i0 | PRJEB43370 | 7768 | 169 | 0.866667 | 1.46466723 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 75.5 | 3.94e-14 | NR | MCB9638593.1 | 2026763 | g7725 | i0 | 67.9 | 0.994082840236686 | 56 | 18 | 99.4 | 0 | 2 | 169 | 366 | 421 | MCB9638593.1 acetoacetate--CoA ligase [Myxococcales bacterium] | diamond | 168 | 75.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28928277 | 28928277 | PRJEB43370_P_NODE_9868_length_164_cov_0.904348_g9825_i0 | PRJEB43370 | 9868 | 164 | 0.904348 | 1.48313072 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 54.3 | 1.06e-6 | NR | MDO9017237.1 | 2026763 | g9825 | i0 | 56.3 | 1.84756097560976 | 48 | 21 | 87.8 | 0 | 161 | 18 | 771 | 818 | MDO9017237.1 hypothetical protein [Myxococcales bacterium] | diamond | 303 | 54.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29275453 | 29275453 | PRJEB43370_P_NODE_8309_length_167_cov_0.966102_g8266_i0 | PRJEB43370 | 8309 | 167 | 0.966102 | 1.61339034 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 44.3 | 0.00308 | NR | MBL9099531.1 | 2026763 | g8266 | i0 | 40.7 | 0.970059880239521 | 54 | 32 | 97 | 0 | 165 | 4 | 47 | 100 | MBL9099531.1 hypothetical protein [Myxococcales bacterium] | diamond | 162 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29654097 | 29654097 | PRJEB43370_P_NODE_10550_length_162_cov_1.840708_g10507_i0 | PRJEB43370 | 10550 | 162 | 1.840708 | 2.98194696 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 59.3 | 1.65e-8 | NR | MEZ4389728.1 | 3034171 | g10507 | i0 | 57.7 | 0.962962962962963 | 52 | 21 | 96.3 | 1 | 158 | 3 | 132 | 182 | MEZ4389728.1 hypothetical protein [Polyangiales bacterium] | diamond | 156 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 30064951 | 30064951 | PRJEB43370_P_NODE_8212_length_168_cov_0.873950_g8169_i0 | PRJEB43370 | 8212 | 168 | 0.87395 | 1.468236 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 66.2 | 6.77e-11 | NR | MEB2284342.1 | 2026763 | g8169 | i0 | 59.3 | 4.69642857142857 | 54 | 20 | 92.9 | 1 | 3 | 158 | 390 | 443 | MEB2284342.1 DUF4215 domain-containing protein [Myxococcales bacterium] | diamond | 789 | 66.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30311678 | 30311678 | PRJEB43370_P_NODE_7052_length_173_cov_1.177419_g7009_i0 | PRJEB43370 | 7052 | 173 | 1.177419 | 2.03693487 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 46.6 | 6.22e-4 | NR | MCH2107811.1 | 2268199 | g7009 | i0 | 43.2 | 1.42196531791908 | 44 | 25 | 76.3 | 0 | 166 | 35 | 48 | 91 | MCH2107811.1 leishmanolysin [Polyangiaceae bacterium] | diamond | 246 | 47 | 0.991489361702128 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30318379 | 30318379 | PRJEB43370_P_NODE_6572_length_179_cov_1.238462_g6529_i0 | PRJEB43370 | 6572 | 179 | 1.238462 | 2.21684698 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 88.6 | 6.71e-19 | NR | HEY5934200.1 | 2212474 | g6529 | i0 | 66.1 | 0.988826815642458 | 59 | 20 | 98.9 | 0 | 179 | 3 | 203 | 261 | HEY5934200.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 177 | 88.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31392465 | 31392465 | PRJEB43370_P_NODE_7936_length_168_cov_0.873950_g7893_i0 | PRJEB43370 | 7936 | 168 | 0.87395 | 1.468236 | Vulgatibacter sp. | 1971226 | Bacteria | Bacteria | 61.2 | 3.96e-9 | NR | WP_373046014.1 | 1971226 | g7893 | i0 | 51.9 | 1.91071428571429 | 52 | 21 | 85.7 | 2 | 157 | 14 | 511 | 562 | WP_373046014.1 DUF4215 domain-containing protein [Vulgatibacter sp.] | diamond | 321 | 61.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Vulgatibacteraceae | Vulgatibacter | Vulgatibacter sp. | ||
| 31512333 | 31512333 | PRJEB43370_P_NODE_5536_length_193_cov_1.381944_g5493_i0 | PRJEB43370 | 5536 | 193 | 1.381944 | 2.66715192 | Chondromyces | 50 | Bacteria | Bacteria | 48.5 | 1.79e-4 | NR | WP_044250348.1 | 51 | g5493 | i0 | 35 | 2.48704663212435 | 60 | 30 | 93.3 | 1 | 184 | 5 | 718 | 768 | WP_044250348.1 hypothetical protein [Chondromyces apiculatus] | diamond | 480 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces apiculatus | |||
| 31550660 | 31550660 | PRJEB43370_P_NODE_6716_length_177_cov_1.609375_g6673_i0 | PRJEB43370 | 6716 | 177 | 1.609375 | 2.84859375 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 83.2 | 1.05e-18 | NR | MDA8405706.1 | 2026735 | g6673 | i0 | 69.1 | 0.932203389830508 | 55 | 14 | 88.1 | 1 | 161 | 6 | 15 | 69 | MDA8405706.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Deltaproteobacteria bacterium] | diamond | 165 | 83.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31645171 | 31645171 | PRJEB43370_P_NODE_9317_length_165_cov_0.896552_g9274_i0 | PRJEB43370 | 9317 | 165 | 0.896552 | 1.4793108 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 61.2 | 3.13e-9 | NR | MBW1688487.1 | 2026735 | g9274 | i0 | 46.3 | 0.981818181818182 | 54 | 29 | 98.2 | 0 | 163 | 2 | 77 | 130 | MBW1688487.1 SDR family oxidoreductase [Deltaproteobacteria bacterium] | diamond | 162 | 61.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31708563 | 31708563 | PRJEB43370_P_NODE_9357_length_165_cov_0.896552_g9314_i0 | PRJEB43370 | 9357 | 165 | 0.896552 | 1.4793108 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.9 | 0.00532 | NR | MBP7160088.1 | 2818507 | g9314 | i0 | 45.1 | 3.70909090909091 | 51 | 24 | 92.7 | 2 | 1 | 153 | 501 | 547 | MBP7160088.1 hypothetical protein [Myxococcota bacterium] | diamond | 612 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32088191 | 32088191 | PRJEB43370_P_NODE_4738_length_207_cov_0.987342_g4695_i0 | PRJEB43370 | 4738 | 207 | 0.987342 | 2.04379794 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.9 | 0.00952 | NR | MBM4344213.1 | 2026735 | g4695 | i0 | 53.6 | 1 | 69 | 22 | 100 | 2 | 1 | 207 | 53 | 111 | MBM4344213.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 207 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32271527 | 32271527 | PRJEB43370_P_NODE_5958_length_187_cov_1.507246_g5915_i0 | PRJEB43370 | 5958 | 187 | 1.507246 | 2.81855002 | Myxococcia | 32015 | Bacteria | Bacteria | 78.6 | 3.36e-17 | NR | MCO4762647.1 | 2026763 | g5915 | i0 | 61.4 | 19.4117647058824 | 57 | 22 | 91.4 | 0 | 1 | 171 | 26 | 82 | MCO4762647.1 RNA-binding protein [Myxococcales bacterium] | diamond | 3630 | 78.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32594459 | 32594459 | PRJEB43370_P_NODE_8800_length_166_cov_0.888889_g8757_i0 | PRJEB43370 | 8800 | 166 | 0.888889 | 1.47555574 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 49.3 | 6.55e-5 | NR | MEZ4266202.1 | 2818507 | g8757 | i0 | 50 | 0.795180722891566 | 44 | 20 | 79.5 | 1 | 23 | 154 | 1905 | 1946 | MEZ4266202.1 EGF domain-containing protein [Myxococcota bacterium] | diamond | 132 | 49.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32656958 | 32656958 | PRJEB43370_P_NODE_1720_length_335_cov_1.416084_g1677_i0 | PRJEB43370 | 1720 | 335 | 1.416084 | 4.7438814 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 70.5 | 2.05e-11 | NR | HET9621954.1 | 2212474 | g1677 | i0 | 59.6 | 0.886567164179105 | 52 | 21 | 46.6 | 0 | 3 | 158 | 879 | 930 | HET9621954.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 297 | 70.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32688648 | 32688648 | PRJEB43370_P_NODE_3920_length_224_cov_0.891429_g3877_i0 | PRJEB43370 | 3920 | 224 | 0.891429 | 1.99680096 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 96.7 | 1.11e-21 | NR | MFA6034219.1 | 2818507 | g3877 | i0 | 68.7 | 0.897321428571429 | 67 | 20 | 89.7 | 1 | 1 | 201 | 162 | 227 | MFA6034219.1 hypothetical protein [Myxococcota bacterium] | diamond | 201 | 96.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32751752 | 32751752 | PRJEB43370_P_NODE_5120_length_200_cov_1.099338_g5077_i0 | PRJEB43370 | 5120 | 200 | 1.099338 | 2.198676 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 57 | 1.94e-7 | NR | MBN95682.1 | 2026735 | g5077 | i0 | 48.2 | 1.395 | 56 | 26 | 82.5 | 2 | 36 | 200 | 16 | 69 | MBN95682.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 279 | 57 | 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);;