RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA699078" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA699078 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1184124 1184124 PRJNA699078_S_NODE_49241_length_244_cov_1.579487_g48292_i0 PRJNA699078 49241 244 1.579487 3.85394828 Cutibacterium 1912216 Bacteria Bacteria 451 1.86e-122   NTclustered gi|1446500593|gb|CP031442.1| 1747 g48292 i0 100 287.549180327869 244 0 100 0 1 244 55726 55969 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 70162 451 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
3735915 3735915 PRJNA699078_S_NODE_67243_length_206_cov_0.993631_g66294_i0 PRJNA699078 67243 206 0.993631 2.04687986 Brevibacterium 1696 Bacteria Bacteria 381 2.0199999999999994e-101   NTclustered gi|1943100173|gb|CP065629.1| 33889 g66294 i0 100 346.058252427184 206 0 100 0 1 206 599203 599408 Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome blastn 71288 381 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium casei
5786262 5786262 PRJNA699078_S_NODE_78165_length_190_cov_1.446809_g77216_i0 PRJNA699078 78165 190 1.446809 2.7489371 Brevibacterium casei 33889 Bacteria Bacteria 351 1.4399999999999997e-92   NTclustered gi|1943100173|gb|CP065629.1| 33889 g77216 i0 100 342.031578947368 190 0 100 0 1 190 598410 598599 Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome blastn 64986 351 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium casei
11387693 11387693 PRJNA699078_S_NODE_70169_length_201_cov_1.638158_g69220_i0 PRJNA699078 70169 201 1.638158 3.29269758 Cutibacterium 1912216 Bacteria Bacteria 372 1.18e-98   NTclustered gi|1446500593|gb|CP031442.1| 1747 g69220 i0 100 209.164179104478 201 0 100 0 1 201 56946 57146 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 42042 372 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
11387698 11387698 PRJNA699078_S_NODE_92049_length_174_cov_1.408000_g91100_i0 PRJNA699078 92049 174 1.408 2.44992 Kocuria 57493 Bacteria Bacteria 322 1.01e-83   NTclustered gi|923033569|gb|CP012507.1| 71999 g91100 i0 100 297.551724137931 174 0 100 0 1 174 219838 219665 Kocuria palustris strain MU14/1, complete genome blastn 51774 322 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria palustris
12663605 12663605 PRJNA699078_S_NODE_32070_length_305_cov_1.355469_g31121_i0 PRJNA699078 32070 305 1.355469 4.13418045 Cutibacterium 1912216 Bacteria Bacteria 518 2.33e-142   NTclustered gi|1446500593|gb|CP031442.1| 1747 g31121 i0 100 246.255737704918 280 0 92 0 1 280 56493 56214 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 75108 518 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
17259518 17259518 PRJNA699078_S_NODE_101494_length_166_cov_1.333333_g100545_i0 PRJNA699078 101494 166 1.333333 2.21333278 Aeromicrobium chenweiae 2079793 Bacteria Bacteria 67.6 4.96e-7   NTclustered gi|1380481754|gb|CP026952.1| 2079793 g100545 i0 95.238 0.427710843373494 42 2 25 0 7 48 1343662 1343703 Aeromicrobium chenweiae strain 592 chromosome, complete genome blastn 71 67.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Aeromicrobium Aeromicrobium chenweiae
20310424 20310424 PRJNA699078_S_NODE_105496_length_163_cov_2.771930_g104547_i0 PRJNA699078 105496 163 2.77193 4.5182459 Cutibacterium 1912216 Bacteria Bacteria 302 1.22e-77   NTclustered gi|1446500593|gb|CP031442.1| 1747 g104547 i0 100 256.159509202454 163 0 100 0 1 163 55547 55709 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 41754 302 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes

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