contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA640143" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10814088 | 10814088 | PRJNA640143_S_NODE_21309_length_190_cov_13.137255_g21099_i0 | PRJNA640143 | 21309 | 190 | 13.137255 | 24.9607845 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 80.9 | 4.84e-16 | NR | MFN0028796.1 | 2201156 | g21099 | i0 | 85.1 | 0.742105263157895 | 47 | 7 | 74.2 | 0 | 155 | 15 | 11 | 57 | MFN0028796.1 molybdopterin-synthase adenylyltransferase MoeB [Acidimicrobiales bacterium] | diamond | 141 | 80.9 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 10814211 | 10814211 | PRJNA640143_S_NODE_27009_length_169_cov_1.598485_g26799_i0 | PRJNA640143 | 27009 | 169 | 1.598485 | 2.70143965 | Microbacterium sp. NPDC | 51671 | Bacteria | Bacteria | 104 | 9.57e-27 | NR | WP_363360348.1 | 3155817 | g26799 | i0 | 94.2 | 0.923076923076923 | 52 | 3 | 92.3 | 0 | 14 | 169 | 1 | 52 | WP_363360348.1 ribose-5-phosphate isomerase [Microbacterium sp. NPDC064584] | diamond | 156 | 104 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. NPDC064584 | ||
| 22287055 | 22287055 | PRJNA640143_S_NODE_25258_length_176_cov_1.000000_g25048_i0 | PRJNA640143 | 25258 | 176 | 1 | 1.76 | Aquipuribacter hungaricus | 545624 | Bacteria | Bacteria | 112 | 4.55e-28 | NR | WP_340292247.1 | 545624 | g25048 | i0 | 93.1 | 0.988636363636364 | 58 | 4 | 98.9 | 0 | 176 | 3 | 236 | 293 | WP_340292247.1 thioredoxin-disulfide reductase [Aquipuribacter hungaricus] | diamond | 174 | 112 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Aquipuribacter | Aquipuribacter hungaricus | ||
| 26764474 | 26764474 | PRJNA640143_S_NODE_20861_length_192_cov_5.935484_g20651_i0 | PRJNA640143 | 20861 | 192 | 5.935484 | 11.39612928 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 92.4 | 5.77e-20 | NR | MCC6438575.1 | 2201156 | g20651 | i0 | 93.2 | 0.6875 | 44 | 3 | 68.8 | 0 | 158 | 27 | 69 | 112 | MCC6438575.1 acyl-CoA dehydrogenase [Acidimicrobiales bacterium] | diamond | 132 | 92.4 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 26954276 | 26954276 | PRJNA640143_S_NODE_22002_length_188_cov_0.986755_g21792_i0 | PRJNA640143 | 22002 | 188 | 0.986755 | 1.8550994 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 93.6 | 1.6e-20 | NR | MEY2848758.1 | 2900548 | g21792 | i0 | 86 | 0.797872340425532 | 50 | 7 | 79.8 | 0 | 1 | 150 | 64 | 113 | MEY2848758.1 hypothetical protein [Actinomycetota bacterium] | diamond | 150 | 93.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 27030187 | 27030187 | PRJNA640143_S_NODE_20062_length_196_cov_2.295597_g19852_i0 | PRJNA640143 | 20062 | 196 | 2.295597 | 4.49937012 | Streptomyces | 1883 | Bacteria | Bacteria | 42 | 0.0219 | NR | EFE84358.1 | 1886 | g19852 | i0 | 48.2 | 2.63265306122449 | 56 | 29 | 85.7 | 0 | 194 | 27 | 53 | 108 | EFE84358.1 conserved hypothetical protein [Streptomyces albidoflavus] | diamond | 516 | 42.4 | 0.990566037735849 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces albidoflavus | ||
| 27618255 | 27618255 | PRJNA640143_S_NODE_5564_length_351_cov_9.216561_g5354_i0 | PRJNA640143 | 5564 | 351 | 9.216561 | 32.35012911 | Gaiella sp. | 2663207 | Bacteria | Bacteria | 162 | 1.8e-47 | NR | HET9937642.1 | 2663207 | g5354 | i0 | 92.6 | 0.803418803418803 | 94 | 7 | 80.3 | 0 | 33 | 314 | 164 | 257 | HET9937642.1 hypothetical protein [Gaiella sp.] | diamond | 282 | 162 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Gaiellales | Gaiellaceae | Gaiella | Gaiella sp. | ||
| 28880943 | 28880943 | PRJNA640143_S_NODE_13028_length_240_cov_7.211823_g12818_i0 | PRJNA640143 | 13028 | 240 | 7.211823 | 17.3083752 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 70.1 | 7.94e-12 | NR | MFV0257242.1 | 2201156 | g12818 | i0 | 59.3 | 1.35 | 54 | 22 | 67.5 | 0 | 203 | 42 | 425 | 478 | MFV0257242.1 D-alanyl-D-alanine carboxypeptidase family protein [Acidimicrobiales bacterium] | diamond | 324 | 70.1 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 29102181 | 29102181 | PRJNA640143_S_NODE_24668_length_177_cov_378.521429_g24458_i0 | PRJNA640143 | 24668 | 177 | 378.521429 | 669.98292933 | Solirubrobacterales bacterium | 1909295 | Bacteria | Bacteria | 68.2 | 1.34e-11 | NR | HYQ13484.1 | 1909295 | g24458 | i0 | 71.7 | 8.38983050847458 | 46 | 13 | 78 | 0 | 175 | 38 | 176 | 221 | HYQ13484.1 DUF1385 domain-containing protein [Solirubrobacterales bacterium] | diamond | 1485 | 68.2 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacterales bacterium | ||||
| 29272190 | 29272190 | PRJNA640143_S_NODE_32429_length_151_cov_1.517544_g32219_i0 | PRJNA640143 | 32429 | 151 | 1.517544 | 2.29149144 | Bacillati | 1783272 | Bacteria | Bacteria | 47 | 3.25e-4 | NR | HYB30793.1 | 2586742 | g32219 | i0 | 43.8 | 4.78807947019868 | 48 | 27 | 95.4 | 0 | 146 | 3 | 214 | 261 | HYB30793.1 sigma-70 family RNA polymerase sigma factor [Solirubrobacteraceae bacterium] | diamond | 723 | 47 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 29386380 | 29386380 | PRJNA640143_S_NODE_23049_length_183_cov_10.301370_g22839_i0 | PRJNA640143 | 23049 | 183 | 10.30137 | 18.8515071 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 72.8 | 4.18e-13 | NR | MDT5081352.1 | 1785 | g22839 | i0 | 79.1 | 2.09836065573771 | 43 | 9 | 70.5 | 0 | 151 | 23 | 678 | 720 | MDT5081352.1 hypothetical protein [Mycobacterium sp.] | diamond | 384 | 72.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 29493429 | 29493429 | PRJNA640143_S_NODE_23810_length_181_cov_1.083333_g23600_i0 | PRJNA640143 | 23810 | 181 | 1.083333 | 1.96083273 | Aeromicrobium | 2040 | Bacteria | Bacteria | 69.3 | 4.8e-13 | NR | WP_297780780.1 | 1871063 | g23600 | i0 | 63 | 2.68508287292818 | 54 | 19 | 87.8 | 1 | 179 | 21 | 41 | 94 | WP_297780780.1 DUF2550 domain-containing protein [Aeromicrobium sp.] | diamond | 486 | 69.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Aeromicrobium | Aeromicrobium sp. | ||
| 29638477 | 29638477 | PRJNA640143_S_NODE_18690_length_203_cov_1.337349_g18480_i0 | PRJNA640143 | 18690 | 203 | 1.337349 | 2.71481847 | Arthrobacter sp. Soc17.1.1.1 | 3121277 | Bacteria | Bacteria | 49.3 | 5.66e-5 | NR | WP_334211951.1 | 3121277 | g18480 | i0 | 73.5 | 0.502463054187192 | 34 | 9 | 50.2 | 0 | 201 | 100 | 68 | 101 | WP_334211951.1 sigma-70 family RNA polymerase sigma factor [Arthrobacter sp. Soc17.1.1.1] | diamond | 102 | 49.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter sp. Soc17.1.1.1 | ||
| 29923159 | 29923159 | PRJNA640143_S_NODE_21711_length_189_cov_1.671053_g21501_i0 | PRJNA640143 | 21711 | 189 | 1.671053 | 3.15829017 | Actinomycetospora chlora | 663608 | Bacteria | Bacteria | 42.4 | 0.0099 | NR | WP_345425833.1 | 663608 | g21501 | i0 | 38.8 | 0.777777777777778 | 49 | 30 | 77.8 | 0 | 149 | 3 | 1 | 49 | WP_345425833.1 hypothetical protein, partial [Actinomycetospora chlora] | diamond | 147 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinomycetospora | Actinomycetospora chlora | ||
| 30428942 | 30428942 | PRJNA640143_S_NODE_21053_length_191_cov_344.928571_g20843_i0 | PRJNA640143 | 21053 | 191 | 344.928571 | 658.81357061 | uncultured Nocardioides sp. | 198441 | Bacteria | Bacteria | 47.4 | 3.71e-4 | NR | WP_298518960.1 | 198441 | g20843 | i0 | 60 | 0.628272251308901 | 40 | 16 | 62.8 | 0 | 130 | 11 | 3 | 42 | WP_298518960.1 hypothetical protein [uncultured Nocardioides sp.] | diamond | 120 | 47.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | uncultured Nocardioides sp. | ||
| 30472724 | 30472724 | PRJNA640143_S_NODE_30353_length_157_cov_1.625000_g30143_i0 | PRJNA640143 | 30353 | 157 | 1.625 | 2.55125 | Microbacterium | 33882 | Bacteria | Bacteria | 97.8 | 1.8e-23 | NR | WP_378751246.1 | 323761 | g30143 | i0 | 90.4 | 5.96178343949045 | 52 | 5 | 99.4 | 0 | 2 | 157 | 36 | 87 | WP_378751246.1 hypothetical protein [Microbacterium koreense] | diamond | 936 | 97.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium koreense | ||
| 30618040 | 30618040 | PRJNA640143_S_NODE_31313_length_154_cov_1.632479_g31103_i0 | PRJNA640143 | 31313 | 154 | 1.632479 | 2.51401766 | Microbacterium sp. | 51671 | Bacteria | Bacteria | 65.5 | 3.94e-11 | NR | WP_396643578.1 | 51671 | g31103 | i0 | 62 | 0.974025974025974 | 50 | 18 | 97.4 | 1 | 4 | 153 | 113 | 161 | WP_396643578.1 hypothetical protein [Microbacterium sp.] | diamond | 150 | 65.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. | ||
| 30712884 | 30712884 | PRJNA640143_S_NODE_17114_length_211_cov_9.850575_g16904_i0 | PRJNA640143 | 17114 | 211 | 9.850575 | 20.78471325 | unclassified Microbacterium | 2609290 | Bacteria | Bacteria | 84.7 | 1.36e-17 | NR | WP_405372898.1 | 2609290 | g16904 | i0 | 100 | 0.568720379146919 | 40 | 0 | 56.9 | 0 | 177 | 58 | 109 | 148 | WP_405372898.1 MULTISPECIES: proteasome assembly chaperone family protein [unclassified Microbacterium] | diamond | 120 | 84.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | |||
| 31503290 | 31503290 | PRJNA640143_S_NODE_10876_length_262_cov_1.257778_g10666_i0 | PRJNA640143 | 10876 | 262 | 1.257778 | 3.29537836 | Microbacterium lacus | 415217 | Bacteria | Bacteria | 108 | 3.3299999999999998e-25 | NR | WP_404431579.1 | 415217 | g10666 | i0 | 93 | 0.652671755725191 | 57 | 4 | 65.3 | 0 | 261 | 91 | 645 | 701 | WP_404431579.1 alpha-galactosidase [Microbacterium lacus] | diamond | 171 | 108 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium lacus | ||
| 31629680 | 31629680 | PRJNA640143_S_NODE_19336_length_199_cov_8.339506_g19126_i0 | PRJNA640143 | 19336 | 199 | 8.339506 | 16.59561694 | Conexibacter sp. | 1929289 | Bacteria | Bacteria | 47 | 6.4e-4 | NR | HEY4281237.1 | 1929289 | g19126 | i0 | 59.5 | 0.633165829145729 | 42 | 17 | 63.3 | 0 | 146 | 21 | 12 | 53 | HEY4281237.1 CoA transferase [Conexibacter sp.] | diamond | 126 | 47 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Conexibacteraceae | Conexibacter | Conexibacter sp. | ||
| 32135932 | 32135932 | PRJNA640143_S_NODE_11958_length_250_cov_11.244131_g11748_i0 | PRJNA640143 | 11958 | 250 | 11.244131 | 28.1103275 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 94 | 3.82e-20 | NR | MEZ5263250.1 | 2201156 | g11748 | i0 | 100 | 1.764 | 49 | 0 | 58.8 | 0 | 216 | 70 | 166 | 214 | MEZ5263250.1 dynamin family protein [Acidimicrobiales bacterium] | diamond | 441 | 94 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 32610232 | 32610232 | PRJNA640143_S_NODE_21920_length_188_cov_2.006623_g21710_i0 | PRJNA640143 | 21920 | 188 | 2.006623 | 3.77245124 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 42.4 | 0.0245 | NR | WKZ83440.1 | 2080302 | g21710 | i0 | 32.7 | 0.877659574468085 | 55 | 37 | 87.8 | 0 | 13 | 177 | 307 | 361 | WKZ83440.1 MAG: AMP-binding protein [Acidimicrobiia bacterium] | diamond | 165 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 32736346 | 32736346 | PRJNA640143_S_NODE_32440_length_151_cov_1.377193_g32230_i0 | PRJNA640143 | 32440 | 151 | 1.377193 | 2.07956143 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 96.7 | 5.02e-22 | NR | MBI2703540.1 | 1785 | g32230 | i0 | 100 | 0.973509933774834 | 49 | 0 | 97.4 | 0 | 3 | 149 | 201 | 249 | MBI2703540.1 cytochrome P450 [Mycobacterium sp.] | diamond | 147 | 96.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium 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);;