RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB27957", tax_clade = "Opisthokonta" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 5 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 5 ✖

bioproject 1

  • PRJEB27957 · 5 ✖
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
5125845 5125845 PRJEB27957_P_NODE_83885_length_187_cov_3.014493_g83775_i0 PRJEB27957 83885 187 3.014493 5.63710191 Lytechinus pictus 7653 Echinodermata other_Eukaryota 54.7 0.004   NTclustered gi|2707435910|ref|XM_064103226.1| 7653 g83775 i0 100 1.08021390374332 29 0 16 0 156 184 4917 4889 PREDICTED: Lytechinus pictus uncharacterized LOC135154972 (LOC135154972), mRNA blastn 202 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
5125848 5125848 PRJEB27957_P_NODE_87905_length_183_cov_1.940299_g87795_i0 PRJEB27957 87905 183 1.940299 3.55074717 Asterias rubens 7604 Echinodermata other_Eukaryota 54.7 0.004   NTclustered gi|1834274165|ref|XM_033774830.1| 7604 g87795 i0 96.875 0.174863387978142 32 1 17 0 43 74 3280 3249 PREDICTED: Asterias rubens ubiquitin carboxyl-terminal hydrolase 36-like (LOC117292691), mRNA blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
6401530 6401530 PRJEB27957_P_NODE_2166_length_706_cov_3.458143_g2087_i0 PRJEB27957 2166 706 3.458143 24.41448958 Acanthaster planci 133434 Echinodermata other_Eukaryota 54.7 0.02   NTclustered gi|1229129307|ref|XM_022234876.1| 133434 g2087 i0 100 0.164305949008499 29 0 4 0 37 65 3203 3175 PREDICTED: Acanthaster planci transient receptor potential channel pyrexia-like (LOC110979250), transcript variant X1, mRNA blastn 116 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
11501395 11501395 PRJEB27957_P_NODE_111770_length_166_cov_1.316239_g111660_i0 PRJEB27957 111770 166 1.316239 2.18495674 Lytechinus pictus 7653 Echinodermata other_Eukaryota 52.8 0.014   NTclustered gi|2707360840|ref|XM_054896049.2| 7653 g111660 i0 100 0.168674698795181 28 0 17 0 127 154 2366 2393 PREDICTED: Lytechinus pictus ferrochelatase, mitochondrial-like (LOC129257676), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
26589702 26589702 PRJEB27957_P_NODE_39041_length_255_cov_1.514563_g38931_i0 PRJEB27957 39041 255 1.514563 3.86213565 Asterias rubens 7604 Echinodermata other_Eukaryota 52.4 5.12e-6   NR XP_033641004.1 7604 g38931 i0 36.7 1.90588235294118 79 46 89.4 2 26 253 43 120 XP_033641004.1 uncharacterized protein LOC117301244 [Asterias rubens] diamond 486 52.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens

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