RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA397733" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA397733 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
26726809 26726809 PRJNA397733_S_NODE_4421_length_290_cov_8.628352_g4333_i0 PRJNA397733 4421 290 8.628352 25.0222208 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 45.4 0.00253   NR MFO1258777.1 1913989 g4333 i0 29.5 0.631034482758621 61 37 56.9 1 225 61 5 65 MFO1258777.1 cytochrome c-type biogenesis protein [Gammaproteobacteria bacterium] diamond 183 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
26743545 26743545 PRJNA397733_S_NODE_15001_length_158_cov_5.488372_g14913_i0 PRJNA397733 15001 158 5.488372 8.67162776 root 1 Root_unresolved Root_unresolved 113 4.45e-29   NR MCT5795657.1 287 g14913 i0 98.1 309 52 1 98.7 0 156 1 62 113 MCT5795657.1 GTP-binding protein [Pseudomonas aeruginosa] diamond 48822 113 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
26885747 26885747 PRJNA397733_S_NODE_7181_length_226_cov_2.263959_g7093_i0 PRJNA397733 7181 226 2.263959 5.11654734 Burkholderia pseudomallei 28450 Bacteria Bacteria 42.7 0.031   NR WP_004526659.1 28450 g7093 i0 34.8 1.75221238938053 66 42 86.3 1 210 16 547 612 WP_004526659.1 patatin-like protein [Burkholderia pseudomallei] diamond 396 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia pseudomallei
27138147 27138147 PRJNA397733_S_NODE_7862_length_215_cov_2.413978_g7774_i0 PRJNA397733 7862 215 2.413978 5.1900527 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 42.4 0.0349   NR MEK9822671.1 1913989 g7774 i0 40 0.767441860465116 55 29 76.7 1 183 19 208 258 MEK9822671.1 GGDEF domain-containing protein [Gammaproteobacteria bacterium] diamond 165 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
27169956 27169956 PRJNA397733_S_NODE_16402_length_152_cov_3.699187_g16314_i0 PRJNA397733 16402 152 3.699187 5.62276424 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 75.5 1.2e-16   NR MCP3666119.1 1913989 g16314 i0 86.4 0.868421052631579 44 6 86.8 0 132 1 1 44 MCP3666119.1 tetratricopeptide repeat protein [Gammaproteobacteria bacterium] diamond 132 75.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
27233438 27233438 PRJNA397733_S_NODE_5163_length_267_cov_3.210084_g5075_i0 PRJNA397733 5163 267 3.210084 8.57092428 Serratia marcescens 615 Bacteria Bacteria 43.1 0.0362   NR WP_172448222.1 615 g5075 i0 31.1 2.02247191011236 90 51 92.1 3 4 249 34 120 WP_172448222.1 MFS transporter [Serratia marcescens] diamond 540 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Serratia Serratia marcescens
27629397 27629397 PRJNA397733_S_NODE_5864_length_249_cov_15.100000_g5776_i0 PRJNA397733 5864 249 15.1 37.599 root 1 Root_unresolved Root_unresolved 137 1.03e-39   NR WP_353960168.1 573 g5776 i0 100 46.7951807228916 66 0 79.5 0 3 200 51 116 WP_353960168.1 50S ribosomal protein L14 [Klebsiella pneumoniae] diamond 11652 137 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27707630 27707630 PRJNA397733_S_NODE_3984_length_306_cov_8.960289_g3896_i0 PRJNA397733 3984 306 8.960289 27.41848434 Vibrio vulnificus 672 Bacteria Bacteria 72 2.86e-14   NR WP_224657775.1 672 g3896 i0 67.9 0.519607843137255 53 17 52 0 223 65 1 53 WP_224657775.1 hypothetical protein, partial [Vibrio vulnificus] diamond 159 72 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio vulnificus
28071183 28071183 PRJNA397733_S_NODE_7065_length_227_cov_16.237374_g6977_i0 PRJNA397733 7065 227 16.237374 36.85883898 root 1 Root_unresolved Root_unresolved 132 4e-38   NR WP_224642557.1 672 g6977 i0 98.3 21.8325991189427 59 1 78 0 1 177 61 119 WP_224642557.1 ubiquitin-40S ribosomal protein S27a family protein, partial [Vibrio vulnificus] diamond 4956 132 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio vulnificus
28102682 28102682 PRJNA397733_S_NODE_16625_length_151_cov_12.491803_g16537_i0 PRJNA397733 16625 151 12.491803 18.86262253 root 1 Root_unresolved Root_unresolved 96.7 3.8199999999999996e-23   NR WP_065392632.1 644 g16537 i0 96 77.2847682119205 50 2 99.3 0 2 151 117 166 WP_065392632.1 50S ribosomal protein L16, partial [Aeromonas hydrophila] diamond 11670 97.1 0.995880535530381 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas hydrophila
28481721 28481721 PRJNA397733_S_NODE_11386_length_179_cov_5.293333_g11298_i0 PRJNA397733 11386 179 5.293333 9.47506607 root 1 Root_unresolved Root_unresolved 114 7.35e-32   NR WP_353960205.1 573 g11298 i0 100 143.36312849162 59 0 98.9 0 178 2 13 71 WP_353960205.1 nascent polypeptide-associated complex subunit family protein, partial [Klebsiella pneumoniae] diamond 25662 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28496671 28496671 PRJNA397733_S_NODE_8307_length_208_cov_7.648045_g8219_i0 PRJNA397733 8307 208 7.648045 15.9079336 Pseudomonas aeruginosa 287 Bacteria Bacteria 41.2 0.019   NR WP_128653067.1 287 g8219 i0 41.5 0.764423076923077 53 26 72.1 2 154 5 27 77 WP_128653067.1 helix-turn-helix transcriptional regulator [Pseudomonas aeruginosa] diamond 159 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
28671260 28671260 PRJNA397733_S_NODE_5147_length_267_cov_18.453782_g5059_i0 PRJNA397733 5147 267 18.453782 49.27159794 root 1 Root_unresolved Root_unresolved 47 0.00154   NR 6XW2_A 562 g5059 i0 100 8.53932584269663 22 0 24.7 0 265 200 314 335 6XW2_A Chain A, Genetically encoded calcium indicator NCaMP7 based on mNeonGreen fluorescent protein [Escherichia coli] diamond 2280 47 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28686235 28686235 PRJNA397733_S_NODE_11227_length_180_cov_24.218543_g11139_i0 PRJNA397733 11227 180 24.218543 43.5933774 Salmonella enterica 28901 Bacteria Bacteria 115 7.069999999999999e-31   NR MEY6333246.1 593905 g11139 i0 96.7 22 60 2 100 0 1 180 56 115 MEY6333246.1 Hsp70 family protein [Salmonella enterica subsp. enterica serovar Corvallis] diamond 3960 115 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
28843678 28843678 PRJNA397733_S_NODE_5888_length_249_cov_3.586364_g5800_i0 PRJNA397733 5888 249 3.586364 8.93004636 Variovorax sp. J22R133 3053503 Bacteria Bacteria 41.6 0.033   NR WP_353506266.1 3053503 g5800 i0 40.3 0.807228915662651 67 27 66.3 3 20 184 47 112 WP_353506266.1 DUF6351 family protein [Variovorax sp. J22R133] diamond 201 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Variovorax Variovorax brevis
28938675 28938675 PRJNA397733_S_NODE_10228_length_188_cov_41.389937_g10140_i0 PRJNA397733 10228 188 41.389937 77.81308156 Shigella sonnei 624 Bacteria Bacteria 72.8 6.26e-15   NR MDD0641329.1 624 g10140 i0 91.2 0.542553191489362 34 3 54.3 0 184 83 1 34 MDD0641329.1 hypothetical protein [Shigella sonnei] diamond 102 72.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
29081704 29081704 PRJNA397733_S_NODE_10968_length_182_cov_15.457516_g10880_i0 PRJNA397733 10968 182 15.457516 28.13267912 root 1 Root_unresolved Root_unresolved 101 1.75e-25   NR WP_353802567.1 470 g10880 i0 91.2 104.208791208791 57 5 94 0 11 181 97 153 WP_353802567.1 30S ribosomal protein S4, partial [Acinetobacter baumannii] diamond 18966 102 0.990196078431373 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
29776111 29776111 PRJNA397733_S_NODE_10011_length_190_cov_16.956522_g9923_i0 PRJNA397733 10011 190 16.956522 32.2173918 root 1 Root_unresolved Root_unresolved 121 1.0999999999999999e-33   NR WP_416532271.1 573 g9923 i0 100 54.6947368421053 61 0 96.3 0 187 5 49 109 WP_416532271.1 EF-hand domain-containing protein, partial [Klebsiella pneumoniae] diamond 10392 121 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31687189 31687189 PRJNA397733_S_NODE_16877_length_150_cov_22.537190_g16789_i0 PRJNA397733 16877 150 22.53719 33.805785 Salmonella enterica 28901 Bacteria Bacteria 93.6 6.189999999999999e-23   NR MEY6407885.1 593905 g16789 i0 91.5 2.84 47 4 94 0 148 8 21 67 MEY6407885.1 hemoglobin beta-like protein [Salmonella enterica subsp. enterica serovar Corvallis] diamond 426 93.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
31845297 31845297 PRJNA397733_S_NODE_9257_length_198_cov_3.106509_g9169_i0 PRJNA397733 9257 198 3.106509 6.15088782 Salmonella enterica 28901 Bacteria Bacteria 130 1.03e-34   NR MEY6403329.1 593905 g9169 i0 97 22 66 2 100 0 198 1 143 208 MEY6403329.1 creatine kinase family protein [Salmonella enterica subsp. enterica serovar Corvallis] diamond 4356 131 0.99236641221374 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
32336986 32336986 PRJNA397733_S_NODE_14379_length_161_cov_7.803030_g14291_i0 PRJNA397733 14379 161 7.80303 12.5628783 root 1 Root_unresolved Root_unresolved 110 1.15e-28   NR WP_416550324.1 573 g14291 i0 96.2 85.9192546583851 53 2 98.8 0 160 2 41 93 WP_416550324.1 MC/SLC25 family protein, partial [Klebsiella pneumoniae] diamond 13833 111 0.990990990990991 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32336989 32336989 PRJNA397733_S_NODE_8819_length_202_cov_23.005780_g8731_i0 PRJNA397733 8819 202 23.00578 46.4716756 root 1 Root_unresolved Root_unresolved 118 3.7199999999999997e-32   NR WP_175283833.1 562 g8731 i0 95.4 201.311881188119 65 3 96.5 0 195 1 55 119 WP_175283833.1 Hsp70 family protein, partial [Escherichia coli] diamond 40665 119 0.991596638655462 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32715736 32715736 PRJNA397733_S_NODE_14420_length_161_cov_3.477273_g14332_i0 PRJNA397733 14420 161 3.477273 5.59840953 root 1 Root_unresolved Root_unresolved 106 1.26e-28   NR WP_159189245.1 573 g14332 i0 100 735.652173913043 53 0 98.8 0 159 1 5 57 WP_159189245.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 118440 106 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);;