RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA781196", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 3 ✖

tax_kingdom 1

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA781196 · 3 ✖

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
16061823 16061823 PRJNA781196_P_NODE_39873_length_283_cov_1.671429_g39496_i0 PRJNA781196 39873 283 1.671429 4.73014407 Desulfovibrionales bacterium 2448050 Bacteria Bacteria 118 2.01e-29   NR MDK2957425.1 2448050 g39496 i0 65.6 2.87279151943463 90 31 95.4 0 275 6 207 296 MDK2957425.1 ammonium transporter, Amt family [Desulfovibrionales bacterium] diamond 813 118 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales     Desulfovibrionales bacterium
26705087 26705087 PRJNA781196_P_NODE_37401_length_291_cov_1.431193_g37024_i0 PRJNA781196 37401 291 1.431193 4.16477163 Desulfatitalea sp. BRH_c12 1629708 Bacteria Bacteria 45.8 0.00211   NR KJS31168.1 1629708 g37024 i0 40.8 0.505154639175258 49 29 50.5 0 257 111 24 72 KJS31168.1 MAG: hypothetical protein VR64_12660 [Desulfatitalea sp. BRH_c12] diamond 147 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfatitalea Desulfatitalea sp. BRH_c12
28379973 28379973 PRJNA781196_P_NODE_56786_length_249_cov_0.886364_g56409_i0 PRJNA781196 56786 249 0.886364 2.20704636 Desulforegula conservatrix 153026 Bacteria Bacteria 48.1 4.88e-4   NR WP_027360420.1 153026 g56409 i0 40.4 2.16867469879518 52 31 62.7 0 89 244 22 73 WP_027360420.1 aldehyde dehydrogenase family protein [Desulforegula conservatrix] diamond 540 48.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulforegulaceae Desulforegula Desulforegula conservatrix

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);;