RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA832865 · 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
15256704 15256704 PRJNA832865_S_NODE_96832_length_249_cov_1.721591_g91746_i0 PRJNA832865 96832 249 1.721591 4.28676159 Metazoa 33208 Echinodermata other_Eukaryota 52.8 0.023   NTclustered gi|2707406524|ref|XM_064113482.1| 7653 g91746 i0 100 0.240963855421687 28 0 11 0 127 154 488 461 PREDICTED: Lytechinus pictus pro-epidermal growth factor-like (LOC135157546), mRNA blastn 60 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
18674942 18674942 PRJNA832865_S_NODE_73015_length_288_cov_2.148837_g67929_i0 PRJNA832865 73015 288 2.148837 6.18865056 Temnopleurus reevesii 161071 Echinodermata other_Eukaryota 52.8 0.027   NTclustered gi|1886868118|dbj|LC523655.1| 161071 g67929 i0 100 0.0972222222222222 28 0 10 0 28 55 187871 187844 Temnopleurus reevesii DNA, scaffold_247 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Temnopleuridae Temnopleurus Temnopleurus reevesii
19949920 19949920 PRJNA832865_S_NODE_59876_length_322_cov_0.959839_g54790_i0 PRJNA832865 59876 322 0.959839 3.09068158 Patiria miniata 46514 Echinodermata other_Eukaryota 52.8 0.03   NTclustered gi|1944913035|ref|XM_038213410.1| 46514 g54790 i0 100 0.0869565217391304 28 0 9 0 270 297 4005 3978 PREDICTED: Patiria miniata growth hormone secretagogue receptor type 1-like (LOC119738509), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
23775693 23775693 PRJNA832865_S_NODE_50799_length_355_cov_1.574468_g45713_i0 PRJNA832865 50799 355 1.574468 5.5893614 Lytechinus pictus 7653 Echinodermata other_Eukaryota 56.5 0.003   NTclustered gi|2707354388|ref|XM_064096696.1| 7653 g45713 i0 90.476 0.11830985915493 42 4 12 0 68 109 2231 2190 PREDICTED: Lytechinus pictus uncharacterized LOC129257557 (LOC129257557), mRNA blastn 42 56.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
25049561 25049561 PRJNA832865_S_NODE_49880_length_359_cov_2.153846_g44794_i0 PRJNA832865 49880 359 2.153846 7.73230714 Diadema antillarum 105358 Echinodermata other_Eukaryota 54.7 0.009   NTclustered gi|2919466660|ref|XM_071643474.1| 105358 g44794 i0 96.875 0.178272980501393 32 1 9 0 51 82 1466 1497 PREDICTED: Diadema antillarum serine/threonine-protein phosphatase PP1-gamma catalytic subunit B (LOC139732618), mRNA blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum

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