RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA596870", tax_kingdom = "Bacillati" 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

  • Bacillati · 5 ✖

bioproject 1

  • PRJNA596870 · 5 ✖

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
26763293 26763293 PRJNA596870_P_NODE_14961_length_338_cov_1.162264_g14828_i0 PRJNA596870 14961 338 1.162264 3.92845232 Chloroflexota bacterium 2026724 Bacteria Bacteria 44.7 0.00603   NR MBI4498428.1 2026724 g14828 i0 32.9 0.64792899408284 73 49 64.8 0 119 337 11 83 MBI4498428.1 retroviral-like aspartic protease family protein [Chloroflexota bacterium] diamond 219 44.7 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28848102 28848102 PRJNA596870_P_NODE_23288_length_280_cov_1.487923_g23155_i0 PRJNA596870 23288 280 1.487923 4.1661844 Chloroflexales bacterium 2725990 Bacteria Bacteria 122 5.53e-30   NR MCG8352146.1 2725990 g23155 i0 68.5 0.985714285714286 92 29 98.6 0 3 278 359 450 MCG8352146.1 GAF domain-containing protein [Chloroflexales bacterium] diamond 276 122 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales     Chloroflexales bacterium
29922001 29922001 PRJNA596870_P_NODE_30991_length_250_cov_0.870056_g30858_i0 PRJNA596870 30991 250 0.870056 2.17514 Chloroflexota bacterium 2026724 Bacteria Bacteria 68.6 3.24e-13   NR MFH1663036.1 2026724 g30858 i0 58.9 1.344 56 23 67.2 0 206 39 10 65 MFH1663036.1 superinfection immunity protein [Chloroflexota bacterium] diamond 336 68.6 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31104093 31104093 PRJNA596870_P_NODE_16395_length_325_cov_1.392857_g16262_i0 PRJNA596870 16395 325 1.392857 4.52678525 Bacteria 2 Bacteria Bacteria 114 3.39e-30   NR MEM6284454.1 2026724 g16262 i0 51.6 5.83384615384615 93 45 85.8 0 281 3 1 93 MEM6284454.1 Mth938-like domain-containing protein [Chloroflexota bacterium] diamond 1896 114 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32071312 32071312 PRJNA596870_P_NODE_29098_length_251_cov_0.865169_g28965_i0 PRJNA596870 29098 251 0.865169 2.17157419 Chloroflexota bacterium 2026724 Bacteria Bacteria 46.2 0.00155   NR HHE71062.1 2026724 g28965 i0 52.2 2.12749003984064 46 22 55 0 144 7 3 48 HHE71062.1 ATPase [Chloroflexota bacterium] diamond 534 46.2 1 Bacteria   Bacillati Chloroflexota         Chloroflexota 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);;