RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA846110" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA846110 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
29052800 29052800 PRJNA846110_P_NODE_24908_length_248_cov_0.880000_g24663_i0 PRJNA846110 24908 248 0.88 2.1824 Candidatus Similichlamydia 1348235 Bacteria Bacteria 152 1.95e-45   NR WP_275655994.1 1903953 g24663 i0 90.1 1.95967741935484 81 8 98 0 248 6 10 90 WP_275655994.1 Clp protease N-terminal domain-containing protein, partial [Candidatus Similichlamydia epinepheli] diamond 486 152 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Parilichlamydiaceae Candidatus Similichlamydia Candidatus Similichlamydia epinepheli
31706674 31706674 PRJNA846110_P_NODE_28877_length_243_cov_0.905882_g28632_i0 PRJNA846110 28877 243 0.905882 2.20129326 Parachlamydiales 1963360 Bacteria Bacteria 55.5 1.21e-6   NR WP_108623814.1 1903953 g28632 i0 39.2 3.5679012345679 74 40 85.2 1 35 241 3 76 WP_108623814.1 tetratricopeptide repeat protein [Candidatus Similichlamydia epinepheli] diamond 867 55.8 0.99462365591397806 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Parilichlamydiaceae Candidatus Similichlamydia Candidatus Similichlamydia epinepheli
32173011 32173011 PRJNA846110_P_NODE_18298_length_271_cov_2.691919_g18053_i0 PRJNA846110 18298 271 2.691919 7.29510049 Parachlamydiaceae bacterium 2052176 Bacteria Bacteria 103 5.31e-25   NR MFN4174080.1 2052176 g18053 i0 69.4 0.686346863468635 62 19 68.6 0 188 3 1 62 MFN4174080.1 carotenoid oxygenase family protein [Parachlamydiaceae bacterium] diamond 186 103 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   Parachlamydiaceae 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);;