RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA857857" and tax_kingdom = "Promethearchaeati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Promethearchaeati · 3 ✖

bioproject 1

  • PRJNA857857 · 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
28697454 28697454 PRJNA857857_P_NODE_14907_length_407_cov_2.356287_g14460_i0 PRJNA857857 14907 407 2.356287 9.59008809 Promethearchaeia archaeon 3067280 Archaea Archaea 74.7 1.25e-12   NR RLI61446.1 3067280 g14460 i0 40.2 0.862407862407862 117 65 83.3 4 365 27 92 207 RLI61446.1 MAG: hypothetical protein DRO88_13050 [Promethearchaeia archaeon] diamond 351 74.7 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
30497528 30497528 PRJNA857857_P_NODE_33133_length_266_cov_2.393782_g32684_i0 PRJNA857857 33133 266 2.393782 6.36746012 Promethearchaeota archaeon 2053489 Archaea Archaea 74.3 1.93e-13   NR MCK4280635.1 2053489 g32684 i0 46.5 0.969924812030075 86 45 95.9 1 8 262 49 134 MCK4280635.1 hypothetical protein [Promethearchaeota archaeon] diamond 258 74.3 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
32521484 32521484 PRJNA857857_P_NODE_34199_length_261_cov_1.324468_g33750_i0 PRJNA857857 34199 261 1.324468 3.45686148 Candidatus Heimdallarchaeota archaeon 2026747 Archaea Archaea 66.2 5.59e-11   NR MBN1328499.1 2026747 g33750 i0 41.9 0.988505747126437 86 41 98.9 2 3 260 108 184 MBN1328499.1 DUF1917 domain-containing protein [Candidatus Heimdallarchaeota archaeon] diamond 258 66.2 1 Archaea   Promethearchaeati Candidatus Heimdallarchaeota         Candidatus Heimdallarchaeota 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);;