contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 544480 | 544480 | PRJNA560932_P_NODE_1921_length_1149_cov_2.377323_g1718_i0 | PRJNA560932 | 1921 | 1149 | 2.377323 | 27.31544127 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.009 | NTclustered | gi|915003962|ref|XM_013393818.1| | 5801 | g1718 | i0 | 100 | 0.0261096605744125 | 30 | 0 | 3 | 0 | 722 | 751 | 204 | 233 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 1820528 | 1820528 | PRJNA560932_P_NODE_60822_length_245_cov_0.895349_g60466_i0 | PRJNA560932 | 60822 | 245 | 0.895349 | 2.19360505 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|915132157|ref|XM_013480233.1| | 5804 | g60466 | i0 | 94.118 | 0.138775510204082 | 34 | 2 | 14 | 0 | 207 | 240 | 3050 | 3017 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 34 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 4371964 | 4371964 | PRJNA560932_P_NODE_22324_length_375_cov_0.976821_g21968_i0 | PRJNA560932 | 22324 | 375 | 0.976821 | 3.66307875 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|1620175562|ref|XM_028683273.1| | 880535 | g21968 | i0 | 100 | 0.0773333333333333 | 29 | 0 | 8 | 0 | 69 | 97 | 2955 | 2927 | Plasmodium sp. gorilla clade G2 vacuolar transporter chaperone,putative (PADL01_1230800), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 4372384 | 4372384 | PRJNA560932_P_NODE_9844_length_555_cov_2.400415_g9490_i0 | PRJNA560932 | 9844 | 555 | 2.400415 | 13.32230325 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 1.2800000000000002e-122 | NTclustered | gi|1673120333|ref|XM_029366196.1| | 94643 | g9490 | i0 | 81.588 | 97.6594594594595 | 554 | 96 | 99 | 6 | 5 | 555 | 818 | 268 | Besnoitia besnoiti alpha tubulin TUBA1 (BESB_078340), partial mRNA | blastn | 54201 | 453 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 5648368 | 5648368 | PRJNA560932_P_NODE_20825_length_386_cov_2.111821_g20469_i0 | PRJNA560932 | 20825 | 386 | 2.111821 | 8.15162906 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.037 | NTclustered | gi|2795620842|ref|XM_068064451.1| | 483139 | g20469 | i0 | 100 | 0.0725388601036269 | 28 | 0 | 7 | 0 | 324 | 351 | 243 | 216 | Cystoisospora suis dna chr wayne state university expressed family (CSUI_004258), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 8783462 | 8783462 | PRJNA560932_P_NODE_4127_length_839_cov_3.634465_g3831_i0 | PRJNA560932 | 4127 | 839 | 3.634465 | 30.49316135 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 632 | 2.369999999999999e-176 | NTclustered | gi|260232275|dbj|AK318274.1| | 5811 | g3831 | i0 | 81.156 | 91.4469606674613 | 796 | 142 | 94 | 8 | 3 | 794 | 1057 | 266 | Toxoplasma gondii cDNA, clone: XTG09340.2, full cDNA, XTG Sugano cDNA library | blastn | 76724 | 632 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 10748966 | 10748966 | PRJNA560932_P_NODE_3429_length_910_cov_27.764636_g3154_i0 | PRJNA560932 | 3429 | 910 | 27.764636 | 252.6581876 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.007 | NTclustered | gi|1620114090|ref|XM_028670209.1| | 5849 | g3154 | i0 | 92.5 | 0.043956043956044 | 40 | 1 | 4 | 2 | 829 | 866 | 683 | 722 | Plasmodium gallinaceum conserved Plasmodium protein, unknown function (PGAL8A_00386700), partial mRNA | blastn | 40 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 11333676 | 11333676 | PRJNA560932_P_NODE_13389_length_478_cov_1.876543_g13035_i0 | PRJNA560932 | 13389 | 478 | 1.876543 | 8.96987554 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.047 | NTclustered | gi|1085011886|ref|XM_018781301.1| | 508771 | g13035 | i0 | 100 | 0.117154811715481 | 28 | 0 | 6 | 0 | 156 | 183 | 591 | 564 | Toxoplasma gondii ME49 peptidase family c50 protein partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 12023877 | 12023877 | PRJNA560932_P_NODE_53070_length_251_cov_0.865169_g52714_i0 | PRJNA560932 | 53070 | 251 | 0.865169 | 2.17157419 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.2299999999999999e-74 | NTclustered | gi|1620123653|ref|XM_028672625.1| | 5849 | g52714 | i0 | 87.698 | 18 | 252 | 29 | 100 | 2 | 1 | 251 | 1022 | 772 | Plasmodium gallinaceum 26S protease regulatory subunit 6a, putative (RPT5), partial mRNA | blastn | 4518 | 292 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 13298734 | 13298734 | PRJNA560932_P_NODE_39491_length_289_cov_2.018519_g39135_i0 | PRJNA560932 | 39491 | 289 | 2.018519 | 5.83351991 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 4.38e-15 | NTclustered | gi|915123216|ref|XM_013477418.1| | 5804 | g39135 | i0 | 87.805 | 19.2595155709343 | 82 | 8 | 30 | 2 | 1 | 81 | 1224 | 1304 | Eimeria maxima hypothetical protein partial mRNA | blastn | 5566 | 95.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 15847577 | 15847577 | PRJNA560932_P_NODE_43513_length_277_cov_1.392157_g43157_i0 | PRJNA560932 | 43513 | 277 | 1.392157 | 3.85627489 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 7.04e-8 | NTclustered | gi|916504977|ref|XM_013497651.1| | 44415 | g43157 | i0 | 93.617 | 1.55956678700361 | 47 | 3 | 17 | 0 | 206 | 252 | 3399 | 3445 | Eimeria mitis uncharacterized protein (EMH_0059160), partial mRNA | blastn | 432 | 71.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 15847666 | 15847666 | PRJNA560932_P_NODE_54033_length_250_cov_0.870056_g53677_i0 | PRJNA560932 | 54033 | 250 | 0.870056 | 2.17514 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.35e-4 | NTclustered | gi|915001478|ref|XM_013393039.1| | 5801 | g53677 | i0 | 100 | 0.128 | 32 | 0 | 13 | 0 | 181 | 212 | 144 | 175 | Eimeria acervulina hypothetical protein partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 16433260 | 16433260 | PRJNA560932_P_NODE_45493_length_271_cov_1.237374_g45137_i0 | PRJNA560932 | 45493 | 271 | 1.237374 | 3.35328354 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916498807|ref|XM_013494769.1| | 44415 | g45137 | i0 | 92.308 | 0.542435424354244 | 39 | 3 | 14 | 0 | 104 | 142 | 309 | 347 | Eimeria mitis uncharacterized protein (EMH_0090460), partial mRNA | blastn | 147 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 19671166 | 19671166 | PRJNA560932_P_NODE_36236_length_302_cov_1.323144_g35880_i0 | PRJNA560932 | 36236 | 302 | 1.323144 | 3.99589488 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.028 | NTclustered | gi|915139101|ref|XM_013481635.1| | 5804 | g35880 | i0 | 100 | 0.0927152317880795 | 28 | 0 | 9 | 0 | 248 | 275 | 389 | 362 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 22807672 | 22807672 | PRJNA560932_P_NODE_18998_length_404_cov_0.930514_g18642_i0 | PRJNA560932 | 18998 | 404 | 0.930514 | 3.75927656 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.011 | NTclustered | gi|915001192|ref|XM_013392965.1| | 5801 | g18642 | i0 | 100 | 1.66831683168317 | 29 | 0 | 7 | 0 | 205 | 233 | 143 | 171 | Eimeria acervulina DNA-directed RNA polymerase, related partial mRNA | blastn | 674 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 24082474 | 24082474 | PRJNA560932_P_NODE_30959_length_325_cov_0.916667_g30603_i0 | PRJNA560932 | 30959 | 325 | 0.916667 | 2.97916775 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.031 | NTclustered | gi|915129098|ref|XM_013479538.1| | 5804 | g30603 | i0 | 100 | 0.172307692307692 | 28 | 0 | 9 | 0 | 34 | 61 | 2543 | 2516 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 24082476 | 24082476 | PRJNA560932_P_NODE_3319_length_924_cov_2.351351_g3046_i0 | PRJNA560932 | 3319 | 924 | 2.351351 | 21.72648324 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.002 | NTclustered | gi|8468620|gb|AF270648.1|AF270648 | 5833 | g3046 | i0 | 100 | 0.635281385281385 | 31 | 0 | 3 | 0 | 418 | 448 | 3345 | 3375 | Plasmodium falciparum mature parasite-infected erythrocyte surface antigen (MESA) gene, complete cds | blastn | 587 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum |
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);;