contig_metadata
19 rows where bioproject = "PRJNA407886", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5521925 | 5521925 | PRJNA407886_P_NODE_77185_length_245_cov_0.895349_g75491_i0 | PRJNA407886 | 77185 | 245 | 0.895349 | 2.19360505 | Eimeria magna | 471282 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.72e-36 | NTclustered | gi|2512998691|gb|OQ128328.1| | 471282 | g75491 | i0 | 80.841 | 65.2897959183673 | 214 | 38 | 86 | 1 | 2 | 212 | 670 | 457 | Eimeria magna isolate Chengdu glyceraldehyde-3-phosphate dehydrogenase (GAPDH) mRNA, complete cds | blastn | 15996 | 165 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria magna | ||
| 8071147 | 8071147 | PRJNA407886_P_NODE_63527_length_265_cov_1.604167_g61833_i0 | PRJNA407886 | 63527 | 265 | 1.604167 | 4.25104255 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.03e-35 | NR | UKK00186.1 | 68886 | g61833 | i0 | 70.1 | 11.7056603773585 | 87 | 25 | 97.4 | 1 | 1 | 258 | 81 | 167 | UKK00186.1 peptidyl-prolyl cis-trans isomerase [Theileria orientalis] | diamond | 3102 | 129 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 9345415 | 9345415 | PRJNA407886_P_NODE_34368_length_381_cov_5.019481_g32674_i0 | PRJNA407886 | 34368 | 381 | 5.019481 | 19.12422261 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|915016413|ref|XM_013397464.1| | 5801 | g32674 | i0 | 100 | 0.0761154855643045 | 29 | 0 | 8 | 0 | 16 | 44 | 392 | 420 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 10621612 | 10621612 | PRJNA407886_P_NODE_56629_length_283_cov_2.647619_g54935_i0 | PRJNA407886 | 56629 | 283 | 2.647619 | 7.49276177 | Theileria equi | 5872 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|510902588|ref|XM_004829868.1| | 1537102 | g54935 | i0 | 96.875 | 0.212014134275618 | 32 | 1 | 11 | 0 | 15 | 46 | 281 | 250 | Theileria equi strain WA signal peptide-containing protein (BEWA_031120), partial mRNA | blastn | 60 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 14447042 | 14447042 | PRJNA407886_P_NODE_77972_length_244_cov_0.900585_g76278_i0 | PRJNA407886 | 77972 | 244 | 0.900585 | 2.1974274 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.73e-23 | NR | XP_026189909.1 | 88456 | g76278 | i0 | 61.3 | 8.84016393442623 | 80 | 31 | 98.4 | 0 | 242 | 3 | 293 | 372 | XP_026189909.1 2-oxoglutarate dehydrogenase, mitochondrial [Cyclospora cayetanensis] | diamond | 2157 | 103 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 15720741 | 15720741 | PRJNA407886_P_NODE_74113_length_247_cov_1.522989_g72419_i0 | PRJNA407886 | 74113 | 247 | 1.522989 | 3.76178283 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 2.889999999999999e-38 | NR | XP_067812290.1 | 2853593 | g72419 | i0 | 80.5 | 3.98380566801619 | 82 | 16 | 99.6 | 0 | 1 | 246 | 129 | 210 | XP_067812290.1 MAG: uncharacterized protein KVP18_001420 [Porospora cf. gigantea A] | diamond | 984 | 138 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A | ||
| 15720815 | 15720815 | PRJNA407886_P_NODE_78353_length_244_cov_0.900585_g76659_i0 | PRJNA407886 | 78353 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 7.34e-44 | NR | XP_019969845.1 | 5854 | g76659 | i0 | 94.9 | 226.327868852459 | 79 | 4 | 97.1 | 0 | 6 | 242 | 23 | 101 | XP_019969845.1 26S proteasome AAA-ATPase subunit RPT3, putative, partial [Plasmodium reichenowi] | diamond | 55224 | 151 | 0.993377483443709 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 20818590 | 20818590 | PRJNA407886_P_NODE_20197_length_566_cov_3.703854_g18512_i0 | PRJNA407886 | 20197 | 566 | 3.703854 | 20.96381364 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 1.5799999999999999e-62 | NR | OEH76901.1 | 88456 | g18512 | i0 | 61.5 | 1.86042402826855 | 179 | 69 | 94.9 | 0 | 4 | 540 | 29 | 207 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 1053 | 202 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 24644214 | 24644214 | PRJNA407886_P_NODE_64240_length_263_cov_1.973684_g62546_i0 | PRJNA407886 | 64240 | 263 | 1.973684 | 5.19078892 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 2.6199999999999995e-121 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g62546 | i0 | 97.338 | 3.31178707224335 | 263 | 7 | 100 | 0 | 1 | 263 | 117664 | 117402 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 871 | 448 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 26726951 | 26726951 | PRJNA407886_P_NODE_70481_length_250_cov_1.807910_g68787_i0 | PRJNA407886 | 70481 | 250 | 1.80791 | 4.519775 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 3.32e-14 | NR | KAF8820485.1 | 476202 | g68787 | i0 | 41.2 | 5.136 | 85 | 47 | 99.6 | 2 | 1 | 249 | 33 | 116 | KAF8820485.1 serine/threonine specific protein phosphatase [Cardiosporidium cionae] | diamond | 1284 | 77 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 27060547 | 27060547 | PRJNA407886_P_NODE_38722_length_353_cov_2.900000_g37028_i0 | PRJNA407886 | 38722 | 353 | 2.9 | 10.237 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 1.3399999999999998e-31 | NR | XP_012766397.1 | 5866 | g37028 | i0 | 68 | 20.8300283286119 | 75 | 24 | 63.7 | 0 | 322 | 98 | 58 | 132 | XP_012766397.1 40S ribosomal protein S15, putative [Babesia bigemina] | diamond | 7353 | 119 | 0.991596638655462 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 27676003 | 27676003 | PRJNA407886_P_NODE_73144_length_248_cov_0.880000_g71450_i0 | PRJNA407886 | 73144 | 248 | 0.88 | 2.1824 | Cryptosporidium felis | 83540 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 8.84e-18 | NR | KAF7456640.1 | 83540 | g71450 | i0 | 60.3 | 4.29435483870968 | 73 | 27 | 88.3 | 1 | 236 | 18 | 273 | 343 | KAF7456640.1 cAMP-dependent protein kinase regulatory subunit [Cryptosporidium felis] | diamond | 1065 | 86.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis | ||
| 28180680 | 28180680 | PRJNA407886_P_NODE_28446_length_433_cov_3.544444_g26753_i0 | PRJNA407886 | 28446 | 433 | 3.544444 | 15.34744252 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 2.2099999999999998e-60 | NR | OEH76901.1 | 88456 | g26753 | i0 | 69.9 | 4.93995381062356 | 143 | 43 | 99.1 | 0 | 429 | 1 | 29 | 171 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2139 | 195 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 28987199 | 28987199 | PRJNA407886_P_NODE_27148_length_449_cov_1.664894_g25455_i0 | PRJNA407886 | 27148 | 449 | 1.664894 | 7.47537406 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 2.8999999999999996e-68 | NR | XP_013332946.1 | 5804 | g25455 | i0 | 82.7 | 10.1759465478842 | 127 | 22 | 84.9 | 0 | 3 | 383 | 11 | 137 | XP_013332946.1 ribosomal protein S23, putative [Eimeria maxima] | diamond | 4569 | 213 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 30282152 | 30282152 | PRJNA407886_P_NODE_81352_length_241_cov_0.916667_g79658_i0 | PRJNA407886 | 81352 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 71.2 | 4.85e-13 | NR | XP_011133207.1 | 110365 | g79658 | i0 | 50 | 2.43983402489627 | 64 | 32 | 79.7 | 0 | 215 | 24 | 1 | 64 | XP_011133207.1 proteasome subunit beta type [Gregarina niphandrodes] | diamond | 588 | 71.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 31624101 | 31624101 | PRJNA407886_P_NODE_84196_length_198_cov_6.736000_g82502_i0 | PRJNA407886 | 84196 | 198 | 6.736 | 13.33728 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 2e-7 | NR | UKK02333.1 | 68886 | g82502 | i0 | 55.6 | 0.681818181818182 | 45 | 20 | 68.2 | 0 | 196 | 62 | 162 | 206 | UKK02333.1 60S ribosomal protein L10 [Theileria orientalis] | diamond | 135 | 56.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 32210309 | 32210309 | PRJNA407886_P_NODE_51778_length_298_cov_1.368889_g50084_i0 | PRJNA407886 | 51778 | 298 | 1.368889 | 4.07928922 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 4.41e-16 | NR | XP_067068871.1 | 117008 | g50084 | i0 | 68.6 | 1.54026845637584 | 51 | 16 | 51.3 | 0 | 297 | 145 | 168 | 218 | XP_067068871.1 60s ribosomal protein L10A [Cryptosporidium andersoni] | diamond | 459 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 32495168 | 32495168 | PRJNA407886_P_NODE_47559_length_313_cov_1.837500_g45865_i0 | PRJNA407886 | 47559 | 313 | 1.8375 | 5.751375 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 2.5900000000000003e-27 | NR | UKJ88711.2 | 68886 | g45865 | i0 | 56.8 | 6.69009584664537 | 88 | 36 | 84.3 | 1 | 266 | 3 | 11 | 96 | UKJ88711.2 60S ribosomal protein L35a [Theileria orientalis] | diamond | 2094 | 106 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 32778608 | 32778608 | PRJNA407886_P_NODE_71920_length_249_cov_1.102273_g70226_i0 | PRJNA407886 | 71920 | 249 | 1.102273 | 2.74465977 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 7.890000000000001e-26 | NR | XP_628436.1 | 353152 | g70226 | i0 | 59.8 | 6.91566265060241 | 82 | 33 | 98.8 | 0 | 247 | 2 | 74 | 155 | XP_628436.1 s-adenosylmethionine synthetase (SAM) [Cryptosporidium parvum Iowa II] | diamond | 1722 | 108 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum |
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);;