RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1087264" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1087264 · 3 ✖

analysis 1

  • diamond · 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
16770963 16770963 PRJNA1087264_P_NODE_13454_length_171_cov_2.090164_g13372_i0 PRJNA1087264 13454 171 2.090164 3.57418044 Calicophoron daubneyi 300641 Platyhelminthes Platyhelminthes 94.4 6.31e-22   NR CAL5135349.1 300641 g13372 i0 82.1 0.982456140350877 56 10 98.2 0 2 169 57 112 CAL5135349.1 unnamed protein product [Calicophoron daubneyi] diamond 168 94.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Paramphistomidae Calicophoron Calicophoron daubneyi
28109652 28109652 PRJNA1087264_P_NODE_10545_length_194_cov_1.544828_g10463_i0 PRJNA1087264 10545 194 1.544828 2.99696632 Cichlidogyrus casuarinus 1844966 Platyhelminthes Platyhelminthes 53.5 2.98e-6   NR KAL3320168.1 1844966 g10463 i0 47.1 1.05154639175258 68 32 99 2 194 3 247 314 KAL3320168.1 hypothetical protein Ciccas_001136 [Cichlidogyrus casuarinus] diamond 204 53.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Dactylogyridea Ancyrocephalidae Cichlidogyrus Cichlidogyrus casuarinus
29143453 29143453 PRJNA1087264_P_NODE_14189_length_167_cov_0.864407_g14107_i0 PRJNA1087264 14189 167 0.864407 1.44355969 Opisthorchiidae 6196 Platyhelminthes Platyhelminthes 51.2 1.36e-5   NR XP_009172925.1 6198 g14107 i0 43.8 4.31137724550898 48 27 86.2 0 165 22 525 572 XP_009172925.1 hypothetical protein T265_08769 [Opisthorchis viverrini] diamond 720 51.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Opisthorchiida Opisthorchiidae Opisthorchis Opisthorchis viverrini

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