RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA505837" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA505837 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
2386014 2386014 PRJNA505837_S_NODE_482_length_207_cov_23.612360_g467_i0 PRJNA505837 482 207 23.61236 48.8775852 root 1 Root_unresolved Root_unresolved 383 5.65e-102   NTclustered gi|10832|emb|X54512.1| 5911 g467 i0 100 91.6570048309179 207 0 100 0 1 207 8322 8116 T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA blastn 18973 383 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
15138520 15138520 PRJNA505837_S_NODE_112_length_392_cov_5.608815_g97_i0 PRJNA505837 112 392 5.608815 21.9865548 root 1 Root_unresolved Root_unresolved 702 0   NTclustered gi|345541658|gb|JN547815.1| 5911 g97 i0 98.98 69.2933673469388 392 4 100 0 1 392 3806 3415 Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence blastn 27163 702 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
15786395 15786395 PRJNA505837_S_NODE_973_length_152_cov_2.463415_g958_i0 PRJNA505837 973 152 2.463415 3.7443908 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 265 1.47e-66   NTclustered gi|1241841575|gb|KY273140.1| 5908 g958 i0 98.026 23.2171052631579 152 3 100 0 1 152 168 17 Tetrahymena pyriformis isolate 1289-2 large subunit ribosomal RNA gene, partial sequence; macronuclear blastn 3529 265 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
18962084 18962084 PRJNA505837_S_NODE_355_length_244_cov_6.348837_g340_i0 PRJNA505837 355 244 6.348837 15.49116228 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 446 8.639999999999999e-121   NTclustered gi|1837628855|gb|MN158348.1| 5909 g340 i0 99.59 96.6516393442623 244 1 100 0 1 244 2901 2658 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 23583 446 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata

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