RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA453111" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 21 ✖

bioproject 1

  • PRJNA453111 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
441418 441418 PRJNA453111_P_NODE_12801_length_242_cov_0.911243_g12709_i0 PRJNA453111 12801 242 0.911243 2.20520806 Pseudomonadati 3379134 Bacteria Bacteria 137 2.03e-36   NR WP_407176481.1 578924 g12709 i0 75 32.7272727272727 80 20 99.2 0 242 3 276 355 WP_407176481.1 isocitrate lyase [Bradyrhizobium sp. STM 3562] diamond 7920 137 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. STM 3562
5545173 5545173 PRJNA453111_P_NODE_605_length_1046_cov_2.182939_g546_i0 PRJNA453111 605 1046 2.182939 22.83354194 Myxococcota bacterium 2818507 Bacteria Bacteria 286 6.49e-86   NR MDJ0869580.1 2818507 g546 i0 42.8 1.76099426386233 306 156 87.8 5 84 1001 511 797 MDJ0869580.1 BPTI/Kunitz-type proteinase inhibitor domain-containing protein [Myxococcota bacterium] diamond 1842 286 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
26600960 26600960 PRJNA453111_P_NODE_7761_length_290_cov_1.419355_g7669_i0 PRJNA453111 7761 290 1.419355 4.1161295 Polyangia bacterium 3058050 Bacteria Bacteria 44.7 0.0126   NR HSS37185.1 3058050 g7669 i0 38.8 1.75862068965517 85 49 85.9 2 1 249 99 182 HSS37185.1 adenylosuccinate lyase [Polyangia bacterium] diamond 510 44.7 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
26696137 26696137 PRJNA453111_P_NODE_6461_length_318_cov_1.877551_g6369_i0 PRJNA453111 6461 318 1.877551 5.97061218 Acidobacteriota bacterium 1978231 Bacteria Bacteria 121 2.3199999999999997e-30   NR MEM6703481.1 1978231 g6369 i0 54.3 5.90566037735849 105 48 99.1 0 3 317 20 124 MEM6703481.1 S9 family peptidase [Acidobacteriota bacterium] diamond 1878 121 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26791359 26791359 PRJNA453111_P_NODE_8841_length_271_cov_1.166667_g8749_i0 PRJNA453111 8841 271 1.166667 3.16166757 Nitrospira sp. 70125 Bacteria Bacteria 43.5 0.0144   NR MDR4473450.1 70125 g8749 i0 48.8 0.476014760147601 43 22 47.6 0 33 161 115 157 MDR4473450.1 hypothetical protein [Nitrospira sp.] diamond 129 43.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27138914 27138914 PRJNA453111_P_NODE_7942_length_287_cov_1.084112_g7850_i0 PRJNA453111 7942 287 1.084112 3.11140144 Variovorax sp. J22R133 3053503 Bacteria Bacteria 43.5 0.0328   NR WP_286562580.1 3053503 g7850 i0 42.9 0.585365853658537 56 30 57.5 2 265 101 277 331 WP_286562580.1 PglL family O-oligosaccharyltransferase [Variovorax sp. J22R133] diamond 168 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Variovorax Variovorax brevis
27834113 27834113 PRJNA453111_P_NODE_12464_length_243_cov_0.905882_g12372_i0 PRJNA453111 12464 243 0.905882 2.20129326 Betaproteobacteria bacterium 1891241 Bacteria Bacteria 44.7 0.00771   NR MSQ54280.1 1891241 g12372 i0 38.7 0.925925925925926 75 43 90.1 2 19 237 294 367 MSQ54280.1 MFS transporter [Betaproteobacteria bacterium] diamond 225 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria bacterium
28055094 28055094 PRJNA453111_P_NODE_5745_length_337_cov_1.659091_g5653_i0 PRJNA453111 5745 337 1.659091 5.59113667 Spiribacter pallidus 1987936 Bacteria Bacteria 44.7 0.0213   NR WP_367985223.1 1987936 g5653 i0 28.4 0.72106824925816 81 48 63.2 2 49 261 119 199 WP_367985223.1 CynX/NimT family MFS transporter [Spiribacter pallidus] diamond 243 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Ectothiorhodospiraceae Spiribacter Spiribacter pallidus
28086687 28086687 PRJNA453111_P_NODE_5285_length_351_cov_1.586331_g5193_i0 PRJNA453111 5285 351 1.586331 5.56802181 Chitinimonas sp. 1934313 Bacteria Bacteria 78.6 2.42e-14   NR WP_374349013.1 1934313 g5193 i0 35.1 0.974358974358974 114 74 97.4 0 1 342 65 178 WP_374349013.1 M35 family metallo-endopeptidase [Chitinimonas sp.] diamond 342 78.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Chitinimonas Chitinimonas sp.
28118268 28118268 PRJNA453111_P_NODE_4865_length_366_cov_1.784983_g4773_i0 PRJNA453111 4865 366 1.784983 6.53303778 Formosa undariae 1325436 Bacteria Bacteria 43.5 0.049   NR WP_382380540.1 1325436 g4773 i0 30.2 0.704918032786885 86 57 70.5 1 349 92 32 114 WP_382380540.1 RNA polymerase sigma factor [Formosa undariae] diamond 258 43.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Formosa Formosa undariae
28212843 28212843 PRJNA453111_P_NODE_9366_length_261_cov_1.303191_g9274_i0 PRJNA453111 9366 261 1.303191 3.40132851 Klebsiella pneumoniae 573 Bacteria Bacteria 42.4 0.00926   NR WP_416493070.1 573 g9274 i0 53.1 0.735632183908046 64 29 73.6 1 55 246 9 71 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 192 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28244486 28244486 PRJNA453111_P_NODE_3266_length_450_cov_2.408488_g3174_i0 PRJNA453111 3266 450 2.408488 10.838196 unclassified Corallococcus 2685029 Bacteria Bacteria 164 3.34e-46   NR WP_206797742.1 2685029 g3174 i0 53 3.96666666666667 149 67 98.7 2 448 5 200 346 WP_206797742.1 MULTISPECIES: M35 family metallo-endopeptidase [unclassified Corallococcus] diamond 1785 164 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus  
28307889 28307889 PRJNA453111_P_NODE_11166_length_247_cov_1.327586_g11074_i0 PRJNA453111 11166 247 1.327586 3.27913742 Archangium sp. 1872627 Bacteria Bacteria 59.3 5.37e-8   NR MDP1828757.1 1872627 g11074 i0 48.8 2.97570850202429 82 34 99.6 1 1 246 98 171 MDP1828757.1 LysM peptidoglycan-binding domain-containing protein [Archangium sp.] diamond 735 59.3 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
28686974 28686974 PRJNA453111_P_NODE_2627_length_507_cov_1.774194_g2535_i0 PRJNA453111 2627 507 1.774194 8.99516358 Bacteroides zhangwenhongii 2650157 Bacteria Bacteria 53.9 5.55e-5   NR WP_272720491.1 2650157 g2535 i0 55.6 0.21301775147929 36 16 21.3 0 503 396 12 47 WP_272720491.1 tetratricopeptide repeat protein, partial [Bacteroides zhangwenhongii] diamond 108 53.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Bacteroides Bacteroides zhangwenhongii
28812660 28812660 PRJNA453111_P_NODE_12328_length_244_cov_0.888889_g12236_i0 PRJNA453111 12328 244 0.888889 2.16888916 Nitrosomonas 914 Bacteria Bacteria 43.9 0.015   NR WP_011111877.1 914 g12236 i0 35 0.737704918032787 60 38 73.8 1 13 192 421 479 WP_011111877.1 MULTISPECIES: CHASE2 domain-containing protein [Nitrosomonas] diamond 180 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas  
30518432 30518432 PRJNA453111_P_NODE_8573_length_276_cov_1.201970_g8481_i0 PRJNA453111 8573 276 1.20197 3.3174372 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.1 0.0276   NR MEI6341235.1 2026799 g8481 i0 46 0.543478260869565 50 25 52.2 1 113 256 109 158 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 150 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31451296 31451296 PRJNA453111_P_NODE_12116_length_244_cov_0.900585_g12024_i0 PRJNA453111 12116 244 0.900585 2.1974274 Comamonadaceae 80864 Bacteria Bacteria 41.6 0.0289   NR WP_006298065.1 80880 g12024 i0 37.7 1.63524590163934 61 35 73.8 2 51 230 8 66 WP_006298065.1 hypothetical protein [Hylemonella gracilis] diamond 399 42 0.990476190476191 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Hylemonella Hylemonella gracilis
31483054 31483054 PRJNA453111_P_NODE_12396_length_243_cov_1.100000_g12304_i0 PRJNA453111 12396 243 1.1 2.673 root 1 Root_unresolved Root_unresolved 82.8 1.71e-18   NR WP_264767160.1 573 g12304 i0 87.5 1.97530864197531 40 5 49.4 0 120 1 41 80 WP_264767160.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 480 83.2 0.995192307692308 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32131075 32131075 PRJNA453111_P_NODE_13318_length_222_cov_6.724832_g13226_i0 PRJNA453111 13318 222 6.724832 14.92912704 Klebsiella pneumoniae 573 Bacteria Bacteria 114 1.19e-30   NR WP_416532323.1 573 g13226 i0 91.5 0.797297297297297 59 5 79.7 0 45 221 86 144 WP_416532323.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 177 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32510914 32510914 PRJNA453111_P_NODE_9719_length_254_cov_2.552486_g9627_i0 PRJNA453111 9719 254 2.552486 6.48331444 Methylocella sp. 1978226 Bacteria Bacteria 42 0.0203   NR HEY4846789.1 1978226 g9627 i0 32.4 0.803149606299213 68 45 80.3 1 1 204 4 70 HEY4846789.1 helix-turn-helix domain-containing protein [Methylocella sp.] diamond 204 42 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Beijerinckiaceae Methylocella Methylocella sp.
32699658 32699658 PRJNA453111_P_NODE_4880_length_366_cov_0.839590_g4788_i0 PRJNA453111 4880 366 0.83959 3.0728994 Comamonas sp. 34028 Bacteria Bacteria 42.7 0.0464   NR MBN9331280.1 34028 g4788 i0 38.2 0.450819672131148 55 32 43.4 2 205 363 32 86 MBN9331280.1 hypothetical protein [Comamonas sp.] diamond 165 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas sp.

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