RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1123686 · 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
1555469 1555469 PRJNA1123686_S_NODE_12002_length_179_cov_13.553333_g11970_i0 PRJNA1123686 12002 179 13.553333 24.26046607 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 60.2 9.06e-5   NTclustered gi|1084296408|ref|XM_018799522.1| 6183 g11970 i0 100 1.46927374301676 32 0 18 0 148 179 1635 1666 Schistosoma mansoni putative slingshot dual specificity phosphatase partial mRNA blastn 263 60.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
8683252 8683252 PRJNA1123686_S_NODE_5947_length_219_cov_26.421053_g5915_i0 PRJNA1123686 5947 219 26.421053 57.86210607 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 0.019   NTclustered gi|2318764958|ref|XM_051218950.1| 6185 g5915 i0 100 0.525114155251142 28 0 13 0 5 32 1054 1027 Schistosoma haematobium uncharacterized protein (MS3_00010575), mRNA blastn 115 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium
13034617 13034617 PRJNA1123686_S_NODE_5511_length_224_cov_8.917949_g5479_i0 PRJNA1123686 5511 224 8.917949 19.97620576 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 409 1.03e-109   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g5479 i0 99.554 13.0848214285714 224 1 100 0 1 224 8980 8757 Stenostomum sthenum mitochondrion, complete genome blastn 2931 409 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum

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