RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA760904", tax_kingdom = "Thermotogati" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 2 ✖

tax_kingdom 1

  • Thermotogati · 2 ✖

bioproject 1

  • PRJNA760904 · 2 ✖

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
30464259 30464259 PRJNA760904_P_NODE_13753_length_257_cov_2.217391_g13696_i0 PRJNA760904 13753 257 2.217391 5.69869487 Mesotoga sp. 2053577 Bacteria Bacteria 84.7 2.63e-18   NR HRV01955.1 2053577 g13696 i0 51.9 0.898832684824903 77 34 89.9 1 232 2 2 75 HRV01955.1 C39 family peptidase [Mesotoga sp.] diamond 231 84.7 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae Mesotoga Mesotoga sp.
32456125 32456125 PRJNA760904_P_NODE_1139_length_719_cov_32.992260_g1086_i0 PRJNA760904 1139 719 32.99226 237.2143494 Thermotogaceae bacterium 2268206 Bacteria Bacteria 72.4 2.84e-12   NR MCD6449480.1 2268206 g1086 i0 40.6 0.442280945757997 106 58 43.8 3 542 228 14 115 MCD6449480.1 Hsp20/alpha crystallin family protein [Thermotogaceae bacterium] diamond 318 72.4 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae 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);;