RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA416866", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 6 ✖

tax_kingdom 1

  • Bacillati · 6 ✖

bioproject 1

  • PRJNA416866 · 6 ✖

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
14448555 14448555 PRJNA416866_P_NODE_8812_length_217_cov_1.019231_g8668_i0 PRJNA416866 8812 217 1.019231 2.21173127 Anaerolineales bacterium 2073117 Bacteria Bacteria 114 1.71e-27   NR MCB9103363.1 2073117 g8668 i0 77.4 2.68202764976959 62 14 85.7 0 5 190 184 245 MCB9103363.1 insulinase family protein [Anaerolineales bacterium] diamond 582 114 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
27928445 27928445 PRJNA416866_P_NODE_8145_length_226_cov_2.084848_g8001_i0 PRJNA416866 8145 226 2.084848 4.71175648 Caldilineaceae bacterium 2614250 Bacteria Bacteria 68.6 2.41e-11   NR MBX3000354.1 2614250 g8001 i0 56 6.99557522123894 75 33 99.6 0 2 226 456 530 MBX3000354.1 sodium-translocating pyrophosphatase [Caldilineaceae bacterium] diamond 1581 68.6 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae bacterium
27991706 27991706 PRJNA416866_P_NODE_8425_length_222_cov_1.590062_g8281_i0 PRJNA416866 8425 222 1.590062 3.52993764 Chloroflexota bacterium 2026724 Bacteria Bacteria 55.1 9.77e-7   NR NMB87870.1 2026724 g8281 i0 49.2 2.90540540540541 59 20 79.7 2 182 6 7 55 NMB87870.1 alpha/beta hydrolase [Chloroflexota bacterium] diamond 645 55.1 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30991979 30991979 PRJNA416866_P_NODE_9154_length_212_cov_1.695364_g9010_i0 PRJNA416866 9154 212 1.695364 3.59417168 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 48.9 4.54e-5   NR HEU0073941.1 2026734 g9010 i0 47.9 0.679245283018868 48 24 67.9 1 208 65 56 102 HEU0073941.1 RlpA-like double-psi beta-barrel domain-containing protein [Dehalococcoidia bacterium] diamond 144 48.9 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
31972124 31972124 PRJNA416866_P_NODE_11498_length_202_cov_0.907801_g11354_i0 PRJNA416866 11498 202 0.907801 1.83375802 Chloroflexota bacterium 2026724 Bacteria Bacteria 49.3 1.07e-4   NR MYE27165.1 2026724 g11354 i0 52 1.41089108910891 50 21 69.8 1 198 58 428 477 MYE27165.1 sigma-70 family RNA polymerase sigma factor [Chloroflexota bacterium] diamond 285 49.3 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32715828 32715828 PRJNA416866_P_NODE_11320_length_203_cov_0.901408_g11176_i0 PRJNA416866 11320 203 0.901408 1.82985824 Bacillati 1783272 Bacteria Bacteria 42.7 0.0221   NR HLF07758.1 2026734 g11176 i0 32.8 1.89162561576355 64 37 94.6 1 2 193 81 138 HLF07758.1 succinate dehydrogenase/fumarate reductase flavoprotein subunit [Dehalococcoidia bacterium] diamond 384 42.7 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);;