RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA811725" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA811725 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
21212117 21212117 PRJNA811725_P_NODE_27117_length_296_cov_4.686099_g26871_i0 PRJNA811725 27117 296 4.686099 13.87085304 Thermus sp. 275 Bacteria Bacteria 186 5.09e-56   NR WP_370532954.1 275 g26871 i0 90.6 1.07432432432432 106 2 99.3 1 1 294 41 146 WP_370532954.1 UDP-N-acetylglucosamine--N-acetylmuramyl-(pentapeptide) pyrophosphoryl-undecaprenol N-acetylglucosamine transferase [Thermus sp.] diamond 318 186 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp.
27528174 27528174 PRJNA811725_P_NODE_19503_length_343_cov_6.507407_g19257_i0 PRJNA811725 19503 343 6.507407 22.32040601 Deinococcus carri 1211323 Bacteria Bacteria 53.1 6.27e-7   NR GAA5514291.1 1211323 g19257 i0 88.9 0.236151603498542 27 3 23.6 0 81 1 1 27 GAA5514291.1 hypothetical protein Dcar01_03046 [Deinococcus carri] diamond 81 53.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus carri
28728060 28728060 PRJNA811725_P_NODE_15947_length_378_cov_2.662295_g15701_i0 PRJNA811725 15947 378 2.662295 10.0634751 Deinococcus antarcticus 1298767 Bacteria Bacteria 106 6.97e-24   NR WP_380080740.1 1298767 g15701 i0 95.1 0.650793650793651 82 4 65.1 0 377 132 320 401 WP_380080740.1 DUF937 domain-containing protein [Deinococcus antarcticus] diamond 246 106 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
29391213 29391213 PRJNA811725_P_NODE_32049_length_275_cov_1.292079_g31803_i0 PRJNA811725 32049 275 1.292079 3.55321725 Deinococcus sp. YIM 134 47478 Bacteria Bacteria 43.5 0.0287   NR WP_331826078.1 3118910 g31803 i0 43.1 0.632727272727273 58 26 63.3 2 32 205 105 155 WP_331826078.1 sugar ABC transporter ATP-binding protein [Deinococcus sp. YIM 134068] diamond 174 43.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus lichenicola
29674933 29674933 PRJNA811725_P_NODE_31930_length_276_cov_0.891626_g31684_i0 PRJNA811725 31930 276 0.891626 2.46088776 Truepera radiovictrix 332249 Bacteria Bacteria 90.1 2.62e-20   NR WP_041947187.1 332249 g31684 i0 85.7 0.532608695652174 49 7 53.3 0 129 275 1 49 WP_041947187.1 orotate phosphoribosyltransferase [Truepera radiovictrix] diamond 147 90.1 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
31855845 31855845 PRJNA811725_P_NODE_30097_length_284_cov_1.218009_g29851_i0 PRJNA811725 30097 284 1.218009 3.45914556 Truepera radiovictrix 332249 Bacteria Bacteria 114 1.43e-27   NR WP_013179371.1 332249 g29851 i0 68.4 1.00352112676056 95 29 99.3 1 283 2 317 411 WP_013179371.1 aspartate aminotransferase family protein [Truepera radiovictrix] diamond 285 114 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix

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