RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1248471", tax_clade = "Opisthokonta" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 3 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 3 ✖

bioproject 1

  • PRJNA1248471 · 3 ✖

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
2904401 2904401 PRJNA1248471_S_NODE_17023_length_172_cov_0.829268_g16923_i0 PRJNA1248471 17023 172 0.829268 1.42634096 Obelia dichotoma 37520 Cnidaria other_Eukaryota 145 2.31e-30   NTclustered gi|1069324016|gb|KX665533.1| 37520 g16923 i0 88 4.3953488372093 125 12 71 2 51 172 3177 3053 Obelia dichotoma voucher MZUSP:3346 28S ribosomal RNA gene, partial sequence blastn 756 145 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Obeliidae Obelia Obelia dichotoma
11832143 11832143 PRJNA1248471_S_NODE_13930_length_185_cov_0.661765_g13830_i0 PRJNA1248471 13930 185 0.661765 1.22426525 Helgicirrha cari 1978353 Cnidaria other_Eukaryota 75 3.37e-9   NTclustered gi|1181738905|gb|KY363989.1| 1978353 g13830 i0 82.022 1.0972972972973 89 15 48 1 36 124 15 102 Helgicirrha cari isolate MHNG-HYD-DNA1153 18S ribosomal RNA gene, partial sequence blastn 203 75 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Eirenidae Helgicirrha Helgicirrha cari
23305951 23305951 PRJNA1248471_S_NODE_17939_length_169_cov_0.808333_g17839_i0 PRJNA1248471 17939 169 0.808333 1.36608277 Acropora muricata 159855 Cnidaria other_Eukaryota 54.7 0.004   NTclustered gi|2784677829|ref|XM_067169169.1| 159855 g17839 i0 100 0.171597633136095 29 0 17 0 123 151 1548 1576 PREDICTED: Acropora muricata uncharacterized protein (LOC136896362), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora muricata

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