RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJDB12134" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJDB12134 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
14028082 14028082 PRJDB12134_P_NODE_13952_length_244_cov_0.912281_g13817_i0 PRJDB12134 13952 244 0.912281 2.22596564 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 58.4 4.73e-4   NTclustered gi|2874254049|emb|OY970373.1| 171953 g13817 i0 100 1.86475409836066 31 0 15 0 25 55 2469284 2469254 MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1 blastn 455 58.4 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
15302162 15302162 PRJDB12134_P_NODE_13473_length_247_cov_0.890805_g13338_i0 PRJDB12134 13473 247 0.890805 2.20028835 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 257 4.41e-64   NTclustered gi|2874253760|emb|OY969701.1| 2283092 g13338 i0 86.134 29.3198380566802 238 33 96 0 10 247 2559665 2559902 MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1 blastn 7242 257 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
24225844 24225844 PRJDB12134_P_NODE_10600_length_280_cov_1.256039_g10465_i0 PRJDB12134 10600 280 1.256039 3.5169092 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 505 1.65e-138   NTclustered gi|112980873|gb|DQ829677.1| 171953 g10465 i0 99.286 370.785714285714 280 1 100 1 1 280 1174 1452 Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence blastn 103820 505 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota 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);;