contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 902401 | 902401 | PRJNA928559_P_NODE_134561_length_305_cov_8.474138_g132992_i0 | PRJNA928559 | 134561 | 305 | 8.474138 | 25.8461209 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|820698945|tpe|LN714498.1| | 432359 | g132992 | i0 | 100 | 0.095081967213114807 | 29 | 0 | 10 | 0 | 91 | 119 | 2293515 | 2293487 | TPA_asm: Toxoplasma gondii VEG, chromosome chrVIII, complete genome | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 2177600 | 2177600 | PRJNA928559_P_NODE_126882_length_315_cov_3.289256_g125313_i0 | PRJNA928559 | 126882 | 315 | 3.289256 | 10.3611564 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 8.95e-122 | NTclustered | gi|134021988|gb|EF023338.1| | 404735 | g125313 | i0 | 92.523 | 76.415873015873 | 321 | 12 | 100 | 8 | 1 | 315 | 1791 | 1477 | Eimeriidae environmental sample clone Amb_18S_660 18S ribosomal RNA gene, partial sequence | blastn | 24071 | 449 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 2177950 | 2177950 | PRJNA928559_P_NODE_152442_length_285_cov_1.905660_g150873_i0 | PRJNA928559 | 152442 | 285 | 1.90566 | 5.431131 | Eimeria anguillae | 947528 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 7.17e-18 | NTclustered | gi|324022087|gb|GU593704.1| | 947528 | g150873 | i0 | 84.112 | 8.89122807017544 | 107 | 17 | 38 | 0 | 140 | 246 | 1504 | 1610 | Eimeria anguillae strain 128 28S ribosomal RNA gene, partial sequence | blastn | 2534 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria anguillae | ||
| 2178754 | 2178754 | PRJNA928559_P_NODE_206122_length_245_cov_1.720930_g204553_i0 | PRJNA928559 | 206122 | 245 | 1.72093 | 4.2162785 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.28e-24 | NTclustered | gi|457870372|ref|XM_004222059.1| | 1120755 | g204553 | i0 | 84.328 | 4.6734693877551 | 134 | 15 | 53 | 6 | 94 | 224 | 592 | 462 | Plasmodium cynomolgi strain B 40S ribosomal protein S11 (PCYB_083210) mRNA, complete cds | blastn | 1145 | 126 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 4732161 | 4732161 | PRJNA928559_P_NODE_22564_length_672_cov_4.215359_g21076_i0 | PRJNA928559 | 22564 | 672 | 4.215359 | 28.32721248 | Goussia bayae | 2303416 | SAR_Eukaryotes | SAR_Eukaryotes | 965 | 0 | NTclustered | gi|1450318675|gb|MH758782.1| | 2303416 | g21076 | i0 | 92.522 | 97.1324404761905 | 682 | 38 | 100 | 12 | 1 | 672 | 1550 | 2228 | Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence | blastn | 65273 | 965 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia bayae | ||
| 5080978 | 5080978 | PRJNA928559_P_NODE_117864_length_328_cov_1.929412_g116295_i0 | PRJNA928559 | 117864 | 328 | 1.929412 | 6.32847136 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 4.91e-35 | NTclustered | gi|22035803|emb|AJ493200.1| | 5807 | g116295 | i0 | 83.146 | 54.2225609756098 | 178 | 29 | 54 | 1 | 40 | 217 | 236 | 60 | Cryptosporidium parvum 18S rRNA gene, isolate Th18Cp | blastn | 17785 | 161 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 9830672 | 9830672 | PRJNA928559_P_NODE_16908_length_763_cov_3.781159_g15496_i0 | PRJNA928559 | 16908 | 763 | 3.781159 | 28.85024317 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 4.449999999999999e-24 | NTclustered | gi|160358922|gb|EU252544.1| | 88456 | g15496 | i0 | 89.216 | 11.3263433813893 | 102 | 10 | 13 | 1 | 12 | 113 | 42 | 142 | Cyclospora cayetanensis 28S large subunit ribosomal RNA gene, partial sequence | blastn | 8642 | 126 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 9831001 | 9831001 | PRJNA928559_P_NODE_191928_length_251_cov_1.674157_g190359_i0 | PRJNA928559 | 191928 | 251 | 1.674157 | 4.20213407 | Theileria equi | 5872 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.65e-39 | NTclustered | gi|2047401839|gb|MZ327271.1| | 5872 | g190359 | i0 | 93.966 | 46.2151394422311 | 116 | 6 | 46 | 1 | 1 | 115 | 974 | 1089 | Theileria equi voucher SD-53 small subunit ribosomal RNA gene, partial sequence | blastn | 11600 | 174 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 10181589 | 10181589 | PRJNA928559_P_NODE_199608_length_248_cov_0.891429_g198039_i0 | PRJNA928559 | 199608 | 248 | 0.891429 | 2.21074392 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|820700576|tpe|LN714500.1| | 432359 | g198039 | i0 | 96.875 | 0.258064516129032 | 32 | 1 | 13 | 0 | 205 | 236 | 4345315 | 4345346 | TPA_asm: Toxoplasma gondii VEG, chromosome chrX, complete genome | blastn | 64 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 11108078 | 11108078 | PRJNA928559_P_NODE_81689_length_392_cov_4.031348_g80120_i0 | PRJNA928559 | 81689 | 392 | 4.031348 | 15.80288416 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 6.05e-25 | NTclustered | gi|1673118587|ref|XM_029364694.1| | 94643 | g80120 | i0 | 76.305 | 1.25510204081633 | 249 | 53 | 63 | 6 | 37 | 282 | 100 | 345 | Besnoitia besnoiti ribosomal protein RPS20 (BESB_062800), partial mRNA | blastn | 492 | 128 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 15280808 | 15280808 | PRJNA928559_P_NODE_174752_length_263_cov_12.115789_g173183_i0 | PRJNA928559 | 174752 | 263 | 12.115789 | 31.86452507 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.99e-5 | NTclustered | gi|527046689|tpe|HG323591.1| | 5807 | g173183 | i0 | 100 | 0.250950570342205 | 33 | 0 | 13 | 0 | 92 | 124 | 192 | 160 | TPA: Cryptosporidium parvum SRP RNA for signal recognition particle RNA | blastn | 66 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 16206554 | 16206554 | PRJNA928559_P_NODE_217553_length_238_cov_3.000000_g215984_i0 | PRJNA928559 | 217553 | 238 | 3 | 7.14 | Theileria uilenbergi | 507731 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 5.9e-8 | NTclustered | gi|396582134|gb|JN696674.1| | 507731 | g215984 | i0 | 90.566 | 7.17226890756303 | 53 | 5 | 22 | 0 | 114 | 166 | 642 | 590 | Theileria uilenbergi 28S ribosomal RNA gene, partial sequence | blastn | 1707 | 71.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria uilenbergi | ||
| 16207015 | 16207015 | PRJNA928559_P_NODE_44933_length_505_cov_176.314815_g43374_i0 | PRJNA928559 | 44933 | 505 | 176.314815 | 890.38981575 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 1.76e-6 | NTclustered | gi|1305413|gb|U48228.1|PFU48228 | 5833 | g43374 | i0 | 88.333 | 8.44158415841584 | 60 | 2 | 12 | 5 | 1 | 59 | 4100 | 4155 | Plasmodium falciparum 5.8S ribosomal RNA gene, partial sequence, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 4263 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 17480758 | 17480758 | PRJNA928559_P_NODE_153114_length_284_cov_3.137441_g151545_i0 | PRJNA928559 | 153114 | 284 | 3.137441 | 8.91033244 | Nephromyces sp. ex Molgula occidentalis | 2544991 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.57e-4 | NTclustered | gi|1735073298|gb|MK573205.1| | 2544991 | g151545 | i0 | 88.235 | 0.71830985915493 | 51 | 5 | 18 | 1 | 102 | 151 | 24881 | 24931 | Nephromyces sp. ex Molgula occidentalis isolate 654 apicoplast, partial genome | blastn | 204 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Nephromyces | Nephromyces sp. ex Molgula occidentalis | |||
| 17481980 | 17481980 | PRJNA928559_P_NODE_27434_length_619_cov_3.710623_g25919_i0 | PRJNA928559 | 27434 | 619 | 3.710623 | 22.96875637 | Coccidia sp. | 2049902 | SAR_Eukaryotes | SAR_Eukaryotes | 1026 | 0 | NTclustered | gi|1419337971|gb|MH590232.1| | 2049902 | g25919 | i0 | 96.602 | 64.0420032310178 | 618 | 21 | 99 | 0 | 2 | 619 | 2822 | 2205 | 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 | 39642 | 1026 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Coccidia sp. | |||||
| 20030028 | 20030028 | PRJNA928559_P_NODE_209016_length_244_cov_1.339181_g207447_i0 | PRJNA928559 | 209016 | 244 | 1.339181 | 3.26760164 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|1145263604|ref|XM_012910067.2| | 5854 | g207447 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 179 | 206 | 4055 | 4082 | Plasmodium reichenowi CH domain-containing protein, putative partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 21655094 | 21655094 | PRJNA928559_P_NODE_171677_length_266_cov_2.948187_g170108_i0 | PRJNA928559 | 171677 | 266 | 2.948187 | 7.84217742 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.32e-74 | NTclustered | gi|1027949875|ref|XM_734387.2| | 31271 | g170108 | i0 | 86.923 | 77.3834586466165 | 260 | 34 | 98 | 0 | 1 | 260 | 1055 | 1314 | Plasmodium chabaudi chabaudi alpha-tubulin 2, putative (PCHAS_0522900), partial mRNA | blastn | 20584 | 292 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 23856957 | 23856957 | PRJNA928559_P_NODE_93419_length_368_cov_10.210169_g91850_i0 | PRJNA928559 | 93419 | 368 | 10.210169 | 37.57342192 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 2.09e-4 | NTclustered | gi|1931714359|ref|XR_552297.2| | 54757 | g91850 | i0 | 86.792 | 3.17391304347826 | 53 | 7 | 14 | 0 | 253 | 305 | 4102 | 4050 | Plasmodium vinckei vinckei ribosomal RNA (PVVCY_0502190), rRNA | blastn | 1168 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei |
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);;