RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA698538" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA698538 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
3735853 3735853 PRJNA698538_S_NODE_21863_length_274_cov_1.228856_g21697_i0 PRJNA698538 21863 274 1.228856 3.36706544 Methylobacterium 407 Bacteria Bacteria 129 7.41e-35   NR WP_024827429.1 409 g21697 i0 69.3 7.74087591240876 88 27 96.4 0 274 11 54 141 WP_024827429.1 HWE histidine kinase domain-containing protein [Methylobacterium sp.] diamond 2121 129 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium sp.
7059774 7059774 PRJNA698538_S_NODE_10066_length_349_cov_1.673913_g9900_i0 PRJNA698538 10066 349 1.673913 5.84195637 Bacteria 2 Bacteria Bacteria 127 1.43e-31   NR HSD42132.1 1891238 g9900 i0 63 10.3151862464183 100 36 85.1 1 27 323 481 580 HSD42132.1 thiamine pyrophosphate-binding protein [Burkholderiales bacterium] diamond 3600 128 0.9921875 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales     Burkholderiales bacterium
26893105 26893105 PRJNA698538_S_NODE_9281_length_356_cov_2.201413_g9115_i0 PRJNA698538 9281 356 2.201413 7.83703028 Hyphomicrobiales bacterium 1909294 Bacteria Bacteria 176 2.0599999999999998e-54   NR MBN8974307.1 1909294 g9115 i0 79.7 1.03651685393258 123 20 99.4 1 354 1 6 128 MBN8974307.1 hypothetical protein [Hyphomicrobiales bacterium] diamond 369 176 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales     Hyphomicrobiales bacterium
27525076 27525076 PRJNA698538_S_NODE_29983_length_241_cov_1.625000_g29817_i0 PRJNA698538 29983 241 1.625 3.91625 Shewanella electrica 515560 Bacteria Bacteria 75.1 7.38e-16   NR WP_369123403.1 515560 g29817 i0 78.7 1.1701244813278 47 10 58.5 0 241 101 18 64 WP_369123403.1 eS28 family ribosomal protein [Shewanella electrica] diamond 282 75.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Shewanellaceae Shewanella Shewanella electrica
27872377 27872377 PRJNA698538_S_NODE_27065_length_250_cov_0.807910_g26899_i0 PRJNA698538 27065 250 0.80791 2.019775 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 44.7 0.00544   NR WP_395568434.1 251699 g26899 i0 51.1 0.564 47 20 56.4 2 77 217 64 107 WP_395568434.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 141 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
28598753 28598753 PRJNA698538_S_NODE_15067_length_312_cov_2.322176_g14901_i0 PRJNA698538 15067 312 2.322176 7.24518912 Pseudomonadales bacterium 1891229 Bacteria Bacteria 46.2 0.00217   NR MFQ3322558.1 1891229 g14901 i0 40.4 0.451923076923077 47 28 45.2 0 312 172 43 89 MFQ3322558.1 rhodanese-related sulfurtransferase [Pseudomonadales bacterium] diamond 141 46.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales     Pseudomonadales bacterium
29135592 29135592 PRJNA698538_S_NODE_32149_length_211_cov_14.963768_g31983_i0 PRJNA698538 32149 211 14.963768 31.57355048 Klebsiella pneumoniae 573 Bacteria Bacteria 61.2 6.78e-10   NR WP_416501348.1 573 g31983 i0 96.6 0.824644549763033 29 1 41.2 0 107 193 97 125 WP_416501348.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 174 61.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29841201 29841201 PRJNA698538_S_NODE_19591_length_285_cov_4.108491_g19425_i0 PRJNA698538 19591 285 4.108491 11.70919935 Mesorhizobium 68287 Bacteria Bacteria 110 5.68e-29   NR TIU17063.1 1871066 g19425 i0 65.2 6.52631578947368 89 30 93.7 1 14 280 11 98 TIU17063.1 MAG: hypothetical protein E5W49_20795, partial [Mesorhizobium sp.] diamond 1860 110 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium sp.
30335893 30335893 PRJNA698538_S_NODE_21292_length_277_cov_1.220588_g21126_i0 PRJNA698538 21292 277 1.220588 3.38102876 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 43.9 0.0141   NR WP_395588384.1 251699 g21126 i0 43.2 0.877256317689531 81 36 85.6 4 24 260 115 187 WP_395588384.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 243 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
31251725 31251725 PRJNA698538_S_NODE_20415_length_281_cov_2.591346_g20249_i0 PRJNA698538 20415 281 2.591346 7.28168226 Wohlfahrtiimonas chitiniclastica 400946 Bacteria Bacteria 107 1.2900000000000002e-27   NR WP_094491519.1 400946 g20249 i0 60.2 0.99288256227758 93 37 99.3 0 281 3 24 116 WP_094491519.1 GNAT family N-acetyltransferase [Wohlfahrtiimonas chitiniclastica] diamond 279 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cardiobacteriales Ignatzschineriaceae Wohlfahrtiimonas Wohlfahrtiimonas chitiniclastica
31409988 31409988 PRJNA698538_S_NODE_11536_length_337_cov_1.106061_g11370_i0 PRJNA698538 11536 337 1.106061 3.72742557 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 45.1 0.0064   NR WP_395515008.1 251699 g11370 i0 43.8 1.23738872403561 73 27 53.4 2 105 284 48 119 WP_395515008.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 417 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
31599874 31599874 PRJNA698538_S_NODE_18916_length_289_cov_2.138889_g18750_i0 PRJNA698538 18916 289 2.138889 6.18138921 Photobacterium phosphoreum 659 Bacteria Bacteria 98.6 3.49e-22   NR WP_283393077.1 659 g18750 i0 69.6 0.716262975778547 69 21 71.6 0 287 81 275 343 WP_283393077.1 hypothetical protein [Photobacterium phosphoreum] diamond 207 98.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Photobacterium Photobacterium phosphoreum
31757822 31757822 PRJNA698538_S_NODE_20637_length_280_cov_1.864734_g20471_i0 PRJNA698538 20637 280 1.864734 5.2212552 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 42.4 0.021   NR WP_395580181.1 251699 g20471 i0 45.3 0.921428571428571 86 23 69.6 6 65 259 5 87 WP_395580181.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 258 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
31863804 31863804 PRJNA698538_S_NODE_19277_length_287_cov_2.322430_g19111_i0 PRJNA698538 19277 287 2.32243 6.6653741 root 1 Root_unresolved Root_unresolved 48.9 1.12e-4   NR WP_220492980.1 573 g19111 i0 62.9 1.10801393728223 35 13 36.6 0 7 111 3 37 WP_220492980.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 318 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32085376 32085376 PRJNA698538_S_NODE_24678_length_260_cov_1.475936_g24512_i0 PRJNA698538 24678 260 1.475936 3.8374335999999998 Pseudomonadati 3379134 Bacteria Bacteria 104 1.98e-24   NR WP_076203211.1 1842727 g24512 i0 62 13.1653846153846 79 29 91.2 1 7 243 1 78 WP_076203211.1 iron-containing alcohol dehydrogenase [Rhodoferax koreense] diamond 3423 105 0.990476190476191 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Rhodoferax Rhodoferax koreensis
32264369 32264369 PRJNA698538_S_NODE_26898_length_250_cov_1.485876_g26732_i0 PRJNA698538 26898 250 1.485876 3.71469 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 40.8 0.0357   NR WP_395578412.1 251699 g26732 i0 49.2 0.708 59 26 70.8 2 45 221 1 55 WP_395578412.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 177 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7

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