RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA380416" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA380416 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
3624873 3624873 PRJNA380416_P_NODE_13883_length_161_cov_0.910714_g13736_i0 PRJNA380416 13883 161 0.910714 1.46624954 Geobacillus 129337 Bacteria Bacteria 298 1.56e-76   NTclustered gi|2529062746|gb|CP128458.1| 1422 g13736 i0 100 28 161 0 100 0 1 161 3271824 3271664 Geobacillus stearothermophilus strain EF60133 chromosome, complete genome blastn 4508 298 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus stearothermophilus
7452082 7452082 PRJNA380416_P_NODE_9766_length_182_cov_1.526316_g9619_i0 PRJNA380416 9766 182 1.526316 2.77789512 Lactobacillus 1578 Bacteria Bacteria 335 1.3699999999999997e-87   NTclustered gi|2096299657|gb|CP083392.1| 47770 g9619 i0 100 29.8351648351648 181 0 99 0 2 182 2130335 2130515 Lactobacillus crispatus strain Lc1226 chromosome, complete genome blastn 5430 335 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
8726807 8726807 PRJNA380416_P_NODE_11067_length_168_cov_1.705882_g10920_i0 PRJNA380416 11067 168 1.705882 2.86588176 Bacillales 1385 Bacteria Bacteria 311 2.11e-80   NTclustered gi|1469974|gb|U56472.1|BCU56472 47592 g10920 i0 100 1009.04166666667 168 0 100 0 1 168 263 96 Bacillus coniferum 23S ribosomal RNA gene, hypervariable region, partial sequence blastn 169519 311 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus coniferum
8726838 8726838 PRJNA380416_P_NODE_9987_length_180_cov_1.106870_g9840_i0 PRJNA380416 9987 180 1.10687 1.992366 Streptococcus 1301 Bacteria Bacteria 257 3.01e-64   NTclustered gi|1403385328|emb|LS483378.1| 1310 g9840 i0 92.778 368.522222222222 180 10 99 3 3 180 21964 21786 Streptococcus sobrinus strain NCTC12279 genome assembly, chromosome: 1 blastn 66334 259 0.992277992277992 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sobrinus
11880737 11880737 PRJNA380416_P_NODE_13370_length_162_cov_0.902655_g13223_i0 PRJNA380416 13370 162 0.902655 1.4623011 Anoxybacillus flavithermus 33934 Bacteria Bacteria 261 2.06e-65   NTclustered gi|1207877705|gb|CP021838.1| 33934 g13223 i0 99.306 0.888888888888889 144 1 89 0 1 144 23773 23630 Anoxybacillus flavithermus strain 52-1A chromosome, complete genome blastn 144 261 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacillus Anoxybacillus flavithermus
14430772 14430772 PRJNA380416_P_NODE_12972_length_163_cov_0.894737_g12825_i0 PRJNA380416 12972 163 0.894737 1.45842131 Lysinibacillus sp. PLM2 2929796 Bacteria Bacteria 302 1.22e-77   NTclustered gi|2215597311|dbj|AP025689.1| 2929796 g12825 i0 100 1 163 0 100 0 1 163 3385820 3385982 Lysinibacillus sp. PLM2 DNA, complete genome blastn 163 302 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus sp. PLM2
20200233 20200233 PRJNA380416_P_NODE_13416_length_162_cov_0.902655_g13269_i0 PRJNA380416 13416 162 0.902655 1.4623011 Lactiplantibacillus 2767842 Bacteria Bacteria 279 5.68e-71   NTclustered gi|1611638273|gb|CP033616.1| 1590 g13269 i0 100 93.2098765432099 151 0 93 0 1 151 689797 689947 Lactiplantibacillus plantarum strain J26 chromosome, complete genome blastn 15100 279 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
21475805 21475805 PRJNA380416_P_NODE_10057_length_179_cov_1.492308_g9910_i0 PRJNA380416 10057 179 1.492308 2.67123132 Streptococcus 1301 Bacteria Bacteria 327 2.25e-85   NTclustered gi|1140122741|gb|CP019562.1| 1303 g9910 i0 100 335.212290502793 177 0 99 0 3 179 1571343 1571519 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 60003 327 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
22750954 22750954 PRJNA380416_P_NODE_8218_length_199_cov_1.726667_g8071_i0 PRJNA380416 8218 199 1.726667 3.43606733 Streptococcus 1301 Bacteria Bacteria 363 7.019999999999998e-96   NTclustered gi|1578069334|emb|LR216032.1| 1313 g8071 i0 99.497 319 199 1 100 0 1 199 23745 23943 Streptococcus pneumoniae strain 2245STDY5775874 genome assembly, chromosome: 1 blastn 63481 363 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
25300351 25300351 PRJNA380416_P_NODE_8320_length_198_cov_1.328859_g8173_i0 PRJNA380416 8320 198 1.328859 2.63114082 root 1 Root_unresolved Root_unresolved 364 1.9399999999999995e-96   NTclustered gi|1140122741|gb|CP019562.1| 1303 g8173 i0 100 102.515151515152 197 0 99 0 2 198 1572662 1572858 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 20298 366 0.994535519125683 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis

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