contig_metadata
11 rows where bioproject = "PRJNA1108009", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4039540 | 4039540 | PRJNA1108009_P_NODE_14104_length_351_cov_2.071942_g13786_i0 | PRJNA1108009 | 14104 | 351 | 2.071942 | 7.27251642 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.8499999999999999e-54 | NTclustered | gi|1624692895|ref|XM_029011319.1| | 189622 | g13786 | i0 | 90.286 | 52.1880341880342 | 175 | 14 | 49 | 2 | 23 | 194 | 422 | 596 | Babesia ovata heat shock 70 (BOVATA_024020), partial mRNA | blastn | 18318 | 226 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 10416610 | 10416610 | PRJNA1108009_P_NODE_30749_length_242_cov_0.911243_g30431_i0 | PRJNA1108009 | 30749 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 5.71e-40 | NR | XP_012766454.1 | 5866 | g30431 | i0 | 88.8 | 29.7520661157025 | 80 | 9 | 99.2 | 0 | 2 | 241 | 182 | 261 | XP_012766454.1 hypothetical protein BBBOND_0105770 [Babesia bigemina] | diamond | 7200 | 151 | 0.993377483443709 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 16790088 | 16790088 | PRJNA1108009_P_NODE_21714_length_274_cov_1.238806_g21396_i0 | PRJNA1108009 | 21714 | 274 | 1.238806 | 3.39432844 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 2.2e-40 | NR | XP_664964.1 | 353151 | g21396 | i0 | 76.7 | 20.6277372262774 | 90 | 21 | 98.5 | 0 | 3 | 272 | 3 | 92 | XP_664964.1 hypothetical protein, partial [Cryptosporidium hominis TU502] | diamond | 5652 | 147 | 0.993197278911565 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 16790242 | 16790242 | PRJNA1108009_P_NODE_27674_length_247_cov_0.885057_g27356_i0 | PRJNA1108009 | 27674 | 247 | 0.885057 | 2.18609079 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 8.53e-32 | NR | CAL7857573.1 | 1344799 | g27356 | i0 | 67.9 | 1.96761133603239 | 81 | 26 | 98.4 | 0 | 4 | 246 | 5 | 85 | CAL7857573.1 unnamed protein product [Sarcocystis calchasi] | diamond | 486 | 118 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 26624483 | 26624483 | PRJNA1108009_P_NODE_10021_length_428_cov_1.078873_g9703_i0 | PRJNA1108009 | 10021 | 428 | 1.078873 | 4.61757644 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 6.02e-19 | NR | XP_028865997.1 | 189622 | g9703 | i0 | 36.9 | 2.0607476635514 | 149 | 78 | 94.6 | 3 | 425 | 21 | 12 | 158 | XP_028865997.1 translationally-controlled tumor protein [Babesia ovata] | diamond | 882 | 88.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 28638230 | 28638230 | PRJNA1108009_P_NODE_29667_length_244_cov_0.900585_g29349_i0 | PRJNA1108009 | 29667 | 244 | 0.900585 | 2.1974274 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 2.9e-18 | NR | XP_067920867.1 | 483139 | g29349 | i0 | 71.7 | 9.50409836065574 | 60 | 16 | 72.5 | 1 | 241 | 65 | 114 | 173 | XP_067920867.1 centrin 2 [Cystoisospora suis] | diamond | 2319 | 84.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 29206581 | 29206581 | PRJNA1108009_P_NODE_14229_length_350_cov_1.108303_g13911_i0 | PRJNA1108009 | 14229 | 350 | 1.108303 | 3.8790605 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.59e-33 | NR | GFE54039.1 | 5869 | g13911 | i0 | 58.7 | 8.42571428571429 | 109 | 44 | 92.6 | 1 | 337 | 14 | 5 | 113 | GFE54039.1 60S ribosomal protein L31 [Babesia ovis] | diamond | 2949 | 122 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 29846613 | 29846613 | PRJNA1108009_P_NODE_6591_length_540_cov_3.156317_g6278_i0 | PRJNA1108009 | 6591 | 540 | 3.156317 | 17.0441118 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 1.17e-62 | NR | OEH76901.1 | 88456 | g6278 | i0 | 62.1 | 4.78888888888889 | 177 | 67 | 98.3 | 0 | 537 | 7 | 29 | 205 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2586 | 202 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 29901161 | 29901161 | PRJNA1108009_P_NODE_18531_length_301_cov_1.333333_g18213_i0 | PRJNA1108009 | 18531 | 301 | 1.333333 | 4.01333233 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 8.789999999999998e-30 | NR | GFE54039.1 | 5869 | g18213 | i0 | 57 | 15.936877076412 | 100 | 42 | 98.7 | 1 | 2 | 298 | 8 | 107 | GFE54039.1 60S ribosomal protein L31 [Babesia ovis] | diamond | 4797 | 112 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 31828800 | 31828800 | PRJNA1108009_P_NODE_29797_length_244_cov_0.900585_g29479_i0 | PRJNA1108009 | 29797 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 115 | 7.22e-28 | NR | OLQ16690.1 | 237895 | g29479 | i0 | 64.9 | 6.5655737704918 | 77 | 27 | 94.7 | 0 | 238 | 8 | 37 | 113 | OLQ16690.1 tRNA synthetases class I (I L M and V) [Cryptosporidium hominis] | diamond | 1602 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 32840026 | 32840026 | PRJNA1108009_P_NODE_13320_length_363_cov_1.855172_g13002_i0 | PRJNA1108009 | 13320 | 363 | 1.855172 | 6.73427436 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 4.5599999999999996e-46 | NR | AFJ45055.1 | 5874 | g13002 | i0 | 63.3 | 17.5289256198347 | 120 | 43 | 99.2 | 1 | 361 | 2 | 2 | 120 | AFJ45055.1 ribosomal protein S8, partial [Theileria annulata] | diamond | 6363 | 157 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata |
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);;