RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1174234 · 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
7969393 7969393 PRJNA1174234_P_NODE_25667_length_271_cov_1.166667_g25471_i0 PRJNA1174234 25667 271 1.166667 3.16166757 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 54.7 0.007   NTclustered gi|1752386050|ref|XM_030995953.1| 7668 g25471 i0 96.875 0.811808118081181 32 1 12 0 52 83 1444 1413 PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC115918970 (LOC115918970), transcript variant X2, mRNA blastn 220 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
13069691 13069691 PRJNA1174234_P_NODE_21471_length_298_cov_1.342222_g21275_i0 PRJNA1174234 21471 298 1.342222 3.99982156 Lytechinus pictus 7653 Echinodermata other_Eukaryota 54.7 0.008   NTclustered gi|2707365989|ref|XM_064112355.1| 7653 g21275 i0 100 0.288590604026846 29 0 10 0 160 188 2114 2086 PREDICTED: Lytechinus pictus lactadherin-like (LOC129280151), mRNA blastn 86 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
20717499 20717499 PRJNA1174234_P_NODE_27597_length_259_cov_1.327957_g27401_i0 PRJNA1174234 27597 259 1.327957 3.43940863 Patiria miniata 46514 Echinodermata other_Eukaryota 54.7 0.007   NTclustered gi|1944916156|ref|XM_038214918.1| 46514 g27401 i0 96.97 0.50965250965251 33 0 13 1 15 47 1962 1993 PREDICTED: Patiria miniata beta-1,2-xylosyltransferase RCN11-like (LOC119739830), transcript variant X1, mRNA blastn 132 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata

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