RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB39269 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
26843672 26843672 PRJEB39269_P_NODE_85801_length_154_cov_1.530435_g85396_i0 PRJEB39269 85801 154 1.530435 2.3568699 Chloroflexota bacterium 2026724 Bacteria Bacteria 101 1.99e-23   NR MDQ6673653.1 2026724 g85396 i0 90 1.96753246753247 50 5 97.4 0 2 151 789 838 MDQ6673653.1 LLM class flavin-dependent oxidoreductase [Chloroflexota bacterium] diamond 303 101 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27026711 27026711 PRJEB39269_P_NODE_82702_length_157_cov_1.042373_g82297_i0 PRJEB39269 82702 157 1.042373 1.63652561 Bacteria 2 Bacteria Bacteria 47.4 2.62e-4   NR MEA3377224.1 2026724 g82297 i0 44.9 2.82802547770701 49 26 93.6 1 3 149 674 721 MEA3377224.1 NBR1-Ig-like domain-containing protein [Chloroflexota bacterium] diamond 444 47.4 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27349679 27349679 PRJEB39269_P_NODE_74383_length_163_cov_1.983871_g73978_i0 PRJEB39269 74383 163 1.983871 3.23370973 Chloroflexales bacterium 2725990 Bacteria Bacteria 47.4 7.61e-5   NR MEI8165616.1 2725990 g73978 i0 54.5 1.78527607361963 44 20 81 0 134 3 11 54 MEI8165616.1 DUF4844 domain-containing protein [Chloroflexales bacterium] diamond 291 47.4 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales     Chloroflexales bacterium
29395229 29395229 PRJEB39269_P_NODE_71709_length_166_cov_1.614173_g71304_i0 PRJEB39269 71709 166 1.614173 2.67952718 PVC group 1783257 Bacteria Bacteria 103 5.75e-25   NR MBF6605010.1 2026724 g71304 i0 89.1 22.8614457831325 55 6 99.4 0 2 166 67 121 MBF6605010.1 transketolase family protein [Chloroflexota bacterium] diamond 3795 104 0.990384615384615 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30089844 30089844 PRJEB39269_P_NODE_80592_length_158_cov_2.739496_g80187_i0 PRJEB39269 80592 158 2.739496 4.32840368 Bacteria 2 Bacteria Bacteria 75.1 4.11e-14   NR MBN1660975.1 2052143 g80187 i0 57.7 6.87341772151899 52 22 98.7 0 2 157 145 196 MBN1660975.1 beta-lactamase family protein [Anaerolineae bacterium] diamond 1086 75.5 0.994701986754967 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
31771675 31771675 PRJEB39269_P_NODE_57297_length_182_cov_1.433566_g56892_i0 PRJEB39269 57297 182 1.433566 2.60909012 Chloroflexota bacterium 2026724 Bacteria Bacteria 85.1 9.41e-20   NR MCH7580248.1 2026724 g56892 i0 72 1.64835164835165 50 14 82.4 0 2 151 48 97 MCH7580248.1 DUF1330 domain-containing protein [Chloroflexota bacterium] diamond 300 85.1 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32556444 32556444 PRJEB39269_P_NODE_11599_length_410_cov_20.107817_g11194_i0 PRJEB39269 11599 410 20.107817 82.4420497 Chloroflexota 200795 Bacteria Bacteria 45.1 0.0313   NR PMP78997.1 152260 g11194 i0 29.2 3.25609756097561 89 47 65.1 2 404 138 299 371 PMP78997.1 MAG: transporter, partial [Chloroflexus aggregans] diamond 1335 45.1 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Chloroflexaceae Chloroflexus Chloroflexus aggregans

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