RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA485080" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA485080 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
2372925 2372925 PRJNA485080_P_NODE_41842_length_242_cov_0.887574_g41748_i0 PRJNA485080 41842 242 0.887574 2.14792908 Metazoa 33208 Platyhelminthes Platyhelminthes 156 1.6200000000000002e-33   NTclustered gi|1084315499|ref|XM_018792062.1| 6183 g41748 i0 87.879 45.3181818181818 132 16 55 0 25 156 224 355 Schistosoma mansoni hypothetical protein partial mRNA blastn 10967 156 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
5552553 5552553 PRJNA485080_P_NODE_14385_length_297_cov_1.375000_g14291_i0 PRJNA485080 14385 297 1.375 4.08375 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 56.5 0.002   NTclustered gi|690818188|emb|LN312641.1| 99802 g14291 i0 100 0.101010101010101 30 0 10 0 148 177 243 214 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0093051 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
9377122 9377122 PRJNA485080_P_NODE_3708_length_486_cov_2.215496_g3614_i0 PRJNA485080 3708 486 2.215496 10.76731056 Diplorchis hangzhouensis 1131906 Platyhelminthes Platyhelminthes 54.7 0.013   NTclustered gi|379771686|gb|JQ038227.1| 1131906 g3614 i0 100 0.0596707818930041 29 0 6 0 330 358 5361 5389 Diplorchis hangzhouensis mitochondrion sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Polystomatidea Polystomatidae Diplorchis Diplorchis hangzhouensis
23401582 23401582 PRJNA485080_P_NODE_37639_length_244_cov_0.900585_g37545_i0 PRJNA485080 37639 244 0.900585 2.1974274 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 52.8 0.022   NTclustered gi|690472687|emb|LN012675.1| 99802 g37545 i0 100 0.114754098360656 28 0 11 0 30 57 1547 1574 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0012520 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
24675247 24675247 PRJNA485080_P_NODE_32220_length_246_cov_0.890173_g32126_i0 PRJNA485080 32220 246 0.890173 2.18982558 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 52.8 0.022   NTclustered gi|690644328|emb|LN191298.1| 99802 g32126 i0 100 0.113821138211382 28 0 11 0 1 28 196 169 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0026262 blastn 28 52.8 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);;