RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA635397", 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 · 8 ✖

tax_kingdom 1

  • Pseudomonadati · 8 ✖

bioproject 1

  • PRJNA635397 · 8 ✖

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
4433607 4433607 PRJNA635397_P_NODE_37724_length_257_cov_1.521739_g37270_i0 PRJNA635397 37724 257 1.521739 3.91086923 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 54.7 0.006   NTclustered gi|2874253693|emb|OY969419.1| 194844 g37270 i0 100 0.22568093385214 29 0 11 0 154 182 2693436 2693464 MAG: uncultured Acidobacteriaceae bacterium isolate MFD03346.bin.1.13 genome assembly, chromosome: 1 blastn 58 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
26891353 26891353 PRJNA635397_P_NODE_32941_length_276_cov_1.911330_g32487_i0 PRJNA635397 32941 276 1.91133 5.2752708 Terriglobia bacterium 2081523 Bacteria Bacteria 43.1 0.0422   NR MBZ5647546.1 2081523 g32487 i0 36.1 0.66304347826087 61 35 66.3 2 13 195 22 78 MBZ5647546.1 protein kinase [Terriglobia bacterium] diamond 183 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
27302316 27302316 PRJNA635397_P_NODE_36403_length_262_cov_1.566138_g35949_i0 PRJNA635397 36403 262 1.566138 4.10328156 Acidobacteriota bacterium 1978231 Bacteria Bacteria 83.2 2.54e-16   NR MBX3265733.1 1978231 g35949 i0 44 0.961832061068702 84 43 92.7 3 8 250 149 231 MBX3265733.1 hypothetical protein [Acidobacteriota bacterium] diamond 252 83.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27618164 27618164 PRJNA635397_P_NODE_16164_length_410_cov_1.661721_g15710_i0 PRJNA635397 16164 410 1.661721 6.8130561 Granulicella aggregans 474949 Bacteria Bacteria 44.3 0.0453   NR WP_184222884.1 474949 g15710 i0 34.2 0.578048780487805 79 50 57.1 2 140 373 144 221 WP_184222884.1 glycosyltransferase [Granulicella aggregans] diamond 237 44.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella aggregans
28546451 28546451 PRJNA635397_P_NODE_48327_length_212_cov_5.093525_g47873_i0 PRJNA635397 48327 212 5.093525 10.798273 Pseudomonadati 3379134 Bacteria Bacteria 75.9 5.3e-14   NR MBS1768271.1 1978231 g47873 i0 52.2 1.95283018867925 69 33 97.6 0 210 4 1141 1209 MBS1768271.1 hypothetical protein [Acidobacteriota bacterium] diamond 414 76.6 0.990861618798956 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29512319 29512319 PRJNA635397_P_NODE_42070_length_248_cov_0.891429_g41616_i0 PRJNA635397 42070 248 0.891429 2.21074392 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 140 3.98e-37   NR MFP5286361.1 2651171 g41616 i0 78 0.991935483870968 82 18 99.2 0 1 246 86 167 MFP5286361.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 246 140 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
31661049 31661049 PRJNA635397_P_NODE_40637_length_250_cov_0.881356_g40183_i0 PRJNA635397 40637 250 0.881356 2.20339 Acidobacteriota bacterium 1978231 Bacteria Bacteria 130 1.18e-34   NR MBM3762192.1 1978231 g40183 i0 79.5 0.996 83 17 99.6 0 250 2 190 272 MBM3762192.1 iron-containing alcohol dehydrogenase [Acidobacteriota bacterium] diamond 249 130 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31882507 31882507 PRJNA635397_P_NODE_38257_length_255_cov_1.659341_g37803_i0 PRJNA635397 38257 255 1.659341 4.23131955 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 64.7 8.15e-10   NR HRH44546.1 2283092 g37803 i0 39.1 1.69411764705882 87 47 95.3 1 246 4 9 95 HRH44546.1 VIT domain-containing protein [Pyrinomonadaceae bacterium] diamond 432 64.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae 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);;