RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA781427 · 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
2037519 2037519 PRJNA781427_P_NODE_74242_length_251_cov_0.865169_g73358_i0 PRJNA781427 74242 251 0.865169 2.17157419 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 54.7 0.006   NTclustered gi|687368757|emb|LK757075.1| 57078 g73358 i0 100 0.115537848605578 29 0 12 0 154 182 101 129 Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0327070 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
8413962 8413962 PRJNA781427_P_NODE_50607_length_317_cov_0.946721_g49724_i0 PRJNA781427 50607 317 0.946721 3.00110557 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 219 2.77e-52   NTclustered gi|226467264|emb|FN320387.1| 6182 g49724 i0 85.047 61.2996845425868 214 32 68 0 5 218 1171 1384 Schistosoma japonicum isolate Anhui full length mRNA clone SJFCE3598.004|FSE001-P00018-D18, complete sequence blastn 19432 219 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
10965523 10965523 PRJNA781427_P_NODE_70389_length_260_cov_1.390374_g69505_i0 PRJNA781427 70389 260 1.390374 3.6149724 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 431 2.6e-116   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g69505 i0 96.538 8.93076923076923 260 9 100 0 1 260 8575 8316 Stenostomum sthenum mitochondrion, complete genome blastn 2322 431 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
12240052 12240052 PRJNA781427_P_NODE_33850_length_396_cov_2.383901_g32969_i0 PRJNA781427 33850 396 2.383901 9.44024796 Echinococcus granulosus 6210 Platyhelminthes Platyhelminthes 52.8 0.038   NTclustered gi|1373848774|ref|XM_024490764.1| 6210 g32969 i0 100 0.0707070707070707 28 0 7 0 50 77 1212 1185 Echinococcus granulosus Coiled-coil domain-containing protein (EGR_01515), partial mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus
18612582 18612582 PRJNA781427_P_NODE_54095_length_305_cov_0.995690_g53212_i0 PRJNA781427 54095 305 0.99569 3.0368545 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 60.2 1.7e-4   NTclustered gi|690493339|emb|LN039237.1| 99802 g53212 i0 100 4.60327868852459 32 0 10 0 207 238 6056 6087 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0038330 blastn 1404 60.2 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);;