RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA414036 · 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
2969551 2969551 PRJNA414036_P_NODE_67603_length_190_cov_1.916129_g65864_i0 PRJNA414036 67603 190 1.916129 3.6406451 Lytechinus pictus 7653 Echinodermata other_Eukaryota 54.7 0.005   NTclustered gi|2707445222|ref|XM_064105914.1| 7653 g65864 i0 90.698 0.226315789473684 43 0 21 4 127 166 704 745 PREDICTED: Lytechinus pictus aspartate and glycine-rich protein-like (LOC129269662), mRNA blastn 43 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
6796468 6796468 PRJNA414036_P_NODE_30306_length_272_cov_7.409283_g28570_i0 PRJNA414036 30306 272 7.409283 20.15324976 Lytechinus pictus 7653 Echinodermata other_Eukaryota 126 1.45e-24   NTclustered gi|2707408381|ref|XM_054893204.2| 7653 g28570 i0 80.233 3.48161764705882 172 30 63 4 94 263 394 563 PREDICTED: Lytechinus pictus dynein light chain 2, cytoplasmic-like (LOC129254696), mRNA blastn 947 126 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
11897562 11897562 PRJNA414036_P_NODE_29630_length_276_cov_3.016598_g27894_i0 PRJNA414036 29630 276 3.016598 8.32581048 Diadema antillarum 105358 Echinodermata other_Eukaryota 54.7 0.007   NTclustered gi|2919397928|ref|XM_071631265.1| 105358 g27894 i0 100 0.105072463768116 29 0 11 0 232 260 276 304 PREDICTED: Diadema antillarum uncharacterized protein (LOC139719881), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
13172546 13172546 PRJNA414036_P_NODE_63531_length_203_cov_2.809524_g61792_i0 PRJNA414036 63531 203 2.809524 5.70333372 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 69.4 1.76e-7   NTclustered gi|1752357769|ref|XM_030983960.1| 7668 g61792 i0 83.562 0.719211822660099 73 12 36 0 110 182 812 740 PREDICTED: Strongylocentrotus purpuratus splicing factor U2AF 50 kDa subunit (LOC588126), transcript variant X2, mRNA blastn 146 69.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
24645244 24645244 PRJNA414036_P_NODE_70980_length_181_cov_1.876712_g69241_i0 PRJNA414036 70980 181 1.876712 3.39684872 Paracentrotus lividus 7656 Echinodermata other_Eukaryota 63.9 7.1e-6   NTclustered gi|108735519|gb|DQ536194.1| 7656 g69241 i0 79.121 0.502762430939227 91 19 50 0 85 175 1199 1289 Paracentrotus lividus BMP2/4 mRNA, complete cds blastn 91 63.9 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);;