RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA195897 · 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
1640752 1640752 PRJNA195897_P_NODE_2902_length_290_cov_1.165975_g2869_i0 PRJNA195897 2902 290 1.165975 3.3813275 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 124 5.61e-24   NTclustered gi|1619621337|ref|XM_028657565.1| 2652724 g2869 i0 89 0.344827586206897 100 11 34 0 191 290 1056 957 PREDICTED: Exaiptasia diaphana ADP,ATP carrier protein 1, mitochondrial (LOC110234027), mRNA blastn 100 124 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
6743686 6743686 PRJNA195897_P_NODE_8266_length_175_cov_1.238095_g8233_i0 PRJNA195897 8266 175 1.238095 2.16666625 Anemonia sulcata 6108 Cnidaria other_Eukaryota 89.8 1.12e-13   NTclustered gi|2917940720|emb|OZ237562.1| 6108 g8233 i0 90.141 31.8914285714286 71 4 51 3 24 93 13380741 13380809 Anemonia sulcata genome assembly, chromosome: 8 blastn 5581 89.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
18217660 18217660 PRJNA195897_P_NODE_2095_length_353_cov_1.075658_g2062_i0 PRJNA195897 2095 353 1.075658 3.79707274 Anemonia sulcata 6108 Cnidaria other_Eukaryota 60.2 1.99e-4   NTclustered gi|2917940752|emb|OZ237570.1| 6108 g2062 i0 97.143 0.198300283286119 35 1 10 0 244 278 7719785 7719819 Anemonia sulcata genome assembly, chromosome: 16 blastn 70 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata

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