RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 5 ✖

bioproject 1

  • PRJNA716463 · 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
21110993 21110993 PRJNA716463_P_NODE_71177_length_275_cov_2.693069_g70760_i0 PRJNA716463 71177 275 2.693069 7.40593975 Nitrososphaeria archaeon 2268198 Archaea Archaea 178 3.419999999999999e-54   NR NDB47524.1 2268198 g70760 i0 94.5 0.992727272727273 91 5 99.3 0 273 1 71 161 NDB47524.1 ABC transporter ATP-binding protein [Nitrososphaeria archaeon] diamond 273 178 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon
27810313 27810313 PRJNA716463_P_NODE_105104_length_247_cov_1.758621_g104687_i0 PRJNA716463 105104 247 1.758621 4.34379387 Thermofilaceae archaeon 2268203 Archaea Archaea 184 9.02e-58   NR MEM2592530.1 2268203 g104687 i0 98.8 0.995951417004049 82 1 99.6 0 246 1 39 120 MEM2592530.1 DUF2750 domain-containing protein [Thermofilaceae archaeon] diamond 246 184 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermofilales Thermofilaceae   Thermofilaceae archaeon
28504751 28504751 PRJNA716463_P_NODE_41247_length_298_cov_2.631111_g40830_i0 PRJNA716463 41247 298 2.631111 7.84071078 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 76.3 1.1e-13   NR HKG87688.1 2169593 g40830 i0 68 2.50671140939597 50 16 50.3 0 293 144 357 406 HKG87688.1 PQQ-dependent sugar dehydrogenase [Nitrososphaeraceae archaeon] diamond 747 76.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28788774 28788774 PRJNA716463_P_NODE_85107_length_264_cov_3.099476_g84690_i0 PRJNA716463 85107 264 3.099476 8.1826166400000009 Nitrosopumilales archaeon 2026768 Archaea Archaea 169 5.58e-49   NR RPJ31745.1 2026768 g84690 i0 100 0.988636363636364 87 0 98.9 0 263 3 216 302 RPJ31745.1 MAG: adenosylhomocysteinase [Nitrosopumilales archaeon] diamond 261 169 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
31379333 31379333 PRJNA716463_P_NODE_97656_length_253_cov_2.844444_g97239_i0 PRJNA716463 97656 253 2.844444 7.19644332 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 165 2.05e-45   NR HEY9491973.1 2169593 g97239 i0 97.6 2.98814229249012 84 2 99.6 0 1 252 19 102 HEY9491973.1 GMC family oxidoreductase [Nitrososphaeraceae archaeon] diamond 756 165 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae 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);;