RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB14175 · 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
25501520 25501520 PRJEB14175_P_NODE_112657_length_332_cov_10.435424_g110391_i0 PRJEB14175 112657 332 10.435424 34.64560768 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 187 8.219999999999999e-43   NTclustered gi|690681150|emb|LN233574.1| 99802 g110391 i0 88.462 67.8493975903614 156 17 47 1 159 313 302 147 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0188913 blastn 22526 187 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
25916158 25916158 PRJEB14175_P_NODE_257788_length_201_cov_2.164286_g255520_i0 PRJEB14175 257788 201 2.164286 4.35021486 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 62.1 2.9e-5   NTclustered gi|690506172|emb|LN055201.1| 99802 g255520 i0 93.023 0.213930348258706 43 2 21 1 78 119 2460 2418 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0053601 blastn 43 62.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
26182719 26182719 PRJEB14175_P_NODE_127126_length_308_cov_2.809717_g124859_i0 PRJEB14175 127126 308 2.809717 8.65392836 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 102 2.81e-17   NTclustered gi|687789777|emb|LK829830.1| 57078 g124859 i0 96.721 19.6038961038961 61 2 20 0 3 63 597 537 Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 blastn 6038 102 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
26183503 26183503 PRJEB14175_P_NODE_143686_length_284_cov_14.139013_g141419_i0 PRJEB14175 143686 284 14.139013 40.15479692 Urastoma cyprinae 84118 Platyhelminthes Platyhelminthes 111 4.27e-20   NTclustered gi|14530194|emb|AJ313230.1| 84118 g141419 i0 82.443 48.1866197183099 131 20 46 3 131 261 815 688 Urastoma cyprinae partial 28S rRNA gene blastn 13685 111 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora   Urastomidae Urastoma Urastoma cyprinae
26321099 26321099 PRJEB14175_P_NODE_184839_length_240_cov_7.843575_g182572_i0 PRJEB14175 184839 240 7.843575 18.82458 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 54.7 0.006   NTclustered gi|690543326|emb|LN096236.1| 99802 g182572 i0 100 0.120833333333333 29 0 12 0 44 72 929 901 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0091419 blastn 29 54.7 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);;