RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1065838" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1065838 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
2730511 2730511 PRJNA1065838_S_NODE_19063_length_205_cov_1.301282_g18961_i0 PRJNA1065838 19063 205 1.301282 2.6676281 Bacillus thuringiensis 1428 Bacteria Bacteria 112 1.97e-29   NR WP_400136190.1 1428 g18961 i0 94.8 1.69756097560976 58 3 84.9 0 203 30 55 112 WP_400136190.1 hypothetical protein [Bacillus thuringiensis] diamond 348 112 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
14208842 14208842 PRJNA1065838_S_NODE_6192_length_299_cov_1.648000_g6090_i0 PRJNA1065838 6192 299 1.648 4.92752 Bacteria 2 Bacteria Bacteria 173 1.78e-53   NR WP_148842497.1 1314 g6090 i0 97.8 1.7859531772575299 89 2 89.3 0 267 1 1 89 WP_148842497.1 exosortase C-terminal domain/associated protein EpsI, partial [Streptococcus pyogenes] diamond 534 173 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pyogenes
26869251 26869251 PRJNA1065838_S_NODE_32301_length_168_cov_0.873950_g32199_i0 PRJNA1065838 32301 168 0.87395 1.468236 Bacteria 2 Bacteria Bacteria 107 6.87e-29   NR MCH2991121.1 1639 g32199 i0 98.2 1.96428571428571 55 1 98.2 0 166 2 8 62 MCH2991121.1 N-succinylarginine dihydrolase [Listeria monocytogenes] diamond 330 107 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
27596103 27596103 PRJNA1065838_S_NODE_24704_length_189_cov_1.114286_g24602_i0 PRJNA1065838 24704 189 1.114286 2.10600054 Bacteria 2 Bacteria Bacteria 75.9 2.03e-16   NR MBN9921145.1 1639 g24602 i0 97.3 1.17460317460317 37 1 58.7 0 77 187 1 37 MBN9921145.1 hypothetical protein [Listeria monocytogenes] diamond 222 75.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
27627702 27627702 PRJNA1065838_S_NODE_32864_length_167_cov_1.008475_g32762_i0 PRJNA1065838 32864 167 1.008475 1.68415325 Bacteria 2 Bacteria Bacteria 70.1 2.4e-14   NR MCH3002905.1 1639 g32762 i0 100 1.25748502994012 35 0 62.9 0 166 62 27 61 MCH3002905.1 hypothetical protein [Listeria monocytogenes] diamond 210 70.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
27667545 27667545 PRJNA1065838_S_NODE_16744_length_212_cov_1.276074_g16642_i0 PRJNA1065838 16744 212 1.276074 2.70527688 Bacillus thuringiensis 1428 Bacteria Bacteria 60.1 5.26e-9   NR WP_400136190.1 1428 g16642 i0 100 0.438679245283019 31 0 43.9 0 210 118 152 182 WP_400136190.1 hypothetical protein [Bacillus thuringiensis] diamond 93 60.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
28109267 28109267 PRJNA1065838_S_NODE_23365_length_193_cov_1.062500_g23263_i0 PRJNA1065838 23365 193 1.0625 2.050625 Bacillus mobilis 2026190 Bacteria Bacteria 95.5 4.82e-21   NR WP_400830793.1 2026190 g23263 i0 63.5 4.83419689119171 63 23 97.9 0 3 191 433 495 WP_400830793.1 reverse transcriptase domain-containing protein [Bacillus mobilis] diamond 933 95.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus mobilis
28583179 28583179 PRJNA1065838_S_NODE_27527_length_180_cov_1.190840_g27425_i0 PRJNA1065838 27527 180 1.19084 2.143512 Listeria monocytogenes 1639 Bacteria Bacteria 123 5.46e-35   NR MBN9981007.1 1639 g27425 i0 100 1 60 0 100 0 1 180 1 60 MBN9981007.1 hypothetical protein [Listeria monocytogenes] diamond 180 123 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
28646268 28646268 PRJNA1065838_S_NODE_27867_length_179_cov_1.200000_g27765_i0 PRJNA1065838 27867 179 1.2 2.148 Geobacillus thermoleovorans 33941 Bacteria Bacteria 107 5.1e-29   NR WP_367164894.1 33941 g27765 i0 100 0.854748603351955 51 0 85.5 0 25 177 1 51 WP_367164894.1 hypothetical protein, partial [Geobacillus thermoleovorans] diamond 153 107 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus thermoleovorans
29080003 29080003 PRJNA1065838_S_NODE_36208_length_162_cov_0.920354_g36106_i0 PRJNA1065838 36208 162 0.920354 1.49097348 Bacteria 2 Bacteria Bacteria 117 1.2199999999999999e-32   NR MBN9926981.1 1639 g36106 i0 98.1 1.96296296296296 53 1 98.1 0 3 161 23 75 MBN9926981.1 hypothetical protein [Listeria monocytogenes] diamond 318 117 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
29592987 29592987 PRJNA1065838_S_NODE_19710_length_203_cov_1.012987_g19608_i0 PRJNA1065838 19710 203 1.012987 2.05636361 Listeria monocytogenes 1639 Bacteria Bacteria 73.2 1.74e-15   NR MCH3092978.1 1639 g19608 i0 100 0.502463054187192 34 0 50.2 0 201 100 15 48 MCH3092978.1 hypothetical protein [Listeria monocytogenes] diamond 102 73.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
30004034 30004034 PRJNA1065838_S_NODE_31131_length_170_cov_1.289256_g31029_i0 PRJNA1065838 31131 170 1.289256 2.1917352 Bacillus thuringiensis 1428 Bacteria Bacteria 76.3 1.56e-14   NR WP_400136196.1 1428 g31029 i0 97.3 0.652941176470588 37 1 65.3 0 169 59 325 361 WP_400136196.1 glycosyltransferase family 4 protein [Bacillus thuringiensis] diamond 111 76.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
30098595 30098595 PRJNA1065838_S_NODE_29232_length_175_cov_1.238095_g29130_i0 PRJNA1065838 29232 175 1.238095 2.16666625 Lactobacillus crispatus 47770 Bacteria Bacteria 50.4 6.6e-6   NR TDN29012.1 47770 g29130 i0 96.4 0.48 28 1 48 0 90 173 1 28 TDN29012.1 polysaccharide transporter, partial [Lactobacillus crispatus] diamond 84 50.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
30216731 30216731 PRJNA1065838_S_NODE_28872_length_176_cov_1.228346_g28770_i0 PRJNA1065838 28872 176 1.228346 2.16188896 Bacteria 2 Bacteria Bacteria 64.3 4.91e-12   NR WP_409352355.1 1352 g28770 i0 90 1.36363636363636 40 4 68.2 0 2 121 19 58 WP_409352355.1 pyrroline-5-carboxylate reductase dimerization domain-containing protein, partial [Enterococcus faecium] diamond 240 64.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
30635661 30635661 PRJNA1065838_S_NODE_31693_length_169_cov_0.866667_g31591_i0 PRJNA1065838 31693 169 0.866667 1.46466723 Thermicanus aegyptius 94009 Bacteria Bacteria 74.7 6.77e-14   NR WP_028986370.1 94009 g31591 i0 70.4 0.958579881656805 54 16 95.9 0 6 167 280 333 WP_028986370.1 RNA polymerase factor sigma-54 [Thermicanus aegyptius] diamond 162 74.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
31584324 31584324 PRJNA1065838_S_NODE_34416_length_165_cov_0.879310_g34314_i0 PRJNA1065838 34416 165 0.87931 1.4508615 Saccharibacillus deserti 1634444 Bacteria Bacteria 105 8.17e-25   NR WP_172255376.1 1634444 g34314 i0 98.2 1 55 1 100 0 1 165 202 256 WP_172255376.1 peptide chain release factor 3 [Saccharibacillus deserti] diamond 165 105 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Saccharibacillus Saccharibacillus deserti
31836964 31836964 PRJNA1065838_S_NODE_2737_length_413_cov_1.571429_g2635_i0 PRJNA1065838 2737 413 1.571429 6.49000177 Bacillus thuringiensis 1428 Bacteria Bacteria 271 2.75e-88   NR WP_400136196.1 1428 g2635 i0 97.8 0.995157384987893 137 3 99.5 0 3 413 137 273 WP_400136196.1 glycosyltransferase family 4 protein [Bacillus thuringiensis] diamond 411 271 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
31868664 31868664 PRJNA1065838_S_NODE_33597_length_166_cov_0.888889_g33495_i0 PRJNA1065838 33597 166 0.888889 1.47555574 Staphylococcus epidermidis 1282 Bacteria Bacteria 66.2 9.57e-13   NR PIH42955.1 1282 g33495 i0 90.9 0.596385542168675 33 3 59.6 0 22 120 1 33 PIH42955.1 hypothetical protein CTJ01_13190, partial [Staphylococcus epidermidis] diamond 99 66.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
32312063 32312063 PRJNA1065838_S_NODE_33399_length_166_cov_1.333333_g33297_i0 PRJNA1065838 33399 166 1.333333 2.21333278 Listeria monocytogenes 1639 Bacteria Bacteria 60.1 2.13e-10   NR MCH3113139.1 1639 g33297 i0 93.8 0.578313253012048 32 2 57.8 0 21 116 30 61 MCH3113139.1 hypothetical protein [Listeria monocytogenes] diamond 96 60.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32525308 32525308 PRJNA1065838_S_NODE_32359_length_168_cov_0.873950_g32257_i0 PRJNA1065838 32359 168 0.87395 1.468236 Bacteria 2 Bacteria Bacteria 58.2 1.17e-9   NR MCH3005797.1 1639 g32257 i0 100 2 28 0 50 0 166 83 30 57 MCH3005797.1 DUF4337 domain-containing protein [Listeria monocytogenes] diamond 336 58.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes

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