RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA274362" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA274362 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
22046920 22046920 PRJNA274362_S_NODE_15578_length_228_cov_1.435754_g15458_i0 PRJNA274362 15578 228 1.435754 3.27351912 Candidatus Micropelagos thuwalensis 1397666 Bacteria Bacteria 93.2 2.16e-21   NR WP_108912107.1 1397666 g15458 i0 66.7 5.27631578947368 66 20 86.8 1 6 203 151 214 WP_108912107.1 peptide-methionine (S)-S-oxide reductase MsrA [Candidatus Micropelagos thuwalensis] diamond 1203 93.2 1 Bacteria PS1 clade Pseudomonadati Pseudomonadota Alphaproteobacteria     Candidatus Micropelagius Candidatus Micropelagius thuwalensis
27042463 27042463 PRJNA274362_S_NODE_35022_length_165_cov_0.896552_g34902_i0 PRJNA274362 35022 165 0.896552 1.4793108 Pseudomonadota 1224 Bacteria Bacteria 56.6 3.88e-9   NR WP_156143031.1 1224 g34902 i0 96.2 0.472727272727273 26 1 47.3 0 78 1 1 26 WP_156143031.1 MULTISPECIES: hypothetical protein [Pseudomonadota] diamond 78 56.6 1 Bacteria   Pseudomonadati Pseudomonadota          
27168676 27168676 PRJNA274362_S_NODE_5282_length_364_cov_1.498413_g5162_i0 PRJNA274362 5282 364 1.498413 5.45422332 Pseudomonadota bacterium 1977087 Bacteria Bacteria 162 1.13e-48   NR MEL6702598.1 1977087 g5162 i0 65.3 2.99175824175824 121 41 99.7 1 364 2 21 140 MEL6702598.1 uL15 family ribosomal protein [Pseudomonadota bacterium] diamond 1089 162 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27344855 27344855 PRJNA274362_S_NODE_33483_length_167_cov_0.881356_g33363_i0 PRJNA274362 33483 167 0.881356 1.47186452 Pseudomonadati 3379134 Bacteria Bacteria 102 1.05e-25   NR MEK7811464.1 1977087 g33363 i0 85.5 13.8323353293413 55 8 98.8 0 166 2 96 150 MEK7811464.1 SDR family oxidoreductase [Pseudomonadota bacterium] diamond 2310 102 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27358703 27358703 PRJNA274362_S_NODE_16243_length_224_cov_1.760000_g16123_i0 PRJNA274362 16243 224 1.76 3.9424 Pseudomonadota bacterium 1977087 Bacteria Bacteria 42.7 0.00666   NR MEL6702628.1 1977087 g16123 i0 43.4 0.709821428571429 53 30 71 0 53 211 5 57 MEL6702628.1 hypothetical protein [Pseudomonadota bacterium] diamond 159 42.7 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27534154 27534154 PRJNA274362_S_NODE_36623_length_163_cov_0.912281_g36503_i0 PRJNA274362 36623 163 0.912281 1.48701803 Alphaproteobacteria 28211 Bacteria Bacteria 104 2.51e-26   NR WP_288046500.1 28214 g36503 i0 100 2.98159509202454 54 0 99.4 0 1 162 31 84 WP_288046500.1 LacI family DNA-binding transcriptional regulator, partial [Sphingomonas sp.] diamond 486 104 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp.
27990142 27990142 PRJNA274362_S_NODE_26965_length_182_cov_1.390977_g26845_i0 PRJNA274362 26965 182 1.390977 2.53157814 Salmonella enterica 28901 Bacteria Bacteria 43.5 0.00203   NR MCY5962370.1 2583588 g26845 i0 80 0.412087912087912 25 4 39.6 1 177 106 7 31 MCY5962370.1 hypothetical protein [Salmonella enterica subsp. enterica serovar 1,4,[5],12:i:-] diamond 75 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
28102332 28102332 PRJNA274362_S_NODE_36745_length_163_cov_0.912281_g36625_i0 PRJNA274362 36745 163 0.912281 1.48701803 Gammaproteobacteria 1236 Bacteria Bacteria 55.1 5.64e-7   NR WP_008927846.1 519051 g36625 i0 45.5 17.1901840490798 55 27 95.7 1 156 1 303 357 WP_008927846.1 acetate--CoA ligase [Alcanivorax hongdengensis] diamond 2802 55.5 0.992792792792793 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Alcanivoracaceae Alcanivorax Alcanivorax hongdengensis
28134187 28134187 PRJNA274362_S_NODE_9725_length_278_cov_2.558952_g9605_i0 PRJNA274362 9725 278 2.558952 7.11388656 root 1 Root_unresolved Root_unresolved 84.7 3.37e-19   NR WP_349955076.1 672 g9605 i0 73.5 93.8309352517986 49 13 52.9 0 277 131 39 87 WP_349955076.1 30S ribosomal protein S19, partial [Vibrio vulnificus] diamond 26085 85.5 0.990643274853801 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio vulnificus
28179236 28179236 PRJNA274362_S_NODE_22586_length_196_cov_1.414966_g22466_i0 PRJNA274362 22586 196 1.414966 2.77333336 Psychrobacter sp. LV1 56811 Bacteria Bacteria 102 2.5e-24   NR WP_321155701.1 1415574 g22466 i0 77.4 0.948979591836735 62 14 94.9 0 1 186 244 305 WP_321155701.1 glycosyltransferase family 2 protein [Psychrobacter sp. LV10R520-6] diamond 186 102 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Psychrobacter Psychrobacter sp. LV10R520-6
28337376 28337376 PRJNA274362_S_NODE_32346_length_168_cov_2.226891_g32226_i0 PRJNA274362 32346 168 2.226891 3.74117688 Pseudomonadota bacterium 1977087 Bacteria Bacteria 70.1 1.04e-13   NR MEL6702651.1 1977087 g32226 i0 68.6 0.910714285714286 51 15 89.3 1 17 166 7 57 MEL6702651.1 30S ribosomal protein S11 [Pseudomonadota bacterium] diamond 153 70.1 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28337377 28337377 PRJNA274362_S_NODE_32846_length_168_cov_0.873950_g32726_i0 PRJNA274362 32846 168 0.87395 1.468236 Methylomonas sp. LWB 1905845 Bacteria Bacteria 55.1 5.88e-7   NR WP_071157917.1 1905845 g32726 i0 45.5 0.982142857142857 55 29 96.4 1 164 3 510 564 WP_071157917.1 NAD-dependent malic enzyme [Methylomonas sp. LWB] diamond 165 55.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales Methylococcaceae Methylomonas Methylomonas sp. LWB
29126968 29126968 PRJNA274362_S_NODE_28069_length_179_cov_1.138462_g27949_i0 PRJNA274362 28069 179 1.138462 2.03784698 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 82.4 1.51e-16   NR MCC7046595.1 1913988 g27949 i0 66 0.837988826815642 50 17 83.8 0 2 151 418 467 MCC7046595.1 homospermidine synthase [Alphaproteobacteria bacterium] diamond 150 82.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
29284381 29284381 PRJNA274362_S_NODE_30369_length_173_cov_0.967742_g30249_i0 PRJNA274362 30369 173 0.967742 1.67419366 Escherichia coli 562 Bacteria Bacteria 78.2 3.61e-16   NR WP_089477287.1 562 g30249 i0 67.3 3.83236994219653 55 18 95.4 0 9 173 69 123 WP_089477287.1 C1 family peptidase, partial [Escherichia coli] diamond 663 78.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
29663096 29663096 PRJNA274362_S_NODE_37650_length_162_cov_0.920354_g37530_i0 PRJNA274362 37650 162 0.920354 1.49097348 Curvibacter lanceolatus 86182 Bacteria Bacteria 57 1.12e-7   NR WP_019572938.1 86182 g37530 i0 85.4 0.759259259259259 41 6 75.9 0 4 126 107 147 WP_019572938.1 DNA-binding protein [Curvibacter lanceolatus] diamond 123 57 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Curvibacter Curvibacter lanceolatus
29694711 29694711 PRJNA274362_S_NODE_26070_length_185_cov_1.125000_g25950_i0 PRJNA274362 26070 185 1.125 2.08125 Rheinheimera sp. 1869214 Bacteria Bacteria 44.3 0.00494   NR WP_296299366.1 1869214 g25950 i0 45.9 0.989189189189189 61 32 98.9 1 185 3 323 382 WP_296299366.1 hypothetical protein [Rheinheimera sp.] diamond 183 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp.
29758057 29758057 PRJNA274362_S_NODE_21271_length_201_cov_1.322368_g21151_i0 PRJNA274362 21271 201 1.322368 2.65795968 Alcanivorax sp. 1872427 Bacteria Bacteria 75.1 4.45e-15   NR MDX1802940.1 1872427 g21151 i0 63.3 0.895522388059702 60 22 89.6 0 2 181 98 157 MDX1802940.1 peroxiredoxin [Alcanivorax sp.] diamond 180 75.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Alcanivoracaceae Alcanivorax Alcanivorax sp.
29979278 29979278 PRJNA274362_S_NODE_11171_length_263_cov_1.313084_g11051_i0 PRJNA274362 11171 263 1.313084 3.45341092 Salmonella sp. S146_54837 2665635 Bacteria Bacteria 45.8 0.00132   NR WP_187788098.1 2665635 g11051 i0 60.5 0.821292775665399 38 15 43.3 0 254 141 74 111 WP_187788098.1 hypothetical protein, partial [Salmonella sp. S146_54837] diamond 216 45.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. S146_54837
30200223 30200223 PRJNA274362_S_NODE_1332_length_677_cov_2.121019_g1236_i0 PRJNA274362 1332 677 2.121019 14.35929863 Rheinheimera sp. 4Y26 2977811 Bacteria Bacteria 231 6.229999999999999e-72   NR WP_260657151.1 2977811 g1236 i0 93 0.948301329394387 214 15 94.8 0 14 655 93 306 WP_260657151.1 cell envelope integrity protein TolA [Rheinheimera sp. 4Y26] diamond 642 231 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp. 4Y26
30232020 30232020 PRJNA274362_S_NODE_36372_length_163_cov_1.368421_g36252_i0 PRJNA274362 36372 163 1.368421 2.23052623 Rickettsiales bacterium 2026788 Bacteria Bacteria 83.6 8.48e-19   NR MDD2840196.1 2026788 g36252 i0 71.7 1.95092024539877 53 15 97.5 0 160 2 8 60 MDD2840196.1 50S ribosomal protein L24 [Rickettsiales bacterium] diamond 318 83.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
30755331 30755331 PRJNA274362_S_NODE_31754_length_169_cov_1.491667_g31634_i0 PRJNA274362 31754 169 1.491667 2.52091723 root 1 Root_unresolved Root_unresolved 97.1 8.01e-24   NR WP_346361592.1 1871050 g31634 i0 80.4 7.91715976331361 56 11 99.4 0 169 2 13 68 WP_346361592.1 WD40 repeat domain-containing protein, partial [Bosea sp. (in: a-proteobacteria)] diamond 1338 97.4 0.996919917864476 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Boseaceae Bosea Bosea sp. (in: a-proteobacteria)
31116464 31116464 PRJNA274362_S_NODE_13295_length_244_cov_1.323077_g13175_i0 PRJNA274362 13295 244 1.323077 3.22830788 Pseudomonadota bacterium 1977087 Bacteria Bacteria 96.7 1.2299999999999997e-23   NR MEL6702586.1 1977087 g13175 i0 62 0.872950819672131 71 27 87.3 0 30 242 1 71 MEL6702586.1 uL14 family ribosomal protein [Pseudomonadota bacterium] diamond 213 96.7 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
31496370 31496370 PRJNA274362_S_NODE_26356_length_184_cov_1.155556_g26236_i0 PRJNA274362 26356 184 1.155556 2.12622304 Pseudomonas lundensis 86185 Bacteria Bacteria 108 2.01e-29   NR MBE8610753.1 86185 g26236 i0 98.3 0.96195652173913 59 1 96.2 0 179 3 1 59 MBE8610753.1 hypothetical protein [Pseudomonas lundensis] diamond 177 108 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas lundensis
31514152 31514152 PRJNA274362_S_NODE_32056_length_169_cov_0.866667_g31936_i0 PRJNA274362 32056 169 0.866667 1.46466723 root 1 Root_unresolved Root_unresolved 100 4.44e-25   NR MAO08131.1 232 g31936 i0 89.3 1960.33136094675 56 6 99.4 0 168 1 79 134 MAO08131.1 hypothetical protein [Alteromonas sp.] diamond 331296 101 0.99009900990099 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas sp.
31514153 31514153 PRJNA274362_S_NODE_32776_length_168_cov_0.873950_g32656_i0 PRJNA274362 32776 168 0.87395 1.468236 Allosphingosinicella 2823232 Bacteria Bacteria 101 1.82e-24   NR MEA3010957.1 1978525 g32656 i0 90.9 7.85714285714286 55 5 98.2 0 166 2 200 254 MEA3010957.1 hypothetical protein [Sphingomonadales bacterium] diamond 1320 102 0.990196078431373 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales     Sphingomonadales bacterium
31685796 31685796 PRJNA274362_S_NODE_5957_length_346_cov_1.437710_g5837_i0 PRJNA274362 5957 346 1.43771 4.9744766 Arenimonas sp. 1872635 Bacteria Bacteria 53.9 1.32e-5   NR WP_290887686.1 1872635 g5837 i0 52.4 0.745664739884393 42 20 36.4 0 30 155 346 387 WP_290887686.1 hypothetical protein [Arenimonas sp.] diamond 258 53.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Arenimonas Arenimonas sp.
31875566 31875566 PRJNA274362_S_NODE_30077_length_173_cov_1.661290_g29957_i0 PRJNA274362 30077 173 1.66129 2.8740317 Pseudomonadota bacterium 1977087 Bacteria Bacteria 74.3 1.25e-14   NR MEL6702525.1 1977087 g29957 i0 64.3 0.971098265895954 56 20 97.1 0 4 171 39 94 MEL6702525.1 V-type ATPase subunit C [Pseudomonadota bacterium] diamond 168 74.3 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
31938859 31938859 PRJNA274362_S_NODE_38097_length_157_cov_2.398148_g37977_i0 PRJNA274362 38097 157 2.398148 3.76509236 Pseudomonadota bacterium 1977087 Bacteria Bacteria 86.7 8.49e-20   NR MEL6702587.1 1977087 g37977 i0 74.5 1.94904458598726 51 13 97.5 0 156 4 10 60 MEL6702587.1 50S ribosomal protein L2 [Pseudomonadota bacterium] diamond 306 86.7 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
32129049 32129049 PRJNA274362_S_NODE_16058_length_225_cov_1.732955_g15938_i0 PRJNA274362 16058 225 1.732955 3.89914875 Rheinheimera sp. 1869214 Bacteria Bacteria 137 1.18e-39   NR WP_296298987.1 1869214 g15938 i0 93.3 1 75 4 98.7 1 2 223 50 124 WP_296298987.1 protein TolR [Rheinheimera sp.] diamond 225 137 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp.
32146611 32146611 PRJNA274362_S_NODE_24518_length_190_cov_1.106383_g24398_i0 PRJNA274362 24518 190 1.106383 2.1021277 Psychrobacter 497 Bacteria Bacteria 96.7 1.06e-21   NR HAM62042.1 56811 g24398 i0 67.7 4.91052631578947 62 20 97.9 0 4 189 148 209 HAM62042.1 methylmalonate-semialdehyde dehydrogenase (CoA acylating) [Psychrobacter sp.] diamond 933 96.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Psychrobacter Psychrobacter sp.
32287381 32287381 PRJNA274362_S_NODE_29959_length_174_cov_0.848000_g29839_i0 PRJNA274362 29959 174 0.848 1.47552 Aquisalimonadaceae bacterium 3121688 Bacteria Bacteria 43.5 0.00771   NR MEX0730518.1 3121688 g29839 i0 47.2 0.913793103448276 53 28 91.4 0 12 170 250 302 MEX0730518.1 glycine cleavage system aminomethyltransferase GcvT [Aquisalimonadaceae bacterium] diamond 159 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nitrococcales Aquisalimonadaceae   Aquisalimonadaceae bacterium
32445500 32445500 PRJNA274362_S_NODE_19599_length_208_cov_0.981132_g19479_i0 PRJNA274362 19599 208 0.981132 2.04075456 Rheinheimera sp. 1869214 Bacteria Bacteria 73.9 1.64e-13   NR WP_306518789.1 1869214 g19479 i0 97.4 0.5625 39 1 56.3 0 90 206 1 39 WP_306518789.1 UDP-3-O-(3-hydroxymyristoyl)glucosamine N-acyltransferase [Rheinheimera sp.] diamond 117 73.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera 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);;