RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA704949 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
7069735 7069735 PRJNA704949_P_NODE_1639866_length_189_cov_2.292857_g1624527_i0 PRJNA704949 1639866 189 2.292857 4.33349973 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 274 3.18e-69   NTclustered gi|687192672|emb|LN209249.1| 99802 g1624527 i0 99.338 0.798941798941799 151 1 80 0 39 189 858 1008 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_contig0033398 blastn 151 274 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
8350056 8350056 PRJNA704949_P_NODE_34107_length_1338_cov_24.597362_g20933_i1 PRJNA704949 34107 1338 24.597362 329.11270356 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 351 1.2100000000000003e-91   NTclustered gi|690816508|emb|LN310741.1| 99802 g20933 i1 79.049 0.737668161434978 568 77 41 23 311 856 550 3 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0219101 blastn 987 351 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
10897982 10897982 PRJNA704949_P_NODE_198389_length_588_cov_1.866419_g184252_i0 PRJNA704949 198389 588 1.866419 10.97454372 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 67.6 2.08e-6   NTclustered gi|60605083|gb|AY812310.1| 6182 g184252 i0 100 5.02551020408163 36 0 6 0 33 68 40 75 Schistosoma japonicum SJCHGC09530 protein mRNA, partial cds blastn 2955 67.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
17277499 17277499 PRJNA704949_P_NODE_635694_length_339_cov_509.244828_g620369_i0 PRJNA704949 635694 339 509.244828 1726.33996692 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 91.6 6.78e-14   NTclustered gi|690593917|emb|LN146799.1| 99802 g620369 i0 100 0.63716814159292 49 0 14 0 1 49 1940 1988 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0133681 blastn 216 91.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
18545406 18545406 PRJNA704949_P_NODE_1960815_length_168_cov_1.260504_g1945476_i0 PRJNA704949 1960815 168 1.260504 2.11764672 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 289 9.879999999999999e-74   NTclustered gi|690852613|emb|LN352066.1| 99802 g1945476 i0 98.182 2.81547619047619 165 3 98 0 4 168 399 235 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0229253 blastn 473 289 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
19817043 19817043 PRJNA704949_P_NODE_1520516_length_199_cov_1.386667_g1505177_i0 PRJNA704949 1520516 199 1.386667 2.75946733 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 86.1 1.7e-12   NTclustered gi|690536207|emb|LN087622.1| 99802 g1505177 i0 94.545 3.52261306532663 55 3 28 0 22 76 338 392 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0083695 blastn 701 86.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
19823308 19823308 PRJNA704949_P_NODE_304516_length_487_cov_6.385845_g289693_i0 PRJNA704949 304516 487 6.385845 31.09906515 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 185 4.49e-42   NTclustered gi|690859839|emb|LN360282.1| 99802 g289693 i0 100 0.205338809034908 100 0 21 0 388 487 773 674 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0231299 blastn 100 185 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
19828185 19828185 PRJNA704949_P_NODE_83516_length_848_cov_14.078849_g20933_i2 PRJNA704949 83516 848 14.078849 119.38863952 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 355 5.809999999999999e-93   NTclustered gi|690816508|emb|LN310741.1| 99802 g20933 i2 79.032 1.14622641509434 558 87 63 18 3 538 1 550 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0219101 blastn 972 355 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
21098699 21098699 PRJNA704949_P_NODE_29937_length_1454_cov_23.390036_g20933_i0 PRJNA704949 29937 1454 23.390036 340.09112344 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 351 1.31e-91   NTclustered gi|690816508|emb|LN310741.1| 99802 g20933 i0 79.049 0.678817056396149 568 77 38 23 599 1144 3 550 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0219101 blastn 987 351 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
24929005 24929005 PRJNA704949_P_NODE_989780_length_262_cov_1.352113_g974445_i0 PRJNA704949 989780 262 1.352113 3.54253606 Didymorchis sp. Australia-DTJL-2002 216950 Platyhelminthes Platyhelminthes 73.1 1.83e-8   NTclustered gi|28273275|gb|AY157163.1| 216950 g974445 i0 88.71 0.370229007633588 62 4 23 3 192 252 2380 2439 Didymorchis sp. Australia-DTJL-2002 28S large subunit ribosomal RNA gene, partial sequence blastn 97 73.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Rhabdocoela Didymorchiidae Didymorchis Didymorchis sp. Australia-DTJL-2002

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