RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB673" 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

  • PRJEB673 · 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
27406434 27406434 PRJEB673_P_NODE_12883_length_151_cov_1.034483_g12534_i0 PRJEB673 12883 151 1.034483 1.56206933 FCB group 1783270 Bacteria Bacteria 49.3 5.23e-5   NR TAK62485.1 2026734 g12534 i0 63.2 1.60927152317881 38 11 69.5 1 118 14 68 105 TAK62485.1 MAG: CSLREA domain-containing protein [Dehalococcoidia bacterium] diamond 243 49.3 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
28928936 28928936 PRJEB673_P_NODE_9168_length_209_cov_1.080460_g8819_i0 PRJEB673 9168 209 1.08046 2.2581614 Chloroflexota bacterium 2026724 Bacteria Bacteria 77.4 8.2e-15   NR MEA3441316.1 2026724 g8819 i0 46.4 2.92822966507177 69 37 99 0 3 209 119 187 MEA3441316.1 NBR1-Ig-like domain-containing protein [Chloroflexota bacterium] diamond 612 77.4 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31417367 31417367 PRJEB673_P_NODE_11356_length_162_cov_1.259843_g11007_i0 PRJEB673 11356 162 1.259843 2.04094566 Candidatus Chlorohelix 3139173 Bacteria Bacteria 95.5 1e-22   NR WP_341470264.1 3003348 g11007 i0 81.1 4.90740740740741 53 10 98.1 0 3 161 126 178 WP_341470264.1 DoxX family protein [Candidatus Chlorohelix allophototropha] diamond 795 95.9 0.995828988529718 Bacteria   Bacillati Chloroflexota Chloroflexia Candidatus Chloroheliales Candidatus Chloroheliaceae Candidatus Chlorohelix Candidatus Chlorohelix allophototropha
31899036 31899036 PRJEB673_P_NODE_3197_length_557_cov_2.695402_g2881_i0 PRJEB673 3197 557 2.695402 15.01338914 Anaerolineales bacterium 2073117 Bacteria Bacteria 94.4 5.41e-21   NR HXQ39119.1 2073117 g2881 i0 49 1.07719928186715 100 49 53.9 1 155 454 32 129 HXQ39119.1 globin family protein [Anaerolineales bacterium] diamond 600 94.4 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales 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);;