contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA421571" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1698636 | 1698636 | PRJNA421571_P_NODE_69842_length_304_cov_1.333333_g67293_i0 | PRJNA421571 | 69842 | 304 | 1.333333 | 4.05333232 | Cryptosporidium meleagridis | 93969 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 2.61e-42 | NR | POM84985.1 | 93969 | g67293 | i0 | 75 | 43.7072368421053 | 100 | 25 | 98.7 | 0 | 1 | 300 | 93 | 192 | POM84985.1 ribosomal protein S4 [Cryptosporidium meleagridis] | diamond | 13287 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium meleagridis | ||
| 5527311 | 5527311 | PRJNA421571_P_NODE_63865_length_325_cov_1.222222_g61316_i0 | PRJNA421571 | 63865 | 325 | 1.222222 | 3.9722215 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 6.739999999999998e-42 | NR | KAF8821475.1 | 476202 | g61316 | i0 | 66.4 | 6.05538461538462 | 110 | 32 | 98.8 | 2 | 321 | 1 | 7 | 114 | KAF8821475.1 ribosomal protein RPS5 [Cardiosporidium cionae] | diamond | 1968 | 146 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 14453429 | 14453429 | PRJNA421571_P_NODE_99172_length_246_cov_0.890173_g96623_i0 | PRJNA421571 | 99172 | 246 | 0.890173 | 2.18982558 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 1.48e-16 | NR | KAF7458560.1 | 83540 | g96623 | i0 | 60.9 | 1.5609756097561 | 64 | 22 | 78 | 1 | 226 | 35 | 97 | 157 | KAF7458560.1 alkaline phosphatase family protein [Cryptosporidium felis] | diamond | 384 | 84 | 0.995238095238095 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis | ||
| 27455086 | 27455086 | PRJNA421571_P_NODE_58823_length_344_cov_1.704797_g56274_i0 | PRJNA421571 | 58823 | 344 | 1.704797 | 5.86450168 | Theileria annulata | 5874 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 0.0026 | NR | XP_953521.1 | 5874 | g56274 | i0 | 31.8 | 0.741279069767442 | 85 | 55 | 72.4 | 3 | 296 | 48 | 256 | 339 | XP_953521.1 phosphoinositide binding protein (SEC14 homologue), putative [Theileria annulata] | diamond | 255 | 47.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 27976585 | 27976585 | PRJNA421571_P_NODE_92085_length_251_cov_0.865169_g89536_i0 | PRJNA421571 | 92085 | 251 | 0.865169 | 2.17157419 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 1.19e-18 | NR | KAJ1611560.1 | 195482 | g89536 | i0 | 58.8 | 12.4302788844622 | 80 | 29 | 95.6 | 1 | 7 | 246 | 8 | 83 | KAJ1611560.1 hypothetical protein OJ253_827 [Cryptosporidium canis] | diamond | 3120 | 90.5 | 0.991160220994475 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium canis | ||
| 28528580 | 28528580 | PRJNA421571_P_NODE_59947_length_340_cov_1.153558_g57398_i0 | PRJNA421571 | 59947 | 340 | 1.153558 | 3.9220972 | Babesia bovis T2Bo | 484906 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 7.64e-22 | NR | XP_001609548.2 | 484906 | g57398 | i0 | 48.2 | 1.93235294117647 | 112 | 50 | 97.9 | 3 | 338 | 6 | 195 | 299 | XP_001609548.2 ATPase associated with various cellular activities (AAA) family protein [Babesia bovis T2Bo] | diamond | 657 | 99.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 29033835 | 29033835 | PRJNA421571_P_NODE_63968_length_324_cov_2.446215_g61419_i0 | PRJNA421571 | 63968 | 324 | 2.446215 | 7.9257366 | Neospora caninum Liverpool | 572307 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 7.420000000000001e-36 | NR | XP_003884403.1 | 572307 | g61419 | i0 | 57.3 | 4.72222222222222 | 103 | 44 | 95.4 | 0 | 16 | 324 | 11 | 113 | XP_003884403.1 hypothetical protein NCLIV_048030 [Neospora caninum Liverpool] | diamond | 1530 | 128 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 29033836 | 29033836 | PRJNA421571_P_NODE_64388_length_323_cov_1.232000_g61839_i0 | PRJNA421571 | 64388 | 323 | 1.232 | 3.97936 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 4.1700000000000006e-21 | NR | XP_012649673.1 | 1133968 | g61839 | i0 | 72.1 | 5.09907120743034 | 61 | 17 | 56.7 | 0 | 321 | 139 | 117 | 177 | XP_012649673.1 large subunit ribosomal protein L23Ae [Babesia microti strain RI] | diamond | 1647 | 92.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 29633085 | 29633085 | PRJNA421571_P_NODE_79630_length_278_cov_1.200000_g77081_i0 | PRJNA421571 | 79630 | 278 | 1.2 | 3.336 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 3.29e-10 | NR | CAL7859112.1 | 1344799 | g77081 | i0 | 64.7 | 1.10071942446043 | 51 | 18 | 55 | 0 | 276 | 124 | 55 | 105 | CAL7859112.1 unnamed protein product [Sarcocystis calchasi] | diamond | 306 | 62.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 30360501 | 30360501 | PRJNA421571_P_NODE_87012_length_261_cov_1.228723_g84463_i0 | PRJNA421571 | 87012 | 261 | 1.228723 | 3.20696703 | Theileria annulata | 5874 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 7e-35 | NR | XP_951968.1 | 5874 | g84463 | i0 | 72.4 | 7 | 87 | 24 | 100 | 0 | 261 | 1 | 51 | 137 | XP_951968.1 eukaryotic peptide chain release factor, putative [Theileria annulata] | diamond | 1827 | 133 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 30392054 | 30392054 | PRJNA421571_P_NODE_106553_length_241_cov_0.916667_g104004_i0 | PRJNA421571 | 106553 | 241 | 0.916667 | 2.20916747 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 4.18e-14 | NR | XP_013439721.1 | 51315 | g104004 | i0 | 49.4 | 1.96680497925311 | 79 | 37 | 98.3 | 2 | 238 | 2 | 196 | 271 | XP_013439721.1 CMGC kinase, MAPK family TgMAPK2, putative [Eimeria necatrix] | diamond | 474 | 76.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 30471533 | 30471533 | PRJNA421571_P_NODE_88093_length_258_cov_2.605405_g85544_i0 | PRJNA421571 | 88093 | 258 | 2.605405 | 6.7219448999999996 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 4.12e-29 | NR | XP_012768418.1 | 5866 | g85544 | i0 | 76.3 | 21.2093023255814 | 76 | 18 | 88.4 | 0 | 258 | 31 | 146 | 221 | XP_012768418.1 40S ribosomal protein S5, putative [Babesia bigemina] | diamond | 5472 | 114 | 0.991228070175439 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 30755803 | 30755803 | PRJNA421571_P_NODE_93414_length_250_cov_0.870056_g90865_i0 | PRJNA421571 | 93414 | 250 | 0.870056 | 2.17514 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 4.37e-13 | NR | XP_013335237.1 | 5804 | g90865 | i0 | 44.4 | 3.96 | 81 | 45 | 97.2 | 0 | 7 | 249 | 646 | 726 | XP_013335237.1 thrombospondin type 1 domain-containing protein, putative [Eimeria maxima] | diamond | 990 | 73.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 30770917 | 30770917 | PRJNA421571_P_NODE_71194_length_300_cov_1.233480_g68645_i0 | PRJNA421571 | 71194 | 300 | 1.23348 | 3.70044 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 9.1e-4 | NR | KAF8822001.1 | 476202 | g68645 | i0 | 36.7 | 0.9 | 90 | 48 | 82 | 3 | 5 | 250 | 552 | 640 | KAF8822001.1 Ras family protein [Cardiosporidium cionae] | diamond | 270 | 48.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 31482955 | 31482955 | PRJNA421571_P_NODE_70896_length_301_cov_1.013158_g68347_i0 | PRJNA421571 | 70896 | 301 | 1.013158 | 3.04960558 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 5.23e-41 | NR | XP_067921576.1 | 483139 | g68347 | i0 | 73.7 | 1.9734219269103 | 99 | 26 | 98.7 | 0 | 3 | 299 | 221 | 319 | XP_067921576.1 cystathione gamma lyase [Cystoisospora suis] | diamond | 594 | 150 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 31577685 | 31577685 | PRJNA421571_P_NODE_80736_length_275_cov_1.470297_g78187_i0 | PRJNA421571 | 80736 | 275 | 1.470297 | 4.04331675 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 7.810000000000001e-27 | NR | OEH75806.1 | 88456 | g78187 | i0 | 65.4 | 2.67272727272727 | 81 | 28 | 88.4 | 0 | 265 | 23 | 135 | 215 | OEH75806.1 hit domain-containing protein [Cyclospora cayetanensis] | diamond | 735 | 107 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis |
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);;