RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA572587", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 22 ✖

tax_kingdom 1

  • Pseudomonadati · 22 ✖

bioproject 1

  • PRJNA572587 · 22 ✖

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
3109813 3109813 PRJNA572587_P_NODE_27263_length_214_cov_1.987879_g26935_i0 PRJNA572587 27263 214 1.987879 4.25406106 Bacteria 2 Bacteria Bacteria 99.4 1.27e-22   NR PYR33842.1 1978231 g26935 i0 76.3 3.29439252336449 59 14 82.7 0 38 214 178 236 PYR33842.1 MAG: amino acid dehydrogenase [Acidobacteriota bacterium] diamond 705 100 0.994 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
6936972 6936972 PRJNA572587_P_NODE_25746_length_221_cov_1.186047_g25418_i0 PRJNA572587 25746 221 1.186047 2.62116387 uncultured Bryobacterales bacterium 2569091 Bacteria Bacteria 119 1.9e-22   NTclustered gi|2546137838|emb|OY282420.1| 2569091 g25418 i0 93.75 4.27601809954751 80 4 36 1 1 79 3758852 3758773 MAG: uncultured Bryobacterales bacterium isolate 78526416-339a-45b8-a6d3-8fabb82c2801 genome assembly, chromosome: 1 blastn 945 119 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     uncultured Bryobacterales bacterium
8788962 8788962 PRJNA572587_P_NODE_9507_length_387_cov_49.568047_g9180_i0 PRJNA572587 9507 387 49.568047 191.82834189 Bacteria 2 Bacteria Bacteria 81.3 3.64e-15   NR WP_263382578.1 940613 g9180 i0 63.3 2.44961240310078 60 22 46.5 0 331 152 6 65 WP_263382578.1 DNA topoisomerase IB [Granulicella arctica] diamond 948 82 0.991463414634146 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella arctica
12614884 12614884 PRJNA572587_P_NODE_11090_length_353_cov_11.578947_g10763_i0 PRJNA572587 11090 353 11.578947 40.87368291 Terriglobia bacterium 2081523 Bacteria Bacteria 90.9 1.96e-20   NR HET9129972.1 2081523 g10763 i0 51.2 2.88951841359773 82 40 69.7 0 249 4 13 94 HET9129972.1 hypothetical protein [Terriglobia bacterium] diamond 1020 90.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
18410613 18410613 PRJNA572587_P_NODE_15095_length_296_cov_33.481781_g14767_i0 PRJNA572587 15095 296 33.481781 99.10607176 Acidobacteriota bacterium 1978231 Bacteria Bacteria 141 5.7e-29   NTclustered gi|1958085512|gb|CP065000.1| 1978231 g14767 i0 83.648 0.631756756756757 159 16 52 8 61 213 3097227 3097073 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome blastn 187 141 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
23511302 23511302 PRJNA572587_P_NODE_2899_length_770_cov_12.783634_g2651_i0 PRJNA572587 2899 770 12.783634 98.4339818 Pyrinomonas methylaliphatogenes 454194 Bacteria Bacteria 358 1.7599999999999996e-118   NR WP_041974984.1 454194 g2651 i0 91.2 0.755844155844156 194 17 75.6 0 101 682 1 194 WP_041974984.1 L-glutamate gamma-semialdehyde dehydrogenase [Pyrinomonas methylaliphatogenes] diamond 582 358 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae Pyrinomonas Pyrinomonas methylaliphatogenes
24785310 24785310 PRJNA572587_P_NODE_46680_length_161_cov_4.517857_g46352_i0 PRJNA572587 46680 161 4.517857 7.27374977 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 257 2.64e-64   NTclustered gi|217038899|gb|EU810989.1| 171953 g46352 i0 97.351 227.111801242236 151 4 94 0 2 152 331 181 Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence blastn 36565 257 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
26730926 26730926 PRJNA572587_P_NODE_11541_length_345_cov_9.587838_g11214_i0 PRJNA572587 11541 345 9.587838 33.0780411 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 45.8 0.00292   NR MEJ7848371.1 2283092 g11214 i0 47.2 0.31304347826087 36 18 30.4 1 23 127 84 119 MEJ7848371.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 108 45.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27174111 27174111 PRJNA572587_P_NODE_43002_length_167_cov_0.864407_g42674_i0 PRJNA572587 43002 167 0.864407 1.44355969 Acidobacteriota bacterium 1978231 Bacteria Bacteria 90.1 8.73e-20   NR MDQ6786376.1 1978231 g42674 i0 87.2 0.844311377245509 47 6 84.4 0 1 141 283 329 MDQ6786376.1 galactose-1-phosphate uridylyltransferase [Acidobacteriota bacterium] diamond 141 90.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27711782 27711782 PRJNA572587_P_NODE_8864_length_404_cov_42.461972_g8537_i0 PRJNA572587 8864 404 42.461972 171.54636688 Candidatus Acidiferrales bacterium 2952895 Bacteria Bacteria 67.8 1.15e-10   NR HKZ53809.1 2952895 g8537 i0 38.7 1.64108910891089 106 63 77.2 1 390 79 123 228 HKZ53809.1 hypothetical protein [Candidatus Acidiferrales bacterium] diamond 663 67.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales     Candidatus Acidiferrales bacterium
28058576 28058576 PRJNA572587_P_NODE_1965_length_918_cov_40.698504_g1787_i0 PRJNA572587 1965 918 40.698504 373.61226672 Pyrinomonas methylaliphatogenes 454194 Bacteria Bacteria 168 1.2199999999999999e-42   NR WP_041975184.1 454194 g1787 i0 78.2 0.330065359477124 101 22 33 0 305 3 1817 1917 WP_041975184.1 S8 family serine peptidase [Pyrinomonas methylaliphatogenes] diamond 303 168 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae Pyrinomonas Pyrinomonas methylaliphatogenes
28658704 28658704 PRJNA572587_P_NODE_3047_length_751_cov_12.203704_g2790_i0 PRJNA572587 3047 751 12.203704 91.64981704 Pyrinomonas methylaliphatogenes 454194 Bacteria Bacteria 252 9.05e-79   NR WP_235789178.1 454194 g2790 i0 82.3 0.563249001331558 141 25 56.3 0 13 435 2 142 WP_235789178.1 RHS repeat protein [Pyrinomonas methylaliphatogenes] diamond 423 252 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae Pyrinomonas Pyrinomonas methylaliphatogenes
30016413 30016413 PRJNA572587_P_NODE_15351_length_294_cov_1.297959_g15023_i0 PRJNA572587 15351 294 1.297959 3.81599946 Pyrinomonas sp. 2080306 Bacteria Bacteria 166 4.2399999999999995e-45   NR WP_352432760.1 2080306 g15023 i0 83.7 1 98 16 100 0 294 1 57 154 WP_352432760.1 TonB-dependent receptor [Pyrinomonas sp.] diamond 294 166 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae Pyrinomonas Pyrinomonas sp.
30016425 30016425 PRJNA572587_P_NODE_39411_length_174_cov_11.592000_g39083_i0 PRJNA572587 39411 174 11.592 20.17008 Thermoanaerobaculum sp. 2510637 Bacteria Bacteria 50.1 1.2e-5   NR BCW94076.1 2510637 g39083 i0 53.8 0.672413793103448 39 18 67.2 0 130 14 106 144 BCW94076.1 MAG: hypothetical protein KatS3mg007_1970 [Thermoanaerobaculum sp.] diamond 117 50.1 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales Thermoanaerobaculaceae Thermoanaerobaculum Thermoanaerobaculum sp.
30174236 30174236 PRJNA572587_P_NODE_5552_length_532_cov_213.501035_g5232_i0 PRJNA572587 5552 532 213.501035 1135.8255062 Acidobacteriota bacterium 1978231 Bacteria Bacteria 222 1.88e-69   NR MEO8257194.1 1978231 g5232 i0 66.7 0.879699248120301 156 52 88 0 46 513 12 167 MEO8257194.1 glycosyltransferase family 2 protein [Acidobacteriota bacterium] diamond 468 222 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30251314 30251314 PRJNA572587_P_NODE_3412_length_708_cov_9.567527_g3137_i0 PRJNA572587 3412 708 9.567527 67.73809116 Acidobacteriota 57723 Bacteria Bacteria 356 1.3499999999999993e-119   NR MBW8865923.1 1978231 g3137 i0 85.3 16.6779661016949 197 29 83.5 0 12 602 81 277 MBW8865923.1 radical SAM protein [Acidobacteriota bacterium] diamond 11808 359 0.991643454038997 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30774766 30774766 PRJNA572587_P_NODE_21914_length_241_cov_13.718750_g21586_i0 PRJNA572587 21914 241 13.71875 33.0621875 Acidobacteriota bacterium 1978231 Bacteria Bacteria 119 5.710000000000001e-29   NR MDE3155071.1 1978231 g21586 i0 75.3 4.54356846473029 73 18 90.9 0 220 2 667 739 MDE3155071.1 diguanylate cyclase [Acidobacteriota bacterium] diamond 1095 119 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31533469 31533469 PRJNA572587_P_NODE_24036_length_229_cov_29.388889_g23708_i0 PRJNA572587 24036 229 29.388889 67.30055581 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 106 5.03e-28   NR HLM02227.1 2283092 g23708 i0 81.5 2.62008733624454 65 12 85.2 0 25 219 1 65 HLM02227.1 heavy metal-binding domain-containing protein [Pyrinomonadaceae bacterium] diamond 600 106 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32464466 32464466 PRJNA572587_P_NODE_30499_length_201_cov_3.026316_g30171_i0 PRJNA572587 30499 201 3.026316 6.08289516 Bacteria 2 Bacteria Bacteria 86.7 3.47e-18   NR MDP2999235.1 2026791 g30171 i0 70.2 1.71641791044776 57 17 85.1 0 177 7 251 307 MDP2999235.1 zinc-dependent dehydrogenase [Bryobacterales bacterium] diamond 345 87 0.996551724137931 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
32514277 32514277 PRJNA572587_P_NODE_11059_length_354_cov_1.662295_g10732_i0 PRJNA572587 11059 354 1.662295 5.8845243 Acidobacteriota bacterium 1978231 Bacteria Bacteria 63.9 3.59e-9   NR MBM61939.1 1978231 g10732 i0 47.8 0.584745762711864 69 31 54.2 2 150 341 180 248 MBM61939.1 hypothetical protein [Acidobacteriota bacterium] diamond 207 63.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32703078 32703078 PRJNA572587_P_NODE_3880_length_660_cov_11.536825_g3589_i0 PRJNA572587 3880 660 11.536825 76.143045 Bryobacterales bacterium 2026791 Bacteria Bacteria 49.3 0.00555   NR MCC7175044.1 2026791 g3589 i0 33.9 0.75 165 95 70.5 4 491 27 101 261 MCC7175044.1 efflux RND transporter periplasmic adaptor subunit [Bryobacterales bacterium] diamond 495 49.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
32891979 32891979 PRJNA572587_P_NODE_8980_length_401_cov_28.170455_g8653_i0 PRJNA572587 8980 401 28.170455 112.96352455 Pyrinomonas methylaliphatogenes 454194 Bacteria Bacteria 212 1.7e-63   NR WP_041973910.1 454194 g8653 i0 90.5 0.942643391521197 126 12 94.3 0 398 21 334 459 WP_041973910.1 NADH-quinone oxidoreductase subunit N [Pyrinomonas methylaliphatogenes] diamond 378 212 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae Pyrinomonas Pyrinomonas methylaliphatogenes

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