RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA924320" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA924320 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
6002470 6002470 PRJNA924320_S_NODE_48205_length_166_cov_0.871795_g48063_i0 PRJNA924320 48205 166 0.871795 1.4471797 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 296 5.82e-76   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g48063 i0 98.795 84.9156626506024 166 2 100 0 1 166 8945 8780 Stenostomum sthenum mitochondrion, complete genome blastn 14096 296 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
9827041 9827041 PRJNA924320_S_NODE_40268_length_177_cov_1.148438_g40126_i0 PRJNA924320 40268 177 1.148438 2.03273526 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 182 1.83e-41   NTclustered gi|226471717|emb|FN315208.1| 6182 g40126 i0 85.882 17.954802259887 170 24 96 0 1 170 565 734 Schistosoma japonicum isolate Anhui full length mRNA clone SJFCA3598.008|FSA001-P00032-F13, complete sequence blastn 3178 182 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
13652942 13652942 PRJNA924320_S_NODE_4271_length_455_cov_46.788177_g4130_i0 PRJNA924320 4271 455 46.788177 212.88620535 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 732 0   NTclustered gi|68479954|gb|DQ076149.1| 6182 g4130 i0 96.811 0.964835164835165 439 13 96 1 16 454 12 449 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 439 732 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
14927072 14927072 PRJNA924320_S_NODE_23252_length_219_cov_1.200000_g23110_i0 PRJNA924320 23252 219 1.2 2.628 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 178 3.06e-40   NTclustered gi|1084307901|ref|XM_018791342.1| 6183 g23110 i0 85.799 21.0684931506849 169 23 77 1 48 216 27 194 Schistosoma mansoni tubulin beta chain,putative partial mRNA blastn 4614 178 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
21301276 21301276 PRJNA924320_S_NODE_40537_length_176_cov_1.606299_g40395_i0 PRJNA924320 40537 176 1.606299 2.82708624 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 91.6 3.15e-14   NTclustered gi|1084298757|ref|XM_018797433.1| 6183 g40395 i0 88.158 2.3125 76 9 43 0 1 76 1245 1320 Schistosoma mansoni putative tubulin beta chain partial mRNA blastn 407 91.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
21301382 21301382 PRJNA924320_S_NODE_52057_length_164_cov_0.886957_g51915_i0 PRJNA924320 52057 164 0.886957 1.45460948 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 122 1.03e-23   NTclustered gi|21308864|gb|AY068231.1| 79327 g51915 i0 82.734 4.31707317073171 139 22 84 2 6 143 222 359 Schmidtea mediterranea clone H.2.10h(T3) unknown mRNA sequence blastn 708 122 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
25125276 25125276 PRJNA924320_S_NODE_37100_length_183_cov_1.141791_g36958_i0 PRJNA924320 37100 183 1.141791 2.08947753 Dicrocoelium dendriticum 57078 Platyhelminthes Platyhelminthes 52.8 0.016   NTclustered gi|687550989|emb|LK641613.1| 57078 g36958 i0 100 0.153005464480874 28 0 15 0 19 46 773 746 Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0225147 blastn 28 52.8 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);;