RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1111146", tax_clade = "Opisthokonta" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 4 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 4 ✖

bioproject 1

  • PRJNA1111146 · 4 ✖

analysis 1

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
5319079 5319079 PRJNA1111146_P_NODE_275085_length_191_cov_2.050725_g273947_i0 PRJNA1111146 275085 191 2.050725 3.91688475 Stylophora pistillata 50429 Cnidaria other_Eukaryota 52.8 0.016   NTclustered gi|1270085404|ref|XM_022950374.1| 50429 g273947 i0 100 0.43979057591623 28 0 15 0 132 159 2742 2715 PREDICTED: Stylophora pistillata ataxin-1-like (LOC111343211), transcript variant X1, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
18068183 18068183 PRJNA1111146_P_NODE_355355_length_182_cov_0.875969_g354217_i0 PRJNA1111146 355355 182 0.875969 1.59426358 Hydra vulgaris 6087 Cnidaria other_Eukaryota 167 5.3e-37   NTclustered gi|2744813115|ref|XR_007025487.2| 6087 g354217 i0 95.283 5.0989010989011 106 4 58 1 45 149 348 243 PREDICTED: Hydra vulgaris uncharacterized LOC124816897 (LOC124816897), transcript variant X1, ncRNA blastn 928 167 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
24441733 24441733 PRJNA1111146_P_NODE_187160_length_209_cov_1.211538_g186022_i0 PRJNA1111146 187160 209 1.211538 2.53211442 Hydra vulgaris 6087 Cnidaria other_Eukaryota 56.5 0.001   NTclustered gi|2744874088|ref|XM_065803575.1| 6087 g186022 i0 94.595 0.354066985645933 37 1 17 1 3 38 445 409 PREDICTED: Hydra vulgaris crossover junction endonuclease EME1 (LOC100202321), transcript variant X3, mRNA blastn 74 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
24442512 24442512 PRJNA1111146_P_NODE_355620_length_182_cov_0.875969_g354482_i0 PRJNA1111146 355620 182 0.875969 1.59426358 Hydra vulgaris 6087 Cnidaria other_Eukaryota 250 5.1099999999999995e-62   NTclustered gi|2744778989|ref|XM_047274362.2| 6087 g354482 i0 92.09 1.94505494505495 177 14 97 0 3 179 2532 2708 PREDICTED: Hydra vulgaris uncharacterized LOC124810113 (LOC124810113), mRNA blastn 354 250 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris

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