RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1010780" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1010780 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
155078 155078 PRJNA1010780_S_NODE_17081_length_475_cov_10.979545_g15819_i0 PRJNA1010780 17081 475 10.979545 52.15283875 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 734 0   NTclustered gi|68479954|gb|DQ076149.1| 6182 g15819 i0 96.818 0.926315789473684 440 13 93 1 20 459 450 12 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 440 734 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
155103 155103 PRJNA1010780_S_NODE_21461_length_372_cov_3.643917_g20172_i0 PRJNA1010780 21461 372 3.643917 13.55537124 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 305 2.46e-78   NTclustered gi|1842149|dbj|AB001051.1| 6161 g20172 i0 86.17 72.6532258064516 282 39 76 0 63 344 365 84 Dugesia japonica mRNA for ADP-ribosylation factor, complete cds blastn 27027 305 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
11633657 11633657 PRJNA1010780_S_NODE_18590_length_434_cov_70.894737_g17312_i0 PRJNA1010780 18590 434 70.894737 307.68315858 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 56.5 0.003   NTclustered gi|84617288|emb|AJ865376.1| 6161 g17312 i0 83.607 3.78801843317972 61 9 14 1 1 60 2 62 Dugesia japonica iwi gene for Piwi homologue blastn 1644 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
18006982 18006982 PRJNA1010780_S_NODE_56455_length_161_cov_1.888889_g55166_i0 PRJNA1010780 56455 161 1.888889 3.04111129 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 56.5 0.001   NTclustered gi|687179744|emb|LN123456.1| 99802 g55166 i0 97.059 0.416149068322981 34 0 20 1 45 77 2855 2888 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0114899 blastn 67 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
21831978 21831978 PRJNA1010780_S_NODE_5098_length_1202_cov_13.222793_g4594_i0 PRJNA1010780 5098 1202 13.222793 158.93797186 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 678 0   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g4594 i0 85.429 15.481697171381 652 95 54 0 373 1024 652 1 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 18609 678 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
25227792 25227792 PRJNA1010780_S_NODE_5520_length_1147_cov_5.705935_g4981_i0 PRJNA1010780 5520 1147 5.705935 65.44707445 Metazoa 33208 Platyhelminthes Platyhelminthes 449 3.5499999999999995e-121   NTclustered gi|58197522|dbj|AB200392.1| 6161 g4981 i0 84.464 31.3993025283348 457 70 40 1 660 1115 495 39 Dugesia japonica CaM mRNA for calmodulin, complete cds blastn 36015 449 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica

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