RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA493632" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493632 · 6 ✖

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
28750436 28750436 PRJNA493632_P_NODE_706187_length_224_cov_6.364238_g702746_i0 PRJNA493632 706187 224 6.364238 14.25589312 Fervidobacterium sp. 1871331 Bacteria Bacteria 88.6 3.39e-20   NR HOH54357.1 1871331 g702746 i0 91.8 1.96875 49 4 65.6 0 147 1 92 140 HOH54357.1 phosphatidate cytidylyltransferase [Fervidobacterium sp.] diamond 441 88.6 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
29633942 29633942 PRJNA493632_P_NODE_179990_length_360_cov_0.961672_g176562_i0 PRJNA493632 179990 360 0.961672 3.4620192 Mesotoga prima 1184387 Bacteria Bacteria 75.1 2.02e-14   NR WP_333641476.1 1184387 g176562 i0 38.9 0.9 108 65 89.2 1 357 37 30 137 WP_333641476.1 hypothetical protein [Mesotoga prima] diamond 324 75.1 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae Mesotoga Mesotoga prima
30266497 30266497 PRJNA493632_P_NODE_528112_length_250_cov_0.870056_g524673_i0 PRJNA493632 528112 250 0.870056 2.17514 Petrotoga olearia 156203 Bacteria Bacteria 112 3.08e-29   NR WP_103066255.1 156203 g524673 i0 100 0.672 56 0 67.2 0 168 1 1 56 WP_103066255.1 HTH domain-containing protein [Petrotoga olearia] diamond 168 112 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Petrotoga Petrotoga olearia
30377206 30377206 PRJNA493632_P_NODE_705052_length_225_cov_11.973684_g701611_i0 PRJNA493632 705052 225 11.973684 26.940789 Bacteria 2 Bacteria Bacteria 67.8 4.28e-11   NR WP_103077549.1 204046 g701611 i0 43.6 6.05333333333333 78 37 97.3 3 2 220 248 323 WP_103077549.1 LytS/YhcK type 5TM receptor domain-containing protein [Petrotoga mexicana] diamond 1362 68.2 0.994134897360704 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Petrotoga Petrotoga mexicana
31498829 31498829 PRJNA493632_P_NODE_393736_length_273_cov_2.710000_g390297_i0 PRJNA493632 393736 273 2.71 7.3983 Fervidobacterium sp. 1871331 Bacteria Bacteria 187 1.3599999999999998e-56   NR MEN6590164.1 1871331 g390297 i0 98.9 0.989010989010989 90 1 98.9 0 2 271 5 94 MEN6590164.1 ABC transporter ATP-binding protein [Fervidobacterium sp.] diamond 270 187 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
32067980 32067980 PRJNA493632_P_NODE_375138_length_277_cov_2.598039_g371699_i0 PRJNA493632 375138 277 2.598039 7.19656803 Fervidobacterium sp. 1871331 Bacteria Bacteria 192 2.0500000000000002e-59   NR HCI29463.1 1871331 g371699 i0 95.6 3.94223826714801 91 4 98.6 0 275 3 161 251 HCI29463.1 phosphohydrolase [Fervidobacterium sp.] diamond 1092 192 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);;