RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB2368 · 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
27722165 27722165 PRJEB2368_P_NODE_15764_length_152_cov_1.365217_g15445_i0 PRJEB2368 15764 152 1.365217 2.07512984 Eukaryota 2759 Plants Plants 61.6 2.32e-9   NR PTQ32829.1 3197 g15445 i0 60 63.0789473684211 50 20 98.7 0 150 1 207 256 PTQ32829.1 hypothetical protein MARPO_0094s0010 [Marchantia polymorpha] diamond 9588 62 0.993548387096774 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Marchantiaceae Marchantia Marchantia polymorpha
29047993 29047993 PRJEB2368_P_NODE_15568_length_153_cov_2.094828_g15249_i0 PRJEB2368 15568 153 2.094828 3.20508684 Closterium 34145 Plants Plants 54.3 7.61e-7   NR CAI5488445.1 2996811 g15249 i0 49 3.84313725490196 49 25 96.1 0 147 1 86 134 CAI5488445.1 unnamed protein product [Closterium sp. Naga37s-1] diamond 588 54.7 0.992687385740402 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. Naga37s-1
32720018 32720018 PRJEB2368_P_NODE_12740_length_196_cov_1.798742_g12421_i0 PRJEB2368 12740 196 1.798742 3.5255343200000002 Klebsormidium nitens 105231 Plants Plants 64.7 2.73e-10   NR GAQ78914.1 105231 g12421 i0 47.6 0.964285714285714 63 33 96.4 0 7 195 192 254 GAQ78914.1 hypothetical protein KFL_000200670 [Klebsormidium nitens] diamond 189 64.7 1 Eukaryota   Viridiplantae Streptophyta Klebsormidiophyceae Klebsormidiales Klebsormidiaceae Klebsormidium Klebsormidium nitens

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