RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1066877" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1066877 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
180309 180309 PRJNA1066877_S_NODE_10721_length_171_cov_1.254098_g10686_i0 PRJNA1066877 10721 171 1.254098 2.14450758 Enterobacter mori 539813 Bacteria Bacteria 107 6.16e-29   NR PWG67911.1 539813 g10686 i0 100 0.982456140350877 56 0 98.2 0 169 2 8 63 PWG67911.1 hypothetical protein DEM28_26025, partial [Enterobacter mori] diamond 168 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter mori
26908977 26908977 PRJNA1066877_S_NODE_12182_length_164_cov_0.886957_g12147_i0 PRJNA1066877 12182 164 0.886957 1.45460948 Lysobacterales bacterium CG17_big_fil_post_rev_8_21_14_2_5 2006849 Bacteria Bacteria 41.2 0.045   NR PIQ37167.1 1974109 g12147 i0 51.1 0.859756097560976 47 17 86 1 22 162 97 137 PIQ37167.1 MAG: hypothetical protein COW59_08640 [Lysobacterales bacterium CG17_big_fil_post_rev_8_21_14_2_50_64_11] diamond 141 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales     Lysobacterales bacterium CG17_big_fil_post_rev_8_21_14_2_50_64_11
27564127 27564127 PRJNA1066877_S_NODE_11824_length_165_cov_1.258621_g11789_i0 PRJNA1066877 11824 165 1.258621 2.07672465 root 1 Root_unresolved Root_unresolved 92 2.9300000000000004e-21   NR WP_266333533.1 562 g11789 i0 75.9 93.2727272727273 54 13 98.2 0 2 163 90 143 WP_266333533.1 hypothetical protein [Escherichia coli] diamond 15390 92 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28141257 28141257 PRJNA1066877_S_NODE_4245_length_243_cov_1.051546_g4210_i0 PRJNA1066877 4245 243 1.051546 2.55525678 Escherichia coli 562 Bacteria Bacteria 112 1.6799999999999999e-29   NR WP_230509318.1 562 g4210 i0 100 0.728395061728395 59 0 72.8 0 3 179 86 144 WP_230509318.1 hypothetical protein, partial [Escherichia coli] diamond 177 112 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28583194 28583194 PRJNA1066877_S_NODE_10907_length_170_cov_1.090909_g10872_i0 PRJNA1066877 10907 170 1.090909 1.8545453 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 88.6 9.81e-19   NR MCQ2966745.1 1913988 g10872 i0 76 0.882352941176471 50 12 88.2 0 154 5 4 53 MCQ2966745.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 150 88.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
29214762 29214762 PRJNA1066877_S_NODE_12449_length_163_cov_0.894737_g12414_i0 PRJNA1066877 12449 163 0.894737 1.45842131 Methylobacterium sp. V23 2044878 Bacteria Bacteria 52.8 9.37e-7   NR WP_103711710.1 2044878 g12414 i0 78.1 0.588957055214724 32 7 58.9 0 1 96 110 141 WP_103711710.1 DUF1810 domain-containing protein [Methylobacterium sp. V23] diamond 96 52.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium sp. V23
29277491 29277491 PRJNA1066877_S_NODE_12689_length_162_cov_0.902655_g12654_i0 PRJNA1066877 12689 162 0.902655 1.4623011 Neisseriaceae bacterium PsAf 2815356 Bacteria Bacteria 62.8 8.34e-11   NR MBN3860240.1 2815356 g12654 i0 51.9 1.92592592592593 52 25 96.3 0 3 158 19 70 MBN3860240.1 RNA-binding protein [Neisseriaceae bacterium PsAf] diamond 312 62.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae   Neisseriaceae bacterium PsAf
29877722 29877722 PRJNA1066877_S_NODE_10191_length_175_cov_1.214286_g10156_i0 PRJNA1066877 10191 175 1.214286 2.1250005 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 89.7 3.01e-19   NR MCQ2966752.1 1913988 g10156 i0 74.1 0.994285714285714 58 15 99.4 0 2 175 50 107 MCQ2966752.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 174 89.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
30090301 30090301 PRJNA1066877_S_NODE_12672_length_162_cov_0.902655_g12637_i0 PRJNA1066877 12672 162 0.902655 1.4623011 Pseudomonadota 1224 Bacteria Bacteria 100 5.519999999999999e-23   NR MDO5687027.1 192066 g12637 i0 79.2 5.88888888888889 53 11 98.1 0 161 3 232 284 MDO5687027.1 acyl-CoA dehydrogenase [Neisseria sp.] diamond 954 100 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Neisseria Neisseria sp.
31046884 31046884 PRJNA1066877_S_NODE_6535_length_206_cov_4.000000_g6500_i0 PRJNA1066877 6535 206 4 8.24 Porphyrobacter sp. 1113 Bacteria Bacteria 40.8 0.029   NR MBA4766075.1 1113 g6500 i0 41.3 0.669902912621359 46 27 67 0 59 196 24 69 MBA4766075.1 hypothetical protein [Porphyrobacter sp.] diamond 138 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Erythrobacteraceae Porphyrobacter Porphyrobacter sp.
31070113 31070113 PRJNA1066877_S_NODE_11935_length_165_cov_0.879310_g11900_i0 PRJNA1066877 11935 165 0.87931 1.4508615 Bacteria 2 Bacteria Bacteria 87.8 3.27e-21   NR MCP5809999.1 573 g11900 i0 100 1.96363636363636 54 0 98.2 0 2 163 19 72 MCP5809999.1 hypothetical protein [Klebsiella pneumoniae] diamond 324 87.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32248821 32248821 PRJNA1066877_S_NODE_10198_length_175_cov_1.214286_g10163_i0 PRJNA1066877 10198 175 1.214286 2.1250005 Pseudomonas aeruginosa 287 Bacteria Bacteria 51.2 1.48e-5   NR WP_074202395.1 287 g10163 i0 47.3 0.942857142857143 55 28 92.6 1 9 170 558 612 WP_074202395.1 TraM recognition domain-containing protein [Pseudomonas aeruginosa] diamond 165 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa

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