contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA893346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9795833 | 9795833 | PRJNA893346_P_NODE_16408_length_383_cov_0.990323_g15920_i0 | PRJNA893346 | 16408 | 383 | 0.990323 | 3.79293709 | Cryptosporidium ubiquitum | 857276 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 4.69e-6 | NTclustered | gi|1624737958|ref|XM_029018501.1| | 857276 | g15920 | i0 | 90.196 | 39.242819843342 | 51 | 3 | 13 | 2 | 129 | 178 | 768 | 719 | Cryptosporidium ubiquitum uncharacterized protein (cubi_01489), partial mRNA | blastn | 15030 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ubiquitum | ||
| 9796170 | 9796170 | PRJNA893346_P_NODE_29488_length_275_cov_1.108911_g28998_i0 | PRJNA893346 | 29488 | 275 | 1.108911 | 3.04950525 | Theileria equi | 5872 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 1.16e-10 | NTclustered | gi|510907572|ref|XM_004831870.1| | 1537102 | g28998 | i0 | 95.918 | 0.178181818181818 | 49 | 2 | 18 | 0 | 207 | 255 | 486 | 438 | Theileria equi strain WA 60S ribosomal protein L19, putative (BEWA_049420), mRNA | blastn | 49 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 12347530 | 12347530 | PRJNA893346_P_NODE_39150_length_242_cov_0.911243_g38660_i0 | PRJNA893346 | 39150 | 242 | 0.911243 | 2.20520806 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 9.72e-31 | NTclustered | gi|1673112363|ref|XM_029359405.1| | 94643 | g38660 | i0 | 81.319 | 0.752066115702479 | 182 | 32 | 75 | 2 | 1 | 181 | 1308 | 1488 | Besnoitia besnoiti DnaJ domain-containing protein (BESB_006500), partial mRNA | blastn | 182 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 13622331 | 13622331 | PRJNA893346_P_NODE_8051_length_561_cov_2.741803_g7572_i0 | PRJNA893346 | 8051 | 561 | 2.741803 | 15.38151483 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 2.55e-5 | NTclustered | gi|397561522|gb|JX044493.1| | 5811 | g7572 | i0 | 81.707 | 0.996434937611408 | 82 | 10 | 14 | 5 | 482 | 561 | 149 | 227 | Toxoplasma gondii strain GUYDOS chromosome Ia region 5 genomic sequence | blastn | 559 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii |
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);;