RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA558770 · 7 ✖

analysis 1

  • diamond · 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
28215680 28215680 PRJNA558770_P_NODE_258906_length_234_cov_2.120603_g256901_i0 PRJNA558770 258906 234 2.120603 4.96221102 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00143   NR OMJ72952.1 5963 g256901 i0 91.3 0.294871794871795 23 2 29.5 0 70 2 497 519 OMJ72952.1 hypothetical protein SteCoe_28488 [Stentor coeruleus] diamond 69 46.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28658082 28658082 PRJNA558770_P_NODE_283467_length_234_cov_1.678392_g281462_i0 PRJNA558770 283467 234 1.678392 3.92743728 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 47 9.94e-4   NR OMJ92639.1 5963 g281462 i0 79.2 0.307692307692308 24 5 30.8 0 233 162 102 125 OMJ92639.1 hypothetical protein SteCoe_4510 [Stentor coeruleus] diamond 72 47 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28942367 28942367 PRJNA558770_P_NODE_294648_length_234_cov_1.386935_g292643_i0 PRJNA558770 294648 234 1.386935 3.2454279 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 40.8 0.0492   NR CDW75550.1 5949 g292643 i0 35.1 0.987179487179487 77 37 98.7 2 232 2 27 90 CDW75550.1 UNKNOWN [Stylonychia lemnae] diamond 231 40.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30395288 30395288 PRJNA558770_P_NODE_286633_length_234_cov_1.628141_g284628_i0 PRJNA558770 286633 234 1.628141 3.80984994 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 53.9 3.8e-6   NR CAG9320844.1 1481888 g284628 i0 37.2 1 78 31 100 1 1 234 315 374 CAG9320844.1 unnamed protein product [Blepharisma stoltei] diamond 234 53.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
31215925 31215925 PRJNA558770_P_NODE_190875_length_234_cov_4.150754_g188870_i0 PRJNA558770 190875 234 4.150754 9.71276436 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00675   NR CDW79612.1 5949 g188870 i0 87.5 0.307692307692308 24 3 30.8 0 161 232 292 315 CDW79612.1 kelch motif family protein [Stylonychia lemnae] diamond 72 44.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31451963 31451963 PRJNA558770_P_NODE_134736_length_234_cov_7.663317_g132731_i0 PRJNA558770 134736 234 7.663317 17.93216178 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 51.2 3.37e-5   NR XP_001441350.1 5888 g132731 i0 84 0.641025641025641 25 4 32.1 0 76 2 688 712 XP_001441350.1 uncharacterized protein GSPATT00010186001 [Paramecium tetraurelia] diamond 150 51.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32716568 32716568 PRJNA558770_P_NODE_202100_length_234_cov_3.703518_g200095_i0 PRJNA558770 202100 234 3.703518 8.66623212 root 1 Root_unresolved Root_unresolved 43.5 0.0172   NR CDW76703.1 5949 g200095 i0 79.2 0.923076923076923 24 5 30.8 0 232 161 76 99 CDW76703.1 peptidase c13 family protein [Stylonychia lemnae] diamond 216 43.9 0.990888382687927 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);;