RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA853194" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA853194 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
5943873 5943873 PRJNA853194_S_NODE_55525_length_293_cov_1.240909_g54434_i0 PRJNA853194 55525 293 1.240909 3.63586337 Schistosoma haematobium 6185 Platyhelminthes Platyhelminthes 52.8 0.027   NTclustered gi|2318761541|ref|XM_051214273.1| 6185 g54434 i0 96.875 0.109215017064846 32 0 11 1 74 105 11372 11342 Schistosoma haematobium IQ motif and S7 domain-containing protein 1 (IQSEC1_2), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium
9768547 9768547 PRJNA853194_S_NODE_47248_length_315_cov_2.371901_g46157_i0 PRJNA853194 47248 315 2.371901 7.47148815 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 56.5 0.002   NTclustered gi|690489862|emb|LN034565.1| 99802 g46157 i0 89.362 0.149206349206349 47 1 14 4 20 62 3071 3025 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0033848 blastn 47 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
9768825 9768825 PRJNA853194_S_NODE_61188_length_280_cov_1.690821_g60097_i0 PRJNA853194 61188 280 1.690821 4.7342988 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 52.8 0.026   NTclustered gi|21308252|gb|AY067619.1| 79327 g60097 i0 100 0.1 28 0 10 0 75 102 259 232 Schmidtea mediterranea clone H.108.5b unknown mRNA sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
17419109 17419109 PRJNA853194_S_NODE_68474_length_265_cov_2.369792_g67383_i0 PRJNA853194 68474 265 2.369792 6.2799488 Taenia laticollis 1035110 Platyhelminthes Platyhelminthes 52.8 0.024   NTclustered gi|482651530|ref|NC_021140.1| 1035110 g67383 i0 100 0.105660377358491 28 0 11 0 98 125 1609 1636 Taenia laticollis mitochondrial DNA, complete genome, sample code: TlatFin1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Taenia Taenia laticollis
19967025 19967025 PRJNA853194_S_NODE_46856_length_316_cov_3.156379_g45765_i0 PRJNA853194 46856 316 3.156379 9.97415764 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 56.5 0.002   NTclustered gi|690579346|emb|LN130126.1| 99802 g45765 i0 92.308 0.974683544303797 39 3 12 0 278 316 1792 1754 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0120367 blastn 308 56.5 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);;