contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA981359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2237792 | 2237792 | PRJNA981359_S_NODE_38642_length_305_cov_3.448276_g38542_i0 | PRJNA981359 | 38642 | 305 | 3.448276 | 10.5172418 | Corynebacterium appendicis | 163202 | Bacteria | Bacteria | 521 | 1.8e-143 | NTclustered | gi|2531255973|gb|CP046976.1| | 1161099 | g38542 | i0 | 97.394 | 444.445901639344 | 307 | 6 | 100 | 1 | 1 | 305 | 586782 | 587088 | Corynebacterium appendicis CIP 107643 chromosome, complete genome | blastn | 135556 | 521 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium appendicis | ||
| 2237973 | 2237973 | PRJNA981359_S_NODE_45342_length_290_cov_3.073733_g45242_i0 | PRJNA981359 | 45342 | 290 | 3.073733 | 8.9138257 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 496 | 1.03e-135 | NTclustered | gi|1723592958|emb|LR584267.1| | 1528099 | g45242 | i0 | 97.578 | 225.3 | 289 | 7 | 99 | 0 | 2 | 290 | 553543 | 553255 | Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1 | blastn | 65337 | 496 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 2238285 | 2238285 | PRJNA981359_S_NODE_57682_length_265_cov_2.880208_g57582_i0 | PRJNA981359 | 57682 | 265 | 2.880208 | 7.6325512 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 473 | 4.3599999999999987e-129 | NTclustered | gi|1723592958|emb|LR584267.1| | 1528099 | g57582 | i0 | 98.868 | 290.192452830189 | 265 | 3 | 100 | 0 | 1 | 265 | 553567 | 553303 | Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1 | blastn | 76901 | 473 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 5099127 | 5099127 | PRJNA981359_S_NODE_40324_length_301_cov_7.833333_g40224_i0 | PRJNA981359 | 40324 | 301 | 7.833333 | 23.57833233 | Cutibacterium | 1912216 | Bacteria | Bacteria | 556 | 4.87e-154 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g40224 | i0 | 100 | 263.461794019934 | 301 | 0 | 100 | 0 | 1 | 301 | 55805 | 55505 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 79302 | 556 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 11474511 | 11474511 | PRJNA981359_S_NODE_2549_length_605_cov_2.646617_g2454_i0 | PRJNA981359 | 2549 | 605 | 2.646617 | 16.01203285 | Corynebacterium | 1716 | Bacteria | Bacteria | 861 | 0 | NTclustered | gi|2547417233|gb|CP073096.1| | 38304 | g2454 | i0 | 92.422 | 372.333884297521 | 607 | 41 | 100 | 5 | 1 | 605 | 789191 | 789794 | Corynebacterium tuberculostearicum strain CTNIH20 chromosome, complete genome | blastn | 225262 | 861 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium tuberculostearicum | ||
| 11474563 | 11474563 | PRJNA981359_S_NODE_73929_length_240_cov_2.335329_g73829_i0 | PRJNA981359 | 73929 | 240 | 2.335329 | 5.6047896 | Propionibacteriaceae | 31957 | Bacteria | Bacteria | 383 | 6.74e-102 | NTclustered | gi|1086063565|emb|LT629799.1| | 546874 | g73829 | i0 | 95.798 | 317.170833333333 | 238 | 9 | 99 | 1 | 1 | 238 | 1044511 | 1044747 | Friedmanniella sagamiharensis strain DSM 21743 genome assembly, chromosome: I | blastn | 76121 | 385 | 0.994805194805195 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Microlunatus | Microlunatus sagamiharensis | ||
| 14990076 | 14990076 | PRJNA981359_S_NODE_27672_length_334_cov_2.747126_g27572_i0 | PRJNA981359 | 27672 | 334 | 2.747126 | 9.17540084 | Corynebacterium marquesiae | 2913503 | Bacteria | Bacteria | 584 | 2.509999999999999e-162 | NTclustered | gi|2869822234|gb|CP175776.1| | 2913503 | g27572 | i0 | 98.209 | 374.236526946108 | 335 | 5 | 100 | 1 | 1 | 334 | 1954902 | 1954568 | Corynebacterium marquesiae strain YSMAA3_1_G3 chromosome, complete genome | blastn | 124995 | 584 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium marquesiae | ||
| 17539959 | 17539959 | PRJNA981359_S_NODE_24634_length_343_cov_4.444444_g24534_i0 | PRJNA981359 | 24634 | 343 | 4.444444 | 15.24444292 | Corynebacterium accolens | 38284 | Bacteria | Bacteria | 634 | 2.5299999999999996e-177 | NTclustered | gi|2550468567|gb|CP100375.1| | 38284 | g24534 | i0 | 100 | 349.166180758018 | 343 | 0 | 100 | 0 | 1 | 343 | 2492486 | 2492828 | Corynebacterium accolens strain CA8 chromosome | blastn | 119764 | 634 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium accolens | ||
| 17848463 | 17848463 | PRJNA981359_S_NODE_76054_length_230_cov_2.484076_g75954_i0 | PRJNA981359 | 76054 | 230 | 2.484076 | 5.7133748 | Cutibacterium | 1912216 | Bacteria | Bacteria | 425 | 1.05e-114 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g75954 | i0 | 100 | 267.947826086957 | 230 | 0 | 100 | 0 | 1 | 230 | 56237 | 56466 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 61628 | 425 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 21364450 | 21364450 | PRJNA981359_S_NODE_33737_length_317_cov_3.655738_g33637_i0 | PRJNA981359 | 33737 | 317 | 3.655738 | 11.58868946 | Corynebacterium coyleae | 53374 | Bacteria | Bacteria | 468 | 2.49e-127 | NTclustered | gi|2058472593|gb|CP077302.1| | 53374 | g33637 | i0 | 93.375 | 357.350157728707 | 317 | 20 | 99 | 1 | 2 | 317 | 501790 | 501474 | Corynebacterium coyleae strain FDAARGOS 1425 chromosome, complete genome | blastn | 113280 | 468 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium coyleae | ||
| 22948553 | 22948553 | PRJNA981359_S_NODE_29278_length_329_cov_3.687500_g29178_i0 | PRJNA981359 | 29278 | 329 | 3.6875 | 12.131875 | Micrococcales | 85006 | Bacteria | Bacteria | 608 | 1.4599999999999995e-169 | NTclustered | gi|2528150176|gb|CP128474.1| | 33883 | g29178 | i0 | 100 | 170.987841945289 | 329 | 0 | 100 | 0 | 1 | 329 | 2056468 | 2056140 | Microbacterium arborescens strain SSF12 chromosome, complete genome | blastn | 56255 | 608 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium arborescens |
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);;