RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB12237" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB12237 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
20658 20658 PRJEB12237_P_NODE_11661_length_154_cov_1.008403_g11465_i0 PRJEB12237 11661 154 1.008403 1.55294062 Diadema antillarum 105358 Echinodermata other_Eukaryota 63.9 5.84e-6   NTclustered gi|2919453208|ref|XR_011710916.1| 105358 g11465 i0 95 0.25974025974026 40 2 26 0 114 153 3072 3033 PREDICTED: Diadema antillarum uncharacterized lncRNA (LOC139730312), ncRNA blastn 40 63.9 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
7672900 7672900 PRJEB12237_P_NODE_5627_length_250_cov_2.251163_g5431_i0 PRJEB12237 5627 250 2.251163 5.6279075 Molpadia musculus complex sp. AKM-2016 1902941 Echinodermata other_Eukaryota 128 3.66e-25   NTclustered gi|1160550733|gb|KX856889.1| 1902941 g5431 i0 98.611 26.048 72 1 29 0 97 168 444 515 Molpadia musculus complex sp. AKM-2016 voucher SIO:BIC:E5295 28S ribosomal RNA gene, partial sequence blastn 6512 128 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Molpadida Molpadiidae Molpadia Molpadia musculus complex sp. AKM-2016
8947663 8947663 PRJEB12237_P_NODE_3068_length_389_cov_2.290960_g2872_i0 PRJEB12237 3068 389 2.29096 8.9118344 Asterias rubens 7604 Echinodermata other_Eukaryota 84.2 1.32e-11   NTclustered gi|1834301632|ref|XM_033770905.1| 7604 g2872 i0 94.444 0.25706940874036 54 3 14 0 336 389 1418 1365 PREDICTED: Asterias rubens tubulin beta chain-like (LOC117289675), transcript variant X2, mRNA blastn 100 84.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
15322884 15322884 PRJEB12237_P_NODE_7933_length_196_cov_2.354037_g7737_i0 PRJEB12237 7933 196 2.354037 4.61391252 Paracentrotus lividus 7656 Echinodermata other_Eukaryota 180 7.45e-41   NTclustered gi|37287386|gb|AY388462.1| 7656 g7737 i0 84.153 20.8265306122449 183 29 93 0 5 187 397 215 Paracentrotus lividus neural alfa2 tubulin (Talfa2) mRNA, complete cds blastn 4082 180 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Echinidae Paracentrotus Paracentrotus lividus

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