RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA450343" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA450343 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
26600934 26600934 PRJNA450343_P_NODE_14101_length_161_cov_0.901786_g14033_i0 PRJNA450343 14101 161 0.901786 1.45187546 Massilia sp. 1882437 Bacteria Bacteria 101 5.509999999999999e-24   NR MEN3277622.1 1882437 g14033 i0 94.3 1.97515527950311 53 3 98.8 0 160 2 122 174 MEN3277622.1 NitT/TauT family transport system substrate-binding protein [Massilia sp.] diamond 318 101 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Massilia Massilia sp.
26632891 26632891 PRJNA450343_P_NODE_13061_length_163_cov_0.894737_g12993_i0 PRJNA450343 13061 163 0.894737 1.45842131 Rhizobium sp. PP-CC-3A-592 2135647 Bacteria Bacteria 57.8 6e-8   NR PYE29016.1 2135647 g12993 i0 71.1 0.828220858895706 45 13 82.8 0 161 27 162 206 PYE29016.1 chromate transporter [Rhizobium sp. PP-CC-3A-592] diamond 135 57.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium Rhizobium sp. PP-CC-3A-592
27455483 27455483 PRJNA450343_P_NODE_10543_length_167_cov_1.728814_g10475_i0 PRJNA450343 10543 167 1.728814 2.88711938 Sulfitobacter mediterraneus 83219 Bacteria Bacteria 71.6 8.49e-13   NR WP_025047185.1 83219 g10475 i0 52.7 1.90419161676647 55 26 98.8 0 166 2 58 112 WP_025047185.1 glycerol kinase GlpK [Sulfitobacter mediterraneus] diamond 318 71.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Sulfitobacter Sulfitobacter mediterraneus
28465813 28465813 PRJNA450343_P_NODE_11326_length_166_cov_0.871795_g11258_i0 PRJNA450343 11326 166 0.871795 1.4471797 Sphingomonas rubra 634430 Bacteria Bacteria 110 2.52e-26   NR WP_093330724.1 634430 g11258 i0 98.1 0.975903614457831 54 1 97.6 0 1 162 113 166 WP_093330724.1 MobF family relaxase [Sphingomonas rubra] diamond 162 110 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas rubra
28686942 28686942 PRJNA450343_P_NODE_11767_length_165_cov_0.879310_g11699_i0 PRJNA450343 11767 165 0.87931 1.4508615 Pseudomonadota bacterium 1977087 Bacteria Bacteria 79 2.01e-15   NR MEL7308602.1 1977087 g11699 i0 64.9 1.03636363636364 57 17 98.2 1 1 162 126 182 MEL7308602.1 reverse transcriptase family protein [Pseudomonadota bacterium] diamond 171 79 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28970888 28970888 PRJNA450343_P_NODE_10688_length_167_cov_0.864407_g10620_i0 PRJNA450343 10688 167 0.864407 1.44355969 Acinetobacter seifertii 1530123 Bacteria Bacteria 55.1 5.82e-7   NR WP_004703533.1 1530123 g10620 i0 76.5 3.05389221556886 34 8 61.1 0 102 1 265 298 WP_004703533.1 restriction endonuclease subunit S [Acinetobacter seifertii] diamond 510 55.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter seifertii
28970891 28970891 PRJNA450343_P_NODE_1948_length_394_cov_1.568116_g1880_i0 PRJNA450343 1948 394 1.568116 6.17837704 Hafnia paralvei 546367 Bacteria Bacteria 147 1.01e-40   NR WP_256000131.1 546367 g1880 i0 92.3 1.18781725888325 78 6 59.4 0 392 159 223 300 WP_256000131.1 class I fructose-bisphosphate aldolase, partial [Hafnia paralvei] diamond 468 148 0.993243243243243 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Hafniaceae Hafnia Hafnia paralvei
29791596 29791596 PRJNA450343_P_NODE_10011_length_172_cov_1.243902_g9943_i0 PRJNA450343 10011 172 1.243902 2.13951144 Cohaesibacter celericrescens 2067669 Bacteria Bacteria 42.4 0.0189   NR WP_101534443.1 2067669 g9943 i0 41.8 0.959302325581395 55 31 94.2 1 6 167 37 91 WP_101534443.1 tyrosine-type recombinase/integrase [Cohaesibacter celericrescens] diamond 165 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Cohaesibacteraceae Cohaesibacter Cohaesibacter celericrescens
30202214 30202214 PRJNA450343_P_NODE_12132_length_164_cov_1.426087_g12064_i0 PRJNA450343 12132 164 1.426087 2.33878268 uncultured Agitococcus sp. 1506599 Bacteria Bacteria 119 1.19e-29   NR WP_297926683.1 1506599 g12064 i0 100 0.98780487804878 54 0 98.8 0 3 164 245 298 WP_297926683.1 hypothetical protein [uncultured Agitococcus sp.] diamond 162 119 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Agitococcus uncultured Agitococcus sp.
30265942 30265942 PRJNA450343_P_NODE_12892_length_163_cov_0.894737_g12824_i0 PRJNA450343 12892 163 0.894737 1.45842131 Proteus mirabilis 584 Bacteria Bacteria 43.5 0.00183   NR WP_185167798.1 584 g12824 i0 55 1.49079754601227 40 17 71.8 1 44 160 36 75 WP_185167798.1 hypothetical protein [Proteus mirabilis] diamond 243 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Morganellaceae Proteus Proteus mirabilis
31055865 31055865 PRJNA450343_P_NODE_7635_length_195_cov_9.657534_g7567_i0 PRJNA450343 7635 195 9.657534 18.8321913 Escherichia coli 562 Bacteria Bacteria 119 2.1e-32   NR WP_250909175.1 562 g7567 i0 100 7.03076923076923 56 0 86.2 0 169 2 1 56 WP_250909175.1 S6e family ribosomal protein, partial [Escherichia coli] diamond 1371 119 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31181601 31181601 PRJNA450343_P_NODE_3575_length_282_cov_3.721030_g3507_i0 PRJNA450343 3575 282 3.72103 10.4933046 Enterobacter hormaechei 158836 Bacteria Bacteria 175 4.049999999999999e-54   NR WP_112777959.1 158836 g3507 i0 97.9 46.3936170212766 94 2 100 0 282 1 1 94 WP_112777959.1 30S ribosomal protein S3, partial [Enterobacter hormaechei] diamond 13083 176 0.994318181818182 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
32289471 32289471 PRJNA450343_P_NODE_539_length_776_cov_20.642366_g492_i0 PRJNA450343 539 776 20.642366 160.18476016 Klebsiella pneumoniae 573 Bacteria Bacteria 245 2.3e-79   NR HCS9083780.1 573 g492 i0 90 0.541237113402062 140 14 54.1 0 715 296 1 140 HCS9083780.1 hypothetical protein [Klebsiella pneumoniae] diamond 420 245 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32447518 32447518 PRJNA450343_P_NODE_9979_length_172_cov_1.292683_g9911_i0 PRJNA450343 9979 172 1.292683 2.22341476 Salmonella sp. s54412 3160128 Bacteria Bacteria 79 1.8e-15   NR WP_395239267.1 3160128 g9911 i0 100 1.88372093023256 36 0 62.8 0 108 1 15 50 WP_395239267.1 actin, partial [Salmonella sp. s54412] diamond 324 79 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. s54412
32715956 32715956 PRJNA450343_P_NODE_12940_length_163_cov_0.894737_g12872_i0 PRJNA450343 12940 163 0.894737 1.45842131 root 1 Root_unresolved Root_unresolved 65.5 1.24e-11   NR WP_176265472.1 562 g12872 i0 100 21.680981595092 31 0 57.1 0 161 69 120 150 WP_176265472.1 30S ribosomal protein S15, partial [Escherichia coli] diamond 3534 65.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32873308 32873308 PRJNA450343_P_NODE_5320_length_230_cov_1.839779_g5252_i0 PRJNA450343 5320 230 1.839779 4.2314917 root 1 Root_unresolved Root_unresolved 161 1.4e-48   NR MDC9991623.1 623 g5252 i0 97.4 59.4521739130435 76 2 99.1 0 1 228 68 143 MDC9991623.1 hypothetical protein [Shigella flexneri] diamond 13674 162 0.993827160493827 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella flexneri

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