RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1136505" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA1136505 · 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
6662357 6662357 PRJNA1136505_P_NODE_36946_length_571_cov_2.248996_g30118_i0 PRJNA1136505 36946 571 2.248996 12.84176716 Bacteria 2 Bacteria Bacteria 301 2.36e-98   NR WP_013704011.1 186192 g30118 i0 76.8 33.9824868651489 190 43 99.8 1 2 571 69 257 WP_013704011.1 isocitrate lyase [Marinithermus hydrothermalis] diamond 19404 301 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Marinithermus Marinithermus hydrothermalis
15059660 15059660 PRJNA1136505_P_NODE_131812_length_250_cov_1.740113_g124952_i0 PRJNA1136505 131812 250 1.740113 4.3502825 Deinococcus 1298 Bacteria Bacteria 244 3.48e-60   NTclustered gi|2155018471|emb|OV024757.1| 1299 g124952 i0 84.836 17.176 244 35 97 2 8 250 2201798 2202040 Deinococcus radiodurans isolate DRR11 genome assembly, chromosome: 1 blastn 4294 244 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans
31418222 31418222 PRJNA1136505_P_NODE_84776_length_316_cov_1.329218_g77916_i0 PRJNA1136505 84776 316 1.329218 4.20032888 Bacteria 2 Bacteria Bacteria 70.5 6.44e-12   NR MDZ7703424.1 2026798 g77916 i0 32.7 1.9746835443038 104 67 98.7 1 3 314 83 183 MDZ7703424.1 TspO/MBR family protein [Trueperaceae bacterium] diamond 624 70.5 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
31608038 31608038 PRJNA1136505_P_NODE_154316_length_241_cov_1.375000_g147456_i0 PRJNA1136505 154316 241 1.375 3.31375 Bacteria 2 Bacteria Bacteria 138 2.04e-38   NR MCA9836620.1 2026798 g147456 i0 83.5 2.95020746887967 79 13 98.3 0 239 3 146 224 MCA9836620.1 SDR family oxidoreductase [Trueperaceae bacterium] diamond 711 139 0.992805755395683 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium

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