RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA900028", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 11 ✖

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJNA900028 · 11 ✖

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
2151222 2151222 PRJNA900028_P_NODE_73962_length_187_cov_4.210145_g73213_i0 PRJNA900028 73962 187 4.210145 7.87297115 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 340 3.0499999999999998e-89   NTclustered gi|937349254|gb|KR778775.1| 5909 g73213 i0 99.465 100.048128342246 187 1 100 0 1 187 393 579 Tetrahymena rostrata clone TR1015 18S ribosomal RNA gene, partial sequence; macronuclear blastn 18709 340 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
5073618 5073618 PRJNA900028_P_NODE_60804_length_196_cov_1.387755_g60055_i0 PRJNA900028 60804 196 1.387755 2.7199998 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 346 6.94e-91   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g60055 i0 98.469 89.3265306122449 196 3 100 0 1 196 1069 1264 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 17508 346 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
8897517 8897517 PRJNA900028_P_NODE_11307_length_334_cov_2.396491_g10559_i0 PRJNA900028 11307 334 2.396491 8.00427994 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 529 1.1899999999999999e-145   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g10559 i0 99.315 78.7155688622754 292 2 87 0 43 334 2025 2316 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 26291 529 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
11078460 11078460 PRJNA900028_P_NODE_17389_length_284_cov_2.378723_g16640_i0 PRJNA900028 17389 284 2.378723 6.75557332 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 453 6.15e-123   NTclustered gi|2651357791|gb|PP174306.1| 41631 g16640 i0 95.423 95.9718309859155 284 13 100 0 1 284 3496 3213 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 27256 453 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
12354281 12354281 PRJNA900028_P_NODE_2830_length_652_cov_2.827529_g2137_i0 PRJNA900028 2830 652 2.827529 18.43548908 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 1133 0   NTclustered gi|1837628855|gb|MN158348.1| 5909 g2137 i0 98.009 75.1901840490798 653 11 100 2 1 652 2611 3262 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 49024 1133 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
16547702 16547702 PRJNA900028_P_NODE_2713_length_667_cov_1.846278_g2026_i0 PRJNA900028 2713 667 1.846278 12.31467426 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 1074 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g2026 i0 95.665 61.0269865067466 669 27 100 1 1 667 680 12 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 40705 1074 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
18725801 18725801 PRJNA900028_P_NODE_112395_length_170_cov_1.264463_g111646_i0 PRJNA900028 112395 170 1.264463 2.1495871 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 303 3.55e-78   NTclustered gi|1202135013|gb|KY476314.1| 151077 g111646 i0 98.824 64.5588235294118 170 2 100 0 1 170 738 569 Chilodonella uncinata 18S ribosomal RNA gene, partial sequence blastn 10975 303 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
22922584 22922584 PRJNA900028_P_NODE_16658_length_289_cov_1.004167_g15909_i0 PRJNA900028 16658 289 1.004167 2.90204263 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 305 1.86e-78   NTclustered gi|10782|emb|X54004.1| 5908 g15909 i0 100 62.7439446366782 165 0 57 0 125 289 3131 2967 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 18133 305 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
23828339 23828339 PRJNA900028_P_NODE_93619_length_179_cov_1.146154_g92870_i0 PRJNA900028 93619 179 1.146154 2.05161566 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.015   NTclustered gi|471220388|ref|XM_004027107.1| 5932 g92870 i0 100 0.156424581005587 28 0 16 0 144 171 415 388 Ichthyophthirius multifiliis kap beta 3 protein, putative (IMG5_188370) mRNA, complete cds blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
25101932 25101932 PRJNA900028_P_NODE_7300_length_400_cov_5.028490_g6554_i0 PRJNA900028 7300 400 5.02849 20.11396 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 717 0   NTclustered gi|1837628855|gb|MN158348.1| 5909 g6554 i0 99 85.1625 400 4 100 0 1 400 5395 4996 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 34065 717 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
25102113 25102113 PRJNA900028_P_NODE_8980_length_366_cov_2.255521_g8233_i0 PRJNA900028 8980 366 2.255521 8.25520686 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 590 5.96e-164   NTclustered gi|1837628855|gb|MN158348.1| 5909 g8233 i0 97.143 78.3497267759563 350 9 96 1 1 350 4225 4573 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 28676 590 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);;