RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA562549" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA562549 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27616359 27616359 PRJNA562549_P_NODE_33204_length_208_cov_0.884354_g32971_i0 PRJNA562549 33204 208 0.884354 1.83945632 Bacillota bacterium 1879010 Bacteria Bacteria 46.2 4.84e-4   NR HYH05358.1 1879010 g32971 i0 56.3 0.461538461538462 32 13 44.7 1 10 102 84 115 HYH05358.1 hypothetical protein [Bacillota bacterium] diamond 96 46.2 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
28798153 28798153 PRJNA562549_P_NODE_36467_length_202_cov_0.921986_g36234_i0 PRJNA562549 36467 202 0.921986 1.86241172 root 1 Root_unresolved Root_unresolved 53.9 1.37e-6   NR WP_204516196.1 1125967 g36234 i0 43.4 5.64356435643564 53 30 78.7 0 172 14 106 158 WP_204516196.1 DsbA family oxidoreductase [Brevibacillus fulvus] diamond 1140 53.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus fulvus
28974102 28974102 PRJNA562549_P_NODE_5068_length_510_cov_9.062361_g4843_i0 PRJNA562549 5068 510 9.062361 46.2180411 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 68.6 9.29e-12   NR WP_252130143.1 1590 g4843 i0 80 2.11764705882353 40 8 23.5 0 510 391 50 89 WP_252130143.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 1080 68.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
30805897 30805897 PRJNA562549_P_NODE_32034_length_210_cov_0.872483_g31801_i0 PRJNA562549 32034 210 0.872483 1.8322143 Exiguobacterium mexicanum 340146 Bacteria Bacteria 123 6.879999999999999e-34   NR MFN3367734.1 340146 g31801 i0 97.1 1 70 2 100 0 210 1 89 158 MFN3367734.1 hypothetical protein [Exiguobacterium mexicanum] diamond 210 123 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium Exiguobacterium mexicanum
31184735 31184735 PRJNA562549_P_NODE_34855_length_205_cov_0.902778_g34622_i0 PRJNA562549 34855 205 0.902778 1.8506949 Clostridium sp. 1506 Bacteria Bacteria 45.1 0.00355   NR WP_333887201.1 1506 g34622 i0 41.3 0.673170731707317 46 27 67.3 0 204 67 579 624 WP_333887201.1 hypothetical protein [Clostridium sp.] diamond 138 45.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
32387074 32387074 PRJNA562549_P_NODE_30159_length_215_cov_1.636364_g29926_i0 PRJNA562549 30159 215 1.636364 3.5181826 Clostridia bacterium 2044939 Bacteria Bacteria 42 0.049   NR MBR3739319.1 2044939 g29926 i0 41.7 0.669767441860465 48 27 65.6 1 44 184 506 553 MBR3739319.1 GNAT family N-acetyltransferase [Clostridia bacterium] diamond 144 42 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32797031 32797031 PRJNA562549_P_NODE_24400_length_237_cov_2.215909_g24167_i0 PRJNA562549 24400 237 2.215909 5.25170433 Gordoniibacillus kamchatkensis 1590651 Bacteria Bacteria 57 1.38e-7   NR WP_041047251.1 1590651 g24167 i0 40.3 1.86075949367089 77 45 97.5 1 5 235 19 94 WP_041047251.1 hypothetical protein [Gordoniibacillus kamchatkensis] diamond 441 57 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Gordoniibacillus Gordoniibacillus kamchatkensis

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