contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA508758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4311845 | 4311845 | PRJNA508758_P_NODE_84484_length_244_cov_0.877193_g83436_i0 | PRJNA508758 | 84484 | 244 | 0.877193 | 2.14035092 | Solirubrobacter sp. | 1932788 | Bacteria | Bacteria | 120 | 1.1499999999999999e-32 | NR | HEX6024707.1 | 1932788 | g83436 | i0 | 86.8 | 1.67213114754098 | 68 | 9 | 83.6 | 0 | 40 | 243 | 1 | 68 | HEX6024707.1 gamma carbonic anhydrase family protein [Solirubrobacter sp.] | diamond | 408 | 120 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacter | Solirubrobacter sp. | ||
| 18336501 | 18336501 | PRJNA508758_P_NODE_71515_length_255_cov_1.395604_g70467_i0 | PRJNA508758 | 71515 | 255 | 1.395604 | 3.5587902 | Agrococcus | 46352 | Bacteria | Bacteria | 125 | 7.27e-34 | NR | WP_146794961.1 | 153730 | g70467 | i0 | 76.5 | 3 | 85 | 20 | 100 | 0 | 255 | 1 | 33 | 117 | WP_146794961.1 hypothetical protein [Agrococcus baldri] | diamond | 765 | 125 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Agrococcus | Agrococcus baldri | ||
| 19610879 | 19610879 | PRJNA508758_P_NODE_78016_length_248_cov_0.880000_g76968_i0 | PRJNA508758 | 78016 | 248 | 0.88 | 2.1824 | Microbacterium sp. SLBN-146 | 2768457 | Bacteria | Bacteria | 110 | 4.51e-27 | NR | WP_141930949.1 | 2768457 | g76968 | i0 | 95.2 | 1.5 | 62 | 3 | 75 | 0 | 61 | 246 | 1 | 62 | WP_141930949.1 ketose-bisphosphate aldolase [Microbacterium sp. SLBN-146] | diamond | 372 | 110 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. SLBN-146 | ||
| 20886832 | 20886832 | PRJNA508758_P_NODE_61957_length_274_cov_1.024876_g60909_i0 | PRJNA508758 | 61957 | 274 | 1.024876 | 2.80816024 | Parenemella sanctibonifatiensis | 2016505 | Bacteria | Bacteria | 186 | 5.559999999999999e-54 | NR | WP_229116579.1 | 2016505 | g60909 | i0 | 97.8 | 0.985401459854015 | 90 | 2 | 98.5 | 0 | 3 | 272 | 170 | 259 | WP_229116579.1 AMP-dependent synthetase/ligase [Parenemella sanctibonifatiensis] | diamond | 270 | 186 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Parenemella | Parenemella sanctibonifatiensis | ||
| 27250556 | 27250556 | PRJNA508758_P_NODE_5843_length_990_cov_2.750273_g5088_i0 | PRJNA508758 | 5843 | 990 | 2.750273 | 27.2277027 | FCB group | 1783270 | Bacteria | Bacteria | 129 | 3.18e-33 | NR | MCA1715340.1 | 2900548 | g5088 | i0 | 47.3 | 5.77272727272727 | 131 | 64 | 39.7 | 2 | 541 | 933 | 1 | 126 | MCA1715340.1 Mth938-like domain-containing protein [Actinomycetota bacterium] | diamond | 5715 | 130 | 0.992307692307692 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 27519487 | 27519487 | PRJNA508758_P_NODE_12283_length_598_cov_3.489524_g11281_i0 | PRJNA508758 | 12283 | 598 | 3.489524 | 20.86735352 | Trebonia sp. | 2767075 | Bacteria | Bacteria | 46.6 | 0.0384 | NR | HVT68871.1 | 2767075 | g11281 | i0 | 38 | 0.3561872909699 | 71 | 44 | 35.6 | 0 | 368 | 156 | 528 | 598 | HVT68871.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Trebonia sp.] | diamond | 213 | 46.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Treboniaceae | Trebonia | Trebonia sp. | ||
| 27803821 | 27803821 | PRJNA508758_P_NODE_80164_length_247_cov_0.885057_g79116_i0 | PRJNA508758 | 80164 | 247 | 0.885057 | 2.18609079 | Herbihabitans rhizosphaerae | 1872711 | Bacteria | Bacteria | 43.5 | 0.0205 | NR | WP_130346325.1 | 1872711 | g79116 | i0 | 35.2 | 0.862348178137652 | 71 | 40 | 82.6 | 2 | 224 | 21 | 406 | 473 | WP_130346325.1 ArnT family glycosyltransferase [Herbihabitans rhizosphaerae] | diamond | 213 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Herbihabitans | Herbihabitans rhizosphaerae | ||
| 28450746 | 28450746 | PRJNA508758_P_NODE_47726_length_306_cov_1.321888_g46678_i0 | PRJNA508758 | 47726 | 306 | 1.321888 | 4.04497728 | Bacteria | 2 | Bacteria | Bacteria | 47 | 5.38e-4 | NR | WP_344745140.1 | 46190 | g46678 | i0 | 38.2 | 2.69607843137255 | 55 | 34 | 53.9 | 0 | 244 | 80 | 24 | 78 | WP_344745140.1 AMP-binding enzyme [Streptosporangium vulgare] | diamond | 825 | 47.4 | 0.991561181434599 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Streptosporangium | Streptosporangium vulgare | ||
| 28940561 | 28940561 | PRJNA508758_P_NODE_77328_length_249_cov_0.875000_g76280_i0 | PRJNA508758 | 77328 | 249 | 0.875 | 2.17875 | Leifsonia shinshuensis | 150026 | Bacteria | Bacteria | 150 | 1.15e-41 | NR | WP_241701912.1 | 150026 | g76280 | i0 | 93.9 | 0.987951807228916 | 82 | 5 | 98.8 | 0 | 2 | 247 | 74 | 155 | WP_241701912.1 DUF58 domain-containing protein [Leifsonia shinshuensis] | diamond | 246 | 150 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Leifsonia | Leifsonia shinshuensis | ||
| 29129978 | 29129978 | PRJNA508758_P_NODE_25949_length_395_cov_1.475155_g24901_i0 | PRJNA508758 | 25949 | 395 | 1.475155 | 5.82686225 | Rubrobacteraceae bacterium | 2740537 | Bacteria | Bacteria | 45.1 | 0.0299 | NR | HEY6674089.1 | 2740537 | g24901 | i0 | 31 | 0.881012658227848 | 116 | 66 | 85.8 | 6 | 4 | 342 | 16 | 120 | HEY6674089.1 glutamate synthase large subunit [Rubrobacteraceae bacterium] | diamond | 348 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Rubrobacteria | Rubrobacterales | Rubrobacteraceae | Rubrobacteraceae bacterium | |||
| 29130012 | 29130012 | PRJNA508758_P_NODE_78389_length_248_cov_0.880000_g77341_i0 | PRJNA508758 | 78389 | 248 | 0.88 | 2.1824 | Actinomyces sp. ICM47 | 936548 | Bacteria | Bacteria | 144 | 2.32e-38 | NR | WP_083836264.1 | 936548 | g77341 | i0 | 93.9 | 0.991935483870968 | 82 | 5 | 99.2 | 0 | 247 | 2 | 342 | 423 | WP_083836264.1 exonuclease domain-containing protein [Actinomyces sp. ICM47] | diamond | 246 | 144 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Actinomyces | Actinomyces sp. ICM47 | ||
| 29193080 | 29193080 | PRJNA508758_P_NODE_4289_length_1195_cov_4.729055_g3744_i0 | PRJNA508758 | 4289 | 1195 | 4.729055 | 56.51220725 | Saccharopolyspora flava | 95161 | Bacteria | Bacteria | 50.1 | 0.0125 | NR | WP_093418561.1 | 95161 | g3744 | i0 | 44.3 | 0.198326359832636 | 79 | 41 | 19.3 | 2 | 825 | 595 | 20 | 97 | WP_093418561.1 LLM class flavin-dependent oxidoreductase [Saccharopolyspora flava] | diamond | 237 | 50.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharopolyspora | Saccharopolyspora flava | ||
| 29476799 | 29476799 | PRJNA508758_P_NODE_79410_length_247_cov_0.885057_g78362_i0 | PRJNA508758 | 79410 | 247 | 0.885057 | 2.18609079 | Corynebacterium meitnerae | 2913498 | Bacteria | Bacteria | 152 | 4.11e-42 | NR | WP_269964772.1 | 2913498 | g78362 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 1 | 246 | 233 | 314 | WP_269964772.1 ammonium transporter [Corynebacterium meitnerae] | diamond | 246 | 152 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium meitnerae | ||
| 29666149 | 29666149 | PRJNA508758_P_NODE_33310_length_355_cov_1.024823_g32262_i0 | PRJNA508758 | 33310 | 355 | 1.024823 | 3.63812165 | unclassified Streptomyces | 2593676 | Bacteria | Bacteria | 45.8 | 0.00967 | NR | WP_329921045.1 | 2593676 | g32262 | i0 | 34.7 | 0.853521126760563 | 101 | 58 | 82.8 | 4 | 44 | 337 | 60 | 155 | WP_329921045.1 MULTISPECIES: N-acetylglucosamine kinase [unclassified Streptomyces] | diamond | 303 | 45.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | |||
| 29887693 | 29887693 | PRJNA508758_P_NODE_2851_length_1516_cov_2.811504_g2473_i0 | PRJNA508758 | 2851 | 1516 | 2.811504 | 42.62240064 | Micrococcus luteus | 1270 | Bacteria | Bacteria | 67.8 | 8.8e-10 | NR | WP_216882726.1 | 1270 | g2473 | i0 | 31.8 | 0.338390501319261 | 110 | 72 | 21.8 | 1 | 831 | 1160 | 7 | 113 | WP_216882726.1 hypothetical protein [Micrococcus luteus] | diamond | 513 | 67.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus luteus | ||
| 29903142 | 29903142 | PRJNA508758_P_NODE_74031_length_251_cov_0.865169_g72983_i0 | PRJNA508758 | 74031 | 251 | 0.865169 | 2.17157419 | Actinomycetota | 201174 | Bacteria | Bacteria | 41.6 | 0.0188 | NR | WP_310049504.1 | 1356565 | g72983 | i0 | 41.2 | 1.92430278884462 | 51 | 30 | 61 | 0 | 54 | 206 | 23 | 73 | WP_310049504.1 PLD nuclease N-terminal domain-containing protein [Arthrobacter ginsengisoli] | diamond | 483 | 41.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter ginsengisoli | ||
| 29919333 | 29919333 | PRJNA508758_P_NODE_84811_length_243_cov_1.570588_g83763_i0 | PRJNA508758 | 84811 | 243 | 1.570588 | 3.81652884 | Nonomuraea rubra | 46180 | Bacteria | Bacteria | 43.9 | 0.0139 | NR | WP_379491580.1 | 46180 | g83763 | i0 | 35.8 | 0.827160493827161 | 67 | 33 | 82.7 | 2 | 230 | 30 | 325 | 381 | WP_379491580.1 alpha/beta hydrolase family protein [Nonomuraea rubra] | diamond | 201 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Nonomuraea | Nonomuraea rubra | ||
| 29982328 | 29982328 | PRJNA508758_P_NODE_36751_length_340_cov_2.550562_g35703_i0 | PRJNA508758 | 36751 | 340 | 2.550562 | 8.6719108 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 43.5 | 0.0304 | NR | MEZ5192790.1 | 35761 | g35703 | i0 | 47.7 | 0.388235294117647 | 44 | 23 | 38.8 | 0 | 196 | 65 | 65 | 108 | MEZ5192790.1 hypothetical protein [Nocardioides sp.] | diamond | 132 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 30014054 | 30014054 | PRJNA508758_P_NODE_71031_length_256_cov_1.278689_g69983_i0 | PRJNA508758 | 71031 | 256 | 1.278689 | 3.27344384 | Kitasatospora griseola | 2064 | Bacteria | Bacteria | 41.2 | 0.0322 | NR | WP_380333499.1 | 2064 | g69983 | i0 | 55.9 | 0.3984375 | 34 | 14 | 38.7 | 1 | 117 | 215 | 50 | 83 | WP_380333499.1 hypothetical protein [Kitasatospora griseola] | diamond | 102 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora griseola | ||
| 30076995 | 30076995 | PRJNA508758_P_NODE_84052_length_244_cov_0.900585_g83004_i0 | PRJNA508758 | 84052 | 244 | 0.900585 | 2.1974274 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 125 | 9.469999999999999e-32 | NR | MDQ3965353.1 | 2900548 | g83004 | i0 | 80.2 | 0.995901639344262 | 81 | 16 | 99.6 | 0 | 243 | 1 | 203 | 283 | MDQ3965353.1 PAS domain S-box protein [Actinomycetota bacterium] | diamond | 243 | 125 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30645645 | 30645645 | PRJNA508758_P_NODE_68133_length_262_cov_0.984127_g67085_i0 | PRJNA508758 | 68133 | 262 | 0.984127 | 2.57841274 | Micromonospora auratinigra | 261654 | Bacteria | Bacteria | 43.9 | 0.018 | NR | WP_091658452.1 | 261654 | g67085 | i0 | 35.3 | 0.778625954198473 | 68 | 34 | 66.4 | 2 | 59 | 232 | 321 | 388 | WP_091658452.1 D-alanyl-D-alanine carboxypeptidase family protein [Micromonospora auratinigra] | diamond | 204 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora auratinigra | ||
| 30803826 | 30803826 | PRJNA508758_P_NODE_80554_length_246_cov_1.520231_g79506_i0 | PRJNA508758 | 80554 | 246 | 1.520231 | 3.73976826 | Streptomyces sp. 2321.6 | 1938840 | Bacteria | Bacteria | 42.4 | 0.046 | NR | PBC87039.1 | 1938840 | g79506 | i0 | 39.7 | 0.829268292682927 | 68 | 37 | 79.3 | 2 | 48 | 242 | 30 | 96 | PBC87039.1 hypothetical protein BX261_7173 [Streptomyces sp. 2321.6] | diamond | 204 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. 2321.6 | ||
| 31134884 | 31134884 | PRJNA508758_P_NODE_82295_length_245_cov_0.895349_g81247_i0 | PRJNA508758 | 82295 | 245 | 0.895349 | 2.19360505 | Rothia | 32207 | Bacteria | Bacteria | 155 | 9.02e-43 | NR | WP_346924112.1 | 1885016 | g81247 | i0 | 100 | 1.98367346938776 | 81 | 0 | 99.2 | 0 | 244 | 2 | 251 | 331 | WP_346924112.1 oligosaccharide flippase family protein [Rothia sp. (in: high G+C Gram-positive bacteria)] | diamond | 486 | 155 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Rothia | Rothia sp. (in: high G+C Gram-positive bacteria) | ||
| 31688949 | 31688949 | PRJNA508758_P_NODE_76057_length_250_cov_0.870056_g75009_i0 | PRJNA508758 | 76057 | 250 | 0.870056 | 2.17514 | Microbacterium sp. JZ31 | 1906274 | Bacteria | Bacteria | 44.7 | 0.00866 | NR | WP_238439419.1 | 1906274 | g75009 | i0 | 36.5 | 0.756 | 63 | 40 | 75.6 | 0 | 34 | 222 | 412 | 474 | WP_238439419.1 glycoside hydrolase family 65 protein [Microbacterium sp. JZ31] | diamond | 189 | 44.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. JZ31 | ||
| 31783769 | 31783769 | PRJNA508758_P_NODE_83677_length_244_cov_0.900585_g82629_i0 | PRJNA508758 | 83677 | 244 | 0.900585 | 2.1974274 | Streptomyces sp. NBC_ | 1931 | Bacteria | Bacteria | 43.9 | 0.0133 | NR | WP_323179198.1 | 2975635 | g82629 | i0 | 39.1 | 0.848360655737705 | 69 | 35 | 84.8 | 3 | 12 | 218 | 62 | 123 | WP_323179198.1 protein kinase domain-containing protein [Streptomyces sp. NBC_00059] | diamond | 207 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NBC_00059 | ||
| 31847080 | 31847080 | PRJNA508758_P_NODE_8097_length_788_cov_8.637762_g7191_i0 | PRJNA508758 | 8097 | 788 | 8.637762 | 68.06556456 | Actinacidiphila soli | 2487275 | Bacteria | Bacteria | 48.1 | 0.0232 | NR | WP_127360606.1 | 2487275 | g7191 | i0 | 29.6 | 0.373096446700508 | 98 | 63 | 36.5 | 2 | 750 | 463 | 225 | 318 | WP_127360606.1 O-antigen ligase family protein [Actinacidiphila soli] | diamond | 294 | 48.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Actinacidiphila | Actinacidiphila soli | ||
| 32416819 | 32416819 | PRJNA508758_P_NODE_52739_length_293_cov_1.400000_g51691_i0 | PRJNA508758 | 52739 | 293 | 1.4 | 4.102 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 43.9 | 0.0244 | NR | MDP9262338.1 | 2900548 | g51691 | i0 | 36.4 | 0.675767918088737 | 66 | 37 | 62.5 | 1 | 110 | 292 | 81 | 146 | MDP9262338.1 beta-eliminating lyase-related protein [Actinomycetota bacterium] | diamond | 198 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota 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);;