RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA558770", 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

  • PRJNA558770 · 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
27124231 27124231 PRJNA558770_P_NODE_324822_length_233_cov_7.570707_g322817_i0 PRJNA558770 324822 233 7.570707 17.63974731 Thermoproteati 1783275 Archaea Archaea 47.4 6.95e-5   NR MDQ5868552.1 2056631 g322817 i0 92 0.965665236051502 25 2 32.2 0 159 233 21 45 MDQ5868552.1 hypothetical protein [Thermoproteota archaeon] diamond 225 47.4 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27331956 27331956 PRJNA558770_P_NODE_229563_length_234_cov_2.819095_g227558_i0 PRJNA558770 229563 234 2.819095 6.5966823 Thermoproteota archaeon 2056631 Archaea Archaea 48.9 1.75e-4   NR MDQ5870269.1 2056631 g227558 i0 87.5 0.307692307692308 24 3 30.8 0 3 74 139 162 MDQ5870269.1 class I SAM-dependent methyltransferase [Thermoproteota archaeon] diamond 72 48.9 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28577233 28577233 PRJNA558770_P_NODE_176447_length_234_cov_4.819095_g174442_i0 PRJNA558770 176447 234 4.819095 11.2766823 Thermoproteati 1783275 Archaea Archaea 44.3 0.00879   NR MDQ3984143.1 2056631 g174442 i0 84 1.28205128205128 25 4 32.1 0 159 233 102 126 MDQ3984143.1 UDP-glucuronosyltransferase [Thermoproteota archaeon] diamond 300 44.7 0.991051454138702 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30963743 30963743 PRJNA558770_P_NODE_316334_length_233_cov_10.015152_g314329_i0 PRJNA558770 316334 233 10.015152 23.33530416 Thermoproteota archaeon 2056631 Archaea Archaea 53.5 1.12e-6   NR MEK6930753.1 2056631 g314329 i0 100 0.927038626609442 24 0 30.9 0 73 2 14 37 MEK6930753.1 ribonuclease HII [Thermoproteota archaeon] diamond 216 53.5 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);;