RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA661142", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJNA661142 · 6 ✖

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
18480473 18480473 PRJNA661142_P_NODE_12035_length_164_cov_0.886957_g11970_i0 PRJNA661142 12035 164 0.886957 1.45460948 Spirochaetia bacterium 2053615 Bacteria Bacteria 82 1.74e-16   NR HUV06963.1 2053615 g11970 i0 76.1 0.841463414634146 46 11 84.1 0 164 27 454 499 HUV06963.1 Ni/Fe hydrogenase subunit alpha [Spirochaetia bacterium] diamond 138 82 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28881366 28881366 PRJNA661142_P_NODE_8928_length_243_cov_2.907216_g8863_i0 PRJNA661142 8928 243 2.907216 7.06453488 Spirochaetia bacterium 2053615 Bacteria Bacteria 134 4.95e-39   NR MFO7729640.1 2053615 g8863 i0 100 0.790123456790123 64 0 79 0 3 194 38 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 192 134 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29733688 29733688 PRJNA661142_P_NODE_12770_length_161_cov_0.910714_g12705_i0 PRJNA661142 12770 161 0.910714 1.46624954 Spirochaetota bacterium 2202144 Bacteria Bacteria 82 8.69e-17   NR MEI6386405.1 2202144 g12705 i0 86.3 2.8695652173913 51 7 95 0 153 1 17 67 MEI6386405.1 ABC transporter permease [Spirochaetota bacterium] diamond 462 82 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32516142 32516142 PRJNA661142_P_NODE_11479_length_167_cov_0.864407_g11414_i0 PRJNA661142 11479 167 0.864407 1.44355969 Spirochaetota bacterium 2202144 Bacteria Bacteria 42 0.0254   NR MCX7039408.1 2202144 g11414 i0 40.4 2.60479041916168 47 28 84.4 0 167 27 416 462 MCX7039408.1 ABC transporter permease [Spirochaetota bacterium] diamond 435 42 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32547792 32547792 PRJNA661142_P_NODE_12659_length_161_cov_0.910714_g12594_i0 PRJNA661142 12659 161 0.910714 1.46624954 Leptospira brenneri 2023182 Bacteria Bacteria 49.7 3.73e-5   NR WP_100792488.1 2023182 g12594 i0 41.5 0.987577639751553 53 31 98.8 0 159 1 64 116 WP_100792488.1 GNAT family N-acetyltransferase [Leptospira brenneri] diamond 159 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira brenneri
32610584 32610584 PRJNA661142_P_NODE_11720_length_166_cov_0.871795_g11655_i0 PRJNA661142 11720 166 0.871795 1.4471797 Treponema sp. GWA1_62_8 1802378 Bacteria Bacteria 95.5 1.57e-21   NR OHE62948.1 1802378 g11655 i0 78.2 1.98795180722892 55 12 99.4 0 1 165 130 184 OHE62948.1 MAG: hypothetical protein A2Y36_07130 [Treponema sp. GWA1_62_8] diamond 330 95.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. GWA1_62_8

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