RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1087264", 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

  • PRJNA1087264 · 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
27722763 27722763 PRJNA1087264_P_NODE_6844_length_242_cov_1.056995_g6762_i0 PRJNA1087264 6844 242 1.056995 2.5579279 Bacillati 1783272 Bacteria Bacteria 60.5 1.97e-8   NR MFN8488417.1 2614250 g6762 i0 39.3 2.80165289256198 56 34 69.4 0 171 4 6 61 MFN8488417.1 arginine deiminase family protein [Caldilineaceae bacterium] diamond 678 60.8 0.995065789473684 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae bacterium
27983474 27983474 PRJNA1087264_P_NODE_9585_length_204_cov_0.812903_g9503_i0 PRJNA1087264 9585 204 0.812903 1.65832212 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 45.4 0.00259   NR MFN8557611.1 2026734 g9503 i0 44.4 1.05882352941176 72 36 100 1 1 204 84 155 MFN8557611.1 VWA domain-containing protein [Dehalococcoidia bacterium] diamond 216 45.4 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
28615059 28615059 PRJNA1087264_P_NODE_12727_length_177_cov_1.195312_g12645_i0 PRJNA1087264 12727 177 1.195312 2.11570224 Anaerolineae bacterium 2052143 Bacteria Bacteria 48.1 1.46e-4   NR MBN1248875.1 2052143 g12645 i0 62.2 0.76271186440678 45 16 74.6 1 5 136 19 63 MBN1248875.1 hypothetical protein [Anaerolineae bacterium] diamond 135 48.1 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
28772770 28772770 PRJNA1087264_P_NODE_9167_length_208_cov_1.283019_g9085_i0 PRJNA1087264 9167 208 1.283019 2.66867952 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 90.5 2.99e-21   NR MDO9333994.1 2026733 g9085 i0 64.2 1.93269230769231 67 24 96.6 0 204 4 45 111 MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium] diamond 402 90.5 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
29498989 29498989 PRJNA1087264_P_NODE_14690_length_167_cov_0.864407_g14608_i0 PRJNA1087264 14690 167 0.864407 1.44355969 Anaerolineales bacterium 2073117 Bacteria Bacteria 56.6 1.67e-7   NR MBX3048901.1 2073117 g14608 i0 50.9 0.988023952095808 55 16 97 2 1 162 270 314 MBX3048901.1 beta-galactosidase [Anaerolineales bacterium] diamond 165 56.6 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
30225435 30225435 PRJNA1087264_P_NODE_17112_length_165_cov_0.879310_g17030_i0 PRJNA1087264 17112 165 0.87931 1.4508615 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 99.8 2.93e-23   NR MDO9334216.1 2026733 g17030 i0 81.5 0.981818181818182 54 10 98.2 0 163 2 124 177 MDO9334216.1 hypothetical protein [Dehalococcoidales bacterium] diamond 162 99.8 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales 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);;