RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA559720" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA559720 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
26712900 26712900 PRJNA559720_P_NODE_6481_length_402_cov_1.151976_g6342_i0 PRJNA559720 6481 402 1.1519760000000001 4.63094352 Cohnella 329857 Bacteria Bacteria 104 2.35e-25   NR WP_204602556.1 768479 g6342 i0 42.9 1.78358208955224 119 68 88.8 0 368 12 23 141 WP_204602556.1 acyl-CoA thioesterase [Cohnella boryungensis] diamond 717 104 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella boryungensis
26794197 26794197 PRJNA559720_P_NODE_7881_length_359_cov_1.076923_g7742_i0 PRJNA559720 7881 359 1.076923 3.86615357 Clostridiales bacterium 1898207 Bacteria Bacteria 88.2 2.95e-18   NR MBF0987186.1 1898207 g7742 i0 48.6 6.05013927576602 105 51 86.1 3 359 51 3 106 MBF0987186.1 aldo/keto reductase [Clostridiales bacterium] diamond 2172 88.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28987960 28987960 PRJNA559720_P_NODE_15108_length_245_cov_1.790698_g14969_i0 PRJNA559720 15108 245 1.790698 4.3872101 Ruminococcus 1263 Bacteria Bacteria 144 4.69e-41   NR WP_044976680.1 1514668 g14969 i0 76.9 1.91020408163265 78 18 95.5 0 235 2 1 78 WP_044976680.1 pyruvate formate-lyase-activating protein [Ruminococcus sp. HUN007] diamond 468 144 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp. HUN007
29510363 29510363 PRJNA559720_P_NODE_15930_length_242_cov_1.668639_g15791_i0 PRJNA559720 15930 242 1.668639 4.03810638 Lactobacillus crispatus 47770 Bacteria Bacteria 86.7 2.58e-20   NR WP_205758276.1 47770 g15791 i0 95.7 0.867768595041322 70 3 86.8 0 3 212 5 74 WP_205758276.1 hypothetical protein, partial [Lactobacillus crispatus] diamond 210 86.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
30300569 30300569 PRJNA559720_P_NODE_4732_length_478_cov_10.101235_g4594_i0 PRJNA559720 4732 478 10.101235 48.2839033 Clostridium lundense 319475 Bacteria Bacteria 144 3.71e-41   NR WP_027623586.1 319475 g4594 i0 58.1 3.82217573221757 124 50 76.6 1 448 83 2 125 WP_027623586.1 RidA family protein [Clostridium lundense] diamond 1827 144 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium lundense
30458508 30458508 PRJNA559720_P_NODE_16453_length_241_cov_0.916667_g16314_i0 PRJNA559720 16453 241 0.916667 2.20916747 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 48.1 7.1e-5   NR WP_222850852.1 1590 g16314 i0 57.1 0.435684647302905 35 15 43.6 0 127 23 66 100 WP_222850852.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 105 48.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
30932081 30932081 PRJNA559720_P_NODE_13334_length_253_cov_1.283333_g13195_i0 PRJNA559720 13334 253 1.283333 3.24683249 Bacilli bacterium 1903720 Bacteria Bacteria 42.7 0.0413   NR MBQ2873053.1 1903720 g13195 i0 30.4 0.936758893280632 79 52 90.1 1 20 247 136 214 MBQ2873053.1 insulinase family protein [Bacilli bacterium] diamond 237 42.7 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
31184510 31184510 PRJNA559720_P_NODE_6475_length_402_cov_1.422492_g6336_i0 PRJNA559720 6475 402 1.422492 5.71841784 Peptoniphilaceae bacterium 1891242 Bacteria Bacteria 46.2 0.00754   NR MDD7463520.1 1891242 g6336 i0 33.7 0.708955223880597 95 51 67.2 4 293 24 18 105 MDD7463520.1 AraC family transcriptional regulator [Peptoniphilaceae bacterium] diamond 285 46.2 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae   Peptoniphilaceae bacterium
31564592 31564592 PRJNA559720_P_NODE_5816_length_427_cov_1.553672_g5677_i0 PRJNA559720 5816 427 1.553672 6.63417944 Clostridia bacterium 2044939 Bacteria Bacteria 45.4 0.027   NR MBR3697310.1 2044939 g5677 i0 30.4 0.786885245901639 112 69 78.7 2 395 60 255 357 MBR3697310.1 DNA polymerase III subunit gamma/tau [Clostridia bacterium] diamond 336 45.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31817242 31817242 PRJNA559720_P_NODE_6617_length_397_cov_3.191358_g6478_i0 PRJNA559720 6617 397 3.191358 12.66969126 Holdemanella biformis 1735 Bacteria Bacteria 47.8 0.00343   NR WP_118356857.1 1735 g6478 i0 35.7 0.846347607052897 112 61 80.9 4 347 27 115 220 WP_118356857.1 DEAD/DEAH box helicase [Holdemanella biformis] diamond 336 47.8 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Holdemanella Holdemanella biformis
32796827 32796827 PRJNA559720_P_NODE_15740_length_243_cov_0.905882_g15601_i0 PRJNA559720 15740 243 0.905882 2.20129326 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 171 1.59e-49   NR MCQ2499216.1 1898203 g15601 i0 97.5 0.987654320987654 80 2 98.8 0 3 242 234 313 MCQ2499216.1 AAA family ATPase [Lachnospiraceae bacterium] diamond 240 171 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium

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