contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA753112" and tax_kingdom = "Bacillati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8854709 | 8854709 | PRJNA753112_P_NODE_33307_length_243_cov_0.917647_g32965_i0 | PRJNA753112 | 33307 | 243 | 0.917647 | 2.22988221 | Nocardioides jiangsuensis | 2866161 | Bacteria | Bacteria | 122 | 1.98e-30 | NR | WP_221026628.1 | 2866161 | g32965 | i0 | 86.1 | 0.975308641975309 | 79 | 11 | 97.5 | 0 | 238 | 2 | 289 | 367 | WP_221026628.1 potassium-transporting ATPase subunit KdpA [Nocardioides jiangsuensis] | diamond | 237 | 122 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides jiangsuensis | ||
| 18580800 | 18580800 | PRJNA753112_P_NODE_24775_length_274_cov_1.184080_g24433_i0 | PRJNA753112 | 24775 | 274 | 1.18408 | 3.2443792 | root | 1 | Root_unresolved | Root_unresolved | 72.8 | 9.77e-13 | NR | BAS27306.1 | 1555112 | g24433 | i0 | 48.3 | 1.88321167883212 | 87 | 43 | 94.2 | 2 | 17 | 274 | 218 | 303 | BAS27306.1 hypothetical protein LIP_1457 [Limnochorda pilosa] | diamond | 516 | 72.8 | 1 | Bacteria | Bacillati | Bacillota | Limnochordia | Limnochordales | Limnochordaceae | Limnochorda | Limnochorda pilosa | ||
| 24955709 | 24955709 | PRJNA753112_P_NODE_32340_length_245_cov_0.906977_g31998_i0 | PRJNA753112 | 32340 | 245 | 0.906977 | 2.22209365 | Microbacterium ginsengisoli | 400772 | Bacteria | Bacteria | 166 | 2.58e-48 | NR | WP_045247539.1 | 400772 | g31998 | i0 | 97.5 | 0.979591836734694 | 80 | 2 | 98 | 0 | 240 | 1 | 216 | 295 | WP_045247539.1 Rv2578c family radical SAM protein [Microbacterium ginsengisoli] | diamond | 240 | 166 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium ginsengisoli | ||
| 26704486 | 26704486 | PRJNA753112_P_NODE_28941_length_253_cov_0.866667_g28599_i0 | PRJNA753112 | 28941 | 253 | 0.866667 | 2.19266751 | Nocardia sp. alder85J | 2862949 | Bacteria | Bacteria | 49.7 | 1.43e-4 | NR | WP_323138010.1 | 2862949 | g28599 | i0 | 40.2 | 1.94466403162055 | 82 | 39 | 96 | 3 | 10 | 252 | 219 | 291 | WP_323138010.1 metal-dependent hydrolase [Nocardia sp. alder85J] | diamond | 492 | 49.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Nocardia | Nocardia sp. alder85J | ||
| 26873217 | 26873217 | PRJNA753112_P_NODE_21201_length_295_cov_1.405405_g20859_i0 | PRJNA753112 | 21201 | 295 | 1.405405 | 4.14594475 | Bacteria | 2 | Bacteria | Bacteria | 105 | 1.49e-24 | NR | MDA0233251.1 | 2026724 | g20859 | i0 | 60.5 | 2.48135593220339 | 81 | 31 | 81.4 | 1 | 48 | 287 | 1 | 81 | MDA0233251.1 ISL3 family transposase [Chloroflexota bacterium] | diamond | 732 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27084552 | 27084552 | PRJNA753112_P_NODE_29302_length_252_cov_0.871508_g28960_i0 | PRJNA753112 | 29302 | 252 | 0.871508 | 2.19620016 | Bacilli bacterium | 1903720 | Bacteria | Bacteria | 66.6 | 1.57e-10 | NR | MEG0407679.1 | 1903720 | g28960 | i0 | 53 | 0.785714285714286 | 66 | 30 | 78.6 | 1 | 53 | 250 | 144 | 208 | MEG0407679.1 hypothetical protein [Bacilli bacterium] | diamond | 198 | 66.6 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacilli bacterium | |||||
| 27337478 | 27337478 | PRJNA753112_P_NODE_29923_length_250_cov_1.514124_g29581_i0 | PRJNA753112 | 29923 | 250 | 1.514124 | 3.78531 | Nocardioides aquiterrae | 203799 | Bacteria | Bacteria | 58.2 | 8.81e-8 | NR | GAA1164235.1 | 203799 | g29581 | i0 | 58.1 | 0.744 | 62 | 25 | 73.2 | 1 | 31 | 213 | 31 | 92 | GAA1164235.1 hypothetical protein GCM10009606_47390 [Nocardioides aquiterrae] | diamond | 186 | 58.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides aquiterrae | ||
| 27400675 | 27400675 | PRJNA753112_P_NODE_31683_length_246_cov_1.317919_g31341_i0 | PRJNA753112 | 31683 | 246 | 1.317919 | 3.24208074 | Streptomyces tendae | 1932 | Bacteria | Bacteria | 44.7 | 0.00811 | NR | MFJ3044153.1 | 1932 | g31341 | i0 | 59.5 | 0.451219512195122 | 37 | 13 | 45.1 | 1 | 131 | 241 | 714 | 748 | MFJ3044153.1 hypothetical protein [Streptomyces tendae] | diamond | 111 | 44.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces tendae | ||
| 27558222 | 27558222 | PRJNA753112_P_NODE_8084_length_480_cov_2.732187_g7742_i0 | PRJNA753112 | 8084 | 480 | 2.732187 | 13.1144976 | Curtobacterium sp. ER1/6 | 1891920 | Bacteria | Bacteria | 45.1 | 0.0496 | NR | OEI69057.1 | 1891920 | g7742 | i0 | 33.3 | 0.9375 | 150 | 88 | 89.4 | 3 | 17 | 445 | 36 | 180 | OEI69057.1 hypothetical protein Cus16_0887 [Curtobacterium sp. ER1/6] | diamond | 450 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Curtobacterium | Curtobacterium sp. ER1/6 | ||
| 27621707 | 27621707 | PRJNA753112_P_NODE_13724_length_367_cov_1.054422_g13382_i0 | PRJNA753112 | 13724 | 367 | 1.054422 | 3.8697287399999998 | Oscillospiraceae bacterium | 2485925 | Bacteria | Bacteria | 46.2 | 0.00865 | NR | MBE6951160.1 | 2485925 | g13382 | i0 | 32.9 | 0.596730245231608 | 73 | 48 | 59.7 | 1 | 327 | 109 | 17 | 88 | MBE6951160.1 hypothetical protein [Oscillospiraceae bacterium] | diamond | 219 | 46.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 28032132 | 28032132 | PRJNA753112_P_NODE_24765_length_274_cov_1.363184_g24423_i0 | PRJNA753112 | 24765 | 274 | 1.363184 | 3.73512416 | Micromonospora aurantiaca | 47850 | Bacteria | Bacteria | 45.1 | 0.0056 | NR | WP_162881542.1 | 47850 | g24423 | i0 | 38.2 | 1.80656934306569 | 55 | 32 | 58 | 1 | 36 | 194 | 144 | 198 | WP_162881542.1 DUF4352 domain-containing protein [Micromonospora aurantiaca] | diamond | 495 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora aurantiaca (nom. illeg.) | ||
| 28032133 | 28032133 | PRJNA753112_P_NODE_27565_length_259_cov_1.268817_g27223_i0 | PRJNA753112 | 27565 | 259 | 1.268817 | 3.28623603 | Saccharothrix variisporea | 543527 | Bacteria | Bacteria | 43.5 | 0.025 | NR | WP_246029499.1 | 543527 | g27223 | i0 | 40 | 0.694980694980695 | 60 | 32 | 64.9 | 2 | 92 | 259 | 884 | 943 | WP_246029499.1 hypothetical protein [Saccharothrix variisporea] | diamond | 180 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharothrix | Saccharothrix variisporea | ||
| 28568711 | 28568711 | PRJNA753112_P_NODE_19207_length_310_cov_1.468354_g18865_i0 | PRJNA753112 | 19207 | 310 | 1.468354 | 4.5518974 | Firmicutes bacterium ADurb.Bin193 | 1852885 | Bacteria | Bacteria | 48.9 | 4.62e-4 | NR | OQB13730.1 | 1852885 | g18865 | i0 | 54.3 | 0.338709677419355 | 35 | 16 | 33.9 | 0 | 7 | 111 | 181 | 215 | OQB13730.1 MAG: KWG Leptospira [Firmicutes bacterium ADurb.Bin193] | diamond | 105 | 48.9 | 1 | Bacteria | Bacillati | Bacillota | Firmicutes bacterium ADurb.Bin193 | ||||||
| 29620126 | 29620126 | PRJNA753112_P_NODE_15470_length_345_cov_1.812500_g15128_i0 | PRJNA753112 | 15470 | 345 | 1.8125 | 6.253125 | Bacteria | 2 | Bacteria | Bacteria | 55.5 | 3.27e-6 | NR | MCH7738147.1 | 2026724 | g15128 | i0 | 38 | 2.74782608695652 | 79 | 45 | 65.2 | 2 | 226 | 2 | 6 | 84 | MCH7738147.1 ImmA/IrrE family metallo-endopeptidase [Chloroflexota bacterium] | diamond | 948 | 55.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30179148 | 30179148 | PRJNA753112_P_NODE_31632_length_246_cov_1.560694_g31290_i0 | PRJNA753112 | 31632 | 246 | 1.560694 | 3.83930724 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 43.9 | 0.00769 | NR | MCL4250160.1 | 2052143 | g31290 | i0 | 65.5 | 0.719512195121951 | 29 | 10 | 35.4 | 0 | 242 | 156 | 129 | 157 | MCL4250160.1 aspartate ammonia-lyase [Anaerolineae bacterium] | diamond | 177 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30337707 | 30337707 | PRJNA753112_P_NODE_27152_length_261_cov_1.404255_g26810_i0 | PRJNA753112 | 27152 | 261 | 1.404255 | 3.66510555 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 46.2 | 0.00274 | NR | MBN1178039.1 | 2052143 | g26810 | i0 | 43.5 | 0.528735632183908 | 46 | 26 | 52.9 | 0 | 61 | 198 | 336 | 381 | MBN1178039.1 glycosyltransferase family 2 protein [Anaerolineae bacterium] | diamond | 138 | 46.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30432441 | 30432441 | PRJNA753112_P_NODE_27313_length_260_cov_1.668449_g26971_i0 | PRJNA753112 | 27313 | 260 | 1.668449 | 4.3379674 | Tissierellales bacterium | 2053631 | Bacteria | Bacteria | 46.2 | 0.00266 | NR | MCT4662835.1 | 2053631 | g26971 | i0 | 42.9 | 0.646153846153846 | 56 | 31 | 64.6 | 1 | 6 | 173 | 64 | 118 | MCT4662835.1 ATPase, T2SS/T4P/T4SS family [Tissierellales bacterium] | diamond | 168 | 46.2 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Tissierellales bacterium | ||||
| 30589916 | 30589916 | PRJNA753112_P_NODE_11693_length_397_cov_2.842593_g11351_i0 | PRJNA753112 | 11693 | 397 | 2.842593 | 11.28509421 | Mycolicibacterium brumae | 85968 | Bacteria | Bacteria | 49.3 | 0.00106 | NR | WP_090587324.1 | 85968 | g11351 | i0 | 33 | 0.755667506297229 | 100 | 62 | 74.8 | 3 | 327 | 31 | 809 | 904 | WP_090587324.1 arabinosyltransferase domain-containing protein [Mycolicibacterium brumae] | diamond | 300 | 49.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium brumae | ||
| 30748033 | 30748033 | PRJNA753112_P_NODE_8034_length_482_cov_1.427873_g7692_i0 | PRJNA753112 | 8034 | 482 | 1.427873 | 6.88234786 | Coleofasciculus chthonoplastes | 64178 | Bacteria | Bacteria | 97.1 | 2.9e-20 | NR | WP_044204156.1 | 64178 | g7692 | i0 | 61 | 6.04979253112033 | 77 | 27 | 46.1 | 1 | 261 | 482 | 6 | 82 | WP_044204156.1 GTP cyclohydrolase II [Coleofasciculus chthonoplastes] | diamond | 2916 | 97.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Coleofasciculales | Coleofasciculaceae | Coleofasciculus | Coleofasciculus chthonoplastes | |
| 31538417 | 31538417 | PRJNA753112_P_NODE_28756_length_253_cov_0.866667_g28414_i0 | PRJNA753112 | 28756 | 253 | 0.866667 | 2.19266751 | Streptomyces sp. MBT84 | 1488414 | Bacteria | Bacteria | 42.7 | 0.0417 | NR | MBW8705193.1 | 1488414 | g28414 | i0 | 40.3 | 0.735177865612648 | 62 | 34 | 73.5 | 1 | 66 | 251 | 704 | 762 | MBW8705193.1 Cyclic di-GMP phosphodiesterase Gmr [Streptomyces sp. MBT84] | diamond | 186 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. MBT84 | ||
| 32329498 | 32329498 | PRJNA753112_P_NODE_9059_length_452_cov_1.387863_g8717_i0 | PRJNA753112 | 9059 | 452 | 1.387863 | 6.27314076 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 55.8 | 7.82e-6 | NR | WP_395142005.1 | 1872638 | g8717 | i0 | 28.3 | 1.80530973451327 | 145 | 86 | 96.2 | 4 | 12 | 446 | 62 | 188 | WP_395142005.1 TIGR02221 family CRISPR-associated protein [Armatimonas sp.] | diamond | 816 | 55.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 32592123 | 32592123 | PRJNA753112_P_NODE_17539_length_324_cov_1.657371_g17197_i0 | PRJNA753112 | 17539 | 324 | 1.657371 | 5.36988204 | Streptomyces | 1883 | Bacteria | Bacteria | 56.2 | 1.62e-6 | NR | WP_016643678.1 | 47760 | g17197 | i0 | 52.5 | 4.69444444444444 | 61 | 23 | 50.9 | 2 | 322 | 158 | 138 | 198 | WP_016643678.1 Kelch repeat-containing protein [Streptomyces aurantiacus] | diamond | 1521 | 56.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces aurantiacus | ||
| 32592124 | 32592124 | PRJNA753112_P_NODE_21839_length_291_cov_1.275229_g21497_i0 | PRJNA753112 | 21839 | 291 | 1.275229 | 3.71091639 | FCB group | 1783270 | Bacteria | Bacteria | 157 | 5.03e-46 | NR | HZO25256.1 | 2026724 | g21497 | i0 | 69.8 | 21.7525773195876 | 96 | 29 | 99 | 0 | 3 | 290 | 3 | 98 | HZO25256.1 inorganic pyrophosphatase [Chloroflexota bacterium] | diamond | 6330 | 158 | 0.993670886075949 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32644858 | 32644858 | PRJNA753112_P_NODE_26380_length_265_cov_1.625000_g26038_i0 | PRJNA753112 | 26380 | 265 | 1.625 | 4.30625 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 77.4 | 3.06e-14 | NR | HLN17668.1 | 2201156 | g26038 | i0 | 68.6 | 2.11698113207547 | 51 | 16 | 57.7 | 0 | 264 | 112 | 520 | 570 | HLN17668.1 amidohydrolase family protein [Acidimicrobiales bacterium] | diamond | 561 | 77.4 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 32718003 | 32718003 | PRJNA753112_P_NODE_34560_length_231_cov_2.936709_g34218_i0 | PRJNA753112 | 34560 | 231 | 2.936709 | 6.78379779 | Gudongella | 2692382 | Bacteria | Bacteria | 81.6 | 2.69e-16 | NR | MCR3955806.1 | 2692384 | g34218 | i0 | 52.1 | 2.81818181818182 | 73 | 35 | 94.8 | 0 | 222 | 4 | 192 | 264 | MCR3955806.1 lysophospholipase [Gudongella sp.] | diamond | 651 | 82 | 0.995121951219512 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Tissierellaceae | Gudongella | Gudongella 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);;