RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA635874" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA635874 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
5711999 5711999 PRJNA635874_P_NODE_73985_length_241_cov_0.910714_g73838_i0 PRJNA635874 73985 241 0.910714 2.19482074 Deinococcus 1298 Bacteria Bacteria 132 7.62e-34   NR WP_103130574.1 200253 g73838 i0 79.7 2.95020746887967 79 16 98.3 0 3 239 227 305 WP_103130574.1 helicase-related protein [Deinococcus aerius] diamond 711 132 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aerius
28880922 28880922 PRJNA635874_P_NODE_71248_length_242_cov_0.911243_g71101_i0 PRJNA635874 71248 242 0.911243 2.20520806 Deinococcus xinjiangensis 457454 Bacteria Bacteria 43.9 0.00768   NR WP_353542388.1 457454 g71101 i0 42.3 1.61157024793388 71 26 88 1 216 4 4 59 WP_353542388.1 hypothetical protein [Deinococcus xinjiangensis] diamond 390 43.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus xinjiangensis
29733283 29733283 PRJNA635874_P_NODE_57850_length_247_cov_0.885057_g57703_i0 PRJNA635874 57850 247 0.885057 2.18609079 Deinococcus sp. 47478 Bacteria Bacteria 94.7 4.89e-21   NR MDO4263433.1 47478 g57703 i0 57 5.75708502024291 79 34 96 0 7 243 227 305 MDO4263433.1 alpha/beta fold hydrolase [Deinococcus sp.] diamond 1422 94.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
30030374 30030374 PRJNA635874_P_NODE_62791_length_245_cov_0.895349_g62644_i0 PRJNA635874 62791 245 0.895349 2.19360505 Deinococcus 1298 Bacteria Bacteria 117 4.13e-29   NR UID71601.1 243230 g62644 i0 78.2 1.91020408163265 78 17 95.5 0 240 7 66 143 UID71601.1 cobalamin biosynthesis protein CbiX [Deinococcus radiodurans R1 = ATCC 13939 = DSM 20539] diamond 468 118 0.991525423728814 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans

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