RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 19 ✖

bioproject 1

  • PRJNA994052 · 19 ✖

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
6377130 6377130 PRJNA994052_P_NODE_20505_length_308_cov_7.642553_g19279_i0 PRJNA994052 20505 308 7.642553 23.53906324 Loxocephalidae 311388 SAR_Eukaryotes SAR_Eukaryotes 246 1.2299999999999999e-60   NTclustered gi|1332983250|gb|MG819725.1| 638335 g19279 i0 96.026 44.5941558441558 151 6 49 0 1 151 1461 1611 Dexiotricha colpidiopsis strain DEX201707a small subunit ribosomal RNA gene, partial sequence blastn 13735 246 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Loxocephalidae Dexiotricha Dexiotricha colpidiopsis
7354446 7354446 PRJNA994052_P_NODE_68406_length_214_cov_75.524823_g67150_i0 PRJNA994052 68406 214 75.524823 161.62312122 Spirostomum yagiui 1471042 SAR_Eukaryotes SAR_Eukaryotes 62.1 3.13e-5   NTclustered gi|2692944869|ref|NC_086648.1| 1471042 g67150 i0 97.222 0.168224299065421 36 1 17 0 172 207 3866 3901 Spirostomum yagiui isolate XKC mitochondrion, complete genome blastn 36 62.1 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Spirostomidae Spirostomum Spirostomum yagiui
9904293 9904293 PRJNA994052_P_NODE_14988_length_313_cov_19.487500_g13767_i0 PRJNA994052 14988 313 19.4875 60.995875 Sorogena stoianovitchae 164621 SAR_Eukaryotes SAR_Eukaryotes 268 2.67e-67   NTclustered gi|169659247|dbj|AB325967.1| 164621 g13767 i0 84.706 79.8083067092652 255 36 81 3 59 313 1292 1041 Sorogena stoianovitchae sbt mRNA for putative beta-tubulin, partial cds blastn 24980 268 1 Eukaryota Sar   Ciliophora Colpodea Sorogenida Sorogenidae Sorogena Sorogena stoianovitchae
16575884 16575884 PRJNA994052_P_NODE_76993_length_204_cov_18.541985_g75736_i0 PRJNA994052 76993 204 18.541985 37.8256494 Euplotes 5935 SAR_Eukaryotes SAR_Eukaryotes 171 4.71e-38   NTclustered gi|405109099|emb|FR873717.1| 5941 g75736 i0 100 88.093137254902 92 0 88 0 111 202 1189 1098 Euplotes eurystomus partial 18S rRNA gene, isolate EM population blastn 17971 171 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes eurystomus
17554167 17554167 PRJNA994052_P_NODE_27934_length_287_cov_30.350467_g26693_i0 PRJNA994052 27934 287 30.350467 87.10584029 Opercularia sp. ZhW-2019a 2582953 SAR_Eukaryotes SAR_Eukaryotes 481 2.86e-131   NTclustered gi|2304601486|gb|OP458307.1| 2582953 g26693 i0 98.885 91.5191637630662 269 3 94 0 18 286 330 62 Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence blastn 26266 481 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Operculariidae Opercularia Opercularia sp. ZhW-2019a
18828132 18828132 PRJNA994052_P_NODE_33155_length_273_cov_159.475000_g31911_i0 PRJNA994052 33155 273 159.475 435.36675 Conchophthirus unionis 3053525 SAR_Eukaryotes SAR_Eukaryotes 390 4.6799999999999996e-104   NTclustered gi|2518630397|gb|OR129902.1| 3053525 g31911 i0 93.846 94.9157509157509 260 15 95 1 15 273 875 616 Conchophthirus unionis isolate HO 24 UC internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 25912 390 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Conchophthiridae Conchophthirus Conchophthirus unionis
18828528 18828528 PRJNA994052_P_NODE_67695_length_215_cov_63.338028_g66439_i0 PRJNA994052 67695 215 63.338028 136.1767602 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 78.7 3.13e-10   NTclustered gi|829163709|ref|XM_001013641.3| 312017 g66439 i0 77.305 3.94883720930233 141 26 64 6 68 205 495 358 Tetrahymena thermophila SB210 60S ribosomal protein L11 partial mRNA blastn 849 78.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
25499667 25499667 PRJNA994052_P_NODE_60220_length_225_cov_397.276316_g58964_i0 PRJNA994052 60220 225 397.276316 893.871711 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 224 4.01e-54   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g58964 i0 89.326 45.4755555555556 178 19 79 0 3 180 2905 3082 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 10232 224 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
26678003 26678003 PRJNA994052_P_NODE_41201_length_256_cov_41.016393_g39954_i0 PRJNA994052 41201 256 41.016393 105.00196608 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 85.5 4.5e-19   NR TNV72613.1 5974 g39954 i0 67.7 0.7265625 62 20 72.7 0 255 70 67 128 TNV72613.1 hypothetical protein FGO68_gene17584 [Halteria grandinella] diamond 186 85.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
27374496 27374496 PRJNA994052_P_NODE_29443_length_283_cov_40.761905_g28201_i0 PRJNA994052 29443 283 40.761905 115.35619115 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.96e-4   NR XP_004035134.1 5932 g28201 i0 33.8 0.752650176678445 71 46 75.3 1 283 71 85 154 XP_004035134.1 hypothetical protein IMG5_105320 [Ichthyophthirius multifiliis] diamond 213 49.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27563354 27563354 PRJNA994052_P_NODE_75904_length_205_cov_48.939394_g74648_i0 PRJNA994052 75904 205 48.939394 100.3257577 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 47 7.17e-4   NR OMJ66661.1 5963 g74648 i0 76 0.365853658536585 25 6 36.6 0 202 128 370 394 OMJ66661.1 hypothetical protein SteCoe_36420 [Stentor coeruleus] diamond 75 47 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28384512 28384512 PRJNA994052_P_NODE_40206_length_258_cov_45.021622_g38960_i0 PRJNA994052 40206 258 45.021622 116.15578476 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.97e-4   NR XP_001014479.2 312017 g38960 i0 34.3 0.813953488372093 70 44 81.4 1 218 9 31 98 XP_001014479.2 CRAL TRIO domain protein [Tetrahymena thermophila SB210] diamond 210 48.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28605571 28605571 PRJNA994052_P_NODE_46307_length_247_cov_34.189655_g45056_i0 PRJNA994052 46307 247 34.189655 84.44844785 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 86.7 5.46e-18   NR OMJ88245.1 5963 g45056 i0 77 0.740890688259109 61 14 74.1 0 242 60 22 82 OMJ88245.1 hypothetical protein SteCoe_9827 [Stentor coeruleus] diamond 183 86.7 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28858065 28858065 PRJNA994052_P_NODE_46968_length_246_cov_27.398844_g45717_i0 PRJNA994052 46968 246 27.398844 67.40115624 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.58e-5   NR KRX07603.1 266149 g45717 i0 36.8 0.695121951219512 57 36 69.5 0 231 61 222 278 KRX07603.1 hypothetical protein PPERSA_11152 [Pseudocohnilembus persalinus] diamond 171 52.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29710301 29710301 PRJNA994052_P_NODE_62630_length_222_cov_26.879195_g61374_i0 PRJNA994052 62630 222 26.879195 59.6718129 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 48.5 2.52e-4   NR CDW73613.1 5949 g61374 i0 54.1 0.5 37 17 50 0 32 142 73 109 CDW73613.1 UNKNOWN [Stylonychia lemnae] diamond 111 48.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29931908 29931908 PRJNA994052_P_NODE_43971_length_251_cov_31.028090_g42723_i0 PRJNA994052 43971 251 31.02809 77.8805059 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 62.4 4.42e-9   NR XP_001433059.1 5888 g42723 i0 50 1.19521912350598 50 25 59.8 0 227 78 301 350 XP_001433059.1 uncharacterized protein GSPATT00035142001 [Paramecium tetraurelia] diamond 300 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
30247893 30247893 PRJNA994052_P_NODE_40692_length_257_cov_41.864130_g39445_i0 PRJNA994052 40692 257 41.86413 107.5908141 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 124 6.089999999999999e-31   NR CDW80051.1 5949 g39445 i0 73.7 0.88715953307393 76 20 88.7 0 247 20 517 592 CDW80051.1 abc transporter b family protein [Stylonychia lemnae] diamond 228 124 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30632520 30632520 PRJNA994052_P_NODE_79273_length_201_cov_84.039062_g78016_i0 PRJNA994052 79273 201 84.039062 168.91851462 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 66.6 3.17e-12   NR XP_004035748.1 5932 g78016 i0 68.8 1.43283582089552 48 15 71.6 0 196 53 64 111 XP_004035748.1 hypothetical protein IMG5_091110 [Ichthyophthirius multifiliis] diamond 288 66.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32081171 32081171 PRJNA994052_P_NODE_59498_length_227_cov_6.512987_g58242_i0 PRJNA994052 59498 227 6.512987 14.78448049 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00249   NR CAI2386419.1 5936 g58242 i0 39.7 0.766519823788546 58 34 76.7 1 175 2 236 292 CAI2386419.1 unnamed protein product [Moneuplotes crassus] diamond 174 45.8 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);;