RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1263632", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 3 ✖

tax_kingdom 1

  • Bacillati · 3 ✖

bioproject 1

  • PRJNA1263632 · 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
31134072 31134072 PRJNA1263632_P_NODE_2915_length_358_cov_1.621053_g2897_i0 PRJNA1263632 2915 358 1.621053 5.80336974 root 1 Root_unresolved Root_unresolved 109 8.88e-28   NR MEZ4515128.1 2026724 g2897 i0 45.6 2.93296089385475 114 61 94.7 1 339 1 6 119 MEZ4515128.1 coactosin family protein [Chloroflexota bacterium] diamond 1050 109 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31134073 31134073 PRJNA1263632_P_NODE_6955_length_248_cov_0.880000_g6937_i0 PRJNA1263632 6955 248 0.88 2.1824 PVC group 1783257 Bacteria Bacteria 43.5 0.0219   NR MCP4541251.1 2026724 g6937 i0 44.9 1.42741935483871 49 26 59.3 1 3 149 416 463 MCP4541251.1 DUF11 domain-containing protein [Chloroflexota bacterium] diamond 354 43.9 0.990888382687927 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32033797 32033797 PRJNA1263632_P_NODE_6398_length_251_cov_0.865169_g6380_i0 PRJNA1263632 6398 251 0.865169 2.17157419 Chloroflexales bacterium 2725990 Bacteria Bacteria 75.5 1.2e-13   NR MCG8349124.1 2725990 g6380 i0 48.2 0.99203187250996006 83 39 99.2 1 3 251 483 561 MCG8349124.1 choline/carnitine O-acyltransferase [Chloroflexales bacterium] diamond 249 75.5 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales     Chloroflexales 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);;