RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA399133", tax_clade = "Sar" 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

  • PRJNA399133 · 3 ✖

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
6790881 6790881 PRJNA399133_P_NODE_10506_length_163_cov_0.875000_g10418_i0 PRJNA399133 10506 163 0.875 1.42625 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 252 1.25e-62   NTclustered gi|1837628855|gb|MN158348.1| 5909 g10418 i0 94.479 8.04294478527607 163 9 100 0 1 163 5032 5194 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 1311 252 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
16383316 16383316 PRJNA399133_P_NODE_8253_length_182_cov_3.054422_g8165_i0 PRJNA399133 8253 182 3.054422 5.55904804 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 141 3.21e-29   NTclustered gi|404425902|gb|JX310031.1| 655661 g8165 i0 92.857 8.50549450549451 98 5 98 1 81 178 2409 2314 Wilbertia typica voucher PXM20100628 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 1548 141 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Eurystomatellidae Wilbertia Wilbertia typica
18932334 18932334 PRJNA399133_P_NODE_2755_length_301_cov_1.657895_g2667_i0 PRJNA399133 2755 301 1.657895 4.99026395 Hymenostomatida 31277 SAR_Eukaryotes SAR_Eukaryotes 529 1.0599999999999996e-145   NTclustered gi|1468800191|gb|MH822305.1| 5927 g2667 i0 98.339 100.019933554817 301 5 100 0 1 301 257 557 Dexiostoma campyla strain Tue2015_Dex small subunit ribosomal RNA gene, partial sequence blastn 30106 529 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Turaniellidae Dexiostoma Dexiostoma campyla

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