RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA263496 · 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
10573229 10573229 PRJNA263496_P_NODE_17289_length_187_cov_1.478261_g17036_i0 PRJNA263496 17289 187 1.478261 2.76434807 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 147 7.139999999999999e-31   NTclustered gi|393794643|dbj|AK389067.1| 6161 g17036 i0 83.439 4.74866310160428 157 26 84 0 1 157 199 43 Dugesia japonica cDNA, clone: Dj_aH_000_07236HH.full, full-insert sequence, expressed in adult head blastn 888 147 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
11847856 11847856 PRJNA263496_P_NODE_18910_length_178_cov_1.581395_g18657_i0 PRJNA263496 18910 178 1.581395 2.8148831 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 163 6.67e-36   NTclustered gi|1084307901|ref|XM_018791342.1| 6183 g18657 i0 88.722 34.6516853932584 133 15 75 0 1 133 162 30 Schistosoma mansoni tubulin beta chain,putative partial mRNA blastn 6168 163 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
18220765 18220765 PRJNA263496_P_NODE_14875_length_202_cov_2.620915_g14622_i0 PRJNA263496 14875 202 2.620915 5.2942483 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 110 1.03e-19   NTclustered gi|1084309800|ref|XM_018790535.1| 6183 g14622 i0 80.537 11.1633663366337 149 23 72 5 52 197 740 595 Schistosoma mansoni 60S ribosomal protein L8, putative partial mRNA blastn 2255 110 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);;