RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1074408" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1074408 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
7843661 7843661 PRJNA1074408_S_NODE_2267_length_303_cov_2.765385_g2137_i0 PRJNA1074408 2267 303 2.765385 8.3791165500000009 Pseudomonas 286 Bacteria Bacteria 206 6.57e-65   NR WP_181127634.1 286 g2137 i0 100 1 101 0 100 0 303 1 120 220 WP_181127634.1 MULTISPECIES: hydroxyacylglutathione hydrolase [Pseudomonas] diamond 303 206 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas  
26972448 26972448 PRJNA1074408_S_NODE_10082_length_150_cov_1.420561_g9952_i0 PRJNA1074408 10082 150 1.420561 2.1308415 Pseudomonas fluorescens 294 Bacteria Bacteria 94.4 9e-22   NR WP_223026575.1 294 g9952 i0 91.8 0.98 49 4 98 0 2 148 84 132 WP_223026575.1 trypsin-like peptidase domain-containing protein [Pseudomonas fluorescens] diamond 147 94.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas fluorescens
27225291 27225291 PRJNA1074408_S_NODE_5343_length_200_cov_1.528662_g5213_i0 PRJNA1074408 5343 200 1.528662 3.057324 Pseudomonas amygdali 47877 Bacteria Bacteria 64.7 8.02e-11   NR WP_057421623.1 47877 g5213 i0 63.8 0.705 47 17 70.5 0 148 8 1 47 WP_057421623.1 hypothetical protein [Pseudomonas amygdali] diamond 141 64.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas amygdali
28172786 28172786 PRJNA1074408_S_NODE_4826_length_211_cov_1.142857_g4696_i0 PRJNA1074408 4826 211 1.142857 2.41142827 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 121 1.26e-32   NR NVJ97813.1 1913988 g4696 i0 76.8 0.981042654028436 69 16 98.1 0 208 2 133 201 NVJ97813.1 glutathione S-transferase N-terminal domain-containing protein [Alphaproteobacteria bacterium] diamond 207 121 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
29246344 29246344 PRJNA1074408_S_NODE_5749_length_194_cov_1.271523_g5619_i0 PRJNA1074408 5749 194 1.271523 2.46675462 Pseudomonas sp. F8 688277 Bacteria Bacteria 130 2.59e-33   NR WP_177044401.1 2738822 g5619 i0 98.4 0.989690721649485 64 1 99 0 2 193 35 98 WP_177044401.1 dermonecrotic toxin domain-containing protein [Pseudomonas sp. F8002] diamond 192 130 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. F8002
29593315 29593315 PRJNA1074408_S_NODE_4950_length_208_cov_1.163636_g4820_i0 PRJNA1074408 4950 208 1.163636 2.42036288 Sphingomonas sp. Leaf1 28214 Bacteria Bacteria 129 1.78e-35   NR WP_056459246.1 1735676 g4820 i0 91.3 0.995192307692308 69 6 99.5 0 2 208 151 219 WP_056459246.1 WecB/TagA/CpsF family glycosyltransferase [Sphingomonas sp. Leaf10] diamond 207 129 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. Leaf10
30572726 30572726 PRJNA1074408_S_NODE_8773_length_159_cov_1.655172_g8643_i0 PRJNA1074408 8773 159 1.655172 2.63172348 unclassified Pseudomonas 196821 Bacteria Bacteria 108 5.5e-26   NR WP_177035925.1 196821 g8643 i0 100 0.962264150943396 51 0 96.2 0 154 2 1 51 WP_177035925.1 MULTISPECIES: asparagine synthase-related protein [unclassified Pseudomonas] diamond 153 108 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas  
31015304 31015304 PRJNA1074408_S_NODE_8615_length_160_cov_3.316239_g8485_i0 PRJNA1074408 8615 160 3.316239 5.3059824 Shigella sonnei 624 Bacteria Bacteria 83.2 2.49e-19   NR WP_353763804.1 624 g8485 i0 95.6 0.84375 45 2 84.4 0 23 157 38 82 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 135 83.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
31892196 31892196 PRJNA1074408_S_NODE_7817_length_168_cov_1.152000_g7687_i0 PRJNA1074408 7817 168 1.152 1.93536 Pseudomonas 286 Bacteria Bacteria 84.7 2.08e-17   NR WP_146180377.1 287 g7687 i0 90.9 3.92857142857143 44 4 78.6 0 168 37 140 183 WP_146180377.1 TIR domain-containing anti-phage reverse transcriptase [Pseudomonas aeruginosa] diamond 660 85.5 0.990643274853801 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
32145396 32145396 PRJNA1074408_S_NODE_7798_length_168_cov_1.536000_g7668_i0 PRJNA1074408 7798 168 1.536 2.58048 Pseudomonas 286 Bacteria Bacteria 88.6 2.16e-21   NR MCF5518030.1 2665474 g7668 i0 100 1.46428571428571 41 0 73.2 0 166 44 45 85 MCF5518030.1 4'-phosphopantetheinyl transferase superfamily protein [Pseudomonas sp. PA-3-6E] diamond 246 88.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. PA-3-6E
32565502 32565502 PRJNA1074408_S_NODE_8239_length_164_cov_1.190083_g8109_i0 PRJNA1074408 8239 164 1.190083 1.95173612 Stenotrophomonas maltophilia 40324 Bacteria Bacteria 107 8.43e-28   NR WP_143592210.1 40324 g8109 i0 100 0.98780487804878 54 0 98.8 0 3 164 94 147 WP_143592210.1 hypothetical protein [Stenotrophomonas maltophilia] diamond 162 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas maltophilia

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