RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB7799 · 3 ✖

analysis 1

  • diamond · 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
25752753 25752753 PRJEB7799a_S_NODE_178_length_609_cov_6.254355_g155_i0 PRJEB7799 178 609 6.254355 38.08902195 Deinococcus sp. 47478 Bacteria Bacteria 281 7.43e-94   NR WP_310584664.1 47478 g155 i0 76.8 0.891625615763547 181 40 89.2 2 592 50 1 179 WP_310584664.1 PEP-CTERM sorting domain-containing protein [Deinococcus sp.] diamond 543 281 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
26481206 26481206 PRJEB7799n_S_NODE_9408_length_167_cov_1.386364_g9371_i0 PRJEB7799 9408 167 1.386364 2.31522788 Thermus brevis 2862456 Bacteria Bacteria 72 6.64e-14   NR MBW6394558.1 2862456 g9371 i0 70.9 0.988023952095808 55 16 98.8 0 167 3 89 143 MBW6394558.1 CatB-related O-acetyltransferase [Thermus brevis] diamond 165 72 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brevis
33151683 33151683 PRJEB7799a_S_NODE_11048_length_179_cov_1.763889_g11013_i0 PRJEB7799 11048 179 1.763889 3.15736131 Deinococcus misasensis 392413 Bacteria Bacteria 58.5 9.9e-10   NR WP_157442767.1 392413 g11013 i0 97.1 0.569832402234637 34 1 57 0 178 77 25 58 WP_157442767.1 hypothetical protein [Deinococcus misasensis] diamond 102 58.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis

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