RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA908278", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 4 ✖

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJNA908278 · 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
27245609 27245609 PRJNA908278_P_NODE_21183_length_281_cov_1.466346_g21080_i0 PRJNA908278 21183 281 1.466346 4.12043226 Candidatus Poseidoniaceae archaeon 2666346 Archaea Archaea 55.1 7.65e-7   NR MDP6863872.1 2666346 g21080 i0 32.9 2.71174377224199 85 55 90.7 1 12 266 66 148 MDP6863872.1 PAC2 family protein [Candidatus Poseidoniaceae archaeon] diamond 762 55.1 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae   Candidatus Poseidoniaceae archaeon
29234994 29234994 PRJNA908278_P_NODE_11589_length_361_cov_1.604167_g11486_i0 PRJNA908278 11589 361 1.604167 5.79104287 Thermoplasmatota archaeon 2806419 Archaea Archaea 105 1.37e-24   NR MEE2986083.1 2806419 g11486 i0 44.2 2.96675900277008 120 66 99.7 1 1 360 5 123 MEE2986083.1 NAD-dependent epimerase/dehydratase family protein [Thermoplasmatota archaeon] diamond 1071 105 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
29581912 29581912 PRJNA908278_P_NODE_13830_length_336_cov_1.482890_g13727_i0 PRJNA908278 13830 336 1.48289 4.9825104 Candidatus Thalassarchaeaceae archaeon 2670411 Archaea Archaea 45.1 0.0162   NR MDP6328880.1 2670411 g13727 i0 48.8 2.08035714285714 41 21 36.6 0 73 195 12 52 MDP6328880.1 SAP domain-containing protein [Candidatus Thalassarchaeaceae archaeon] diamond 699 45.1 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Thalassarchaeaceae   Candidatus Thalassarchaeaceae archaeon
32781484 32781484 PRJNA908278_P_NODE_32280_length_245_cov_0.895349_g32177_i0 PRJNA908278 32280 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 47.4 9.16e-4   NR MCK5309863.1 1906666 g32177 i0 48.3 3.63673469387755 60 22 62.4 2 197 45 157 216 MCK5309863.1 FG-GAP repeat protein [Thermoplasmata archaeon] diamond 891 47.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata 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);;