RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA330616" 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

bioproject 1

  • PRJNA330616 · 3 ✖

analysis 1

  • blastn · 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
16967236 16967236 PRJNA330616_P_NODE_7174_length_311_cov_1.912214_g6765_i0 PRJNA330616 7174 311 1.912214 5.94698554 Diadema antillarum 105358 Echinodermata other_Eukaryota 172 2.14e-38   NTclustered gi|2919562891|ref|XM_071624859.1| 105358 g6765 i0 83.889 62.4372990353698 180 29 58 0 19 198 267 88 PREDICTED: Diadema antillarum late histone H2A.3, gonadal (LOC139713103), mRNA blastn 19418 172 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
18920845 18920845 PRJNA330616_P_NODE_26535_length_166_cov_0.871795_g26126_i0 PRJNA330616 26535 166 0.871795 1.4471797 Lytechinus 7652 Echinodermata other_Eukaryota 147 6.2e-31   NTclustered gi|2707360192|ref|XM_054894817.2| 7653 g26126 i0 83.648 90.9036144578313 159 23 95 3 6 163 181 25 PREDICTED: Lytechinus pictus ras-related protein Rap-1A-like (LOC129256657), mRNA blastn 15090 147 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
24615671 24615671 PRJNA330616_P_NODE_14960_length_216_cov_1.125749_g14551_i0 PRJNA330616 14960 216 1.1257490000000001 2.43161784 Psammechinus miliaris 7660 Echinodermata other_Eukaryota 139 1.42e-28   NTclustered gi|1036032539|gb|AH001093.2| 7660 g14551 i0 83.226 70.4861111111111 155 22 71 3 55 207 817 665 Psammechinus miliaris histone H2B-2.1 and histone H2A-2.1 genes, complete cds blastn 15225 139 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Parechinidae Psammechinus Psammechinus miliaris

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