RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1082072" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1082072 · 7 ✖

analysis 1

  • blastn · 7 ✖

tax_clade 0

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
1017107 1017107 PRJNA1082072_P_NODE_1901_length_262_cov_1.629630_g1894_i0 PRJNA1082072 1901 262 1.62963 4.2696306 Cutibacterium 1912216 Bacteria Bacteria 401 2.0599999999999992e-107   NTclustered gi|1446500593|gb|CP031442.1| 1747 g1894 i0 99.545 53.7442748091603 220 1 100 0 1 220 357240 357459 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 14081 401 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
4019747 4019747 PRJNA1082072_P_NODE_1844_length_266_cov_1.259067_g1837_i0 PRJNA1082072 1844 266 1.259067 3.34911822 Corynebacterium ureicelerivorans 401472 Bacteria Bacteria 472 1.5799999999999998e-128   NTclustered gi|675824235|gb|CP009215.1| 401472 g1837 i0 98.496 345.082706766917 266 3 100 1 1 266 625172 624908 Corynebacterium ureicelerivorans strain IMMIB RIV-2301, complete genome blastn 91792 472 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium ureicelerivorans
4845271 4845271 PRJNA1082072_P_NODE_2064_length_251_cov_0.865169_g2057_i0 PRJNA1082072 2064 251 0.865169 2.17157419 Cutibacterium 1912216 Bacteria Bacteria 464 2.47e-126   NTclustered gi|1446500593|gb|CP031442.1| 1747 g2057 i0 100 53 251 0 100 0 1 251 409447 409197 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 13303 464 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
5295976 5295976 PRJNA1082072_P_NODE_2885_length_242_cov_0.911243_g2878_i0 PRJNA1082072 2885 242 0.911243 2.20520806 Corynebacterium ureicelerivorans 401472 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|675824235|gb|CP009215.1| 401472 g2878 i0 100 454.632231404959 242 0 100 0 1 242 627202 627443 Corynebacterium ureicelerivorans strain IMMIB RIV-2301, complete genome blastn 110021 448 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium ureicelerivorans
9120809 9120809 PRJNA1082072_P_NODE_2928_length_241_cov_0.916667_g2921_i0 PRJNA1082072 2928 241 0.916667 2.20916747 Corynebacterium lujinxingii 2763010 Bacteria Bacteria 407 4.0199999999999995e-109   NTclustered gi|1899778044|gb|CP061032.1| 2763010 g2921 i0 97.095 1.82157676348548 241 7 100 0 1 241 50694 50934 Corynebacterium lujinxingii strain zg-917 chromosome, complete genome blastn 439 407 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium lujinxingii
23145361 23145361 PRJNA1082072_P_NODE_1799_length_269_cov_1.178571_g1792_i0 PRJNA1082072 1799 269 1.178571 3.17035599 Rhodococcoides fascians 1828 Bacteria Bacteria 54.7 0.007   NTclustered gi|2637134465|gb|CP140264.1| 1828 g1792 i0 100 0.107806691449814 29 0 11 0 173 201 3320803 3320775 Rhodococcoides fascians strain GS01 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcoides Rhodococcoides fascians
23969616 23969616 PRJNA1082072_P_NODE_2699_length_244_cov_0.900585_g2692_i0 PRJNA1082072 2699 244 0.900585 2.1974274 Kocuria 57493 Bacteria Bacteria 446 8.639999999999999e-121   NTclustered gi|1678593041|gb|CP035103.1| 1275 g2692 i0 99.59 350.545081967213 244 1 100 0 1 244 2499330 2499087 Kocuria rosea strain ATCC 186 chromosome, complete genome blastn 85533 446 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria rosea

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;