RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB12366" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB12366 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
2570676 2570676 PRJEB12366_P_NODE_5303_length_359_cov_3.030864_g5113_i0 PRJEB12366 5303 359 3.030864 10.88080176 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 580 3.51e-161   NTclustered gi|76574295|gb|DQ139443.1| 171953 g5113 i0 96.1 103.701949860724 359 9 100 3 1 359 558 911 Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence blastn 37229 580 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
3846987 3846987 PRJEB12366_P_NODE_2044_length_604_cov_4.483304_g1878_i0 PRJEB12366 2044 604 4.483304 27.07915616 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 713 0   NTclustered gi|2874253796|emb|OY969780.1| 194844 g1878 i0 88.648 102.024834437086 599 50 99 8 1 597 284687 285269 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 blastn 61623 713 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
5123152 5123152 PRJEB12366_P_NODE_2665_length_529_cov_10.265182_g2482_i0 PRJEB12366 2665 529 10.265182 54.302812779999996 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 880 0   NTclustered gi|2874254057|emb|OY970381.1| 194844 g2482 i0 96.774 112.192816635161 527 17 99 0 3 529 1656846 1657372 MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1 blastn 59350 880 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
8947738 8947738 PRJEB12366_P_NODE_16868_length_170_cov_1.177778_g16678_i0 PRJEB12366 16868 170 1.177778 2.0022226 Acidobacteriota bacterium 1978231 Bacteria Bacteria 128 2.3e-25   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g16678 i0 86.325 0.688235294117647 117 16 69 0 46 162 2893550 2893434 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 117 128 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
11498767 11498767 PRJEB12366_P_NODE_13510_length_196_cov_2.291925_g13320_i0 PRJEB12366 13510 196 2.291925 4.492173 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 289 1.1899999999999998e-73   NTclustered gi|2874253796|emb|OY969780.1| 194844 g13320 i0 93.367 172.040816326531 196 12 100 1 1 196 285332 285526 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 blastn 33720 289 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
19146256 19146256 PRJEB12366_P_NODE_16496_length_173_cov_1.050725_g16306_i0 PRJEB12366 16496 173 1.050725 1.81775425 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 276 7.92e-70   NTclustered gi|2874253796|emb|OY969780.1| 194844 g16306 i0 95.376 225.167630057803 173 8 100 0 1 173 286583 286411 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 blastn 38954 276 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
25211728 25211728 PRJEB12366_P_NODE_740_length_996_cov_8.192508_g636_i0 PRJEB12366 740 996 8.192508 81.59737968 Acidobacteriaceae 204434 Bacteria Bacteria 1127 0   NTclustered gi|2874254057|emb|OY970381.1| 194844 g636 i0 96.889 90.6315261044177 675 18 68 1 1 675 1656835 1656164 MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1 blastn 90269 1136 0.992077464788732 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae 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);;