RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA641991", tax_clade = "Opisthokonta" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 3 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 3 ✖

bioproject 1

  • PRJNA641991 · 3 ✖

analysis 1

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
29587901 29587901 PRJNA641991_S_NODE_10850_length_174_cov_0.880000_g10731_i0 PRJNA641991 10850 174 0.88 1.5312 root 1 Root_unresolved Root_unresolved 80.5 7.44e-16   NR XP_071498642.1 105358 g10731 i0 62.1 14.7931034482759 58 22 100 0 1 174 283 340 XP_071498642.1 extracellular serine proteinase-like [Diadema antillarum] diamond 2574 81.3 0.990159901599016 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
30239199 30239199 PRJNA641991_P_NODE_3492_length_166_cov_0.871795_g3451_i0 PRJNA641991 3492 166 0.871795 1.4471797 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 82.4 3.05e-17   NR XP_041481441.1 7654 g3451 i0 69.1 0.993975903614458 55 17 99.4 0 165 1 196 250 XP_041481441.1 60S ribosomal protein L7a-like [Lytechinus variegatus] diamond 165 82.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
30302845 30302845 PRJNA641991_P_NODE_3192_length_168_cov_0.857143_g3151_i0 PRJNA641991 3192 168 0.857143 1.44000024 Luidia clathrata 133437 Echinodermata other_Eukaryota 40.4 0.0252   NR AAG31941.1 133437 g3151 i0 50 0.714285714285714 40 20 71.4 0 4 123 22 61 AAG31941.1 cytochrome oxidase subunit I, partial [Luidia clathrata] diamond 120 40.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Paxillosida Luidiidae Luidia Luidia clathrata

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