contig_metadata
28 rows where bioproject = "PRJNA846486", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10159952 | 10159952 | PRJNA846486_P_NODE_55268_length_191_cov_1.021127_g55172_i0 | PRJNA846486 | 55268 | 191 | 1.021127 | 1.95035257 | Corallococcus | 83461 | Bacteria | Bacteria | 154 | 4.38e-33 | NTclustered | gi|337255776|gb|CP002830.1| | 35 | g55172 | i0 | 81.675 | 1.99476439790576 | 191 | 30 | 98 | 5 | 1 | 187 | 4455011 | 4455200 | Myxococcus macrosporus strain HW-1, complete genome | blastn | 381 | 154 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus macrosporus | ||
| 10159982 | 10159982 | PRJNA846486_P_NODE_86508_length_165_cov_0.896552_g86412_i0 | PRJNA846486 | 86508 | 165 | 0.896552 | 1.4793108 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 90.5 | 1.78e-19 | NR | HVJ14543.1 | 2268199 | g86412 | i0 | 75.9 | 2.89090909090909 | 54 | 13 | 98.2 | 0 | 1 | 162 | 241 | 294 | HVJ14543.1 DUF4055 domain-containing protein [Polyangiaceae bacterium] | diamond | 477 | 90.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 13586986 | 13586986 | PRJNA846486_P_NODE_79651_length_168_cov_0.873950_g79555_i0 | PRJNA846486 | 79651 | 168 | 0.87395 | 1.468236 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 95.1 | 4.920000000000001e-21 | NR | MBL0197464.1 | 2026763 | g79555 | i0 | 82.1 | 1 | 56 | 10 | 100 | 0 | 168 | 1 | 41 | 96 | MBL0197464.1 ATP-dependent DNA helicase [Myxococcales bacterium] | diamond | 168 | 95.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 26706319 | 26706319 | PRJNA846486_P_NODE_93501_length_162_cov_0.920354_g93405_i0 | PRJNA846486 | 93501 | 162 | 0.920354 | 1.49097348 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 50.1 | 4.22e-6 | NR | NUP12898.1 | 2268199 | g93405 | i0 | 50 | 0.814814814814815 | 44 | 22 | 81.5 | 0 | 2 | 133 | 13 | 56 | NUP12898.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 132 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 26801506 | 26801506 | PRJNA846486_P_NODE_75221_length_170_cov_0.859504_g75125_i0 | PRJNA846486 | 75221 | 170 | 0.859504 | 1.4611568 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 60.1 | 1.05e-8 | NR | MCB9507964.1 | 2026763 | g75125 | i0 | 57.1 | 0.988235294117647 | 56 | 24 | 98.8 | 0 | 2 | 169 | 105 | 160 | MCB9507964.1 hypothetical protein [Myxococcales bacterium] | diamond | 168 | 60.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 26936538 | 26936538 | PRJNA846486_P_NODE_79182_length_168_cov_0.873950_g79086_i0 | PRJNA846486 | 79182 | 168 | 0.87395 | 1.468236 | Myxococcia | 32015 | Bacteria | Bacteria | 99 | 1.18e-22 | NR | MBL8600617.1 | 2026763 | g79086 | i0 | 80 | 3.92857142857143 | 55 | 11 | 98.2 | 0 | 2 | 166 | 61 | 115 | MBL8600617.1 hypothetical protein [Myxococcales bacterium] | diamond | 660 | 99 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28042363 | 28042363 | PRJNA846486_P_NODE_42745_length_210_cov_1.291925_g42649_i0 | PRJNA846486 | 42745 | 210 | 1.291925 | 2.7130425 | Myxococcia | 32015 | Bacteria | Bacteria | 136 | 1.48e-36 | NR | MBK6463537.1 | 2026763 | g42649 | i0 | 94.3 | 3 | 70 | 4 | 100 | 0 | 1 | 210 | 27 | 96 | MBK6463537.1 hypothetical protein [Myxococcales bacterium] | diamond | 630 | 136 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28065491 | 28065491 | PRJNA846486_P_NODE_84865_length_165_cov_1.793103_g84769_i0 | PRJNA846486 | 84865 | 165 | 1.793103 | 2.95861995 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 77.4 | 3.51e-15 | NR | MDO9016551.1 | 2026763 | g84769 | i0 | 65.5 | 1 | 55 | 18 | 98.2 | 1 | 3 | 164 | 75 | 129 | MDO9016551.1 DNA circularization N-terminal domain-containing protein [Myxococcales bacterium] | diamond | 165 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28223169 | 28223169 | PRJNA846486_P_NODE_14806_length_326_cov_1.555957_g14710_i0 | PRJNA846486 | 14806 | 326 | 1.555957 | 5.07241982 | Archangium sp. | 1872627 | Bacteria | Bacteria | 129 | 2.76e-32 | NR | HYO71604.1 | 1872627 | g14710 | i0 | 69.4 | 1.80368098159509 | 98 | 30 | 90.2 | 0 | 294 | 1 | 435 | 532 | HYO71604.1 AAA family ATPase [Archangium sp.] | diamond | 588 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28539330 | 28539330 | PRJNA846486_P_NODE_82087_length_167_cov_0.881356_g81991_i0 | PRJNA846486 | 82087 | 167 | 0.881356 | 1.47186452 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 95.9 | 2.44e-21 | NR | MBL8952514.1 | 2484252 | g81991 | i0 | 78.2 | 0.988023952095808 | 55 | 12 | 98.8 | 0 | 2 | 166 | 303 | 357 | MBL8952514.1 FHA domain-containing protein [Myxococcaceae bacterium] | diamond | 165 | 95.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 29013028 | 29013028 | PRJNA846486_P_NODE_76568_length_169_cov_0.866667_g76472_i0 | PRJNA846486 | 76568 | 169 | 0.866667 | 1.46466723 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 48.1 | 4.32e-5 | NR | MBA2540568.1 | 2026735 | g76472 | i0 | 47.2 | 0.940828402366864 | 53 | 27 | 92.3 | 1 | 11 | 166 | 29 | 81 | MBA2540568.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 159 | 48.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29076020 | 29076020 | PRJNA846486_P_NODE_91408_length_163_cov_0.912281_g91312_i0 | PRJNA846486 | 91408 | 163 | 0.912281 | 1.48701803 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.9 | 0.00473 | NR | MEZ4225955.1 | 2268199 | g91312 | i0 | 51.1 | 0.865030674846626 | 47 | 23 | 86.5 | 0 | 148 | 8 | 119 | 165 | MEZ4225955.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 141 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29770337 | 29770337 | PRJNA846486_P_NODE_78491_length_168_cov_1.117647_g78395_i0 | PRJNA846486 | 78491 | 168 | 1.117647 | 1.87764696 | Sandaracinaceae bacterium | 2510337 | Bacteria | Bacteria | 40.8 | 0.0335 | NR | MFK7987570.1 | 2510337 | g78395 | i0 | 45.5 | 0.589285714285714 | 33 | 15 | 58.9 | 1 | 167 | 69 | 65 | 94 | MFK7987570.1 hypothetical protein [Sandaracinaceae bacterium] | diamond | 99 | 40.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinaceae bacterium | ||||
| 30054598 | 30054598 | PRJNA846486_P_NODE_81071_length_167_cov_0.881356_g80975_i0 | PRJNA846486 | 81071 | 167 | 0.881356 | 1.47186452 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 68.6 | 1.04e-11 | NR | MBV8357467.1 | 2026735 | g80975 | i0 | 81.6 | 1.36526946107784 | 38 | 7 | 68.3 | 0 | 48 | 161 | 597 | 634 | MBV8357467.1 DNA polymerase I [Deltaproteobacteria bacterium] | diamond | 228 | 68.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30117829 | 30117829 | PRJNA846486_P_NODE_79312_length_168_cov_0.873950_g79216_i0 | PRJNA846486 | 79312 | 168 | 0.87395 | 1.468236 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 77 | 1.09e-14 | NR | MBL0197447.1 | 2026763 | g79216 | i0 | 97.1 | 0.625 | 35 | 1 | 62.5 | 0 | 1 | 105 | 438 | 472 | MBL0197447.1 hypothetical protein [Myxococcales bacterium] | diamond | 105 | 77 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30560057 | 30560057 | PRJNA846486_P_NODE_91373_length_163_cov_0.912281_g91277_i0 | PRJNA846486 | 91373 | 163 | 0.912281 | 1.48701803 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 63.9 | 3.39e-10 | NR | MFO0599253.1 | 2484252 | g91277 | i0 | 62.7 | 1.84049079754601 | 51 | 19 | 93.9 | 0 | 157 | 5 | 44 | 94 | MFO0599253.1 hypothetical protein [Myxococcaceae bacterium] | diamond | 300 | 63.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 30686524 | 30686524 | PRJNA846486_P_NODE_65373_length_179_cov_1.200000_g65277_i0 | PRJNA846486 | 65373 | 179 | 1.2 | 2.148 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 60.8 | 2.64e-9 | NR | MCA9634375.1 | 2026763 | g65277 | i0 | 58.7 | 0.770949720670391 | 46 | 19 | 77.1 | 0 | 40 | 177 | 75 | 120 | MCA9634375.1 hypothetical protein [Myxococcales bacterium] | diamond | 138 | 60.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30781428 | 30781428 | PRJNA846486_P_NODE_61494_length_183_cov_1.470149_g61398_i0 | PRJNA846486 | 61494 | 183 | 1.470149 | 2.69037267 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 60.1 | 1.26e-9 | NR | MBM3301962.1 | 2026735 | g61398 | i0 | 54.2 | 1.72131147540984 | 48 | 22 | 78.7 | 0 | 39 | 182 | 52 | 99 | MBM3301962.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 315 | 60.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30971161 | 30971161 | PRJNA846486_P_NODE_84174_length_166_cov_0.888889_g84078_i0 | PRJNA846486 | 84174 | 166 | 0.888889 | 1.47555574 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 53.1 | 2.65e-6 | NR | HVK87950.1 | 2212474 | g84078 | i0 | 57.1 | 0.759036144578313 | 42 | 18 | 75.9 | 0 | 38 | 163 | 204 | 245 | HVK87950.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 126 | 53.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31286949 | 31286949 | PRJNA846486_P_NODE_79255_length_168_cov_0.873950_g79159_i0 | PRJNA846486 | 79255 | 168 | 0.87395 | 1.468236 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 50.4 | 2.49e-5 | NR | MFN0246831.1 | 2212474 | g79159 | i0 | 55.8 | 0.767857142857143 | 43 | 19 | 76.8 | 0 | 166 | 38 | 277 | 319 | MFN0246831.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 129 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31286955 | 31286955 | PRJNA846486_P_NODE_93815_length_162_cov_0.920354_g93719_i0 | PRJNA846486 | 93815 | 162 | 0.920354 | 1.49097348 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 72.4 | 4.2e-13 | NR | MBL9008291.1 | 2026763 | g93719 | i0 | 71.2 | 0.962962962962963 | 52 | 15 | 96.3 | 0 | 157 | 2 | 156 | 207 | MBL9008291.1 hypothetical protein [Myxococcales bacterium] | diamond | 156 | 72.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31350469 | 31350469 | PRJNA846486_P_NODE_91036_length_163_cov_0.912281_g90940_i0 | PRJNA846486 | 91036 | 163 | 0.912281 | 1.48701803 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 42.7 | 0.0129 | NR | HWB73452.1 | 2545255 | g90940 | i0 | 65.4 | 0.975460122699387 | 26 | 9 | 47.9 | 0 | 79 | 2 | 4 | 29 | HWB73452.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Nannocystaceae bacterium] | diamond | 159 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 31571929 | 31571929 | PRJNA846486_P_NODE_86456_length_165_cov_0.896552_g86360_i0 | PRJNA846486 | 86456 | 165 | 0.896552 | 1.4793108 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 44.7 | 0.00229 | NR | TAK27233.1 | 2484252 | g86360 | i0 | 46.3 | 0.981818181818182 | 54 | 23 | 98.2 | 1 | 163 | 2 | 132 | 179 | TAK27233.1 MAG: hypothetical protein EPO40_16550 [Myxococcaceae bacterium] | diamond | 162 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 31643243 | 31643243 | PRJNA846486_P_NODE_68116_length_176_cov_1.496063_g68020_i0 | PRJNA846486 | 68116 | 176 | 1.496063 | 2.63307088 | Bacteria | 2 | Bacteria | Bacteria | 42.7 | 0.0126 | NR | MEB2343393.1 | 2026735 | g68020 | i0 | 62.5 | 4.02272727272727 | 32 | 11 | 52.8 | 1 | 94 | 2 | 1 | 32 | MEB2343393.1 riboflavin synthase [Deltaproteobacteria bacterium] | diamond | 708 | 43.1 | 0.990719257540603 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31864605 | 31864605 | PRJNA846486_P_NODE_48717_length_200_cov_1.158940_g48621_i0 | PRJNA846486 | 48717 | 200 | 1.15894 | 2.31788 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 57.4 | 3.24e-8 | NR | MBI3247806.1 | 2026735 | g48621 | i0 | 50 | 1.74 | 54 | 27 | 81 | 0 | 2 | 163 | 83 | 136 | MBI3247806.1 aromatic-ring-hydroxylating dioxygenase subunit beta [Deltaproteobacteria bacterium] | diamond | 348 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32077869 | 32077869 | PRJNA846486_P_NODE_86738_length_165_cov_0.896552_g86642_i0 | PRJNA846486 | 86738 | 165 | 0.896552 | 1.4793108 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 53.1 | 2.8e-6 | NR | MCA9491922.1 | 2026763 | g86642 | i0 | 50 | 1.05454545454545 | 58 | 26 | 100 | 1 | 1 | 165 | 319 | 376 | MCA9491922.1 transposase zinc-binding domain-containing protein [Myxococcales bacterium] | diamond | 174 | 53.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32181376 | 32181376 | PRJNA846486_P_NODE_81878_length_167_cov_0.881356_g81782_i0 | PRJNA846486 | 81878 | 167 | 0.881356 | 1.47186452 | FCB group | 1783270 | Bacteria | Bacteria | 88.2 | 1.28e-18 | NR | MBM4361774.1 | 2026735 | g81782 | i0 | 78.2 | 34.4910179640719 | 55 | 12 | 98.8 | 0 | 1 | 165 | 641 | 695 | MBM4361774.1 V-type H(+)-translocating pyrophosphatase [Deltaproteobacteria bacterium] | diamond | 5760 | 88.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32898766 | 32898766 | PRJNA846486_P_NODE_33740_length_230_cov_1.723757_g33644_i0 | PRJNA846486 | 33740 | 230 | 1.723757 | 3.9646411 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 70.9 | 3.76e-12 | NR | MDO9020555.1 | 2026763 | g33644 | i0 | 53.4 | 0.952173913043478 | 73 | 34 | 95.2 | 0 | 226 | 8 | 329 | 401 | MDO9020555.1 DUF935 family protein [Myxococcales bacterium] | diamond | 219 | 70.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales 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);;