RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA473201 · 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
2995043 2995043 PRJNA473201_P_NODE_70843_length_249_cov_0.875000_g70101_i0 PRJNA473201 70843 249 0.875 2.17875 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 54.7 0.006   NTclustered gi|690601964|emb|LN155797.1| 99802 g70101 i0 100 0.232931726907631 29 0 12 0 160 188 1039 1011 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0140542 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
17021057 17021057 PRJNA473201_P_NODE_34274_length_339_cov_1.406015_g33532_i0 PRJNA473201 34274 339 1.406015 4.76639085 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 154 8.53e-33   NTclustered gi|690929153|emb|LN438066.1| 99802 g33532 i0 82.123 4.87905604719764 179 32 53 0 156 334 132 310 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0186957 blastn 1654 154 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
21497072 21497072 PRJNA473201_P_NODE_70637_length_249_cov_0.875000_g69895_i0 PRJNA473201 70637 249 0.875 2.17875 Stenostomum 39238 Platyhelminthes Platyhelminthes 294 3.39e-75   NTclustered gi|10880358|emb|AJ405975.1| 52061 g69895 i0 87.952 91.7710843373494 249 30 100 0 1 249 274 26 Stenostomum leucops partial mitochondrial cytochrome oxidase c subunit I (cox1 gene), part 1 blastn 22851 294 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum leucops
23395632 23395632 PRJNA473201_P_NODE_20939_length_431_cov_1.650838_g20197_i0 PRJNA473201 20939 431 1.650838 7.11511178 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 752 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g20197 i0 98.144 47.631090487239 431 8 100 0 1 431 8964 8534 Stenostomum sthenum mitochondrion, complete genome blastn 20529 752 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
24670028 24670028 PRJNA473201_P_NODE_44660_length_305_cov_1.327586_g43918_i0 PRJNA473201 44660 305 1.327586 4.0491373 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 381 3.1899999999999997e-101   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g43918 i0 89.18 1 305 33 100 0 1 305 13597 13901 Stenostomum sthenum mitochondrion, complete genome blastn 305 381 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum

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