contig_metadata
6 rows where bioproject = "PRJNA399711", tax_clade = "Sar" and tax_phylum = "Apicomplexa"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25562754 | 25562754 | PRJNA399711_S_NODE_25297_length_254_cov_2.156682_g25155_i0 | PRJNA399711 | 25297 | 254 | 2.156682 | 5.47797228 | Cryptosporidium ubiquitum | 857276 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.72e-39 | NTclustered | gi|1624735034|ref|XM_029019898.1| | 857276 | g25155 | i0 | 86.335 | 31.748031496063 | 161 | 20 | 63 | 2 | 1 | 160 | 584 | 743 | Cryptosporidium ubiquitum 60s ribosomal protein L8 L2 (cubi_02887), partial mRNA | blastn | 8064 | 174 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ubiquitum | ||
| 25565073 | 25565073 | PRJNA399711_S_NODE_86345_length_163_cov_4.357143_g86203_i0 | PRJNA399711 | 86345 | 163 | 4.357143 | 7.10214309 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.014 | NTclustered | gi|916416461|ref|XM_013374008.1| | 5802 | g86203 | i0 | 100 | 0.171779141104294 | 28 | 0 | 17 | 0 | 6 | 33 | 120 | 93 | Eimeria tenella uncharacterized protein (ETH_00040805), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 25835571 | 25835571 | PRJNA399711_S_NODE_39099_length_217_cov_12.111111_g38957_i0 | PRJNA399711 | 39099 | 217 | 12.111111 | 26.28111087 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|914998632|ref|XM_013392170.1| | 5801 | g38957 | i0 | 89.13 | 0.341013824884793 | 46 | 2 | 21 | 1 | 16 | 61 | 1545 | 1503 | Eimeria acervulina glycosylphosphatidylinositol anchor attachment 1 protein, putative partial mRNA | blastn | 74 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 25837171 | 25837171 | PRJNA399711_S_NODE_82963_length_166_cov_1.519380_g82821_i0 | PRJNA399711 | 82963 | 166 | 1.51938 | 2.5221708 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.014 | NTclustered | gi|1620148298|ref|XM_028678236.1| | 85471 | g82821 | i0 | 100 | 0.168674698795181 | 28 | 0 | 17 | 0 | 137 | 164 | 7869 | 7842 | Plasmodium relictum conserved Plasmodium membrane protein, unknown function (PRELSG_1243100), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 25973577 | 25973577 | PRJNA399711_S_NODE_87972_length_162_cov_3.432000_g87830_i0 | PRJNA399711 | 87972 | 162 | 3.432 | 5.55984 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.013 | NTclustered | gi|2795622194|ref|XM_068065127.1| | 483139 | g87830 | i0 | 96.875 | 0.197530864197531 | 32 | 0 | 19 | 1 | 129 | 159 | 398 | 367 | Cystoisospora suis uncharacterized protein (CSUI_004946), partial mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 26515018 | 26515018 | PRJNA399711_S_NODE_16264_length_295_cov_15.837209_g16122_i0 | PRJNA399711 | 16264 | 295 | 15.837209 | 46.71976655 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915011600|ref|XM_013396010.1| | 5801 | g16122 | i0 | 100 | 0.674576271186441 | 30 | 0 | 10 | 0 | 87 | 116 | 661 | 632 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 199 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina |
Advanced export
JSON shape: default, array, newline-delimited
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);;