RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA533623 · 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
1117957 1117957 PRJNA533623_P_NODE_59141_length_257_cov_2.392857_g57361_i0 PRJNA533623 59141 257 2.392857 6.14964249 root 1 Root_unresolved Root_unresolved 433 7.15e-117   NTclustered gi|226473461|emb|FN315684.1| 6182 g57361 i0 100 91.0505836575876 234 0 91 0 24 257 437 204 Schistosoma japonicum isolate Anhui full length mRNA clone SJFCA3765.008|FSA001-P00027-C16, complete sequence blastn 23400 433 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
3057317 3057317 PRJNA533623_P_NODE_34823_length_377_cov_0.987342_g33051_i0 PRJNA533623 34823 377 0.987342 3.72227934 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 52.8 0.036   NTclustered gi|393794191|dbj|AK388788.1| 6161 g33051 i0 100 0.0742705570291777 28 0 7 0 267 294 1772 1799 Dugesia japonica cDNA, clone: Dj_aH_000_02497HH.full, full-insert sequence, expressed in adult head blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
3669440 3669440 PRJNA533623_P_NODE_69103_length_223_cov_1.253086_g67322_i0 PRJNA533623 69103 223 1.253086 2.79438178 Prorhynchidae 6170 Platyhelminthes Platyhelminthes 65.8 2.54e-6   NTclustered gi|588313896|gb|KC869854.1| 6172 g67322 i0 93.182 5.10313901345291 44 3 20 0 22 65 2167 2210 Geocentrophora baltica 28S ribosomal RNA gene, partial sequence blastn 1138 65.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Lecithoepitheliata Prorhynchidae Geocentrophora Geocentrophora baltica
11985643 11985643 PRJNA533623_P_NODE_58630_length_259_cov_2.085859_g56850_i0 PRJNA533623 58630 259 2.085859 5.40237481 Didymorchis sp. Australia-DTJL-2002 216950 Platyhelminthes Platyhelminthes 73.1 1.81e-8   NTclustered gi|28273275|gb|AY157163.1| 216950 g56850 i0 88.71 0.374517374517374 62 4 24 3 63 123 2439 2380 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);;