RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA883229 · 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
8512917 8512917 PRJNA883229_P_NODE_7627_length_265_cov_1.625000_g7581_i0 PRJNA883229 7627 265 1.625 4.30625 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 270 6.14e-68   NTclustered gi|829194699|ref|XM_001025224.3| 312017 g7581 i0 87.607 0.883018867924528 234 27 88 2 31 263 359 127 Tetrahymena thermophila SB210 S25 ribosomal protein partial mRNA blastn 234 270 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8893974 8893974 PRJNA883229_P_NODE_3327_length_359_cov_1.073427_g3281_i0 PRJNA883229 3327 359 1.073427 3.85360293 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 593 4.5099999999999985e-165   NTclustered gi|1837628855|gb|MN158348.1| 5909 g3281 i0 99.691 93.7019498607242 324 1 100 0 1 324 2628 2951 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 33639 593 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
16162744 16162744 PRJNA883229_P_NODE_6633_length_280_cov_1.111111_g6587_i0 PRJNA883229 6633 280 1.111111 3.1111108 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 462 1.01e-125   NTclustered gi|759083562|gb|KM222179.1| 1607889 g6587 i0 96.429 56.1928571428571 280 10 100 0 1 280 593 314 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 15734 462 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta sp. FG-2015

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