RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA613025 · 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
30851556 30851556 PRJNA613025_S_NODE_19774_length_222_cov_1.173410_g19620_i0 PRJNA613025 19774 222 1.17341 2.6049702 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 60.8 1.14e-8   NR TRY50678.1 756076 g19620 i0 40.8 2.71621621621622 76 43 100 1 1 222 305 380 TRY50678.1 Elongation factor EF1-gamma (Glutathione S-transferase family) [Cryptosporidium tyzzeri] diamond 603 60.8 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium tyzzeri
31597527 31597527 PRJNA613025_S_NODE_29216_length_170_cov_1.256198_g29062_i0 PRJNA613025 29216 170 1.256198 2.1355366 Cyclospora cayetanensis 88456 SAR_Eukaryotes SAR_Eukaryotes 69.7 4.26e-12   NR OEH79924.1 88456 g29062 i0 86.1 3.24705882352941 36 5 63.5 0 63 170 188 223 OEH79924.1 glycyl-tRNA synthetase [Cyclospora cayetanensis] diamond 552 69.7 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Cyclospora Cyclospora cayetanensis
31692152 31692152 PRJNA613025_S_NODE_32677_length_163_cov_0.894737_g32523_i0 PRJNA613025 32677 163 0.894737 1.45842131 Neospora caninum Liverpool 572307 SAR_Eukaryotes SAR_Eukaryotes 77 1.92e-16   NR XP_003884403.1 572307 g32523 i0 71.2 1.91411042944785 52 15 95.7 0 156 1 45 96 XP_003884403.1 hypothetical protein NCLIV_048030 [Neospora caninum Liverpool] diamond 312 77 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum

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