RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB10320" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB10320 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
27980369 27980369 PRJEB10320_P_NODE_28085_length_152_cov_1.025641_g27827_i0 PRJEB10320 28085 152 1.025641 1.55897432 Desulfofustis sp. PB-SRB1 1385624 Bacteria Bacteria 56.6 1.28e-7   NR MBL0381487.1 1385624 g27827 i0 65.3 0.967105263157895 49 16 96.7 1 147 1 229 276 MBL0381487.1 malate dehydrogenase [Desulfofustis sp. PB-SRB1] diamond 147 56.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfofustis Desulfofustis sp. PB-SRB1
28074949 28074949 PRJEB10320_P_NODE_25665_length_161_cov_1.071429_g25407_i0 PRJEB10320 25665 161 1.071429 1.72500069 Desulfobacterales bacterium 2044940 Bacteria Bacteria 60.8 4.94e-9   NR MCP4353600.1 2044940 g25407 i0 62.8 2.34782608695652 43 16 80.1 0 1 129 1 43 MCP4353600.1 CHAT domain-containing protein [Desulfobacterales bacterium] diamond 378 60.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31897629 31897629 PRJEB10320_P_NODE_28137_length_152_cov_0.923077_g27879_i0 PRJEB10320 28137 152 0.923077 1.40307704 Desulfobacterales bacterium 2044940 Bacteria Bacteria 62 1.69e-9   NR MCJ7541722.1 2044940 g27879 i0 60 1.97368421052632 50 20 98.7 0 151 2 446 495 MCJ7541722.1 NAD-dependent malic enzyme [Desulfobacterales bacterium] diamond 300 62 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales 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);;