RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 11 ✖

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJNA1255065 · 11 ✖

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
5463760 5463760 PRJNA1255065_P_NODE_58325_length_253_cov_1.019608_g56097_i0 PRJNA1255065 58325 253 1.019608 2.57960824 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 289 1.61e-73   NTclustered gi|2651357788|gb|PP174303.1| 41631 g56097 i0 87.259 97.5217391304348 259 26 99 5 2 253 3736 3478 Colpoda sp. isolate CIL1 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 24673 289 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
6156390 6156390 PRJNA1255065_P_NODE_96705_length_178_cov_1.023256_g94477_i0 PRJNA1255065 96705 178 1.023256 1.82139568 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 274 2.95e-69   NTclustered gi|759083543|gb|KM222160.1| 5980 g94477 i0 94.382 49.0674157303371 178 10 100 0 1 178 523 700 Colpoda inflata voucher SXK2011071402 large subunit ribosomal RNA gene, partial sequence blastn 8734 274 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda inflata
10564354 10564354 PRJNA1255065_P_NODE_154489_length_158_cov_8.055046_g152261_i0 PRJNA1255065 154489 158 8.055046 12.72697268 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.013   NTclustered gi|471223161|ref|XM_004030318.1| 5932 g152261 i0 100 0.177215189873418 28 0 18 0 84 111 717 690 Ichthyophthirius multifiliis hypothetical protein (IMG5_162330) mRNA, complete cds blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
12532225 12532225 PRJNA1255065_P_NODE_86810_length_190_cov_1.638298_g84582_i0 PRJNA1255065 86810 190 1.638298 3.1127662 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 313 6.78e-81   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g84582 i0 96.316 101.447368421053 190 7 100 0 1 190 1136 947 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 19275 313 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
15080789 15080789 PRJNA1255065_P_NODE_147672_length_162_cov_1.699115_g145444_i0 PRJNA1255065 147672 162 1.699115 2.7525663 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 300 4.36e-77   NTclustered gi|1621572405|gb|MH051920.1| 5893 g145444 i0 100 100.006172839506 162 0 100 0 1 162 284 445 Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence blastn 16201 300 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena borealis
16355883 16355883 PRJNA1255065_P_NODE_73633_length_212_cov_1.092025_g71405_i0 PRJNA1255065 73633 212 1.092025 2.315093 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 375 9.74e-100   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g71405 i0 98.585 76.7547169811321 212 3 100 0 1 212 257 468 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 16272 375 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
16937527 16937527 PRJNA1255065_P_NODE_21154_length_597_cov_5.127737_g19028_i0 PRJNA1255065 21154 597 5.127737 30.61258989 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 658 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g19028 i0 86.777 77.0904522613065 605 62 100 15 1 597 1491 2085 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 46023 658 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
24586072 24586072 PRJNA1255065_P_NODE_107760_length_169_cov_0.866667_g105532_i0 PRJNA1255065 107760 169 0.866667 1.46466723 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 302 1.27e-77   NTclustered gi|10782|emb|X54004.1| 5908 g105532 i0 98.817 45.3727810650888 169 2 100 0 1 169 1858 1690 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 7668 302 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
24586875 24586875 PRJNA1255065_P_NODE_73380_length_212_cov_1.914110_g71152_i0 PRJNA1255065 73380 212 1.91411 4.0579132 Trithigmostoma cucullulus 1346499 SAR_Eukaryotes SAR_Eukaryotes 370 4.53e-98   NTclustered gi|759083539|gb|KM222156.1| 1346499 g71152 i0 98.113 100.344339622642 212 4 100 0 1 212 1386 1175 Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence blastn 21273 370 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Trithigmostoma Trithigmostoma cucullulus
25279669 25279669 PRJNA1255065_P_NODE_89140_length_187_cov_1.500000_g86912_i0 PRJNA1255065 89140 187 1.5 2.805 Ichthyophthirius 5931 SAR_Eukaryotes SAR_Eukaryotes 73.1 1.23e-8   NTclustered gi|161087246|gb|EU185635.1| 5932 g86912 i0 84 1.75935828877005 75 12 40 0 1 75 2409 2483 Ichthyophthirius multifiliis 28S ribosomal RNA gene, partial sequence blastn 329 73.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29189771 29189771 PRJNA1255065_P_NODE_147009_length_163_cov_0.903509_g144781_i0 PRJNA1255065 147009 163 0.903509 1.47271967 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 64.7 1.37e-11   NR CDW88910.1 5949 g144781 i0 57.4 0.993865030674847 54 23 99.4 0 2 163 22 75 CDW88910.1 60s acidic ribosomal protein p1 [Stylonychia lemnae] diamond 162 64.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

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