RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB25789" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 3 ✖

tax_clade 1

bioproject 1

  • PRJEB25789 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_kingdom 0

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
5125531 5125531 PRJEB25789_S_NODE_15245_length_259_cov_2.064516_g15166_i0 PRJEB25789 15245 259 2.064516 5.34709644 Epistylis sp. FG-2015 1607876 SAR_Eukaryotes SAR_Eukaryotes 479 9.13e-131   NTclustered gi|759083557|gb|KM222174.1| 1607876 g15166 i0 100 67.1969111969112 259 0 100 0 1 259 576 318 Epistylis sp. FG-2015 voucher SZ2011052302 large subunit ribosomal RNA gene, partial sequence blastn 17404 479 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis sp. FG-2015
6401355 6401355 PRJEB25789_S_NODE_19886_length_241_cov_1.488095_g19807_i0 PRJEB25789 19886 241 1.488095 3.58630895 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 189 1.58e-43   NTclustered gi|220966760|gb|FJ545743.1| 94289 g19807 i0 97.297 39.4771784232365 111 3 46 0 131 241 6001 5891 Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear blastn 9514 189 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
6401369 6401369 PRJEB25789_S_NODE_20566_length_229_cov_2.961538_g20487_i0 PRJEB25789 20566 229 2.961538 6.78192202 Lamtostyla gui 2678605 SAR_Eukaryotes SAR_Eukaryotes 143 1.18e-29   NTclustered gi|1778223994|gb|MN733822.1| 2678605 g20487 i0 91.346 30.2576419213974 104 9 45 0 1 104 4443 4340 Lamtostyla gui isolate LWY2015111409 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 6929 143 1 Eukaryota Sar   Ciliophora Spirotrichea Stichotrichida Amphisiellidae Lamtostyla Lamtostyla gui

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