RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1111448", tax_clade = "Sar" 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

  • PRJNA1111448 · 3 ✖

analysis 1

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
6595865 6595865 PRJNA1111448_S_NODE_20586_length_462_cov_11.359897_g19764_i0 PRJNA1111448 20586 462 11.359897 52.48272414 Plasmodium reichenowi 5854 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.012   NTclustered gi|1145257097|ref|XM_012906157.2| 5854 g19764 i0 100 0.183982683982684 29 0 6 0 345 373 2948 2920 Plasmodium reichenowi RNA polymerase I partial mRNA blastn 85 54.7 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium reichenowi
16325223 16325223 PRJNA1111448_S_NODE_30333_length_408_cov_2.797015_g29510_i0 PRJNA1111448 30333 408 2.797015 11.4118212 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 178 6.189999999999999e-40   NTclustered gi|1250004058|gb|MF039328.1| 5815 g29510 i0 94.737 28.0759803921569 114 6 28 0 170 283 2241 2128 Sarcocystis arieticanis isolate YDSSA4 28S ribosomal RNA gene, partial sequence blastn 11455 178 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Sarcocystis Sarcocystis arieticanis
24444299 24444299 PRJNA1111448_S_NODE_70240_length_310_cov_1.535865_g69417_i0 PRJNA1111448 70240 310 1.535865 4.7611815 Plasmodium coatneyi 208452 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.029   NTclustered gi|379988120|dbj|AB649420.1| 208452 g69417 i0 100 0.0903225806451613 28 0 9 0 97 124 6437 6410 Plasmodium coatneyi apicoplast DNA, partial sequence, strain: CDC blastn 28 52.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium coatneyi

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