RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA946307 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
4756290 4756290 PRJNA946307_P_NODE_79084_length_194_cov_6.786207_g78210_i0 PRJNA946307 79084 194 6.786207 13.16524158 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.017   NTclustered gi|1752358960|ref|XM_030984431.1| 7668 g78210 i0 100 0.288659793814433 28 0 14 0 146 173 1095 1068 PREDICTED: Strongylocentrotus purpuratus L-xylulose reductase-like (LOC591319), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
8578666 8578666 PRJNA946307_P_NODE_115647_length_177_cov_1.609375_g114773_i0 PRJNA946307 115647 177 1.609375 2.84859375 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.015   NTclustered gi|1752398371|ref|XM_782669.5| 7668 g114773 i0 100 0.15819209039548 28 0 16 0 75 102 1540 1567 PREDICTED: Strongylocentrotus purpuratus NADH dehydrogenase [ubiquinone] 1 beta subcomplex subunit 11, mitochondrial (LOC582727), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
8580626 8580626 PRJNA946307_P_NODE_68187_length_199_cov_3.733333_g67313_i0 PRJNA946307 68187 199 3.733333 7.42933267 Anneissia japonica 1529436 Echinodermata other_Eukaryota 60.2 1.03e-4   NTclustered gi|1826661462|ref|XM_033262690.1| 1529436 g67313 i0 89.583 0.241206030150754 48 4 24 1 59 105 7923 7970 PREDICTED: Anneissia japonica E3 ubiquitin-protein ligase TRIM71-like (LOC117118176), mRNA blastn 48 60.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
25152476 25152476 PRJNA946307_P_NODE_149680_length_165_cov_0.879310_g148806_i0 PRJNA946307 149680 165 0.87931 1.4508615 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.014   NTclustered gi|1752405348|ref|XM_030974934.1| 7668 g148806 i0 100 0.16969696969697 28 0 17 0 64 91 390 363 PREDICTED: Strongylocentrotus purpuratus bystin (LOC578981), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus

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