RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB66218 · 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
12886268 12886268 PRJEB66218_P_NODE_227091_length_205_cov_0.902778_g224661_i0 PRJEB66218 227091 205 0.902778 1.8506949 Diadema antillarum 105358 Echinodermata other_Eukaryota 104 4.87e-18   NTclustered gi|2919467962|ref|XM_071643681.1| 105358 g224661 i0 88.372 40.0243902439024 86 10 42 0 120 205 1857 1772 PREDICTED: Diadema antillarum AP-1 complex subunit beta-1-like (LOC139732840), mRNA blastn 8205 104 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
21396721 21396721 PRJEB66218_P_NODE_212937_length_208_cov_0.884354_g210507_i0 PRJEB66218 212937 208 0.884354 1.83945632 Metazoa 33208 Echinodermata other_Eukaryota 111 2.96e-20   NTclustered gi|1944908007|ref|XM_038210904.1| 46514 g210507 i0 82.927 54.3317307692308 123 21 59 0 66 188 689 567 PREDICTED: Patiria miniata ADP/ATP translocase 3-like (LOC119736888), mRNA blastn 11301 111 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
24357425 24357425 PRJEB66218_P_NODE_161240_length_233_cov_1.854651_g158810_i0 PRJEB66218 161240 233 1.854651 4.32133683 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 119 2.03e-22   NTclustered gi|2037937090|ref|XM_041617574.1| 7654 g158810 i0 88 15.0729613733906 100 12 43 0 46 145 149 248 PREDICTED: Lytechinus variegatus cytochrome c oxidase subunit 6B1-like (LOC121422490), mRNA blastn 3512 119 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);;