contig_metadata
14 rows where bioproject = "PRJEB14664", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2571040 | 2571040 | PRJEB14664_P_NODE_14923_length_183_cov_2.432432_g14793_i0 | PRJEB14664 | 14923 | 183 | 2.432432 | 4.45135056 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 4.2099999999999996e-23 | NTclustered | gi|2794945628|ref|XM_067860250.1| | 5871 | g14793 | i0 | 80.12 | 5.77049180327869 | 166 | 29 | 90 | 4 | 20 | 183 | 339 | 176 | Babesia caballi 40S ribosomal protein S11, putative (BcabD6B2_37170), partial mRNA | blastn | 1056 | 121 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 8948137 | 8948137 | PRJEB14664_P_NODE_14408_length_188_cov_2.013072_g14278_i0 | PRJEB14664 | 14408 | 188 | 2.013072 | 3.78457536 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.5299999999999998e-37 | NTclustered | gi|1673123994|ref|XM_029360740.1| | 94643 | g14278 | i0 | 82.888 | 51.1542553191489 | 187 | 32 | 99 | 0 | 2 | 188 | 161 | 347 | Besnoitia besnoiti ribosomal-ubiquitin protein RPL40 (BESB_020310), partial mRNA | blastn | 9617 | 169 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 10224016 | 10224016 | PRJEB14664_P_NODE_6509_length_322_cov_1.672474_g6379_i0 | PRJEB14664 | 6509 | 322 | 1.672474 | 5.38536628 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 3.44e-36 | NR | OEH77157.1 | 88456 | g6379 | i0 | 70.4 | 6.32608695652174 | 98 | 29 | 91.3 | 0 | 7 | 300 | 206 | 303 | OEH77157.1 60s ribosomal protein [Cyclospora cayetanensis] | diamond | 2037 | 135 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 13739230 | 13739230 | PRJEB14664_P_NODE_911_length_957_cov_3.386117_g839_i0 | PRJEB14664 | 911 | 957 | 3.386117 | 32.40513969 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 1.19e-35 | NTclustered | gi|396582138|gb|JN696678.1| | 5874 | g839 | i0 | 89.844 | 13.7648902821317 | 128 | 13 | 13 | 0 | 776 | 903 | 1262 | 1135 | Theileria annulata 28S ribosomal RNA gene, partial sequence | blastn | 13173 | 165 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 21697837 | 21697837 | PRJEB14664_P_NODE_10158_length_239_cov_1.372549_g10028_i0 | PRJEB14664 | 10158 | 239 | 1.372549 | 3.28039211 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 4.14e-19 | NR | XP_067804442.1 | 323732 | g10028 | i0 | 51.9 | 5.97489539748954 | 79 | 37 | 99.2 | 1 | 239 | 3 | 102 | 179 | XP_067804442.1 bifunctional Ribosomal protein L3 [Babesia duncani] | diamond | 1428 | 90.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 27444222 | 27444222 | PRJEB14664_P_NODE_9643_length_248_cov_1.347418_g9513_i0 | PRJEB14664 | 9643 | 248 | 1.347418 | 3.34159664 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 2.86e-14 | NR | XP_028533300.1 | 85471 | g9513 | i0 | 52.8 | 0.870967741935484 | 72 | 34 | 87.1 | 0 | 241 | 26 | 20 | 91 | XP_028533300.1 60S ribosomal protein L35ae, putative [Plasmodium relictum] | diamond | 216 | 73.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 27469260 | 27469260 | PRJEB14664_P_NODE_11183_length_224_cov_1.476190_g11053_i0 | PRJEB14664 | 11183 | 224 | 1.47619 | 3.3066656 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 1.08e-20 | NR | XP_013251045.1 | 5801 | g11053 | i0 | 53.4 | 3.96428571428571 | 73 | 34 | 97.8 | 0 | 3 | 221 | 906 | 978 | XP_013251045.1 thrombospondin type 1 domain-containing protein, putative [Eimeria acervulina] | diamond | 888 | 95.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 27974296 | 27974296 | PRJEB14664_P_NODE_8245_length_276_cov_2.473029_g8115_i0 | PRJEB14664 | 8245 | 276 | 2.473029 | 6.82556004 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 5.69e-15 | NR | CDJ52943.1 | 51314 | g8115 | i0 | 48.1 | 3.34782608695652 | 79 | 36 | 85.9 | 1 | 36 | 272 | 6 | 79 | CDJ52943.1 60s ribosomal protein L33-A, putative [Eimeria brunetti] | diamond | 924 | 75.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti | ||
| 29111073 | 29111073 | PRJEB14664_P_NODE_14308_length_189_cov_1.558442_g14178_i0 | PRJEB14664 | 14308 | 189 | 1.558442 | 2.94545538 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 2.8499999999999997e-25 | NR | EWC86021.1 | 5843 | g14178 | i0 | 80.6 | 9.84126984126984 | 62 | 12 | 98.4 | 0 | 187 | 2 | 35 | 96 | EWC86021.1 ribosomal protein L10.e [Plasmodium falciparum NF54] | diamond | 1860 | 101 | 0.99009900990099 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 29142794 | 29142794 | PRJEB14664_P_NODE_18989_length_156_cov_1.619835_g18859_i0 | PRJEB14664 | 18989 | 156 | 1.619835 | 2.5269426 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0291 | NR | XP_012766445.1 | 5866 | g18859 | i0 | 41.2 | 8.86538461538461 | 51 | 27 | 98.1 | 1 | 154 | 2 | 510 | 557 | XP_012766445.1 polyadenylate binding protein, putative [Babesia bigemina] | diamond | 1383 | 42 | 0.990476190476191 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 31012496 | 31012496 | PRJEB14664_P_NODE_10095_length_240_cov_1.560976_g9965_i0 | PRJEB14664 | 10095 | 240 | 1.560976 | 3.7463424 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 2.88e-17 | NR | XP_026190971.1 | 88456 | g9965 | i0 | 56.3 | 1.6 | 64 | 26 | 80 | 1 | 19 | 210 | 367 | 428 | XP_026190971.1 phytepsin-like [Cyclospora cayetanensis] | diamond | 384 | 85.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 31163844 | 31163844 | PRJEB14664_P_NODE_15275_length_181_cov_1.006849_g15145_i0 | PRJEB14664 | 15275 | 181 | 1.006849 | 1.82239669 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0102 | NR | KAK1934938.1 | 32595 | g15145 | i0 | 41.9 | 2.17127071823204 | 43 | 25 | 71.3 | 0 | 180 | 52 | 41 | 83 | KAK1934938.1 putative prefoldin subunit 6 [Babesia divergens] | diamond | 393 | 42 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia divergens | ||
| 31353910 | 31353910 | PRJEB14664_P_NODE_11216_length_223_cov_2.553191_g11086_i0 | PRJEB14664 | 11216 | 223 | 2.553191 | 5.69361593 | root | 1 | Root_unresolved | Root_unresolved | 106 | 1.9100000000000003e-27 | NR | KAK1444563.1 | 33632 | g11086 | i0 | 72.9 | 1.84304932735426 | 70 | 19 | 94.2 | 0 | 211 | 2 | 1 | 70 | KAK1444563.1 60S ribosomal protein L27A like protein [Babesia gibsoni] | diamond | 411 | 106 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia gibsoni | ||
| 31360414 | 31360414 | PRJEB14664_P_NODE_9876_length_244_cov_1.531100_g9746_i0 | PRJEB14664 | 9876 | 244 | 1.5311 | 3.735884 | Neospora caninum Liverpool | 572307 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.95e-26 | NR | XP_003884403.1 | 572307 | g9746 | i0 | 63.6 | 7.35245901639344 | 77 | 28 | 94.7 | 0 | 234 | 4 | 11 | 87 | XP_003884403.1 hypothetical protein NCLIV_048030 [Neospora caninum Liverpool] | diamond | 1794 | 103 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum |
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);;