RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA833575" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA833575 · 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
19950890 19950890 PRJNA833575_P_NODE_37336_length_239_cov_1.076471_g37199_i0 PRJNA833575 37336 239 1.076471 2.57276569 Mytilus trossulus 6551 Mollusca Mollusca 139 1.6e-28   NTclustered gi|2694136893|ref|XM_063544320.1| 6551 g37199 i0 85.606 15.5481171548117 132 19 55 0 40 171 302 171 PREDICTED: Mytilus trossulus actin-like (LOC134684992), mRNA blastn 3716 139 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus
22501263 22501263 PRJNA833575_P_NODE_38518_length_235_cov_0.867470_g38381_i0 PRJNA833575 38518 235 0.86747 2.0385545 Ylistrum balloti 509963 Mollusca Mollusca 65.8 2.71e-6   NTclustered gi|2592054721|ref|XM_060206516.1| 509963 g38381 i0 79.048 0.446808510638298 105 15 43 6 1 100 290 188 PREDICTED: Ylistrum balloti ATP synthase subunit alpha, mitochondrial-like (LOC132543061), mRNA blastn 105 65.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Ylistrum Ylistrum balloti
25455691 25455691 PRJNA833575_P_NODE_44600_length_228_cov_0.905660_g44463_i0 PRJNA833575 44600 228 0.90566 2.0649048 Metazoa 33208 Mollusca Mollusca 54.7 0.006   NTclustered gi|2911908276|ref|XM_071231849.1| 6455 g44463 i0 100 1.5219298245614 29 0 13 0 14 42 2842 2814 PREDICTED: Haliotis cracherodii uncharacterized protein (LOC139450171), mRNA blastn 347 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis cracherodii

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