RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA976345 · 5 ✖

analysis 1

  • blastn · 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
9876056 9876056 PRJNA976345_P_NODE_147048_length_167_cov_3.015152_g145440_i0 PRJNA976345 147048 167 3.015152 5.03530384 Lytechinus pictus 7653 Echinodermata other_Eukaryota 52.8 0.014   NTclustered gi|2707393036|ref|XM_064104292.1| 7653 g145440 i0 100 0.167664670658683 28 0 17 0 42 69 3636 3663 PREDICTED: Lytechinus pictus ankyrin repeat, PH and SEC7 domain containing protein secG-like (LOC135155395), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
14975869 14975869 PRJNA976345_P_NODE_159912_length_162_cov_2.259843_g158304_i0 PRJNA976345 159912 162 2.259843 3.66094566 Anneissia japonica 1529436 Echinodermata other_Eukaryota 52.8 0.013   NTclustered gi|1826643116|ref|XM_033253791.1| 1529436 g158304 i0 100 0.172839506172839 28 0 17 0 121 148 935 908 PREDICTED: Anneissia japonica 1,2-dihydroxy-3-keto-5-methylthiopentene dioxygenase-like (LOC117110942), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
18799550 18799550 PRJNA976345_P_NODE_129755_length_175_cov_3.064286_g128147_i0 PRJNA976345 129755 175 3.064286 5.3625005 Acanthaster planci 133434 Echinodermata other_Eukaryota 52.8 0.015   NTclustered gi|1229142435|ref|XM_022227738.1| 133434 g128147 i0 100 0.16 28 0 16 0 123 150 2682 2655 PREDICTED: Acanthaster planci uncharacterized LOC110975336 (LOC110975336), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
21350243 21350243 PRJNA976345_P_NODE_19857_length_378_cov_2.588921_g18259_i0 PRJNA976345 19857 378 2.588921 9.78612138 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.036   NTclustered gi|1752401893|ref|XM_011664285.2| 7668 g18259 i0 94.286 0.0925925925925926 35 1 9 1 48 82 1754 1721 PREDICTED: Strongylocentrotus purpuratus galactose-3-O-sulfotransferase 2 (LOC100892774), mRNA blastn 35 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
23900679 23900679 PRJNA976345_P_NODE_186239_length_153_cov_6.423729_g184631_i0 PRJNA976345 186239 153 6.423729 9.82830537 Acanthaster planci 133434 Echinodermata other_Eukaryota 73.1 9.62e-9   NTclustered gi|1229160690|ref|XM_022237567.1| 133434 g184631 i0 93.75 0.627450980392157 48 3 31 0 45 92 5861 5814 PREDICTED: Acanthaster planci pre-mRNA-processing-splicing factor 8 (LOC110980671), mRNA blastn 96 73.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci

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