RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA980585" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA980585 · 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
7332475 7332475 PRJNA980585_P_NODE_29726_length_280_cov_1.487923_g29472_i0 PRJNA980585 29726 280 1.487923 4.1661844 root 1 Root_unresolved Root_unresolved 97.4 7.6e-22   NR WP_125740732.1 498846 g29472 i0 55.4 18.7071428571429 92 41 98.6 0 280 5 79 170 WP_125740732.1 glyoxylate reductase [Candidatus Korarchaeum cryptofilum] diamond 5238 97.8 0.995910020449898 Archaea   Thermoproteati Thermoproteota Candidatus Korarchaeia Candidatus Korarchaeales Candidatus Korarchaeaceae Candidatus Korarchaeum Candidatus Korarchaeum cryptofilum
28889321 28889321 PRJNA980585_P_NODE_21608_length_314_cov_1.278008_g21354_i0 PRJNA980585 21608 314 1.278008 4.01294512 Desulfurococcales archaeon 2480821 Archaea Archaea 52.4 3.45e-6   NR MCE4621427.1 2480821 g21354 i0 34.4 5.37898089171975 93 58 86.9 2 10 282 5 96 MCE4621427.1 DNA-binding protein Alba [Desulfurococcales archaeon] diamond 1689 52.4 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales     Desulfurococcales archaeon
30784462 30784462 PRJNA980585_P_NODE_23574_length_303_cov_1.339130_g23320_i0 PRJNA980585 23574 303 1.33913 4.0575639 Thermoproteales archaeon 2268205 Archaea Archaea 45.8 0.00458   NR MCD6369239.1 2268205 g23320 i0 31.3 1.96039603960396 99 51 98 2 3 299 11 92 MCD6369239.1 hypothetical protein [Thermoproteales archaeon] diamond 594 45.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales     Thermoproteales archaeon
31258458 31258458 PRJNA980585_P_NODE_3815_length_633_cov_1.783929_g3561_i0 PRJNA980585 3815 633 1.783929 11.29227057 Thermoproteota archaeon 2056631 Archaea Archaea 50.8 0.00175   NR MEM3426583.1 2056631 g3561 i0 33.3 0.625592417061611 132 73 57.3 7 367 5 584 711 MEM3426583.1 C10 family peptidase [Thermoproteota archaeon] diamond 396 50.8 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);;