RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA682078", 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 · 17 ✖

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA682078 · 17 ✖

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
8827190 8827190 PRJNA682078_P_NODE_81527_length_384_cov_3.951768_g79752_i0 PRJNA682078 81527 384 3.951768 15.17478912 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 638 2.2099999999999997e-178   NTclustered gi|1802599796|gb|MT001205.1| 41631 g79752 i0 97.135 100.033854166667 384 0 100 1 1 384 1195 1567 Colpoda sp. strain HFCC864 small subunit ribosomal RNA gene, partial sequence blastn 38413 638 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
10864376 10864376 PRJNA682078_P_NODE_21249_length_740_cov_7.104948_g19634_i0 PRJNA682078 21249 740 7.104948 52.5766152 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 1240 0   NTclustered gi|2651357791|gb|PP174306.1| 41631 g19634 i0 96.892 73.85 740 23 100 0 1 740 3192 3931 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 54649 1240 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
12141199 12141199 PRJNA682078_P_NODE_271330_length_244_cov_0.900585_g269553_i0 PRJNA682078 271330 244 0.900585 2.1974274 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 401 1.8999999999999998e-107   NTclustered gi|759083562|gb|KM222179.1| 1607889 g269553 i0 96.311 93.827868852459 244 9 100 0 1 244 1769 1526 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 22894 401 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta sp. FG-2015
20299817 20299817 PRJNA682078_P_NODE_284816_length_242_cov_0.911243_g283039_i0 PRJNA682078 284816 242 0.911243 2.20520806 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 139 7.2e-39   NR KRX05645.1 266149 g283039 i0 77.5 0.991735537190083 80 18 99.2 0 2 241 95 174 KRX05645.1 Ribosomal protein S2, flavodoxin-like domain [Pseudocohnilembus persalinus] diamond 240 139 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
24124103 24124103 PRJNA682078_P_NODE_15899_length_863_cov_7.403797_g14431_i0 PRJNA682078 15899 863 7.403797 63.89476811 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 1421 0   NTclustered gi|2651357791|gb|PP174306.1| 41631 g14431 i0 96.408 70.7786790266512 863 29 100 1 1 863 2613 1753 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 61082 1421 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
26987019 26987019 PRJNA682078_P_NODE_237482_length_249_cov_0.875000_g235705_i0 PRJNA682078 237482 249 0.875 2.17875 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 48.9 2.61e-4   NR XP_001017918.1 312017 g235705 i0 36.5 0.759036144578313 63 36 75.9 1 193 5 134 192 XP_001017918.1 cytochrome P450 family monooxygenase [Tetrahymena thermophila SB210] diamond 189 48.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27914882 27914882 PRJNA682078_P_NODE_260485_length_245_cov_1.639535_g258708_i0 PRJNA682078 260485 245 1.639535 4.01686075 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 103 5.2e-25   NR CDW77972.1 5949 g258708 i0 53 4.7265306122449 83 37 99.2 1 2 244 13 95 CDW77972.1 probable nucleoredoxin 1-like [Stylonychia lemnae] diamond 1158 103 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28124405 28124405 PRJNA682078_P_NODE_269405_length_244_cov_0.900585_g267628_i0 PRJNA682078 269405 244 0.900585 2.1974274 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 67 5.25e-11   NR XP_004037254.1 5932 g267628 i0 57.4 0.577868852459016 47 20 57.8 0 218 78 43 89 XP_004037254.1 hypothetical protein IMG5_057330 [Ichthyophthirius multifiliis] diamond 141 67 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
28451926 28451926 PRJNA682078_P_NODE_218926_length_252_cov_1.720670_g217149_i0 PRJNA682078 218926 252 1.72067 4.3360884 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47 0.00125   NR XP_001425076.1 5888 g217149 i0 31.3 3.16666666666667 64 44 76.2 0 53 244 196 259 XP_001425076.1 uncharacterized protein GSPATT00028713001 [Paramecium tetraurelia] diamond 798 47 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
28755825 28755825 PRJNA682078_P_NODE_268767_length_244_cov_0.900585_g266990_i0 PRJNA682078 268767 244 0.900585 2.1974274 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 57.4 2.63e-7   NR CDW88967.1 5949 g266990 i0 51.9 0.663934426229508 54 26 66.4 0 238 77 666 719 CDW88967.1 UNKNOWN [Stylonychia lemnae] diamond 162 57.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29367499 29367499 PRJNA682078_P_NODE_195809_length_265_cov_1.791667_g194032_i0 PRJNA682078 195809 265 1.791667 4.74791755 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 49.3 2.44e-4   NR KAL4463235.1 5901 g194032 i0 36.6 2.95471698113208 71 38 73.6 2 197 3 2473 2542 KAL4463235.1 hypothetical protein ABPG74_007236 [Tetrahymena malaccensis] diamond 783 49.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29545054 29545054 PRJNA682078_P_NODE_234850_length_249_cov_1.215909_g233073_i0 PRJNA682078 234850 249 1.215909 3.02761341 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 73.9 3.72e-13   NR KRX11177.1 266149 g233073 i0 68.9 1.08433734939759 45 14 54.2 0 136 2 7 51 KRX11177.1 WD40-repeat-containing domain [Pseudocohnilembus persalinus] diamond 270 73.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30208172 30208172 PRJNA682078_P_NODE_230932_length_250_cov_0.870056_g229155_i0 PRJNA682078 230932 250 0.870056 2.17514 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 98.6 9.01e-22   NR CAI2376387.1 5936 g229155 i0 54.9 1.968 82 37 98.4 0 3 248 535 616 CAI2376387.1 unnamed protein product [Moneuplotes crassus] diamond 492 98.6 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31030199 31030199 PRJNA682078_P_NODE_249735_length_247_cov_0.885057_g247958_i0 PRJNA682078 249735 247 0.885057 2.18609079 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 63.5 4.9e-10   NR CDW73736.1 5949 g247958 i0 51.5 0.801619433198381 66 32 80.2 0 32 229 30 95 CDW73736.1 UNKNOWN [Stylonychia lemnae] diamond 198 63.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31768864 31768864 PRJNA682078_P_NODE_286257_length_242_cov_0.863905_g284480_i0 PRJNA682078 286257 242 0.863905 2.0906501 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.43e-7   NR KRX05225.1 266149 g284480 i0 44.8 2.18181818181818 58 32 71.9 0 189 16 100 157 KRX05225.1 hypothetical protein PPERSA_06859 [Pseudocohnilembus persalinus] diamond 528 56.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32200206 32200206 PRJNA682078_P_NODE_191518_length_268_cov_1.235897_g189741_i0 PRJNA682078 191518 268 1.235897 3.31220396 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 177 2.299999999999999e-53   NR CAI2377160.1 5936 g189741 i0 98.9 0.985074626865672 88 1 98.5 0 3 266 141 228 CAI2377160.1 unnamed protein product [Moneuplotes crassus] diamond 264 177 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
32863157 32863157 PRJNA682078_P_NODE_290500_length_241_cov_0.916667_g288723_i0 PRJNA682078 290500 241 0.916667 2.20916747 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 68.2 3.91e-11   NR CAI2373152.1 5936 g288723 i0 43.2 0.921161825726141 74 42 92.1 0 239 18 621 694 CAI2373152.1 unnamed protein product [Moneuplotes crassus] diamond 222 68.2 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus

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