RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA624323" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA624323 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
4423964 4423964 PRJNA624323_P_NODE_6344_length_285_cov_1.367925_g6182_i0 PRJNA624323 6344 285 1.367925 3.89858625 Hyphomicrobiales 356 Bacteria Bacteria 101 2.5499999999999998e-23   NR WP_002718111.1 1033 g6182 i0 95.9 1.03157894736842 49 2 51.6 0 149 3 1 49 WP_002718111.1 MULTISPECIES: thioredoxin-disulfide reductase [Afipia] diamond 294 102 0.990196078431373 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Afipia  
5699926 5699926 PRJNA624323_P_NODE_9545_length_241_cov_0.916667_g9383_i0 PRJNA624323 9545 241 0.916667 2.20916747 Hyphomonas sp. 87 Bacteria Bacteria 164 1.41e-49   NR WP_291069978.1 87 g9383 i0 98.8 0.995850622406639 80 1 99.6 0 241 2 111 190 WP_291069978.1 TetR/AcrR family transcriptional regulator [Hyphomonas sp.] diamond 240 164 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomonadales Hyphomonadaceae Hyphomonas Hyphomonas sp.
10078691 10078691 PRJNA624323_P_NODE_9368_length_242_cov_0.911243_g9206_i0 PRJNA624323 9368 242 0.911243 2.20520806 Rheinheimera 67575 Bacteria Bacteria 150 6.769999999999998e-42   NR WP_147904741.1 400153 g9206 i0 85 1.98347107438017 80 12 99.2 0 2 241 273 352 WP_147904741.1 UDP-N-acetyl-D-mannosamine dehydrogenase [Rheinheimera tangshanensis] diamond 480 150 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera tangshanensis
20998697 20998697 PRJNA624323_P_NODE_9477_length_241_cov_0.916667_g9315_i0 PRJNA624323 9477 241 0.916667 2.20916747 Pseudomonadota 1224 Bacteria Bacteria 138 1.76e-36   NR WP_291861034.1 376 g9315 i0 88.8 25.8921161825726 80 9 99.6 0 240 1 294 373 WP_291861034.1 ferredoxin:protochlorophyllide reductase (ATP-dependent) subunit B [Bradyrhizobium sp.] diamond 6240 138 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp.
24102019 24102019 PRJNA624323_P_NODE_8259_length_249_cov_0.875000_g8097_i0 PRJNA624323 8259 249 0.875 2.17875 Aquariibacter lacus 2801332 Bacteria Bacteria 111 6.67e-27   NR WP_201824029.1 2801332 g8097 i0 93.7 0.759036144578313 63 4 75.9 0 249 61 134 196 WP_201824029.1 AAA family ATPase [Aquariibacter lacus] diamond 189 111 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Aquariibacter Aquariibacter lacus
26605532 26605532 PRJNA624323_P_NODE_9181_length_243_cov_0.905882_g9019_i0 PRJNA624323 9181 243 0.905882 2.20129326 unclassified Sphingomonas 196159 Bacteria Bacteria 147 4.93e-39   NR WP_294443173.1 196159 g9019 i0 85 0.987654320987654 80 12 98.8 0 2 241 281 360 WP_294443173.1 MULTISPECIES: primase-helicase family protein [unclassified Sphingomonas] diamond 240 147 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
26700547 26700547 PRJNA624323_P_NODE_7961_length_251_cov_0.865169_g7799_i0 PRJNA624323 7961 251 0.865169 2.17157419 Xanthobacteraceae bacterium 2021379 Bacteria Bacteria 156 4.109999999999999e-47   NR MBX9845150.1 2021379 g7799 i0 100 0.944223107569721 79 0 94.4 0 249 13 53 131 MBX9845150.1 RidA family protein [Xanthobacteraceae bacterium] diamond 237 156 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Xanthobacteraceae   Xanthobacteraceae bacterium
26764030 26764030 PRJNA624323_P_NODE_8721_length_246_cov_0.890173_g8559_i0 PRJNA624323 8721 246 0.890173 2.18982558 Francisella sp. 2047875 Bacteria Bacteria 155 3.37e-44   NR PZU05366.1 2047875 g8559 i0 95.3 1.03658536585366 85 0 98.8 1 244 2 80 164 PZU05366.1 MAG: hypothetical protein DI619_00645, partial [Francisella sp.] diamond 255 155 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Francisellaceae Francisella Francisella sp.
26827531 26827531 PRJNA624323_P_NODE_9481_length_241_cov_0.916667_g9319_i0 PRJNA624323 9481 241 0.916667 2.20916747 Thermomonas hydrothermalis 213588 Bacteria Bacteria 151 2.1499999999999993e-40   NR WP_072755804.1 213588 g9319 i0 97.5 0.995850622406639 80 2 99.6 0 240 1 3 82 WP_072755804.1 LPS assembly protein LptD [Thermomonas hydrothermalis] diamond 240 151 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Thermomonas Thermomonas hydrothermalis
27017244 27017244 PRJNA624323_P_NODE_8622_length_247_cov_0.885057_g8460_i0 PRJNA624323 8622 247 0.885057 2.18609079 Sphingomonas sp. 28214 Bacteria Bacteria 167 3.16e-48   NR WP_374134943.1 28214 g8460 i0 100 0.995951417004049 82 0 99.6 0 247 2 205 286 WP_374134943.1 hypothetical protein [Sphingomonas sp.] diamond 246 167 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp.
27175173 27175173 PRJNA624323_P_NODE_9942_length_226_cov_6.712418_g9780_i0 PRJNA624323 9942 226 6.712418 15.17006468 Nitrosospira sp. 38080 Bacteria Bacteria 42.4 0.0397   NR MBN9124366.1 38080 g9780 i0 35.2 0.716814159292035 54 35 71.7 0 201 40 77 130 MBN9124366.1 HPr kinase/phosphorylase [Nitrosospira sp.] diamond 162 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosospira Nitrosospira sp.
27681120 27681120 PRJNA624323_P_NODE_9464_length_241_cov_0.916667_g9302_i0 PRJNA624323 9464 241 0.916667 2.20916747 Bradyrhizobium sp. KB893862 SZCCT 376 Bacteria Bacteria 52 1.96e-5   NR WP_212028397.1 2807672 g9302 i0 75 3.33609958506224 32 8 39.8 0 238 143 409 440 WP_212028397.1 amidase [Bradyrhizobium sp. KB893862 SZCCT0404] diamond 804 52 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. KB893862 SZCCT0404
28438742 28438742 PRJNA624323_P_NODE_9386_length_242_cov_0.911243_g9224_i0 PRJNA624323 9386 242 0.911243 2.20520806 Candidatus Raskinella chloraquaticus 1951219 Bacteria Bacteria 138 6.16e-36   NR WP_376802789.1 1951219 g9224 i0 100 0.991735537190083 80 0 99.2 0 240 1 638 717 WP_376802789.1 ribonuclease R family protein [Candidatus Raskinella chloraquaticus] diamond 240 138 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phreatobacteraceae Candidatus Raskinella Candidatus Raskinella chloraquaticus
28501798 28501798 PRJNA624323_P_NODE_9907_length_228_cov_2.277419_g9745_i0 PRJNA624323 9907 228 2.277419 5.19251532 Rheinheimera sp. 1869214 Bacteria Bacteria 59.3 3.02e-9   NR MDZ7868654.1 1869214 g9745 i0 66 0.618421052631579 47 16 61.8 0 204 64 60 106 MDZ7868654.1 hypothetical protein [Rheinheimera sp.] diamond 141 59.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp.
28596597 28596597 PRJNA624323_P_NODE_8567_length_247_cov_0.885057_g8405_i0 PRJNA624323 8567 247 0.885057 2.18609079 Salmonella sp. s6 599 Bacteria Bacteria 162 3.0500000000000002e-49   NR WP_411028222.1 3159722 g8405 i0 100 0.995951417004049 82 0 99.6 0 1 246 64 145 WP_411028222.1 hypothetical protein, partial [Salmonella sp. s60131] diamond 246 162 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. s60131
28628224 28628224 PRJNA624323_P_NODE_8867_length_245_cov_0.895349_g8705_i0 PRJNA624323 8867 245 0.895349 2.19360505 Hyphomonas sp. 87 Bacteria Bacteria 114 3.45e-28   NR MEQ9504764.1 87 g8705 i0 79 0.991836734693878 81 17 99.2 0 245 3 213 293 MEQ9504764.1 hypothetical protein [Hyphomonas sp.] diamond 243 114 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomonadales Hyphomonadaceae Hyphomonas Hyphomonas sp.
28628225 28628225 PRJNA624323_P_NODE_9187_length_243_cov_0.905882_g9025_i0 PRJNA624323 9187 243 0.905882 2.20129326 Pseudomonadota bacterium 1977087 Bacteria Bacteria 116 3.6199999999999997e-28   NR MES2194407.1 1977087 g9025 i0 82.4 1.67901234567901 68 12 84 0 3 206 672 739 MES2194407.1 TonB-dependent receptor [Pseudomonadota bacterium] diamond 408 116 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29493331 29493331 PRJNA624323_P_NODE_8910_length_245_cov_0.895349_g8748_i0 PRJNA624323 8910 245 0.895349 2.19360505 Sphingomonas 13687 Bacteria Bacteria 128 2.48e-34   NR WP_344710055.1 335630 g8748 i0 77.2 1.93469387755102 79 18 96.7 0 242 6 64 142 WP_344710055.1 c-type cytochrome [Sphingomonas humi] diamond 474 128 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas humi
29525005 29525005 PRJNA624323_P_NODE_9390_length_242_cov_0.911243_g9228_i0 PRJNA624323 9390 242 0.911243 2.20520806 Pseudomonadota 1224 Bacteria Bacteria 131 2.64e-33   NR WP_252658237.1 2004485 g9228 i0 95.6 1.71074380165289 68 3 84.3 0 242 39 194 261 WP_252658237.1 DUF1631 family protein [Acidovorax kalamii] diamond 414 131 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Acidovorax Acidovorax kalamii
29985787 29985787 PRJNA624323_P_NODE_7811_length_253_cov_1.283333_g7649_i0 PRJNA624323 7811 253 1.283333 3.24683249 Candidatus Raskinella chloraquaticus 1951219 Bacteria Bacteria 160 3.18e-49   NR WP_376800425.1 1951219 g7649 i0 100 0.901185770750988 76 0 90.1 0 1 228 11 86 WP_376800425.1 glutaredoxin 3 [Candidatus Raskinella chloraquaticus] diamond 228 160 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phreatobacteraceae Candidatus Raskinella Candidatus Raskinella chloraquaticus
29985788 29985788 PRJNA624323_P_NODE_8631_length_247_cov_0.885057_g8469_i0 PRJNA624323 8631 247 0.885057 2.18609079 Klebsiella pneumoniae 573 Bacteria Bacteria 61.2 2.33e-10   NR WP_227656067.1 573 g8469 i0 65 0.48582995951417 40 14 48.6 0 127 246 1 40 WP_227656067.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 120 61.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30112056 30112056 PRJNA624323_P_NODE_8712_length_246_cov_0.890173_g8550_i0 PRJNA624323 8712 246 0.890173 2.18982558 Paracoccaceae bacterium 1904441 Bacteria Bacteria 69.7 1.62e-12   NR MCB2107007.1 1904441 g8550 i0 83.8 0.902439024390244 37 6 45.1 0 133 243 1 37 MCB2107007.1 single-stranded DNA-binding protein [Paracoccaceae bacterium] diamond 222 69.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae   Paracoccaceae bacterium
30491355 30491355 PRJNA624323_P_NODE_9513_length_241_cov_0.916667_g9351_i0 PRJNA624323 9513 241 0.916667 2.20916747 Sphingobium yanoikuyae 13690 Bacteria Bacteria 136 2.96e-39   NR WP_312251127.1 13690 g9351 i0 92.5 0.995850622406639 80 6 99.6 0 1 240 53 132 WP_312251127.1 YsnF/AvaK domain-containing protein [Sphingobium yanoikuyae] diamond 240 136 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingobium Sphingobium yanoikuyae
31154448 31154448 PRJNA624323_P_NODE_9195_length_243_cov_0.905882_g9033_i0 PRJNA624323 9195 243 0.905882 2.20129326 Burkholderiales bacterium RIFCSPHIGHO2_ 1891238 Bacteria Bacteria 120 6.28e-31   NR OGA84221.1 1797552 g9033 i0 87.5 0.790123456790123 64 8 79 0 241 50 261 324 OGA84221.1 MAG: pseudouridine synthase [Burkholderiales bacterium RIFCSPHIGHO2_01_FULL_63_240] diamond 192 120 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales     Burkholderiales bacterium RIFCSPHIGHO2_01_FULL_63_240
31281192 31281192 PRJNA624323_P_NODE_5435_length_311_cov_0.831933_g5273_i0 PRJNA624323 5435 311 0.831933 2.58731163 Paludibacterium purpuratum 1144873 Bacteria Bacteria 46.6 0.00143   NR WP_133681878.1 1144873 g5273 i0 40 0.578778135048232 60 35 56.9 1 269 93 21 80 WP_133681878.1 RDD family protein [Paludibacterium purpuratum] diamond 180 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chromobacteriaceae Paludibacterium Paludibacterium purpuratum
31376246 31376246 PRJNA624323_P_NODE_8776_length_246_cov_0.890173_g8614_i0 PRJNA624323 8776 246 0.890173 2.18982558 Duganella sp. Leaf61 1736227 Bacteria Bacteria 75.9 8.5e-14   NR WP_229205119.1 1736227 g8614 i0 66.7 0.804878048780488 66 22 80.5 0 49 246 1 66 WP_229205119.1 diguanylate cyclase domain-containing protein [Duganella sp. Leaf61] diamond 198 75.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Duganella Duganella sp. Leaf61
31723980 31723980 PRJNA624323_P_NODE_5397_length_312_cov_1.288703_g5235_i0 PRJNA624323 5397 312 1.288703 4.02075336 Francisella sp. 2047875 Bacteria Bacteria 173 1.3899999999999997e-52   NR PZU02922.1 2047875 g5235 i0 98.8 0.817307692307692 85 1 81.7 0 256 2 1 85 PZU02922.1 MAG: DNA polymerase III subunit gamma/tau, partial [Francisella sp.] diamond 255 173 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Francisellaceae Francisella Francisella sp.
31723982 31723982 PRJNA624323_P_NODE_9237_length_243_cov_0.905882_g9075_i0 PRJNA624323 9237 243 0.905882 2.20129326 Proteobacteria bacterium SG_bin9 1827385 Bacteria Bacteria 129 2.92e-36   NR OQW59208.1 1827385 g9075 i0 80 3.7037037037037 75 15 92.6 0 18 242 1 75 OQW59208.1 MAG: DoxX family protein [Proteobacteria bacterium SG_bin9] diamond 900 129 1 Bacteria   Pseudomonadati Pseudomonadota         Proteobacteria bacterium SG_bin9
32103663 32103663 PRJNA624323_P_NODE_7998_length_251_cov_0.865169_g7836_i0 PRJNA624323 7998 251 0.865169 2.17157419 Rheinheimera texasensis 306205 Bacteria Bacteria 166 6.57e-51   NR WP_031571181.1 306205 g7836 i0 85.4 2.9402390438247 82 12 98 0 249 4 34 115 WP_031571181.1 DUF2750 domain-containing protein [Rheinheimera texasensis] diamond 738 166 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera texasensis
32464733 32464733 PRJNA624323_P_NODE_7939_length_251_cov_0.865169_g7777_i0 PRJNA624323 7939 251 0.865169 2.17157419 Pseudomonadota 1224 Bacteria Bacteria 100 5.45e-25   NR WP_226561602.1 282683 g7777 i0 96.3 1.42231075697211 54 2 64.5 0 90 251 1 54 WP_226561602.1 IS66-like element accessory protein TnpA [Salipiger thiooxidans] diamond 357 100 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Salipiger Salipiger thiooxidans

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