RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA675331", 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 · 21 ✖

tax_kingdom 1

  • Bacillati · 21 ✖

bioproject 1

  • PRJNA675331 · 21 ✖

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
1923829 1923829 PRJNA675331_P_NODE_14302_length_275_cov_1.232673_g14130_i0 PRJNA675331 14302 275 1.232673 3.38985075 Bacteria 2 Bacteria Bacteria 126 2.31e-32   NR NLK69503.1 1898204 g14130 i0 63.3 16.5927272727273 90 33 98.2 0 4 273 303 392 NLK69503.1 elongation factor Tu [Clostridiaceae bacterium] diamond 4563 127 0.992125984251969 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
3198596 3198596 PRJNA675331_P_NODE_10963_length_303_cov_75.169565_g10791_i0 PRJNA675331 10963 303 75.169565 227.76378195 uncultured Streptococcus sp. 83427 Bacteria Bacteria 405 1.88e-108   NTclustered gi|2695360723|gb|PP455427.1| 83427 g10791 i0 92 120.792079207921 300 6 94 11 9 293 503 799 Uncultured Streptococcus sp. clone def16 16S ribosomal RNA gene, partial sequence blastn 36600 405 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus uncultured Streptococcus sp.
5751267 5751267 PRJNA675331_P_NODE_12945_length_284_cov_1.094787_g12773_i0 PRJNA675331 12945 284 1.094787 3.10919508 Neobacillus sp. DY30 3047871 Bacteria Bacteria 147 1.17e-30   NTclustered gi|2511398412|gb|CP126093.1| 3047871 g12773 i0 82.286 16.306338028169 175 25 60 5 105 275 164379 164551 Neobacillus sp. DY30 chromosome, complete genome blastn 4631 147 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus sp. DY30
5751328 5751328 PRJNA675331_P_NODE_22805_length_243_cov_0.905882_g22633_i0 PRJNA675331 22805 243 0.905882 2.20129326 Streptococcus mitis 28037 Bacteria Bacteria 438 1.4399999999999996e-118   NTclustered gi|2886512733|emb|OZ217346.1| 28037 g22633 i0 99.177 99.0740740740741 243 2 100 0 1 243 173848 174090 Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1 blastn 24075 438 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
6272464 6272464 PRJNA675331_P_NODE_15185_length_270_cov_1.436548_g15013_i0 PRJNA675331 15185 270 1.436548 3.8786796 Clostridium 1485 Bacteria Bacteria 418 2.1199999999999993e-112   NTclustered gi|2425298477|gb|CP114763.1| 1492 g15013 i0 95.131 863.562962962963 267 10 99 3 3 268 11376 11640 Clostridium butyricum strain LV1 chromosome 1, complete sequence blastn 233162 418 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium butyricum
10851776 10851776 PRJNA675331_P_NODE_18689_length_250_cov_0.870056_g18517_i0 PRJNA675331 18689 250 0.870056 2.17514 Streptococcus sp. oral taxon 061 712623 Bacteria Bacteria 440 4.1399999999999976e-119   NTclustered gi|1866752300|gb|CP058258.1| 712623 g18517 i0 98.4 5.996 250 4 100 0 1 250 284137 284386 Streptococcus sp. oral taxon 061 strain F0704 chromosome, complete genome blastn 1499 440 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp. oral taxon 061
10851786 10851786 PRJNA675331_P_NODE_20569_length_247_cov_0.885057_g20397_i0 PRJNA675331 20569 247 0.885057 2.18609079 Lactobacillus crispatus 47770 Bacteria Bacteria 420 5.31e-113   NTclustered gi|2096299657|gb|CP083392.1| 47770 g20397 i0 100 27.5708502024291 227 0 92 0 1 227 250579 250353 Lactobacillus crispatus strain Lc1226 chromosome, complete genome blastn 6810 420 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
12647843 12647843 PRJNA675331_P_NODE_18410_length_251_cov_0.865169_g18238_i0 PRJNA675331 18410 251 0.865169 2.17157419 Streptococcus 1301 Bacteria Bacteria 398 2.5399999999999994e-106   NTclustered gi|1403472623|emb|LS483417.1| 1313 g18238 i0 95.219 99.9760956175299 251 12 100 0 1 251 1155700 1155950 Streptococcus pneumoniae strain NCTC11902 genome assembly, chromosome: 1 blastn 25094 398 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
15950529 15950529 PRJNA675331_P_NODE_4813_length_435_cov_1.063536_g4641_i0 PRJNA675331 4813 435 1.063536 4.6263816 Evansella vedderi 38282 Bacteria Bacteria 261 1.34e-81   NR WP_307329272.1 38282 g4641 i0 81.9 0.993103448275862 144 26 99.3 0 434 3 244 387 WP_307329272.1 beta-glucuronidase [Evansella vedderi] diamond 432 261 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Evansella Evansella vedderi
15950548 15950548 PRJNA675331_P_NODE_9253_length_325_cov_1.142857_g9081_i0 PRJNA675331 9253 325 1.142857 3.71428525 Clostridia bacterium 2044939 Bacteria Bacteria 162 2.11e-46   NR MDD4685958.1 2044939 g9081 i0 79 47.4830769230769 105 22 96.9 0 324 10 154 258 MDD4685958.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridia bacterium] diamond 15432 162 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
18500028 18500028 PRJNA675331_P_NODE_19595_length_248_cov_2.022857_g19423_i0 PRJNA675331 19595 248 2.022857 5.01668536 Paraclostridium bifermentans 1490 Bacteria Bacteria 449 6.81e-122   NTclustered gi|2223161236|gb|CP094933.1| 1490 g19423 i0 100 1119.5564516129 243 0 98 0 3 245 14899 14657 Paraclostridium bifermentans strain HD0315_2 chromosome, complete genome blastn 277650 449 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Paraclostridium Paraclostridium bifermentans
27239880 27239880 PRJNA675331_P_NODE_20003_length_248_cov_0.880000_g19831_i0 PRJNA675331 20003 248 0.88 2.1824 Clostridiales bacterium 1898207 Bacteria Bacteria 64.3 2.16e-11   NR HBV66938.1 1898207 g19831 i0 46.7 0.725806451612903 60 32 72.6 0 229 50 17 76 HBV66938.1 hypothetical protein [Clostridiales bacterium] diamond 180 64.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28293757 28293757 PRJNA675331_P_NODE_4586_length_444_cov_1.326146_g4414_i0 PRJNA675331 4586 444 1.326146 5.88808824 root 1 Root_unresolved Root_unresolved 162 7.64e-46   NR MRB67411.1 1428 g4414 i0 59.4 5.40540540540541 133 47 89.9 1 401 3 5 130 MRB67411.1 30S ribosomal protein S2 [Bacillus thuringiensis] diamond 2400 163 0.993865030674847 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
28408406 28408406 PRJNA675331_P_NODE_19326_length_249_cov_0.875000_g19154_i0 PRJNA675331 19326 249 0.875 2.17875 Oribacterium sinus 237576 Bacteria Bacteria 92 1.84e-19   NR WP_304070818.1 237576 g19154 i0 53 1.98795180722892 83 39 100 0 1 249 153 235 WP_304070818.1 methyl-accepting chemotaxis protein [Oribacterium sinus] diamond 495 92 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Oribacterium Oribacterium sinus
28724132 28724132 PRJNA675331_P_NODE_10527_length_308_cov_2.034043_g10355_i0 PRJNA675331 10527 308 2.034043 6.26485244 Veillonella sp. 1926307 Bacteria Bacteria 156 2.9e-47   NR WP_366512514.1 1926307 g10355 i0 73 1.94805194805195 100 27 97.4 0 306 7 6 105 WP_366512514.1 hypothetical protein [Veillonella sp.] diamond 600 156 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp.
31218986 31218986 PRJNA675331_P_NODE_13035_length_283_cov_1.114286_g12863_i0 PRJNA675331 13035 283 1.114286 3.15342938 Evansella sp. LMS18 2924033 Bacteria Bacteria 44.3 0.0172   NR WP_255244507.1 2924033 g12863 i0 33.8 0.816254416961131 77 51 81.6 0 4 234 325 401 WP_255244507.1 asparagine synthase-related protein [Evansella sp. LMS18] diamond 231 44.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Evansella Evansella sp. LMS18
31326014 31326014 PRJNA675331_P_NODE_16255_length_263_cov_1.215789_g16083_i0 PRJNA675331 16255 263 1.215789 3.19752507 Bacillati 1783272 Bacteria Bacteria 43.5 0.0252   NR WP_010246532.1 35830 g16083 i0 37.9 1.6425855513308 66 37 73 2 69 260 213 276 WP_010246532.1 hypothetical protein [Acetivibrio cellulolyticus] diamond 432 43.9 0.990888382687927 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Acetivibrio Acetivibrio cellulolyticus
31958628 31958628 PRJNA675331_P_NODE_8617_length_335_cov_0.881679_g8445_i0 PRJNA675331 8617 335 0.881679 2.95362465 Bacillati 1783272 Bacteria Bacteria 111 7.090000000000001e-26   NR MEE3392634.1 1898203 g8445 i0 55.6 4.38805970149254 81 36 72.5 0 243 1 6 86 MEE3392634.1 glutamine synthetase III [Lachnospiraceae bacterium] diamond 1470 111 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32041836 32041836 PRJNA675331_P_NODE_1778_length_685_cov_1.570261_g1617_i0 PRJNA675331 1778 685 1.570261 10.75628785 Clostridia bacterium 2044939 Bacteria Bacteria 47.4 0.0393   NR MBQ3461596.1 2044939 g1617 i0 26.9 2.19416058394161 167 109 67.9 4 475 11 4766 4931 MBQ3461596.1 cadherin-like beta sandwich domain-containing protein [Clostridia bacterium] diamond 1503 47.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32105037 32105037 PRJNA675331_P_NODE_7118_length_364_cov_1.054983_g6946_i0 PRJNA675331 7118 364 1.054983 3.84013812 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 47 0.00446   NR MBO5336739.1 1898203 g6946 i0 30.6 0.593406593406593 72 50 59.3 0 93 308 404 475 MBO5336739.1 glucosyltransferase domain-containing protein [Lachnospiraceae bacterium] diamond 216 47 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32799878 32799878 PRJNA675331_P_NODE_23620_length_242_cov_0.911243_g23448_i0 PRJNA675331 23620 242 0.911243 2.20520806 Staphylococcus aureus 1280 Bacteria Bacteria 56.2 3.96e-7   NR WP_275218940.1 1280 g23448 i0 84.6 0.322314049586777 26 4 32.2 0 186 109 3 28 WP_275218940.1 hypothetical protein, partial [Staphylococcus aureus] diamond 78 56.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus

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