RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Methylomirabilota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Methylomirabilota · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA168635 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_kingdom 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
14393784 14393784 PRJNA168635_P_NODE_35212_length_152_cov_3.097087_g34796_i0 PRJNA168635 35212 152 3.097087 4.70757224 uncultured Methylomirabilota bacterium 991135 Bacteria Bacteria 91.6 2.63e-14   NTclustered gi|2874253892|emb|OY970067.1| 991135 g34796 i0 98.077 0.611842105263158 52 1 34 0 1 52 4745700 4745649 MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1 blastn 93 91.6 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         uncultured Methylomirabilota bacterium
18216036 18216036 PRJNA168635_P_NODE_13655_length_219_cov_2.811765_g13239_i0 PRJNA168635 13655 219 2.811765 6.15776535 Candidatus Methylomirabilis oxygeniifera 671143 Bacteria Bacteria 193 1.09e-44   NTclustered gi|507148395|ref|NR_103198.1| 671143 g13239 i0 83.645 243.986301369863 214 25 95 9 1 209 2095 2303 Candidatus Methylomirabilis oxyfera 23S ribosomal RNA gene, complete sequence blastn 53433 193 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota Candidatus Methylomirabilia Candidatus Methylomirabilales Candidatus Methylomirabilaceae Candidatus Methylomirabilis Candidatus Methylomirabilis oxygeniifera
19490273 19490273 PRJNA168635_P_NODE_13676_length_219_cov_1.700000_g13260_i0 PRJNA168635 13676 219 1.7 3.723 Candidatus Methylomirabilis oxygeniifera 671143 Bacteria Bacteria 78.7 3.2e-10   NTclustered gi|258590833|emb|FP565575.1| 671143 g13260 i0 95.833 1.00456621004566 48 2 22 0 171 218 196227 196274 Candidatus Methylomirabilis oxyfera complete genome blastn 220 78.7 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota Candidatus Methylomirabilia Candidatus Methylomirabilales Candidatus Methylomirabilaceae Candidatus Methylomirabilis Candidatus Methylomirabilis oxygeniifera

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