RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA285816 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
5475391 5475391 PRJNA285816_S_NODE_21085_length_177_cov_1.203125_g20983_i0 PRJNA285816 21085 177 1.203125 2.12953125 Hydra vulgaris 6087 Cnidaria other_Eukaryota 71.3 4.13e-8   NTclustered gi|2744809587|ref|XM_002166486.5| 6087 g20983 i0 92 0.564971751412429 50 4 28 0 128 177 1282 1233 PREDICTED: Hydra vulgaris eukaryotic initiation factor 4A-III (LOC100197176), transcript variant X1, mRNA blastn 100 71.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
11850622 11850622 PRJNA285816_S_NODE_20670_length_178_cov_1.596899_g20568_i0 PRJNA285816 20670 178 1.596899 2.84248022 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 86.1 1.48e-12   NTclustered gi|2782923104|ref|XM_067072374.1| 252671 g20568 i0 83.696 0.51685393258427 92 13 51 2 24 114 3893 3983 PREDICTED: Clytia hemisphaerica ATP-binding cassette sub-family C member 5-like (LOC136815946), mRNA blastn 92 86.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
22735985 22735985 PRJNA285816_S_NODE_558_length_823_cov_231.249354_g501_i0 PRJNA285816 558 823 231.249354 1903.18218342 Metazoa 33208 Cnidaria other_Eukaryota 145 1.33e-29   NTclustered gi|605060084|gb|KF874224.1| 109801 g501 i0 87.402 15.9866342648846 127 14 15 2 1 127 357 233 Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence blastn 13157 145 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Parvicapsulidae Parvicapsula Parvicapsula minibicornis
24598241 24598241 PRJNA285816_S_NODE_4140_length_334_cov_1.761404_g4038_i0 PRJNA285816 4140 334 1.761404 5.88308936 Montipora capricornis 246305 Cnidaria other_Eukaryota 130 1.41e-25   NTclustered gi|2812136229|ref|XM_068881313.1| 246305 g4038 i0 77.049 19.2455089820359 244 45 71 11 1 238 1738 1976 PREDICTED: Montipora capricornis dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3A (LOC138033545), mRNA blastn 6428 130 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis

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