RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA986547" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA986547 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
27664382 27664382 PRJNA986547_P_NODE_16224_length_207_cov_4.507463_g16142_i0 PRJNA986547 16224 207 4.507463 9.33044841 Heterotrichea 194287 SAR_Eukaryotes SAR_Eukaryotes 119 1.82e-29   NR OMJ84556.1 5963 g16142 i0 79.7 6.97101449275362 69 14 100 0 207 1 410 478 OMJ84556.1 hypothetical protein SteCoe_14295 [Stentor coeruleus] diamond 1443 119 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
27727713 27727713 PRJNA986547_P_NODE_9064_length_249_cov_3.926136_g8982_i0 PRJNA986547 9064 249 3.926136 9.77607864 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 60.8 1.67e-8   NR CAG9318551.1 1481888 g8982 i0 44.3 6.24096385542169 79 41 95.2 2 247 11 222 297 CAG9318551.1 unnamed protein product [Blepharisma stoltei] diamond 1554 61.2 0.993464052287582 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
27784814 27784814 PRJNA986547_P_NODE_15304_length_215_cov_9.154930_g15222_i0 PRJNA986547 15304 215 9.15493 19.6830995 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 47.4 2.06e-4   NR CAD8066873.1 65129 g15222 i0 43.4 0.73953488372093 53 29 74 1 56 214 27 78 CAD8066873.1 unnamed protein product [Paramecium sonneborni] diamond 159 47.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni

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