RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA255848", tax_kingdom = "Bacillati" 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

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA255848 · 4 ✖

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
27692274 27692274 PRJNA255848_P_NODE_39024_length_165_cov_0.879310_g38706_i0 PRJNA255848 39024 165 0.87931 1.4508615 Bacteria 2 Bacteria Bacteria 77.8 3.05e-15   NR MEN9934468.1 2026724 g38706 i0 72.2 1.96363636363636 54 15 98.2 0 3 164 192 245 MEN9934468.1 hypothetical protein [Chloroflexota bacterium] diamond 324 78.2 0.994884910485933 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29095212 29095212 PRJNA255848_P_NODE_25608_length_197_cov_1.033784_g25290_i0 PRJNA255848 25608 197 1.033784 2.03655448 Anaerolineales bacterium 2073117 Bacteria Bacteria 71.2 1.8e-12   NR MCB0077131.1 2073117 g25290 i0 53.1 2.9238578680203 64 30 97.5 0 196 5 297 360 MCB0077131.1 RecQ family ATP-dependent DNA helicase [Anaerolineales bacterium] diamond 576 71.2 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
30200182 30200182 PRJNA255848_P_NODE_19692_length_225_cov_0.710227_g19374_i0 PRJNA255848 19692 225 0.710227 1.59801075 Anaerolineae bacterium 2052143 Bacteria Bacteria 139 1.89e-40   NR MFO7743059.1 2052143 g19374 i0 90.5 0.986666666666667 74 7 98.7 0 3 224 51 124 MFO7743059.1 reverse transcriptase domain-containing protein [Anaerolineae bacterium] diamond 222 139 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
30484829 30484829 PRJNA255848_P_NODE_44953_length_162_cov_0.902655_g44635_i0 PRJNA255848 44953 162 0.902655 1.4623011 Caldilineales bacterium 2306055 Bacteria Bacteria 83.2 2.16e-18   NR MEZ4768038.1 2306055 g44635 i0 67.3 2.88888888888889 52 17 96.3 0 2 157 94 145 MEZ4768038.1 nuclear transport factor 2 family protein [Caldilineales bacterium] diamond 468 83.2 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales     Caldilineales 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);;