RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA330616" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA330616 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27327553 27327553 PRJNA330616_P_NODE_29603_length_163_cov_1.342105_g29194_i0 PRJNA330616 29603 163 1.342105 2.18763115 Nannocystis poenicansa 2995304 Bacteria Bacteria 48.9 7.8e-5   NR WP_269041940.1 2995304 g29194 i0 46.3 0.993865030674847 54 29 99.4 0 2 163 31 84 WP_269041940.1 aKG-HExxH-type peptide beta-hydroxylase [Nannocystis poenicansa] diamond 162 48.9 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis punicea
27390857 27390857 PRJNA330616_P_NODE_26683_length_166_cov_0.871795_g26274_i0 PRJNA330616 26683 166 0.871795 1.4471797 Kofleriaceae bacterium 2212474 Bacteria Bacteria 51.6 9.93e-6   NR HEU4733172.1 2212474 g26274 i0 55.3 3.39759036144578 47 21 84.9 0 4 144 466 512 HEU4733172.1 Ig-like domain-containing protein [Kofleriaceae bacterium] diamond 564 51.6 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
27390861 27390861 PRJNA330616_P_NODE_29083_length_164_cov_0.886957_g28674_i0 PRJNA330616 29083 164 0.886957 1.45460948 Myxococcus sp. AM 1929279 Bacteria Bacteria 70.5 2.09e-12   NR WP_176434832.1 2745200 g28674 i0 60 4.92073170731707 55 19 97 2 161 3 196 249 WP_176434832.1 EGF domain-containing protein [Myxococcus sp. AM011] diamond 807 70.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus sp. AM011
28527565 28527565 PRJNA330616_P_NODE_32207_length_161_cov_0.910714_g31798_i0 PRJNA330616 32207 161 0.910714 1.46624954 Myxococcales bacterium 2026763 Bacteria Bacteria 65.1 1.57e-10   NR MSP63362.1 2026763 g31798 i0 60.4 0.894409937888199 48 19 89.4 0 17 160 265 312 MSP63362.1 VCBS repeat-containing protein [Myxococcales bacterium] diamond 144 65.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
28734152 28734152 PRJNA330616_P_NODE_28167_length_165_cov_0.879310_g27758_i0 PRJNA330616 28167 165 0.87931 1.4508615 Pseudomonadati 3379134 Bacteria Bacteria 85.5 2.95e-19   NR MSP25315.1 2026763 g27758 i0 91.5 5.21818181818182 47 4 85.5 0 146 6 1 47 MSP25315.1 type VI secretion system contractile sheath small subunit [Myxococcales bacterium] diamond 861 85.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31654691 31654691 PRJNA330616_P_NODE_27637_length_165_cov_0.879310_g27228_i0 PRJNA330616 27637 165 0.87931 1.4508615 Myxococcales bacterium 2026763 Bacteria Bacteria 78.6 1.02e-15   NR MBL8605552.1 2026763 g27228 i0 72.2 0.981818181818182 54 15 98.2 0 163 2 49 102 MBL8605552.1 hypothetical protein [Myxococcales bacterium] diamond 162 78.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales 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);;