RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA998413" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA998413 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
13732634 13732634 PRJNA998413_S_NODE_12911_length_210_cov_1.367347_g12880_i0 PRJNA998413 12911 210 1.367347 2.8714287 Pseudomonadati 3379134 Bacteria Bacteria 115 2.18e-28   NR WP_121380288.1 287 g12880 i0 71 77.4 69 20 98.6 0 208 2 35 103 WP_121380288.1 DNA topoisomerase IV subunit A, partial [Pseudomonas aeruginosa] diamond 16254 116 0.991379310344828 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
26900051 26900051 PRJNA998413_S_NODE_7721_length_241_cov_1.505618_g7690_i0 PRJNA998413 7721 241 1.505618 3.62853938 Klebsiella pneumoniae 573 Bacteria Bacteria 46.2 2.07e-4   NR WP_316420995.1 573 g7690 i0 42.6 0.846473029045643 68 30 73.4 2 6 182 4 71 WP_316420995.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 204 46.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27500661 27500661 PRJNA998413_S_NODE_3083_length_318_cov_2.341176_g3052_i0 PRJNA998413 3083 318 2.341176 7.44493968 Methylococcales bacterium 2304002 Bacteria Bacteria 86.3 4.28e-17   NR MCK5872813.1 2304002 g3052 i0 91.5 0.443396226415094 47 4 44.3 0 143 3 1 47 MCK5872813.1 hypothetical protein [Methylococcales bacterium] diamond 141 86.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales     Methylococcales bacterium
28037376 28037376 PRJNA998413_S_NODE_1105_length_433_cov_46.151351_g1074_i0 PRJNA998413 1105 433 46.151351 199.83534983 Escherichia coli 562 Bacteria Bacteria 44.3 0.0376   NR KAB0025260.1 562 g1074 i0 46.7 0.94919168591224 137 34 87.3 9 39 416 32 140 KAB0025260.1 hypothetical protein F7F36_28680, partial [Escherichia coli] diamond 411 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28037380 28037380 PRJNA998413_S_NODE_8885_length_231_cov_1.142857_g8854_i0 PRJNA998413 8885 231 1.142857 2.63999967 Yersinia enterocolitica 630 Bacteria Bacteria 90.9 3.42e-20   NR EKN3986139.1 630 g8854 i0 73.9 2.68831168831169 69 18 89.6 0 20 226 1 69 EKN3986139.1 hypothetical protein [Yersinia enterocolitica] diamond 621 90.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Yersinia Yersinia enterocolitica
28194947 28194947 PRJNA998413_S_NODE_12606_length_211_cov_1.202703_g12575_i0 PRJNA998413 12606 211 1.202703 2.53770333 Idiomarinaceae bacterium 1898113 Bacteria Bacteria 47.8 1.18e-4   NR MBG24060.1 1898113 g12575 i0 45.5 0.781990521327014 55 27 78.2 1 47 211 1 52 MBG24060.1 hypothetical protein [Idiomarinaceae bacterium] diamond 165 47.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Idiomarinaceae   Idiomarinaceae bacterium
28295607 28295607 PRJNA998413_S_NODE_12326_length_212_cov_0.899329_g12295_i0 PRJNA998413 12326 212 0.899329 1.90657748 Pseudomonadati 3379134 Bacteria Bacteria 79.7 2.33e-15   NR MDC3028381.1 2024849 g12295 i0 44.9 6.36792452830189 69 38 97.6 0 207 1 163 231 MDC3028381.1 DNA polymerase I [Candidatus Pelagibacter sp.] diamond 1350 80.1 0.995006242197254 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Candidatus Pelagibacterales Candidatus Pelagibacteraceae Candidatus Pelagibacter Candidatus Pelagibacter sp.
28731946 28731946 PRJNA998413_S_NODE_9747_length_224_cov_1.248447_g9716_i0 PRJNA998413 9747 224 1.248447 2.79652128 Klebsiella pneumoniae 573 Bacteria Bacteria 45.1 0.00122   NR WP_206567152.1 573 g9716 i0 47.7 0.589285714285714 44 23 58.9 0 183 52 45 88 WP_206567152.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 132 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28863961 28863961 PRJNA998413_S_NODE_2228_length_348_cov_2.350877_g2197_i0 PRJNA998413 2228 348 2.350877 8.18105196 Bacteria 2 Bacteria Bacteria 137 2.0599999999999997e-37   NR WP_091827977.1 48076 g2197 i0 68.7 38.1551724137931 99 31 85.3 0 346 50 156 254 WP_091827977.1 3-hydroxyacyl-CoA dehydrogenase [Marinobacterium iners] diamond 13278 137 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Oceanospirillaceae Marinobacterium Marinobacterium iners
30531970 30531970 PRJNA998413_S_NODE_4693_length_280_cov_0.926267_g4662_i0 PRJNA998413 4693 280 0.926267 2.5935476 Paraburkholderia strydomiana 1245417 Bacteria Bacteria 76.3 6.53e-15   NR WP_408189928.1 1245417 g4662 i0 50.7 0.782142857142857 73 36 78.2 0 2 220 103 175 WP_408189928.1 hypothetical protein [Paraburkholderia strydomiana] diamond 219 76.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia strydomiana
30689937 30689937 PRJNA998413_S_NODE_3833_length_297_cov_1.717949_g3802_i0 PRJNA998413 3833 297 1.717949 5.10230853 Pseudomonas syringae 317 Bacteria Bacteria 58.9 1.34e-7   NR MDU8351232.1 103796 g3802 i0 39.8 0.98989898989899 98 57 97 2 289 2 78 175 MDU8351232.1 hypothetical protein [Pseudomonas syringae pv. actinidiae] diamond 294 58.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae
31353722 31353722 PRJNA998413_S_NODE_11696_length_214_cov_0.887417_g11665_i0 PRJNA998413 11696 214 0.887417 1.89907238 Aeromonas caviae 648 Bacteria Bacteria 88.2 2.44e-18   NR WP_405694203.1 648 g11665 i0 52.9 0.981308411214953 70 33 98.1 0 212 3 411 480 WP_405694203.1 ATP-dependent helicase [Aeromonas caviae] diamond 210 88.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas caviae
31416962 31416962 PRJNA998413_S_NODE_8836_length_231_cov_1.595238_g8805_i0 PRJNA998413 8836 231 1.595238 3.68499978 Halomonadaceae 28256 Bacteria Bacteria 79.3 4.39e-16   NR WP_031383959.1 28256 g8805 i0 50 2.64935064935065 68 34 88.3 0 205 2 33 100 WP_031383959.1 MULTISPECIES: outer membrane lipoprotein chaperone LolA [Halomonadaceae] diamond 612 79.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae    
31796308 31796308 PRJNA998413_S_NODE_6077_length_259_cov_1.025510_g6046_i0 PRJNA998413 6077 259 1.02551 2.6560709 Pseudomonas proteolytica 219574 Bacteria Bacteria 51.2 2.06e-5   NR WP_339520695.1 219574 g6046 i0 38 1.65637065637066 71 40 77.6 1 234 34 88 158 WP_339520695.1 hypothetical protein, partial [Pseudomonas proteolytica] diamond 429 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas proteolytica
32650055 32650055 PRJNA998413_S_NODE_13300_length_209_cov_0.917808_g13269_i0 PRJNA998413 13300 209 0.917808 1.91821872 uncultured Methylobacterium sp. 157278 Bacteria Bacteria 50.8 1.95e-6   NR WP_289016066.1 157278 g13269 i0 65.8 0.545454545454545 38 13 54.5 0 119 6 8 45 WP_289016066.1 hypothetical protein [uncultured Methylobacterium sp.] diamond 114 50.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium uncultured Methylobacterium sp.
32776234 32776234 PRJNA998413_S_NODE_12240_length_212_cov_1.348993_g12209_i0 PRJNA998413 12240 212 1.348993 2.85986516 Escherichia coli 562 Bacteria Bacteria 152 3.33e-46   NR MCV7892418.1 562 g12209 i0 98.6 0.990566037735849 70 1 99.1 0 211 2 20 89 MCV7892418.1 hypothetical protein [Escherichia coli] diamond 210 152 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32870774 32870774 PRJNA998413_S_NODE_8520_length_234_cov_1.175439_g8489_i0 PRJNA998413 8520 234 1.175439 2.75052726 Halopseudomonas aestusnigri 857252 Bacteria Bacteria 74.7 9.49e-15   NR WP_088277830.1 857252 g8489 i0 95 1.02564102564103 40 2 51.3 0 120 1 41 80 WP_088277830.1 antitoxin Xre-like helix-turn-helix domain-containing protein [Halopseudomonas aestusnigri] diamond 240 74.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Halopseudomonas Halopseudomonas aestusnigri

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