RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA924320 · 4 ✖

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
22576192 22576192 PRJNA924320_S_NODE_24298_length_215_cov_1.843373_g24156_i0 PRJNA924320 24298 215 1.843373 3.96325195 Vulcanisaeta moutnovskia 985052 Archaea Archaea 52.8 0.019   NTclustered gi|323706731|gb|CP002529.1| 985053 g24156 i0 100 0.130232558139535 28 0 13 0 118 145 336100 336127 Vulcanisaeta moutnovskia 768-28, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Vulcanisaeta Vulcanisaeta moutnovskia
28667077 28667077 PRJNA924320_S_NODE_53307_length_163_cov_0.894737_g53165_i0 PRJNA924320 53307 163 0.894737 1.45842131 Thermofilum pendens 2269 Archaea Archaea 71.6 7.76e-13   NR WP_011752483.1 2269 g53165 i0 54.7 0.975460122699387 53 24 97.5 0 3 161 289 341 WP_011752483.1 proline--tRNA ligase [Thermofilum pendens] diamond 159 71.6 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermofilales Thermofilaceae Thermofilum Thermofilum pendens
29582248 29582248 PRJNA924320_S_NODE_49770_length_165_cov_0.879310_g49628_i0 PRJNA924320 49770 165 0.87931 1.4508615 Metallosphaera hakonensis 79601 Archaea Archaea 45.1 0.00193   NR WP_240938780.1 79601 g49628 i0 43.1 0.927272727272727 51 25 92.7 1 2 154 252 298 WP_240938780.1 diphosphomevalonate decarboxylase [Metallosphaera hakonensis] diamond 153 45.1 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Metallosphaera Metallosphaera hakonensis
31549178 31549178 PRJNA924320_S_NODE_7956_length_343_cov_2.081633_g7814_i0 PRJNA924320 7956 343 2.081633 7.14000119 root 1 Root_unresolved Root_unresolved 64.7 1.71e-9   NR MFP3144362.1 2060322 g7814 i0 39.6 2.7201166180758 106 52 87.5 4 26 325 186 285 MFP3144362.1 ABC transporter ATP-binding protein [Caldisphaera sp.] diamond 933 64.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Acidilobales Caldisphaeraceae Caldisphaera Caldisphaera 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);;