RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA975724 · 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
6370896 6370896 PRJNA975724_S_NODE_25525_length_363_cov_6.113793_g25344_i0 PRJNA975724 25525 363 6.113793 22.19306859 Metazoa 33208 Echinodermata other_Eukaryota 115 4.33e-21   NTclustered gi|1834275018|ref|XM_033775283.1| 7604 g25344 i0 89.888 24.4022038567493 89 9 25 0 273 361 402 314 PREDICTED: Asterias rubens dynein light chain LC6, flagellar outer arm-like (LOC117293071), transcript variant X2, mRNA blastn 8858 115 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
13700234 13700234 PRJNA975724_S_NODE_57651_length_283_cov_1.100000_g57470_i0 PRJNA975724 57651 283 1.1 3.113 Patiria miniata 46514 Echinodermata other_Eukaryota 76.8 1.55e-9   NTclustered gi|1944871289|ref|XM_038199805.1| 46514 g57470 i0 91.228 0.628975265017668 57 3 20 2 204 259 3960 3905 PREDICTED: Patiria miniata DNA repair protein RAD50-like (LOC119727760), mRNA blastn 178 76.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
22623493 22623493 PRJNA975724_S_NODE_51338_length_294_cov_7.212670_g51157_i0 PRJNA975724 51338 294 7.21267 21.2052498 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 54.7 0.008   NTclustered gi|1752389840|ref|XM_030997580.1| 7668 g51157 i0 100 0.0986394557823129 29 0 10 0 264 292 1859 1887 PREDICTED: Strongylocentrotus purpuratus uncharacterized protein DDB_G0271670 (LOC579968), mRNA blastn 29 54.7 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);;