RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1126198 · 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
27027727 27027727 PRJNA1126198_P_NODE_457242_length_243_cov_0.917647_g456521_i0 PRJNA1126198 457242 243 0.917647 2.22988221 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 113 1.55e-27   NR AAT39331.1 270669 g456521 i0 66.7 7.69135802469136 78 26 96.3 0 9 242 247 324 AAT39331.1 eukaryotic release factor 1 [Eschaneustyla sp. HL-2004] diamond 1869 113 1 Eukaryota Sar   Ciliophora Spirotrichea Urostylida Urostylidae Eschaneustyla Eschaneustyla sp. HL-2004
29280650 29280650 PRJNA1126198_P_NODE_75169_length_364_cov_2.106529_g74452_i0 PRJNA1126198 75169 364 2.106529 7.66776556 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.57e-5   NR OMJ75209.1 5963 g74452 i0 34.8 1.36813186813187 89 57 73.4 1 98 364 168 255 OMJ75209.1 hypothetical protein SteCoe_25722 [Stentor coeruleus] diamond 498 53.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32568267 32568267 PRJNA1126198_P_NODE_306979_length_264_cov_1.523560_g306258_i0 PRJNA1126198 306979 264 1.52356 4.0221984 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0333   NR CDW74976.1 5949 g306258 i0 61.5 0.443181818181818 39 13 42 2 262 152 272 310 CDW74976.1 translocation protein [Stylonychia lemnae] diamond 117 43.1 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);;