RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1063685" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJNA1063685 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
24405438 24405438 PRJNA1063685_S_NODE_2520_length_851_cov_20.982005_g2157_i0 PRJNA1063685 2520 851 20.982005 178.55686255 Deinococcus peraridilitoris 432329 Bacteria Bacteria 377 9.91e-127   NR WP_085931722.1 432329 g2157 i0 71.6 0.90599294947121 257 73 90.6 0 830 60 148 404 WP_085931722.1 acyl-CoA dehydrogenase family protein [Deinococcus peraridilitoris] diamond 771 377 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
27320061 27320061 PRJNA1063685_S_NODE_19803_length_511_cov_12.796804_g19265_i0 PRJNA1063685 19803 511 12.796804 65.39166844 Deinococcus sp. 47478 Bacteria Bacteria 161 3.94e-46   NR MDO4263478.1 47478 g19265 i0 58 3.70450097847358 157 57 92.2 3 488 18 96 243 MDO4263478.1 DUF4388 domain-containing protein [Deinococcus sp.] diamond 1893 161 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
32406725 32406725 PRJNA1063685_S_NODE_16899_length_541_cov_2.014957_g16367_i0 PRJNA1063685 16899 541 2.014957 10.90091737 Thermovirga lienii 336261 Bacteria Bacteria 131 6.4e-35   NR WP_334139740.1 336261 g16367 i0 51.2 1.40850277264325 127 60 70.4 1 435 55 6 130 WP_334139740.1 ribonuclease HI family protein [Thermovirga lienii] diamond 762 131 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Thermovirgaceae Thermovirga Thermovirga lienii

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