contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1195551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26851161 | 26851161 | PRJNA1195551_S_NODE_12381_length_272_cov_5.479821_g12028_i0 | PRJNA1195551 | 12381 | 272 | 5.479821 | 14.90511312 | Jiangellaceae bacterium | 2768363 | Bacteria | Bacteria | 42.7 | 0.0372 | NR | HSI92738.1 | 2768363 | g12028 | i0 | 34.9 | 0.915441176470588 | 83 | 39 | 91.5 | 3 | 254 | 6 | 115 | 182 | HSI92738.1 DUF559 domain-containing protein [Jiangellaceae bacterium] | diamond | 249 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Jiangellales | Jiangellaceae | Jiangellaceae bacterium | |||
| 27420379 | 27420379 | PRJNA1195551_S_NODE_16363_length_244_cov_1.066667_g16010_i0 | PRJNA1195551 | 16363 | 244 | 1.066667 | 2.60266748 | Pedococcus sp. | 2860345 | Bacteria | Bacteria | 45.1 | 0.00563 | NR | HEY7718655.1 | 2860345 | g16010 | i0 | 35.4 | 1.00819672131148 | 82 | 40 | 94.7 | 3 | 3 | 233 | 203 | 276 | HEY7718655.1 acyltransferase family protein [Pedococcus sp.] | diamond | 246 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Pedococcus | Pedococcus sp. | ||
| 27672859 | 27672859 | PRJNA1195551_S_NODE_20104_length_223_cov_2.586207_g19751_i0 | PRJNA1195551 | 20104 | 223 | 2.586207 | 5.76724161 | Microbacterium | 33882 | Bacteria | Bacteria | 42.7 | 0.0212 | NR | WP_292768637.1 | 33882 | g19751 | i0 | 34.5 | 1.39910313901345 | 55 | 36 | 74 | 0 | 170 | 6 | 81 | 135 | WP_292768637.1 MULTISPECIES: biotin transporter BioY [Microbacterium] | diamond | 312 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | |||
| 28398902 | 28398902 | PRJNA1195551_S_NODE_23766_length_207_cov_1.037975_g23413_i0 | PRJNA1195551 | 23766 | 207 | 1.037975 | 2.14860825 | uncultured Frankineae bacterium | 437475 | Bacteria | Bacteria | 114 | 1.37e-30 | NR | CAA9350750.1 | 437475 | g23413 | i0 | 83.6 | 0.971014492753623 | 67 | 11 | 97.1 | 0 | 205 | 5 | 81 | 147 | CAA9350750.1 MAG: NADH-ubiquinone oxidoreductase chain I [uncultured Frankineae bacterium] | diamond | 201 | 114 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Frankiales | uncultured Frankineae bacterium | ||||
| 28746204 | 28746204 | PRJNA1195551_S_NODE_35627_length_171_cov_1.278689_g35274_i0 | PRJNA1195551 | 35627 | 171 | 1.278689 | 2.18655819 | Kitasatospora kifunensis | 58351 | Bacteria | Bacteria | 43.1 | 0.00961 | NR | WP_184939329.1 | 58351 | g35274 | i0 | 41.4 | 1.01754385964912 | 58 | 23 | 87.7 | 2 | 6 | 155 | 166 | 220 | WP_184939329.1 polysaccharide deacetylase family protein [Kitasatospora kifunensis] | diamond | 174 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora kifunensis | ||
| 28809041 | 28809041 | PRJNA1195551_S_NODE_38988_length_165_cov_0.896552_g38635_i0 | PRJNA1195551 | 38988 | 165 | 0.896552 | 1.4793108 | Cutibacterium avidum | 33010 | Bacteria | Bacteria | 58.5 | 3.25e-8 | NR | MDU3568470.1 | 33010 | g38635 | i0 | 93.3 | 0.545454545454545 | 30 | 1 | 54.5 | 1 | 1 | 90 | 264 | 292 | MDU3568470.1 Na+/H+ antiporter NhaA [Cutibacterium avidum] | diamond | 90 | 58.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium avidum | ||
| 29030601 | 29030601 | PRJNA1195551_S_NODE_23928_length_206_cov_2.917197_g23575_i0 | PRJNA1195551 | 23928 | 206 | 2.917197 | 6.00942582 | Leucobacter komagatae | 55969 | Bacteria | Bacteria | 42.4 | 0.0318 | NR | WP_141888704.1 | 55969 | g23575 | i0 | 33.3 | 0.742718446601942 | 51 | 34 | 74.3 | 0 | 26 | 178 | 671 | 721 | WP_141888704.1 FtsX-like permease family protein [Leucobacter komagatae] | diamond | 153 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Leucobacter | Leucobacter komagatae | ||
| 29333508 | 29333508 | PRJNA1195551_S_NODE_10569_length_289_cov_3.262500_g10216_i0 | PRJNA1195551 | 10569 | 289 | 3.2625 | 9.428625 | root | 1 | Root_unresolved | Root_unresolved | 58.5 | 3.45e-8 | NR | MES9247268.1 | 1747 | g10216 | i0 | 38.4 | 13.3598615916955 | 99 | 54 | 95.5 | 2 | 277 | 2 | 22 | 120 | MES9247268.1 hypothetical protein [Cutibacterium acnes] | diamond | 3861 | 58.9 | 0.99320882852292 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 29693087 | 29693087 | PRJNA1195551_S_NODE_24890_length_202_cov_3.718954_g24537_i0 | PRJNA1195551 | 24890 | 202 | 3.718954 | 7.51228708 | Streptomyces spiralis | 66376 | Bacteria | Bacteria | 43.9 | 0.00775 | NR | WP_189902841.1 | 66376 | g24537 | i0 | 50 | 0.623762376237624 | 42 | 20 | 60.9 | 1 | 39 | 161 | 65 | 106 | WP_189902841.1 type II secretion system F family protein [Streptomyces spiralis] | diamond | 126 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces spiralis | ||
| 29819522 | 29819522 | PRJNA1195551_S_NODE_34271_length_174_cov_1.664000_g33918_i0 | PRJNA1195551 | 34271 | 174 | 1.664 | 2.89536 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 39.7 | 0.0485 | NR | MSY83325.1 | 2900548 | g33918 | i0 | 33.3 | 0.879310344827586 | 51 | 33 | 86.2 | 1 | 7 | 156 | 20 | 70 | MSY83325.1 hypothetical protein [Actinomycetota bacterium] | diamond | 153 | 39.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30009436 | 30009436 | PRJNA1195551_S_NODE_37051_length_168_cov_1.747899_g36698_i0 | PRJNA1195551 | 37051 | 168 | 1.747899 | 2.93647032 | Arthrobacter sp. EPSL27 | 1745378 | Bacteria | Bacteria | 41.2 | 0.0486 | NR | WP_066435757.1 | 1745378 | g36698 | i0 | 51.2 | 0.732142857142857 | 41 | 16 | 66.1 | 1 | 52 | 162 | 94 | 134 | WP_066435757.1 GNAT family N-acetyltransferase [Arthrobacter sp. EPSL27] | diamond | 123 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter sp. EPSL27 | ||
| 30103920 | 30103920 | PRJNA1195551_S_NODE_40232_length_163_cov_0.912281_g39879_i0 | PRJNA1195551 | 40232 | 163 | 0.912281 | 1.48701803 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 45.4 | 1.07e-4 | NR | MEA2380772.1 | 2586742 | g39879 | i0 | 58.3 | 0.662576687116564 | 36 | 15 | 66.3 | 0 | 49 | 156 | 4 | 39 | MEA2380772.1 hypothetical protein [Solirubrobacteraceae bacterium] | diamond | 108 | 45.4 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 30230410 | 30230410 | PRJNA1195551_S_NODE_42312_length_158_cov_2.385321_g41959_i0 | PRJNA1195551 | 42312 | 158 | 2.385321 | 3.76880718 | Candidatus Blastococcus massiliensis | 1470358 | Bacteria | Bacteria | 84.3 | 1.39e-17 | NR | WP_051515436.1 | 1470358 | g41959 | i0 | 75 | 1.9746835443038 | 52 | 13 | 98.7 | 0 | 156 | 1 | 287 | 338 | WP_051515436.1 hypothetical protein [Candidatus Blastococcus massiliensis] | diamond | 312 | 84.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Geodermatophilales | Geodermatophilaceae | Blastococcus | Candidatus Blastococcus massiliensis | ||
| 30546387 | 30546387 | PRJNA1195551_S_NODE_23513_length_208_cov_1.188679_g23160_i0 | PRJNA1195551 | 23513 | 208 | 1.188679 | 2.47245232 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 42 | 0.0409 | NR | HMD56173.1 | 2586742 | g23160 | i0 | 51.1 | 0.649038461538462 | 45 | 18 | 59.1 | 1 | 39 | 161 | 10 | 54 | HMD56173.1 cytochrome c oxidase assembly protein [Solirubrobacteraceae bacterium] | diamond | 135 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 30672635 | 30672635 | PRJNA1195551_S_NODE_28773_length_189_cov_1.442857_g28420_i0 | PRJNA1195551 | 28773 | 189 | 1.442857 | 2.72699973 | Nocardiopsis terrae | 372655 | Bacteria | Bacteria | 41.6 | 0.0379 | NR | WP_191273017.1 | 372655 | g28420 | i0 | 33.9 | 0.936507936507937 | 59 | 36 | 88.9 | 1 | 1 | 168 | 19 | 77 | WP_191273017.1 hypothetical protein [Nocardiopsis terrae] | diamond | 177 | 41.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Nocardiopsidaceae | Nocardiopsis | Nocardiopsis terrae | ||
| 30767584 | 30767584 | PRJNA1195551_S_NODE_17974_length_234_cov_2.751351_g17621_i0 | PRJNA1195551 | 17974 | 234 | 2.751351 | 6.43816134 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 42.7 | 0.00606 | NR | MSY83325.1 | 2900548 | g17621 | i0 | 37.9 | 0.743589743589744 | 58 | 35 | 73.1 | 1 | 218 | 48 | 13 | 70 | MSY83325.1 hypothetical protein [Actinomycetota bacterium] | diamond | 174 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30862310 | 30862310 | PRJNA1195551_S_NODE_36874_length_168_cov_4.126050_g36521_i0 | PRJNA1195551 | 36874 | 168 | 4.12605 | 6.931764 | Kineosporiaceae bacterium | 2487580 | Bacteria | Bacteria | 42 | 0.0254 | NR | HST84241.1 | 2487580 | g36521 | i0 | 42.9 | 0.75 | 42 | 24 | 75 | 0 | 33 | 158 | 138 | 179 | HST84241.1 sodium-translocating pyrophosphatase [Kineosporiaceae bacterium] | diamond | 126 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kineosporiales | Kineosporiaceae | Kineosporiaceae bacterium | |||
| 31020407 | 31020407 | PRJNA1195551_S_NODE_14975_length_253_cov_2.299020_g14622_i0 | PRJNA1195551 | 14975 | 253 | 2.29902 | 5.8165206 | Bifidobacterium sp. | 41200 | Bacteria | Bacteria | 43.9 | 0.0144 | NR | HCH22157.1 | 41200 | g14622 | i0 | 42.6 | 0.557312252964427 | 47 | 24 | 52.2 | 1 | 174 | 43 | 199 | 245 | HCH22157.1 hypothetical protein [Bifidobacterium sp.] | diamond | 141 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Bifidobacteriales | Bifidobacteriaceae | Bifidobacterium | Bifidobacterium sp. | ||
| 31146269 | 31146269 | PRJNA1195551_S_NODE_11535_length_280_cov_2.251082_g11182_i0 | PRJNA1195551 | 11535 | 280 | 2.251082 | 6.3030296 | Nocardioidaceae bacterium | 1871072 | Bacteria | Bacteria | 45.1 | 0.0026 | NR | HEY0773885.1 | 1871072 | g11182 | i0 | 52 | 1.10357142857143 | 50 | 21 | 53.6 | 2 | 225 | 76 | 68 | 114 | HEY0773885.1 DUF6504 family protein [Nocardioidaceae bacterium] | diamond | 309 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioidaceae bacterium | |||
| 31241386 | 31241386 | PRJNA1195551_S_NODE_32415_length_178_cov_5.240310_g32062_i0 | PRJNA1195551 | 32415 | 178 | 5.24031 | 9.3277518 | Piscicoccus intestinalis | 746033 | Bacteria | Bacteria | 43.5 | 0.00832 | NR | WP_068430052.1 | 746033 | g32062 | i0 | 47.5 | 0.674157303370786 | 40 | 21 | 67.4 | 0 | 29 | 148 | 205 | 244 | WP_068430052.1 universal stress protein [Piscicoccus intestinalis] | diamond | 120 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermatophilaceae | Piscicoccus | Piscicoccus intestinalis | ||
| 31431248 | 31431248 | PRJNA1195551_S_NODE_28136_length_191_cov_1.464789_g27783_i0 | PRJNA1195551 | 28136 | 191 | 1.464789 | 2.79774699 | Arthrobacter sp. zg-Y111 | 1667 | Bacteria | Bacteria | 41.6 | 0.0177 | NR | WP_227934269.1 | 2886932 | g27783 | i0 | 52.9 | 1.33507853403141 | 34 | 16 | 53.4 | 0 | 29 | 130 | 17 | 50 | WP_227934269.1 DUF4326 domain-containing protein [Arthrobacter sp. zg-Y1110] | diamond | 255 | 41.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter sp. zg-Y1110 | ||
| 31463131 | 31463131 | PRJNA1195551_S_NODE_24716_length_203_cov_2.025974_g24363_i0 | PRJNA1195551 | 24716 | 203 | 2.025974 | 4.11272722 | Streptomyces umbrinus | 67370 | Bacteria | Bacteria | 42 | 0.0233 | NR | WP_364197828.1 | 67370 | g24363 | i0 | 39.3 | 1.6551724137931 | 56 | 28 | 82.8 | 2 | 26 | 193 | 57 | 106 | WP_364197828.1 GNAT family N-acetyltransferase [Streptomyces umbrinus] | diamond | 336 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces umbrinus | ||
| 32348966 | 32348966 | PRJNA1195551_S_NODE_13519_length_263_cov_5.126168_g13166_i0 | PRJNA1195551 | 13519 | 263 | 5.126168 | 13.48182184 | Nakamurella sp. | 1869182 | Bacteria | Bacteria | 43.1 | 0.0329 | NR | HEY7814265.1 | 1869182 | g13166 | i0 | 33.8 | 0.809885931558935 | 71 | 36 | 75.3 | 2 | 233 | 36 | 191 | 255 | HEY7814265.1 alpha/beta hydrolase [Nakamurella sp.] | diamond | 213 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Nakamurellales | Nakamurellaceae | Nakamurella | Nakamurella 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);;