contig_metadata
8 rows where bioproject = "PRJNA1240804", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1050431 | 1050431 | PRJNA1240804_P_NODE_95221_length_176_cov_1.661417_g94855_i0 | PRJNA1240804 | 95221 | 176 | 1.661417 | 2.92409392 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 1.83e-36 | NTclustered | gi|2294660140|gb|OP363691.1| | 90962 | g94855 | i0 | 91.129 | 70.7784090909091 | 124 | 8 | 69 | 2 | 4 | 125 | 512 | 390 | Cryptosporidium sp. isolate NJ3596 small subunit ribosomal RNA gene, partial sequence | blastn | 12457 | 165 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. | ||
| 4175169 | 4175169 | PRJNA1240804_P_NODE_32684_length_257_cov_1.432692_g32318_i0 | PRJNA1240804 | 32684 | 257 | 1.432692 | 3.68201844 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.98e-11 | NTclustered | gi|1039678902|gb|KX273387.1| | 88456 | g32318 | i0 | 94.444 | 19.1789883268482 | 54 | 2 | 21 | 1 | 192 | 245 | 4482 | 4430 | Cyclospora cayetanensis strain Texas-1 apicoplast, complete genome | blastn | 4929 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 8000927 | 8000927 | PRJNA1240804_P_NODE_151767_length_161_cov_2.544643_g151401_i0 | PRJNA1240804 | 151767 | 161 | 2.544643 | 4.09687523 | Hepatozoon canis | 110120 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 6.14e-11 | NTclustered | gi|1584069862|gb|MH615006.1| | 110120 | g151401 | i0 | 90.323 | 29.4596273291925 | 62 | 4 | 38 | 2 | 5 | 65 | 4982 | 4922 | Hepatozoon canis isolate 9992 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 4743 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Hepatozoidae | Hepatozoon | Hepatozoon canis | ||||
| 14377425 | 14377425 | PRJNA1240804_P_NODE_48432_length_221_cov_2.250000_g48066_i0 | PRJNA1240804 | 48432 | 221 | 2.25 | 4.9725 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 5.22e-33 | NTclustered | gi|160358922|gb|EU252544.1| | 88456 | g48066 | i0 | 83.237 | 19.683257918552 | 173 | 24 | 78 | 5 | 3 | 175 | 1674 | 1507 | Cyclospora cayetanensis 28S large subunit ribosomal RNA gene, partial sequence | blastn | 4350 | 154 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 20749476 | 20749476 | PRJNA1240804_P_NODE_2877_length_664_cov_40.482927_g2552_i0 | PRJNA1240804 | 2877 | 664 | 40.482927 | 268.80663528 | Babesia sp. | 35084 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 2.89e-45 | NTclustered | gi|2315087675|gb|OP604185.1| | 35084 | g2552 | i0 | 80.916 | 40.4126506024096 | 262 | 39 | 39 | 8 | 4 | 265 | 924 | 674 | Babesia sp. isolate T4-2021 small subunit ribosomal RNA gene, partial sequence | blastn | 26834 | 196 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia sp. | ||
| 24001944 | 24001944 | PRJNA1240804_P_NODE_119379_length_167_cov_0.881356_g119013_i0 | PRJNA1240804 | 119379 | 167 | 0.881356 | 1.47186452 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.014 | NTclustered | gi|820699808|tpe|LN714499.1| | 432359 | g119013 | i0 | 100 | 0.335329341317365 | 28 | 0 | 17 | 0 | 128 | 155 | 5379652 | 5379679 | TPA_asm: Toxoplasma gondii VEG, chromosome chrIX, complete genome | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 29631042 | 29631042 | PRJNA1240804_P_NODE_66590_length_197_cov_1.371622_g66224_i0 | PRJNA1240804 | 66590 | 197 | 1.371622 | 2.70209534 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.35e-24 | NR | XP_029215743.1 | 94643 | g66224 | i0 | 75 | 1.82741116751269 | 60 | 15 | 91.4 | 0 | 15 | 194 | 191 | 250 | XP_029215743.1 ribosomal protein RPS4 [Besnoitia besnoiti] | diamond | 360 | 102 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 30691886 | 30691886 | PRJNA1240804_P_NODE_128913_length_165_cov_1.784483_g128547_i0 | PRJNA1240804 | 128913 | 165 | 1.784483 | 2.94439695 | root | 1 | Root_unresolved | Root_unresolved | 59.3 | 1.8e-8 | NR | XP_013249558.1 | 5801 | g128547 | i0 | 61.5 | 3.50909090909091 | 39 | 15 | 70.9 | 0 | 48 | 164 | 23 | 61 | XP_013249558.1 5-aminolevulinic acid synthase, putative [Eimeria acervulina] | diamond | 579 | 59.7 | 0.993299832495812 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina |
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);;