RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA438111 · 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
8087368 8087368 PRJNA438111_P_NODE_36627_length_200_cov_4.690058_g36002_i0 PRJNA438111 36627 200 4.690058 9.380116 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.017   NTclustered gi|2918369565|emb|OZ237731.1| 317547 g36002 i0 100 0.14 28 0 14 0 66 93 9604012 9603985 Eunicella cavolini genome assembly, chromosome: 15 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
9361932 9361932 PRJNA438111_P_NODE_24808_length_218_cov_5.386243_g24183_i0 PRJNA438111 24808 218 5.386243 11.74200974 Hydra vulgaris 6087 Cnidaria other_Eukaryota 126 1.12e-24   NTclustered gi|2744810571|ref|XM_047277555.2| 6087 g24183 i0 81.25 5.04587155963303 160 26 72 3 2 159 1751 1594 PREDICTED: Hydra vulgaris neutral alpha-glucosidase AB (LOC100215131), transcript variant X1, mRNA blastn 1100 126 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
20836428 20836428 PRJNA438111_P_NODE_9437_length_331_cov_9.973510_g8817_i0 PRJNA438111 9437 331 9.97351 33.0123181 Hydra vulgaris 6087 Cnidaria other_Eukaryota 104 8.48e-18   NTclustered gi|2744907926|ref|XM_065819248.1| 6087 g8817 i0 76.077 0.631419939577039 209 44 62 6 124 329 1811 1606 PREDICTED: Hydra vulgaris lysine--tRNA ligase-like (LOC136072001), mRNA blastn 209 104 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
23386010 23386010 PRJNA438111_P_NODE_16259_length_262_cov_2.506438_g15634_i0 PRJNA438111 16259 262 2.506438 6.56686756 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 82.4 3.05e-11   NTclustered gi|1778046360|ref|XM_031704982.1| 6105 g15634 i0 97.872 0.50381679389313 47 1 18 0 22 68 1000 1046 PREDICTED: Actinia tenebrosa vacuole membrane protein 1-like (LOC116296874), transcript variant X2, mRNA blastn 132 82.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa

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