RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1013345" 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

  • PRJNA1013345 · 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
18010144 18010144 PRJNA1013345_P_NODE_24175_length_164_cov_1.461538_g24045_i0 PRJNA1013345 24175 164 1.461538 2.39692232 Luteitalea pratensis 1855912 Bacteria Bacteria 220 3.55e-53   NTclustered gi|1016914409|gb|CP015136.1| 1855912 g24045 i0 91.304 0.981707317073171 161 14 98 0 2 162 536002 536162 Luteitalea pratensis strain DSM 100886 chromosome, complete genome blastn 161 220 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea pratensis
20559448 20559448 PRJNA1013345_P_NODE_21437_length_168_cov_2.223140_g21307_i0 PRJNA1013345 21437 168 2.22314 3.7348752 Occallatibacter riparius 1002689 Bacteria Bacteria 99 1.79e-16   NTclustered gi|2304899767|gb|CP093313.1| 1002689 g21307 i0 95.161 0.982142857142857 62 3 37 0 46 107 3955851 3955790 Occallatibacter riparius strain DSM 25168 chromosome, complete genome blastn 165 99 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Occallatibacter Occallatibacter riparius
20559517 20559517 PRJNA1013345_P_NODE_25137_length_163_cov_1.706897_g25007_i0 PRJNA1013345 25137 163 1.706897 2.78224211 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 213 5.89e-51   NTclustered gi|2874254091|emb|OY970174.1| 171953 g25007 i0 90.244 17.8036809815951 164 14 100 2 1 163 3498764 3498926 MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 blastn 2902 213 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);;