RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA515078 · 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
13240861 13240861 PRJNA515078_P_NODE_8891_length_306_cov_2.881041_g8658_i0 PRJNA515078 8891 306 2.881041 8.81598546 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 388 1.92e-103   NTclustered gi|68479954|gb|DQ076149.1| 6182 g8658 i0 89.577 1.00326797385621 307 30 100 2 1 306 12 317 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 307 388 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
17688855 17688855 PRJNA515078_P_NODE_5014_length_426_cov_1.583548_g4781_i0 PRJNA515078 5014 426 1.583548 6.74591448 Opisthokonta 33154 Platyhelminthes Platyhelminthes 56.5 0.003   NTclustered gi|690487532|emb|LN031707.1| 99802 g4781 i0 100 0.73943661971831 30 0 7 0 35 64 4195 4224 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0031074 blastn 315 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
18338452 18338452 PRJNA515078_P_NODE_1615_length_768_cov_1.458276_g1446_i0 PRJNA515078 1615 768 1.458276 11.19955968 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 54.7 0.021   NTclustered gi|690474539|emb|LN014998.1| 99802 g1446 i0 100 0.0377604166666667 29 0 4 0 541 569 8694 8722 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0014793 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
23439241 23439241 PRJNA515078_P_NODE_18299_length_203_cov_1.644578_g18066_i0 PRJNA515078 18299 203 1.644578 3.33849334 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 58.4 3.8e-4   NTclustered gi|690486651|emb|LN030606.1| 99802 g18066 i0 100 6.65024630541872 31 0 15 0 166 196 279 249 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0030016 blastn 1350 58.4 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);;