RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA702290" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA702290 · 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
28199145 28199145 PRJNA702290_P_NODE_1746_length_157_cov_25.525424_g1738_i0 PRJNA702290 1746 157 25.525424 40.07491568 root 1 Root_unresolved Root_unresolved 47.8 1.09e-4   NR AGH30308.1 31302 g1738 i0 62.1 1.98726114649682 29 11 55.4 0 93 7 50 78 AGH30308.1 chloroplast ribulose-1,5-bisphosphate carboxylase/oxygenase small subunit [Chromochloris zofingiensis] diamond 312 47.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Chromochloridaceae Chromochloris Chromochloris zofingiensis
30208881 30208881 PRJNA702290_P_NODE_592_length_191_cov_23.072368_g584_i0 PRJNA702290 592 191 23.072368 44.06822288 Haematococcus lacustris 44745 Plants Plants 49.3 9.2e-5   NR KAJ9515890.1 44745 g584 i0 88 0.392670157068063 25 3 39.3 0 114 188 293 317 KAJ9515890.1 hypothetical protein QJQ45_016928 [Haematococcus lacustris] diamond 75 49.3 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
32011057 32011057 PRJNA702290_P_NODE_1838_length_156_cov_18.128205_g1830_i0 PRJNA702290 1838 156 18.128205 28.2799998 Bryopsis sp. KO-2 3115439 Plants Plants 46.2 3.13e-4   NR GMH38648.1 3041901 g1830 i0 50 1.55769230769231 52 23 94.2 2 7 153 33 84 GMH38648.1 hypothetical protein BSKO_06532 [Bryopsis sp. KO-2023] diamond 243 46.2 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Bryopsidaceae Bryopsis Bryopsis sp. KO-2023

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