RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA657343", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 4 ✖

tax_kingdom 1

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA657343 · 4 ✖

analysis 1

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
31420794 31420794 PRJNA657343_P_NODE_17036_length_220_cov_1.719298_g17012_i0 PRJNA657343 17036 220 1.719298 3.7824556 Bacteria 2 Bacteria Bacteria 108 3.03e-26   NR MBI3923195.1 2033014 g17012 i0 69 7.66363636363636 71 22 96.8 0 217 5 248 318 MBI3923195.1 D-glycerate dehydrogenase [Armatimonadota bacterium] diamond 1686 108 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31535290 31535290 PRJNA657343_P_NODE_41376_length_164_cov_0.904348_g41352_i0 PRJNA657343 41376 164 0.904348 1.48313072 Armatimonadota bacterium 2033014 Bacteria Bacteria 71.2 1.02e-12   NR NPV47963.1 2033014 g41352 i0 63.3 1.79268292682927 49 18 89.6 0 160 14 173 221 NPV47963.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Armatimonadota bacterium] diamond 294 71.2 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32496596 32496596 PRJNA657343_P_NODE_27039_length_186_cov_1.437956_g27015_i0 PRJNA657343 27039 186 1.437956 2.67459816 root 1 Root_unresolved Root_unresolved 45.1 0.00268   NR MBS1714437.1 2033014 g27015 i0 50 2.40322580645161 50 24 79 1 1 147 280 329 MBS1714437.1 thioredoxin family protein [Armatimonadota bacterium] diamond 447 45.1 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32799264 32799264 PRJNA657343_P_NODE_30600_length_177_cov_4.632812_g30576_i0 PRJNA657343 30600 177 4.632812 8.20007724 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 51.2 1.62e-5   NR MFN8220026.1 2682145 g30576 i0 50 1.88135593220339 58 28 96.6 1 174 4 852 909 MFN8220026.1 tandem-95 repeat protein [Fimbriimonadales bacterium] diamond 333 51.2 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales 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);;