RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA382357 · 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
5508143 5508143 PRJNA382357_P_NODE_8005_length_723_cov_1.925982_g7331_i0 PRJNA382357 8005 723 1.925982 13.92484986 Acanthaster planci 133434 Echinodermata other_Eukaryota 58.4 0.002   NTclustered gi|1229169275|ref|XM_022242169.1| 133434 g7331 i0 100 0.0428769017980636 31 0 4 0 409 439 1284 1314 PREDICTED: Acanthaster planci echinoidin-like (LOC110983166), mRNA blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
7453418 7453418 PRJNA382357_P_NODE_75706_length_273_cov_24.721698_g74967_i0 PRJNA382357 75706 273 24.721698 67.49023554 root 1 Root_unresolved Root_unresolved 320 6.22e-83   NTclustered gi|12964767|gb|AF322373.1| 7668 g74967 i0 100 91.5677655677656 173 0 98 0 101 273 462 290 Strongylocentrotus purpuratus transposase helper protein-like protein mRNA, partial cds blastn 24998 320 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
16980789 16980789 PRJNA382357_P_NODE_20674_length_486_cov_1.136471_g19940_i0 PRJNA382357 20674 486 1.136471 5.52324906 Lytechinus pictus 7653 Echinodermata other_Eukaryota 52.8 0.047   NTclustered gi|2707360967|ref|XM_064107191.1| 7653 g19940 i0 100 0.691358024691358 28 0 12 0 204 231 2040 2067 PREDICTED: Lytechinus pictus phospholysine phosphohistidine inorganic pyrophosphate phosphatase-like (LOC129273112), transcript variant X6, mRNA blastn 336 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
18926493 18926493 PRJNA382357_P_NODE_22335_length_470_cov_0.953545_g21599_i0 PRJNA382357 22335 470 0.953545 4.4816615 Lytechinus 7652 Echinodermata other_Eukaryota 54.7 0.013   NTclustered gi|2707411279|ref|XM_054892322.2| 7653 g21599 i0 94.286 0.714893617021277 35 2 7 0 414 448 3085 3119 PREDICTED: Lytechinus pictus NFX1-type zinc finger-containing protein 1-like (LOC129253888), transcript variant X2, mRNA blastn 336 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus

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