RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA811237" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA811237 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
808757 808757 PRJNA811237_S_NODE_17861_length_197_cov_2.222973_g17621_i0 PRJNA811237 17861 197 2.222973 4.37925681 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 54.7 0.005   NTclustered gi|690662482|emb|LN212137.1| 99802 g17621 i0 100 0.147208121827411 29 0 15 0 68 96 276 248 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0177493 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
7187120 7187120 PRJNA811237_S_NODE_8486_length_259_cov_1.695238_g8246_i0 PRJNA811237 8486 259 1.695238 4.39066642 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 56.5 0.002   NTclustered gi|687615833|emb|LK515075.1| 57078 g8246 i0 100 0.227799227799228 30 0 12 0 2 31 1113 1142 Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0115118 blastn 59 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Dicrocoeliidae Dicrocoelium Dicrocoelium dendriticum
12288128 12288128 PRJNA811237_S_NODE_2610_length_448_cov_19.438596_g2370_i0 PRJNA811237 2610 448 19.438596 87.08491008 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 542 2.11e-149   NTclustered gi|68479954|gb|DQ076149.1| 6182 g2370 i0 90.024 0.939732142857143 421 39 94 3 16 434 13 432 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 421 542 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
21211003 21211003 PRJNA811237_S_NODE_2537_length_454_cov_16.074074_g2298_i0 PRJNA811237 2537 454 16.074074 72.97629596 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 730 0   NTclustered gi|68479954|gb|DQ076149.1| 6182 g2298 i0 96.804 0.964757709251101 438 13 96 1 2 439 449 13 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 438 730 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum

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