RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB3181 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27064845 27064845 PRJEB3181_P_NODE_28302_length_150_cov_1.218487_g28037_i0 PRJEB3181 28302 150 1.218487 1.8277305 Chloroflexota bacterium 2026724 Bacteria Bacteria 40 0.0299   NR MEL7436165.1 2026724 g28037 i0 54.2 0.48 24 11 48 0 5 76 44 67 MEL7436165.1 Uma2 family endonuclease [Chloroflexota bacterium] diamond 72 40 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28738682 28738682 PRJEB3181_P_NODE_14427_length_222_cov_2.916230_g14163_i0 PRJEB3181 14427 222 2.91623 6.4740306 Anaerolineae bacterium 2052143 Bacteria Bacteria 57 1.85e-8   NR HFC12985.1 2052143 g14163 i0 67.6 1.39189189189189 34 10 45.9 1 218 117 23 55 HFC12985.1 DUF2958 domain-containing protein [Anaerolineae bacterium] diamond 309 57 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
29243919 29243919 PRJEB3181_S_NODE_16329_length_161_cov_0.952381_g16036_i0 PRJEB3181 16329 161 0.952381 1.53333341 Anaerolineales bacterium 2073117 Bacteria Bacteria 39.3 0.0271   NR MCJ7584703.1 2073117 g16036 i0 65.5 0.540372670807453 29 10 54 0 89 3 4 32 MCJ7584703.1 hypothetical protein [Anaerolineales bacterium] diamond 87 39.3 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
31138820 31138820 PRJEB3181_S_NODE_17995_length_153_cov_3.483051_g17702_i0 PRJEB3181 17995 153 3.483051 5.32906803 Chloroflexota bacterium 2026724 Bacteria Bacteria 41.6 0.0288   NR NQT48788.1 2026724 g17702 i0 61.3 0.607843137254902 31 12 60.8 0 144 52 305 335 NQT48788.1 NAD-dependent epimerase/dehydratase family protein [Chloroflexota bacterium] diamond 93 41.6 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31385716 31385716 PRJEB3181_S_NODE_12896_length_180_cov_1.406897_g12603_i0 PRJEB3181 12896 180 1.406897 2.5324146 Bacteria 2 Bacteria Bacteria 89 1.07e-19   NR WP_297714930.1 1969742 g12603 i0 69.5 5.9 59 18 98.3 0 2 178 97 155 WP_297714930.1 cyclase family protein [Thermoflexus sp.] diamond 1062 89 1 Bacteria   Bacillati Chloroflexota Thermoflexia Thermoflexales Thermoflexaceae Thermoflexus Thermoflexus sp.

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);;