RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB56027" 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 · 3 ✖

bioproject 1

  • PRJEB56027 · 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
1398919 1398919 PRJEB56027_P_NODE_95742_length_274_cov_2.238806_g92933_i0 PRJEB56027 95742 274 2.238806 6.13432844 Deinococcus gobiensis 502394 Bacteria Bacteria 457 4.5599999999999985e-124   NTclustered gi|379998737|gb|CP002191.1| 745776 g92933 i0 96.715 29.4124087591241 274 9 100 0 1 274 926418 926145 Deinococcus gobiensis I-0, complete genome blastn 8059 457 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
29685831 29685831 PRJEB56027_P_NODE_76530_length_310_cov_2.987342_g73721_i0 PRJEB56027 76530 310 2.987342 9.2607602 Trueperaceae bacterium 2026798 Bacteria Bacteria 92.4 2.74e-19   NR HEX7023109.1 2026798 g73721 i0 64.9 1.18064516129032 74 26 71.6 0 310 89 86 159 HEX7023109.1 hypothetical protein [Trueperaceae bacterium] diamond 366 92.4 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
30381541 30381541 PRJEB56027_P_NODE_100893_length_267_cov_2.190722_g98084_i0 PRJEB56027 100893 267 2.190722 5.84922774 Deinococcus aluminii 1656885 Bacteria Bacteria 47.8 1.04e-4   NR WP_345454796.1 1656885 g98084 i0 55 0.449438202247191 40 18 44.9 0 122 3 1 40 WP_345454796.1 hypothetical protein [Deinococcus aluminii] diamond 120 47.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aluminii

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