RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1005695 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
7806233 7806233 PRJNA1005695_P_NODE_6387_length_623_cov_4.034545_g5561_i0 PRJNA1005695 6387 623 4.034545 25.13521535 Hydra vulgaris 6087 Cnidaria other_Eukaryota 54.7 0.017   NTclustered gi|2744889029|ref|XM_065810454.1| 6087 g5561 i0 100 0.0930979133226324 29 0 5 0 381 409 2276 2248 PREDICTED: Hydra vulgaris kinesin-like protein KIF28P (LOC100208423), transcript variant X3, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
14182301 14182301 PRJNA1005695_P_NODE_38252_length_245_cov_2.500000_g37400_i0 PRJNA1005695 38252 245 2.5 6.125 Xenia sp. Carnegie-2017 2897299 Cnidaria other_Eukaryota 180 9.72e-41   NTclustered gi|2202634487|ref|XM_046993075.1| 2897299 g37400 i0 81.448 33.6285714285714 221 39 91 1 1 219 917 1137 PREDICTED: Xenia sp. Carnegie-2017 polyubiquitin (LOC124442587), mRNA blastn 8239 180 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017
20554652 20554652 PRJNA1005695_P_NODE_22557_length_316_cov_1.810700_g21705_i0 PRJNA1005695 22557 316 1.8107 5.721812 Clytia sp. 3 AFC-2016 1886627 Cnidaria other_Eukaryota 80.5 1.36e-10   NTclustered gi|1069323992|gb|KX665509.1| 1886627 g21705 i0 78.169 14.7753164556962 142 20 42 10 179 312 1735 1597 Clytia sp. 3 AFC-2016 voucher MZUSP:2801 28S ribosomal RNA gene, partial sequence blastn 4669 80.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia sp. 3 AFC-2016

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