contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA637328" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3160012 | 3160012 | PRJNA637328_P_NODE_20863_length_227_cov_7.314607_g20386_i0 | PRJNA637328 | 20863 | 227 | 7.314607 | 16.60415789 | Krasilnikoviella flava | 526729 | Bacteria | Bacteria | 139 | 7.08e-39 | NR | WP_139820991.1 | 526729 | g20386 | i0 | 89.3 | 0.991189427312775 | 75 | 8 | 99.1 | 0 | 226 | 2 | 28 | 102 | WP_139820991.1 SH3 domain-containing protein [Krasilnikoviella flava] | diamond | 225 | 139 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Promicromonosporaceae | Krasilnikoviella | Krasilnikoviella flava | ||
| 10813287 | 10813287 | PRJNA637328_P_NODE_20889_length_227_cov_4.421348_g20412_i0 | PRJNA637328 | 20889 | 227 | 4.421348 | 10.03645996 | Bacteria | 2 | Bacteria | Bacteria | 160 | 1.07e-44 | NR | MDX5318603.1 | 1883427 | g20412 | i0 | 100 | 1.98237885462555 | 75 | 0 | 99.1 | 0 | 225 | 1 | 240 | 314 | MDX5318603.1 [FeFe] hydrogenase, group A [Actinomycetes bacterium] | diamond | 450 | 160 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetes bacterium | |||||
| 18461053 | 18461053 | PRJNA637328_P_NODE_13335_length_267_cov_3.068807_g12859_i0 | PRJNA637328 | 13335 | 267 | 3.068807 | 8.19371469 | Olsenella profusa | 138595 | Bacteria | Bacteria | 137 | 9.49e-39 | NR | WP_021726616.1 | 138595 | g12859 | i0 | 98.5 | 0.752808988764045 | 67 | 1 | 75.3 | 0 | 267 | 67 | 139 | 205 | WP_021726616.1 sulfurtransferase-like selenium metabolism protein YedF [Olsenella profusa] | diamond | 201 | 137 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriales | Atopobiaceae | Olsenella | Olsenella profusa | ||
| 19735694 | 19735694 | PRJNA637328_P_NODE_13796_length_265_cov_0.944444_g13320_i0 | PRJNA637328 | 13796 | 265 | 0.944444 | 2.5027766 | Dermabacter | 36739 | Bacteria | Bacteria | 135 | 9.87e-36 | NR | WP_147594862.1 | 36739 | g13320 | i0 | 75.9 | 1.95849056603774 | 87 | 21 | 98.5 | 0 | 2 | 262 | 261 | 347 | WP_147594862.1 MULTISPECIES: phage portal protein [Dermabacter] | diamond | 519 | 135 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermabacteraceae | Dermabacter | |||
| 25381512 | 25381512 | PRJNA637328_P_NODE_7260_length_332_cov_4.371025_g6785_i0 | PRJNA637328 | 7260 | 332 | 4.371025 | 14.511803 | Propioniciclava sp. | 2038686 | Bacteria | Bacteria | 139 | 1.49e-36 | NR | MFV0452586.1 | 2038686 | g6785 | i0 | 65.8 | 1.03012048192771 | 114 | 34 | 98.5 | 1 | 2 | 328 | 230 | 343 | MFV0452586.1 TrkH family potassium uptake protein [Propioniciclava sp.] | diamond | 342 | 139 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Propioniciclava | Propioniciclava sp. | ||
| 26744975 | 26744975 | PRJNA637328_P_NODE_13881_length_264_cov_2.846512_g13404_i0 | PRJNA637328 | 13881 | 264 | 2.846512 | 7.51479168 | Actinomycetota | 201174 | Bacteria | Bacteria | 169 | 3.8999999999999997e-48 | NR | WP_134206232.1 | 404941 | g13404 | i0 | 87.5 | 7 | 88 | 11 | 100 | 0 | 1 | 264 | 223 | 310 | WP_134206232.1 Eco57I restriction-modification methylase domain-containing protein [Mycobacteroides salmoniphilum] | diamond | 1848 | 169 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacteroides | Mycobacteroides salmoniphilum | ||
| 26891398 | 26891398 | PRJNA637328_P_NODE_12301_length_274_cov_4.351111_g11825_i0 | PRJNA637328 | 12301 | 274 | 4.351111 | 11.92204414 | Corynebacterium urealyticum | 43771 | Bacteria | Bacteria | 87.4 | 1.09e-17 | NR | PZP03286.1 | 43771 | g11825 | i0 | 45.6 | 0.985401459854015 | 90 | 45 | 98.5 | 1 | 4 | 273 | 1265 | 1350 | PZP03286.1 MAG: hypothetical protein DI609_01185 [Corynebacterium urealyticum] | diamond | 270 | 87.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium urealyticum | ||
| 26954254 | 26954254 | PRJNA637328_P_NODE_14022_length_263_cov_17.939252_g13545_i0 | PRJNA637328 | 14022 | 263 | 17.939252 | 47.18023276 | Microbispora sp. NPDC | 1898321 | Bacteria | Bacteria | 42.7 | 0.0425 | NR | WP_367743503.1 | 3154929 | g13545 | i0 | 46 | 0.570342205323194 | 50 | 23 | 53.6 | 2 | 44 | 184 | 193 | 241 | WP_367743503.1 cellulose binding domain-containing protein, partial [Microbispora sp. NPDC049125] | diamond | 150 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Microbispora | Microbispora sp. NPDC049125 | ||
| 27270599 | 27270599 | PRJNA637328_P_NODE_20043_length_233_cov_12.331522_g19566_i0 | PRJNA637328 | 20043 | 233 | 12.331522 | 28.73244626 | Virgisporangium ochraceum | 65505 | Bacteria | Bacteria | 42.7 | 0.0333 | NR | WP_203930126.1 | 65505 | g19566 | i0 | 38.9 | 0.695278969957081 | 54 | 30 | 69.5 | 1 | 30 | 191 | 411 | 461 | WP_203930126.1 ATP-binding protein [Virgisporangium ochraceum] | diamond | 162 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Virgisporangium | Virgisporangium ochraceum | ||
| 27491861 | 27491861 | PRJNA637328_P_NODE_19063_length_241_cov_2.869792_g18586_i0 | PRJNA637328 | 19063 | 241 | 2.869792 | 6.91619872 | Actinokineospora globicatena | 103729 | Bacteria | Bacteria | 40.4 | 0.0491 | NR | GLW80975.1 | 103729 | g18586 | i0 | 40.4 | 0.5850622406639 | 47 | 28 | 58.5 | 0 | 101 | 241 | 15 | 61 | GLW80975.1 hypothetical protein Aglo01_54560 [Actinokineospora globicatena] | diamond | 141 | 40.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinokineospora | Actinokineospora globicatena | ||
| 27504468 | 27504468 | PRJNA637328_P_NODE_19523_length_237_cov_5.111702_g19046_i0 | PRJNA637328 | 19523 | 237 | 5.111702 | 12.11473374 | root | 1 | Root_unresolved | Root_unresolved | 88.6 | 9.2e-20 | NR | WP_416587093.1 | 2047 | g19046 | i0 | 57.5 | 3.64556962025316 | 73 | 31 | 92.4 | 0 | 237 | 19 | 53 | 125 | WP_416587093.1 hypothetical protein [Rothia dentocariosa] | diamond | 864 | 89.4 | 0.991051454138702 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Rothia | Rothia dentocariosa | ||
| 27586589 | 27586589 | PRJNA637328_P_NODE_22084_length_206_cov_4.885350_g21607_i0 | PRJNA637328 | 22084 | 206 | 4.88535 | 10.063821 | Kytococcus aerolatus | 592308 | Bacteria | Bacteria | 114 | 8.28e-28 | NR | WP_234994269.1 | 592308 | g21607 | i0 | 100 | 0.844660194174757 | 58 | 0 | 84.5 | 0 | 205 | 32 | 457 | 514 | WP_234994269.1 potassium/proton antiporter [Kytococcus aerolatus] | diamond | 174 | 114 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Kytococcaceae | Kytococcus | Kytococcus aerolatus | ||
| 27630714 | 27630714 | PRJNA637328_P_NODE_22104_length_205_cov_12.455128_g21627_i0 | PRJNA637328 | 22104 | 205 | 12.455128 | 25.5330124 | Saccharothrix | 2071 | Bacteria | Bacteria | 42.7 | 0.0233 | NR | GAA3458570.1 | 33920 | g21627 | i0 | 44.9 | 1.82926829268293 | 49 | 26 | 70.2 | 1 | 29 | 172 | 13 | 61 | GAA3458570.1 hypothetical protein GCM10018963_05830 [Saccharothrix longispora] | diamond | 375 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharothrix | Saccharothrix longispora | ||
| 28502213 | 28502213 | PRJNA637328_P_NODE_14367_length_262_cov_0.957746_g13890_i0 | PRJNA637328 | 14367 | 262 | 0.957746 | 2.50929452 | Coriobacteriia bacterium | 2052159 | Bacteria | Bacteria | 158 | 1.38e-45 | NR | MEA5075265.1 | 2052159 | g13890 | i0 | 94.3 | 0.99618320610687 | 87 | 5 | 99.6 | 0 | 2 | 262 | 27 | 113 | MEA5075265.1 cytochrome c biogenesis protein [Coriobacteriia bacterium] | diamond | 261 | 158 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriia bacterium | |||||
| 28754760 | 28754760 | PRJNA637328_P_NODE_21667_length_213_cov_5.079268_g21190_i0 | PRJNA637328 | 21667 | 213 | 5.079268 | 10.81884084 | Galactobacter valiniphilus | 2676122 | Bacteria | Bacteria | 42 | 0.0387 | NR | WP_119424843.1 | 2676122 | g21190 | i0 | 37 | 0.647887323943662 | 46 | 29 | 64.8 | 0 | 197 | 60 | 37 | 82 | WP_119424843.1 DedA family protein [Galactobacter valiniphilus] | diamond | 138 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Galactobacter | Galactobacter valiniphilus | ||
| 28944504 | 28944504 | PRJNA637328_P_NODE_20068_length_233_cov_4.391304_g19591_i0 | PRJNA637328 | 20068 | 233 | 4.391304 | 10.23173832 | Actinomyces oris | 544580 | Bacteria | Bacteria | 153 | 3.85e-44 | NR | WP_314133524.1 | 544580 | g19591 | i0 | 97.4 | 0.991416309012876 | 77 | 2 | 99.1 | 0 | 3 | 233 | 188 | 264 | WP_314133524.1 hypothetical protein [Actinomyces oris] | diamond | 231 | 153 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Actinomyces | Actinomyces oris | ||
| 29102154 | 29102154 | PRJNA637328_P_NODE_18408_length_244_cov_1.046154_g17931_i0 | PRJNA637328 | 18408 | 244 | 1.046154 | 2.55261576 | Corynebacterium | 1716 | Bacteria | Bacteria | 174 | 1.66e-52 | NR | WP_230384195.1 | 1716 | g17931 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 243 | 1 | 27 | 107 | WP_230384195.1 MULTISPECIES: NAD(+) diphosphatase [Corynebacterium] | diamond | 243 | 174 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | |||
| 29417682 | 29417682 | PRJNA637328_P_NODE_10869_length_286_cov_2.320675_g10394_i0 | PRJNA637328 | 10869 | 286 | 2.320675 | 6.6371305 | Actinomyces timonensis | 1288391 | Bacteria | Bacteria | 63.5 | 2.81e-9 | NR | WP_154652411.1 | 1288391 | g10394 | i0 | 39.8 | 1.95104895104895 | 93 | 55 | 96.5 | 1 | 281 | 6 | 48 | 140 | WP_154652411.1 O-antigen ligase family protein [Actinomyces timonensis] | diamond | 558 | 63.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Actinomyces | Actinomyces timonensis | ||
| 30049210 | 30049210 | PRJNA637328_P_NODE_20771_length_228_cov_3.245810_g20294_i0 | PRJNA637328 | 20771 | 228 | 3.24581 | 7.4004468 | Brevibacterium sp. CFH 1 | 1701 | Bacteria | Bacteria | 45.1 | 0.0048 | NR | WP_152348748.1 | 2585207 | g20294 | i0 | 35.8 | 0.697368421052632 | 53 | 30 | 69.7 | 2 | 195 | 37 | 229 | 277 | WP_152348748.1 amidohydrolase [Brevibacterium sp. CFH 10365] | diamond | 159 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Brevibacteriaceae | Brevibacterium | Brevibacterium sp. CFH 10365 | ||
| 30725322 | 30725322 | PRJNA637328_P_NODE_21234_length_222_cov_5.710983_g20757_i0 | PRJNA637328 | 21234 | 222 | 5.710983 | 12.67838226 | Bacteria | 2 | Bacteria | Bacteria | 42.7 | 0.0272 | NR | MEO8108094.1 | 1883427 | g20757 | i0 | 30.5 | 1.47297297297297 | 59 | 41 | 79.7 | 0 | 13 | 189 | 20 | 78 | MEO8108094.1 DUF1206 domain-containing protein [Actinomycetes bacterium] | diamond | 327 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetes bacterium | |||||
| 30807738 | 30807738 | PRJNA637328_P_NODE_19674_length_236_cov_3.978610_g19197_i0 | PRJNA637328 | 19674 | 236 | 3.97861 | 9.3895196 | Streptomyces varsoviensis | 67373 | Bacteria | Bacteria | 42.4 | 0.0435 | NR | WP_362164206.1 | 67373 | g19197 | i0 | 41.9 | 0.788135593220339 | 62 | 28 | 68.6 | 4 | 60 | 221 | 14 | 75 | WP_362164206.1 hypothetical protein [Streptomyces varsoviensis] | diamond | 186 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces varsoviensis | ||
| 31629668 | 31629668 | PRJNA637328_P_NODE_20336_length_231_cov_4.686813_g19859_i0 | PRJNA637328 | 20336 | 231 | 4.686813 | 10.82653803 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 92 | 2.46e-20 | NR | MDT5365635.1 | 1785 | g19859 | i0 | 49.4 | 1 | 77 | 39 | 100 | 0 | 231 | 1 | 24 | 100 | MDT5365635.1 hypothetical protein [Mycobacterium sp.] | diamond | 231 | 92 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 31819323 | 31819323 | PRJNA637328_P_NODE_17737_length_246_cov_9.081218_g17260_i0 | PRJNA637328 | 17737 | 246 | 9.081218 | 22.33979628 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 40.4 | 0.0353 | NR | MEI6497093.1 | 2900548 | g17260 | i0 | 40.4 | 0.634146341463415 | 52 | 31 | 63.4 | 0 | 58 | 213 | 3 | 54 | MEI6497093.1 DUF2510 domain-containing protein [Actinomycetota bacterium] | diamond | 156 | 40.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 32452478 | 32452478 | PRJNA637328_P_NODE_14899_length_259_cov_1.761905_g14422_i0 | PRJNA637328 | 14899 | 259 | 1.761905 | 4.56333395 | Streptomyces sp. NBC_ | 1931 | Bacteria | Bacteria | 43.5 | 0.00951 | NR | WP_371677181.1 | 2903808 | g14422 | i0 | 30.3 | 0.88030888030888 | 76 | 49 | 86.9 | 2 | 29 | 253 | 52 | 124 | WP_371677181.1 hypothetical protein [Streptomyces sp. NBC_01276] | diamond | 228 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NBC_01276 |
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);;