RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA980587" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA980587 · 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
29741694 29741694 PRJNA980587_P_NODE_83250_length_248_cov_0.880000_g82457_i0 PRJNA980587 83250 248 0.88 2.1824 Thermosipho sp. (in: thermotogales) 1968895 Bacteria Bacteria 67 4.16e-11   NR MBO8139004.1 1968895 g82457 i0 47.4 1.875 78 38 93.1 2 8 238 125 200 MBO8139004.1 diaminopimelate epimerase [Thermosipho sp. (in: thermotogales)] diamond 465 67 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho sp. (in: thermotogales)
31163383 31163383 PRJNA980587_P_NODE_85335_length_247_cov_0.885057_g84542_i0 PRJNA980587 85335 247 0.885057 2.18609079 Fretibacterium sp. 2699746 Bacteria Bacteria 43.1 0.0282   NR MBQ9526865.1 2699746 g84542 i0 41.2 0.619433198380567 51 29 61.9 1 197 45 281 330 MBQ9526865.1 DUF3536 domain-containing protein [Fretibacterium sp.] diamond 153 43.1 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium sp.
31643980 31643980 PRJNA980587_P_NODE_53536_length_313_cov_1.587500_g52743_i0 PRJNA980587 53536 313 1.5875 4.968875 PVC group 1783257 Bacteria Bacteria 167 1.1599999999999999e-47   NR WP_350243929.1 309891 g52743 i0 73.5 65.4153354632588 102 27 97.8 0 308 3 181 282 WP_350243929.1 acyl-CoA dehydrogenase [Deinococcus sonorensis] diamond 20475 167 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sonorensis
32087091 32087091 PRJNA980587_P_NODE_82018_length_249_cov_0.875000_g81225_i0 PRJNA980587 82018 249 0.875 2.17875 Bacteria 2 Bacteria Bacteria 117 1.14e-29   NR WP_027463593.1 317577 g81225 i0 69.5 8.89156626506024 82 24 98.8 1 3 248 237 317 WP_027463593.1 malate dehydrogenase [Deinococcus ficus] diamond 2214 117 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus

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