RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA906294" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA906294 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
886741 886741 PRJNA906294_P_NODE_162001_length_296_cov_1.022422_g157885_i0 PRJNA906294 162001 296 1.022422 3.02636912 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 497 2.9399999999999994e-136   NTclustered gi|217038899|gb|EU810989.1| 171953 g157885 i0 96.959 100.908783783784 296 9 100 0 1 296 6 301 Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence blastn 29869 497 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
4714683 4714683 PRJNA906294_P_NODE_138744_length_328_cov_2.556863_g134628_i0 PRJNA906294 138744 328 2.556863 8.38651064 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 536 6.989999999999999e-148   NTclustered gi|2874254027|emb|OY970352.1| 171953 g134628 i0 96.594 134.658536585366 323 11 98 0 6 328 2367321 2367643 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 44168 536 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
7626531 7626531 PRJNA906294_P_NODE_180546_length_275_cov_1.118812_g176430_i0 PRJNA906294 180546 275 1.118812 3.076733 Terriglobia 204432 Bacteria Bacteria 448 2.7599999999999995e-121   NTclustered gi|2874253796|emb|OY969780.1| 194844 g176430 i0 96 106.370909090909 275 11 100 0 1 275 286240 286514 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 blastn 29252 448 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
13640576 13640576 PRJNA906294_P_NODE_169251_length_287_cov_1.420561_g165135_i0 PRJNA906294 169251 287 1.420561 4.07701007 Occallatibacter riparius 1002689 Bacteria Bacteria 54.7 0.007   NTclustered gi|2304899767|gb|CP093313.1| 1002689 g165135 i0 96.875 0.111498257839721 32 1 11 0 175 206 2710150 2710181 Occallatibacter riparius strain DSM 25168 chromosome, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Occallatibacter Occallatibacter riparius

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