RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA299585" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA299585 · 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
13129123 13129123 PRJNA299585_S_NODE_851_length_1132_cov_7.913871_g758_i0 PRJNA299585 851 1132 7.913871 89.58501972 Desulfobacterales bacterium 2044940 Bacteria Bacteria 192 1.9999999999999996e-57   NR MDO8943152.1 2044940 g758 i0 92.8 0.257067137809187 97 7 25.7 0 900 610 1 97 MDO8943152.1 hypothetical protein [Desulfobacterales bacterium] diamond 291 192 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
30200374 30200374 PRJNA299585_S_NODE_2712_length_573_cov_5.909926_g2507_i0 PRJNA299585 2712 573 5.909926 33.86387598 Desulfobacterales bacterium 2044940 Bacteria Bacteria 81.3 6.34e-16   NR MCK7512071.1 2044940 g2507 i0 74.5 0.287958115183246 55 14 28.8 0 327 163 58 112 MCK7512071.1 hypothetical protein [Desulfobacterales bacterium] diamond 165 81.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32477235 32477235 PRJNA299585_S_NODE_14939_length_157_cov_3.226562_g14709_i0 PRJNA299585 14939 157 3.226562 5.06570234 Desulfobacterales bacterium 2044940 Bacteria Bacteria 41.2 0.0409   NR MCF6289532.1 2044940 g14709 i0 61.5 0.496815286624204 26 10 49.7 0 147 70 145 170 MCF6289532.1 DUF4338 domain-containing protein [Desulfobacterales bacterium] diamond 78 41.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales 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);;