contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1005695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27375047 | 27375047 | PRJNA1005695_P_NODE_13783_length_412_cov_0.920354_g12931_i0 | PRJNA1005695 | 13783 | 412 | 0.920354 | 3.79185848 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.0184 | NR | XP_012767158.1 | 5866 | g12931 | i0 | 36.2 | 0.983009708737864 | 69 | 43 | 50.2 | 1 | 217 | 11 | 568 | 635 | XP_012767158.1 hypothetical protein, conserved [Babesia bigemina] | diamond | 405 | 46.2 | 0.991341991341991 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 27943160 | 27943160 | PRJNA1005695_P_NODE_34665_length_253_cov_0.866667_g33813_i0 | PRJNA1005695 | 34665 | 253 | 0.866667 | 2.19266751 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 1.73e-21 | NR | XP_002259675.1 | 5851 | g33813 | i0 | 50.6 | 7.71936758893281 | 81 | 40 | 96 | 0 | 244 | 2 | 44 | 124 | XP_002259675.1 ras-related protein Rab-1A, putative [Plasmodium knowlesi strain H] | diamond | 1953 | 94 | 0.995744680851064 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 30438017 | 30438017 | PRJNA1005695_P_NODE_38653_length_245_cov_0.906977_g37801_i0 | PRJNA1005695 | 38653 | 245 | 0.906977 | 2.22209365 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 1.74e-12 | NR | XP_067196856.1 | 515981 | g37801 | i0 | 74.5 | 5.09387755102041 | 47 | 12 | 57.6 | 0 | 102 | 242 | 110 | 156 | XP_067196856.1 uncharacterized protein FG386_002057 [Cryptosporidium ryanae] | diamond | 1248 | 72 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 30445388 | 30445388 | PRJNA1005695_P_NODE_30553_length_270_cov_1.578680_g29701_i0 | PRJNA1005695 | 30553 | 270 | 1.57868 | 4.262436 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 4.660000000000001e-27 | NR | XP_067926961.1 | 483139 | g29701 | i0 | 58.1 | 4.77777777777778 | 86 | 36 | 95.6 | 0 | 268 | 11 | 667 | 752 | XP_067926961.1 emp24 gp25l p24 family protein [Cystoisospora suis] | diamond | 1290 | 114 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 31614676 | 31614676 | PRJNA1005695_P_NODE_36496_length_249_cov_1.261364_g35644_i0 | PRJNA1005695 | 36496 | 249 | 1.261364 | 3.14079636 | Eimeria brunetti | 51314 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0159 | NR | CDJ47586.1 | 51314 | g35644 | i0 | 36.9 | 0.783132530120482 | 65 | 41 | 78.3 | 0 | 51 | 245 | 28 | 92 | CDJ47586.1 hypothetical protein, conserved [Eimeria brunetti] | diamond | 195 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti | ||
| 31891896 | 31891896 | PRJNA1005695_P_NODE_9937_length_493_cov_0.928571_g9086_i0 | PRJNA1005695 | 9937 | 493 | 0.928571 | 4.57785503 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 9.16e-8 | NR | XP_002369261.1 | 508771 | g9086 | i0 | 41.1 | 4.15618661257606 | 73 | 41 | 43.2 | 1 | 215 | 3 | 105 | 177 | XP_002369261.1 kelch repeat protein, putative [Toxoplasma gondii ME49] | diamond | 2049 | 62.4 | 0.993589743589744 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 32745435 | 32745435 | PRJNA1005695_P_NODE_23940_length_307_cov_1.901709_g23088_i0 | PRJNA1005695 | 23940 | 307 | 1.901709 | 5.83824663 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 3.49e-11 | NR | XP_011130710.1 | 110365 | g23088 | i0 | 52.7 | 2.12052117263844 | 74 | 27 | 72.3 | 2 | 305 | 84 | 518 | 583 | XP_011130710.1 prolyl-tRNA synthetase [Gregarina niphandrodes] | diamond | 651 | 69.7 | 0.994261119081779 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes |
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);;