RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA454154" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA454154 · 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
30882173 30882173 PRJNA454154_S_NODE_454_length_175_cov_2.550725_g451_i0 PRJNA454154 454 175 2.550725 4.46376875 Opisthokonta 33154 Chordata Chordata 52.4 5.96e-6   NR XP_059810455.1 79690 g451 i0 56.4 1.88571428571429 39 14 66.9 1 174 58 428 463 XP_059810455.1 adenylyl cyclase-associated protein 1 [Hypanus sabinus] diamond 330 52.4 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Myliobatiformes Dasyatidae Hypanus Hypanus sabinus
32147199 32147199 PRJNA454154_S_NODE_118_length_268_cov_2.666667_g115_i0 PRJNA454154 118 268 2.666667 7.14666756 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 103 9.26e-26   NR XP_039269693.1 7725 g115 i0 71.4 7.80223880597015 70 20 78.4 0 2 211 96 165 XP_039269693.1 60S ribosomal protein L12-like [Styela clava] diamond 2091 103 1 Eukaryota Opisthokonta Metazoa Chordata Ascidiacea Stolidobranchia Styelidae Styela Styela clava

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