contig_metadata
17 rows where bioproject = "PRJNA1005695", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153483 | 153483 | PRJNA1005695_P_NODE_22341_length_317_cov_13.647541_g21489_i0 | PRJNA1005695 | 22341 | 317 | 13.647541 | 43.26270497 | Coccidia sp. | 2049902 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.91e-133 | NTclustered | gi|1419337971|gb|MH590232.1| | 2049902 | g21489 | i0 | 94.603 | 3.45425867507886 | 315 | 17 | 99 | 0 | 2 | 316 | 2883 | 2569 | Coccidia sp. clone C2.5 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1095 | 488 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Coccidia sp. | |||||
| 1428271 | 1428271 | PRJNA1005695_P_NODE_28782_length_278_cov_6.229268_g27930_i0 | PRJNA1005695 | 28782 | 278 | 6.229268 | 17.31736504 | Goussia pannonica | 947569 | SAR_Eukaryotes | SAR_Eukaryotes | 473 | 4.6099999999999987e-129 | NTclustered | gi|328460776|gb|GU479651.1| | 947569 | g27930 | i0 | 97.473 | 100.035971223022 | 277 | 7 | 99 | 0 | 1 | 277 | 411 | 687 | Goussia pannonica isolate ABS622-#622 18S ribosomal RNA gene, partial sequence | blastn | 27810 | 473 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia pannonica | ||
| 2703751 | 2703751 | PRJNA1005695_P_NODE_29943_length_272_cov_61.788945_g29091_i0 | PRJNA1005695 | 29943 | 272 | 61.788945 | 168.0659304 | Coccidia sp. | 2049902 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 7.57e-122 | NTclustered | gi|1419337971|gb|MH590232.1| | 2049902 | g29091 | i0 | 96.667 | 91.9852941176471 | 270 | 9 | 99 | 0 | 2 | 271 | 2259 | 2528 | Coccidia sp. clone C2.5 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25020 | 449 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Coccidia sp. | |||||
| 9929122 | 9929122 | PRJNA1005695_P_NODE_29948_length_272_cov_7.753769_g29096_i0 | PRJNA1005695 | 29948 | 272 | 7.753769 | 21.09025168 | Goussia | 169155 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.47e-132 | NTclustered | gi|21304222|gb|AY043206.1| | 169156 | g29096 | i0 | 98.889 | 98.0110294117647 | 270 | 3 | 99 | 0 | 2 | 271 | 127 | 396 | Goussia janae small subunit ribosomal RNA, partial sequence | blastn | 26659 | 483 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia janae | ||
| 10356562 | 10356562 | PRJNA1005695_P_NODE_14549_length_399_cov_27.177914_g13697_i0 | PRJNA1005695 | 14549 | 399 | 27.177914 | 108.43987686 | Goussia bayae | 2303416 | SAR_Eukaryotes | SAR_Eukaryotes | 643 | 4.959999999999999e-180 | NTclustered | gi|1450318675|gb|MH758782.1| | 2303416 | g13697 | i0 | 95.771 | 99.5789473684211 | 402 | 11 | 99 | 5 | 2 | 398 | 2007 | 1607 | Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence | blastn | 39732 | 643 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia bayae | ||
| 13754550 | 13754550 | PRJNA1005695_P_NODE_34331_length_254_cov_0.850829_g33479_i0 | PRJNA1005695 | 34331 | 254 | 0.850829 | 2.16110566 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|1976646559|ref|XM_039114055.1| | 5851 | g33479 | i0 | 100 | 0.228346456692913 | 29 | 0 | 11 | 0 | 1 | 29 | 9639 | 9667 | Plasmodium knowlesi strain H conserved Plasmodium protein, unknown function (PKNH_1218400), partial mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 15456132 | 15456132 | PRJNA1005695_P_NODE_24153_length_305_cov_10.750000_g23301_i0 | PRJNA1005695 | 24153 | 305 | 10.75 | 32.7875 | Goussia bayae | 2303416 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.35e-137 | NTclustered | gi|1450318675|gb|MH758782.1| | 2303416 | g23301 | i0 | 96.393 | 100.590163934426 | 305 | 9 | 99 | 2 | 2 | 305 | 2805 | 2502 | Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence | blastn | 30680 | 501 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia bayae | ||
| 16303548 | 16303548 | PRJNA1005695_P_NODE_13313_length_420_cov_3.423631_g12461_i0 | PRJNA1005695 | 13313 | 420 | 3.423631 | 14.3792502 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.003 | NTclustered | gi|84997470|ref|XM_948364.1| | 5874 | g12461 | i0 | 100 | 0.15 | 30 | 0 | 7 | 0 | 89 | 118 | 352 | 381 | Theileria annulata uncharacterized protein (TA11355), partial mRNA | blastn | 63 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 17578919 | 17578919 | PRJNA1005695_P_NODE_20554_length_333_cov_1.003846_g19702_i0 | PRJNA1005695 | 20554 | 333 | 1.003846 | 3.34280718 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.36e-50 | NTclustered | gi|8918237|dbj|AB023579.1| | 5833 | g19702 | i0 | 79.048 | 6.54954954954955 | 315 | 62 | 94 | 4 | 1 | 313 | 888 | 1200 | Plasmodium falciparum gene for elongation factor 2, partial cds | blastn | 2181 | 213 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 24379465 | 24379465 | PRJNA1005695_P_NODE_18360_length_352_cov_36.086022_g17508_i0 | PRJNA1005695 | 18360 | 352 | 36.086022 | 127.02279744 | Goussia bayae | 2303416 | SAR_Eukaryotes | SAR_Eukaryotes | 549 | 9.679999999999996e-152 | NTclustered | gi|1450318675|gb|MH758782.1| | 2303416 | g17508 | i0 | 94.872 | 72.7869318181818 | 351 | 18 | 99 | 0 | 1 | 351 | 3434 | 3084 | Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence | blastn | 25621 | 549 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia bayae | ||
| 27375047 | 27375047 | PRJNA1005695_P_NODE_13783_length_412_cov_0.920354_g12931_i0 | PRJNA1005695 | 13783 | 412 | 0.920354 | 3.79185848 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.0184 | NR | XP_012767158.1 | 5866 | g12931 | i0 | 36.2 | 0.983009708737864 | 69 | 43 | 50.2 | 1 | 217 | 11 | 568 | 635 | XP_012767158.1 hypothetical protein, conserved [Babesia bigemina] | diamond | 405 | 46.2 | 0.991341991341991 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 27943160 | 27943160 | PRJNA1005695_P_NODE_34665_length_253_cov_0.866667_g33813_i0 | PRJNA1005695 | 34665 | 253 | 0.866667 | 2.19266751 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 1.73e-21 | NR | XP_002259675.1 | 5851 | g33813 | i0 | 50.6 | 7.71936758893281 | 81 | 40 | 96 | 0 | 244 | 2 | 44 | 124 | XP_002259675.1 ras-related protein Rab-1A, putative [Plasmodium knowlesi strain H] | diamond | 1953 | 94 | 0.995744680851064 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 30438017 | 30438017 | PRJNA1005695_P_NODE_38653_length_245_cov_0.906977_g37801_i0 | PRJNA1005695 | 38653 | 245 | 0.906977 | 2.22209365 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 1.74e-12 | NR | XP_067196856.1 | 515981 | g37801 | i0 | 74.5 | 5.09387755102041 | 47 | 12 | 57.6 | 0 | 102 | 242 | 110 | 156 | XP_067196856.1 uncharacterized protein FG386_002057 [Cryptosporidium ryanae] | diamond | 1248 | 72 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 30445388 | 30445388 | PRJNA1005695_P_NODE_30553_length_270_cov_1.578680_g29701_i0 | PRJNA1005695 | 30553 | 270 | 1.57868 | 4.262436 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 4.660000000000001e-27 | NR | XP_067926961.1 | 483139 | g29701 | i0 | 58.1 | 4.77777777777778 | 86 | 36 | 95.6 | 0 | 268 | 11 | 667 | 752 | XP_067926961.1 emp24 gp25l p24 family protein [Cystoisospora suis] | diamond | 1290 | 114 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 31614676 | 31614676 | PRJNA1005695_P_NODE_36496_length_249_cov_1.261364_g35644_i0 | PRJNA1005695 | 36496 | 249 | 1.261364 | 3.14079636 | Eimeria brunetti | 51314 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0159 | NR | CDJ47586.1 | 51314 | g35644 | i0 | 36.9 | 0.783132530120482 | 65 | 41 | 78.3 | 0 | 51 | 245 | 28 | 92 | CDJ47586.1 hypothetical protein, conserved [Eimeria brunetti] | diamond | 195 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti | ||
| 31891896 | 31891896 | PRJNA1005695_P_NODE_9937_length_493_cov_0.928571_g9086_i0 | PRJNA1005695 | 9937 | 493 | 0.928571 | 4.57785503 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 9.16e-8 | NR | XP_002369261.1 | 508771 | g9086 | i0 | 41.1 | 4.15618661257606 | 73 | 41 | 43.2 | 1 | 215 | 3 | 105 | 177 | XP_002369261.1 kelch repeat protein, putative [Toxoplasma gondii ME49] | diamond | 2049 | 62.4 | 0.993589743589744 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 32745435 | 32745435 | PRJNA1005695_P_NODE_23940_length_307_cov_1.901709_g23088_i0 | PRJNA1005695 | 23940 | 307 | 1.901709 | 5.83824663 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 3.49e-11 | NR | XP_011130710.1 | 110365 | g23088 | i0 | 52.7 | 2.12052117263844 | 74 | 27 | 72.3 | 2 | 305 | 84 | 518 | 583 | XP_011130710.1 prolyl-tRNA synthetase [Gregarina niphandrodes] | diamond | 651 | 69.7 | 0.994261119081779 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes |
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);;