RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA399133" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 4 ✖

bioproject 1

  • PRJNA399133 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28465139 28465139 PRJNA399133_P_NODE_6866_length_200_cov_1.993939_g6778_i0 PRJNA399133 6866 200 1.993939 3.987878 Ignisphaera sp. 2268142 Archaea Archaea 56.6 2.09e-8   NR MCI4435877.1 2268142 g6778 i0 70 1.89 40 12 60 0 80 199 4 43 MCI4435877.1 MazG-like family protein [Ignisphaera sp.] diamond 378 56.6 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
28654466 28654466 PRJNA399133_P_NODE_7927_length_186_cov_1.589404_g7839_i0 PRJNA399133 7927 186 1.589404 2.95629144 Ignisphaera sp. 2268142 Archaea Archaea 94 5.58e-21   NR MCI4437464.1 2268142 g7839 i0 71.2 1.90322580645161 59 17 95.2 0 179 3 46 104 MCI4437464.1 hypothetical protein [Ignisphaera sp.] diamond 354 94 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
29790916 29790916 PRJNA399133_P_NODE_6171_length_212_cov_1.220339_g6083_i0 PRJNA399133 6171 212 1.220339 2.58711868 Nitrosarchaeum sp. 2026886 Archaea Archaea 115 1.85e-30   NR MDW7641537.1 2026886 g6083 i0 75.7 0.990566037735849 70 17 99.1 0 210 1 109 178 MDW7641537.1 DUF6433 family protein [Nitrosarchaeum sp.] diamond 210 115 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
31387912 31387912 PRJNA399133_P_NODE_7356_length_194_cov_0.981132_g7268_i0 PRJNA399133 7356 194 0.981132 1.90339608 root 1 Root_unresolved Root_unresolved 108 1.67e-25   NR MCI4437983.1 2268142 g7268 i0 65.6 2.96907216494845 64 22 99 0 3 194 545 608 MCI4437983.1 hypothetical protein [Ignisphaera sp.] diamond 576 108 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera 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);;