RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA561212" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA561212 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
545300 545300 PRJNA561212_P_NODE_18301_length_266_cov_1.062176_g18090_i0 PRJNA561212 18301 266 1.062176 2.82538816 Anneissia japonica 1529436 Echinodermata other_Eukaryota 54.7 0.007   NTclustered gi|1826624574|ref|XM_033249209.1| 1529436 g18090 i0 100 0.21804511278195499 29 0 11 0 65 93 599 571 PREDICTED: Anneissia japonica nose resistant to fluoxetine protein 6-like (LOC117107506), transcript variant X2, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
18982085 18982085 PRJNA561212_P_NODE_23515_length_247_cov_0.879310_g23304_i0 PRJNA561212 23515 247 0.87931 2.1718957 Metazoa 33208 Echinodermata other_Eukaryota 58.4 4.8e-4   NTclustered gi|1752406687|ref|XM_030975445.1| 7668 g23304 i0 97.059 12.0485829959514 34 1 14 0 109 142 1986 2019 PREDICTED: Strongylocentrotus purpuratus CCR4-NOT transcription complex subunit 10 (LOC575687), transcript variant X1, mRNA blastn 2976 58.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
21532704 21532704 PRJNA561212_P_NODE_14337_length_296_cov_0.883408_g14126_i0 PRJNA561212 14337 296 0.883408 2.61488768 Opisthokonta 33154 Echinodermata other_Eukaryota 52.8 0.027   NTclustered gi|1752351012|ref|XM_030981071.1| 7668 g14126 i0 96.774 0.827702702702703 31 1 10 0 82 112 1100 1130 PREDICTED: Strongylocentrotus purpuratus nuclear pore complex protein Nup98-Nup96 (LOC593572), transcript variant X2, mRNA blastn 245 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
23497932 23497932 PRJNA561212_P_NODE_8839_length_370_cov_0.838384_g8628_i0 PRJNA561212 8839 370 0.838384 3.1020208 Diadema antillarum 105358 Echinodermata other_Eukaryota 274 6.889999999999998e-69   NTclustered gi|2919369550|ref|XM_071652004.1| 105358 g8628 i0 80.791 27.3756756756757 354 64 95 3 10 361 578 929 PREDICTED: Diadema antillarum calreticulin-like (LOC139741415), mRNA blastn 10129 274 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
24771482 24771482 PRJNA561212_P_NODE_10000_length_349_cov_1.072464_g9789_i0 PRJNA561212 10000 349 1.072464 3.74289936 Lytechinus pictus 7653 Echinodermata other_Eukaryota 128 5.32e-25   NTclustered gi|2707408381|ref|XM_054893204.2| 7653 g9789 i0 83.333 4.91404011461318 138 23 40 0 10 147 460 597 PREDICTED: Lytechinus pictus dynein light chain 2, cytoplasmic-like (LOC129254696), mRNA blastn 1715 128 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus

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