RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1233317 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
26788062 26788062 PRJNA1233317_S_NODE_8301_length_268_cov_2.497608_g8265_i0 PRJNA1233317 8301 268 2.497608 6.69358944 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 42.7 0.0474   NR HEX7081217.1 1913989 g8265 i0 32.5 0.895522388059702 80 40 85.1 3 37 264 145 214 HEX7081217.1 PepSY domain-containing protein [Gammaproteobacteria bacterium] diamond 240 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
26977849 26977849 PRJNA1233317_S_NODE_4382_length_330_cov_4.538745_g4346_i0 PRJNA1233317 4382 330 4.538745 14.9778585 Mesorhizobium sp. SP-1A 3077840 Bacteria Bacteria 137 2.63e-39   NR WP_315920420.1 3077840 g4346 i0 57.9 0.972727272727273 107 45 97.3 0 322 2 13 119 WP_315920420.1 HNH endonuclease [Mesorhizobium sp. SP-1A] diamond 321 137 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium sp. SP-1A
27325678 27325678 PRJNA1233317_S_NODE_14603_length_201_cov_1.514085_g14567_i0 PRJNA1233317 14603 201 1.514085 3.04331085 Pseudomonas sp. PA15(2 306 Bacteria Bacteria 43.1 0.0155   NR WP_075962821.1 1932111 g14567 i0 43.3 0.895522388059702 60 30 83.6 2 5 172 191 250 WP_075962821.1 cyclic diguanylate phosphodiesterase [Pseudomonas sp. PA15(2017)] diamond 180 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. PA15(2017)
27799489 27799489 PRJNA1233317_S_NODE_2864_length_365_cov_1.934641_g2828_i0 PRJNA1233317 2864 365 1.934641 7.06143965 Pseudomonas 286 Bacteria Bacteria 179 3.5799999999999996e-56   NR WP_156858570.1 286 g2828 i0 100 0.723287671232877 88 0 72.3 0 102 365 1 88 WP_156858570.1 MULTISPECIES: hypothetical protein [Pseudomonas] diamond 264 179 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas  
28241137 28241137 PRJNA1233317_S_NODE_2446_length_377_cov_4.669811_g2410_i0 PRJNA1233317 2446 377 4.669811 17.60518747 Pseudomonas sp. 8O 2653165 Bacteria Bacteria 207 5.3999999999999995e-62   NR WP_160019590.1 2653165 g2410 i0 98.4 0.994694960212202 125 2 99.5 0 2 376 163 287 WP_160019590.1 hypothetical protein [Pseudomonas sp. 8O] diamond 375 207 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. 8O
28620403 28620403 PRJNA1233317_S_NODE_1807_length_400_cov_3.375367_g1771_i0 PRJNA1233317 1807 400 3.375367 13.501468 Burkholderia cepacia complex 87882 Bacteria Bacteria 240 2.1e-77   NR WP_046196446.1 87882 g1771 i0 88.7 0.9975 133 15 99.8 0 2 400 59 191 WP_046196446.1 MULTISPECIES: hypothetical protein [Burkholderia cepacia complex] diamond 399 240 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia  
28936034 28936034 PRJNA1233317_S_NODE_12528_length_219_cov_2.287500_g12492_i0 PRJNA1233317 12528 219 2.2875 5.009625 Franzmannia qiaohouensis 1329370 Bacteria Bacteria 42.4 0.0365   NR WP_309718572.1 1329370 g12492 i0 35.5 1.04109589041096 76 39 94.5 2 11 217 289 361 WP_309718572.1 MFS transporter [Franzmannia qiaohouensis] diamond 228 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae Franzmannia Franzmannia qiaohouensis
29661732 29661732 PRJNA1233317_S_NODE_8290_length_268_cov_3.177033_g8254_i0 PRJNA1233317 8290 268 3.177033 8.51444844 Pseudomonas entomophila 312306 Bacteria Bacteria 43.1 0.0354   NR WP_181098733.1 312306 g8254 i0 47.7 0.492537313432836 44 23 49.3 0 136 5 290 333 WP_181098733.1 aminopeptidase [Pseudomonas entomophila] diamond 132 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas entomophila
30009736 30009736 PRJNA1233317_S_NODE_4111_length_335_cov_4.108696_g4075_i0 PRJNA1233317 4111 335 4.108696 13.7641316 Pseudomonas sp. 8O 2653165 Bacteria Bacteria 217 9.12e-70   NR WP_160018661.1 2653165 g4075 i0 97.3 0.994029850746269 111 3 99.4 0 334 2 13 123 WP_160018661.1 hypothetical protein [Pseudomonas sp. 8O] diamond 333 217 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. 8O
30217823 30217823 PRJNA1233317_S_NODE_17312_length_181_cov_3.000000_g17276_i0 PRJNA1233317 17312 181 3 5.43 root 1 Root_unresolved Root_unresolved 40.4 0.0182   NR WP_301159048.1 546 g17276 i0 56.3 1.06077348066298 32 11 53 1 170 75 41 69 WP_301159048.1 hypothetical protein, partial [Citrobacter freundii] diamond 192 40.8 0.990196078431373 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Citrobacter Citrobacter freundii
30217824 30217824 PRJNA1233317_S_NODE_9552_length_251_cov_4.380208_g9516_i0 PRJNA1233317 9552 251 4.380208 10.99432208 Pseudomonadati 3379134 Bacteria Bacteria 96.7 1.9799999999999998e-23   NR MCX7378634.1 1913988 g9516 i0 64.2 7.74501992031873 81 28 96.8 1 2 244 58 137 MCX7378634.1 type II 3-dehydroquinate dehydratase [Alphaproteobacteria bacterium] diamond 1944 97.4 0.992813141683778 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
30326068 30326068 PRJNA1233317_S_NODE_9652_length_250_cov_1.795812_g9616_i0 PRJNA1233317 9652 250 1.795812 4.48953 Stenotrophomonas geniculata 86188 Bacteria Bacteria 170 5.12e-47   NR WP_329767022.1 86188 g9616 i0 98.8 0.996 83 1 99.6 0 250 2 282 364 WP_329767022.1 helix-turn-helix domain-containing protein [Stenotrophomonas geniculata] diamond 249 170 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas geniculata
30894404 30894404 PRJNA1233317_S_NODE_7714_length_276_cov_4.926267_g7678_i0 PRJNA1233317 7714 276 4.926267 13.59649692 Afipia sp. 1871052 Bacteria Bacteria 79.3 2.92e-17   NR MBN9587268.1 1871052 g7678 i0 100 0.717391304347826 33 0 35.9 0 2 100 40 72 MBN9587268.1 hypothetical protein [Afipia sp.] diamond 198 79.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Afipia Afipia sp.
31020710 31020710 PRJNA1233317_S_NODE_12315_length_221_cov_1.895062_g12279_i0 PRJNA1233317 12315 221 1.895062 4.18808702 Sphingopyxis sp. A 1908224 Bacteria Bacteria 55.8 4.68e-8   NR KTE76093.1 1759083 g12279 i0 96.6 0.393665158371041 29 1 39.4 0 133 219 1 29 KTE76093.1 hypothetical protein ATE59_11425 [Sphingopyxis sp. A083] diamond 87 55.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingopyxis Sphingopyxis sp. A083
31368584 31368584 PRJNA1233317_S_NODE_1596_length_410_cov_4.991453_g1560_i0 PRJNA1233317 1596 410 4.991453 20.4649573 Bradyrhizobium aeschynomenes 2734909 Bacteria Bacteria 221 4.56e-71   NR WP_246739908.1 2734909 g1560 i0 86.4 1.94634146341463 132 18 96.6 0 9 404 60 191 WP_246739908.1 hypothetical protein [Bradyrhizobium aeschynomenes] diamond 798 221 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium aeschynomenes
31400138 31400138 PRJNA1233317_S_NODE_8936_length_259_cov_3.525000_g8900_i0 PRJNA1233317 8936 259 3.525 9.12975 Succinivibrio sp. 2053619 Bacteria Bacteria 178 3.29e-51   NR MBQ8477756.1 2053619 g8900 i0 100 0.996138996138996 86 0 99.6 0 258 1 418 503 MBQ8477756.1 C69 family dipeptidase [Succinivibrio sp.] diamond 258 178 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Succinivibrionaceae Succinivibrio Succinivibrio sp.
31747811 31747811 PRJNA1233317_S_NODE_5457_length_310_cov_4.948207_g5421_i0 PRJNA1233317 5457 310 4.948207 15.3394417 Burkholderia 32008 Bacteria Bacteria 171 7.79e-51   NR WP_176000377.1 32008 g5421 i0 100 0.812903225806452 84 0 81.3 0 252 1 1 84 WP_176000377.1 MULTISPECIES: hypothetical protein [Burkholderia] diamond 252 171 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia  
32790696 32790696 PRJNA1233317_S_NODE_3700_length_344_cov_2.140351_g3664_i0 PRJNA1233317 3700 344 2.140351 7.36280744 Pseudomonas sp. 8O 2653165 Bacteria Bacteria 216 9.42e-69   NR WP_160020154.1 2653165 g3664 i0 96.5 0.98546511627907 113 4 98.5 0 339 1 58 170 WP_160020154.1 ABC transporter ATP-binding protein [Pseudomonas sp. 8O] diamond 339 216 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. 8O

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