contig_metadata
23 rows where bioproject = "PRJEB28589" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 988030 | 988030 | PRJEB28589_S_NODE_4661_length_332_cov_4.343860_g4553_i0 | PRJEB28589 | 4661 | 332 | 4.34386 | 14.4216152 | Cutibacterium | 1912216 | Bacteria | Bacteria | 54.7 | 0.009 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g4553 | i0 | 96.875 | 3.67168674698795 | 32 | 1 | 10 | 0 | 301 | 332 | 657100 | 657131 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 1219 | 54.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 2263326 | 2263326 | PRJEB28589_S_NODE_3682_length_351_cov_6.220395_g3574_i0 | PRJEB28589 | 3682 | 351 | 6.220395 | 21.83358645 | Propionibacteriaceae | 31957 | Bacteria | Bacteria | 326 | 1.77e-84 | NTclustered | gi|1976468523|gb|CP069240.1| | 33010 | g3574 | i0 | 89.015 | 79.977207977208 | 264 | 27 | 75 | 2 | 84 | 346 | 438576 | 438838 | Cutibacterium avidum strain KCTC 5339 chromosome, complete genome | blastn | 28072 | 329 | 0.990881458966565 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium avidum | ||
| 3852102 | 3852102 | PRJEB28589_S_NODE_15164_length_186_cov_0.884892_g15056_i0 | PRJEB28589 | 15164 | 186 | 0.884892 | 1.64589912 | Knoellia locipacati | 882824 | Bacteria | Bacteria | 329 | 6.56e-86 | NTclustered | gi|2851051056|gb|CP087730.1| | 882824 | g15056 | i0 | 98.913 | 201.736559139785 | 184 | 2 | 99 | 0 | 1 | 184 | 68565 | 68748 | Knoellia locipacati strain SLM-625 chromosome, complete genome | blastn | 37523 | 329 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Knoellia | Knoellia locipacati | ||
| 7365645 | 7365645 | PRJEB28589_S_NODE_5606_length_314_cov_3.730337_g5498_i0 | PRJEB28589 | 5606 | 314 | 3.730337 | 11.71325818 | Cutibacterium | 1912216 | Bacteria | Bacteria | 580 | 3.0299999999999992e-161 | NTclustered | gi|966542502|gb|CP012354.1| | 1747 | g5498 | i0 | 100 | 53.3503184713376 | 314 | 0 | 100 | 0 | 1 | 314 | 1803893 | 1803580 | Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome | blastn | 16752 | 580 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 8641215 | 8641215 | PRJEB28589_S_NODE_787_length_571_cov_6.503817_g690_i0 | PRJEB28589 | 787 | 571 | 6.503817 | 37.13679507 | Cutibacterium | 1912216 | Bacteria | Bacteria | 743 | 0 | NTclustered | gi|966544767|gb|CP012355.1| | 1747 | g690 | i0 | 92.22 | 237.900175131349 | 527 | 37 | 92 | 4 | 46 | 571 | 625951 | 625428 | Cutibacterium acnes strain PA_15_1_R1 chromosome, complete genome | blastn | 135841 | 743 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 9916189 | 9916189 | PRJEB28589_S_NODE_1328_length_473_cov_7.164319_g1224_i0 | PRJEB28589 | 1328 | 473 | 7.164319 | 33.88722887 | Cutibacterium | 1912216 | Bacteria | Bacteria | 773 | 0 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g1224 | i0 | 96.391 | 267.365750528541 | 471 | 13 | 99 | 4 | 1 | 469 | 56554 | 56086 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 126464 | 773 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 10228725 | 10228725 | PRJEB28589_S_NODE_2509_length_387_cov_2.126471_g2401_i0 | PRJEB28589 | 2509 | 387 | 2.126471 | 8.22944277 | Salinibacterium soli | 3064523 | Bacteria | Bacteria | 186 | 2.21e-53 | NR | WP_305003951.1 | 3064523 | g2401 | i0 | 80.2 | 0.976744186046512 | 126 | 25 | 97.7 | 0 | 380 | 3 | 446 | 571 | WP_305003951.1 dynamin family protein [Salinibacterium soli] | diamond | 378 | 186 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Antiquaquibacter | Antiquaquibacter soli | ||
| 11504041 | 11504041 | PRJEB28589_S_NODE_2050_length_409_cov_7.707182_g1942_i0 | PRJEB28589 | 2050 | 409 | 7.707182 | 31.52237438 | Homoserinibacter sp. YIM 151385 | 2985506 | Bacteria | Bacteria | 372 | 2.6499999999999995e-98 | NTclustered | gi|2428672229|gb|CP115175.1| | 2985506 | g1942 | i0 | 87.135 | 79.1711491442543 | 342 | 26 | 82 | 14 | 76 | 409 | 2545086 | 2544755 | Homoserinibacter sp. YIM 151385 chromosome, complete genome | blastn | 32381 | 372 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Homoserinibacter | Homoserinibacter sp. YIM 151385 | ||
| 12467135 | 12467135 | PRJEB28589_S_NODE_5930_length_309_cov_3.374046_g5822_i0 | PRJEB28589 | 5930 | 309 | 3.374046 | 10.42580214 | Streptomyces | 1883 | Bacteria | Bacteria | 571 | 1.7899999999999995e-158 | NTclustered | gi|1399240079|gb|CP029788.1| | 1885 | g5822 | i0 | 100 | 559.37216828479 | 309 | 0 | 100 | 0 | 1 | 309 | 1248414 | 1248722 | Streptomyces actuosus strain ATCC 25421 chromosome, complete genome | blastn | 172846 | 571 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces actuosus | ||
| 13741502 | 13741502 | PRJEB28589_S_NODE_19151_length_157_cov_2.090909_g19043_i0 | PRJEB28589 | 19151 | 157 | 2.090909 | 3.28272713 | Nocardioidaceae | 85015 | Bacteria | Bacteria | 285 | 1.17e-72 | NTclustered | gi|2806731072|gb|PQ351029.1| | 35761 | g19043 | i0 | 99.363 | 101 | 157 | 1 | 100 | 0 | 1 | 157 | 359 | 203 | Nocardioides sp. strain b99 16S ribosomal RNA gene, partial sequence | blastn | 15857 | 285 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 13741504 | 13741504 | PRJEB28589_S_NODE_2191_length_402_cov_9.380282_g2083_i0 | PRJEB28589 | 2191 | 402 | 9.380282 | 37.70873364 | Cutibacterium | 1912216 | Bacteria | Bacteria | 743 | 0 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g2083 | i0 | 100 | 53.0970149253731 | 402 | 0 | 100 | 0 | 1 | 402 | 1216859 | 1217260 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 21345 | 743 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 16290701 | 16290701 | PRJEB28589_S_NODE_7173_length_290_cov_4.209877_g7065_i0 | PRJEB28589 | 7173 | 290 | 4.209877 | 12.2086433 | Microbacterium | 33882 | Bacteria | Bacteria | 78.7 | 4.43e-10 | NTclustered | gi|2440500310|gb|CP069429.1| | 2809708 | g7065 | i0 | 84.615 | 0.76551724137931 | 78 | 12 | 27 | 0 | 35 | 112 | 1525168 | 1525091 | Microbacterium sp. EF45047 chromosome, complete genome | blastn | 222 | 78.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. EF45047 | ||
| 16602815 | 16602815 | PRJEB28589_S_NODE_6814_length_295_cov_6.516129_g6706_i0 | PRJEB28589 | 6814 | 295 | 6.516129 | 19.22258055 | Microbacterium hydrocarbonoxydans | 273678 | Bacteria | Bacteria | 104 | 7.45e-18 | NTclustered | gi|1915674697|emb|LR882982.1| | 273678 | g6706 | i0 | 98.333 | 8.57627118644068 | 60 | 0 | 20 | 1 | 59 | 117 | 3140623 | 3140564 | Microbacterium hydrocarbonoxydans strain Marseille-P2596 genome assembly, chromosome: contig00001 | blastn | 2530 | 104 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium hydrocarbonoxydans | ||
| 20426614 | 20426614 | PRJEB28589_S_NODE_10517_length_241_cov_2.407216_g10409_i0 | PRJEB28589 | 10517 | 241 | 2.407216 | 5.80139056 | Micrococcus luteus | 1270 | Bacteria | Bacteria | 418 | 1.8599999999999995e-112 | NTclustered | gi|1875928653|gb|CP059046.1| | 1270 | g10409 | i0 | 97.925 | 27 | 241 | 5 | 100 | 0 | 1 | 241 | 256173 | 255933 | Micrococcus luteus strain R17 chromosome, complete genome | blastn | 6507 | 418 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus luteus | ||
| 20426638 | 20426638 | PRJEB28589_S_NODE_15237_length_185_cov_2.028986_g15129_i0 | PRJEB28589 | 15237 | 185 | 2.028986 | 3.7536241 | Micrococcus yunnanensis | 566027 | Bacteria | Bacteria | 337 | 3.89e-88 | NTclustered | gi|2506638323|gb|CP125290.1| | 566027 | g15129 | i0 | 99.462 | 190.416216216216 | 186 | 0 | 100 | 1 | 1 | 185 | 247470 | 247655 | Micrococcus yunnanensis strain TJPT4 chromosome, complete genome | blastn | 35227 | 337 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus yunnanensis | ||
| 23940383 | 23940383 | PRJEB28589_S_NODE_5499_length_316_cov_3.137546_g5391_i0 | PRJEB28589 | 5499 | 316 | 3.137546 | 9.91464536 | Cutibacterium | 1912216 | Bacteria | Bacteria | 584 | 2.359999999999999e-162 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g5391 | i0 | 100 | 267 | 316 | 0 | 100 | 0 | 1 | 316 | 55818 | 55503 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 84372 | 584 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 28075458 | 28075458 | PRJEB28589_S_NODE_8025_length_276_cov_6.270742_g7917_i0 | PRJEB28589 | 8025 | 276 | 6.270742 | 17.30724792 | Mycobacteroides abscessus | 36809 | Bacteria | Bacteria | 44.3 | 0.0159 | NR | WP_074344327.1 | 36809 | g7917 | i0 | 35.8 | 0.728260869565217 | 67 | 36 | 72.8 | 2 | 64 | 264 | 11 | 70 | WP_074344327.1 site-specific integrase [Mycobacteroides abscessus] | diamond | 201 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacteroides | Mycobacteroides abscessus | ||
| 28770116 | 28770116 | PRJEB28589_S_NODE_2987_length_369_cov_12.767081_g2879_i0 | PRJEB28589 | 2987 | 369 | 12.767081 | 47.11052889 | Nonomuraea sp. NPDC | 1883105 | Bacteria | Bacteria | 60.1 | 6.9e-8 | NR | WP_397337993.1 | 3364361 | g2879 | i0 | 77.4 | 0.252032520325203 | 31 | 7 | 25.2 | 0 | 1 | 93 | 213 | 243 | WP_397337993.1 hypothetical protein [Nonomuraea sp. NPDC050328] | diamond | 93 | 60.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Nonomuraea | Nonomuraea sp. NPDC050328 | ||
| 29142851 | 29142851 | PRJEB28589_S_NODE_4389_length_337_cov_7.889655_g4281_i0 | PRJEB28589 | 4389 | 337 | 7.889655 | 26.58813735 | Bacillati | 1783272 | Bacteria | Bacteria | 218 | 7.87e-69 | NR | PYC99595.1 | 57043 | g4281 | i0 | 96.3 | 1.90504451038576 | 107 | 4 | 95.3 | 0 | 321 | 1 | 25 | 131 | PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum] | diamond | 642 | 218 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium esteraromaticum | ||
| 29212395 | 29212395 | PRJEB28589_S_NODE_2729_length_378_cov_8.105740_g2621_i0 | PRJEB28589 | 2729 | 378 | 8.10574 | 30.6396972 | Mycolicibacterium peregrinum | 43304 | Bacteria | Bacteria | 70.9 | 1.72e-12 | NR | WP_207548826.1 | 43304 | g2621 | i0 | 75.6 | 1.05555555555556 | 45 | 7 | 32.5 | 1 | 3 | 125 | 111 | 155 | WP_207548826.1 cyanase [Mycolicibacterium peregrinum] | diamond | 399 | 70.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium peregrinum | ||
| 29685495 | 29685495 | PRJEB28589_S_NODE_18050_length_163_cov_0.879310_g17942_i0 | PRJEB28589 | 18050 | 163 | 0.87931 | 1.4332753 | Trebonia sp. | 2767075 | Bacteria | Bacteria | 43.1 | 0.00758 | NR | HXC81211.1 | 2767075 | g17942 | i0 | 35.1 | 1.04907975460123 | 57 | 33 | 97.5 | 1 | 3 | 161 | 11 | 67 | HXC81211.1 helix-turn-helix domain-containing protein [Trebonia sp.] | diamond | 171 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Treboniaceae | Trebonia | Trebonia sp. | ||
| 29843714 | 29843714 | PRJEB28589_S_NODE_3571_length_354_cov_4.671010_g3463_i0 | PRJEB28589 | 3571 | 354 | 4.67101 | 16.5353754 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 170 | 4.54e-51 | NR | WP_385231606.1 | 3346948 | g3463 | i0 | 66.7 | 2.93220338983051 | 114 | 37 | 96.6 | 1 | 2 | 343 | 87 | 199 | WP_385231606.1 DUF1349 domain-containing protein [Streptomyces sp. NPDC059788] | diamond | 1038 | 170 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC059788 | ||
| 30343229 | 30343229 | PRJEB28589_S_NODE_2652_length_381_cov_7.143713_g2544_i0 | PRJEB28589 | 2652 | 381 | 7.143713 | 27.21754653 | Actinomycetes | 1760 | Bacteria | Bacteria | 182 | 2.03e-56 | NR | WP_010851256.1 | 101689 | g2544 | i0 | 70 | 3.79527559055118 | 120 | 36 | 94.5 | 0 | 2 | 361 | 41 | 160 | WP_010851256.1 glutathione peroxidase [Phycicoccus elongatus] | diamond | 1446 | 183 | 0.994535519125683 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Phycicoccus | Phycicoccus elongatus |
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);;