RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA661142" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA661142 · 5 ✖

analysis 1

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
14657061 14657061 PRJNA661142_P_NODE_11692_length_166_cov_0.871795_g11627_i0 PRJNA661142 11692 166 0.871795 1.4471797 Thermoplasmata archaeon 1906666 Archaea Archaea 112 2.4199999999999998e-27   NR MEM4728365.1 1906666 g11627 i0 87.3 1.98795180722892 55 7 99.4 0 165 1 215 269 MEM4728365.1 cysteine--tRNA ligase [Thermoplasmata archaeon] diamond 330 112 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
27144176 27144176 PRJNA661142_P_NODE_11402_length_167_cov_0.864407_g11337_i0 PRJNA661142 11402 167 0.864407 1.44355969 Thermoplasmata archaeon 1906666 Archaea Archaea 90.9 1.56e-20   NR HEV8594469.1 1906666 g11337 i0 79.6 0.970059880239521 54 11 97 0 166 5 27 80 HEV8594469.1 class I SAM-dependent methyltransferase [Thermoplasmata archaeon] diamond 162 90.9 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29134248 29134248 PRJNA661142_P_NODE_12289_length_163_cov_0.894737_g12224_i0 PRJNA661142 12289 163 0.894737 1.45842131 Thermoplasmata archaeon 1906666 Archaea Archaea 77.4 7.61e-15   NR RLF33979.1 1906666 g12224 i0 68.5 0.993865030674847 54 17 99.4 0 162 1 402 455 RLF33979.1 MAG: hypothetical protein DRN08_05045, partial [Thermoplasmata archaeon] diamond 162 77.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30460976 30460976 PRJNA661142_P_NODE_11993_length_164_cov_0.886957_g11928_i0 PRJNA661142 11993 164 0.886957 1.45460948 Thermoplasmata archaeon 1906666 Archaea Archaea 55.5 4.16e-7   NR UCC92922.1 1906666 g11928 i0 49 0.896341463414634 49 25 89.6 0 17 163 1830 1878 UCC92922.1 MAG: PKD domain-containing protein [Thermoplasmata archaeon] diamond 147 55.5 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
32831047 32831047 PRJNA661142_P_NODE_12040_length_164_cov_0.886957_g11975_i0 PRJNA661142 12040 164 0.886957 1.45460948 Thermoplasmatales archaeon 2268204 Archaea Archaea 112 4.3e-28   NR MBP1662522.1 2268204 g11975 i0 98.1 0.969512195121951 53 1 97 0 4 162 141 193 MBP1662522.1 glycosyltransferase [Thermoplasmatales archaeon] diamond 159 112 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales 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);;