RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA390533" and tax_phylum = "Candidatus Sysuimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Sysuimicrobiota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA390533 · 3 ✖

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
26854008 26854008 PRJNA390533_P_NODE_36401_length_199_cov_1.587500_g35374_i0 PRJNA390533 36401 199 1.5875 3.159125 Candidatus Sysuimicrobiota bacterium CSP1-3 1640515 Bacteria Bacteria 53.1 6.07e-7   NR KRT76663.1 1640515 g35374 i0 67.6 2.77386934673367 37 12 55.8 0 113 3 1 37 KRT76663.1 MAG: putative ArsR family transcriptional regulator [Candidatus Sysuimicrobiota bacterium CSP1-3] diamond 552 53.1 1 Bacteria   Bacillati Candidatus Sysuimicrobiota         Candidatus Sysuimicrobiota bacterium CSP1-3
27770447 27770447 PRJNA390533_P_NODE_28184_length_275_cov_1.305085_g27157_i0 PRJNA390533 28184 275 1.305085 3.58898375 Candidatus Fervidifonticultor septimus 3378018 Bacteria Bacteria 52.4 1.96e-5   NR MDR7550337.1 3378018 g27157 i0 53.2 0.512727272727273 47 22 51.3 0 274 134 255 301 MDR7550337.1 trypsin-like peptidase domain-containing protein [Candidatus Fervidifonticultor septimus] diamond 141 52.4 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Humicultoraceae Candidatus Fervidifonticultor Candidatus Fervidifonticultor septimus
31275913 31275913 PRJNA390533_P_NODE_40935_length_177_cov_0.862319_g39908_i0 PRJNA390533 40935 177 0.862319 1.52630463 Candidatus Thermofontivivens primus 3378000 Bacteria Bacteria 54.3 1.26e-6   NR MDR5693737.1 3378000 g39908 i0 41.8 0.932203389830508 55 32 93.2 0 12 176 597 651 MDR5693737.1 ATP-binding protein [Candidatus Thermofontivivens primus] diamond 165 54.3 1 Bacteria   Bacillati Candidatus Sysuimicrobiota Candidatus Sysuimicrobiia Candidatus Sysuimicrobiales Candidatus Thermofontiviventaceae Candidatus Thermofontivivens Candidatus Thermofontivivens primus

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