RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA188516 · 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
365811 365811 PRJNA188516_P_NODE_4741_length_167_cov_0.881356_g4691_i0 PRJNA188516 4741 167 0.881356 1.47186452 Bacillales 1385 Bacteria Bacteria 102 1.04e-24   NR WP_040928296.1 489909 g4691 i0 98.2 1.97604790419162 55 1 98.8 0 167 3 228 282 WP_040928296.1 MULTISPECIES: ATP synthase F1 subunit gamma [Nosocomiicoccus] diamond 330 103 0.990291262135922 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Nosocomiicoccus  
27231956 27231956 PRJNA188516_P_NODE_3083_length_195_cov_0.931507_g3033_i0 PRJNA188516 3083 195 0.931507 1.81643865 Streptococcus pneumoniae 1313 Bacteria Bacteria 41.6 0.00595   NR MFR7015324.1 1313 g3033 i0 61.3 0.476923076923077 31 12 47.7 0 103 195 26 56 MFR7015324.1 hypothetical protein [Streptococcus pneumoniae] diamond 93 41.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
29726218 29726218 PRJNA188516_P_NODE_270_length_778_cov_6.171468_g235_i0 PRJNA188516 270 778 6.171468 48.01402104 Lacticaseibacillus paracasei 1597 Bacteria Bacteria 52.8 5.34e-5   NR WP_273958772.1 1597 g235 i0 50 0.223650385604113 58 29 22.4 0 603 776 39 96 WP_273958772.1 hypothetical protein [Lacticaseibacillus paracasei] diamond 174 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus paracasei
29947621 29947621 PRJNA188516_P_NODE_4871_length_166_cov_0.888889_g4821_i0 PRJNA188516 4871 166 0.888889 1.47555574 Staphylococcus warneri 1292 Bacteria Bacteria 66.6 1.84e-12   NR MDU6255149.1 1292 g4821 i0 57.4 0.975903614457831 54 23 97.6 0 162 1 43 96 MDU6255149.1 hypothetical protein [Staphylococcus warneri] diamond 162 66.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
30010907 30010907 PRJNA188516_P_NODE_6151_length_162_cov_0.920354_g6101_i0 PRJNA188516 6151 162 0.920354 1.49097348 Jeotgalicoccus halotolerans 157227 Bacteria Bacteria 103 5.22e-24   NR WP_115885056.1 157227 g6101 i0 94.3 0.981481481481482 53 3 98.1 0 2 160 329 381 WP_115885056.1 BCCT family transporter [Jeotgalicoccus halotolerans] diamond 159 103 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Jeotgalicoccus Jeotgalicoccus halotolerans
30800515 30800515 PRJNA188516_P_NODE_5054_length_166_cov_0.880342_g5004_i0 PRJNA188516 5054 166 0.880342 1.46136772 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 62 4.62e-10   NR HCM92348.1 1898203 g5004 i0 54.9 0.921686746987952 51 23 92.2 0 5 157 111 161 HCM92348.1 adenine phosphoribosyltransferase [Lachnospiraceae bacterium] diamond 153 62 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
31717439 31717439 PRJNA188516_P_NODE_5137_length_165_cov_0.896552_g5087_i0 PRJNA188516 5137 165 0.896552 1.4793108 Anthropogastromicrobium aceti 2981768 Bacteria Bacteria 102 2.5999999999999996e-24   NR WP_262537636.1 2981768 g5087 i0 100 4.90909090909091 54 0 98.2 0 3 164 77 130 WP_262537636.1 substrate-binding domain-containing protein [Anthropogastromicrobium aceti] diamond 810 102 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Anthropogastromicrobium Anthropogastromicrobium aceti
32350412 32350412 PRJNA188516_P_NODE_5939_length_162_cov_0.920354_g5889_i0 PRJNA188516 5939 162 0.920354 1.49097348 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 41.6 0.0311   NR MCL1820674.1 2485925 g5889 i0 46.2 0.722222222222222 39 16 63 1 56 157 201 239 MCL1820674.1 glycoside hydrolase family 43 protein [Oscillospiraceae bacterium] diamond 117 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32683739 32683739 PRJNA188516_P_NODE_5380_length_164_cov_0.904348_g5330_i0 PRJNA188516 5380 164 0.904348 1.48313072 Lachnoanaerobaculum 1164882 Bacteria Bacteria 84.7 1.82e-19   NR MBF1260553.1 2049030 g5330 i0 89.6 2.63414634146341 48 2 82.3 1 135 1 1 48 MBF1260553.1 endonuclease/exonuclease/phosphatase family protein [Lachnoanaerobaculum sp.] diamond 432 84.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lachnoanaerobaculum Lachnoanaerobaculum 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);;