RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1174207 · 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
17618517 17618517 PRJNA1174207_P_NODE_37134_length_246_cov_1.780347_g36605_i0 PRJNA1174207 37134 246 1.780347 4.37965362 Haliotis 6452 Mollusca Mollusca 159 1.27e-34   NTclustered gi|2911890353|ref|XM_071225229.1| 6455 g36605 i0 79.06 24.0162601626016 234 47 95 2 14 246 117 349 PREDICTED: Haliotis cracherodii calmodulin (LOC139444295), mRNA blastn 5908 159 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis cracherodii
21992271 21992271 PRJNA1174207_P_NODE_30558_length_262_cov_1.920635_g30029_i0 PRJNA1174207 30558 262 1.920635 5.0320637 Mya arenaria 6604 Mollusca Mollusca 54.7 0.007   NTclustered gi|2427386575|ref|XM_052916440.1| 6604 g30029 i0 100 0.110687022900763 29 0 11 0 94 122 1596 1568 PREDICTED: Mya arenaria telomerase protein component 1-like (LOC128211536), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
24541655 24541655 PRJNA1174207_P_NODE_30480_length_262_cov_4.211640_g29951_i0 PRJNA1174207 30480 262 4.21164 11.0344968 Perna canaliculus 38949 Mollusca Mollusca 477 3.329999999999999e-130   NTclustered gi|1655427700|gb|MK419109.1| 38949 g29951 i0 100 98.5343511450382 258 0 98 0 1 258 3008 3265 Perna canaliculus isolate N3 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, and 28S-18S intergenic spacer, complete sequence blastn 25816 477 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Perna Perna canaliculus

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