RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA981359" 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

  • PRJNA981359 · 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
26677829 26677829 PRJNA981359_S_NODE_49821_length_281_cov_1.855769_g49721_i0 PRJNA981359 49821 281 1.855769 5.21471089 Lactonifactor 420345 Bacteria Bacteria 43.1 0.0402   NR WP_154258727.1 420345 g49721 i0 28.6 0.672597864768683 63 45 67.3 0 242 54 44 106 WP_154258727.1 MULTISPECIES: ADP-ribosylglycohydrolase family protein [Lactonifactor] diamond 189 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Lactonifactor  
26741008 26741008 PRJNA981359_S_NODE_29101_length_330_cov_1.894942_g29001_i0 PRJNA981359 29101 330 1.894942 6.2533086 Tepidibacter formicigenes 227138 Bacteria Bacteria 45.4 0.0106   NR WP_072889760.1 227138 g29001 i0 35.9 0.836363636363636 92 51 82.7 3 328 56 74 158 WP_072889760.1 Wadjet anti-phage system protein JetD domain-containing protein [Tepidibacter formicigenes] diamond 276 45.4 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Tepidibacter Tepidibacter formicigenes
27152287 27152287 PRJNA981359_S_NODE_28282_length_332_cov_3.702703_g28182_i0 PRJNA981359 28282 332 3.702703 12.29297396 Weissella cibaria 137591 Bacteria Bacteria 43.5 0.0303   NR WP_196777253.1 137591 g28182 i0 51.3 1.05722891566265 117 30 94.9 6 17 331 21 122 WP_196777253.1 hypothetical protein, partial [Weissella cibaria] diamond 351 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella cibaria
27152288 27152288 PRJNA981359_S_NODE_45542_length_290_cov_1.663594_g45442_i0 PRJNA981359 45542 290 1.663594 4.8244226 Halanaerobiales bacterium 2094029 Bacteria Bacteria 59.7 7.22e-8   NR MBS3812162.1 2094029 g45442 i0 37.6 0.879310344827586 85 42 80.7 2 278 45 814 894 MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] diamond 255 59.7 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
27311030 27311030 PRJNA981359_S_NODE_77123_length_219_cov_4.821918_g77023_i0 PRJNA981359 77123 219 4.821918 10.56000042 Clostridia bacterium 2044939 Bacteria Bacteria 43.1 0.0196   NR MBQ9995343.1 2044939 g77023 i0 41.3 0.63013698630137 46 25 60.3 1 168 37 34 79 MBQ9995343.1 aminoglycoside phosphotransferase family protein [Clostridia bacterium] diamond 138 43.1 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27468836 27468836 PRJNA981359_S_NODE_19543_length_362_cov_3.352941_g19443_i0 PRJNA981359 19543 362 3.352941 12.13764642 Bacillaceae bacterium 1889774 Bacteria Bacteria 42.7 0.029   NR MDX5474038.1 1889774 g19443 i0 40.9 0.364640883977901 44 26 36.5 0 31 162 15 58 MDX5474038.1 hypothetical protein [Bacillaceae bacterium] diamond 132 42.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae   Bacillaceae bacterium
27601260 27601260 PRJNA981359_S_NODE_60884_length_259_cov_2.935484_g60784_i0 PRJNA981359 60884 259 2.935484 7.60290356 root 1 Root_unresolved Root_unresolved 42 0.0107   NR MCH2749318.1 1639 g60784 i0 43.8 1.65637065637066 48 26 55.6 1 258 115 4 50 MCH2749318.1 hypothetical protein [Listeria monocytogenes] diamond 429 42.4 0.990566037735849 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
28005694 28005694 PRJNA981359_S_NODE_49765_length_281_cov_2.072115_g49665_i0 PRJNA981359 49765 281 2.072115 5.82264315 Gemella haemolysans 1379 Bacteria Bacteria 97.8 1.5400000000000001e-22   NR WP_060914566.1 1379 g49665 i0 100 0.491103202846975 46 0 49.1 0 138 1 1 46 WP_060914566.1 hypothetical protein [Gemella haemolysans] diamond 138 97.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
28605384 28605384 PRJNA981359_S_NODE_25007_length_342_cov_3.312268_g24907_i0 PRJNA981359 25007 342 3.312268 11.32795656 Gemella haemolysans 1379 Bacteria Bacteria 182 1.66e-51   NR WP_316446835.1 1379 g24907 i0 93.8 3.96491228070175 113 7 99.1 0 340 2 48 160 WP_316446835.1 YSIRK-type signal peptide-containing protein [Gemella haemolysans] diamond 1356 182 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
29211473 29211473 PRJNA981359_S_NODE_70109_length_246_cov_0.901734_g70009_i0 PRJNA981359 70109 246 0.901734 2.21826564 Anaerococcus 165779 Bacteria Bacteria 91.7 3.49e-22   NR WP_004816084.1 33029 g70009 i0 93.2 1.07317073170732 44 3 53.7 0 136 5 1 44 WP_004816084.1 hypothetical protein [Anaerococcus hydrogenalis] diamond 264 92 0.996739130434783 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus hydrogenalis
29331584 29331584 PRJNA981359_S_NODE_20929_length_357_cov_1.098592_g20829_i0 PRJNA981359 20929 357 1.098592 3.92197344 Halanaerobiales bacterium 2094029 Bacteria Bacteria 58.2 5.61e-7   NR MBS3812162.1 2094029 g20829 i0 63.2 0.319327731092437 38 14 31.9 0 55 168 83 120 MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] diamond 114 58.2 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
29836706 29836706 PRJNA981359_S_NODE_61531_length_258_cov_1.859459_g61431_i0 PRJNA981359 61531 258 1.859459 4.79740422 Halanaerobiales bacterium 2094029 Bacteria Bacteria 51.2 4.78e-5   NR MBS3812162.1 2094029 g61431 i0 71 0.36046511627907 31 9 36 0 96 4 83 113 MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] diamond 93 51.2 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
29900102 29900102 PRJNA981359_S_NODE_59671_length_262_cov_1.238095_g59571_i0 PRJNA981359 59671 262 1.238095 3.2438089 Halanaerobiales bacterium 2094029 Bacteria Bacteria 80.1 3.28e-15   NR MBS3812162.1 2094029 g59571 i0 46.4 1.11068702290076 97 31 98.5 2 3 260 773 859 MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] diamond 291 80.1 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
30784613 30784613 PRJNA981359_S_NODE_37794_length_307_cov_3.598291_g37694_i0 PRJNA981359 37794 307 3.598291 11.04675337 Weissella cibaria 137591 Bacteria Bacteria 45.4 0.00876   NR WP_196777227.1 137591 g37694 i0 52.4 1.00651465798046 103 35 98.7 5 5 307 440 530 WP_196777227.1 hypothetical protein, partial [Weissella cibaria] diamond 309 45.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella cibaria
30816174 30816174 PRJNA981359_S_NODE_60254_length_261_cov_0.914894_g60154_i0 PRJNA981359 60254 261 0.914894 2.38787334 Paenibacillus amylolyticus 1451 Bacteria Bacteria 40.8 0.0289   NR WP_179088735.1 1451 g60154 i0 48.6 0.402298850574713 35 18 40.2 0 27 131 1 35 WP_179088735.1 hypothetical protein, partial [Paenibacillus amylolyticus] diamond 105 40.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus amylolyticus
30942740 30942740 PRJNA981359_S_NODE_33454_length_318_cov_2.546939_g33354_i0 PRJNA981359 33454 318 2.546939 8.09926602 Erysipelothrix sp. 38403 Bacteria Bacteria 206 3.49e-63   NR NLL75168.1 38403 g33354 i0 100 0.990566037735849 105 0 99.1 0 1 315 280 384 NLL75168.1 F0F1 ATP synthase subunit alpha [Erysipelothrix sp.] diamond 315 206 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Erysipelothrix Erysipelothrix sp.
30948783 30948783 PRJNA981359_S_NODE_55534_length_269_cov_3.775510_g55434_i0 PRJNA981359 55534 269 3.77551 10.1561219 root 1 Root_unresolved Root_unresolved 42.7 0.00654   NR WP_319443985.1 1307 g55434 i0 65.5 0.814126394052045 29 10 32.3 0 232 146 28 56 WP_319443985.1 hypothetical protein, partial [Streptococcus suis] diamond 219 42.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus suis
31069167 31069167 PRJNA981359_S_NODE_27275_length_335_cov_3.290076_g27175_i0 PRJNA981359 27275 335 3.290076 11.0217546 Bacillus subtilis 1423 Bacteria Bacteria 46.2 0.00357   NR WP_322840250.1 1423 g27175 i0 56.8 0.698507462686567 44 18 38.5 1 129 1 96 139 WP_322840250.1 endonuclease/exonuclease/phosphatase family protein, partial [Bacillus subtilis] diamond 234 46.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus subtilis
31701391 31701391 PRJNA981359_S_NODE_50117_length_280_cov_2.695652_g50017_i0 PRJNA981359 50117 280 2.695652 7.5478256 Staphylococcus aureus 1280 Bacteria Bacteria 45.1 0.00248   NR WP_178137632.1 1280 g50017 i0 53.2 1.00714285714286 94 25 88.9 5 27 275 17 102 WP_178137632.1 hypothetical protein, partial [Staphylococcus aureus] diamond 282 45.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31764652 31764652 PRJNA981359_S_NODE_51697_length_277_cov_2.284314_g51597_i0 PRJNA981359 51697 277 2.284314 6.32754978 Halanaerobiales bacterium 2094029 Bacteria Bacteria 87.8 7.89e-18   NR MBS3812162.1 2094029 g51597 i0 63.2 0.823104693140794 76 25 80.1 2 224 3 789 863 MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] diamond 228 87.8 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
32901914 32901914 PRJNA981359_S_NODE_44240_length_293_cov_1.386364_g44140_i0 PRJNA981359 44240 293 1.386364 4.06204652 Candidatus Onthovivens sp. 2952951 Bacteria Bacteria 43.9 0.024   NR MDY2727466.1 2952951 g44140 i0 34.8 0.675767918088737 66 40 67.6 1 46 243 56 118 MDY2727466.1 TraX family protein [Candidatus Onthovivens sp.] diamond 198 43.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Candidatus Onthovivens Candidatus Onthovivens sp.

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