RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA938397" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJNA938397 · 3 ✖

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
12735385 12735385 PRJNA938397_S_NODE_34030_length_189_cov_2.947368_g33789_i0 PRJNA938397 34030 189 2.947368 5.57052552 Deinococcus 1298 Bacteria Bacteria 294 2.44e-75   NTclustered gi|821341785|gb|CP011389.1| 1309411 g33789 i0 98.788 190.767195767196 165 2 87 0 25 189 1886175 1886011 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 36055 294 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
21658253 21658253 PRJNA938397_S_NODE_26837_length_213_cov_3.954545_g26596_i0 PRJNA938397 26837 213 3.954545 8.42318085 Deinococcus 1298 Bacteria Bacteria 394 2.7e-105   NTclustered gi|2113031129|gb|OK500351.1| 47478 g26596 i0 100 104 213 0 100 0 1 213 757 545 Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence blastn 22152 394 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
22589832 22589832 PRJNA938397_S_NODE_23778_length_226_cov_11.153439_g23537_i0 PRJNA938397 23778 226 11.153439 25.206772140000002 Deinococcus peraridilitoris 432329 Bacteria Bacteria 167 6.8799999999999995e-37   NTclustered gi|429128598|gb|CP003382.1| 937777 g23537 i0 81.991 73.2787610619469 211 24 89 10 2 202 1140572 1140366 Deinococcus peraridilitoris DSM 19664, complete genome blastn 16561 167 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris

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