RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA737474" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA737474 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
33057210 33057210 PRJNA737474g_S_NODE_308573_length_252_cov_1.111732_g307279_i0 PRJNA737474 308573 252 1.111732 2.80156464 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 76.3 6.22e-14   NR MDX1419746.1 2838334 g307279 i0 47.6 0.976190476190476 82 43 97.6 0 247 2 309 390 MDX1419746.1 hypothetical protein [Rubricoccaceae bacterium] diamond 246 76.3 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae bacterium
33074009 33074009 PRJNA737474g_S_NODE_219373_length_272_cov_1.005025_g218079_i0 PRJNA737474 219373 272 1.005025 2.733668 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 86.7 4.59e-19   NR HLT46636.1 2838334 g218079 i0 69.5 0.650735294117647 59 18 65.1 0 96 272 1 59 HLT46636.1 CsgE family curli-type amyloid fiber assembly protein [Rubricoccaceae bacterium] diamond 177 86.7 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae bacterium
33107514 33107514 PRJNA737474f_S_NODE_27054_length_409_cov_1.360119_g26377_i0 PRJNA737474 27054 409 1.360119 5.56288671 Rhodothermales bacterium 2306054 Bacteria Bacteria 84.3 2.37e-16   NR MFT5129960.1 2306054 g26377 i0 41.8 1.63569682151589 110 62 79.2 1 408 85 90 199 MFT5129960.1 tagatose 6-phosphate kinase [Rhodothermales bacterium] diamond 669 84.3 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales     Rhodothermales bacterium

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