RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA495917" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA495917 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
26965934 26965934 PRJNA495917_S_NODE_12602_length_162_cov_2.748031_g12408_i0 PRJNA495917 12602 162 2.748031 4.45181022 root 1 Root_unresolved Root_unresolved 107 1.68e-28   NR MBH0219721.1 1639 g12408 i0 98.1 270.611111111111 52 1 96.3 0 2 157 34 85 MBH0219721.1 Hsp70 family protein [Listeria monocytogenes] diamond 43839 108 0.990740740740741 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
28340284 28340284 PRJNA495917_S_NODE_15046_length_155_cov_1.000000_g14852_i0 PRJNA495917 15046 155 1 1.55 Paenibacillus odorifer 189426 Bacteria Bacteria 52.4 4.43e-6   NR WP_076106539.1 189426 g14852 i0 50 0.929032258064516 48 24 92.9 0 12 155 331 378 WP_076106539.1 NosD domain-containing protein [Paenibacillus odorifer] diamond 144 52.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus odorifer
30203114 30203114 PRJNA495917_S_NODE_13112_length_161_cov_0.952381_g12918_i0 PRJNA495917 13112 161 0.952381 1.53333341 Caldalkalibacillus thermarum 296745 Bacteria Bacteria 73.9 3.1e-14   NR WP_007503174.1 296745 g12918 i0 81 0.782608695652174 42 8 78.3 0 3 128 39 80 WP_007503174.1 N-acetylmuramoyl-L-alanine amidase [Caldalkalibacillus thermarum] diamond 126 73.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Caldalkalibacillus Caldalkalibacillus thermarum
30250734 30250734 PRJNA495917_S_NODE_13132_length_161_cov_0.952381_g12938_i0 PRJNA495917 13132 161 0.952381 1.53333341 Bacteria 2 Bacteria Bacteria 107 2.2399999999999993e-28   NR MFV7869607.1 1352 g12938 i0 100 2.96273291925466 53 0 98.8 0 2 160 43 95 MFV7869607.1 hypothetical protein [Enterococcus faecium] diamond 477 107 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
30629482 30629482 PRJNA495917_S_NODE_10213_length_173_cov_4.746377_g10019_i0 PRJNA495917 10213 173 4.746377 8.21123221 root 1 Root_unresolved Root_unresolved 61.6 3.08e-9   NR QHG77622.1 1280 g10019 i0 85.7 19.4219653179191 56 6 97.1 1 169 2 22 75 QHG77622.1 30S ribosomal protein S5 [Staphylococcus aureus] diamond 3360 62 0.993548387096774 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30677165 30677165 PRJNA495917_S_NODE_16533_length_151_cov_1.025862_g16339_i0 PRJNA495917 16533 151 1.025862 1.54905162 Ferroacidibacillus organovorans 1765683 Bacteria Bacteria 75.1 2.09e-15   NR WP_067567365.1 1765683 g16339 i0 76.2 1.80794701986755 42 10 83.4 0 21 146 109 150 WP_067567365.1 DinB family protein [Ferroacidibacillus organovorans] diamond 273 75.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Alicyclobacillaceae Ferroacidibacillus Ferroacidibacillus organovorans
31309261 31309261 PRJNA495917_S_NODE_6555_length_202_cov_1.437126_g6361_i0 PRJNA495917 6555 202 1.437126 2.90299452 Bacillus thuringiensis 1428 Bacteria Bacteria 90.9 2.34e-19   NR WP_176581311.1 1428 g6361 i0 60.6 0.98019801980198 66 26 98 0 200 3 689 754 WP_176581311.1 right-handed parallel beta-helix repeat-containing protein [Bacillus thuringiensis] diamond 198 90.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
31340969 31340969 PRJNA495917_S_NODE_1976_length_345_cov_57.970968_g1782_i0 PRJNA495917 1976 345 57.970968 199.9998396 Criibacterium bergeronii 1871336 Bacteria Bacteria 133 8.499999999999999e-38   NR RDY20310.1 1871336 g1782 i0 98 1.85217391304348 101 2 87.8 0 8 310 1 101 RDY20310.1 hypothetical protein BBG48_010870, partial [Criibacterium bergeronii] diamond 639 133 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Filifactoraceae Criibacterium Criibacterium bergeronii
32384935 32384935 PRJNA495917_S_NODE_3699_length_255_cov_2.745455_g3505_i0 PRJNA495917 3699 255 2.745455 7.00091025 Bacillaceae 186817 Bacteria Bacteria 64.7 2.48e-11   NR WP_053071327.1 186817 g3505 i0 40.2 1.55294117647059 82 49 96.5 0 255 10 4 85 WP_053071327.1 MULTISPECIES: YncE family protein [Bacillaceae] diamond 396 64.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae    

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