contig_metadata
24 rows where bioproject = "PRJNA853194", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 840711 | 840711 | PRJNA853194_S_NODE_57621_length_288_cov_1.386047_g56530_i0 | PRJNA853194 | 57621 | 288 | 1.386047 | 3.99181536 | Micromonospora sp. B006 | 2201999 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|1450453732|gb|CP030865.1| | 2201999 | g56530 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 18 | 45 | 2839752 | 2839725 | Micromonospora sp. B006 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora sp. B006 | ||
| 1234517 | 1234517 | PRJNA853194_S_NODE_64961_length_272_cov_1.889447_g63870_i0 | PRJNA853194 | 64961 | 272 | 1.889447 | 5.13929584 | Cutibacterium | 1912216 | Bacteria | Bacteria | 475 | 1.2499999999999999e-129 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g63870 | i0 | 98.162 | 260.834558823529 | 272 | 5 | 100 | 0 | 1 | 272 | 55522 | 55793 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 70947 | 475 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 2116127 | 2116127 | PRJNA853194_S_NODE_58922_length_285_cov_1.556604_g57831_i0 | PRJNA853194 | 58922 | 285 | 1.556604 | 4.4363214 | Micrococcus terreus | 574650 | Bacteria | Bacteria | 455 | 1.72e-123 | NTclustered | gi|2606505334|gb|CP136963.1| | 574650 | g57831 | i0 | 95.439 | 348.410526315789 | 285 | 13 | 100 | 0 | 1 | 285 | 1206030 | 1206314 | Micrococcus terreus strain UMB0712 chromosome, complete genome | blastn | 99297 | 455 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus terreus | ||
| 2510028 | 2510028 | PRJNA853194_S_NODE_29302_length_385_cov_1.750000_g28211_i0 | PRJNA853194 | 29302 | 385 | 1.75 | 6.7375 | Cutibacterium | 1912216 | Bacteria | Bacteria | 673 | 0 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g28211 | i0 | 98.182 | 271.187012987013 | 385 | 7 | 100 | 0 | 1 | 385 | 56108 | 56492 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 104407 | 678 | 0.992625368731563 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 3786465 | 3786465 | PRJNA853194_S_NODE_65843_length_270_cov_3.126904_g64752_i0 | PRJNA853194 | 65843 | 270 | 3.126904 | 8.4426408 | Microbacterium | 33882 | Bacteria | Bacteria | 412 | 9.85e-111 | NTclustered | gi|2421836332|dbj|AP027141.1| | 344163 | g64752 | i0 | 94.403 | 152.840740740741 | 268 | 15 | 99 | 0 | 1 | 268 | 1041403 | 1041670 | Microbacterium terricola KV-448 DNA, complete genome | blastn | 41267 | 412 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium terricola | ||
| 4669316 | 4669316 | PRJNA853194_S_NODE_66924_length_268_cov_2.210256_g65833_i0 | PRJNA853194 | 66924 | 268 | 2.210256 | 5.92348608 | Microbacterium limosum | 3079935 | Bacteria | Bacteria | 490 | 4.39e-134 | NTclustered | gi|2609663758|gb|CP137080.1| | 3079935 | g65833 | i0 | 99.627 | 173.981343283582 | 268 | 1 | 100 | 0 | 1 | 268 | 816988 | 817255 | Microbacterium limosum strain Y20 chromosome, complete genome | blastn | 46627 | 490 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium limosum | ||
| 8493886 | 8493886 | PRJNA853194_S_NODE_71587_length_259_cov_3.564516_g70496_i0 | PRJNA853194 | 71587 | 259 | 3.564516 | 9.23209644 | Streptomyces sp. NBC_01744 | 2975927 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|2652825344|gb|CP109148.1| | 2975927 | g70496 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 101 | 128 | 6608833 | 6608860 | Streptomyces sp. NBC_01744 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NBC_01744 | ||
| 9768637 | 9768637 | PRJNA853194_S_NODE_52148_length_301_cov_2.921053_g51057_i0 | PRJNA853194 | 52148 | 301 | 2.921053 | 8.79236953 | Curtobacterium flaccumfaciens | 2035 | Bacteria | Bacteria | 67.6 | 1e-6 | NTclustered | gi|2699815311|gb|CP147772.1| | 138532 | g51057 | i0 | 97.436 | 0.578073089700997 | 39 | 1 | 13 | 0 | 40 | 78 | 1468796 | 1468758 | Curtobacterium flaccumfaciens pv. flaccumfaciens strain ARGTr 5-2 chromosome, complete genome | blastn | 174 | 67.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Curtobacterium | Curtobacterium flaccumfaciens | ||
| 13988270 | 13988270 | PRJNA853194_S_NODE_11_length_4751_cov_29.085720_g7_i0 | PRJNA853194 | 11 | 4751 | 29.08572 | 1381.8625572 | root | 1 | Root_unresolved | Root_unresolved | 8691 | 0 | NTclustered | gi|1851830967|gb|CP050522.1| | 1902 | g7 | i0 | 99.958 | 97.1283940223111 | 4712 | 2 | 99 | 0 | 1 | 4712 | 4166864 | 4162153 | Streptomyces coelicolor strain M1154/pAMX4/pGP1416 chromosome, complete genome | blastn | 461457 | 8691 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces coelicolor | ||
| 13988320 | 13988320 | PRJNA853194_S_NODE_40371_length_337_cov_2.681818_g39280_i0 | PRJNA853194 | 40371 | 337 | 2.681818 | 9.03772666 | Microbacterium | 33882 | Bacteria | Bacteria | 612 | 1.16e-170 | NTclustered | gi|1532072101|gb|CP034245.1| | 2483401 | g39280 | i0 | 99.407 | 164.06824925816 | 337 | 2 | 100 | 0 | 1 | 337 | 2274416 | 2274752 | Microbacterium sp. 10M-3C3 chromosome, complete genome | blastn | 55291 | 612 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. 10M-3C3 | ||
| 17812066 | 17812066 | PRJNA853194_S_NODE_80894_length_246_cov_1.242775_g79803_i0 | PRJNA853194 | 80894 | 246 | 1.242775 | 3.0572265 | root | 1 | Root_unresolved | Root_unresolved | 348 | 2.53e-91 | NTclustered | gi|1851830967|gb|CP050522.1| | 1902 | g79803 | i0 | 92.245 | 99.5934959349593 | 245 | 19 | 99 | 0 | 1 | 245 | 4168319 | 4168563 | Streptomyces coelicolor strain M1154/pAMX4/pGP1416 chromosome, complete genome | blastn | 24500 | 348 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces coelicolor | ||
| 19086032 | 19086032 | PRJNA853194_S_NODE_44075_length_325_cov_1.615079_g42984_i0 | PRJNA853194 | 44075 | 325 | 1.615079 | 5.24900675 | root | 1 | Root_unresolved | Root_unresolved | 597 | 3.1299999999999987e-166 | NTclustered | gi|1851830967|gb|CP050522.1| | 1902 | g42984 | i0 | 100 | 99.5938461538462 | 323 | 0 | 99 | 0 | 1 | 323 | 4161764 | 4161442 | Streptomyces coelicolor strain M1154/pAMX4/pGP1416 chromosome, complete genome | blastn | 32368 | 597 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces coelicolor | ||
| 25461113 | 25461113 | PRJNA853194_S_NODE_22000_length_431_cov_1.687151_g20909_i0 | PRJNA853194 | 22000 | 431 | 1.687151 | 7.27162081 | Microbacterium | 33882 | Bacteria | Bacteria | 780 | 0 | NTclustered | gi|1137412343|gb|CP018762.1| | 36805 | g20909 | i0 | 99.304 | 162.554524361949 | 431 | 3 | 100 | 0 | 1 | 431 | 2342208 | 2341778 | Microbacterium aurum strain KACC 15219 chromosome, complete genome | blastn | 70061 | 785 | 0.993630573248408 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium aurum | ||
| 25461229 | 25461229 | PRJNA853194_S_NODE_79200_length_248_cov_1.074286_g78109_i0 | PRJNA853194 | 79200 | 248 | 1.074286 | 2.66422928 | Dietzia | 37914 | Bacteria | Bacteria | 278 | 3.4e-70 | NTclustered | gi|1783245866|gb|CP046567.1| | 912801 | g78109 | i0 | 87.398 | 2.49193548387097 | 246 | 25 | 99 | 2 | 3 | 248 | 606954 | 607193 | Dietzia sp. DQ12-45-1b chromosome, complete genome | blastn | 618 | 278 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Dietziaceae | Dietzia | Dietzia sp. DQ12-45-1b | ||
| 29518049 | 29518049 | PRJNA853194_S_NODE_68790_length_265_cov_1.151042_g67699_i0 | PRJNA853194 | 68790 | 265 | 1.151042 | 3.0502613 | Sinomonas cellulolyticus | 2801916 | Bacteria | Bacteria | 43.5 | 0.0254 | NR | WP_189693105.1 | 2801916 | g67699 | i0 | 35.5 | 0.860377358490566 | 76 | 42 | 86 | 1 | 32 | 259 | 97 | 165 | WP_189693105.1 glycosyltransferase 87 family protein [Sinomonas cellulolyticus] | diamond | 228 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Sinomonas | Sinomonas cellulolyticus | ||
| 29833867 | 29833867 | PRJNA853194_S_NODE_65011_length_272_cov_1.663317_g63920_i0 | PRJNA853194 | 65011 | 272 | 1.663317 | 4.52422224 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 44.3 | 0.0157 | NR | WP_399435965.1 | 3365658 | g63920 | i0 | 47.5 | 0.441176470588235 | 40 | 21 | 44.1 | 0 | 71 | 190 | 1206 | 1245 | WP_399435965.1 hypothetical protein [Streptomyces sp. NPDC051561] | diamond | 120 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC051561 | ||
| 29905424 | 29905424 | PRJNA853194_S_NODE_80631_length_246_cov_1.745665_g79540_i0 | PRJNA853194 | 80631 | 246 | 1.745665 | 4.2943359 | root | 1 | Root_unresolved | Root_unresolved | 105 | 8.870000000000001e-27 | NR | NSL78899.1 | 1902 | g79540 | i0 | 74.7 | 5.78048780487805 | 79 | 20 | 96.3 | 0 | 237 | 1 | 45 | 123 | NSL78899.1 hypothetical protein [Streptomyces coelicolor] | diamond | 1422 | 105 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces coelicolor | ||
| 30592048 | 30592048 | PRJNA853194_S_NODE_62313_length_278_cov_1.029268_g61222_i0 | PRJNA853194 | 62313 | 278 | 1.029268 | 2.86136504 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 43.9 | 0.0213 | NR | WP_388990728.1 | 3364609 | g61222 | i0 | 43.2 | 0.474820143884892 | 44 | 25 | 47.5 | 0 | 174 | 43 | 118 | 161 | WP_388990728.1 serine hydroxymethyltransferase [Streptomyces sp. NPDC001796] | diamond | 132 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC001796 | ||
| 30853087 | 30853087 | PRJNA853194_S_NODE_85094_length_241_cov_1.773810_g84003_i0 | PRJNA853194 | 85094 | 241 | 1.77381 | 4.2748821 | Streptomyces | 1883 | Bacteria | Bacteria | 42.7 | 0.0288 | NR | WP_053657044.1 | 1415544 | g84003 | i0 | 33.3 | 1.26970954356846 | 48 | 32 | 59.8 | 0 | 175 | 32 | 51 | 98 | WP_053657044.1 phosphatase PAP2 family protein [Streptomyces sp. MMG1121] | diamond | 306 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. MMG1121 | ||
| 31698509 | 31698509 | PRJNA853194_S_NODE_77617_length_250_cov_0.870056_g76526_i0 | PRJNA853194 | 77617 | 250 | 0.870056 | 2.17514 | Microbispora sp. H1 | 1898321 | Bacteria | Bacteria | 42.4 | 0.0396 | NR | WP_182879688.1 | 2729111 | g76526 | i0 | 35.7 | 0.84 | 70 | 37 | 74.4 | 3 | 9 | 194 | 123 | 192 | WP_182879688.1 hypothetical protein [Microbispora sp. H10949] | diamond | 210 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Microbispora | Microbispora sp. H10949 | ||
| 32109791 | 32109791 | PRJNA853194_S_NODE_75738_length_252_cov_1.592179_g74647_i0 | PRJNA853194 | 75738 | 252 | 1.592179 | 4.01229108 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 42 | 0.0204 | NR | MFI5040452.1 | 2201156 | g74647 | i0 | 36.4 | 0.654761904761905 | 55 | 35 | 65.5 | 0 | 27 | 191 | 19 | 73 | MFI5040452.1 hypothetical protein [Acidimicrobiales bacterium] | diamond | 165 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 32308155 | 32308155 | PRJNA853194_S_NODE_64439_length_273_cov_1.940000_g63348_i0 | PRJNA853194 | 64439 | 273 | 1.94 | 5.2962 | Acidimicrobiales | 84993 | Bacteria | Bacteria | 44.7 | 0.0104 | NR | HBZ62281.1 | 1872112 | g63348 | i0 | 37.3 | 7.13186813186813 | 59 | 36 | 64.8 | 1 | 239 | 63 | 63 | 120 | HBZ62281.1 pyruvate dehydrogenase [Acidimicrobium sp.] | diamond | 1947 | 45.1 | 0.991130820399113 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiaceae | Acidimicrobium | Acidimicrobium sp. | ||
| 32426253 | 32426253 | PRJNA853194_S_NODE_80379_length_247_cov_0.879310_g79288_i0 | PRJNA853194 | 80379 | 247 | 0.87931 | 2.1718957 | Streptosporangium sp. NPDC | 47486 | Bacteria | Bacteria | 43.1 | 0.0282 | NR | WP_362803166.1 | 3154794 | g79288 | i0 | 39.3 | 0.740890688259109 | 61 | 34 | 72.9 | 2 | 231 | 52 | 123 | 181 | WP_362803166.1 AAA family ATPase [Streptosporangium sp. NPDC023615] | diamond | 183 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Streptosporangium | Streptosporangium sp. NPDC023615 | ||
| 32489661 | 32489661 | PRJNA853194_S_NODE_62919_length_276_cov_2.906404_g61828_i0 | PRJNA853194 | 62919 | 276 | 2.906404 | 8.02167504 | Mycobacterium leprae | 1769 | Bacteria | Bacteria | 40.8 | 0.029 | NR | WP_162618264.1 | 1769 | g61828 | i0 | 35 | 0.434782608695652 | 40 | 26 | 43.5 | 0 | 56 | 175 | 11 | 50 | WP_162618264.1 hypothetical protein [Mycobacterium leprae] | diamond | 120 | 40.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium leprae |
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);;