RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA725806 · 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
711977 711977 PRJNA725806_P_NODE_78601_length_214_cov_26.536723_g78300_i0 PRJNA725806 78601 214 26.536723 56.78858722 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.019   NTclustered gi|829186784|ref|XM_001031547.2| 312017 g78300 i0 94.286 0.163551401869159 35 1 16 1 34 68 3900 3867 Tetrahymena thermophila SB210 chromo(CHRromatin organization modifier) domain protein partial mRNA blastn 35 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
1987949 1987949 PRJNA725806_P_NODE_53842_length_243_cov_2.383495_g53545_i0 PRJNA725806 53842 243 2.383495 5.79189285 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|471227863|ref|XM_004034783.1| 5932 g53545 i0 100 0.11522633744856 28 0 12 0 23 50 66 39 Ichthyophthirius multifiliis coiled-coil domain protein (IMG5_112150) mRNA, complete cds blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
7090728 7090728 PRJNA725806_P_NODE_73126_length_220_cov_2.732240_g72825_i0 PRJNA725806 73126 220 2.73224 6.010928 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.019   NTclustered gi|829099662|ref|XM_012795313.1| 312017 g72825 i0 100 0.127272727272727 28 0 13 0 139 166 214 241 Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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