RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA900999 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
2153448 2153448 PRJNA900999_S_NODE_9542_length_152_cov_1.975610_g9486_i0 PRJNA900999 9542 152 1.97561 3.0029272 Rehaibacterium terrae 1341696 Bacteria Bacteria 98.6 5.46e-24   NR WP_183949368.1 1341696 g9486 i0 94 0.986842105263158 50 3 98.7 0 150 1 150 199 WP_183949368.1 peptide-methionine (S)-S-oxide reductase MsrA [Rehaibacterium terrae] diamond 150 98.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Rehaibacterium Rehaibacterium terrae
5981392 5981392 PRJNA900999_S_NODE_4985_length_196_cov_2.323353_g4929_i0 PRJNA900999 4985 196 2.323353 4.55377188 Vulcaniibacterium thermophilum 1169913 Bacteria Bacteria 136 1.2e-37   NR WP_146474976.1 1169913 g4929 i0 100 0.994897959183674 65 0 99.5 0 196 2 219 283 WP_146474976.1 alpha/beta fold hydrolase [Vulcaniibacterium thermophilum] diamond 195 136 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Vulcaniibacterium Vulcaniibacterium thermophilum
8530964 8530964 PRJNA900999_S_NODE_4447_length_205_cov_1.931818_g4391_i0 PRJNA900999 4447 205 1.931818 3.9602269 Vulcaniibacterium thermophilum 1169913 Bacteria Bacteria 114 3.61e-29   NR WP_146471866.1 1169913 g4391 i0 92.3 0.951219512195122 65 5 95.1 0 1 195 187 251 WP_146471866.1 imidazole glycerol phosphate synthase subunit HisF [Vulcaniibacterium thermophilum] diamond 195 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Vulcaniibacterium Vulcaniibacterium thermophilum
13631848 13631848 PRJNA900999_S_NODE_5651_length_187_cov_1.949367_g5595_i0 PRJNA900999 5651 187 1.949367 3.64531629 Solimonas fluminis 2086571 Bacteria Bacteria 101 5.12e-25   NR WP_104231293.1 2086571 g5595 i0 77.4 2.98395721925134 62 14 99.5 0 1 186 71 132 WP_104231293.1 23S rRNA (uridine(2552)-2'-O)-methyltransferase RlmE [Solimonas fluminis] diamond 558 101 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales Nevskiaceae Solimonas Solimonas fluminis
20004680 20004680 PRJNA900999_S_NODE_1896_length_279_cov_13.512000_g1840_i0 PRJNA900999 1896 279 13.512 37.698480000000004 root 1 Root_unresolved Root_unresolved 143 1.61e-42   NR WP_336508726.1 573 g1840 i0 95.8 99.6774193548387 72 3 77.4 0 3 218 3 74 WP_336508726.1 30S ribosomal protein S10, partial [Klebsiella pneumoniae] diamond 27810 144 0.993055555555556 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
23830229 23830229 PRJNA900999_S_NODE_5739_length_186_cov_2.452229_g5683_i0 PRJNA900999 5739 186 2.452229 4.56114594 Amaricoccus sp. 1872485 Bacteria Bacteria 81.3 4.66e-16   NR MFO1105820.1 1872485 g5683 i0 62.7 0.951612903225806 59 22 95.2 0 1 177 112 170 MFO1105820.1 alpha/beta hydrolase [Amaricoccus sp.] diamond 177 81.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Amaricoccus Amaricoccus sp.
23830238 23830238 PRJNA900999_S_NODE_6759_length_174_cov_3.627586_g6703_i0 PRJNA900999 6759 174 3.627586 6.31199964 Gammaproteobacteria 1236 Bacteria Bacteria 111 5.270000000000001e-27   NR MCX7069615.1 1913989 g6703 i0 98 3.51724137931034 51 1 87.9 0 22 174 154 204 MCX7069615.1 cryptochrome/photolyase family protein [Gammaproteobacteria bacterium] diamond 612 112 0.991071428571429 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
23830259 23830259 PRJNA900999_S_NODE_9359_length_153_cov_2.258065_g9303_i0 PRJNA900999 9359 153 2.258065 3.45483945 Vulcaniibacterium thermophilum 1169913 Bacteria Bacteria 104 5.2100000000000006e-27   NR WP_229814883.1 1169913 g9303 i0 100 0.980392156862745 50 0 98 0 2 151 72 121 WP_229814883.1 molybdenum cofactor biosynthesis protein MoaE [Vulcaniibacterium thermophilum] diamond 150 104 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Vulcaniibacterium Vulcaniibacterium thermophilum
27435306 27435306 PRJNA900999_S_NODE_5743_length_186_cov_2.375796_g5687_i0 PRJNA900999 5743 186 2.375796 4.41898056 Lysobacteraceae bacterium 1926873 Bacteria Bacteria 74.7 2.17e-14   NR MBA4284202.1 1926873 g5687 i0 100 0.612903225806452 38 0 61.3 0 168 55 164 201 MBA4284202.1 50S ribosomal protein L25 [Lysobacteraceae bacterium] diamond 114 74.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae   Lysobacteraceae bacterium
27656241 27656241 PRJNA900999_S_NODE_7504_length_167_cov_2.949275_g7448_i0 PRJNA900999 7504 167 2.949275 4.92528925 Escherichia coli 562 Bacteria Bacteria 102 3.73e-27   NR WP_167399334.1 562 g7448 i0 100 0.916167664670659 51 0 91.6 0 153 1 1 51 WP_167399334.1 hypothetical protein, partial [Escherichia coli] diamond 153 102 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27782505 27782505 PRJNA900999_S_NODE_5024_length_195_cov_4.813253_g4968_i0 PRJNA900999 5024 195 4.813253 9.38584335 Enterobacter hormaechei 158836 Bacteria Bacteria 67.8 8.17e-12   NR QDE47414.1 158836 g4968 i0 70.7 19.0153846153846 58 17 89.2 0 186 13 148 205 QDE47414.1 oxygen-insensitive NAD(P)H nitroreductase [Enterobacter hormaechei] diamond 3708 67.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
27908377 27908377 PRJNA900999_S_NODE_3805_length_218_cov_2.349206_g3749_i0 PRJNA900999 3805 218 2.349206 5.12126908 Nevskia sp. 1929292 Bacteria Bacteria 107 3.43e-25   NR WP_293372991.1 1929292 g3749 i0 90.3 0.853211009174312 62 6 85.3 0 33 218 3 64 WP_293372991.1 type I polyketide synthase [Nevskia sp.] diamond 186 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales Nevskiaceae Nevskia Nevskia sp.
27940354 27940354 PRJNA900999_S_NODE_5105_length_194_cov_3.024242_g5049_i0 PRJNA900999 5105 194 3.024242 5.86702948 Klebsiella pneumoniae 573 Bacteria Bacteria 103 2.0100000000000003e-27   NR MBL2545111.1 573 g5049 i0 98 0.77319587628866 50 1 77.3 0 45 194 1 50 MBL2545111.1 glycosyltransferase family 4 protein [Klebsiella pneumoniae] diamond 150 103 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28263417 28263417 PRJNA900999_S_NODE_8066_length_162_cov_2.939850_g8010_i0 PRJNA900999 8066 162 2.93985 4.762557 Burkholderia 32008 Bacteria Bacteria 41.2 0.0157   NR KOT11876.1 13373 g8010 i0 60 1.85185185185185 25 10 46.3 0 13 87 58 82 KOT11876.1 putative serine acetyltransferase [Burkholderia mallei] diamond 300 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia mallei
28540389 28540389 PRJNA900999_S_NODE_5847_length_184_cov_115.677419_g5791_i0 PRJNA900999 5847 184 115.677419 212.84645096 Klebsiella pneumoniae 573 Bacteria Bacteria 56.2 4.43e-8   NR WP_416532855.1 573 g5791 i0 62.2 1.19021739130435 37 14 60.3 0 158 48 95 131 WP_416532855.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 219 56.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28855725 28855725 PRJNA900999_S_NODE_9708_length_151_cov_2.459016_g9652_i0 PRJNA900999 9708 151 2.459016 3.71311416 Vulcaniibacterium thermophilum 1169913 Bacteria Bacteria 100 3.5299999999999995e-23   NR WP_146473296.1 1169913 g9652 i0 100 0.973509933774834 49 0 97.4 0 2 148 221 269 WP_146473296.1 lytic transglycosylase domain-containing protein [Vulcaniibacterium thermophilum] diamond 147 100 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Vulcaniibacterium Vulcaniibacterium thermophilum
29014062 29014062 PRJNA900999_S_NODE_4388_length_206_cov_2.531073_g4332_i0 PRJNA900999 4388 206 2.531073 5.21401038 unclassified Rhizobium 2613769 Bacteria Bacteria 58.9 4.39e-8   NR WP_247749335.1 2613769 g4332 i0 82.4 0.495145631067961 34 6 49.5 0 103 2 24 57 WP_247749335.1 MULTISPECIES: hypothetical protein [unclassified Rhizobium] diamond 102 58.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium  
29644832 29644832 PRJNA900999_S_NODE_2210_length_265_cov_9.351695_g2154_i0 PRJNA900999 2210 265 9.351695 24.78199175 Salmonella sp. s55 599 Bacteria Bacteria 50.1 3.65e-6   NR WP_411026885.1 3159677 g2154 i0 95.8 1.51698113207547 24 1 27.2 0 247 176 5 28 WP_411026885.1 EF-hand domain-containing protein [Salmonella sp. s55044] diamond 402 50.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. s55044
29771376 29771376 PRJNA900999_S_NODE_3891_length_216_cov_3.021390_g3835_i0 PRJNA900999 3891 216 3.02139 6.5262024 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 137 1.6399999999999998e-35   NR MCX7071810.1 1913989 g3835 i0 94.4 0.986111111111111 71 4 98.6 0 2 214 182 252 MCX7071810.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 213 137 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
30403817 30403817 PRJNA900999_S_NODE_4513_length_204_cov_2.040000_g4457_i0 PRJNA900999 4513 204 2.04 4.1616 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 68.2 3.95e-13   NR WP_267994683.1 715 g4457 i0 61 0.867647058823529 59 23 86.8 0 2 178 25 83 WP_267994683.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae] diamond 177 68.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae
30498192 30498192 PRJNA900999_S_NODE_8693_length_157_cov_5.179688_g8637_i0 PRJNA900999 8693 157 5.179688 8.13211016 Thiolapillus sp. 2017437 Bacteria Bacteria 40 0.0291   NR WP_293682377.1 2017437 g8637 i0 73.7 0.363057324840764 19 5 36.3 0 69 125 43 61 WP_293682377.1 hypothetical protein, partial [Thiolapillus sp.] diamond 57 40 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Thiolapillus Thiolapillus sp.
30948315 30948315 PRJNA900999_S_NODE_8174_length_161_cov_3.560606_g8118_i0 PRJNA900999 8174 161 3.560606 5.73257566 Pseudoxanthomonas 83618 Bacteria Bacteria 101 9.28e-24   NR WP_050992161.1 1211114 g8118 i0 88.5 1.93788819875776 52 6 96.9 0 160 5 41 92 WP_050992161.1 glycosyltransferase [Pseudoxanthomonas sp. GW2] diamond 312 101 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Pseudoxanthomonas Pseudoxanthomonas sp. GW2
31224748 31224748 PRJNA900999_S_NODE_515_length_424_cov_41.635443_g461_i0 PRJNA900999 515 424 41.635443 176.53427832 Pseudoduganella buxea 1949069 Bacteria Bacteria 125 4.2799999999999994e-31   NR WP_155470567.1 1949069 g461 i0 65.1 1.17452830188679 83 29 58.7 0 424 176 341 423 WP_155470567.1 glucan 1,4-alpha-maltotetraohydrolase domain-containing protein [Pseudoduganella buxea] diamond 498 125 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Pseudoduganella Pseudoduganella buxea
31635999 31635999 PRJNA900999_S_NODE_7496_length_167_cov_3.246377_g7440_i0 PRJNA900999 7496 167 3.246377 5.42144959 Methyloversatilis sp. 2569862 Bacteria Bacteria 100 6.039999999999999e-23   NR WP_296808134.1 2569862 g7440 i0 92.7 0.988023952095808 55 4 98.8 0 165 1 570 624 WP_296808134.1 non-ribosomal peptide synthetase [Methyloversatilis sp.] diamond 165 100 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Sterolibacteriaceae Methyloversatilis Methyloversatilis sp.
31643491 31643491 PRJNA900999_S_NODE_5916_length_184_cov_1.935484_g5860_i0 PRJNA900999 5916 184 1.935484 3.56129056 Pseudomonadota 1224 Bacteria Bacteria 78.2 1.48e-15   NR WP_017671697.1 1248760 g5860 i0 62.3 1.67934782608696 53 20 86.4 0 22 180 206 258 WP_017671697.1 3-hydroxybutyrate dehydrogenase [Blastomonas sp. AAP53] diamond 309 78.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Blastomonas Blastomonas sp. AAP53
31667594 31667594 PRJNA900999_S_NODE_3577_length_223_cov_2.649485_g3521_i0 PRJNA900999 3577 223 2.649485 5.90835155 Vulcaniibacterium thermophilum 1169913 Bacteria Bacteria 150 4.78e-41   NR WP_146472220.1 1169913 g3521 i0 100 0.982062780269058 73 0 98.2 0 221 3 407 479 WP_146472220.1 thymidine phosphorylase family protein [Vulcaniibacterium thermophilum] diamond 219 150 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Vulcaniibacterium Vulcaniibacterium thermophilum
32522217 32522217 PRJNA900999_S_NODE_5719_length_186_cov_3.267516_g5663_i0 PRJNA900999 5719 186 3.267516 6.07757976 Vulcaniibacterium thermophilum 1169913 Bacteria Bacteria 118 8.439999999999999e-31   NR WP_146474948.1 1169913 g5663 i0 100 0.983870967741935 61 0 98.4 0 184 2 76 136 WP_146474948.1 flagellar motor protein MotD [Vulcaniibacterium thermophilum] diamond 183 118 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Vulcaniibacterium Vulcaniibacterium thermophilum
32553866 32553866 PRJNA900999_S_NODE_8779_length_157_cov_2.179688_g8723_i0 PRJNA900999 8779 157 2.179688 3.42211016 Vulcaniibacterium thermophilum 1169913 Bacteria Bacteria 107 2.75e-28   NR WP_146474233.1 1169913 g8723 i0 98 0.974522292993631 51 1 97.5 0 155 3 61 111 WP_146474233.1 type II secretion system protein XpsH [Vulcaniibacterium thermophilum] diamond 153 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Vulcaniibacterium Vulcaniibacterium thermophilum

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