RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1074408" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1074408 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
1016455 1016455 PRJNA1074408_S_NODE_8041_length_166_cov_1.016260_g7911_i0 PRJNA1074408 8041 166 1.01626 1.6869916 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 219 1.3e-52   NTclustered gi|1837628855|gb|MN158348.1| 5909 g7911 i0 99.174 62.7048192771084 121 1 73 0 46 166 2787 2907 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 10409 219 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
4017535 4017535 PRJNA1074408_S_NODE_6084_length_188_cov_1.531034_g5954_i0 PRJNA1074408 6084 188 1.531034 2.87834392 Tetrahymena chironomi 3034767 SAR_Eukaryotes SAR_Eukaryotes 337 3.97e-88   NTclustered gi|2459327221|gb|OQ626840.1| 3034767 g5954 i0 98.936 87.1702127659574 188 2 100 0 1 188 657 470 Tetrahymena chironomi isolate LLH20220320 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 16388 337 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena chironomi
11669659 11669659 PRJNA1074408_S_NODE_3950_length_233_cov_1.173684_g3820_i0 PRJNA1074408 3950 233 1.173684 2.73468372 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 379 8.419999999999998e-101   NTclustered gi|2651357791|gb|PP174306.1| 41631 g3820 i0 96.137 72.1244635193133 233 8 100 1 1 233 3440 3671 Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 16805 379 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
25242806 25242806 PRJNA1074408_S_NODE_7600_length_170_cov_2.070866_g7470_i0 PRJNA1074408 7600 170 2.070866 3.5204722 root 1 Root_unresolved Root_unresolved 315 1.64e-81   NTclustered gi|1837628855|gb|MN158348.1| 5909 g7470 i0 100 100.370588235294 170 0 100 0 1 170 5229 5398 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 17063 315 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
25242810 25242810 PRJNA1074408_S_NODE_8600_length_160_cov_5.615385_g8470_i0 PRJNA1074408 8600 160 5.615385 8.984616 root 1 Root_unresolved Root_unresolved 296 5.55e-76   NTclustered gi|10832|emb|X54512.1| 5911 g8470 i0 100 100.1 160 0 100 0 1 160 8273 8114 T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA blastn 16016 296 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);;