RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA675042" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA675042 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
22324811 22324811 PRJNA675042_P_NODE_7698_length_544_cov_5.356688_g7256_i0 PRJNA675042 7698 544 5.356688 29.14038272 Staphylococcus borealis 2742203 Bacteria Bacteria 158 1.13e-46   NR WP_415427147.1 2742203 g7256 i0 100 0.413602941176471 75 0 41.4 0 359 135 9 83 WP_415427147.1 S-adenosylmethionine:tRNA ribosyltransferase-isomerase, partial [Staphylococcus borealis] diamond 225 158 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus borealis
24872336 24872336 PRJNA675042_P_NODE_14080_length_452_cov_1.474934_g13630_i0 PRJNA675042 14080 452 1.474934 6.66670168 Bacillati 1783272 Bacteria Bacteria 298 2.7099999999999996e-99   NR WP_347134754.1 1280 g13630 i0 95.9 1.92477876106195 145 6 96.2 0 439 5 72 216 WP_347134754.1 PBSX family phage terminase large subunit, partial [Staphylococcus aureus] diamond 870 298 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
27018612 27018612 PRJNA675042_P_NODE_62162_length_304_cov_2.584416_g61712_i0 PRJNA675042 62162 304 2.584416 7.85662464 Peptoniphilus harei 54005 Bacteria Bacteria 145 4.599999999999999e-38   NR WP_005956249.1 54005 g61712 i0 94.2 0.848684210526316 86 5 84.9 0 260 3 695 780 WP_005956249.1 S-layer homology domain-containing protein [Peptoniphilus harei] diamond 258 145 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus harei
27156568 27156568 PRJNA675042_P_NODE_23562_length_396_cov_3.699690_g23112_i0 PRJNA675042 23562 396 3.69969 14.6507724 Bacteria 2 Bacteria Bacteria 217 1.55e-70   NR WP_158084704.1 1313 g23112 i0 98.3 1.72727272727273 115 2 87.1 0 43 387 1 115 WP_158084704.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 684 218 0.995412844036697 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
27346752 27346752 PRJNA675042_P_NODE_23363_length_397_cov_1.938272_g22913_i0 PRJNA675042 23363 397 1.938272 7.69493984 root 1 Root_unresolved Root_unresolved 116 3.770000000000001e-27   NR MBC1496232.1 1643 g22913 i0 57.7 19.647355163728 104 44 78.6 0 392 81 611 714 MBC1496232.1 hypothetical protein [Listeria welshimeri] diamond 7800 117 0.991452991452991 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria welshimeri
27871537 27871537 PRJNA675042_P_NODE_84545_length_275_cov_1.430693_g84095_i0 PRJNA675042 84545 275 1.430693 3.93440575 Terrilactibacillus laevilacticus 1380157 Bacteria Bacteria 44.7 0.00829   NR WP_141191311.1 1380157 g84095 i0 54.1 0.807272727272727 37 17 40.4 0 174 64 145 181 WP_141191311.1 urease accessory protein UreG [Terrilactibacillus laevilacticus] diamond 222 44.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Terrilactibacillus Terrilactibacillus laevilacticus
28124136 28124136 PRJNA675042_P_NODE_103285_length_254_cov_1.204420_g102835_i0 PRJNA675042 103285 254 1.20442 3.0592268 Clostridia bacterium 2044939 Bacteria Bacteria 42.4 0.0426   NR MBR0542504.1 2044939 g102835 i0 41.7 0.425196850393701 36 21 42.5 0 92 199 119 154 MBR0542504.1 hypothetical protein [Clostridia bacterium] diamond 108 42.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28281838 28281838 PRJNA675042_P_NODE_83966_length_276_cov_1.133005_g83516_i0 PRJNA675042 83966 276 1.133005 3.1270938 Clostridium perfringens 1502 Bacteria Bacteria 58.9 4.87e-9   NR MDK0894232.1 1502 g83516 i0 73.8 0.456521739130435 42 11 45.7 0 189 64 24 65 MDK0894232.1 hypothetical protein [Clostridium perfringens] diamond 126 58.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
28451877 28451877 PRJNA675042_P_NODE_171506_length_242_cov_0.911243_g171056_i0 PRJNA675042 171506 242 0.911243 2.20520806 Enterococcus 1350 Bacteria Bacteria 43.5 0.0187   NR WP_071878127.1 332949 g171056 i0 43.9 1.41322314049587 57 26 70.7 1 189 19 196 246 WP_071878127.1 DUF916 and DUF3324 domain-containing protein [Enterococcus silesiacus] diamond 342 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus silesiacus
28609620 28609620 PRJNA675042_P_NODE_63387_length_303_cov_0.947826_g62937_i0 PRJNA675042 63387 303 0.947826 2.87191278 root 1 Root_unresolved Root_unresolved 67.8 1.2e-10   NR MBC1496232.1 1643 g62937 i0 51.6 6.27722772277228 64 31 63.4 0 194 3 606 669 MBC1496232.1 hypothetical protein [Listeria welshimeri] diamond 1902 67.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria welshimeri
28704449 28704449 PRJNA675042_P_NODE_14887_length_445_cov_4.717742_g14437_i0 PRJNA675042 14887 445 4.717742 20.9939519 root 1 Root_unresolved Root_unresolved 120 3.06e-28   NR MBC1496232.1 1643 g14437 i0 53.8 16.4089887640449 106 49 71.5 0 413 96 565 670 MBC1496232.1 hypothetical protein [Listeria welshimeri] diamond 7302 121 0.991735537190083 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria welshimeri
28704472 28704472 PRJNA675042_P_NODE_73627_length_288_cov_1.953488_g73177_i0 PRJNA675042 73627 288 1.953488 5.62604544 root 1 Root_unresolved Root_unresolved 106 3.01e-24   NR MBC1496232.1 1643 g73177 i0 56.4 22.5208333333333 94 41 97.9 0 283 2 611 704 MBC1496232.1 hypothetical protein [Listeria welshimeri] diamond 6486 107 0.990654205607477 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria welshimeri
29418545 29418545 PRJNA675042_P_NODE_42529_length_338_cov_1.720755_g42079_i0 PRJNA675042 42529 338 1.720755 5.8161519 Staphylococcus epidermidis 1282 Bacteria Bacteria 43.5 0.0125   NR WP_398574795.1 1282 g42079 i0 41.3 0.816568047337278 92 41 71.9 5 295 53 13 102 WP_398574795.1 hypothetical protein, partial [Staphylococcus epidermidis] diamond 276 43.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
31124200 31124200 PRJNA675042_P_NODE_66875_length_298_cov_0.813333_g66425_i0 PRJNA675042 66875 298 0.813333 2.42373234 Clostridium perfringens 1502 Bacteria Bacteria 56.6 4.97e-8   NR MDK0894232.1 1502 g66425 i0 71.1 0.38255033557047 38 11 38.3 0 158 271 45 82 MDK0894232.1 hypothetical protein [Clostridium perfringens] diamond 114 56.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
31579205 31579205 PRJNA675042_P_NODE_150836_length_245_cov_0.895349_g150386_i0 PRJNA675042 150836 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 49.7 1.34e-4   NR WP_240451975.1 1280 g150386 i0 64.4 23.1061224489796 45 16 55.1 0 57 191 99 143 WP_240451975.1 catalase, partial [Staphylococcus aureus] diamond 5661 49.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31915169 31915169 PRJNA675042_P_NODE_65837_length_299_cov_1.194690_g65387_i0 PRJNA675042 65837 299 1.19469 3.5721231 Staphylococcus aureus 1280 Bacteria Bacteria 43.1 0.0361   NR WP_145367761.1 1280 g65387 i0 37.9 0.662207357859532 66 40 65.2 1 245 51 103 168 WP_145367761.1 nucleoside transporter C-terminal domain-containing protein, partial [Staphylococcus aureus] diamond 198 43.1 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);;