contig_metadata
11 rows where bioproject = "PRJEB50332", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10322377 | 10322377 | PRJEB50332_P_NODE_18109_length_199_cov_2.028986_g18027_i0 | PRJEB50332 | 18109 | 199 | 2.028986 | 4.03768214 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 2.08e-24 | NR | CDJ46527.1 | 51314 | g18027 | i0 | 70.3 | 13.6130653266332 | 64 | 19 | 96.5 | 0 | 194 | 3 | 341 | 404 | CDJ46527.1 CMGC kinase, GSK family TgPK3, putative [Eimeria brunetti] | diamond | 2709 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti | ||
| 11597790 | 11597790 | PRJEB50332_P_NODE_3090_length_329_cov_1.895522_g3008_i0 | PRJEB50332 | 3090 | 329 | 1.895522 | 6.23626738 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 1.36e-19 | NR | UKK02333.1 | 68886 | g3008 | i0 | 70.7 | 0.52887537993921 | 58 | 17 | 52.9 | 0 | 24 | 197 | 149 | 206 | UKK02333.1 60S ribosomal protein L10 [Theileria orientalis] | diamond | 174 | 90.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 14147816 | 14147816 | PRJEB50332_P_NODE_5852_length_257_cov_0.979592_g5770_i0 | PRJEB50332 | 5852 | 257 | 0.979592 | 2.51755144 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|916420781|ref|XM_013376168.1| | 5802 | g5770 | i0 | 100 | 0.108949416342412 | 28 | 0 | 11 | 0 | 141 | 168 | 815 | 842 | Eimeria tenella uncharacterized protein (ETH_00006165), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 17970981 | 17970981 | PRJEB50332_P_NODE_15015_length_207_cov_0.890411_g14933_i0 | PRJEB50332 | 15015 | 207 | 0.890411 | 1.84315077 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 2.47e-31 | NR | XP_013440163.1 | 51315 | g14933 | i0 | 87 | 13 | 69 | 9 | 100 | 0 | 207 | 1 | 425 | 493 | XP_013440163.1 hypothetical protein ENH_00028530 [Eimeria necatrix] | diamond | 2691 | 125 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 17971038 | 17971038 | PRJEB50332_P_NODE_4995_length_273_cov_1.297170_g4913_i0 | PRJEB50332 | 4995 | 273 | 1.29717 | 3.5412741 | Babesia ovis | 5869 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 6.61e-28 | NR | GFE55768.1 | 5869 | g4913 | i0 | 62.2 | 2.07692307692308 | 98 | 29 | 98.9 | 3 | 2 | 271 | 173 | 270 | GFE55768.1 cysteine-tRNA synthetase [Babesia ovis] | diamond | 567 | 116 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 19244984 | 19244984 | PRJEB50332_P_NODE_14016_length_208_cov_1.768707_g13934_i0 | PRJEB50332 | 14016 | 208 | 1.768707 | 3.67891056 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 7.24e-12 | NR | XP_021337375.1 | 1133968 | g13934 | i0 | 66 | 0.677884615384615 | 47 | 16 | 67.8 | 0 | 2 | 142 | 425 | 471 | XP_021337375.1 protein transport protein SEC61 subunit alpha [Babesia microti strain RI] | diamond | 141 | 69.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 28012898 | 28012898 | PRJEB50332_P_NODE_805_length_595_cov_8.226592_g728_i0 | PRJEB50332 | 805 | 595 | 8.226592 | 48.9482224 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 3.47e-64 | NR | OEH76901.1 | 88456 | g728 | i0 | 60.7 | 3.6 | 183 | 72 | 92.3 | 0 | 591 | 43 | 29 | 211 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2142 | 207 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 30216259 | 30216259 | PRJEB50332_P_NODE_6452_length_247_cov_1.290323_g6370_i0 | PRJEB50332 | 6452 | 247 | 1.290323 | 3.18709781 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 7.46e-5 | NR | BAC57465.1 | 5870 | g6370 | i0 | 42.3 | 1.45748987854251 | 52 | 30 | 63.2 | 0 | 240 | 85 | 413 | 464 | BAC57465.1 calcium-dependent protein kinase, partial [Babesia rodhaini] | diamond | 360 | 50.8 | 0.992125984251969 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia rodhaini | ||
| 30437832 | 30437832 | PRJEB50332_P_NODE_4213_length_290_cov_3.580786_g4131_i0 | PRJEB50332 | 4213 | 290 | 3.580786 | 10.3842794 | root | 1 | Root_unresolved | Root_unresolved | 89.4 | 5.8700000000000006e-21 | NR | XP_067803900.1 | 323732 | g4131 | i0 | 56.7 | 1.55172413793103 | 67 | 29 | 69.3 | 0 | 250 | 50 | 9 | 75 | XP_067803900.1 bifunctional Acyl-CoA-binding protein [Babesia duncani] | diamond | 450 | 89.7 | 0.996655518394649 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 31796612 | 31796612 | PRJEB50332_P_NODE_2517_length_358_cov_1.164983_g2435_i0 | PRJEB50332 | 2517 | 358 | 1.164983 | 4.17063914 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 1.21e-17 | NR | XP_028865997.1 | 189622 | g2435 | i0 | 36.5 | 1.96927374301676 | 126 | 73 | 99.7 | 2 | 2 | 358 | 29 | 154 | XP_028865997.1 translationally-controlled tumor protein [Babesia ovata] | diamond | 705 | 84.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 32783145 | 32783145 | PRJEB50332_P_NODE_2460_length_362_cov_1.279070_g2378_i0 | PRJEB50332 | 2460 | 362 | 1.27907 | 4.6302334 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 1.81e-14 | NR | XP_067806792.1 | 2853593 | g2378 | i0 | 45.6 | 1.30939226519337 | 79 | 43 | 65.5 | 0 | 125 | 361 | 19 | 97 | XP_067806792.1 MAG: uncharacterized protein KVP18_001652 [Porospora cf. gigantea A] | diamond | 474 | 76.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A |
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);;