RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA222400" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA222400 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
1642002 1642002 PRJNA222400_P_NODE_5262_length_195_cov_1.068493_g5229_i0 PRJNA222400 5262 195 1.068493 2.08356135 Plasmodium fragile 5857 SAR_Eukaryotes SAR_Eukaryotes 69.4 1.67e-7   NTclustered gi|817737722|ref|XM_012478394.1| 5857 g5229 i0 84 15.2769230769231 75 8 37 3 95 166 14437 14510 Plasmodium fragile uncharacterized protein (AK88_00750), partial mRNA blastn 2979 69.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium fragile
2917864 2917864 PRJNA222400_P_NODE_8103_length_166_cov_0.888889_g8070_i0 PRJNA222400 8103 166 0.888889 1.47555574 Cryptosporidium ryanae 515981 SAR_Eukaryotes SAR_Eukaryotes 110 8.13e-20   NTclustered gi|2787718610|ref|XM_067340940.1| 515981 g8070 i0 86.139 5.32530120481928 101 14 61 0 18 118 329 429 Cryptosporidium ryanae 40S ribosomal protein S16 (FG386_001547), partial mRNA blastn 884 110 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium ryanae
7434432 7434432 PRJNA222400_P_NODE_6166_length_181_cov_0.856061_g6133_i0 PRJNA222400 6166 181 0.856061 1.54947041 Toxoplasma 5810 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.004   NTclustered gi|117575160|emb|AM055942.3| 383379 g6133 i0 100 1.09944751381215 29 0 16 0 15 43 960464 960492 Toxoplasma gondii RH, genomic DNA chromosome Ia blastn 199 54.7 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Toxoplasma Toxoplasma gondii
18218883 18218883 PRJNA222400_P_NODE_5675_length_188_cov_1.697842_g5642_i0 PRJNA222400 5675 188 1.697842 3.19194296 Cryptosporidium ubiquitum 857276 SAR_Eukaryotes SAR_Eukaryotes 58.4 3.46e-4   NTclustered gi|1624732328|ref|XM_029018922.1| 857276 g5642 i0 97.059 17.0585106382979 34 1 18 0 2 35 943 910 Cryptosporidium ubiquitum membrane associated thioredoxin (cubi_01910), partial mRNA blastn 3207 58.4 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium ubiquitum

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