RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1087264" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1087264 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
1468629 1468629 PRJNA1087264_P_NODE_1282_length_588_cov_2.463822_g1208_i0 PRJNA1087264 1282 588 2.463822 14.48727336 Vagococcus fluvialis 2738 Bacteria Bacteria 56.5 0.004   NTclustered gi|2124557331|gb|CP081470.1| 2738 g1208 i0 94.444 0.110544217687075 36 2 6 0 332 367 1032844 1032809 Vagococcus fluvialis strain 25B2 chromosome, complete genome blastn 65 56.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Vagococcus Vagococcus fluvialis
2292809 2292809 PRJNA1087264_P_NODE_7562_length_229_cov_1.383333_g7480_i0 PRJNA1087264 7562 229 1.383333 3.16783257 Streptococcus 1301 Bacteria Bacteria 424 3.76e-114   NTclustered gi|1140122741|gb|CP019562.1| 1303 g7480 i0 100 325 229 0 100 0 1 229 1570390 1570618 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 74425 424 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
5296818 5296818 PRJNA1087264_P_NODE_19085_length_163_cov_0.894737_g19003_i0 PRJNA1087264 19085 163 0.894737 1.45842131 Staphylococcus pasteuri 45972 Bacteria Bacteria 263 5.77e-66   NTclustered gi|2384814837|gb|CP088929.1| 45972 g19003 i0 95.706 1.28834355828221 163 7 100 0 1 163 81 243 Staphylococcus pasteuri strain PPE011 plasmid pSPPPE011_2, complete sequence blastn 210 263 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus pasteuri
9121656 9121656 PRJNA1087264_P_NODE_18048_length_164_cov_0.886957_g17966_i0 PRJNA1087264 18048 164 0.886957 1.45460948 Bacillus sp. PAMC26568 2760090 Bacteria Bacteria 276 7.46e-70   NTclustered gi|1893059056|gb|CP060137.1| 2760090 g17966 i0 96.951 2 164 5 100 0 1 164 259462 259299 Bacillus sp. PAMC26568 chromosome, complete genome blastn 328 276 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. PAMC26568
12496236 12496236 PRJNA1087264_P_NODE_12450_length_179_cov_1.176923_g12368_i0 PRJNA1087264 12450 179 1.176923 2.10669217 Bacteria 2 Bacteria Bacteria 331 1.74e-86   NTclustered gi|1226527036|gb|MF578766.1| 1283 g12368 i0 100 118 179 0 100 0 1 179 279 101 Staphylococcus haemolyticus strain K1 16S ribosomal RNA gene, partial sequence blastn 21122 331 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus haemolyticus
15496648 15496648 PRJNA1087264_P_NODE_11713_length_184_cov_1.466667_g11631_i0 PRJNA1087264 11713 184 1.466667 2.69866728 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 313 6.52e-81   NTclustered gi|2319007379|gb|CP107199.1| 1898203 g11631 i0 97.283 406.5 184 5 100 0 1 184 655475 655658 MAG: Lachnospiraceae bacterium isolate KR001_HIC_0035 chromosome, complete genome blastn 74796 313 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
16770974 16770974 PRJNA1087264_P_NODE_14834_length_167_cov_0.864407_g14752_i0 PRJNA1087264 14834 167 0.864407 1.44355969 Bacillus sp. PAMC26568 2760090 Bacteria Bacteria 303 3.5e-78   NTclustered gi|1893059056|gb|CP060137.1| 2760090 g14752 i0 99.401 71.0179640718563 167 1 100 0 1 167 3850484 3850318 Bacillus sp. PAMC26568 chromosome, complete genome blastn 11860 303 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. PAMC26568
17595243 17595243 PRJNA1087264_P_NODE_7554_length_229_cov_1.427778_g7472_i0 PRJNA1087264 7554 229 1.427778 3.26961162 root 1 Root_unresolved Root_unresolved 424 3.76e-114   NTclustered gi|1796975023|gb|CP033086.1| 1280 g7472 i0 100 30.296943231441 229 0 100 0 1 229 2428176 2427948 Staphylococcus aureus strain WH9628 chromosome blastn 6938 424 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
19319731 19319731 PRJNA1087264_P_NODE_11816_length_183_cov_1.902985_g11734_i0 PRJNA1087264 11816 183 1.902985 3.48246255 Bacillus sp. A01H 3026426 Bacteria Bacteria 62.1 2.59e-5   NTclustered gi|2809046828|gb|CP117703.1| 3026426 g11734 i0 100 9.86885245901639 33 0 18 0 113 145 8716 8748 Bacillus sp. A01H plasmid pA01H_1, complete sequence blastn 1806 62.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. A01H
19319765 19319765 PRJNA1087264_P_NODE_17096_length_165_cov_0.879310_g17014_i0 PRJNA1087264 17096 165 0.87931 1.4508615 Paenibacillus sp. RUD330 2023772 Bacteria Bacteria 294 2.08e-75   NTclustered gi|1811927197|gb|CP022655.2| 2023772 g17014 i0 98.788 1 165 2 100 0 1 165 2744864 2744700 Paenibacillus sp. RUD330 chromosome, complete genome blastn 165 294 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. RUD330
20595169 20595169 PRJNA1087264_P_NODE_7317_length_233_cov_1.239130_g7235_i0 PRJNA1087264 7317 233 1.23913 2.8871729 Terrilactibacillus sp. S3-3 2969846 Bacteria Bacteria 56.5 0.002   NTclustered gi|2533273496|gb|CP129291.1| 2969846 g7235 i0 90.476 0.360515021459227 42 4 18 0 11 52 2101342 2101301 Terrilactibacillus sp. S3-3 chromosome, complete genome blastn 84 56.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Terrilactibacillus Terrilactibacillus sp. S3-3
21870836 21870836 PRJNA1087264_P_NODE_15778_length_166_cov_0.871795_g15696_i0 PRJNA1087264 15778 166 0.871795 1.4471797 Paenibacillus sp. RUD330 2023772 Bacteria Bacteria 307 2.69e-79   NTclustered gi|1811927197|gb|CP022655.2| 2023772 g15696 i0 100 1 166 0 100 0 1 166 795733 795898 Paenibacillus sp. RUD330 chromosome, complete genome blastn 166 307 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. RUD330
21870850 21870850 PRJNA1087264_P_NODE_18258_length_164_cov_0.886957_g18176_i0 PRJNA1087264 18258 164 0.886957 1.45460948 Staphylococcus epidermidis 1282 Bacteria Bacteria 298 1.59e-76   NTclustered gi|2536852070|gb|CP129374.1| 1282 g18176 i0 99.39 100 164 1 100 0 1 164 607761 607598 Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome blastn 16400 298 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
23146216 23146216 PRJNA1087264_P_NODE_15899_length_166_cov_0.871795_g15817_i0 PRJNA1087264 15899 166 0.871795 1.4471797 Bacillus sp. PAMC26568 2760090 Bacteria Bacteria 307 2.69e-79   NTclustered gi|1893059056|gb|CP060137.1| 2760090 g15817 i0 100 98.8674698795181 166 0 100 0 1 166 440437 440602 Bacillus sp. PAMC26568 chromosome, complete genome blastn 16412 307 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. PAMC26568
24419853 24419853 PRJNA1087264_P_NODE_15660_length_166_cov_0.871795_g15578_i0 PRJNA1087264 15660 166 0.871795 1.4471797 Bacillus sp. PAMC26568 2760090 Bacteria Bacteria 307 2.69e-79   NTclustered gi|1893059056|gb|CP060137.1| 2760090 g15578 i0 100 1 166 0 100 0 1 166 2466057 2466222 Bacillus sp. PAMC26568 chromosome, complete genome blastn 166 307 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. PAMC26568

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