RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1086823", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 3 ✖

tax_phylum 1

  • Thermoproteota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1086823 · 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
5296592 5296592 PRJNA1086823_P_NODE_2305_length_498_cov_1.101176_g2188_i0 PRJNA1086823 2305 498 1.101176 5.48385648 uncultured crenarchaeote 29281 Archaea Archaea 713 0   NTclustered gi|22797874|emb|AJ496176.1| 29281 g2188 i0 92.57 135.471887550201 498 35 100 2 1 498 6884 7379 Uncultured crenarchaeote 34 kb genomic fragment blastn 67465 713 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
27888661 27888661 PRJNA1086823_P_NODE_3585_length_410_cov_1.246291_g3468_i0 PRJNA1086823 3585 410 1.246291 5.1097931 Thermoproteota archaeon 2056631 Archaea Archaea 53.9 2.49e-6   NR NLE06965.1 2056631 g3468 i0 39.3 0.446341463414634 61 25 37.3 2 409 257 13 71 NLE06965.1 hypothetical protein [Thermoproteota archaeon] diamond 183 53.9 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32628094 32628094 PRJNA1086823_P_NODE_6880_length_312_cov_2.640167_g6763_i0 PRJNA1086823 6880 312 2.640167 8.23732104 Thermoproteota archaeon 2056631 Archaea Archaea 90.9 8.290000000000001e-21   NR NLE06972.1 2056631 g6763 i0 100 0.471153846153846 49 0 47.1 0 312 166 92 140 NLE06972.1 hypothetical protein [Thermoproteota archaeon] diamond 147 90.9 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota 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);;