RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJEB12366", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 2 ✖

tax_clade 1

bioproject 1

  • PRJEB12366 · 2 ✖

analysis 1

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
5123196 5123196 PRJEB12366_P_NODE_8445_length_268_cov_1.201717_g8255_i0 PRJEB12366 8445 268 1.201717 3.22060156 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 189 1.7899999999999996e-43   NTclustered gi|829188477|ref|XM_001023087.3| 312017 g8255 i0 82.87 16.8022388059701 216 31 79 6 54 266 1050 838 Tetrahymena thermophila SB210 S-adenosyl-L-homocysteine hydrolase partial mRNA blastn 4503 189 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
24246551 24246551 PRJEB12366_P_NODE_17500_length_165_cov_1.946154_g17310_i0 PRJEB12366 17500 165 1.946154 3.2111541 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 300 4.46e-77   NTclustered gi|759083562|gb|KM222179.1| 1607889 g17310 i0 99.394 98.8848484848485 165 1 100 0 1 165 789 625 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 16316 300 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);;