RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA397736" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 3

tax_superkingdom 1

  • Bacteria · 20 ✖

bioproject 1

  • PRJNA397736 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
26617294 26617294 PRJNA397736_S_NODE_2001_length_191_cov_15.913580_g1965_i0 PRJNA397736 2001 191 15.91358 30.3949378 root 1 Root_unresolved Root_unresolved 126 7.91e-36   NR WP_214674608.1 562 g1965 i0 98.4 72.2356020942408 63 1 99 0 3 191 25 87 WP_214674608.1 hypothetical protein, partial [Escherichia coli] diamond 13797 127 0.992125984251969 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
26712025 26712025 PRJNA397736_S_NODE_1261_length_249_cov_5.981818_g1225_i0 PRJNA397736 1261 249 5.981818 14.89472682 root 1 Root_unresolved Root_unresolved 165 1.12e-50   NR MDK0657390.1 1502 g1225 i0 98.8 77.0602409638554 82 1 98.8 0 2 247 27 108 MDK0657390.1 30S ribosomal protein S8 [Clostridium perfringens] diamond 19188 166 0.993975903614458 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
26790667 26790667 PRJNA397736_S_NODE_441_length_444_cov_3.879518_g406_i0 PRJNA397736 441 444 3.879518 17.22505992 Eubacterium sp. 142586 Bacteria Bacteria 64.3 7.23e-9   NR MDE6469480.1 142586 g406 i0 31.6 1.75 133 73 83.1 4 56 424 206 330 MDE6469480.1 glycoside hydrolase family 18 protein [Eubacterium sp.] diamond 777 64.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
27012046 27012046 PRJNA397736_S_NODE_1882_length_199_cov_3.505882_g1846_i0 PRJNA397736 1882 199 3.505882 6.97670518 Salmonella enterica 28901 Bacteria Bacteria 67.4 2.96e-12   NR MEY6259408.1 593905 g1846 i0 100 3.46733668341709 33 0 49.7 0 198 100 23 55 MEY6259408.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Corvallis] diamond 690 67.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
27296649 27296649 PRJNA397736_S_NODE_1563_length_222_cov_3.979275_g1527_i0 PRJNA397736 1563 222 3.979275 8.8339905 Deinococcus radiophilus 32062 Bacteria Bacteria 40.8 0.0315   NR WP_126353034.1 32062 g1527 i0 40 0.675675675675676 50 20 67.6 1 72 221 48 87 WP_126353034.1 hypothetical protein [Deinococcus radiophilus] diamond 150 40.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus
28355322 28355322 PRJNA397736_S_NODE_2466_length_170_cov_4.127660_g2430_i0 PRJNA397736 2466 170 4.12766 7.017022 root 1 Root_unresolved Root_unresolved 109 1.9e-29   NR MRB67503.1 1428 g2430 i0 98.2 238.147058823529 56 1 98.8 0 3 170 55 110 MRB67503.1 30S ribosomal protein S11 [Bacillus thuringiensis] diamond 40485 110 0.990909090909091 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
28433453 28433453 PRJNA397736_S_NODE_666_length_359_cov_12.572727_g630_i0 PRJNA397736 666 359 12.572727 45.13608993 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 44.7 0.0288   NR MBY0495846.1 2847862 g630 i0 33.3 0.501392757660167 60 27 39.3 3 299 159 346 405 MBY0495846.1 penicillin acylase family protein [Cyanobacteriota bacterium] diamond 180 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28717672 28717672 PRJNA397736_S_NODE_2807_length_158_cov_3.945736_g2771_i0 PRJNA397736 2807 158 3.945736 6.23426288 Enterobacter hormaechei 158836 Bacteria Bacteria 113 7.489999999999999e-30   NR WP_149350502.1 158836 g2771 i0 100 50.1835443037975 52 0 98.7 0 158 3 136 187 WP_149350502.1 hypothetical protein, partial [Enterobacter hormaechei] diamond 7929 113 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
29222935 29222935 PRJNA397736_S_NODE_409_length_461_cov_15.081019_g374_i0 PRJNA397736 409 461 15.081019 69.52349759 bacterium 1869227 Bacteria Bacteria 77 9.07e-15   NR MFQ5906323.1 1869227 g374 i0 58.2 0.839479392624729 67 27 43.6 1 255 55 66 131 MFQ5906323.1 nucleoside-diphosphate kinase [bacterium] diamond 387 77 1 Bacteria               bacterium
29254096 29254096 PRJNA397736_S_NODE_1909_length_197_cov_5.125000_g1873_i0 PRJNA397736 1909 197 5.125 10.09625 Klebsiella pneumoniae 573 Bacteria Bacteria 135 1.85e-38   NR KAB1688404.1 573 g1873 i0 98.5 60.3807106598985 65 1 99 0 197 3 17 81 KAB1688404.1 hypothetical protein FNE65_30290, partial [Klebsiella pneumoniae] diamond 11895 135 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29365843 29365843 PRJNA397736_S_NODE_2549_length_166_cov_2.737226_g2513_i0 PRJNA397736 2549 166 2.737226 4.54379516 root 1 Root_unresolved Root_unresolved 105 2.25e-27   NR WP_240057741.1 573 g2513 i0 100 135.180722891566 55 0 99.4 0 2 166 47 101 WP_240057741.1 cation-transporting P-type ATPase, partial [Klebsiella pneumoniae] diamond 22440 105 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29790881 29790881 PRJNA397736_S_NODE_431_length_448_cov_4.720764_g396_i0 PRJNA397736 431 448 4.720764 21.14902272 Salmonella enterica 28901 Bacteria Bacteria 50.1 7.07e-5   NR MEY6403347.1 593905 g396 i0 69.8 0.743303571428571 43 12 28.1 1 447 322 25 67 MEY6403347.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Corvallis] diamond 333 50.4 0.994047619047619 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
29885998 29885998 PRJNA397736_S_NODE_2351_length_175_cov_11.335616_g2315_i0 PRJNA397736 2351 175 11.335616 19.837328 Salmonella enterica 28901 Bacteria Bacteria 114 2.6199999999999997e-30   NR MEY6333246.1 593905 g2315 i0 98.3 21.8742857142857 58 1 99.4 0 175 2 58 115 MEY6333246.1 Hsp70 family protein [Salmonella enterica subsp. enterica serovar Corvallis] diamond 3828 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
30282088 30282088 PRJNA397736_S_NODE_1452_length_232_cov_5.517241_g1416_i0 PRJNA397736 1452 232 5.517241 12.79999912 root 1 Root_unresolved Root_unresolved 151 1.06e-45   NR WP_248807857.1 573 g1416 i0 100 81.6336206896552 77 0 99.6 0 231 1 25 101 WP_248807857.1 KH domain-containing protein, partial [Klebsiella pneumoniae] diamond 18939 151 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30802003 30802003 PRJNA397736_S_NODE_2194_length_182_cov_36.326797_g2158_i0 PRJNA397736 2194 182 36.326797 66.11477054 Helicobacter pylori 210 Bacteria Bacteria 84 6.27e-20   NR GAA8838853.1 210 g2158 i0 92.9 0.692307692307692 42 3 69.2 0 175 50 2 43 GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori] diamond 126 84 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30865197 30865197 PRJNA397736_S_NODE_1894_length_198_cov_8.804734_g1858_i0 PRJNA397736 1894 198 8.804734 17.43337332 Marmoricola sp. 1909296 Bacteria Bacteria 67.4 4.03e-11   NR MCW2763450.1 1909296 g1858 i0 50.8 0.924242424242424 61 28 92.4 1 191 9 269 327 MCW2763450.1 hypothetical protein [Marmoricola sp.] diamond 183 67.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Marmoricola Marmoricola sp.
31292751 31292751 PRJNA397736_S_NODE_2235_length_180_cov_5.556291_g2199_i0 PRJNA397736 2235 180 5.556291 10.0013238 root 1 Root_unresolved Root_unresolved 112 1.01e-29   NR WP_175283833.1 562 g2199 i0 100 217.433333333333 58 0 96.7 0 175 2 61 118 WP_175283833.1 Hsp70 family protein, partial [Escherichia coli] diamond 39138 112 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31577578 31577578 PRJNA397736_S_NODE_516_length_407_cov_15.396825_g481_i0 PRJNA397736 516 407 15.396825 62.66507775 Pseudomonadati 3379134 Bacteria Bacteria 65.9 1.18e-9   NR OJF76583.1 1908540 g481 i0 37.9 3.1031941031941 103 63 75.9 1 98 406 142 243 OJF76583.1 MAG: 5'-nucleotidase [Treponema sp. CETP13] diamond 1263 66.2 0.995468277945619 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. CETP13
31781974 31781974 PRJNA397736_S_NODE_2137_length_185_cov_6.576923_g2101_i0 PRJNA397736 2137 185 6.576923 12.16730755 Streptococcus pneumoniae 1313 Bacteria Bacteria 89.4 1.41e-21   NR MDG7606462.1 1313 g2101 i0 97.5 0.648648648648649 40 1 64.9 0 185 66 1 40 MDG7606462.1 hypothetical protein [Streptococcus pneumoniae] diamond 120 89.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32178765 32178765 PRJNA397736_S_NODE_1958_length_194_cov_4.860606_g1922_i0 PRJNA397736 1958 194 4.860606 9.42957564 root 1 Root_unresolved Root_unresolved 107 2.6e-28   NR WP_353960168.1 573 g1922 i0 100 59.1494845360825 51 0 78.9 0 192 40 66 116 WP_353960168.1 50S ribosomal protein L14 [Klebsiella pneumoniae] diamond 11475 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae

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