RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA453111" 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

  • PRJNA453111 · 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
441418 441418 PRJNA453111_P_NODE_12801_length_242_cov_0.911243_g12709_i0 PRJNA453111 12801 242 0.911243 2.20520806 Pseudomonadati 3379134 Bacteria Bacteria 137 2.03e-36   NR WP_407176481.1 578924 g12709 i0 75 32.7272727272727 80 20 99.2 0 242 3 276 355 WP_407176481.1 isocitrate lyase [Bradyrhizobium sp. STM 3562] diamond 7920 137 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. STM 3562
27138914 27138914 PRJNA453111_P_NODE_7942_length_287_cov_1.084112_g7850_i0 PRJNA453111 7942 287 1.084112 3.11140144 Variovorax sp. J22R133 3053503 Bacteria Bacteria 43.5 0.0328   NR WP_286562580.1 3053503 g7850 i0 42.9 0.585365853658537 56 30 57.5 2 265 101 277 331 WP_286562580.1 PglL family O-oligosaccharyltransferase [Variovorax sp. J22R133] diamond 168 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Variovorax Variovorax brevis
27834113 27834113 PRJNA453111_P_NODE_12464_length_243_cov_0.905882_g12372_i0 PRJNA453111 12464 243 0.905882 2.20129326 Betaproteobacteria bacterium 1891241 Bacteria Bacteria 44.7 0.00771   NR MSQ54280.1 1891241 g12372 i0 38.7 0.925925925925926 75 43 90.1 2 19 237 294 367 MSQ54280.1 MFS transporter [Betaproteobacteria bacterium] diamond 225 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria bacterium
28055094 28055094 PRJNA453111_P_NODE_5745_length_337_cov_1.659091_g5653_i0 PRJNA453111 5745 337 1.659091 5.59113667 Spiribacter pallidus 1987936 Bacteria Bacteria 44.7 0.0213   NR WP_367985223.1 1987936 g5653 i0 28.4 0.72106824925816 81 48 63.2 2 49 261 119 199 WP_367985223.1 CynX/NimT family MFS transporter [Spiribacter pallidus] diamond 243 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Ectothiorhodospiraceae Spiribacter Spiribacter pallidus
28086687 28086687 PRJNA453111_P_NODE_5285_length_351_cov_1.586331_g5193_i0 PRJNA453111 5285 351 1.586331 5.56802181 Chitinimonas sp. 1934313 Bacteria Bacteria 78.6 2.42e-14   NR WP_374349013.1 1934313 g5193 i0 35.1 0.974358974358974 114 74 97.4 0 1 342 65 178 WP_374349013.1 M35 family metallo-endopeptidase [Chitinimonas sp.] diamond 342 78.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Chitinimonas Chitinimonas sp.
28212843 28212843 PRJNA453111_P_NODE_9366_length_261_cov_1.303191_g9274_i0 PRJNA453111 9366 261 1.303191 3.40132851 Klebsiella pneumoniae 573 Bacteria Bacteria 42.4 0.00926   NR WP_416493070.1 573 g9274 i0 53.1 0.735632183908046 64 29 73.6 1 55 246 9 71 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 192 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28812660 28812660 PRJNA453111_P_NODE_12328_length_244_cov_0.888889_g12236_i0 PRJNA453111 12328 244 0.888889 2.16888916 Nitrosomonas 914 Bacteria Bacteria 43.9 0.015   NR WP_011111877.1 914 g12236 i0 35 0.737704918032787 60 38 73.8 1 13 192 421 479 WP_011111877.1 MULTISPECIES: CHASE2 domain-containing protein [Nitrosomonas] diamond 180 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas  
31451296 31451296 PRJNA453111_P_NODE_12116_length_244_cov_0.900585_g12024_i0 PRJNA453111 12116 244 0.900585 2.1974274 Comamonadaceae 80864 Bacteria Bacteria 41.6 0.0289   NR WP_006298065.1 80880 g12024 i0 37.7 1.63524590163934 61 35 73.8 2 51 230 8 66 WP_006298065.1 hypothetical protein [Hylemonella gracilis] diamond 399 42 0.990476190476191 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Hylemonella Hylemonella gracilis
31483054 31483054 PRJNA453111_P_NODE_12396_length_243_cov_1.100000_g12304_i0 PRJNA453111 12396 243 1.1 2.673 root 1 Root_unresolved Root_unresolved 82.8 1.71e-18   NR WP_264767160.1 573 g12304 i0 87.5 1.97530864197531 40 5 49.4 0 120 1 41 80 WP_264767160.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 480 83.2 0.995192307692308 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32131075 32131075 PRJNA453111_P_NODE_13318_length_222_cov_6.724832_g13226_i0 PRJNA453111 13318 222 6.724832 14.92912704 Klebsiella pneumoniae 573 Bacteria Bacteria 114 1.19e-30   NR WP_416532323.1 573 g13226 i0 91.5 0.797297297297297 59 5 79.7 0 45 221 86 144 WP_416532323.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 177 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32510914 32510914 PRJNA453111_P_NODE_9719_length_254_cov_2.552486_g9627_i0 PRJNA453111 9719 254 2.552486 6.48331444 Methylocella sp. 1978226 Bacteria Bacteria 42 0.0203   NR HEY4846789.1 1978226 g9627 i0 32.4 0.803149606299213 68 45 80.3 1 1 204 4 70 HEY4846789.1 helix-turn-helix domain-containing protein [Methylocella sp.] diamond 204 42 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Beijerinckiaceae Methylocella Methylocella sp.
32699658 32699658 PRJNA453111_P_NODE_4880_length_366_cov_0.839590_g4788_i0 PRJNA453111 4880 366 0.83959 3.0728994 Comamonas sp. 34028 Bacteria Bacteria 42.7 0.0464   NR MBN9331280.1 34028 g4788 i0 38.2 0.450819672131148 55 32 43.4 2 205 363 32 86 MBN9331280.1 hypothetical protein [Comamonas sp.] diamond 165 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas sp.

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