RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA737474", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Thermoproteota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA737474 · 4 ✖

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
32937537 32937537 PRJNA737474g_S_NODE_223633_length_271_cov_0.792929_g222339_i0 PRJNA737474 223633 271 0.792929 2.14883759 Metallosphaera yellowstonensis 1111107 Archaea Archaea 41.6 0.0392   NR WP_048087991.1 1111107 g222339 i0 46.5 0.476014760147601 43 23 47.6 0 131 3 39 81 WP_048087991.1 helix-turn-helix domain-containing protein [Metallosphaera yellowstonensis] diamond 129 41.6 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Metallosphaera Metallosphaera yellowstonensis
32954884 32954884 PRJNA737474g_S_NODE_247978_length_264_cov_1.602094_g246684_i0 PRJNA737474 247978 264 1.602094 4.22952816 Thermoproteota archaeon 2056631 Archaea Archaea 127 2.05e-32   NR MEM3368555.1 2056631 g246684 i0 95.5 0.761363636363636 67 3 76.1 0 2 202 10 76 MEM3368555.1 hypothetical protein [Thermoproteota archaeon] diamond 201 127 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33074059 33074059 PRJNA737474g_S_NODE_233501_length_268_cov_1.102564_g232207_i0 PRJNA737474 233501 268 1.102564 2.95487152 Thermoproteota archaeon 2056631 Archaea Archaea 172 1.0499999999999999e-47   NR MEM3368556.1 2056631 g232207 i0 98.9 0.985074626865672 88 1 98.5 0 266 3 1203 1290 MEM3368556.1 hypothetical protein [Thermoproteota archaeon] diamond 264 172 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33107653 33107653 PRJNA737474f_S_NODE_46422_length_347_cov_2.937956_g45744_i0 PRJNA737474 46422 347 2.937956 10.19470732 Zestosphaera sp. 2303494 Archaea Archaea 157 1.8e-43   NR MFN3268367.1 2303494 g45744 i0 73.6 0.951008645533141 110 29 95.1 0 18 347 56 165 MFN3268367.1 RNA-guided endonuclease InsQ/TnpB family protein [Zestosphaera sp.] diamond 330 157 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Zestosphaera Zestosphaera sp.

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);;