RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1120771" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1120771 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
2827291 2827291 PRJNA1120771_S_NODE_26743_length_232_cov_3.460317_g26343_i0 PRJNA1120771 26743 232 3.460317 8.02793544 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 374 3.9e-99   NTclustered gi|68479954|gb|DQ076149.1| 6182 g26343 i0 95.708 1.00431034482759 233 8 100 2 1 232 454 223 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 233 374 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
15579427 15579427 PRJNA1120771_S_NODE_1693_length_673_cov_8.238095_g1388_i0 PRJNA1120771 1693 673 8.238095 55.44237935 Diplorchis hangzhouensis 1131906 Platyhelminthes Platyhelminthes 54.7 0.019   NTclustered gi|379771686|gb|JQ038227.1| 1131906 g1388 i0 100 0.0430906389301634 29 0 4 0 163 191 5361 5389 Diplorchis hangzhouensis mitochondrion sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Polystomatidea Polystomatidae Diplorchis Diplorchis hangzhouensis
18880153 18880153 PRJNA1120771_S_NODE_24735_length_240_cov_3.959391_g24335_i0 PRJNA1120771 24735 240 3.959391 9.5025384 Metazoa 33208 Platyhelminthes Platyhelminthes 52.8 0.022   NTclustered gi|15283994|gb|AY033597.1| 6182 g24335 i0 100 0.7 28 0 12 0 157 184 355 382 Schistosoma japonicum high voltage-activated calcium channel beta subunit CavB mRNA, complete cds blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
24502497 24502497 PRJNA1120771_S_NODE_15640_length_286_cov_6.131687_g15240_i0 PRJNA1120771 15640 286 6.131687 17.53662482 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 52.8 0.026   NTclustered gi|690596878|emb|LN150304.1| 99802 g15240 i0 100 0.0979020979020979 28 0 10 0 156 183 1801 1774 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0136384 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei

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