RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA688931" and tax_kingdom = "Promethearchaeati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Promethearchaeati · 5 ✖

bioproject 1

  • PRJNA688931 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
26797491 26797491 PRJNA688931_P_NODE_5361_length_479_cov_1.790698_g5149_i0 PRJNA688931 5361 479 1.790698 8.57744342 Candidatus Heimdallarchaeota archaeon 2026747 Archaea Archaea 102 1.62e-23   NR MDH5401859.1 2026747 g5149 i0 37.3 0.939457202505219 150 94 93.9 0 5 454 8 157 MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon] diamond 450 102 1 Archaea   Promethearchaeati Candidatus Heimdallarchaeota         Candidatus Heimdallarchaeota archaeon
27145070 27145070 PRJNA688931_P_NODE_14602_length_270_cov_1.995475_g14389_i0 PRJNA688931 14602 270 1.995475 5.3877825 Candidatus Thorarchaeota archaeon 2053491 Archaea Archaea 45.8 0.00409   NR NWF96145.1 2053491 g14389 i0 39.4 0.733333333333333 66 34 72.2 4 63 257 430 490 NWF96145.1 DUF2240 family protein [Candidatus Thorarchaeota archaeon] diamond 198 45.8 1 Archaea   Promethearchaeati Candidatus Thorarchaeota         Candidatus Thorarchaeota archaeon
28250721 28250721 PRJNA688931_P_NODE_23626_length_210_cov_1.919255_g23413_i0 PRJNA688931 23626 210 1.919255 4.0304355 Promethearchaeota archaeon 2053489 Archaea Archaea 62.4 2.57e-9   NR MCK4687431.1 2053489 g23413 i0 60 1.18571428571429 45 18 64.3 0 135 1 3 47 MCK4687431.1 ABC transporter ATP-binding protein [Promethearchaeota archaeon] diamond 249 62.4 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
29009014 29009014 PRJNA688931_P_NODE_4108_length_553_cov_1.523810_g3901_i0 PRJNA688931 4108 553 1.52381 8.4266693 Candidatus Heimdallarchaeota archaeon 2026747 Archaea Archaea 141 2.12e-38   NR MDH5401859.1 2026747 g3901 i0 39.8 0.927667269439421 171 101 92.2 2 522 13 37 206 MDH5401859.1 aquaporin [Candidatus Heimdallarchaeota archaeon] diamond 513 141 1 Archaea   Promethearchaeati Candidatus Heimdallarchaeota         Candidatus Heimdallarchaeota archaeon
29987542 29987542 PRJNA688931_P_NODE_20771_length_224_cov_2.440000_g20558_i0 PRJNA688931 20771 224 2.44 5.4656 Candidatus Thorarchaeota archaeon 2053491 Archaea Archaea 45.4 0.00279   NR RLI53311.1 2053491 g20558 i0 35.1 1.52678571428571 57 37 76.3 0 3 173 175 231 RLI53311.1 MAG: hypothetical protein DRO93_13810, partial [Candidatus Thorarchaeota archaeon] diamond 342 45.4 1 Archaea   Promethearchaeati Candidatus Thorarchaeota         Candidatus Thorarchaeota 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);;