contig_metadata
13 rows where bioproject = "PRJNA229468" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1056633 | 1056633 | PRJNA229468_S_NODE_961_length_173_cov_1.233871_g948_i0 | PRJNA229468 | 961 | 173 | 1.233871 | 2.13459683 | Rothia | 32207 | Bacteria | Bacteria | 320 | 3.61e-83 | NTclustered | gi|1247210625|gb|CP023510.1| | 43675 | g948 | i0 | 100 | 291.132947976879 | 173 | 0 | 100 | 0 | 1 | 173 | 652615 | 652443 | Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome | blastn | 50366 | 320 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Rothia | Rothia mucilaginosa | ||
| 4884545 | 4884545 | PRJNA229468_S_NODE_644_length_203_cov_0.948052_g631_i0 | PRJNA229468 | 644 | 203 | 0.948052 | 1.92454556 | Micrococcales | 85006 | Bacteria | Bacteria | 326 | 9.44e-85 | NTclustered | gi|1247210625|gb|CP023510.1| | 43675 | g631 | i0 | 95.567 | 360.162561576355 | 203 | 9 | 100 | 0 | 1 | 203 | 652910 | 653112 | Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome | blastn | 73113 | 326 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Rothia | Rothia mucilaginosa | ||
| 8020686 | 8020686 | PRJNA229468_S_NODE_1007_length_170_cov_1.264463_g994_i0 | PRJNA229468 | 1007 | 170 | 1.264463 | 2.1495871 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 300 | 4.6e-77 | NTclustered | gi|1723592958|emb|LR584267.1| | 1528099 | g994 | i0 | 98.256 | 276.317647058824 | 172 | 1 | 100 | 1 | 1 | 170 | 552297 | 552468 | Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1 | blastn | 46974 | 300 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 8020687 | 8020687 | PRJNA229468_S_NODE_287_length_292_cov_1.263374_g274_i0 | PRJNA229468 | 287 | 292 | 1.263374 | 3.68905208 | Arthrobacter dokdonellae | 2211210 | Bacteria | Bacteria | 510 | 3.71e-140 | NTclustered | gi|1409665507|gb|CP029642.1| | 2211210 | g274 | i0 | 98.282 | 458.366438356164 | 291 | 5 | 99 | 0 | 2 | 292 | 551070 | 550780 | Arthrobacter dokdonellae, complete genome | blastn | 133843 | 510 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter dokdonellae | ||
| 11259789 | 11259789 | PRJNA229468_S_NODE_1149_length_164_cov_1.208696_g1136_i0 | PRJNA229468 | 1149 | 164 | 1.208696 | 1.98226144 | Corynebacterium | 1716 | Bacteria | Bacteria | 272 | 9.65e-69 | NTclustered | gi|2212856580|gb|CP051667.1| | 37637 | g1136 | i0 | 96.933 | 323.018292682927 | 163 | 3 | 100 | 2 | 4 | 164 | 1103762 | 1103600 | Corynebacterium pseudodiphtheriticum strain 10700 chromosome | blastn | 52975 | 272 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium pseudodiphtheriticum | ||
| 13809994 | 13809994 | PRJNA229468_S_NODE_611_length_207_cov_0.955696_g598_i0 | PRJNA229468 | 611 | 207 | 0.955696 | 1.97829072 | Modestobacter | 88138 | Bacteria | Bacteria | 363 | 7.369999999999998e-96 | NTclustered | gi|470491309|ref|NR_077032.1| | 477641 | g598 | i0 | 99.01 | 379.289855072464 | 202 | 2 | 98 | 0 | 1 | 202 | 1018 | 817 | Modestobacter marinus strain BC501 23S ribosomal RNA, complete sequence | blastn | 78513 | 363 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Geodermatophilales | Geodermatophilaceae | Modestobacter | Modestobacter marinus | ||
| 17634189 | 17634189 | PRJNA229468_S_NODE_834_length_182_cov_1.646617_g821_i0 | PRJNA229468 | 834 | 182 | 1.646617 | 2.99684294 | Arthrobacter | 1663 | Bacteria | Bacteria | 320 | 3.84e-83 | NTclustered | gi|2921126289|gb|CP102608.1| | 619291 | g821 | i0 | 98.352 | 428.796703296703 | 182 | 3 | 100 | 0 | 1 | 182 | 459346 | 459165 | Arthrobacter sp. N1 chromosome, complete genome | blastn | 78041 | 320 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter sp. N1 | ||
| 21458301 | 21458301 | PRJNA229468_S_NODE_357_length_265_cov_2.222222_g344_i0 | PRJNA229468 | 357 | 265 | 2.222222 | 5.8888883 | Cutibacterium | 1912216 | Bacteria | Bacteria | 490 | 4.3299999999999986e-134 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g344 | i0 | 100 | 268.256603773585 | 265 | 0 | 100 | 0 | 1 | 265 | 56512 | 56248 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 71088 | 490 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 22733344 | 22733344 | PRJNA229468_S_NODE_38_length_727_cov_4.001475_g32_i0 | PRJNA229468 | 38 | 727 | 4.001475 | 29.09072325 | Cutibacterium | 1912216 | Bacteria | Bacteria | 1343 | 0 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g32 | i0 | 100 | 282.95598349381 | 727 | 0 | 100 | 0 | 1 | 727 | 56164 | 55438 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 205709 | 1343 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 25282653 | 25282653 | PRJNA229468_S_NODE_20_length_915_cov_3.091224_g16_i0 | PRJNA229468 | 20 | 915 | 3.091224 | 28.2846996 | Cutibacterium | 1912216 | Bacteria | Bacteria | 1674 | 0 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g16 | i0 | 99.672 | 280.55737704918 | 915 | 3 | 100 | 0 | 1 | 915 | 56490 | 57404 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 256710 | 1674 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 27358639 | 27358639 | PRJNA229468_S_NODE_423_length_241_cov_1.088542_g410_i0 | PRJNA229468 | 423 | 241 | 1.088542 | 2.62338622 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 96.3 | 1.0100000000000002e-21 | NR | HXY94086.1 | 2080302 | g410 | i0 | 65 | 5.70124481327801 | 80 | 25 | 99.6 | 2 | 240 | 1 | 70 | 146 | HXY94086.1 SDR family NAD(P)-dependent oxidoreductase [Acidimicrobiia bacterium] | diamond | 1374 | 96.3 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 32128984 | 32128984 | PRJNA229468_S_NODE_998_length_170_cov_2.504132_g985_i0 | PRJNA229468 | 998 | 170 | 2.504132 | 4.2570244 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 63.5 | 6.67e-11 | NR | MDH5420796.1 | 2080302 | g985 | i0 | 52.9 | 0.9 | 51 | 24 | 90 | 0 | 169 | 17 | 20 | 70 | MDH5420796.1 SRPBCC family protein [Acidimicrobiia bacterium] | diamond | 153 | 63.5 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 32146594 | 32146594 | PRJNA229468_S_NODE_718_length_194_cov_1.406897_g705_i0 | PRJNA229468 | 718 | 194 | 1.406897 | 2.72938018 | FCB group | 1783270 | Bacteria | Bacteria | 58.9 | 4.09e-9 | NR | MET0802013.1 | 2900548 | g705 | i0 | 60.5 | 2.64432989690722 | 43 | 16 | 64.9 | 1 | 194 | 69 | 83 | 125 | MET0802013.1 SDR family NAD(P)-dependent oxidoreductase [Actinomycetota bacterium] | diamond | 513 | 59.3 | 0.993254637436762 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium |
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);;