contig_metadata
15 rows where bioproject = "PRJNA911178", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3443475 | 3443475 | PRJNA911178_P_NODE_26303_length_660_cov_1.703578_g23998_i0 | PRJNA911178 | 26303 | 660 | 1.703578 | 11.2436148 | Cryptosporidium hominis | 237895 | SAR_Eukaryotes | SAR_Eukaryotes | 1131 | 0 | NTclustered | gi|67586105|ref|XM_660074.1| | 353151 | g23998 | i0 | 97.576 | 2 | 660 | 16 | 100 | 0 | 1 | 660 | 14 | 673 | Cryptosporidium hominis TU502 sensor histidine kinase (Chro.00003) partial mRNA | blastn | 1320 | 1131 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 4720453 | 4720453 | PRJNA911178_P_NODE_181124_length_282_cov_1.904306_g178651_i0 | PRJNA911178 | 181124 | 282 | 1.904306 | 5.37014292 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 5.59e-24 | NR | CEL74008.1 | 432359 | g178651 | i0 | 52.2 | 4.87234042553191 | 92 | 43 | 96.8 | 1 | 9 | 281 | 79 | 170 | CEL74008.1 TPA: hydroxyacylglutathione hydrolase, putative [Toxoplasma gondii VEG] | diamond | 1374 | 102 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 4720646 | 4720646 | PRJNA911178_P_NODE_202284_length_270_cov_2.309645_g199810_i0 | PRJNA911178 | 202284 | 270 | 2.309645 | 6.2360415 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 9.37e-29 | NR | OEH78182.1 | 88456 | g199810 | i0 | 65.9 | 0.977777777777778 | 88 | 30 | 97.8 | 0 | 264 | 1 | 421 | 508 | OEH78182.1 heat shock protein [Cyclospora cayetanensis] | diamond | 264 | 118 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 5996058 | 5996058 | PRJNA911178_P_NODE_286165_length_242_cov_1.366864_g283691_i0 | PRJNA911178 | 286165 | 242 | 1.366864 | 3.30781088 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 5.41e-83 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g283691 | i0 | 91.81 | 17.8347107438017 | 232 | 16 | 96 | 2 | 1 | 232 | 309 | 81 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 4316 | 320 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 14004321 | 14004321 | PRJNA911178_P_NODE_284471_length_242_cov_3.603550_g281997_i0 | PRJNA911178 | 284471 | 242 | 3.60355 | 8.720591 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.69e-4 | NTclustered | gi|527046684|tpe|HG323586.1| | 5833 | g281997 | i0 | 100 | 1.61570247933884 | 31 | 0 | 13 | 0 | 31 | 61 | 189 | 159 | TPA: Plasmodium falciparum SRP RNA for signal recognition particle RNA | blastn | 391 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 14919648 | 14919648 | PRJNA911178_P_NODE_154032_length_301_cov_1.947368_g151559_i0 | PRJNA911178 | 154032 | 301 | 1.947368 | 5.86157768 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 6.02e-4 | NTclustered | gi|1620950985|ref|XM_028687555.1| | 77519 | g151559 | i0 | 94.595 | 0.122923588039867 | 37 | 2 | 12 | 0 | 78 | 114 | 4479 | 4443 | Plasmodium gonderi hypothetical protein, conserved (PGO_083330), partial mRNA | blastn | 37 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 16552473 | 16552473 | PRJNA911178_P_NODE_214113_length_264_cov_1.486911_g211639_i0 | PRJNA911178 | 214113 | 264 | 1.486911 | 3.92544504 | Gregarina | 35089 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 2.6299999999999993e-121 | NTclustered | gi|473752|gb|L31841.1|GNA18SRRB | 35091 | g211639 | i0 | 98.054 | 74.4583333333333 | 257 | 5 | 97 | 0 | 6 | 262 | 44 | 300 | Gregarina chortiocetes 18S ribosomal RNA gene, partial | blastn | 19657 | 448 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina chortiocetes | ||
| 18744477 | 18744477 | PRJNA911178_P_NODE_297295_length_238_cov_2.254545_g294821_i0 | PRJNA911178 | 297295 | 238 | 2.254545 | 5.3658171 | Eimeria stiedai | 471275 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 6.629999999999998e-107 | NTclustered | gi|511997|emb|Z33907.1| | 471275 | g294821 | i0 | 97.059 | 1.61344537815126 | 238 | 6 | 100 | 1 | 1 | 238 | 611 | 847 | E.stiedae (U82/129) DNA sequence (1173bp) | blastn | 384 | 399 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria stiedai | ||
| 20019599 | 20019599 | PRJNA911178_P_NODE_304316_length_228_cov_2.251613_g301842_i0 | PRJNA911178 | 304316 | 228 | 2.251613 | 5.13367764 | Eimeria stiedai | 471275 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 5.05e-83 | NTclustered | gi|511997|emb|Z33907.1| | 471275 | g301842 | i0 | 93.182 | 1.8859649122807 | 220 | 11 | 96 | 3 | 1 | 220 | 591 | 376 | E.stiedae (U82/129) DNA sequence (1173bp) | blastn | 430 | 320 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria stiedai | ||
| 22569933 | 22569933 | PRJNA911178_P_NODE_293878_length_241_cov_0.916667_g291404_i0 | PRJNA911178 | 293878 | 241 | 0.916667 | 2.20916747 | Gregarina sp. IF-2020a | 2742471 | SAR_Eukaryotes | SAR_Eukaryotes | 414 | 2.3999999999999993e-111 | NTclustered | gi|2008918971|emb|LR814091.1| | 2742471 | g291404 | i0 | 99.13 | 90.1742738589212 | 230 | 2 | 95 | 0 | 12 | 241 | 6 | 235 | Gregarina sp. IF-2020a partial 18S rRNA gene, clone SG2.01.SA.2014-28 | blastn | 21732 | 414 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina sp. IF-2020a | ||
| 23843717 | 23843717 | PRJNA911178_P_NODE_129839_length_324_cov_1.215139_g127367_i0 | PRJNA911178 | 129839 | 324 | 1.215139 | 3.93705036 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 7.039999999999998e-133 | NTclustered | gi|324022090|gb|GU593707.1| | 5801 | g127367 | i0 | 94.375 | 98.4567901234568 | 320 | 13 | 98 | 4 | 1 | 316 | 1877 | 1559 | Eimeria acervulina strain Miska2 28S ribosomal RNA gene, partial sequence | blastn | 31900 | 486 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 29179461 | 29179461 | PRJNA911178_P_NODE_141949_length_312_cov_1.255230_g139476_i0 | PRJNA911178 | 141949 | 312 | 1.25523 | 3.9163176 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 1.03e-10 | NR | VWU48375.1 | 2600580 | g139476 | i0 | 41.9 | 1.70192307692308 | 74 | 43 | 71.2 | 0 | 85 | 306 | 508 | 581 | VWU48375.1 RNA-binding protein, putative [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 531 | 68.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 29747338 | 29747338 | PRJNA911178_P_NODE_225090_length_258_cov_2.021622_g222616_i0 | PRJNA911178 | 225090 | 258 | 2.021622 | 5.21578476 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 5.830000000000001e-27 | NR | AFV39095.1 | 93969 | g222616 | i0 | 66.7 | 4.37209302325581 | 75 | 20 | 87.2 | 1 | 2 | 226 | 100 | 169 | AFV39095.1 glutamate tRNA ligase, partial [Cryptosporidium meleagridis] | diamond | 1128 | 111 | 0.990990990990991 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium meleagridis | ||
| 31193167 | 31193167 | PRJNA911178_P_NODE_79435_length_398_cov_2.150769_g76969_i0 | PRJNA911178 | 79435 | 398 | 2.150769 | 8.56006062 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00804 | NR | XP_067807512.1 | 2853593 | g76969 | i0 | 32.6 | 1.80904522613065 | 95 | 42 | 69.3 | 4 | 390 | 115 | 124 | 199 | XP_067807512.1 MAG: uncharacterized protein KVP18_005252 [Porospora cf. gigantea A] | diamond | 720 | 46.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A | ||
| 31896731 | 31896731 | PRJNA911178_P_NODE_235277_length_253_cov_1.700000_g232803_i0 | PRJNA911178 | 235277 | 253 | 1.7 | 4.301 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.0031 | NR | BAN65996.1 | 5865 | g232803 | i0 | 34.7 | 1.77865612648221 | 75 | 48 | 88.9 | 1 | 228 | 4 | 1 | 74 | BAN65996.1 mitochondrial import inner membrane translocase subunit Tim17, putative [Babesia bovis] | diamond | 450 | 45.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis |
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);;