RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA591127" 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

  • PRJNA591127 · 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
27504143 27504143 PRJNA591127_P_NODE_30703_length_151_cov_2.631579_g30534_i0 PRJNA591127 30703 151 2.631579 3.97368429 Bacteria 2 Bacteria Bacteria 46.6 4.64e-4   NR MCL4454784.1 47478 g30534 i0 96 41.8609271523179 25 1 49.7 0 1 75 10 34 MCL4454784.1 nitronate monooxygenase [Deinococcus sp.] diamond 6321 47 0.991489361702128 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
28627395 28627395 PRJNA591127_P_NODE_14107_length_197_cov_5.025000_g13938_i0 PRJNA591127 14107 197 5.025 9.89925 Fervidobacterium sp. 1871331 Bacteria Bacteria 55.5 6.43e-7   NR HOA17490.1 1871331 g13938 i0 100 0.365482233502538 24 0 36.5 0 195 124 317 340 HOA17490.1 dihydroorotase [Fervidobacterium sp.] diamond 72 55.5 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
32306476 32306476 PRJNA591127_P_NODE_29239_length_151_cov_4.263158_g29070_i0 PRJNA591127 29239 151 4.263158 6.43736858 Thermotogales 2419 Bacteria Bacteria 54.3 4.48e-7   NR HRT01669.1 1871331 g29070 i0 100 1.90728476821192 24 0 47.7 0 74 3 52 75 HRT01669.1 DNA-processing protein DprA [Fervidobacterium sp.] diamond 288 54.3 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium 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);;