contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA934332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1255413 | 1255413 | PRJNA934332_P_NODE_10841_length_242_cov_0.911243_g10754_i0 | PRJNA934332 | 10841 | 242 | 0.911243 | 2.20520806 | Mycolicibacterium | 1866885 | Bacteria | Bacteria | 129 | 1.63e-33 | NR | KLI04824.1 | 1796 | g10754 | i0 | 100 | 1.61157024793388 | 65 | 0 | 80.6 | 0 | 241 | 47 | 395 | 459 | KLI04824.1 hypothetical protein AA982_28030 [Mycolicibacterium senegalense] | diamond | 390 | 129 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium senegalense | ||
| 19106823 | 19106823 | PRJNA934332_P_NODE_6275_length_272_cov_2.035176_g6188_i0 | PRJNA934332 | 6275 | 272 | 2.035176 | 5.53567872 | Rubrobacter | 42255 | Bacteria | Bacteria | 112 | 3.02e-28 | NR | WP_166180504.1 | 2653851 | g6188 | i0 | 72.4 | 2.51470588235294 | 76 | 20 | 83.8 | 1 | 271 | 44 | 197 | 271 | WP_166180504.1 MOSC domain-containing protein [Rubrobacter tropicus] | diamond | 684 | 113 | 0.991150442477876 | Bacteria | Bacillati | Actinomycetota | Rubrobacteria | Rubrobacterales | Rubrobacteraceae | Rubrobacter | Rubrobacter tropicus | ||
| 22587590 | 22587590 | PRJNA934332_P_NODE_4378_length_315_cov_1.161157_g4291_i0 | PRJNA934332 | 4378 | 315 | 1.161157 | 3.65764455 | Propionibacteriaceae bacterium | 2021380 | Bacteria | Bacteria | 169 | 9.69e-52 | NR | MCP3885490.1 | 2021380 | g4291 | i0 | 76 | 0.990476190476191 | 104 | 25 | 99 | 0 | 314 | 3 | 4 | 107 | MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] | diamond | 312 | 169 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Propionibacteriaceae bacterium | |||
| 26613258 | 26613258 | PRJNA934332_P_NODE_10101_length_244_cov_0.900585_g10014_i0 | PRJNA934332 | 10101 | 244 | 0.900585 | 2.1974274 | unclassified Mycolicibacterium | 2636767 | Bacteria | Bacteria | 137 | 6.779999999999999e-37 | NR | WP_155909834.1 | 2636767 | g10014 | i0 | 85 | 0.983606557377049 | 80 | 12 | 98.4 | 0 | 3 | 242 | 235 | 314 | WP_155909834.1 MULTISPECIES: DUF1173 family protein [unclassified Mycolicibacterium] | diamond | 240 | 137 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | |||
| 26620416 | 26620416 | PRJNA934332_P_NODE_4741_length_304_cov_0.865801_g4654_i0 | PRJNA934332 | 4741 | 304 | 0.865801 | 2.63203504 | Bacteria | 2 | Bacteria | Bacteria | 43.5 | 0.0417 | NR | WP_083362910.1 | 412690 | g4654 | i0 | 29.5 | 1.72697368421053 | 88 | 56 | 81.9 | 3 | 6 | 254 | 981 | 1067 | WP_083362910.1 DUF4082 domain-containing protein [Microterricola viridarii] | diamond | 525 | 43.9 | 0.990888382687927 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microterricola | Microterricola viridarii | ||
| 26676441 | 26676441 | PRJNA934332_P_NODE_8461_length_249_cov_0.875000_g8374_i0 | PRJNA934332 | 8461 | 249 | 0.875 | 2.17875 | Nocardia sp. BSTN | 1821 | Bacteria | Bacteria | 56.6 | 4.41e-7 | NR | WP_194807579.1 | 2783665 | g8374 | i0 | 57.1 | 0.674698795180723 | 56 | 23 | 67.5 | 1 | 77 | 244 | 1 | 55 | WP_194807579.1 nuclear transport factor 2 family protein [Nocardia sp. BSTN01] | diamond | 168 | 56.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Nocardia | Nocardia sp. BSTN01 | ||
| 26993064 | 26993064 | PRJNA934332_P_NODE_7462_length_251_cov_1.382022_g7375_i0 | PRJNA934332 | 7462 | 251 | 1.382022 | 3.46887522 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 174 | 6.64e-53 | NR | MBI3215368.1 | 1785 | g7375 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 2 | 250 | 32 | 114 | MBI3215368.1 hypothetical protein [Mycobacterium sp.] | diamond | 249 | 174 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 27246195 | 27246195 | PRJNA934332_P_NODE_9623_length_245_cov_2.087209_g9536_i0 | PRJNA934332 | 9623 | 245 | 2.087209 | 5.11366205 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 40.8 | 0.0311 | NR | WP_366701689.1 | 3154622 | g9536 | i0 | 41.4 | 0.710204081632653 | 58 | 27 | 68.6 | 3 | 241 | 74 | 1 | 53 | WP_366701689.1 hypothetical protein [Streptomyces sp. NPDC048389] | diamond | 174 | 40.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC048389 | ||
| 27625399 | 27625399 | PRJNA934332_P_NODE_10664_length_243_cov_0.894118_g10577_i0 | PRJNA934332 | 10664 | 243 | 0.894118 | 2.17270674 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 161 | 1.44e-45 | NR | HEX6579508.1 | 2900548 | g10577 | i0 | 88.9 | 4 | 81 | 9 | 100 | 0 | 243 | 1 | 235 | 315 | HEX6579508.1 multicopper oxidase domain-containing protein [Actinomycetota bacterium] | diamond | 972 | 161 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 27941079 | 27941079 | PRJNA934332_P_NODE_4985_length_297_cov_1.031250_g4898_i0 | PRJNA934332 | 4985 | 297 | 1.03125 | 3.0628125 | Actinomadura sp. NBRC 1 | 1989 | Bacteria | Bacteria | 41.2 | 0.0386 | NR | GLZ08927.1 | 3032203 | g4898 | i0 | 53.3 | 0.303030303030303 | 30 | 14 | 30.3 | 0 | 30 | 119 | 46 | 75 | GLZ08927.1 hypothetical protein Acsp03_63930 [Actinomadura sp. NBRC 104412] | diamond | 90 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Thermomonosporaceae | Actinomadura | Actinomadura sp. NBRC 104412 | ||
| 28509361 | 28509361 | PRJNA934332_P_NODE_8247_length_249_cov_0.875000_g8160_i0 | PRJNA934332 | 8247 | 249 | 0.875 | 2.17875 | Kocuria sp. CPCC 2 | 1871328 | Bacteria | Bacteria | 40 | 0.0468 | NR | WP_387919956.1 | 3058904 | g8160 | i0 | 40 | 0.481927710843373 | 40 | 24 | 48.2 | 0 | 81 | 200 | 2 | 41 | WP_387919956.1 hypothetical protein [Kocuria sp. CPCC 205300] | diamond | 120 | 40 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Kocuria | Kocuria sp. CPCC 205300 | ||
| 28800291 | 28800291 | PRJNA934332_P_NODE_5347_length_289_cov_0.814815_g5260_i0 | PRJNA934332 | 5347 | 289 | 0.814815 | 2.35481535 | FCB group | 1783270 | Bacteria | Bacteria | 49.7 | 2.25e-4 | NR | HXX91425.1 | 2201156 | g5260 | i0 | 40.4 | 2.88581314878893 | 94 | 51 | 96.5 | 3 | 279 | 1 | 270 | 359 | HXX91425.1 glycosyltransferase family 61 protein [Acidimicrobiales bacterium] | diamond | 834 | 50.1 | 0.992015968063872 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 29109388 | 29109388 | PRJNA934332_P_NODE_8248_length_249_cov_0.875000_g8161_i0 | PRJNA934332 | 8248 | 249 | 0.875 | 2.17875 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 59.3 | 5.31e-8 | NR | HEV7885180.1 | 2586742 | g8161 | i0 | 39 | 3.49397590361446 | 77 | 47 | 92.8 | 0 | 246 | 16 | 233 | 309 | HEV7885180.1 hypothetical protein [Solirubrobacteraceae bacterium] | diamond | 870 | 59.3 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 29684283 | 29684283 | PRJNA934332_P_NODE_7470_length_251_cov_1.297753_g7383_i0 | PRJNA934332 | 7470 | 251 | 1.297753 | 3.25736003 | Bacteria | 2 | Bacteria | Bacteria | 99 | 5.51e-23 | NR | MCU1457491.1 | 1883427 | g7383 | i0 | 53.8 | 7.80478087649402 | 80 | 37 | 95.6 | 0 | 2 | 241 | 74 | 153 | MCU1457491.1 Aromatic ring-opening dioxygenase, catalytic subunit, LigB family [Actinomycetes bacterium] | diamond | 1959 | 99 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetes bacterium | |||||
| 29803770 | 29803770 | PRJNA934332_P_NODE_5871_length_279_cov_1.495146_g5784_i0 | PRJNA934332 | 5871 | 279 | 1.495146 | 4.17145734 | Pseudonocardiaceae bacterium | 1873463 | Bacteria | Bacteria | 94.7 | 2.66e-20 | NR | HEX3649601.1 | 1873463 | g5784 | i0 | 74.6 | 3.1505376344086 | 67 | 17 | 72 | 0 | 279 | 79 | 399 | 465 | HEX3649601.1 glycerol kinase GlpK [Pseudonocardiaceae bacterium] | diamond | 879 | 94.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Pseudonocardiaceae bacterium | |||
| 29930389 | 29930389 | PRJNA934332_P_NODE_10731_length_242_cov_0.911243_g10644_i0 | PRJNA934332 | 10731 | 242 | 0.911243 | 2.20520806 | uncultured Williamsia sp. | 259311 | Bacteria | Bacteria | 103 | 7.66e-26 | NR | WP_299570209.1 | 259311 | g10644 | i0 | 92.2 | 0.632231404958678 | 51 | 4 | 63.2 | 0 | 241 | 89 | 135 | 185 | WP_299570209.1 dTDP-4-dehydrorhamnose 3,5-epimerase [uncultured Williamsia sp.] | diamond | 153 | 103 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Williamsia | uncultured Williamsia sp. | ||
| 30341469 | 30341469 | PRJNA934332_P_NODE_3312_length_352_cov_1.103943_g3225_i0 | PRJNA934332 | 3312 | 352 | 1.103943 | 3.88587936 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 133 | 5.41e-34 | NR | MBS1889662.1 | 2900548 | g3225 | i0 | 53.4 | 1.00568181818182 | 118 | 54 | 99.7 | 1 | 2 | 352 | 119 | 236 | MBS1889662.1 ubiquitin-conjugating enzyme E2 [Actinomycetota bacterium] | diamond | 354 | 133 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30783263 | 30783263 | PRJNA934332_P_NODE_4694_length_305_cov_1.327586_g4607_i0 | PRJNA934332 | 4694 | 305 | 1.327586 | 4.0491373 | Acidimicrobiaceae bacterium | 2024894 | Bacteria | Bacteria | 59.7 | 8.47e-9 | NR | MCY3650208.1 | 2024894 | g4607 | i0 | 52.4 | 0.413114754098361 | 42 | 20 | 41.3 | 0 | 295 | 170 | 2 | 43 | MCY3650208.1 RCC1 domain-containing protein [Acidimicrobiaceae bacterium] | diamond | 126 | 59.7 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiaceae | Acidimicrobiaceae bacterium | |||
| 31099083 | 31099083 | PRJNA934332_P_NODE_10075_length_244_cov_0.900585_g9988_i0 | PRJNA934332 | 10075 | 244 | 0.900585 | 2.1974274 | Longivirga aurantiaca | 1837743 | Bacteria | Bacteria | 94.4 | 6.550000000000001e-21 | NR | WP_386765817.1 | 1837743 | g9988 | i0 | 57 | 0.971311475409836 | 79 | 34 | 97.1 | 0 | 3 | 239 | 111 | 189 | WP_386765817.1 GGDEF domain-containing protein [Longivirga aurantiaca] | diamond | 237 | 94.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Sporichthyales | Sporichthyaceae | Longivirga | Longivirga aurantiaca | ||
| 31510451 | 31510451 | PRJNA934332_P_NODE_10796_length_242_cov_0.911243_g10709_i0 | PRJNA934332 | 10796 | 242 | 0.911243 | 2.20520806 | Streptomyces sp. CHB9.2 | 2841670 | Bacteria | Bacteria | 120 | 5.46e-30 | NR | WP_252941086.1 | 2841670 | g10709 | i0 | 71.3 | 0.991735537190083 | 80 | 22 | 97.9 | 1 | 238 | 2 | 147 | 226 | WP_252941086.1 hypothetical protein [Streptomyces sp. CHB9.2] | diamond | 240 | 120 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. CHB9.2 | ||
| 31858130 | 31858130 | PRJNA934332_P_NODE_6857_length_262_cov_1.470899_g6770_i0 | PRJNA934332 | 6857 | 262 | 1.470899 | 3.85375538 | Amycolatopsis iheyensis | 2945988 | Bacteria | Bacteria | 46.6 | 0.0018600000000000001 | NR | WP_257925344.1 | 2945988 | g6770 | i0 | 35.4 | 2.72519083969466 | 79 | 44 | 82.4 | 2 | 223 | 8 | 20 | 98 | WP_257925344.1 TylF/MycF family methyltransferase [Amycolatopsis iheyensis] | diamond | 714 | 46.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Amycolatopsis | Amycolatopsis iheyensis | ||
| 32079660 | 32079660 | PRJNA934332_P_NODE_5758_length_281_cov_1.480769_g5671_i0 | PRJNA934332 | 5758 | 281 | 1.480769 | 4.16096089 | Jatrophihabitans endophyticus | 1206085 | Bacteria | Bacteria | 48.9 | 3.86e-4 | NR | WP_304050341.1 | 1206085 | g5671 | i0 | 41.3 | 5.61565836298932 | 92 | 48 | 96.1 | 3 | 274 | 5 | 67 | 154 | WP_304050341.1 sugar porter family MFS transporter [Jatrophihabitans endophyticus] | diamond | 1578 | 48.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Jatrophihabitantales | Jatrophihabitantaceae | Jatrophihabitans | Jatrophihabitans endophyticus |
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);;