RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA315399 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
2934134 2934134 PRJNA315399_P_NODE_485443_length_152_cov_7.034783_g484995_i0 PRJNA315399 485443 152 7.034783 10.69287016 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 62.1 2.06e-5   NTclustered gi|2037992070|ref|XM_041608919.1| 7654 g484995 i0 91.304 0.302631578947368 46 3 30 1 99 144 3660 3616 PREDICTED: Lytechinus variegatus WD repeat-containing protein 93-like (LOC121415631), mRNA blastn 46 62.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
6762305 6762305 PRJNA315399_S_NODE_164226_length_157_cov_3.758333_g164025_i0 PRJNA315399 164226 157 3.758333 5.90058281 Lytechinus pictus 7653 Echinodermata other_Eukaryota 54.7 0.004   NTclustered gi|2707359961|ref|XM_054893702.2| 7653 g164025 i0 100 0.184713375796178 29 0 18 0 122 150 4148 4120 PREDICTED: Lytechinus pictus thioredoxin reductase 1, cytoplasmic-like (LOC129255336), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
8036434 8036434 PRJNA315399_P_NODE_433547_length_158_cov_3.190083_g433099_i0 PRJNA315399 433547 158 3.190083 5.04033114 Diadema antillarum 105358 Echinodermata other_Eukaryota 71.3 3.61e-8   NTclustered gi|2919469585|ref|XM_071643940.1| 105358 g433099 i0 95.455 3.21518987341772 44 2 28 0 103 146 1273 1230 PREDICTED: Diadema antillarum protein Red-like (LOC139733097), mRNA blastn 508 71.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
9313774 9313774 PRJNA315399_S_NODE_8748_length_364_cov_34.388379_g8547_i0 PRJNA315399 8748 364 34.388379 125.17369956 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 198 4.19e-46   NTclustered gi|2038000323|ref|XM_041613285.1| 7654 g8547 i0 84.236 13.3434065934066 203 32 56 0 9 211 297 499 PREDICTED: Lytechinus variegatus calmodulin-beta-like (LOC121419026), mRNA blastn 4857 198 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
10587018 10587018 PRJNA315399_P_NODE_426369_length_159_cov_1.459016_g425921_i0 PRJNA315399 426369 159 1.459016 2.31983544 Anneissia japonica 1529436 Echinodermata other_Eukaryota 56.5 0.001   NTclustered gi|1826658313|ref|XM_033261041.1| 1529436 g425921 i0 97.059 0.389937106918239 34 0 21 1 125 157 4898 4931 PREDICTED: Anneissia japonica kin of IRRE-like protein 2 (LOC117116909), mRNA blastn 62 56.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
13135609 13135609 PRJNA315399_P_NODE_218631_length_184_cov_1.653061_g218183_i0 PRJNA315399 218631 184 1.653061 3.04163224 Lytechinus pictus 7653 Echinodermata other_Eukaryota 54.7 0.004   NTclustered gi|2707360636|ref|XM_064097906.1| 7653 g218183 i0 100 0.157608695652174 29 0 16 0 33 61 1679 1651 PREDICTED: Lytechinus pictus uncharacterized LOC129256176 (LOC129256176), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
14412229 14412229 PRJNA315399_P_NODE_443492_length_157_cov_2.816667_g443044_i0 PRJNA315399 443492 157 2.816667 4.42216719 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.013   NTclustered gi|1752353858|ref|XM_030982288.1| 7668 g443044 i0 100 0.535031847133758 28 0 18 0 112 139 3365 3338 PREDICTED: Strongylocentrotus purpuratus G-protein coupled receptor GRL101 (LOC581458), transcript variant X1, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
16960492 16960492 PRJNA315399_P_NODE_41354_length_250_cov_3.192488_g40907_i0 PRJNA315399 41354 250 3.192488 7.98122 Acanthaster planci 133434 Echinodermata other_Eukaryota 52.8 0.023   NTclustered gi|1229183233|ref|XM_022249572.1| 133434 g40907 i0 100 0.336 28 0 11 0 197 224 1446 1473 PREDICTED: Acanthaster planci kxDL motif-containing protein 1-like (LOC110987120), transcript variant X2, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
20785710 20785710 PRJNA315399_S_NODE_114537_length_172_cov_4.348148_g114336_i0 PRJNA315399 114537 172 4.348148 7.47881456 Anneissia japonica 1529436 Echinodermata other_Eukaryota 52.8 0.014   NTclustered gi|1826644441|ref|XM_033254463.1| 1529436 g114336 i0 100 0.162790697674419 28 0 16 0 78 105 3412 3385 PREDICTED: Anneissia japonica adhesion G protein-coupled receptor E3-like (LOC117111531), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
23336712 23336712 PRJNA315399_S_NODE_17279_length_293_cov_9.269531_g17078_i0 PRJNA315399 17279 293 9.269531 27.15972583 Acanthaster planci 133434 Echinodermata other_Eukaryota 52.8 0.027   NTclustered gi|1229133265|ref|XM_022255687.1| 133434 g17078 i0 100 0.191126279863481 28 0 10 0 237 264 2814 2841 PREDICTED: Acanthaster planci sialidase-2-like (LOC110990601), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci

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