contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA672101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 641927 | 641927 | PRJNA672101_S_NODE_27001_length_256_cov_2.524590_g26970_i0 | PRJNA672101 | 27001 | 256 | 2.52459 | 6.4629504 | Rothia nasimurium | 85336 | Bacteria | Bacteria | 326 | 1.2399999999999999e-84 | NTclustered | gi|1890911746|gb|CP056080.1| | 85336 | g26970 | i0 | 92.174 | 267.8125 | 230 | 18 | 90 | 0 | 6 | 235 | 1714374 | 1714603 | Rothia nasimurium strain E1706032 chromosome, complete genome | blastn | 68560 | 326 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Rothia | Rothia nasimurium | ||
| 7020691 | 7020691 | PRJNA672101_S_NODE_35226_length_210_cov_4.291971_g35195_i0 | PRJNA672101 | 35226 | 210 | 4.291971 | 9.0131391 | Streptomyces uncialis | 1048205 | Bacteria | Bacteria | 65.8 | 2.37e-6 | NTclustered | gi|2655924843|gb|CP109290.1| | 1048205 | g35195 | i0 | 90.385 | 0.49047619047619 | 52 | 2 | 24 | 3 | 3 | 52 | 5130118 | 5130168 | Streptomyces uncialis strain NBC 01624 chromosome, complete genome | blastn | 103 | 65.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces uncialis | ||
| 7543388 | 7543388 | PRJNA672101_S_NODE_7106_length_377_cov_3.753289_g7075_i0 | PRJNA672101 | 7106 | 377 | 3.753289 | 14.14989953 | Cutibacterium | 1912216 | Bacteria | Bacteria | 697 | 0 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g7075 | i0 | 100 | 269.623342175066 | 377 | 0 | 100 | 0 | 1 | 377 | 56706 | 57082 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 101648 | 697 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 10845963 | 10845963 | PRJNA672101_S_NODE_229_length_856_cov_30.168582_g211_i0 | PRJNA672101 | 229 | 856 | 30.168582 | 258.24306192 | Brevibacterium casei | 33889 | Bacteria | Bacteria | 1581 | 0 | NTclustered | gi|1958263390|gb|CP068173.1| | 33889 | g211 | i0 | 100 | 296.420560747664 | 856 | 0 | 100 | 0 | 1 | 856 | 173304 | 172449 | Brevibacterium casei strain FDAARGOS_1100 chromosome, complete genome | blastn | 253736 | 1581 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Brevibacteriaceae | Brevibacterium | Brevibacterium casei | ||
| 14670805 | 14670805 | PRJNA672101_S_NODE_15112_length_311_cov_3.134454_g15081_i0 | PRJNA672101 | 15112 | 311 | 3.134454 | 9.74815194 | Actinomyces viscosus | 1656 | Bacteria | Bacteria | 490 | 5.1999999999999985e-134 | NTclustered | gi|1540150178|emb|LR134477.1| | 1656 | g15081 | i0 | 95.208 | 262.392282958199 | 313 | 10 | 99 | 4 | 1 | 309 | 245454 | 245143 | Actinomyces viscosus strain NCTC10951 genome assembly, chromosome: 1 | blastn | 81604 | 490 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Actinomyces | Actinomyces viscosus | ||
| 15194088 | 15194088 | PRJNA672101_S_NODE_12812_length_326_cov_4.000000_g12781_i0 | PRJNA672101 | 12812 | 326 | 4 | 13.04 | Propionibacteriaceae | 31957 | Bacteria | Bacteria | 558 | 1.48e-154 | NTclustered | gi|2016305036|gb|CP071870.1| | 2760308 | g12781 | i0 | 97.546 | 229.003067484663 | 326 | 8 | 100 | 0 | 1 | 326 | 2050501 | 2050826 | Propioniciclava sp. MC1595 chromosome, complete genome | blastn | 74655 | 558 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Propioniciclava | Propioniciclava sp. MC1595 | ||
| 15194101 | 15194101 | PRJNA672101_S_NODE_27552_length_254_cov_2.475138_g27521_i0 | PRJNA672101 | 27552 | 254 | 2.475138 | 6.28685052 | Actinomycetes | 1760 | Bacteria | Bacteria | 464 | 2.4999999999999994e-126 | NTclustered | gi|1828205916|gb|MT279343.1| | 51513 | g27521 | i0 | 99.606 | 100.007874015748 | 254 | 1 | 100 | 0 | 1 | 254 | 450 | 197 | Agromyces sp. strain LA10 16S ribosomal RNA gene, partial sequence | blastn | 25402 | 464 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Agromyces | Agromyces sp. | ||
| 16468409 | 16468409 | PRJNA672101_S_NODE_21053_length_280_cov_6.951691_g21022_i0 | PRJNA672101 | 21053 | 280 | 6.951691 | 19.4647348 | root | 1 | Root_unresolved | Root_unresolved | 518 | 2.12e-142 | NTclustered | gi|1313740129|dbj|LC341276.1| | 1747 | g21022 | i0 | 100 | 103 | 280 | 0 | 100 | 0 | 1 | 280 | 1039 | 1318 | Cutibacterium acnes JK12.2 gene for 16S ribosomal RNA, partial sequence | blastn | 28840 | 518 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 19017237 | 19017237 | PRJNA672101_S_NODE_33115_length_241_cov_3.482143_g33084_i0 | PRJNA672101 | 33115 | 241 | 3.482143 | 8.39196463 | Cutibacterium | 1912216 | Bacteria | Bacteria | 446 | 8.519999999999999e-121 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g33084 | i0 | 100 | 59.4647302904564 | 241 | 0 | 100 | 0 | 1 | 241 | 88110 | 88350 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 14331 | 446 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 22319457 | 22319457 | PRJNA672101_S_NODE_8858_length_358_cov_6.150877_g8827_i0 | PRJNA672101 | 8858 | 358 | 6.150877 | 22.02013966 | uncultured Frankia sp. | 181582 | Bacteria | Bacteria | 412 | 1.35e-110 | NTclustered | gi|48728172|gb|AY627744.1| | 181582 | g8827 | i0 | 87.465 | 155.220670391061 | 359 | 43 | 100 | 2 | 1 | 358 | 530 | 887 | Uncultured Frankia sp. clone CEIN1811 16S-23S intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 55569 | 412 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Frankiales | Frankiaceae | Frankia | uncultured Frankia sp. | ||
| 24867935 | 24867935 | PRJNA672101_S_NODE_11440_length_336_cov_7.543726_g11409_i0 | PRJNA672101 | 11440 | 336 | 7.543726 | 25.34691936 | Pedococcus dokdonensis | 443156 | Bacteria | Bacteria | 527 | 4.3199999999999985e-145 | NTclustered | gi|1085742359|emb|LT629711.1| | 443156 | g11409 | i0 | 94.94 | 349.488095238095 | 336 | 17 | 100 | 0 | 1 | 336 | 1368415 | 1368080 | Phycicoccus dokdonensis strain DSM 22329 genome assembly, chromosome: I | blastn | 117428 | 527 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Pedococcus | Pedococcus dokdonensis | ||
| 24868063 | 24868063 | PRJNA672101_S_NODE_19360_length_288_cov_3.390698_g19329_i0 | PRJNA672101 | 19360 | 288 | 3.390698 | 9.76521024 | Brevibacterium casei | 33889 | Bacteria | Bacteria | 532 | 7.8e-147 | NTclustered | gi|1943100173|gb|CP065629.1| | 33889 | g19329 | i0 | 100 | 16.0381944444444 | 288 | 0 | 100 | 0 | 1 | 288 | 3028899 | 3029186 | Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome | blastn | 4619 | 532 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Brevibacteriaceae | Brevibacterium | Brevibacterium casei |
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);;