RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB2925 · 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
6404291 6404291 PRJEB2925_P_NODE_15326_length_257_cov_2.058559_g14048_i0 PRJEB2925 15326 257 2.058559 5.29049663 Mizuhopecten yessoensis 6573 Mollusca Mollusca 99 2.96e-16   NTclustered gi|1207979940|ref|XM_021483812.1| 6573 g14048 i0 81.897 0.45136186770428 116 21 45 0 50 165 34 149 PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S24-like (LOC110440645), partial mRNA blastn 116 99 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
10228953 10228953 PRJEB2925_P_NODE_8289_length_429_cov_1.791878_g7055_i0 PRJEB2925 8289 429 1.791878 7.68715662 Mya arenaria 6604 Mollusca Mollusca 58.4 8.89e-4   NTclustered gi|2427531503|ref|XM_052963179.1| 6604 g7055 i0 100 0.275058275058275 31 0 7 0 296 326 1836 1806 PREDICTED: Mya arenaria uncharacterized LOC128244994 (LOC128244994), partial mRNA blastn 118 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
16290798 16290798 PRJEB2925_P_NODE_6453_length_512_cov_31.018868_g5322_i0 PRJEB2925 6453 512 31.018868 158.81660416 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 75 1.07e-8   NTclustered gi|2693871861|ref|XR_010104559.1| 6551 g5322 i0 100 9.236328125 40 0 8 0 473 512 3317 3278 PREDICTED: Mytilus trossulus large subunit ribosomal RNA (LOC134702777), rRNA blastn 4729 75 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus

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