contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA195897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9294056 | 9294056 | PRJNA195897_P_NODE_2688_length_303_cov_1.216535_g2655_i0 | PRJNA195897 | 2688 | 303 | 1.216535 | 3.68610105 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.7399999999999997e-35 | NR | AZL94188.1 | 476202 | g2655 | i0 | 74.2 | 0.920792079207921 | 93 | 24 | 92.1 | 0 | 281 | 3 | 7 | 99 | AZL94188.1 iron ABC transporter substrate-binding protein [Cardiosporidium cionae] | diamond | 279 | 134 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 11258517 | 11258517 | PRJNA195897_P_NODE_6449_length_194_cov_1.434483_g6416_i0 | PRJNA195897 | 6449 | 194 | 1.434483 | 2.78289702 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 1.47e-26 | NR | CAL7857665.1 | 1344799 | g6416 | i0 | 81.3 | 0.989690721649485 | 64 | 12 | 99 | 0 | 194 | 3 | 1759 | 1822 | CAL7857665.1 unnamed protein product [Sarcocystis calchasi] | diamond | 192 | 111 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 13119724 | 13119724 | PRJNA195897_P_NODE_10771_length_165_cov_1.370690_g10738_i0 | PRJNA195897 | 10771 | 165 | 1.37069 | 2.2616385 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 1e-21 | NR | XP_013437626.1 | 51315 | g10738 | i0 | 89.1 | 13.6545454545455 | 46 | 5 | 83.6 | 0 | 138 | 1 | 1 | 46 | XP_013437626.1 ribosomal protein L15, putative [Eimeria necatrix] | diamond | 2253 | 92.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 28053000 | 28053000 | PRJNA195897_P_NODE_3565_length_256_cov_1.492754_g3532_i0 | PRJNA195897 | 3565 | 256 | 1.492754 | 3.82145024 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 4.86e-4 | NR | XP_067069719.1 | 117008 | g3532 | i0 | 32.8 | 1.46484375 | 61 | 41 | 71.5 | 0 | 187 | 5 | 23 | 83 | XP_067069719.1 centrin [Cryptosporidium andersoni] | diamond | 375 | 47.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 29599952 | 29599952 | PRJNA195897_P_NODE_4010_length_239_cov_1.621053_g3977_i0 | PRJNA195897 | 4010 | 239 | 1.621053 | 3.87431667 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 3.34e-17 | NR | XP_018635543.1 | 508771 | g3977 | i0 | 58.8 | 2.57322175732218 | 68 | 27 | 84.1 | 1 | 39 | 239 | 83 | 150 | XP_018635543.1 vacuolar atp synthase subunit f, putative [Toxoplasma gondii ME49] | diamond | 615 | 82 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 29617635 | 29617635 | PRJNA195897_P_NODE_2050_length_356_cov_5.013029_g2017_i0 | PRJNA195897 | 2050 | 356 | 5.013029 | 17.84638324 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 5.3000000000000005e-34 | NR | XP_013336974.1 | 5804 | g2017 | i0 | 61.8 | 4.38202247191011 | 102 | 39 | 86 | 0 | 2 | 307 | 72 | 173 | XP_013336974.1 60S ribosomal protein L31, putative [Eimeria maxima] | diamond | 1560 | 127 | 0.992125984251969 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 29662981 | 29662981 | PRJNA195897_P_NODE_6990_length_188_cov_1.122302_g6957_i0 | PRJNA195897 | 6990 | 188 | 1.122302 | 2.10992776 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 1.09e-9 | NR | KAF8822356.1 | 476202 | g6957 | i0 | 41.7 | 0.957446808510638 | 60 | 35 | 95.7 | 0 | 187 | 8 | 364 | 423 | KAF8822356.1 PCI domain-containing protein [Cardiosporidium cionae] | diamond | 180 | 63.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 30168540 | 30168540 | PRJNA195897_P_NODE_1612_length_412_cov_2.606061_g1579_i0 | PRJNA195897 | 1612 | 412 | 2.606061 | 10.73697132 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 181 | 9.809999999999997e-55 | NR | OEH76901.1 | 88456 | g1579 | i0 | 68.4 | 10.8932038834951 | 136 | 43 | 99 | 0 | 5 | 412 | 29 | 164 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 4488 | 181 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 30249954 | 30249954 | PRJNA195897_P_NODE_4952_length_216_cov_1.532934_g4919_i0 | PRJNA195897 | 4952 | 216 | 1.532934 | 3.31113744 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 2.78e-26 | NR | XP_951996.1 | 5874 | g4919 | i0 | 69 | 88.6805555555556 | 71 | 22 | 98.6 | 0 | 215 | 3 | 35 | 105 | XP_951996.1 60S ribosomal protein L17, putative [Theileria annulata] | diamond | 19155 | 105 | 0.990476190476191 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 30421860 | 30421860 | PRJNA195897_P_NODE_10413_length_166_cov_0.888889_g10380_i0 | PRJNA195897 | 10413 | 166 | 0.888889 | 1.47555574 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 1.34e-20 | NR | XP_067813325.1 | 2853593 | g10380 | i0 | 75.9 | 4.87951807228916 | 54 | 13 | 97.6 | 0 | 3 | 164 | 67 | 120 | XP_067813325.1 MAG: uncharacterized protein KVP18_001601 [Porospora cf. gigantea A] | diamond | 810 | 92.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A | ||
| 31306201 | 31306201 | PRJNA195897_P_NODE_5975_length_200_cov_1.377483_g5942_i0 | PRJNA195897 | 5975 | 200 | 1.377483 | 2.754966 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 2.67e-7 | NR | OEH77931.1 | 88456 | g5942 | i0 | 53.3 | 2.7 | 60 | 25 | 90 | 1 | 16 | 195 | 363 | 419 | OEH77931.1 VID27-domain-containing protein [Cyclospora cayetanensis] | diamond | 540 | 56.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 31432746 | 31432746 | PRJNA195897_P_NODE_4796_length_219_cov_1.223529_g4763_i0 | PRJNA195897 | 4796 | 219 | 1.223529 | 2.67952851 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 2.1e-5 | NR | XP_021337412.1 | 1133968 | g4763 | i0 | 45.1 | 0.698630136986301 | 51 | 28 | 69.9 | 0 | 1 | 153 | 115 | 165 | XP_021337412.1 Tetratricopeptide repeat protein 1 [Babesia microti strain RI] | diamond | 153 | 51.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 31893381 | 31893381 | PRJNA195897_P_NODE_9077_length_169_cov_0.866667_g9044_i0 | PRJNA195897 | 9077 | 169 | 0.866667 | 1.46466723 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 3.12e-12 | NR | XP_029215696.1 | 94643 | g9044 | i0 | 62 | 5.16568047337278 | 50 | 19 | 88.8 | 0 | 4 | 153 | 352 | 401 | XP_029215696.1 putative sulfite oxidase [Besnoitia besnoiti] | diamond | 873 | 70.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 31988262 | 31988262 | PRJNA195897_P_NODE_1678_length_400_cov_3.199430_g1645_i0 | PRJNA195897 | 1678 | 400 | 3.19943 | 12.79772 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 3.46e-33 | NR | GFE54039.1 | 5869 | g1645 | i0 | 58.7 | 7.3725 | 109 | 44 | 81 | 1 | 387 | 64 | 5 | 113 | GFE54039.1 60S ribosomal protein L31 [Babesia ovis] | diamond | 2949 | 123 | 0.991869918699187 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis |
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);;