RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1115053 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27289249 27289249 PRJNA1115053_S_NODE_151183_length_219_cov_1.090909_g149366_i0 PRJNA1115053 151183 219 1.090909 2.38909071 Plasmodium falciparum Tanzania (2 5833 SAR_Eukaryotes SAR_Eukaryotes 40.8 0.0435   NR ETW37537.1 1036725 g149366 i0 38.2 0.753424657534247 55 32 72.6 1 54 212 29 83 ETW37537.1 hypothetical protein PFTANZ_01719 [Plasmodium falciparum Tanzania (2000708)] diamond 165 40.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
28520847 28520847 PRJNA1115053_S_NODE_61867_length_311_cov_4.119403_g60050_i0 PRJNA1115053 61867 311 4.119403 12.81134333 Cystoisospora suis 483139 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.03e-6   NR XP_067922122.1 483139 g60050 i0 47.9 2.29581993569132 48 25 46.3 0 2 145 324 371 XP_067922122.1 adp atp translocase 1 [Cystoisospora suis] diamond 714 56.6 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Cystoisospora Cystoisospora suis
28994632 28994632 PRJNA1115053_S_NODE_120648_length_240_cov_2.436548_g118831_i0 PRJNA1115053 120648 240 2.436548 5.8477152 Babesia caballi 5871 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0497   NR XP_067714772.1 5871 g118831 i0 37.7 0.6625 53 33 66.3 0 210 52 468 520 XP_067714772.1 phosphoenolpyruvate synthase [Babesia caballi] diamond 159 42.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia caballi
31774672 31774672 PRJNA1115053_S_NODE_255997_length_174_cov_1.022901_g254180_i0 PRJNA1115053 255997 174 1.022901 1.77984774 Plasmodium vivax 5855 SAR_Eukaryotes SAR_Eukaryotes 54.3 1.23e-7   NR CAA67111.1 5855 g254180 i0 52.2 0.793103448275862 46 22 79.3 0 28 165 2 47 CAA67111.1 PV14 [Plasmodium vivax] diamond 138 54.3 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium vivax
32249723 32249723 PRJNA1115053_S_NODE_79858_length_283_cov_1.800000_g78041_i0 PRJNA1115053 79858 283 1.8 5.094 Besnoitia besnoiti 94643 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0463   NR XP_029216990.1 94643 g78041 i0 41.8 0.710247349823322 67 33 64.7 2 256 74 1357 1423 XP_029216990.1 hypothetical protein BESB_081800 [Besnoitia besnoiti] diamond 201 43.1 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Besnoitia Besnoitia besnoiti
32817631 32817631 PRJNA1115053_S_NODE_125600_length_236_cov_2.487047_g123783_i0 PRJNA1115053 125600 236 2.487047 5.86943092 Sarcocystis calchasi 1344799 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0471   NR CAL7866116.1 1344799 g123783 i0 35.7 0.889830508474576 70 35 76.3 3 185 6 186 255 CAL7866116.1 unnamed protein product [Sarcocystis calchasi] diamond 210 42.4 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Sarcocystis Sarcocystis calchasi

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