RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA927284" 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

  • PRJNA927284 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
1252584 1252584 PRJNA927284_P_NODE_6741_length_200_cov_2.058480_g6534_i0 PRJNA927284 6741 200 2.05848 4.11696 Deinococcus 1298 Bacteria Bacteria 368 1.52e-97   NTclustered gi|2113031129|gb|OK500351.1| 47478 g6534 i0 100 103.48 199 0 99 0 1 199 479 677 Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence blastn 20696 368 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
16204859 16204859 PRJNA927284_P_NODE_7313_length_187_cov_2.056962_g7106_i0 PRJNA927284 7313 187 2.056962 3.84651894 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 324 3.07e-84   NTclustered gi|821341785|gb|CP011389.1| 1309411 g7106 i0 97.861 262.427807486631 187 4 100 0 1 187 1637491 1637677 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 49074 324 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
18753444 18753444 PRJNA927284_P_NODE_6315_length_212_cov_1.743169_g6108_i0 PRJNA927284 6315 212 1.743169 3.69551828 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 387 4.5e-103   NTclustered gi|821341785|gb|CP011389.1| 1309411 g6108 i0 99.528 218.867924528302 212 1 100 0 1 212 1637486 1637275 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 46400 387 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)

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