RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1101946 · 3 ✖

analysis 1

  • blastn · 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
1485941 1485941 PRJNA1101946_S_NODE_3582_length_339_cov_3.848276_g3483_i0 PRJNA1101946 3582 339 3.848276 13.04565564 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 586 7.1e-163   NTclustered gi|60600058|gb|AY810684.1| 6182 g3483 i0 100 8.65191740412979 317 0 94 0 1 317 262 578 Schistosoma japonicum SJCHGC04723 protein mRNA, partial cds blastn 2933 586 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
5314145 5314145 PRJNA1101946_S_NODE_25805_length_158_cov_592.385321_g25706_i0 PRJNA1101946 25805 158 592.385321 935.96880718 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 278 1.98e-70   NTclustered gi|56757963|gb|AY815390.1| 6182 g25706 i0 98.125 124.632911392405 160 1 100 1 1 158 1920 1761 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 19692 278 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
14240063 14240063 PRJNA1101946_S_NODE_5712_length_299_cov_6.528000_g5613_i0 PRJNA1101946 5712 299 6.528 19.51872 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 54.7 0.008   NTclustered gi|687322327|emb|LK415164.1| 57078 g5613 i0 92.105 0.127090301003344 38 3 13 0 6 43 1706 1743 Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0021439 blastn 38 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum

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