RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJDB14274" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJDB14274 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
28416316 28416316 PRJDB14274_S_NODE_5506_length_266_cov_2.360976_g5428_i0 PRJDB14274 5506 266 2.360976 6.28019616 root 1 Root_unresolved Root_unresolved 121 1.77e-33   NR WP_416561407.1 573 g5428 i0 71.6 16.8721804511278 88 25 99.2 0 264 1 16 103 WP_416561407.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 4488 122 0.991803278688525 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28959029 28959029 PRJDB14274_S_NODE_5608_length_264_cov_2.113300_g5530_i0 PRJDB14274 5608 264 2.1133 5.579112 Pseudomonadota bacterium 1977087 Bacteria Bacteria 43.5 0.0215   NR MDQ6646288.1 1977087 g5530 i0 35.6 0.670454545454545 59 38 67 0 256 80 106 164 MDQ6646288.1 glutathione S-transferase C-terminal domain-containing protein [Pseudomonadota bacterium] diamond 177 43.5 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29016411 29016411 PRJDB14274_S_NODE_9788_length_205_cov_1.354167_g9710_i0 PRJDB14274 9788 205 1.354167 2.77604235 Pseudomonadati 3379134 Bacteria Bacteria 94.4 1.2e-20   NR NND55299.1 1913989 g9710 i0 86.3 14.8682926829268 51 7 74.6 0 204 52 422 472 NND55299.1 adenosylhomocysteinase [Gammaproteobacteria bacterium] diamond 3048 94.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
29684661 29684661 PRJDB14274_S_NODE_10070_length_203_cov_1.436620_g9992_i0 PRJDB14274 10070 203 1.43662 2.9163386 Pseudomonadota bacterium 1977087 Bacteria Bacteria 103 1.51e-26   NR MEL6702651.1 1977087 g9992 i0 73.1 1.98029556650246 67 18 99 0 201 1 42 108 MEL6702651.1 30S ribosomal protein S11 [Pseudomonadota bacterium] diamond 402 103 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
30348914 30348914 PRJDB14274_S_NODE_8732_length_215_cov_1.220779_g8654_i0 PRJDB14274 8732 215 1.220779 2.62467485 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 80.5 5.15e-17   NR MFO0203429.1 1913988 g8654 i0 59.3 0.823255813953488 59 24 82.3 0 213 37 91 149 MFO0203429.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 177 80.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
31011843 31011843 PRJDB14274_S_NODE_10135_length_203_cov_0.915493_g10057_i0 PRJDB14274 10135 203 0.915493 1.85845079 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 80.9 3.1e-17   NR MFO0203429.1 1913988 g10057 i0 55.2 4.95073891625616 67 30 99 0 201 1 82 148 MFO0203429.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 1005 80.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
32023948 32023948 PRJDB14274_S_NODE_7318_length_234_cov_1.618497_g7240_i0 PRJDB14274 7318 234 1.618497 3.78728298 Pseudomonadota bacterium 1977087 Bacteria Bacteria 110 3.71e-29   NR MEL6702586.1 1977087 g7240 i0 64.5 0.974358974358974 76 27 97.4 0 232 5 13 88 MEL6702586.1 uL14 family ribosomal protein [Pseudomonadota bacterium] diamond 228 110 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
32055434 32055434 PRJDB14274_S_NODE_3018_length_352_cov_1.340206_g2940_i0 PRJDB14274 3018 352 1.340206 4.71752512 Psychromonas sp. MB-3u-54 2058319 Bacteria Bacteria 45.1 0.0181   NR WP_101038493.1 2058319 g2940 i0 27.7 0.801136363636364 94 68 80.1 0 61 342 129 222 WP_101038493.1 efflux RND transporter periplasmic adaptor subunit [Psychromonas sp. MB-3u-54] diamond 282 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Psychromonadaceae Psychromonas Psychromonas sp. MB-3u-54
32087176 32087176 PRJDB14274_S_NODE_1458_length_504_cov_2.171558_g1382_i0 PRJDB14274 1458 504 2.171558 10.94465232 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 47.4 0.00897   NR MCP3667323.1 1913989 g1382 i0 46.6 0.345238095238095 58 31 34.5 0 489 316 112 169 MCP3667323.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 174 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium

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