contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax_phylum = "Actinomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23953531 | 23953531 | PRJNA1005695_P_NODE_38599_length_245_cov_0.906977_g37747_i0 | PRJNA1005695 | 38599 | 245 | 0.906977 | 2.22209365 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 139 | 3.0600000000000004e-36 | NR | MEZ5235907.1 | 2201156 | g37747 | i0 | 95.6 | 0.83265306122449 | 68 | 3 | 83.3 | 0 | 1 | 204 | 864 | 931 | MEZ5235907.1 vitamin B12-dependent ribonucleotide reductase [Acidimicrobiales bacterium] | diamond | 204 | 139 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 26844838 | 26844838 | PRJNA1005695_P_NODE_28521_length_280_cov_1.502415_g27669_i0 | PRJNA1005695 | 28521 | 280 | 1.502415 | 4.206762 | Streptomyces sp. NBC_ | 1931 | Bacteria | Bacteria | 42.7 | 0.0379 | NR | WP_266711828.1 | 2975652 | g27669 | i0 | 42.4 | 0.632142857142857 | 59 | 33 | 63.2 | 1 | 72 | 248 | 125 | 182 | WP_266711828.1 GNAT family N-acetyltransferase [Streptomyces sp. NBC_00102] | diamond | 177 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NBC_00102 | ||
| 26907919 | 26907919 | PRJNA1005695_P_NODE_41762_length_228_cov_2.006452_g40910_i0 | PRJNA1005695 | 41762 | 228 | 2.006452 | 4.57471056 | Saccharomonospora xinjiangensis | 75294 | Bacteria | Bacteria | 43.1 | 0.0109 | NR | WP_006238214.1 | 75294 | g40910 | i0 | 47.9 | 0.631578947368421 | 48 | 18 | 53.9 | 1 | 125 | 3 | 17 | 64 | WP_006238214.1 DoxX family protein [Saccharomonospora xinjiangensis] | diamond | 144 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharomonospora | Saccharomonospora xinjiangensis | ||
| 27666496 | 27666496 | PRJNA1005695_P_NODE_14684_length_398_cov_0.750769_g13832_i0 | PRJNA1005695 | 14684 | 398 | 0.750769 | 2.98806062 | Catellatospora aurea | 1337874 | Bacteria | Bacteria | 45.4 | 0.00838 | NR | WP_376810015.1 | 1337874 | g13832 | i0 | 42.4 | 0.444723618090452 | 59 | 27 | 43.7 | 3 | 222 | 395 | 62 | 114 | WP_376810015.1 hypothetical protein [Catellatospora aurea] | diamond | 177 | 45.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Catellatospora | Catellatospora aurea | ||
| 28045181 | 28045181 | PRJNA1005695_P_NODE_39465_length_243_cov_0.917647_g38613_i0 | PRJNA1005695 | 39465 | 243 | 0.917647 | 2.22988221 | Kocuria sp. CPCC 2 | 1871328 | Bacteria | Bacteria | 50.4 | 6.88e-5 | NR | WP_387741833.1 | 3058914 | g38613 | i0 | 45.5 | 0.814814814814815 | 66 | 36 | 81.5 | 0 | 2 | 199 | 39 | 104 | WP_387741833.1 M28 family peptidase [Kocuria sp. CPCC 205315] | diamond | 198 | 50.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Kocuria | Kocuria nitroreducens | ||
| 28076680 | 28076680 | PRJNA1005695_P_NODE_20425_length_334_cov_0.957854_g19573_i0 | PRJNA1005695 | 20425 | 334 | 0.957854 | 3.19923236 | Kitasatospora sp. NPDC | 1871188 | Bacteria | Bacteria | 47 | 0.00327 | NR | WP_396310128.1 | 3364054 | g19573 | i0 | 35.1 | 0.87125748502994 | 97 | 54 | 84.4 | 3 | 320 | 39 | 19 | 109 | WP_396310128.1 MFS transporter [Kitasatospora sp. NPDC050543] | diamond | 291 | 47 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora sp. NPDC050543 | ||
| 28140189 | 28140189 | PRJNA1005695_P_NODE_36705_length_249_cov_0.886364_g35853_i0 | PRJNA1005695 | 36705 | 249 | 0.886364 | 2.20704636 | Blastococcus sp. CT_GayMR2 | 1873459 | Bacteria | Bacteria | 131 | 1.23e-33 | NR | WP_135158521.1 | 2559609 | g35853 | i0 | 81.5 | 0.975903614457831 | 81 | 15 | 97.6 | 0 | 247 | 5 | 66 | 146 | WP_135158521.1 bifunctional 3'-5' exonuclease/DNA polymerase [Blastococcus sp. CT_GayMR20] | diamond | 243 | 131 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Geodermatophilales | Geodermatophilaceae | Blastococcus | Blastococcus sp. CT_GayMR20 | ||
| 28550621 | 28550621 | PRJNA1005695_P_NODE_34087_length_255_cov_0.989011_g33235_i0 | PRJNA1005695 | 34087 | 255 | 0.989011 | 2.52197805 | Actinomycetales bacterium | 1911520 | Bacteria | Bacteria | 45.8 | 0.00347 | NR | MBU6147104.1 | 1911520 | g33235 | i0 | 42.6 | 0.717647058823529 | 61 | 26 | 61.2 | 2 | 99 | 254 | 121 | 181 | MBU6147104.1 hypothetical protein [Actinomycetales bacterium] | diamond | 183 | 45.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetales bacterium | ||||
| 29371395 | 29371395 | PRJNA1005695_P_NODE_30049_length_272_cov_2.145729_g29197_i0 | PRJNA1005695 | 30049 | 272 | 2.145729 | 5.83638288 | Jiangellaceae bacterium | 2768363 | Bacteria | Bacteria | 42.7 | 0.0472 | NR | HEY9409042.1 | 2768363 | g29197 | i0 | 46.4 | 0.617647058823529 | 56 | 26 | 57.4 | 2 | 1 | 156 | 130 | 185 | HEY9409042.1 shikimate dehydrogenase [Jiangellaceae bacterium] | diamond | 168 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Jiangellales | Jiangellaceae | Jiangellaceae bacterium | |||
| 29458291 | 29458291 | PRJNA1005695_P_NODE_38990_length_244_cov_0.912281_g38138_i0 | PRJNA1005695 | 38990 | 244 | 0.912281 | 2.22596564 | FCB group | 1783270 | Bacteria | Bacteria | 53.5 | 5.81e-6 | NR | WP_037503838.1 | 363832 | g38138 | i0 | 41.3 | 2.54508196721311 | 75 | 36 | 89.8 | 3 | 22 | 240 | 51 | 119 | WP_037503838.1 hypothetical protein [Solirubrobacter soli] | diamond | 621 | 53.9 | 0.992578849721707 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacter | Solirubrobacter soli | ||
| 29781732 | 29781732 | PRJNA1005695_P_NODE_14731_length_397_cov_1.975309_g13879_i0 | PRJNA1005695 | 14731 | 397 | 1.975309 | 7.84197673 | Streptomyces alfalfae | 1642299 | Bacteria | Bacteria | 53.5 | 7.29e-6 | NR | WP_198501348.1 | 1642299 | g13879 | i0 | 34.7 | 1.68513853904282 | 118 | 55 | 88.4 | 5 | 11 | 361 | 43 | 139 | WP_198501348.1 CBM20 domain-containing protein [Streptomyces alfalfae] | diamond | 669 | 53.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces alfalfae | ||
| 30003037 | 30003037 | PRJNA1005695_P_NODE_33471_length_257_cov_2.423913_g32619_i0 | PRJNA1005695 | 33471 | 257 | 2.423913 | 6.22945641 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 43.1 | 0.033 | NR | HZU74151.1 | 2201156 | g32619 | i0 | 31.7 | 0.957198443579767 | 82 | 48 | 86.4 | 2 | 7 | 228 | 51 | 132 | HZU74151.1 MFS transporter [Acidimicrobiales bacterium] | diamond | 246 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 30476981 | 30476981 | PRJNA1005695_P_NODE_33933_length_255_cov_2.417582_g33081_i0 | PRJNA1005695 | 33933 | 255 | 2.417582 | 6.1648341 | Demequina sp. | 2050685 | Bacteria | Bacteria | 43.5 | 0.0231 | NR | WP_296666963.1 | 2050685 | g33081 | i0 | 38.6 | 0.670588235294118 | 57 | 34 | 67.1 | 1 | 246 | 76 | 320 | 375 | WP_296666963.1 leucyl aminopeptidase [Demequina sp.] | diamond | 171 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Demequinaceae | Demequina | Demequina sp. | ||
| 30508451 | 30508451 | PRJNA1005695_P_NODE_31533_length_266_cov_1.233161_g30681_i0 | PRJNA1005695 | 31533 | 266 | 1.233161 | 3.28020826 | Actinomyces urogenitalis DORA_12 | 1403939 | Bacteria | Bacteria | 44.3 | 0.00243 | NR | ETJ01449.1 | 1403939 | g30681 | i0 | 54.3 | 0.394736842105263 | 35 | 16 | 39.5 | 0 | 242 | 138 | 1 | 35 | ETJ01449.1 MAG: Cell wall-associated hydrolase [Actinomyces urogenitalis DORA_12] | diamond | 105 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Actinomyces | Actinomyces urogenitalis | ||
| 31298344 | 31298344 | PRJNA1005695_P_NODE_28055_length_282_cov_1.937799_g27203_i0 | PRJNA1005695 | 28055 | 282 | 1.937799 | 5.46459318 | Saccharomonospora xinjiangensis | 75294 | Bacteria | Bacteria | 43.5 | 0.0146 | NR | WP_006238214.1 | 75294 | g27203 | i0 | 44.9 | 0.521276595744681 | 49 | 20 | 44.7 | 1 | 4 | 129 | 27 | 75 | WP_006238214.1 DoxX family protein [Saccharomonospora xinjiangensis] | diamond | 147 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharomonospora | Saccharomonospora xinjiangensis | ||
| 31361825 | 31361825 | PRJNA1005695_P_NODE_35016_length_252_cov_1.363128_g34164_i0 | PRJNA1005695 | 35016 | 252 | 1.363128 | 3.43508256 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 43.9 | 0.0129 | NR | WP_385772057.1 | 3347002 | g34164 | i0 | 32 | 2.0952380952381 | 97 | 50 | 98.8 | 3 | 252 | 4 | 24 | 118 | WP_385772057.1 hypothetical protein [Streptomyces sp. NPDC059917] | diamond | 528 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC059917 | ||
| 31488420 | 31488420 | PRJNA1005695_P_NODE_31056_length_268_cov_1.389744_g30204_i0 | PRJNA1005695 | 31056 | 268 | 1.389744 | 3.72451392 | Ornithinimicrobium sp. | 1977084 | Bacteria | Bacteria | 43.1 | 0.0325 | NR | WP_303375145.1 | 1977084 | g30204 | i0 | 36.5 | 0.951492537313433 | 85 | 48 | 91.8 | 3 | 18 | 263 | 40 | 121 | WP_303375145.1 1,2-phenylacetyl-CoA epoxidase subunit PaaC [Ornithinimicrobium sp.] | diamond | 255 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Ornithinimicrobiaceae | Ornithinimicrobium | Ornithinimicrobium sp. | ||
| 31544077 | 31544077 | PRJNA1005695_P_NODE_31076_length_268_cov_1.194872_g30224_i0 | PRJNA1005695 | 31076 | 268 | 1.194872 | 3.20225696 | Bacteria | 2 | Bacteria | Bacteria | 46.2 | 0.00275 | NR | WP_199044285.1 | 980294 | g30224 | i0 | 41.7 | 2.87686567164179 | 84 | 39 | 85.1 | 4 | 37 | 264 | 167 | 248 | WP_199044285.1 S1 family peptidase [Glycomyces salinus] | diamond | 771 | 46.6 | 0.991416309012876 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Glycomycetales | Glycomycetaceae | Glycomyces | Glycomyces salinus | ||
| 31646164 | 31646164 | PRJNA1005695_P_NODE_36157_length_250_cov_0.881356_g35305_i0 | PRJNA1005695 | 36157 | 250 | 0.881356 | 2.20339 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 82 | 1.98e-16 | NR | MEM9610047.1 | 2900548 | g35305 | i0 | 48.8 | 4.812 | 80 | 41 | 96 | 0 | 3 | 242 | 217 | 296 | MEM9610047.1 TIGR01777 family oxidoreductase [Actinomycetota bacterium] | diamond | 1203 | 82 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 31955080 | 31955080 | PRJNA1005695_P_NODE_19817_length_339_cov_1.691729_g18965_i0 | PRJNA1005695 | 19817 | 339 | 1.691729 | 5.73496131 | Actinomycetota | 201174 | Bacteria | Bacteria | 76.6 | 1.36e-13 | NR | WP_125610720.1 | 1629051 | g18965 | i0 | 43.1 | 4.91150442477876 | 116 | 58 | 96.5 | 3 | 5 | 331 | 346 | 460 | WP_125610720.1 sugar porter family MFS transporter [Specibacter cremeus] | diamond | 1665 | 76.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Specibacter | Specibacter cremeus | ||
| 32025989 | 32025989 | PRJNA1005695_P_NODE_39058_length_244_cov_0.912281_g38206_i0 | PRJNA1005695 | 39058 | 244 | 0.912281 | 2.22596564 | Pseudoclavibacter sp. | 1915061 | Bacteria | Bacteria | 143 | 1.77e-38 | NR | HHW51487.1 | 1915061 | g38206 | i0 | 98.5 | 0.836065573770492 | 68 | 1 | 83.6 | 0 | 41 | 244 | 1 | 68 | HHW51487.1 cysteine--tRNA ligase [Pseudoclavibacter sp.] | diamond | 204 | 143 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Pseudoclavibacter | Pseudoclavibacter sp. | ||
| 32374144 | 32374144 | PRJNA1005695_P_NODE_28559_length_280_cov_1.188406_g27707_i0 | PRJNA1005695 | 28559 | 280 | 1.188406 | 3.3275368 | unclassified Blastococcus | 2619396 | Bacteria | Bacteria | 43.9 | 0.0219 | NR | WP_200489685.1 | 2619396 | g27707 | i0 | 36.5 | 0.675 | 63 | 37 | 64.3 | 1 | 89 | 268 | 41 | 103 | WP_200489685.1 MULTISPECIES: MBL fold metallo-hydrolase [unclassified Blastococcus] | diamond | 189 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Geodermatophilales | Geodermatophilaceae | Blastococcus | |||
| 32595451 | 32595451 | PRJNA1005695_P_NODE_27580_length_285_cov_1.103774_g26728_i0 | PRJNA1005695 | 27580 | 285 | 1.103774 | 3.1457559 | Propionicimonas sp. | 1955623 | Bacteria | Bacteria | 43.1 | 0.043 | NR | HEY3545929.1 | 1955623 | g26728 | i0 | 44.3 | 0.642105263157895 | 61 | 27 | 62.1 | 2 | 37 | 213 | 29 | 84 | HEY3545929.1 DMT family transporter [Propionicimonas sp.] | diamond | 183 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Propionicimonas | Propionicimonas 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);;