RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA1041773" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 2 ✖

bioproject 1

  • PRJNA1041773 · 2 ✖

analysis 1

  • diamond · 2 ✖
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
26971821 26971821 PRJNA1041773_P_NODE_22562_length_437_cov_3.002747_g22231_i0 PRJNA1041773 22562 437 3.002747 13.12200439 [Myrmecia] bisecta 41462 Plants Plants 130 7.78e-32   NR KAK9817796.1 41462 g22231 i0 75 1.21510297482838 88 22 60.4 0 432 169 556 643 KAK9817796.1 hypothetical protein WJX72_002302 [[Myrmecia] bisecta] diamond 531 130 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Myrmecia [Myrmecia] bisecta
28235156 28235156 PRJNA1041773_P_NODE_96146_length_243_cov_0.905882_g95813_i0 PRJNA1041773 96146 243 0.905882 2.20129326 Chlamydomonas sp. UWO 241 1653778 Plants Plants 56.6 4.78e-7   NR KAG1669795.1 1653778 g95813 i0 41.4 1.07407407407407 87 42 98.8 4 3 242 209 293 KAG1669795.1 hypothetical protein FOA52_001625 [Chlamydomonas sp. UWO 241] diamond 261 56.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas sp. UWO 241

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