RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA795663 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
3330429 3330429 PRJNA795663_S_NODE_13643_length_170_cov_2.947368_g13538_i0 PRJNA795663 13643 170 2.947368 5.0105256 Macrococcoides caseolyticum 69966 Bacteria Bacteria 80.5 2.11e-18   NR MBQ5153795.1 69966 g13538 i0 100 0.652941176470588 37 0 65.3 0 170 60 29 65 MBQ5153795.1 hypothetical protein [Macrococcoides caseolyticum] diamond 111 80.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Macrococcoides Macrococcoides caseolyticum
23732269 23732269 PRJNA795663_S_NODE_3459_length_309_cov_1.922794_g3354_i0 PRJNA795663 3459 309 1.922794 5.94143346 Streptococcus 1301 Bacteria Bacteria 159 1.3499999999999997e-42   NR WP_275690393.1 2582653 g3354 i0 96.6 2.71844660194175 88 3 85.4 0 266 3 1329 1416 WP_275690393.1 Rib/alpha-like domain-containing protein, partial [Streptococcus sp. 714] diamond 840 160 0.99375 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp. 714
26809855 26809855 PRJNA795663_S_NODE_9761_length_195_cov_1.424051_g9656_i0 PRJNA795663 9761 195 1.424051 2.77689945 Bacteria 2 Bacteria Bacteria 112 4.88e-30   NR WP_289862677.1 1351 g9656 i0 87.5 3.93846153846154 64 8 98.5 0 2 193 27 90 WP_289862677.1 hypothetical protein, partial [Enterococcus faecalis] diamond 768 112 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
27338373 27338373 PRJNA795663_S_NODE_103_length_1353_cov_8.067629_g60_i0 PRJNA795663 103 1353 8.067629 109.15502037 Paenibacillus eucommiae 1355755 Bacteria Bacteria 186 5.489999999999999e-48   NR WP_209972488.1 1355755 g60 i0 39.8 1.22394678492239 284 170 62.7 1 175 1023 465 748 WP_209972488.1 NosD domain-containing protein [Paenibacillus eucommiae] diamond 1656 186 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus eucommiae
27401601 27401601 PRJNA795663_S_NODE_6823_length_227_cov_2.547368_g6718_i0 PRJNA795663 6823 227 2.547368 5.78252536 Aerococcus sp. 1KP-2 1872398 Bacteria Bacteria 136 2.0599999999999997e-37   NR WP_199445736.1 1981982 g6718 i0 97.1 0.911894273127753 69 2 91.2 0 2 208 135 203 WP_199445736.1 RluA family pseudouridine synthase [Aerococcus sp. 1KP-2016] diamond 207 136 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Aerococcus Aerococcus sp. 1KP-2016
28411937 28411937 PRJNA795663_S_NODE_7246_length_221_cov_3.097826_g7141_i0 PRJNA795663 7246 221 3.097826 6.84619546 Aerococcus sp. 1KP-2 1872398 Bacteria Bacteria 145 3.3799999999999987e-41   NR WP_199445736.1 1981982 g7141 i0 98.6 0.990950226244344 73 1 99.1 0 219 1 68 140 WP_199445736.1 RluA family pseudouridine synthase [Aerococcus sp. 1KP-2016] diamond 219 145 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Aerococcus Aerococcus sp. 1KP-2016
29012086 29012086 PRJNA795663_S_NODE_6548_length_231_cov_1.752577_g6443_i0 PRJNA795663 6548 231 1.752577 4.04845287 Marinococcus halophilus 1371 Bacteria Bacteria 84 8.76e-17   NR WP_379920082.1 1371 g6443 i0 92.7 0.532467532467532 41 3 53.2 0 107 229 1 41 WP_379920082.1 NAD-dependent succinate-semialdehyde dehydrogenase [Marinococcus halophilus] diamond 123 84 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Marinococcus Marinococcus halophilus
29999915 29999915 PRJNA795663_S_NODE_19011_length_150_cov_1.362832_g18906_i0 PRJNA795663 19011 150 1.362832 2.044248 Clostridia 186801 Bacteria Bacteria 79.3 1.02e-15   NR MBS4960101.1 1898207 g18906 i0 73.5 5.88 49 13 98 0 3 149 312 360 MBS4960101.1 methionine adenosyltransferase [Clostridiales bacterium] diamond 882 79.7 0.994981179422836 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
30433323 30433323 PRJNA795663_S_NODE_2553_length_355_cov_2.764151_g2448_i0 PRJNA795663 2553 355 2.764151 9.81273605 Priestia megaterium 1404 Bacteria Bacteria 74.7 6.09e-15   NR WP_374735350.1 1404 g2448 i0 56.2 1.62253521126761 73 32 61.7 0 46 264 6 78 WP_374735350.1 hypothetical protein, partial [Priestia megaterium] diamond 576 74.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia megaterium
30852809 30852809 PRJNA795663_S_NODE_12214_length_178_cov_1.879433_g12109_i0 PRJNA795663 12214 178 1.879433 3.34539074 Bacillota 1239 Bacteria Bacteria 52.8 4.58e-6   NR WP_338141068.1 416586 g12109 i0 40 5.66292134831461 55 33 92.7 0 14 178 259 313 WP_338141068.1 DNA polymerase [Selenomonas bovis] diamond 1008 52.8 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Selenomonadaceae Selenomonas Selenomonas bovis
31728827 31728827 PRJNA795663_S_NODE_11957_length_179_cov_10.852113_g11852_i0 PRJNA795663 11957 179 10.852113 19.42528227 Staphylococcus aureus 1280 Bacteria Bacteria 41.6 0.0102   NR MCS4580470.1 1280 g11852 i0 85 0.670391061452514 40 6 67 0 10 129 1 40 MCS4580470.1 hypothetical protein [Staphylococcus aureus] diamond 120 41.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31887044 31887044 PRJNA795663_S_NODE_5097_length_258_cov_2.877828_g4992_i0 PRJNA795663 5097 258 2.877828 7.42479624 Anaerococcus 165779 Bacteria Bacteria 147 5.549999999999999e-43   NR WP_209813982.1 165779 g4992 i0 93.7 0.918604651162791 79 5 91.9 0 237 1 97 175 WP_209813982.1 MULTISPECIES: bis(5'-nucleosyl)-tetraphosphatase (symmetrical) YqeK [Anaerococcus] diamond 237 147 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus  
32181174 32181174 PRJNA795663_S_NODE_3578_length_305_cov_1.753731_g3473_i0 PRJNA795663 3578 305 1.753731 5.34887955 Bacillota 1239 Bacteria Bacteria 56.2 1.34e-6   NR WP_163855498.1 189691 g3473 i0 38.6 2.60655737704918 88 52 84.6 2 304 47 252 339 WP_163855498.1 MerR family transcriptional regulator [Paenibacillus elgii] diamond 795 56.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus elgii
32866412 32866412 PRJNA795663_S_NODE_15420_length_162_cov_1.648000_g15315_i0 PRJNA795663 15420 162 1.648 2.66976 Brevibacillus sp. TJ4 3234853 Bacteria Bacteria 97.1 1.6000000000000002e-22   NR WP_400162767.1 3234853 g15315 i0 100 1 54 0 100 0 162 1 242 295 WP_400162767.1 ABC transporter permease [Brevibacillus sp. TJ4] diamond 162 97.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus sp. TJ4

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