RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJNA641991 · 7 ✖

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
10086921 10086921 PRJNA641991_S_NODE_3588_length_279_cov_1.504348_g3469_i0 PRJNA641991 3588 279 1.504348 4.19713092 Isotrichidae 5985 SAR_Eukaryotes SAR_Eukaryotes 226 1.43e-54   NTclustered gi|92790147|emb|AJ965259.1| 40806 g3469 i0 87.958 99.8028673835125 191 23 69 0 89 279 1085 895 Dasytricha ruminantium partial mRNA for Polyubiqutin 3 (polyubiqutin 3 gene) blastn 27845 226 1 Eukaryota Sar   Ciliophora Litostomatea Vestibuliferida Isotrichidae Dasytricha Dasytricha ruminantium
28281176 28281176 PRJNA641991_S_NODE_14646_length_161_cov_0.910714_g14527_i0 PRJNA641991 14646 161 0.910714 1.46624954 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 60.5 6.54e-9   NR CAI2373274.1 5936 g14527 i0 56 0.93167701863354 50 20 89.4 1 17 160 277 326 CAI2373274.1 unnamed protein product [Moneuplotes crassus] diamond 150 60.5 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
28786382 28786382 PRJNA641991_S_NODE_5187_length_236_cov_2.572193_g5068_i0 PRJNA641991 5187 236 2.572193 6.07037548 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 64.7 1.35e-10   NR CDW84354.1 5949 g5068 i0 38.5 1.70338983050847 65 40 82.6 0 2 196 95 159 CDW84354.1 exported protein [Stylonychia lemnae] diamond 402 64.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28944740 28944740 PRJNA641991_S_NODE_11488_length_170_cov_0.826446_g11369_i0 PRJNA641991 11488 170 0.826446 1.4049582 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 92.8 1.33e-20   NR CDW75397.1 5949 g11369 i0 72 0.882352941176471 50 14 88.2 0 1 150 184 233 CDW75397.1 cysteine proteinase aalp [Stylonychia lemnae] diamond 150 92.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29575685 29575685 PRJNA641991_P_NODE_1430_length_263_cov_1.065421_g1389_i0 PRJNA641991 1430 263 1.065421 2.80205723 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 84.3 5e-18   NR CDW84354.1 5949 g1389 i0 42.9 0.958174904942966 84 47 94.7 1 2 250 53 136 CDW84354.1 exported protein [Stylonychia lemnae] diamond 252 84.3 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31230820 31230820 PRJNA641991_S_NODE_11995_length_167_cov_0.864407_g11876_i0 PRJNA641991 11995 167 0.864407 1.44355969 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 89.4 3.67e-19   NR OMJ72279.1 5963 g11876 i0 77.4 1.90419161676647 53 12 95.2 0 161 3 304 356 OMJ72279.1 hypothetical protein SteCoe_29330 [Stentor coeruleus] diamond 318 89.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32009539 32009539 PRJNA641991_S_NODE_8758_length_190_cov_1.085106_g8639_i0 PRJNA641991 8758 190 1.085106 2.0617014 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0164   NR CDW84514.1 5949 g8639 i0 56.7 1.76842105263158 30 13 47.4 0 1 90 83 112 CDW84514.1 UNKNOWN [Stylonychia lemnae] diamond 336 42.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);;