RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA767802" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA767802 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
28127193 28127193 PRJNA767802_P_NODE_15885_length_167_cov_1.296610_g15812_i0 PRJNA767802 15885 167 1.29661 2.1653387 Candidatus Heimdallarchaeota archaeon 2026747 Archaea Archaea 46.6 5.83e-4   NR HUT86467.1 2026747 g15812 i0 46.3 0.970059880239521 54 28 97 1 166 5 506 558 HUT86467.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] diamond 162 46.6 1 Archaea   Promethearchaeati Candidatus Heimdallarchaeota         Candidatus Heimdallarchaeota archaeon
28600814 28600814 PRJNA767802_P_NODE_17647_length_163_cov_1.728070_g17574_i0 PRJNA767802 17647 163 1.72807 2.8167541 archaeon 1906665 Archaea Archaea 66.6 3.55e-11   NR MCQ2817247.1 1906665 g17574 i0 64.6 1.78527607361963 48 17 88.3 0 163 20 253 300 MCQ2817247.1 Bax inhibitor-1 family protein [archaeon] diamond 291 66.6 1 Archaea               archaeon
29200787 29200787 PRJNA767802_P_NODE_6089_length_322_cov_2.989011_g6016_i0 PRJNA767802 6089 322 2.989011 9.62461542 archaeon 1906665 Archaea Archaea 60.8 2.54e-8   NR MCQ2821136.1 1906665 g6016 i0 63.9 0.335403726708075 36 13 33.5 0 299 192 142 177 MCQ2821136.1 hypothetical protein [archaeon] diamond 108 60.8 1 Archaea               archaeon
30021776 30021776 PRJNA767802_P_NODE_15251_length_172_cov_1.243902_g15178_i0 PRJNA767802 15251 172 1.243902 2.13951144 archaeon 1906665 Archaea Archaea 74.3 5.65e-14   NR MCQ2815999.1 1906665 g15178 i0 57.9 0.994186046511628 57 24 99.4 0 2 172 246 302 MCQ2815999.1 alpha/beta hydrolase [archaeon] diamond 171 74.3 1 Archaea               archaeon
30210992 30210992 PRJNA767802_P_NODE_7852_length_269_cov_1.822727_g7779_i0 PRJNA767802 7852 269 1.822727 4.90313563 archaeon 1906665 Archaea Archaea 90.5 7.56e-21   NR MCQ2816171.1 1906665 g7779 i0 56.2 0.992565055762082 89 38 98.1 1 4 267 49 137 MCQ2816171.1 hypothetical protein [archaeon] diamond 267 90.5 1 Archaea               archaeon
32802864 32802864 PRJNA767802_P_NODE_9840_length_229_cov_1.977778_g9767_i0 PRJNA767802 9840 229 1.977778 4.52911162 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 109 4.27e-26   NR MAH46906.1 2026773 g9767 i0 65.8 0.995633187772926 76 26 99.6 0 2 229 72 147 MAH46906.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 228 109 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota 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);;