contig_metadata
18 rows where bioproject = "PRJEB6584", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25659727 | 25659727 | PRJEB6584h_S_NODE_1290_length_371_cov_14.113095_g1228_i0 | PRJEB6584 | 1290 | 371 | 14.113095 | 52.35958245 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 9.6e-18 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g1228 | i0 | 88.043 | 3.38814016172507 | 92 | 6 | 25 | 5 | 153 | 243 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 1257 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 25752068 | 25752068 | PRJEB6584d_S_NODE_15434_length_163_cov_1.906250_g15366_i0 | PRJEB6584 | 15434 | 163 | 1.90625 | 3.1071875 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.26e-5 | NTclustered | gi|527100844|dbj|AK441686.1| | 5865 | g15366 | i0 | 100 | 2.15337423312883 | 33 | 0 | 20 | 0 | 131 | 163 | 776 | 744 | Babesia bovis BBOV_I000230 mRNA for 40S ribosomal protein S5, putative, complete cds, clone: XBBk019114, strain: Texas | blastn | 351 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 25795846 | 25795846 | PRJEB6584k_S_NODE_123_length_510_cov_779.488421_g74_i1 | PRJEB6584 | 123 | 510 | 779.488421 | 3975.3909471 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.36e-17 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g74 | i1 | 88.043 | 4.75490196078431 | 92 | 6 | 18 | 5 | 64 | 154 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 2425 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 25932127 | 25932127 | PRJEB6584j_S_NODE_460_length_359_cov_9.802469_g431_i0 | PRJEB6584 | 460 | 359 | 9.802469 | 35.19086371 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 9.26e-18 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g431 | i0 | 88.043 | 3.42339832869081 | 92 | 6 | 25 | 5 | 191 | 281 | 243 | 330 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 1229 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 25932642 | 25932642 | PRJEB6584o_S_NODE_13788_length_237_cov_4.623762_g13680_i0 | PRJEB6584 | 13788 | 237 | 4.623762 | 10.95831594 | Parahaemoproteus sp. CP-2 | 1699097 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|702073050|emb|LN482998.1| | 1539139 | g13680 | i0 | 100 | 0.118143459915612 | 28 | 0 | 12 | 0 | 202 | 229 | 230 | 203 | Parahaemoproteus sp. CP-2014 partial ORF for putative eukaryotic translation initiation factor 2 gamm | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Haemoproteidae | Parahaemoproteus | Parahaemoproteus sp. CP-2014 | ||
| 25933000 | 25933000 | PRJEB6584o_S_NODE_23220_length_193_cov_3.094937_g23112_i0 | PRJEB6584 | 23220 | 193 | 3.094937 | 5.97322841 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 3.58e-4 | NTclustered | gi|915125688|ref|XM_013478654.1| | 5804 | g23112 | i0 | 100 | 2.90673575129534 | 31 | 0 | 16 | 0 | 81 | 111 | 535 | 565 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 561 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 26067681 | 26067681 | PRJEB6584a_S_NODE_981_length_349_cov_47.550955_g961_i0 | PRJEB6584 | 981 | 349 | 47.550955 | 165.95283295 | Cryptosporidium hominis | 237895 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 1.1399999999999999e-31 | NTclustered | gi|1822040754|gb|MT221440.1| | 237895 | g961 | i0 | 88.8 | 29.5873925501433 | 125 | 11 | 35 | 3 | 1 | 123 | 199 | 76 | Cryptosporidium hominis isolate gel band small subunit ribosomal RNA gene, partial sequence | blastn | 10326 | 150 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 26204411 | 26204411 | PRJEB6584k_S_NODE_118_length_514_cov_4.799582_g101_i0 | PRJEB6584 | 118 | 514 | 4.799582 | 24.66985148 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 3.76e-28 | NTclustered | gi|1085197446|ref|XR_001974451.1| | 508771 | g101 | i0 | 88.235 | 13.7762645914397 | 119 | 11 | 23 | 3 | 221 | 337 | 61 | 178 | Toxoplasma gondii ME49 28S ribosomal RNA rRNA | blastn | 7081 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 26340065 | 26340065 | PRJEB6584e_S_NODE_2831_length_176_cov_8.985816_g2816_i0 | PRJEB6584 | 2831 | 176 | 8.985816 | 15.81503616 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.001 | NTclustered | gi|1620167712|ref|XM_028681606.1| | 880535 | g2816 | i0 | 100 | 0.170454545454545 | 30 | 0 | 17 | 0 | 4 | 33 | 14993 | 14964 | Plasmodium sp. gorilla clade G2 E3 ubiquitin-protein ligase, putative (PADL01_0825300), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 26432318 | 26432318 | PRJEB6584o_S_NODE_18607_length_208_cov_19.537572_g18499_i0 | PRJEB6584 | 18607 | 208 | 19.537572 | 40.63814976 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 8.119999999999999e-31 | NTclustered | gi|832032833|ref|XM_012907670.1| | 5854 | g18499 | i0 | 86.232 | 41.8557692307692 | 138 | 15 | 65 | 3 | 73 | 208 | 1324 | 1189 | Plasmodium reichenowi tubulin beta chain, putative partial mRNA | blastn | 8706 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 26432484 | 26432484 | PRJEB6584o_S_NODE_7023_length_318_cov_5.363958_g6915_i0 | PRJEB6584 | 7023 | 318 | 5.363958 | 17.05738644 | Eimeriidae | 5799 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 6.36e-9 | NTclustered | gi|324022090|gb|GU593707.1| | 5801 | g6915 | i0 | 95.652 | 14.6100628930818 | 46 | 2 | 14 | 0 | 1 | 46 | 2691 | 2646 | Eimeria acervulina strain Miska2 28S ribosomal RNA gene, partial sequence | blastn | 4646 | 75 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 26476346 | 26476346 | PRJEB6584d_S_NODE_8880_length_202_cov_11.155689_g8812_i0 | PRJEB6584 | 8880 | 202 | 11.155689 | 22.53449178 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 4.79e-18 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g8812 | i0 | 88.043 | 6.08415841584158 | 92 | 6 | 45 | 5 | 20 | 110 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 1229 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 26476396 | 26476396 | PRJEB6584g_S_NODE_712_length_321_cov_11.779720_g700_i0 | PRJEB6584 | 712 | 321 | 11.77972 | 37.8129012 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 8.2e-18 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g700 | i0 | 88.043 | 3.82866043613707 | 92 | 6 | 28 | 5 | 170 | 260 | 243 | 330 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 1229 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 26476472 | 26476472 | PRJEB6584i_S_NODE_5240_length_174_cov_5.208633_g5228_i0 | PRJEB6584 | 5240 | 174 | 5.208633 | 9.06302142 | Platyproteum noduliferae | 2903131 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 5.23e-7 | NTclustered | gi|2250018225|dbj|LC663666.1| | 2903131 | g5228 | i0 | 97.436 | 0.224137931034483 | 39 | 1 | 22 | 0 | 136 | 174 | 3340 | 3302 | Platyproteum noduliferae P1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence | blastn | 39 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Archigregarinorida | Selenidiidae | Platyproteum | Platyproteum noduliferae | ||
| 26476511 | 26476511 | PRJEB6584k_S_NODE_88_length_552_cov_187.292070_g74_i0 | PRJEB6584 | 88 | 552 | 187.29207 | 1033.8522264 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.48e-17 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g74 | i0 | 88.043 | 4.24094202898551 | 92 | 6 | 16 | 5 | 64 | 154 | 330 | 243 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 2341 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 26568104 | 26568104 | PRJEB6584h_S_NODE_2112_length_322_cov_2.452962_g2050_i0 | PRJEB6584 | 2112 | 322 | 2.452962 | 7.89853764 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.03 | NTclustered | gi|1620112739|ref|XM_028674705.1| | 5849 | g2050 | i0 | 100 | 0.173913043478261 | 28 | 0 | 9 | 0 | 1 | 28 | 15729 | 15756 | Plasmodium gallinaceum E3 ubiquitin-protein ligase, putative (PGAL8A_00119300), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 32991606 | 32991606 | PRJEB6584e_S_NODE_2643_length_181_cov_1.876712_g2628_i0 | PRJEB6584 | 2643 | 181 | 1.876712 | 3.39684872 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 1.24e-11 | NR | CEL74828.1 | 432359 | g2628 | i0 | 54.7 | 2.6353591160221 | 53 | 24 | 87.8 | 0 | 161 | 3 | 29 | 81 | CEL74828.1 TPA: R1 protein [Toxoplasma gondii VEG] | diamond | 477 | 64.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 33082733 | 33082733 | PRJEB6584f_S_NODE_2550_length_194_cov_2.591195_g2544_i0 | PRJEB6584 | 2550 | 194 | 2.591195 | 5.0269183 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 1.05e-5 | NR | KAF8822671.1 | 476202 | g2544 | i0 | 79.3 | 2.69072164948454 | 29 | 6 | 44.8 | 0 | 193 | 107 | 574 | 602 | KAF8822671.1 thioredoxin reductase [Cardiosporidium cionae] | diamond | 522 | 52 | 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);;