RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA235310 · 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
2917985 2917985 PRJNA235310_P_NODE_4183_length_184_cov_1.133333_g4157_i0 PRJNA235310 4183 184 1.133333 2.08533272 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 89.8 1.2e-13   NTclustered gi|2037969038|ref|XM_041596501.1| 7654 g4157 i0 83.333 44.7282608695652 102 11 54 6 86 184 413 315 PREDICTED: Lytechinus variegatus late histone H2A.2.2-like (LOC121405574), mRNA blastn 8230 89.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
19493347 19493347 PRJNA235310_P_NODE_5416_length_166_cov_2.555556_g5390_i0 PRJNA235310 5416 166 2.555556 4.24222296 Patiria miniata 46514 Echinodermata other_Eukaryota 76.8 8.25e-10   NTclustered gi|1944922882|ref|XM_038218230.1| 46514 g5390 i0 84.416 0.716867469879518 77 12 46 0 71 147 407 483 PREDICTED: Patiria miniata dynein light chain LC6, flagellar outer arm-like (LOC119742192), mRNA blastn 119 76.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
24593565 24593565 PRJNA235310_P_NODE_1820_length_294_cov_1.877551_g1794_i0 PRJNA235310 1820 294 1.877551 5.51999994 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 60.2 1.63e-4   NTclustered gi|2037962102|ref|XM_041626527.1| 7654 g1794 i0 97.143 0.357142857142857 35 1 12 0 260 294 1944 1978 PREDICTED: Lytechinus variegatus choline-phosphate cytidylyltransferase A-like (LOC121429485), transcript variant X1, mRNA blastn 105 60.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus

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