RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA766854", tax_phylum = "Thermotogota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Thermotogota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA766854 · 4 ✖

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
11409776 11409776 PRJNA766854_P_NODE_1549_length_333_cov_3.282895_g1424_i0 PRJNA766854 1549 333 3.282895 10.93204035 Fervidobacteriaceae 1643950 Bacteria Bacteria 122 2.3599999999999998e-23   NTclustered gi|61657861|emb|AJ876542.1| 2424 g1424 i0 94.872 46 78 4 44 0 256 333 96 19 Fervidobacterium nodosum partial 23S rRNA gene blastn 15318 122 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium nodosum
18596652 18596652 PRJNA766854_P_NODE_1615_length_326_cov_4.781145_g1490_i0 PRJNA766854 1615 326 4.781145 15.5865327 Thermosipho ferrireducens 2571116 Bacteria Bacteria 156 2.27e-33   NTclustered gi|2006729518|gb|CP071446.1| 2571116 g1490 i0 96.774 54.9110429447853 93 3 44 0 173 265 420069 420161 Thermosipho ferrireducens strain JL129W03 chromosome, complete genome blastn 17901 156 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho ferrireducens
19057699 19057699 PRJNA766854_P_NODE_1415_length_349_cov_2.856250_g1290_i0 PRJNA766854 1415 349 2.85625 9.9683125 Fervidobacterium 2422 Bacteria Bacteria 147 1.47e-30   NTclustered gi|2793125101|gb|CP126499.1| 2423 g1290 i0 97.674 47.4842406876791 86 0 45 2 3 87 1622366 1622282 Fervidobacterium islandicum strain H-21 chromosome, complete genome blastn 16572 147 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium islandicum
22422246 22422246 PRJNA766854_P_NODE_1598_length_328_cov_3.207358_g1473_i0 PRJNA766854 1598 328 3.207358 10.52013424 Fervidobacterium gondwanense 44754 Bacteria Bacteria 196 1.35e-45   NTclustered gi|2793121053|gb|CP126498.1| 44754 g1473 i0 90.26 93.8932926829268 154 9 77 5 3 153 973907 973757 Fervidobacterium gondwanense strain 13770 chromosome, complete genome blastn 30797 196 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium gondwanense

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