RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA681861" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA681861 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
26904063 26904063 PRJNA681861_P_NODE_22661_length_282_cov_2.387352_g20561_i0 PRJNA681861 22661 282 2.387352 6.73233264 Heyndrickxia 2837504 Bacteria Bacteria 53.1 3.43e-6   NR GIN83968.1 46224 g20561 i0 55.4 1.1595744680851101 56 25 59.6 0 172 5 37 92 GIN83968.1 hypothetical protein J6TS2_03540 [Heyndrickxia sporothermodurans] diamond 327 53.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Heyndrickxia Heyndrickxia sporothermodurans
27082043 27082043 PRJNA681861_P_NODE_19882_length_318_cov_4.020761_g17782_i0 PRJNA681861 19882 318 4.020761 12.78601998 Gemella haemolysans 1379 Bacteria Bacteria 95.5 2.81e-20   NR WP_204641379.1 1379 g17782 i0 79.7 0.556603773584906 59 12 55.7 0 2 178 2032 2090 WP_204641379.1 YSIRK-type signal peptide-containing protein [Gemella haemolysans] diamond 177 95.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
27650838 27650838 PRJNA681861_P_NODE_28384_length_227_cov_3.297980_g26284_i0 PRJNA681861 28384 227 3.29798 7.4864146 Streptococcus shenyangsis 2589786 Bacteria Bacteria 144 4.24e-38   NR WP_216629101.1 2589786 g26284 i0 100 0.991189427312775 75 0 99.1 0 226 2 1816 1890 WP_216629101.1 Ig-like domain-containing protein, partial [Streptococcus shenyangsis] diamond 225 144 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus shenyangsis
28629702 28629702 PRJNA681861_P_NODE_33447_length_198_cov_34.130178_g31347_i0 PRJNA681861 33447 198 34.130178 67.57775244 Staphylococcus aureus 1280 Bacteria Bacteria 66.6 1.91e-12   NR MCS4580470.1 1280 g31347 i0 100 0.666666666666667 44 0 66.7 0 3 134 1 44 MCS4580470.1 hypothetical protein [Staphylococcus aureus] diamond 132 66.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
29134924 29134924 PRJNA681861_P_NODE_10949_length_548_cov_3.990366_g9001_i0 PRJNA681861 10949 548 3.990366 21.86720568 Limosilactobacillus urinaemulieris 2742600 Bacteria Bacteria 47.4 0.00126   NR WP_206683839.1 2742600 g9001 i0 100 0.142335766423358 26 0 14.2 0 533 456 4 29 WP_206683839.1 hypothetical protein, partial [Limosilactobacillus urinaemulieris] diamond 78 47.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Limosilactobacillus Limosilactobacillus urinaemulieris
30840344 30840344 PRJNA681861_P_NODE_6334_length_863_cov_3.347722_g4878_i0 PRJNA681861 6334 863 3.347722 28.89084086 Limosilactobacillus urinaemulieris 2742600 Bacteria Bacteria 47.4 0.00324   NR WP_206683839.1 2742600 g4878 i0 100 0.0903823870220162 26 0 9 0 16 93 4 29 WP_206683839.1 hypothetical protein, partial [Limosilactobacillus urinaemulieris] diamond 78 47.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Limosilactobacillus Limosilactobacillus urinaemulieris
31155940 31155940 PRJNA681861_P_NODE_27615_length_233_cov_3.715686_g25515_i0 PRJNA681861 27615 233 3.715686 8.65754838 Streptococcus pneumoniae 1313 Bacteria Bacteria 67.4 1.42e-11   NR MDG9168660.1 1313 g25515 i0 88.2 0.437768240343348 34 4 43.8 0 2 103 2 35 MDG9168660.1 hypothetical protein [Streptococcus pneumoniae] diamond 102 67.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31282664 31282664 PRJNA681861_P_NODE_13155_length_464_cov_2.944828_g11127_i0 PRJNA681861 13155 464 2.944828 13.66400192 Heyndrickxia sporothermodurans 46224 Bacteria Bacteria 133 3.82e-37   NR GIN83967.1 46224 g11127 i0 58.8 0.737068965517241 114 43 73.1 2 121 459 2 112 GIN83967.1 hypothetical protein J6TS2_03530 [Heyndrickxia sporothermodurans] diamond 342 133 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Heyndrickxia Heyndrickxia sporothermodurans

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