contig_metadata
15 rows where bioproject = "PRJEB36940" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56748 | 56748 | PRJEB36940_P_NODE_12261_length_253_cov_0.866667_g12132_i0 | PRJEB36940 | 12261 | 253 | 0.866667 | 2.19266751 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.37e-4 | NTclustered | gi|915001563|ref|XM_013393067.1| | 5801 | g12132 | i0 | 97.143 | 0.49802371541502 | 35 | 1 | 14 | 0 | 217 | 251 | 5548 | 5582 | Eimeria acervulina phosphatidylinositol 3-and 4-kinase domain-containing protein, putative partial mRNA | blastn | 126 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 3882903 | 3882903 | PRJEB36940_P_NODE_3644_length_445_cov_11.903226_g3515_i0 | PRJEB36940 | 3644 | 445 | 11.903226 | 52.9693557 | Babesia sp. Xinjiang | 462227 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 3e-46 | NR | XP_028869867.1 | 462227 | g3515 | i0 | 55.2 | 0.964044943820225 | 143 | 61 | 94.4 | 1 | 422 | 3 | 4 | 146 | XP_028869867.1 Eukaryotic translation initiation factor 5A [Babesia sp. Xinjiang] | diamond | 429 | 157 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia sp. Xinjiang | ||
| 14085039 | 14085039 | PRJEB36940_P_NODE_2052_length_589_cov_15.038760_g1929_i0 | PRJEB36940 | 2052 | 589 | 15.03876 | 88.5782964 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 2.13e-62 | NR | OEH76901.1 | 88456 | g1929 | i0 | 61.5 | 1.78777589134126 | 179 | 69 | 91.2 | 0 | 585 | 49 | 29 | 207 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 1053 | 202 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 23008907 | 23008907 | PRJEB36940_P_NODE_8399_length_299_cov_1.026549_g8270_i0 | PRJEB36940 | 8399 | 299 | 1.026549 | 3.06938151 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 184 | 1.12e-51 | NR | XP_013434282.1 | 51315 | g8270 | i0 | 83.8 | 138.010033444816 | 99 | 16 | 99.3 | 0 | 1 | 297 | 1962 | 2060 | XP_013434282.1 pre-mRNA splicing factor prp8, putative, partial [Eimeria necatrix] | diamond | 41265 | 184 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 24282576 | 24282576 | PRJEB36940_P_NODE_2900_length_497_cov_0.891509_g2773_i0 | PRJEB36940 | 2900 | 497 | 0.891509 | 4.43079973 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 234 | 1.39e-70 | NR | XP_067925181.1 | 483139 | g2773 | i0 | 75.2 | 9.11468812877264 | 145 | 36 | 87.5 | 0 | 2 | 436 | 388 | 532 | XP_067925181.1 seryl-trna [Cystoisospora suis] | diamond | 4530 | 236 | 0.991525423728814 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 26837044 | 26837044 | PRJEB36940_P_NODE_8681_length_294_cov_1.398190_g8552_i0 | PRJEB36940 | 8681 | 294 | 1.39819 | 4.1106786 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 1.4e-20 | NR | XP_765368.1 | 333668 | g8552 | i0 | 53.7 | 2.90816326530612 | 95 | 37 | 96.9 | 1 | 285 | 1 | 1 | 88 | XP_765368.1 60S ribosomal protein L18-3 [Theileria parva strain Muguga] | diamond | 855 | 91.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria parva | ||
| 27343079 | 27343079 | PRJEB36940_P_NODE_7343_length_319_cov_1.195122_g7214_i0 | PRJEB36940 | 7343 | 319 | 1.195122 | 3.81243918 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 2.5e-4 | NR | SCM09788.1 | 5826 | g7214 | i0 | 31.3 | 1.33542319749216 | 80 | 54 | 74.3 | 1 | 237 | 1 | 85 | 164 | SCM09788.1 conserved Plasmodium protein, unknown function [Plasmodium chabaudi adami] | diamond | 426 | 50.4 | 0.994047619047619 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 27532307 | 27532307 | PRJEB36940_P_NODE_10503_length_271_cov_1.565657_g10374_i0 | PRJEB36940 | 10503 | 271 | 1.565657 | 4.24293047 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 5.55e-8 | NR | XP_008622699.1 | 54757 | g10374 | i0 | 38.8 | 5.38007380073801 | 85 | 49 | 94.1 | 2 | 270 | 16 | 293 | 374 | XP_008622699.1 protein kinase 2, putative [Plasmodium vinckei vinckei] | diamond | 1458 | 59.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 27886135 | 27886135 | PRJEB36940_P_NODE_7905_length_308_cov_0.897872_g7776_i0 | PRJEB36940 | 7905 | 308 | 0.897872 | 2.76544576 | Plasmodium inui San Antonio 1 | 1237626 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 4.770000000000001e-27 | NR | XP_008817726.1 | 1237626 | g7776 | i0 | 52.2 | 9.7012987012987 | 92 | 44 | 89.6 | 0 | 1 | 276 | 323 | 414 | XP_008817726.1 CAMK/CDPK protein kinase [Plasmodium inui San Antonio 1] | diamond | 2988 | 114 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium inui | ||
| 28100515 | 28100515 | PRJEB36940_P_NODE_6485_length_338_cov_1.750943_g6356_i0 | PRJEB36940 | 6485 | 338 | 1.750943 | 5.91818734 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 6.98e-24 | NR | XP_067925660.1 | 483139 | g6356 | i0 | 50 | 3.21301775147929 | 98 | 46 | 87 | 1 | 324 | 31 | 209 | 303 | XP_067925660.1 mc family transporter [Cystoisospora suis] | diamond | 1086 | 103 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 29300484 | 29300484 | PRJEB36940_P_NODE_7369_length_318_cov_2.134694_g7240_i0 | PRJEB36940 | 7369 | 318 | 2.134694 | 6.78832692 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 6.5e-12 | NR | XP_067924047.1 | 483139 | g7240 | i0 | 40.9 | 2.4622641509434 | 88 | 45 | 76.4 | 2 | 247 | 5 | 23 | 110 | XP_067924047.1 ran-specific gtpase-activating [Cystoisospora suis] | diamond | 783 | 69.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 30026885 | 30026885 | PRJEB36940_P_NODE_16311_length_232_cov_3.201258_g16182_i0 | PRJEB36940 | 16311 | 232 | 3.201258 | 7.42691856 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 1.2499999999999998e-29 | NR | SBS81589.1 | 864141 | g16182 | i0 | 72.7 | 5.97413793103448 | 77 | 21 | 99.6 | 0 | 2 | 232 | 97 | 173 | SBS81589.1 centrin-3, putative [Plasmodium ovale curtisi] | diamond | 1386 | 114 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 30216188 | 30216188 | PRJEB36940_P_NODE_13592_length_248_cov_1.920000_g13463_i0 | PRJEB36940 | 13592 | 248 | 1.92 | 4.7616 | Theileria | 5873 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 7.88e-25 | NR | UKJ90802.1 | 68886 | g13463 | i0 | 59.8 | 1.92338709677419 | 82 | 33 | 99.2 | 0 | 246 | 1 | 1 | 82 | UKJ90802.1 actin 1 [Theileria orientalis] | diamond | 477 | 105 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 31107428 | 31107428 | PRJEB36940_P_NODE_3935_length_431_cov_1.251397_g3806_i0 | PRJEB36940 | 3935 | 431 | 1.251397 | 5.39352107 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 3.71e-29 | NR | XP_022586579.1 | 88456 | g3806 | i0 | 71.1 | 1.89327146171694 | 90 | 24 | 62.6 | 1 | 162 | 431 | 51 | 138 | XP_022586579.1 ATP synthase subunit beta, mitochondrial [Cyclospora cayetanensis] | diamond | 816 | 121 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 31898204 | 31898204 | PRJEB36940_P_NODE_15017_length_244_cov_1.421053_g14888_i0 | PRJEB36940 | 15017 | 244 | 1.421053 | 3.46736932 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 1.03e-12 | NR | KAF8817711.1 | 476202 | g14888 | i0 | 46.8 | 2.91393442622951 | 79 | 41 | 95.9 | 1 | 239 | 6 | 7 | 85 | KAF8817711.1 MaoC family domain-containing protein [Cardiosporidium cionae] | diamond | 711 | 72 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae |
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);;