RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA641991" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA641991 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
2433554 2433554 PRJNA641991_S_NODE_7662_length_201_cov_1.000000_g7543_i0 PRJNA641991 7662 201 1 2.01 Brevibacillus 55080 Bacteria Bacteria 248 2.08e-61   NTclustered gi|507148245|ref|NR_103052.1| 1393 g7543 i0 90.476 1009.2039800995 189 16 94 2 1 188 769 956 Brevibacillus brevis strain 47 23S ribosomal RNA gene, complete sequence blastn 202850 248 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus brevis
8811329 8811329 PRJNA641991_S_NODE_2527_length_330_cov_2.548043_g2408_i0 PRJNA641991 2527 330 2.548043 8.4085419 Streptococcus 1301 Bacteria Bacteria 610 4.09e-170   NTclustered gi|1782758915|gb|CP018189.1| 1304 g2408 i0 100 626.575757575758 330 0 100 0 1 330 17847 17518 Streptococcus salivarius strain ICDC3 chromosome, complete genome blastn 206770 610 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus salivarius
10821962 10821962 PRJNA641991_P_NODE_3549_length_165_cov_0.879310_g3508_i0 PRJNA641991 3549 165 0.87931 1.4508615 Staphylococcus haemolyticus 1283 Bacteria Bacteria 305 9.59e-79   NTclustered gi|2851146212|gb|CP085027.1| 1283 g3508 i0 100 41.6181818181818 165 0 100 0 1 165 1645411 1645247 Staphylococcus haemolyticus strain SLM-175 chromosome, complete genome blastn 6867 305 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus haemolyticus
16461198 16461198 PRJNA641991_S_NODE_14713_length_161_cov_0.910714_g14594_i0 PRJNA641991 14713 161 0.910714 1.46624954 Streptococcus 1301 Bacteria Bacteria 298 1.56e-76   NTclustered gi|1403302629|emb|LS483342.1| 1311 g14594 i0 100 100 161 0 100 0 1 161 656016 655856 Streptococcus agalactiae strain NCTC11930 genome assembly, chromosome: 1 blastn 16100 298 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
17736308 17736308 PRJNA641991_S_NODE_11574_length_169_cov_1.275000_g11455_i0 PRJNA641991 11574 169 1.275 2.15475 Streptococcus 1301 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|1403302629|emb|LS483342.1| 1311 g11455 i0 100 634 169 0 100 0 1 169 19715 19883 Streptococcus agalactiae strain NCTC11930 genome assembly, chromosome: 1 blastn 107146 313 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
18470018 18470018 PRJNA641991_S_NODE_2135_length_359_cov_1.645161_g2016_i0 PRJNA641991 2135 359 1.645161 5.90612799 Streptococcus porcinus 1340 Bacteria Bacteria 52.8 0.034   NTclustered gi|1988318085|gb|CP070236.1| 1340 g2016 i0 100 0.467966573816156 28 0 8 0 20 47 1207591 1207564 Streptococcus porcinus strain Colony573 chromosome blastn 168 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus porcinus
20284800 20284800 PRJNA641991_S_NODE_13816_length_163_cov_0.894737_g13697_i0 PRJNA641991 13816 163 0.894737 1.45842131 Streptococcus 1301 Bacteria Bacteria 302 1.22e-77   NTclustered gi|909815781|gb|CP011327.1| 1311 g13697 i0 100 126.134969325153 163 0 100 0 1 163 605322 605160 Streptococcus agalactiae strain GX064 genome blastn 20560 302 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
25384773 25384773 PRJNA641991_S_NODE_12820_length_165_cov_1.181034_g12701_i0 PRJNA641991 12820 165 1.181034 1.9487061 Streptococcus 1301 Bacteria Bacteria 305 9.59e-79   NTclustered gi|1403302629|emb|LS483342.1| 1311 g12701 i0 100 633.030303030303 165 0 100 0 1 165 19466 19302 Streptococcus agalactiae strain NCTC11930 genome assembly, chromosome: 1 blastn 104450 305 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
25384786 25384786 PRJNA641991_S_NODE_8840_length_189_cov_1.685714_g8721_i0 PRJNA641991 8840 189 1.685714 3.18599946 Streptococcus 1301 Bacteria Bacteria 313 6.74e-81   NTclustered gi|2746253929|gb|PP939747.1| 1306 g8721 i0 100 263.783068783069 169 0 89 0 21 189 191 23 Streptococcus sp. strain 1-4 16S ribosomal RNA gene, partial sequence blastn 49855 313 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp.

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