RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA994052" 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

bioproject 1

  • PRJNA994052 · 11 ✖

analysis 1

  • diamond · 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
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);;