contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA596870" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 568308 | 568308 | PRJNA596870_P_NODE_22321_length_285_cov_1.268868_g22188_i0 | PRJNA596870 | 22321 | 285 | 1.268868 | 3.6162738 | Microbacterium laevaniformans | 36807 | Bacteria | Bacteria | 166 | 3.47e-45 | NR | WP_061683168.1 | 36807 | g22188 | i0 | 95.7 | 0.989473684210526 | 94 | 4 | 98.9 | 0 | 284 | 3 | 160 | 253 | WP_061683168.1 bifunctional [glutamine synthetase] adenylyltransferase/[glutamine synthetase]-adenylyl-L-tyrosine phosphorylase [Microbacterium laevaniformans] | diamond | 282 | 166 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium laevaniformans | ||
| 26840322 | 26840322 | PRJNA596870_P_NODE_4201_length_583_cov_1.286275_g4070_i0 | PRJNA596870 | 4201 | 583 | 1.286275 | 7.49898325 | Streptomyces | 1883 | Bacteria | Bacteria | 210 | 6.93e-62 | NR | WP_142217653.1 | 2768454 | g4070 | i0 | 56.7 | 5.94854202401372 | 194 | 81 | 99.3 | 2 | 581 | 3 | 123 | 314 | WP_142217653.1 S8 family peptidase [Streptomyces sp. SLBN-118] | diamond | 3468 | 210 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. SLBN-118 | ||
| 26858702 | 26858702 | PRJNA596870_P_NODE_40581_length_232_cov_3.037736_g40448_i0 | PRJNA596870 | 40581 | 232 | 3.037736 | 7.04754752 | Micrococcus cohnii | 993416 | Bacteria | Bacteria | 109 | 2.1e-27 | NR | WP_158496904.1 | 993416 | g40448 | i0 | 64.5 | 1.96551724137931 | 76 | 27 | 98.3 | 0 | 3 | 230 | 82 | 157 | WP_158496904.1 hypothetical protein [Micrococcus cohnii] | diamond | 456 | 109 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus cohnii | ||
| 26872031 | 26872031 | PRJNA596870_P_NODE_21061_length_291_cov_2.000000_g20928_i0 | PRJNA596870 | 21061 | 291 | 2 | 5.82 | Microbacterium | 33882 | Bacteria | Bacteria | 103 | 3.43e-26 | NR | WP_239640025.1 | 95616 | g20928 | i0 | 53.6 | 1.98969072164948 | 97 | 44 | 99 | 1 | 289 | 2 | 17 | 113 | WP_239640025.1 histone-like nucleoid-structuring protein Lsr2 [Microbacterium sp. B24] | diamond | 579 | 104 | 0.990384615384615 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. B24 | ||
| 27048260 | 27048260 | PRJNA596870_P_NODE_35322_length_245_cov_1.784884_g35189_i0 | PRJNA596870 | 35322 | 245 | 1.784884 | 4.3729658 | Streptomyces longwoodensis | 68231 | Bacteria | Bacteria | 42.4 | 0.0347 | NR | WP_067237168.1 | 68231 | g35189 | i0 | 33 | 1.07755102040816 | 88 | 43 | 88.2 | 2 | 231 | 16 | 52 | 139 | WP_067237168.1 hypothetical protein [Streptomyces longwoodensis] | diamond | 264 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces longwoodensis | ||
| 27093182 | 27093182 | PRJNA596870_P_NODE_21482_length_289_cov_1.421296_g21349_i0 | PRJNA596870 | 21482 | 289 | 1.421296 | 4.10754544 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.00485 | NR | MES9187225.1 | 1747 | g21349 | i0 | 50 | 2.39792387543253 | 34 | 17 | 35.3 | 0 | 279 | 178 | 33 | 66 | MES9187225.1 hypothetical protein [Cutibacterium acnes] | diamond | 693 | 44.3 | 0.99097065462754 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 27522089 | 27522089 | PRJNA596870_P_NODE_22903_length_282_cov_1.387560_g22770_i0 | PRJNA596870 | 22903 | 282 | 1.38756 | 3.9129192 | Microbacterium | 33882 | Bacteria | Bacteria | 193 | 5.29e-60 | NR | WP_016463377.1 | 33882 | g22770 | i0 | 100 | 1 | 94 | 0 | 100 | 0 | 282 | 1 | 108 | 201 | WP_016463377.1 MULTISPECIES: glycosyltransferase family 2 protein [Microbacterium] | diamond | 282 | 193 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | |||
| 27648632 | 27648632 | PRJNA596870_P_NODE_36084_length_245_cov_0.895349_g35951_i0 | PRJNA596870 | 36084 | 245 | 0.895349 | 2.19360505 | Microbacteriaceae bacterium | 1873462 | Bacteria | Bacteria | 42.7 | 0.037 | NR | MBX3311919.1 | 1873462 | g35951 | i0 | 38.3 | 0.575510204081633 | 47 | 29 | 57.6 | 0 | 10 | 150 | 171 | 217 | MBX3311919.1 LysM peptidoglycan-binding domain-containing protein [Microbacteriaceae bacterium] | diamond | 141 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacteriaceae bacterium | |||
| 28153880 | 28153880 | PRJNA596870_P_NODE_24285_length_275_cov_1.282178_g24152_i0 | PRJNA596870 | 24285 | 275 | 1.282178 | 3.5259895 | Microbacterium sp. | 51671 | Bacteria | Bacteria | 171 | 2.999999999999999e-47 | NR | WP_292891734.1 | 51671 | g24152 | i0 | 89 | 0.992727272727273 | 91 | 10 | 99.3 | 0 | 1 | 273 | 1005 | 1095 | WP_292891734.1 tubulin-like doman-containing protein [Microbacterium sp.] | diamond | 273 | 171 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. | ||
| 28248192 | 28248192 | PRJNA596870_P_NODE_18426_length_310_cov_0.974684_g18293_i0 | PRJNA596870 | 18426 | 310 | 0.974684 | 3.0215204 | Actinophytocola sp. | 1872138 | Bacteria | Bacteria | 80.5 | 1.15e-15 | NR | WP_324917453.1 | 1872138 | g18293 | i0 | 48.4 | 0.9 | 93 | 46 | 89 | 2 | 276 | 1 | 142 | 233 | WP_324917453.1 type VII secretion target [Actinophytocola sp.] | diamond | 279 | 80.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinophytocola | Actinophytocola sp. | ||
| 28374616 | 28374616 | PRJNA596870_P_NODE_32726_length_248_cov_0.880000_g32593_i0 | PRJNA596870 | 32726 | 248 | 0.88 | 2.1824 | Microbacteriaceae bacterium | 1873462 | Bacteria | Bacteria | 56.2 | 3.14e-7 | NR | MBX9717786.1 | 1873462 | g32593 | i0 | 47.2 | 0.870967741935484 | 72 | 35 | 87.1 | 2 | 236 | 21 | 11 | 79 | MBX9717786.1 hypothetical protein [Microbacteriaceae bacterium] | diamond | 216 | 56.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacteriaceae bacterium | |||
| 28595888 | 28595888 | PRJNA596870_P_NODE_34187_length_247_cov_0.885057_g34054_i0 | PRJNA596870 | 34187 | 247 | 0.885057 | 2.18609079 | Corynebacterium bovis | 36808 | Bacteria | Bacteria | 70.9 | 1.3e-12 | NR | WP_342009314.1 | 36808 | g34054 | i0 | 60.3 | 3.26720647773279 | 63 | 23 | 74.1 | 1 | 191 | 9 | 37 | 99 | WP_342009314.1 DUF6668 family protein [Corynebacterium bovis] | diamond | 807 | 70.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium bovis | ||
| 28784973 | 28784973 | PRJNA596870_P_NODE_36187_length_245_cov_0.895349_g36054_i0 | PRJNA596870 | 36187 | 245 | 0.895349 | 2.19360505 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 76.6 | 5.52e-16 | NR | MBS1889909.1 | 2900548 | g36054 | i0 | 63.6 | 0.673469387755102 | 55 | 20 | 67.3 | 0 | 169 | 5 | 45 | 99 | MBS1889909.1 hypothetical protein [Actinomycetota bacterium] | diamond | 165 | 76.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 28974729 | 28974729 | PRJNA596870_P_NODE_30608_length_250_cov_0.870056_g30475_i0 | PRJNA596870 | 30608 | 250 | 0.870056 | 2.17514 | Microbacterium sp. AG79 | 51671 | Bacteria | Bacteria | 146 | 2.04e-42 | NR | WP_183043603.1 | 2183995 | g30475 | i0 | 98.6 | 1.788 | 70 | 1 | 84 | 0 | 40 | 249 | 1 | 70 | WP_183043603.1 TetR/AcrR family transcriptional regulator [Microbacterium sp. AG790] | diamond | 447 | 146 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. AG790 | ||
| 29037981 | 29037981 | PRJNA596870_P_NODE_22868_length_282_cov_1.473684_g22735_i0 | PRJNA596870 | 22868 | 282 | 1.473684 | 4.15578888 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 44.3 | 0.0164 | NR | HEY3669564.1 | 2080302 | g22735 | i0 | 52.6 | 0.404255319148936 | 38 | 18 | 40.4 | 0 | 215 | 102 | 52 | 89 | HEY3669564.1 aldehyde dehydrogenase family protein [Acidimicrobiia bacterium] | diamond | 114 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 29795351 | 29795351 | PRJNA596870_P_NODE_18311_length_310_cov_2.531646_g18178_i0 | PRJNA596870 | 18311 | 310 | 2.531646 | 7.8481026 | Paenarthrobacter nicotinovorans | 29320 | Bacteria | Bacteria | 90.1 | 1.46e-20 | NR | WP_156369771.1 | 29320 | g18178 | i0 | 98 | 0.929032258064516 | 49 | 1 | 47.4 | 0 | 162 | 308 | 62 | 110 | WP_156369771.1 hypothetical protein [Paenarthrobacter nicotinovorans] | diamond | 288 | 90.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Paenarthrobacter | Paenarthrobacter nicotinovorans | ||
| 30048036 | 30048036 | PRJNA596870_P_NODE_37791_length_243_cov_0.905882_g37658_i0 | PRJNA596870 | 37791 | 243 | 0.905882 | 2.20129326 | Kitasatospora sp. NBC_ | 1871188 | Bacteria | Bacteria | 72.4 | 9.68e-14 | NR | WP_371484231.1 | 2975963 | g37658 | i0 | 51.9 | 2.02469135802469 | 81 | 36 | 97.5 | 3 | 6 | 242 | 3 | 82 | WP_371484231.1 translationally-controlled tumor protein [Kitasatospora sp. NBC_00315] | diamond | 492 | 72.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora sp. NBC_00315 | ||
| 30679908 | 30679908 | PRJNA596870_P_NODE_20113_length_298_cov_1.026667_g19980_i0 | PRJNA596870 | 20113 | 298 | 1.026667 | 3.05946766 | Streptomyces | 1883 | Bacteria | Bacteria | 51.2 | 2.72e-5 | NR | WP_285507555.1 | 1883 | g19980 | i0 | 48.8 | 0.865771812080537 | 43 | 22 | 43.3 | 0 | 131 | 3 | 50 | 92 | WP_285507555.1 MULTISPECIES: nuclear transport factor 2 family protein [Streptomyces] | diamond | 258 | 51.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | |||
| 30679911 | 30679911 | PRJNA596870_P_NODE_22733_length_283_cov_1.200000_g22600_i0 | PRJNA596870 | 22733 | 283 | 1.2 | 3.396 | Compostimonas suwonensis | 1048394 | Bacteria | Bacteria | 100 | 1.5999999999999999e-24 | NR | WP_100343925.1 | 1048394 | g22600 | i0 | 67.5 | 0.816254416961131 | 77 | 25 | 81.6 | 0 | 51 | 281 | 7 | 83 | WP_100343925.1 hypothetical protein [Compostimonas suwonensis] | diamond | 231 | 100 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Compostimonas | Compostimonas suwonensis | ||
| 30679912 | 30679912 | PRJNA596870_P_NODE_25853_length_267_cov_1.587629_g25720_i0 | PRJNA596870 | 25853 | 267 | 1.587629 | 4.23896943 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 190 | 1.49e-57 | NR | WP_303678928.1 | 1528099 | g25720 | i0 | 100 | 1 | 89 | 0 | 100 | 0 | 267 | 1 | 93 | 181 | WP_303678928.1 esterase/lipase family protein [Lawsonella clevelandensis] | diamond | 267 | 190 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 30725046 | 30725046 | PRJNA596870_P_NODE_39394_length_241_cov_1.833333_g39261_i0 | PRJNA596870 | 39394 | 241 | 1.833333 | 4.41833253 | Corynebacterium | 1716 | Bacteria | Bacteria | 112 | 8.43e-27 | NR | WP_344850978.1 | 1288393 | g39261 | i0 | 72.5 | 1.99170124481328 | 80 | 21 | 99.6 | 1 | 2 | 241 | 66 | 144 | WP_344850978.1 YPDG domain-containing protein [Corynebacterium pilbarense] | diamond | 480 | 112 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium pilbarense | ||
| 31248843 | 31248843 | PRJNA596870_P_NODE_29555_length_251_cov_0.865169_g29422_i0 | PRJNA596870 | 29555 | 251 | 0.865169 | 2.17157419 | Millisia brevis | 264148 | Bacteria | Bacteria | 47.8 | 6.68e-4 | NR | WP_066903500.1 | 264148 | g29422 | i0 | 46.6 | 1.39840637450199 | 58 | 30 | 69.3 | 1 | 223 | 50 | 219 | 275 | WP_066903500.1 SDR family oxidoreductase [Millisia brevis] | diamond | 351 | 47.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Gordoniaceae | Millisia | Millisia brevis | ||
| 31312094 | 31312094 | PRJNA596870_P_NODE_31275_length_249_cov_0.875000_g31142_i0 | PRJNA596870 | 31275 | 249 | 0.875 | 2.17875 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 44.3 | 0.011 | NR | HEY7705461.1 | 2080302 | g31142 | i0 | 46.7 | 0.542168674698795 | 45 | 23 | 54.2 | 1 | 50 | 184 | 322 | 365 | HEY7705461.1 acyltransferase [Acidimicrobiia bacterium] | diamond | 135 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 31547126 | 31547126 | PRJNA596870_P_NODE_40376_length_241_cov_0.857143_g40243_i0 | PRJNA596870 | 40376 | 241 | 0.857143 | 2.06571463 | Pseudonocardia | 1847 | Bacteria | Bacteria | 79 | 2.99e-15 | NR | MDT7718697.1 | 2201155 | g40243 | i0 | 47.5 | 8.00414937759336 | 80 | 42 | 99.6 | 0 | 241 | 2 | 172 | 251 | MDT7718697.1 hypothetical protein [Pseudonocardiales bacterium] | diamond | 1929 | 79 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiales bacterium | ||||
| 31881345 | 31881345 | PRJNA596870_P_NODE_25657_length_268_cov_1.369231_g25524_i0 | PRJNA596870 | 25657 | 268 | 1.369231 | 3.66953908 | Aurantimicrobium sp. | 1930784 | Bacteria | Bacteria | 174 | 3.16e-48 | NR | WP_332627474.1 | 1930784 | g25524 | i0 | 88.8 | 0.996268656716418 | 89 | 10 | 99.6 | 0 | 1 | 267 | 672 | 760 | WP_332627474.1 hypothetical protein [Aurantimicrobium sp.] | diamond | 267 | 174 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Aurantimicrobium | Aurantimicrobium sp. | ||
| 32102922 | 32102922 | PRJNA596870_P_NODE_19218_length_304_cov_1.333333_g19085_i0 | PRJNA596870 | 19218 | 304 | 1.333333 | 4.05333232 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 42.7 | 0.0196 | NR | MDQ2816046.1 | 2900548 | g19085 | i0 | 38.2 | 0.542763157894737 | 55 | 34 | 54.3 | 0 | 53 | 217 | 24 | 78 | MDQ2816046.1 DUF2461 domain-containing protein [Actinomycetota bacterium] | diamond | 165 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 32324796 | 32324796 | PRJNA596870_P_NODE_35819_length_245_cov_0.895349_g35686_i0 | PRJNA596870 | 35819 | 245 | 0.895349 | 2.19360505 | Microbacterium sp. 69-7 | 1895784 | Bacteria | Bacteria | 80.1 | 2.85e-16 | NR | WP_288119540.1 | 1895784 | g35686 | i0 | 95.3 | 0.52653061224489806 | 43 | 2 | 52.7 | 0 | 1 | 129 | 170 | 212 | WP_288119540.1 2-phosphosulfolactate phosphatase [Microbacterium sp. 69-7] | diamond | 129 | 80.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. 69-7 | ||
| 32419446 | 32419446 | PRJNA596870_P_NODE_18239_length_311_cov_1.281513_g18106_i0 | PRJNA596870 | 18239 | 311 | 1.281513 | 3.98550543 | Microbacterium hominis | 162426 | Bacteria | Bacteria | 82.8 | 9.64e-17 | NR | WP_156122581.1 | 162426 | g18106 | i0 | 82.3 | 1.06109324758842 | 62 | 11 | 59.8 | 0 | 125 | 310 | 25 | 86 | WP_156122581.1 hypothetical protein [Microbacterium hominis] | diamond | 330 | 82.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium hominis | ||
| 32892282 | 32892282 | PRJNA596870_P_NODE_37340_length_243_cov_2.000000_g37207_i0 | PRJNA596870 | 37340 | 243 | 2 | 4.86 | Microbacterium sp. cx-55 | 2875948 | Bacteria | Bacteria | 72.4 | 4.95e-13 | NR | WP_223721113.1 | 2875948 | g37207 | i0 | 46.1 | 0.938271604938272 | 76 | 41 | 93.8 | 0 | 230 | 3 | 110 | 185 | WP_223721113.1 hypothetical protein [Microbacterium sp. cx-55] | diamond | 228 | 72.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. cx-55 |
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);;