RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 4 ✖

bioproject 1

  • PRJNA906294 · 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
31067202 31067202 PRJNA906294_P_NODE_201055_length_254_cov_1.602210_g196939_i0 PRJNA906294 201055 254 1.60221 4.0696134 Candidatus Caldarchaeum sp. 2972665 Archaea Archaea 42.4 0.0492   NR MEM1980601.1 2972665 g196939 i0 44.4 0.637795275590551 54 30 63.8 0 216 55 21 74 MEM1980601.1 hypothetical protein [Candidatus Caldarchaeum sp.] diamond 162 42.4 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales Candidatus Caldarchaeaceae Candidatus Caldarchaeum Candidatus Caldarchaeum sp.
31509810 31509810 PRJNA906294_P_NODE_117656_length_368_cov_3.515254_g113541_i0 PRJNA906294 117656 368 3.515254 12.93613472 Acidianus manzaensis 282676 Archaea Archaea 48.1 9.19e-4   NR WP_148692652.1 282676 g113541 i0 32.9 1.41847826086957 85 54 69.3 2 280 26 8 89 WP_148692652.1 ADP-ribose-binding protein [Acidianus manzaensis] diamond 522 48.1 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Acidianus Acidianus manzaensis
32711102 32711102 PRJNA906294_P_NODE_172400_length_284_cov_0.966825_g168284_i0 PRJNA906294 172400 284 0.966825 2.745783 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 52.8 1.2e-6   NR MDF2737902.1 2169593 g168284 i0 49 0.538732394366197 51 26 53.9 0 181 29 5 55 MDF2737902.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 153 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32774039 32774039 PRJNA906294_P_NODE_149800_length_312_cov_1.192469_g145684_i0 PRJNA906294 149800 312 1.192469 3.72050328 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 92.8 7.18e-21   NR NIR87880.1 2026714 g145684 i0 48.4 17.5769230769231 95 49 91.3 0 310 26 112 206 NIR87880.1 NAD(P)H:quinone oxidoreductase [Candidatus Bathyarchaeota archaeon] diamond 5484 92.8 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon

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