RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA450343", tax_kingdom = "Bacillati" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 23 ✖

tax_kingdom 1

  • Bacillati · 23 ✖

bioproject 1

  • PRJNA450343 · 23 ✖

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
1092513 1092513 PRJNA450343_P_NODE_4221_length_258_cov_2.488038_g4153_i0 PRJNA450343 4221 258 2.488038 6.41913804 Streptococcus 1301 Bacteria Bacteria 475 1.1799999999999999e-129   NTclustered gi|1403375826|emb|LS483375.1| 1302 g4153 i0 100 325.732558139535 257 0 99 0 2 258 625488 625232 Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1 blastn 84039 475 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus gordonii
3643528 3643528 PRJNA450343_P_NODE_4103_length_262_cov_3.089202_g4035_i0 PRJNA450343 4103 262 3.089202 8.09370924 Streptococcus 1301 Bacteria Bacteria 484 1.99e-132   NTclustered gi|1140122741|gb|CP019562.1| 1303 g4035 i0 100 342.290076335878 262 0 100 0 1 262 1568714 1568975 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 89680 484 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
4266057 4266057 PRJNA450343_P_NODE_14004_length_161_cov_0.910714_g13936_i0 PRJNA450343 14004 161 0.910714 1.46624954 Staphylococcus lloydii 2781774 Bacteria Bacteria 287 3.37e-73   NTclustered gi|1940089751|gb|CP064056.1| 2781774 g13936 i0 98.758 2 161 2 100 0 1 161 1911639 1911799 Staphylococcus lloydii strain 23_2_7_LY chromosome, complete genome blastn 322 287 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus lloydii
8745487 8745487 PRJNA450343_P_NODE_13267_length_162_cov_0.902655_g13199_i0 PRJNA450343 13267 162 0.902655 1.4623011 Exiguobacterium 33986 Bacteria Bacteria 294 2.03e-75   NTclustered gi|1735050952|gb|CP030931.1| 41170 g13199 i0 99.383 231.061728395062 162 1 100 0 1 162 475484 475645 Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome blastn 37432 294 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium Exiguobacterium acetylicum
9366937 9366937 PRJNA450343_P_NODE_10268_length_170_cov_0.900826_g10200_i0 PRJNA450343 10268 170 0.900826 1.5314042 Bacillus mojavensis 72360 Bacteria Bacteria 52.8 0.014   NTclustered gi|2522078538|gb|CP127833.1| 72360 g10200 i0 100 0.164705882352941 28 0 16 0 14 41 202311 202338 Bacillus mojavensis strain KRS009 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus mojavensis
11917749 11917749 PRJNA450343_P_NODE_10550_length_167_cov_1.728814_g10482_i0 PRJNA450343 10550 167 1.728814 2.88711938 Gemella haemolysans 1379 Bacteria Bacteria 303 3.5e-78   NTclustered gi|1540173839|emb|LR134484.1| 1379 g10482 i0 99.401 296.634730538922 167 1 100 0 1 167 11010 10844 Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1 blastn 49538 303 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
11917791 11917791 PRJNA450343_P_NODE_2910_length_315_cov_3.270677_g2842_i0 PRJNA450343 2910 315 3.270677 10.30263255 Streptococcus mitis 28037 Bacteria Bacteria 577 3.9299999999999986e-160   NTclustered gi|1894799594|dbj|AP023349.1| 28037 g2842 i0 99.683 337.984126984127 315 1 100 0 1 315 1849149 1848835 Streptococcus mitis Nm-65 DNA, complete genome blastn 106465 577 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
13846041 13846041 PRJNA450343_P_NODE_711_length_677_cov_2.041401_g655_i0 PRJNA450343 711 677 2.041401 13.82028477 Bacillales 1385 Bacteria Bacteria 1127 0   NTclustered gi|1784319663|gb|CP045137.2| 1283 g655 i0 96.522 481.825701624815 690 9 100 4 1 677 2511361 2510674 Staphylococcus haemolyticus strain VB5326 chromosome, complete genome blastn 326196 1127 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus haemolyticus
14467724 14467724 PRJNA450343_P_NODE_8512_length_186_cov_1.489051_g8444_i0 PRJNA450343 8512 186 1.489051 2.76963486 Terribacillus aidingensis 586416 Bacteria Bacteria 56.5 0.001   NTclustered gi|2766236627|gb|CP159996.1| 586416 g8444 i0 100 0.161290322580645 30 0 16 0 11 40 1731566 1731537 Terribacillus aidingensis strain AR507 chromosome blastn 30 56.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Terribacillus Terribacillus aidingensis
17016361 17016361 PRJNA450343_P_NODE_3174_length_301_cov_1.992063_g3106_i0 PRJNA450343 3174 301 1.992063 5.99610963 Staphylococcus lloydii 2781774 Bacteria Bacteria 540 4.899999999999999e-149   NTclustered gi|1940089751|gb|CP064056.1| 2781774 g3106 i0 99.003 530.584717607973 301 3 100 0 1 301 813205 812905 Staphylococcus lloydii strain 23_2_7_LY chromosome, complete genome blastn 159706 540 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus lloydii
19564824 19564824 PRJNA450343_P_NODE_12256_length_164_cov_0.886957_g12188_i0 PRJNA450343 12256 164 0.886957 1.45460948 uncultured Anaeropeptidivorans sp. 2997364 Bacteria Bacteria 172 1.0099999999999999e-38   NTclustered gi|2817958208|gb|PQ455366.1| 2997364 g12188 i0 86.061 125.90243902439 165 18 100 4 1 164 55 215 Uncultured Anaeropeptidivorans sp. clone d 23S ribosomal RNA gene, partial sequence blastn 20648 172 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Anaeropeptidivorans uncultured Anaeropeptidivorans sp.
22769440 22769440 PRJNA450343_P_NODE_11238_length_166_cov_0.871795_g11170_i0 PRJNA450343 11238 166 0.871795 1.4471797 Veillonella 29465 Bacteria Bacteria 272 9.8e-69   NTclustered gi|2672138803|gb|CP138632.1| 29466 g11170 i0 96.364 551.867469879518 165 6 99 0 1 165 1075 1239 Veillonella parvula strain PK1910 chromosome, complete genome blastn 91610 272 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella parvula
24044353 24044353 PRJNA450343_P_NODE_10639_length_167_cov_1.144068_g10571_i0 PRJNA450343 10639 167 1.144068 1.91059356 Streptococcus 1301 Bacteria Bacteria 309 7.53e-80   NTclustered gi|285801502|gb|GU411484.1| 28037 g10571 i0 100 100 167 0 100 0 1 167 291 125 Streptococcus mitis clone LA030 16S ribosomal RNA gene, partial sequence blastn 16700 309 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
24044358 24044358 PRJNA450343_P_NODE_13959_length_161_cov_0.910714_g13891_i0 PRJNA450343 13959 161 0.910714 1.46624954 Staphylococcus 1279 Bacteria Bacteria 298 1.56e-76   NTclustered gi|2624851299|gb|CP120073.1| 29385 g13891 i0 100 53.1242236024845 161 0 100 0 1 161 2362612 2362452 Staphylococcus saprophyticus strain Dog122 chromosome, complete genome blastn 8553 298 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus saprophyticus
26902670 26902670 PRJNA450343_P_NODE_6381_length_212_cov_0.871166_g6313_i0 PRJNA450343 6381 212 0.871166 1.84687192 Bacillota 1239 Bacteria Bacteria 45.8 0.00148   NR WP_207635140.1 73919 g6313 i0 46.8 2.25 47 21 66.5 1 3 143 39 81 WP_207635140.1 DoxX family protein [Thermaerobacter marianensis] diamond 477 46.2 0.991341991341991 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiales Family XVII. Incertae Sedis Thermaerobacter Thermaerobacter marianensis
27076066 27076066 PRJNA450343_P_NODE_12362_length_164_cov_0.886957_g12294_i0 PRJNA450343 12362 164 0.886957 1.45460948 Clostridiales bacterium 1898207 Bacteria Bacteria 40.4 0.0418   NR MBE7082886.1 1898207 g12294 i0 47.4 0.695121951219512 38 19 67.7 1 147 37 47 84 MBE7082886.1 DUF4363 family protein [Clostridiales bacterium] diamond 114 40.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
27202314 27202314 PRJNA450343_P_NODE_9322_length_179_cov_0.969231_g9254_i0 PRJNA450343 9322 179 0.969231 1.73492349 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 43.1 0.0116   NR MBP3519882.1 2485925 g9254 i0 33.3 0.905027932960894 54 30 85.5 2 9 161 296 346 MBP3519882.1 hypothetical protein [Oscillospiraceae bacterium] diamond 162 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
27976686 27976686 PRJNA450343_P_NODE_11145_length_166_cov_1.230769_g11077_i0 PRJNA450343 11145 166 1.230769 2.04307654 root 1 Root_unresolved Root_unresolved 96.7 8.28e-22   NR WP_147358145.1 29363 g11077 i0 92.5 15.289156626506 53 4 95.8 0 164 6 299 351 WP_147358145.1 hypothetical protein, partial [Clostridium paraputrificum] diamond 2538 97.1 0.995880535530381 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium paraputrificum
29633492 29633492 PRJNA450343_P_NODE_7470_length_197_cov_2.425676_g7402_i0 PRJNA450343 7470 197 2.425676 4.77858172 Parageobacillus thermoglucosidasius 1426 Bacteria Bacteria 106 3.44e-28   NR WP_338206249.1 1426 g7402 i0 95 17.3604060913706 60 3 91.4 0 196 17 2 61 WP_338206249.1 cytochrome c oxidase subunit II transmembrane domain-containing protein, partial [Parageobacillus thermoglucosidasius] diamond 3420 107 0.990654205607477 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Parageobacillus Parageobacillus thermoglucosidasius
30581372 30581372 PRJNA450343_P_NODE_6713_length_207_cov_0.968354_g6645_i0 PRJNA450343 6713 207 0.968354 2.00449278 Clostridia bacterium 2044939 Bacteria Bacteria 48.1 3.05e-4   NR MBQ4339359.1 2044939 g6645 i0 40.4 0.753623188405797 52 31 75.4 0 177 22 110 161 MBQ4339359.1 InlB B-repeat-containing protein [Clostridia bacterium] diamond 156 48.1 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30929181 30929181 PRJNA450343_P_NODE_13974_length_161_cov_0.910714_g13906_i0 PRJNA450343 13974 161 0.910714 1.46624954 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 62 6.85e-11   NR WP_406812968.1 1590 g13906 i0 51.9 0.968944099378882 52 25 96.9 0 4 159 6 57 WP_406812968.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 156 62 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
31055860 31055860 PRJNA450343_P_NODE_3935_length_268_cov_1.232877_g3867_i0 PRJNA450343 3935 268 1.232877 3.30411036 Clostridium sp. 1xD42-85 2320084 Bacteria Bacteria 127 2.59e-36   NR RKI73319.1 2320084 g3867 i0 96.7 0.682835820895522 61 2 68.3 0 185 3 1 61 RKI73319.1 hypothetical protein D7V87_20275, partial [Clostridium sp. 1xD42-85] diamond 183 127 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. 1xD42-85
32194227 32194227 PRJNA450343_P_NODE_9918_length_173_cov_1.120968_g9850_i0 PRJNA450343 9918 173 1.120968 1.93927464 Hathewaya massiliensis 1964382 Bacteria Bacteria 41.6 0.0371   NR WP_142414270.1 1964382 g9850 i0 43.2 0.763005780346821 44 25 76.3 0 35 166 193 236 WP_142414270.1 calcium/proton exchanger [Hathewaya massiliensis] diamond 132 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Hathewaya Hathewaya massiliensis

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