RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1248471" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1248471 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
5457060 5457060 PRJNA1248471_S_NODE_3945_length_277_cov_1.828947_g3845_i0 PRJNA1248471 3945 277 1.828947 5.06618319 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 52.8 0.025   NTclustered gi|690466949|emb|LN005271.1| 99802 g3845 i0 100 0.101083032490975 28 0 10 0 4 31 3907 3934 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0005221 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
8704776 8704776 PRJNA1248471_S_NODE_12227_length_194_cov_1.006897_g12127_i0 PRJNA1248471 12227 194 1.006897 1.95338018 Schyzocotyle 1697566 Platyhelminthes Platyhelminthes 84.2 5.94e-12   NTclustered gi|1028916002|gb|KX060596.1| 135513 g12127 i0 100 22.3659793814433 45 0 23 0 89 133 7604 7560 Schyzocotyle acheilognathi isolate CH1052 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 4339 84.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Bothriocephalidea Bothriocephalidae Schyzocotyle Schyzocotyle acheilognathi
20178135 20178135 PRJNA1248471_S_NODE_22296_length_161_cov_3.116071_g22196_i0 PRJNA1248471 22296 161 3.116071 5.01687431 Schistosoma 6181 Platyhelminthes Platyhelminthes 54.7 0.004   NTclustered gi|1084305774|ref|XM_018790254.1| 6183 g22196 i0 100 0.360248447204969 29 0 18 0 4 32 228 256 Schistosoma mansoni putative dna double-strand break repair rad50 ATPase partial mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni

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