RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA631796" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA631796 · 21 ✖

analysis 1

  • diamond · 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
3154246 3154246 PRJNA631796_P_NODE_12783_length_202_cov_1.539007_g12505_i0 PRJNA631796 12783 202 1.539007 3.10879414 Companilactobacillus versmoldensis DSM 14857 = KCTC 3814 1423815 Bacteria Bacteria 134 1.02e-36   NR KRL66906.1 1423815 g12505 i0 98.5 0.98019801980198 66 1 98 0 3 200 95 160 KRL66906.1 apc family amino acid-polyamine-organocation transporter [Companilactobacillus versmoldensis DSM 14857 = KCTC 3814] diamond 198 134 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Companilactobacillus Companilactobacillus versmoldensis
9531870 9531870 PRJNA631796_P_NODE_12128_length_205_cov_0.888889_g11850_i0 PRJNA631796 12128 205 0.888889 1.82222245 Peptoniphilus 162289 Bacteria Bacteria 139 3.32e-38   NR MFQ8697685.1 54005 g11850 i0 97.1 3.98048780487805 68 2 99.5 0 204 1 111 178 MFQ8697685.1 thioether cross-link-forming SCIFF peptide maturase [Peptoniphilus harei] diamond 816 139 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus harei
23555934 23555934 PRJNA631796_P_NODE_12039_length_205_cov_0.888889_g11761_i0 PRJNA631796 12039 205 0.888889 1.82222245 Peptostreptococcaceae bacterium 1904861 Bacteria Bacteria 125 6.63e-32   NR MDO4720141.1 1904861 g11761 i0 82.4 0.995121951219512 68 12 99.5 0 2 205 128 195 MDO4720141.1 glycogen synthase GlgA [Peptostreptococcaceae bacterium] diamond 204 125 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae   Peptostreptococcaceae bacterium
27112385 27112385 PRJNA631796_S_NODE_134942_length_176_cov_7.965217_g134775_i0 PRJNA631796 134942 176 7.965217 14.01878192 Ligilactobacillus animalis 1605 Bacteria Bacteria 40.4 0.0402   NR WP_347859011.1 1605 g134775 i0 87.5 0.272727272727273 16 2 27.3 0 67 114 1 16 WP_347859011.1 hypothetical protein [Ligilactobacillus animalis] diamond 48 40.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Ligilactobacillus Ligilactobacillus animalis
27460288 27460288 PRJNA631796_P_NODE_10343_length_215_cov_1.038961_g10065_i0 PRJNA631796 10343 215 1.038961 2.23376615 Oribacterium sinus 237576 Bacteria Bacteria 104 1.25e-24   NR WP_040649321.1 237576 g10065 i0 100 1.73023255813953 62 0 86.5 0 29 214 1 62 WP_040649321.1 galactose ABC transporter substrate-binding protein [Oribacterium sinus] diamond 372 104 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Oribacterium Oribacterium sinus
27554586 27554586 PRJNA631796_P_NODE_8564_length_233_cov_1.488372_g8286_i0 PRJNA631796 8564 233 1.488372 3.46790676 Streptococcus mitis 28037 Bacteria Bacteria 73.2 1.48e-14   NR WP_125444093.1 28037 g8286 i0 100 0.424892703862661 33 0 42.5 0 3 101 85 117 WP_125444093.1 replication/maintenance protein RepL [Streptococcus mitis] diamond 99 73.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
27554587 27554587 PRJNA631796_S_NODE_120664_length_202_cov_134.879433_g120497_i0 PRJNA631796 120664 202 134.879433 272.45645466 Clostridium butyricum 1492 Bacteria Bacteria 57.4 5.85e-9   NR MDU1007372.1 1492 g120497 i0 68.3 0.608910891089109 41 11 59.4 2 40 159 1 40 MDU1007372.1 hypothetical protein [Clostridium butyricum] diamond 123 57.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium butyricum
27586503 27586503 PRJNA631796_P_NODE_10964_length_209_cov_1.412162_g10686_i0 PRJNA631796 10964 209 1.412162 2.95141858 Peptoniphilus harei 54005 Bacteria Bacteria 135 2.73e-37   NR WP_005955336.1 54005 g10686 i0 91.3 0.990430622009569 69 6 99 0 209 3 160 228 WP_005955336.1 2-amino-4-hydroxy-6-hydroxymethyldihydropteridine diphosphokinase [Peptoniphilus harei] diamond 207 135 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus harei
28483081 28483081 PRJNA631796_P_NODE_8946_length_229_cov_1.488095_g8668_i0 PRJNA631796 8946 229 1.488095 3.40773755 Veillonella 29465 Bacteria Bacteria 150 1.07e-44   NR WP_105089417.1 29465 g8668 i0 93.2 4.8471615720524 74 5 96.9 0 227 6 88 161 WP_105089417.1 MULTISPECIES: Fur family transcriptional regulator [Veillonella] diamond 1110 150 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella  
28533815 28533815 PRJNA631796_P_NODE_10967_length_209_cov_1.344595_g10689_i0 PRJNA631796 10967 209 1.344595 2.81020355 Mammaliicoccus sciuri 1296 Bacteria Bacteria 98.2 2.6099999999999994e-23   NR WP_119495583.1 1296 g10689 i0 62.7 0.961722488038278 67 25 96.2 0 205 5 120 186 WP_119495583.1 hypothetical protein [Mammaliicoccus sciuri] diamond 201 98.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Mammaliicoccus Mammaliicoccus sciuri
28660066 28660066 PRJNA631796_P_NODE_11387_length_208_cov_0.870748_g11109_i0 PRJNA631796 11387 208 0.870748 1.81115584 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 45.1 0.00353   NR HCT62778.1 2049044 g11109 i0 39.6 0.692307692307692 48 29 69.2 0 63 206 27 74 HCT62778.1 hypothetical protein [Erysipelotrichaceae bacterium] diamond 144 45.1 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
28880849 28880849 PRJNA631796_S_NODE_30048_length_252_cov_0.884817_g29881_i0 PRJNA631796 30048 252 0.884817 2.22973884 Enterococcus faecalis 1351 Bacteria Bacteria 58.2 5.44e-9   NR MDU6311072.1 1351 g29881 i0 92.1 0.452380952380952 38 3 45.2 0 3 116 4 41 MDU6311072.1 hypothetical protein [Enterococcus faecalis] diamond 114 58.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
29039068 29039068 PRJNA631796_P_NODE_13168_length_201_cov_0.914286_g12890_i0 PRJNA631796 13168 201 0.914286 1.83771486 Peptostreptococcus canis 1159213 Bacteria Bacteria 131 2.81e-36   NR WP_185623165.1 1159213 g12890 i0 100 0.985074626865672 66 0 98.5 0 3 200 105 170 WP_185623165.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex dimerization subunit type 1 TsaB [Peptostreptococcus canis] diamond 198 131 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Peptostreptococcus Peptostreptococcus canis
29575364 29575364 PRJNA631796_P_NODE_11230_length_208_cov_1.571429_g10952_i0 PRJNA631796 11230 208 1.571429 3.26857232 unclassified Veillonella 2630086 Bacteria Bacteria 136 3.86e-37   NR WP_009353616.1 2630086 g10952 i0 100 0.995192307692308 69 0 99.5 0 2 208 132 200 WP_009353616.1 MULTISPECIES: SufB/SufD family protein [unclassified Veillonella] diamond 207 136 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella  
29796449 29796449 PRJNA631796_P_NODE_9911_length_219_cov_0.917722_g9633_i0 PRJNA631796 9911 219 0.917722 2.00981118 Streptococcus mitis 28037 Bacteria Bacteria 117 8.540000000000001e-33   NR WP_033676226.1 28037 g9633 i0 93.9 0.904109589041096 66 4 90.4 0 21 218 1 66 WP_033676226.1 hypothetical protein [Streptococcus mitis] diamond 198 117 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
30219754 30219754 PRJNA631796_S_NODE_10152_length_296_cov_89.889362_g9985_i0 PRJNA631796 10152 296 89.889362 266.07251152 Bacteria 2 Bacteria Bacteria 68.9 9.52e-13   NR WP_275233503.1 1280 g9985 i0 94.1 1.72297297297297 34 2 34.5 0 104 3 1 34 WP_275233503.1 hypothetical protein [Staphylococcus aureus] diamond 510 68.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30428839 30428839 PRJNA631796_P_NODE_11293_length_208_cov_0.870748_g11015_i0 PRJNA631796 11293 208 0.870748 1.81115584 Companilactobacillus versmoldensis 194326 Bacteria Bacteria 103 6.7400000000000007e-27   NR WP_010624848.1 194326 g11015 i0 100 0.822115384615385 57 0 82.2 0 171 1 1 57 WP_010624848.1 hypothetical protein [Companilactobacillus versmoldensis] diamond 171 103 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Companilactobacillus Companilactobacillus versmoldensis
31217955 31217955 PRJNA631796_S_NODE_134435_length_188_cov_792.622047_g134268_i0 PRJNA631796 134435 188 792.622047 1490.12944836 Enterococcus faecalis 1351 Bacteria Bacteria 93.2 4.659999999999999e-23   NR WP_375855466.1 1351 g134268 i0 94.4 1.6595744680851101 54 3 86.2 0 188 27 35 88 WP_375855466.1 hypothetical protein [Enterococcus faecalis] diamond 312 93.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
31598131 31598131 PRJNA631796_S_NODE_134676_length_187_cov_18.888889_g134509_i0 PRJNA631796 134676 187 18.888889 35.32222243 Staphylococcus aureus 1280 Bacteria Bacteria 53.9 1.71e-7   NR MCS4580470.1 1280 g134509 i0 92.5 0.641711229946524 40 3 64.2 0 187 68 6 45 MCS4580470.1 hypothetical protein [Staphylococcus aureus] diamond 120 53.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31977452 31977452 PRJNA631796_S_NODE_134278_length_189_cov_3.265625_g134111_i0 PRJNA631796 134278 189 3.265625 6.17203125 Veillonella parvula 29466 Bacteria Bacteria 50.4 1.23e-6   NR MDU4431255.1 29466 g134111 i0 55 0.634920634920635 40 18 63.5 0 152 33 1 40 MDU4431255.1 hypothetical protein [Veillonella parvula] diamond 120 50.4 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella parvula
32736230 32736230 PRJNA631796_P_NODE_11320_length_208_cov_0.870748_g11042_i0 PRJNA631796 11320 208 0.870748 1.81115584 Companilactobacillus versmoldensis 194326 Bacteria Bacteria 142 1.8799999999999994e-42   NR WP_029508253.1 194326 g11042 i0 100 0.995192307692308 69 0 99.5 0 2 208 18 86 WP_029508253.1 DUF951 domain-containing protein [Companilactobacillus versmoldensis] diamond 207 142 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Companilactobacillus Companilactobacillus versmoldensis

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