RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB14664" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14664 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
29212205 29212205 PRJEB14664_P_NODE_18109_length_161_cov_0.952381_g17979_i0 PRJEB14664 18109 161 0.952381 1.53333341 Chloroflexota bacterium 2026724 Bacteria Bacteria 55.5 3.94e-7   NR MEP7200188.1 2026724 g17979 i0 50 0.968944099378882 52 25 96.9 1 5 160 136 186 MEP7200188.1 S8 family serine peptidase [Chloroflexota bacterium] diamond 156 55.5 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29212208 29212208 PRJEB14664_P_NODE_19289_length_155_cov_1.000000_g19159_i0 PRJEB14664 19289 155 1 1.55 Anaerolineae bacterium 2052143 Bacteria Bacteria 43.9 0.00443   NR HNS52366.1 2052143 g19159 i0 47.5 2.84516129032258 40 20 75.5 1 1 117 536 575 HNS52366.1 Ig-like domain-containing protein [Anaerolineae bacterium] diamond 441 43.9 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
29622039 29622039 PRJEB14664_P_NODE_10090_length_240_cov_1.648780_g9960_i0 PRJEB14664 10090 240 1.64878 3.957072 Anaerolineae bacterium 2052143 Bacteria Bacteria 62 4.48e-10   NR MCW5848612.1 2052143 g9960 i0 50.8 0.8125 65 32 81.3 0 6 200 60 124 MCW5848612.1 profilin [Anaerolineae bacterium] diamond 195 62 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
29622065 29622065 PRJEB14664_P_NODE_8870_length_263_cov_1.578947_g8740_i0 PRJEB14664 8870 263 1.578947 4.15263061 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 69.3 2.04e-11   NR HXK34737.1 2026734 g8740 i0 50 0.821292775665399 72 36 82.1 0 250 35 246 317 HXK34737.1 VWA domain-containing protein [Dehalococcoidia bacterium] diamond 216 69.3 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia 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);;