RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA280983" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA280983 · 3 ✖

analysis 1

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
28527065 28527065 PRJNA280983_P_NODE_8027_length_197_cov_5.750000_g7912_i0 PRJNA280983 8027 197 5.75 11.3275 Ignisphaera sp. 2268142 Archaea Archaea 42 0.0389   NR MCI4436824.1 2268142 g7912 i0 47.4 0.578680203045685 38 20 57.9 0 186 73 963 1000 MCI4436824.1 hypothetical protein [Ignisphaera sp.] diamond 114 42 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
29379342 29379342 PRJNA280983_P_NODE_3489_length_364_cov_1.231746_g3374_i0 PRJNA280983 3489 364 1.231746 4.48355544 Methanocorpusculum vombati 3002864 Archaea Archaea 45.1 0.0199   NR WP_268923252.1 3002864 g3374 i0 30.4 0.923076923076923 112 57 84.9 6 15 323 45 144 WP_268923252.1 ammonium transporter [Methanocorpusculum vombati] diamond 336 45.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanocorpusculaceae Methanocorpusculum Methanocorpusculum vombati
31211069 31211069 PRJNA280983_P_NODE_9875_length_167_cov_0.864407_g9760_i0 PRJNA280983 9875 167 0.864407 1.44355969 archaeon 1906665 Archaea Archaea 80.1 9.36e-17   NR MDP1729144.1 1906665 g9760 i0 72 0.898203592814371 50 14 89.8 0 166 17 153 202 MDP1729144.1 DNA methyltransferase [archaeon] diamond 150 80.1 1 Archaea               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);;