RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA853194" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA853194 · 4 ✖

analysis 1

  • diamond · 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
22516836 22516836 PRJNA853194_S_NODE_2838_length_1015_cov_165.473461_g2217_i0 PRJNA853194 2838 1015 165.473461 1679.55562915 Bacteria 2 Bacteria Bacteria 66.6 9.29e-9   NR MBK5100830.1 2049433 g2217 i0 32.7 1.86502463054187 162 88 45.5 6 7 468 64 212 MBK5100830.1 lysoplasmalogenase [Desulfobacteraceae bacterium] diamond 1893 66.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
28476202 28476202 PRJNA853194_S_NODE_16086_length_489_cov_1.980769_g14997_i0 PRJNA853194 16086 489 1.980769 9.68596041 Desulfobacterales bacterium 2044940 Bacteria Bacteria 70.9 8.41e-11   NR MEX1352018.1 2044940 g14997 i0 37.8 0.94478527607362 82 51 50.3 0 294 49 422 503 MEX1352018.1 pol polyprotein [Desulfobacterales bacterium] diamond 462 70.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32109793 32109793 PRJNA853194_S_NODE_8658_length_634_cov_20.081996_g7649_i0 PRJNA853194 8658 634 20.081996 127.31985464 Desulfobacterales bacterium 2044940 Bacteria Bacteria 76.6 8.13e-13   NR MDX9788230.1 2044940 g7649 i0 31.1 2.59779179810726 164 102 74.3 3 11 481 78 237 MDX9788230.1 NRDE family protein [Desulfobacterales bacterium] diamond 1647 76.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32331656 32331656 PRJNA853194_S_NODE_73219_length_256_cov_4.202186_g72128_i0 PRJNA853194 73219 256 4.202186 10.75759616 Desulfobacteraceae bacterium 4572_35.1 1971627 Bacteria Bacteria 42.4 0.0426   NR OQY16268.1 1971627 g72128 i0 31.9 0.84375 72 49 84.4 0 15 230 70 141 OQY16268.1 MAG: tRNA glutamyl-Q(34) synthetase GluQRS, partial [Desulfobacteraceae bacterium 4572_35.1] diamond 216 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium 4572_35.1

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