RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA493632" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493632 · 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
4292188 4292188 PRJNA493632_P_NODE_511924_length_251_cov_0.865169_g508485_i0 PRJNA493632 511924 251 0.865169 2.17157419 Acidianus sp. HS-5 2886040 Archaea Archaea 83.6 1.62e-16   NR WP_236751063.1 2886040 g508485 i0 54.3 0.836653386454183 70 31 82.5 1 208 2 237 306 WP_236751063.1 sugar porter family MFS transporter [Acidianus sp. HS-5] diamond 210 83.6 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Acidianus Acidianus sp. HS-5
30456154 30456154 PRJNA493632_P_NODE_484513_length_255_cov_1.587912_g481074_i0 PRJNA493632 484513 255 1.587912 4.0491756 Sulfuracidifex metallicus 47303 Archaea Archaea 46.6 2.1e-4   NR WP_277023027.1 47303 g481074 i0 45.8 0.694117647058824 59 28 64.7 1 228 64 20 78 WP_277023027.1 capsid protein VP2 [Sulfuracidifex metallicus] diamond 177 46.6 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfuracidifex Sulfuracidifex metallicus
31530560 31530560 PRJNA493632_P_NODE_456016_length_260_cov_5.909091_g452577_i0 PRJNA493632 456016 260 5.909091 15.3636366 Pyrobaculum sp. 2004705 Archaea Archaea 145 2.68e-38   NR MEM0464981.1 2004705 g452577 i0 100 0.992307692307692 86 0 99.2 0 1 258 1523 1608 MEM0464981.1 hypothetical protein [Pyrobaculum sp.] diamond 258 145 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum sp.

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