RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA666695" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA666695 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1907752 1907752 PRJNA666695_S_NODE_184822_length_156_cov_1.600000_g183728_i0 PRJNA666695 184822 156 1.6 2.496 Lytechinus pictus 7653 Echinodermata other_Eukaryota 52.8 0.013   NTclustered gi|2707368438|ref|XM_054913873.2| 7653 g183728 i0 100 0.179487179487179 28 0 18 0 54 81 3497 3524 PREDICTED: Lytechinus pictus adenylate kinase isoenzyme 5-like (LOC129277723), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
4458273 4458273 PRJNA666695_S_NODE_121384_length_199_cov_2.930380_g120290_i0 PRJNA666695 121384 199 2.93038 5.8314562 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.017   NTclustered gi|1752401902|ref|XR_971061.2| 7668 g120290 i0 100 0.14070351758794 28 0 14 0 1 28 2500 2527 PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC105438715 (LOC105438715), ncRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
8286235 8286235 PRJNA666695_S_NODE_67527_length_260_cov_3.780822_g66433_i0 PRJNA666695 67527 260 3.780822 9.8301372 Holothuria scabra 269548 Echinodermata other_Eukaryota 52.8 0.024   NTclustered gi|2705712780|gb|PP548101.1| 269548 g66433 i0 100 0.265384615384615 28 0 11 0 24 51 300 273 Holothuria scabra microsatellite Hsca_07 sequence blastn 69 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria scabra
9558825 9558825 PRJNA666695_S_NODE_118388_length_202_cov_2.000000_g117294_i0 PRJNA666695 118388 202 2 4.04 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 52.8 0.018   NTclustered gi|2038006491|ref|XM_041616512.1| 7654 g117294 i0 100 0.138613861386139 28 0 14 0 148 175 5217 5190 PREDICTED: Lytechinus variegatus caprin-1-like (LOC121421729), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
17210508 17210508 PRJNA666695_S_NODE_46574_length_302_cov_1.938697_g45480_i0 PRJNA666695 46574 302 1.938697 5.85486494 Patiria miniata 46514 Echinodermata other_Eukaryota 56.5 0.002   NTclustered gi|1944893778|ref|XM_038205702.1| 46514 g45480 i0 96.97 0.218543046357616 33 1 11 0 216 248 2270 2238 PREDICTED: Patiria miniata probable E3 ubiquitin ligase complex SCF subunit sconB (LOC119732254), transcript variant X1, mRNA blastn 66 56.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
18484714 18484714 PRJNA666695_S_NODE_39135_length_322_cov_10.263345_g38041_i0 PRJNA666695 39135 322 10.263345 33.0479709 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.03   NTclustered gi|1752396792|ref|XM_031000288.1| 7668 g38041 i0 90.244 0.127329192546584 41 3 13 1 18 58 303 264 PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC575879 (LOC575879), mRNA blastn 41 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
24858341 24858341 PRJNA666695_S_NODE_31140_length_352_cov_2.440514_g30046_i0 PRJNA666695 31140 352 2.440514 8.59060928 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 54.7 0.009   NTclustered gi|2037998016|ref|XM_041612056.1| 7654 g30046 i0 96.97 0.09375 33 0 9 1 162 194 3085 3116 PREDICTED: Lytechinus variegatus protein PRRC2C-like (LOC121418277), mRNA blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus

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