RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB14803" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB14803 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
8948443 8948443 PRJEB14803_P_NODE_29328_length_201_cov_0.987952_g28862_i0 PRJEB14803 29328 201 0.987952 1.98578352 Anneissia japonica 1529436 Echinodermata other_Eukaryota 145 2.8e-30   NTclustered gi|1826644950|ref|XM_033254737.1| 1529436 g28862 i0 83.66 5.40796019900498 153 25 76 0 3 155 321 473 PREDICTED: Anneissia japonica 40S ribosomal protein S23 (LOC117111737), mRNA blastn 1087 145 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
10224278 10224278 PRJEB14803_P_NODE_46869_length_151_cov_1.379310_g46403_i0 PRJEB14803 46869 151 1.37931 2.0827581 Diadema antillarum 105358 Echinodermata other_Eukaryota 80.5 5.65e-11   NTclustered gi|2919519130|ref|XM_071653034.1| 105358 g46403 i0 85.526 0.503311258278146 76 11 50 0 19 94 1605 1680 PREDICTED: Diadema antillarum T-complex protein 1 subunit epsilon-like (LOC139742498), mRNA blastn 76 80.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
17873065 17873065 PRJEB14803_P_NODE_31435_length_192_cov_1.579618_g30969_i0 PRJEB14803 31435 192 1.579618 3.03286656 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.017   NTclustered gi|1752396792|ref|XM_031000288.1| 7668 g30969 i0 90.244 0.213541666666667 41 3 21 1 52 92 303 264 PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC575879 (LOC575879), mRNA blastn 41 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
20422234 20422234 PRJEB14803_P_NODE_46097_length_152_cov_2.051282_g45631_i0 PRJEB14803 46097 152 2.051282 3.11794864 Diadema antillarum 105358 Echinodermata other_Eukaryota 76.8 7.37e-10   NTclustered gi|2919409004|ref|XM_071633170.1| 105358 g45631 i0 90 0.960526315789474 60 4 39 2 39 97 1087 1145 PREDICTED: Diadema antillarum serine/threonine-protein kinase Chk2-like (LOC139721851), mRNA blastn 146 76.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
22973449 22973449 PRJEB14803_P_NODE_34099_length_183_cov_1.040541_g33633_i0 PRJEB14803 34099 183 1.040541 1.90419003 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.016   NTclustered gi|1752396333|ref|XM_777414.5| 7668 g33633 i0 100 0.153005464480874 28 0 15 0 48 75 1173 1146 PREDICTED: Strongylocentrotus purpuratus amphiphysin (LOC577170), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
24247353 24247353 PRJEB14803_P_NODE_42120_length_160_cov_2.240000_g41654_i0 PRJEB14803 42120 160 2.24 3.584 Anneissia japonica 1529436 Echinodermata other_Eukaryota 60.2 7.93e-5   NTclustered gi|1826667649|ref|XM_033265538.1| 1529436 g41654 i0 94.737 1.9375 38 2 24 0 123 160 3883 3846 PREDICTED: Anneissia japonica uncharacterized LOC117120526 (LOC117120526), mRNA blastn 310 60.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica

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