RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1215813" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1215813 · 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
2882650 2882650 PRJNA1215813_P_NODE_12523_length_242_cov_0.923077_g12443_i0 PRJNA1215813 12523 242 0.923077 2.23384634 Christensenella sp. 1935934 Bacteria Bacteria 300 7.05e-77   NTclustered gi|2189457697|gb|CP091723.1| 1935934 g12443 i0 91.031 854.681818181818 223 19 92 1 19 240 544776 544554 MAG: Christensenella sp. isolate nC33_lr_bin.267.fa chromosome blastn 206833 300 1 Bacteria   Bacillati Bacillota Clostridia Christensenellales Christensenellaceae Christensenella Christensenella sp.
10535561 10535561 PRJNA1215813_P_NODE_12609_length_241_cov_2.321429_g12529_i0 PRJNA1215813 12609 241 2.321429 5.59464389 Clostridium cadaveris 1529 Bacteria Bacteria 71.3 5.99e-8   NTclustered gi|2154003691|gb|CP076620.1| 1529 g12529 i0 90.566 0.219917012448133 53 5 22 0 41 93 2478644 2478696 Clostridium cadaveris strain IFB3C5 chromosome, complete genome blastn 53 71.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium cadaveris
13085355 13085355 PRJNA1215813_P_NODE_11631_length_245_cov_0.906977_g11551_i0 PRJNA1215813 11631 245 0.906977 2.22209365 Brevibacillus brevis 1393 Bacteria Bacteria 52.8 0.022   NTclustered gi|1539922203|emb|LR134338.1| 1393 g11551 i0 100 0.228571428571429 28 0 11 0 152 179 2323372 2323345 Brevibacillus brevis strain NCTC2611 genome assembly, chromosome: 1 blastn 56 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus brevis
15073409 15073409 PRJNA1215813_P_NODE_10832_length_248_cov_0.891429_g10752_i0 PRJNA1215813 10832 248 0.891429 2.21074392 root 1 Root_unresolved Root_unresolved 459 1.13e-124   NTclustered gi|1663099664|gb|CP039167.1| 1280 g10752 i0 100 100 248 0 100 0 1 248 2842784 2843031 Staphylococcus aureus strain R50 chromosome, complete genome blastn 24800 459 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
16348311 16348311 PRJNA1215813_P_NODE_8233_length_273_cov_1.465000_g8153_i0 PRJNA1215813 8233 273 1.465 3.99945 root 1 Root_unresolved Root_unresolved 488 1.6099999999999996e-133   NTclustered gi|2484084529|gb|CP121497.1| 1282 g8153 i0 98.901 152 273 3 100 0 1 273 896904 897176 Staphylococcus epidermidis strain 24FSE04 chromosome, complete genome blastn 41496 488 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
24557935 24557935 PRJNA1215813_P_NODE_4420_length_364_cov_2.000000_g4340_i0 PRJNA1215813 4420 364 2 7.28 Fictibacillus sp. KU28468 2991053 Bacteria Bacteria 52.8 0.035   NTclustered gi|2328448629|gb|CP110666.1| 2991053 g4340 i0 100 0.0769230769230769 28 0 8 0 288 315 3334048 3334075 Fictibacillus sp. KU28468 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Fictibacillaceae Fictibacillus Fictibacillus sp. KU28468
24558021 24558021 PRJNA1215813_P_NODE_9760_length_252_cov_0.871508_g9680_i0 PRJNA1215813 9760 252 0.871508 2.19620016 Laceyella sacchari 37482 Bacteria Bacteria 335 2.0299999999999998e-87   NTclustered gi|2294964232|gb|CP103866.1| 37482 g9680 i0 90.8 767.531746031746 250 23 99 0 1 250 114066 113817 Laceyella sacchari strain FBKL4.014 chromosome, complete genome blastn 193418 335 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Laceyella Laceyella sacchari

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