RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB6054 · 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
25523095 25523095 PRJEB6054_S_NODE_3145_length_261_cov_1407.398230_g3056_i0 PRJEB6054 3145 261 1407.39823 3673.3093803 Xenia sp. Carnegie-2 86540 Cnidaria other_Eukaryota 161 3.79e-35   NTclustered gi|2202601729|ref|XM_046994017.1| 2897299 g3056 i0 81.818 72.3103448275862 198 30 75 5 10 206 200 392 PREDICTED: Xenia sp. Carnegie-2017 ubiquitin-40S ribosomal protein S27a (LOC124443556), mRNA blastn 18873 161 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017
26067156 26067156 PRJEB6054_S_NODE_11949_length_165_cov_2.430769_g11860_i0 PRJEB6054 11949 165 2.430769 4.01076885 Eunicella cavolini 317547 Cnidaria other_Eukaryota 54.7 0.004   NTclustered gi|2918369554|emb|OZ237726.1| 317547 g11860 i0 96.97 0.387878787878788 33 0 20 1 3 35 14664382 14664413 Eunicella cavolini genome assembly, chromosome: 10 blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
26339248 26339248 PRJEB6054_S_NODE_11799_length_166_cov_1.190840_g11710_i0 PRJEB6054 11799 166 1.19084 1.9767944 Hydra vulgaris 6087 Cnidaria other_Eukaryota 113 6.290000000000001e-21   NTclustered gi|2744834223|ref|XM_002160863.4| 6087 g11710 i0 84.483 11.3493975903614 116 17 69 1 20 134 629 514 PREDICTED: Hydra vulgaris S-phase kinase-associated protein 1 (LOC100212686), mRNA blastn 1884 113 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);;