RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA854078" 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

  • PRJNA854078 · 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
27528978 27528978 PRJNA854078_P_NODE_14323_length_250_cov_0.870056_g14111_i0 PRJNA854078 14323 250 0.870056 2.17514 Acinetobacter baumannii 470 Bacteria Bacteria 169 1.55e-50   NR WP_331311202.1 470 g14111 i0 100 0.996 83 0 99.6 0 249 1 52 134 WP_331311202.1 DNA adenine methylase [Acinetobacter baumannii] diamond 249 169 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
27718872 27718872 PRJNA854078_P_NODE_11964_length_272_cov_2.321608_g11752_i0 PRJNA854078 11964 272 2.321608 6.31477376 Dyella nitratireducens 1849580 Bacteria Bacteria 45.4 0.0062   NR WP_229720870.1 1849580 g11752 i0 36.3 0.882352941176471 80 48 84.9 1 247 17 1836 1915 WP_229720870.1 beta-1,3-glucanase family protein [Dyella nitratireducens] diamond 240 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Rhodanobacteraceae Dyella Dyella nitratireducens
27876252 27876252 PRJNA854078_P_NODE_13725_length_254_cov_0.801105_g13513_i0 PRJNA854078 13725 254 0.801105 2.0348067 Amaricoccus sp. 1872485 Bacteria Bacteria 44.3 0.00953   NR WP_299133312.1 1872485 g13513 i0 34.8 0.779527559055118 66 40 78 2 200 3 84 146 WP_299133312.1 L,D-transpeptidase [Amaricoccus sp.] diamond 198 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Amaricoccus Amaricoccus sp.
28926380 28926380 PRJNA854078_P_NODE_17008_length_230_cov_2.687898_g16796_i0 PRJNA854078 17008 230 2.687898 6.1821654 Bacteria 2 Bacteria Bacteria 78.6 1.71e-15   NR HWP94373.1 1913989 g16796 i0 46.7 6.80869565217391 75 40 97.8 0 229 5 55 129 HWP94373.1 slipin family protein [Gammaproteobacteria bacterium] diamond 1566 79 0.994936708860759 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
28958232 28958232 PRJNA854078_P_NODE_12508_length_266_cov_1.269430_g12296_i0 PRJNA854078 12508 266 1.26943 3.3766838 Stenotrophomonas 40323 Bacteria Bacteria 180 5.2e-54   NR WP_049436696.1 40323 g12296 i0 98.9 1.98496240601504 88 1 99.2 0 265 2 163 250 WP_049436696.1 MULTISPECIES: hypothetical protein [Stenotrophomonas] diamond 528 180 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas  
29265375 29265375 PRJNA854078_P_NODE_5549_length_401_cov_10.975610_g5337_i0 PRJNA854078 5549 401 10.97561 44.0121961 Pseudomonadota bacterium 1977087 Bacteria Bacteria 62.8 2.09e-8   NR MFH1436096.1 1977087 g5337 i0 33.6 2.58852867830424 113 64 78.6 5 350 36 560 669 MFH1436096.1 FG-GAP-like repeat-containing protein [Pseudomonadota bacterium] diamond 1038 62.8 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29526444 29526444 PRJNA854078_P_NODE_7890_length_335_cov_1.129771_g7678_i0 PRJNA854078 7890 335 1.129771 3.78473285 root 1 Root_unresolved Root_unresolved 137 1.55e-36   NR WP_206601589.1 562 g7678 i0 56.8 57.6626865671642 111 48 99.4 0 2 334 266 376 WP_206601589.1 actin, partial [Escherichia coli] diamond 19317 138 0.992753623188406 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
29802254 29802254 PRJNA854078_P_NODE_4551_length_445_cov_4.814516_g4339_i0 PRJNA854078 4551 445 4.814516 21.4245962 Vibrio sp. 678 Bacteria Bacteria 45.4 0.026   NR MFV0576762.1 678 g4339 i0 28.1 0.815730337078652 121 71 71.5 5 108 425 30 149 MFV0576762.1 DUF6279 family lipoprotein [Vibrio sp.] diamond 363 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio sp.
29968473 29968473 PRJNA854078_P_NODE_6011_length_385_cov_1.560897_g5799_i0 PRJNA854078 6011 385 1.560897 6.00945345 root 1 Root_unresolved Root_unresolved 124 1.11e-33   NR MDB5523615.1 391 g5799 i0 53.4 1.86233766233766 118 53 91.9 1 385 32 9 124 MDB5523615.1 cdd [Rhizobium sp.] diamond 717 124 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium Rhizobium sp.
30316522 30316522 PRJNA854078_P_NODE_9332_length_308_cov_1.761702_g9120_i0 PRJNA854078 9332 308 1.761702 5.42604216 Pseudomonadota 1224 Bacteria Bacteria 46.2 0.00247   NR MDD3265746.1 1891238 g9120 i0 31.8 2.69805194805195 85 58 82.8 0 9 263 39 123 MDD3265746.1 Fe-S protein assembly co-chaperone HscB [Burkholderiales bacterium] diamond 831 46.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales     Burkholderiales bacterium
30403044 30403044 PRJNA854078_P_NODE_4813_length_433_cov_1.083333_g4601_i0 PRJNA854078 4813 433 1.083333 4.69083189 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 47.8 0.00122   NR WP_395585878.1 251699 g4601 i0 31.6 0.921478060046189 133 56 70 5 111 413 7 136 WP_395585878.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 399 47.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
30442503 30442503 PRJNA854078_P_NODE_3613_length_500_cov_1.615925_g3401_i0 PRJNA854078 3613 500 1.615925 8.079625 Bacteria 2 Bacteria Bacteria 68.6 6.83e-12   NR NOR79233.1 2020875 g3401 i0 58.8 2.13 51 21 30.6 0 354 202 20 70 NOR79233.1 NINE protein [Methyloprofundus sp.] diamond 1065 68.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales Methylococcaceae Methyloprofundus Methyloprofundus sp.
30908267 30908267 PRJNA854078_P_NODE_14074_length_251_cov_0.865169_g13862_i0 PRJNA854078 14074 251 0.865169 2.17157419 Nitrosomonas sp. 42353 Bacteria Bacteria 123 7.849999999999999e-31   NR MCB1984990.1 42353 g13862 i0 73.5 3.9681274900398402 83 22 99.2 0 249 1 251 333 MCB1984990.1 LON peptidase substrate-binding domain-containing protein [Nitrosomonas sp.] diamond 996 123 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas sp.
30908279 30908279 PRJNA854078_P_NODE_8154_length_329_cov_4.210938_g7942_i0 PRJNA854078 8154 329 4.210938 13.85398602 Paludibacterium sp. B53371 2806263 Bacteria Bacteria 65.5 1.06e-9   NR WP_215778995.1 2806263 g7942 i0 37 0.738601823708207 81 51 73.9 0 81 323 569 649 WP_215778995.1 carbohydrate-binding protein [Paludibacterium sp. B53371] diamond 243 65.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chromobacteriaceae Paludibacterium Paludibacterium sp. B53371
31572195 31572195 PRJNA854078_P_NODE_12956_length_261_cov_1.558511_g12744_i0 PRJNA854078 12956 261 1.558511 4.06771371 Pseudoalteromonas distincta 77608 Bacteria Bacteria 55.8 4.67e-7   NR MFT7568784.1 77608 g12744 i0 40.3 1.75862068965517 77 46 88.5 0 259 29 54 130 MFT7568784.1 Leucine-rich repeat (LRR) protein [Pseudoalteromonas distincta] diamond 459 55.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Pseudoalteromonadaceae Pseudoalteromonas Pseudoalteromonas distincta
31761780 31761780 PRJNA854078_P_NODE_6957_length_357_cov_2.538732_g6745_i0 PRJNA854078 6957 357 2.538732 9.06327324 Mergibacter septicus 221402 Bacteria Bacteria 44.7 0.0207   NR WP_261920896.1 221402 g6745 i0 33.3 2.47058823529412 102 56 78.2 4 324 46 5 103 WP_261920896.1 NTP transferase domain-containing protein [Mergibacter septicus] diamond 882 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Mergibacter Mergibacter septicus
32078151 32078151 PRJNA854078_P_NODE_16298_length_242_cov_0.911243_g16086_i0 PRJNA854078 16298 242 0.911243 2.20520806 Caulobacter sp. RHG1 2545762 Bacteria Bacteria 150 3.2799999999999993e-40   NR WP_172270818.1 2545762 g16086 i0 87.5 0.991735537190083 80 10 99.2 0 2 241 313 392 WP_172270818.1 outer membrane beta-barrel family protein [Caulobacter sp. RHG1] diamond 240 150 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Caulobacter Caulobacter sp. RHG1
32268202 32268202 PRJNA854078_P_NODE_4478_length_449_cov_1.308511_g4266_i0 PRJNA854078 4478 449 1.308511 5.87521439 Hyphomicrobiales bacterium 1909294 Bacteria Bacteria 45.1 0.0261   NR MBV8450579.1 1909294 g4266 i0 29 0.922048997772829 138 88 90.2 3 439 35 21 151 MBV8450579.1 FAD-binding oxidoreductase [Hyphomicrobiales bacterium] diamond 414 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales     Hyphomicrobiales 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);;