contig_metadata
11 rows where bioproject = "PRJNA330616", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5493399 | 5493399 | PRJNA330616_P_NODE_4485_length_401_cov_3.366477_g4076_i0 | PRJNA330616 | 4485 | 401 | 3.366477 | 13.49957277 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 7.119999999999999e-109 | NTclustered | gi|134022092|gb|EF023442.1| | 404735 | g4076 | i0 | 85.539 | 66.8778054862843 | 408 | 37 | 99 | 15 | 2 | 401 | 422 | 29 | Eimeriidae environmental sample clone Amb_18S_1017 18S ribosomal RNA gene, partial sequence | blastn | 26818 | 407 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 20791382 | 20791382 | PRJNA330616_P_NODE_9157_length_274_cov_1.995556_g8748_i0 | PRJNA330616 | 9157 | 274 | 1.995556 | 5.46782344 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.04e-38 | NR | XP_029222174.1 | 94643 | g8748 | i0 | 73 | 2.94525547445255 | 89 | 24 | 97.4 | 0 | 274 | 8 | 63 | 151 | XP_029222174.1 ribosomal protein RPL26 [Besnoitia besnoiti] | diamond | 807 | 136 | 0.992647058823529 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 22746342 | 22746342 | PRJNA330616_P_NODE_32898_length_156_cov_2.831776_g32489_i0 | PRJNA330616 | 32898 | 156 | 2.831776 | 4.41757056 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.26e-17 | NTclustered | gi|1005651880|gb|KU244521.1| | 137009 | g32489 | i0 | 95.312 | 35.3461538461538 | 64 | 3 | 41 | 0 | 1 | 64 | 4248 | 4311 | Sarcocystis zamani voucher BJ no.1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 5514 | 102 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis zamani | ||
| 24615911 | 24615911 | PRJNA330616_P_NODE_30380_length_163_cov_0.894737_g29971_i0 | PRJNA330616 | 30380 | 163 | 0.894737 | 1.45842131 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 2.92e-4 | NTclustered | gi|916505692|ref|XM_013497926.1| | 44415 | g29971 | i0 | 100 | 5.68711656441718 | 31 | 0 | 19 | 0 | 2 | 32 | 197 | 227 | Eimeria mitis uncharacterized protein (EMH_0061420), partial mRNA | blastn | 927 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 28716877 | 28716877 | PRJNA330616_P_NODE_19647_length_190_cov_1.446809_g19238_i0 | PRJNA330616 | 19647 | 190 | 1.446809 | 2.7489371 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 6.35e-9 | NR | UVC54537.1 | 68886 | g19238 | i0 | 47.6 | 0.994736842105263 | 63 | 33 | 99.5 | 0 | 189 | 1 | 144 | 206 | UVC54537.1 60S ribosomal L1/L10a protein [Theileria orientalis] | diamond | 189 | 60.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 28828654 | 28828654 | PRJNA330616_P_NODE_28468_length_164_cov_1.773913_g28059_i0 | PRJNA330616 | 28468 | 164 | 1.773913 | 2.90921732 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 9.4e-9 | NR | GFE54039.1 | 5869 | g28059 | i0 | 61.2 | 7.42682926829268 | 49 | 19 | 89.6 | 0 | 148 | 2 | 5 | 53 | GFE54039.1 60S ribosomal protein L31 [Babesia ovis] | diamond | 1218 | 57.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 28906020 | 28906020 | PRJNA330616_P_NODE_31908_length_161_cov_0.910714_g31499_i0 | PRJNA330616 | 31908 | 161 | 0.910714 | 1.46624954 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 5.39e-7 | NR | XP_029221139.1 | 94643 | g31499 | i0 | 53.8 | 0.968944099378882 | 52 | 24 | 96.9 | 0 | 1 | 156 | 371 | 422 | XP_029221139.1 hypothetical protein BESB_035880 [Besnoitia besnoiti] | diamond | 156 | 55.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 30597309 | 30597309 | PRJNA330616_P_NODE_27373_length_165_cov_1.758621_g26964_i0 | PRJNA330616 | 27373 | 165 | 1.758621 | 2.90172465 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.04e-5 | NR | XP_013229778.1 | 5802 | g26964 | i0 | 59.1 | 2.38181818181818 | 44 | 18 | 80 | 0 | 2 | 133 | 56 | 99 | XP_013229778.1 ribosomal protein L41, putative [Eimeria tenella] | diamond | 393 | 49.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 31623180 | 31623180 | PRJNA330616_P_NODE_25756_length_167_cov_0.864407_g25347_i0 | PRJNA330616 | 25756 | 167 | 0.864407 | 1.44355969 | Babesia duncani | 323732 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 1.88e-8 | NR | XP_067805073.1 | 323732 | g25347 | i0 | 59.1 | 2.67664670658683 | 44 | 18 | 79 | 0 | 132 | 1 | 436 | 479 | XP_067805073.1 bifunctional Pumilio RNA-binding repeat/Armadillo-like helical/Pumilio [Babesia duncani] | diamond | 447 | 59.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 31861796 | 31861796 | PRJNA330616_P_NODE_28057_length_165_cov_0.879310_g27648_i0 | PRJNA330616 | 28057 | 165 | 0.87931 | 1.4508615 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.00728 | NR | SCO65374.1 | 5855 | g27648 | i0 | 56.4 | 7.89090909090909 | 39 | 13 | 63.6 | 2 | 111 | 7 | 1031 | 1069 | SCO65374.1 cysteine repeat modular protein 2, putative [Plasmodium vivax] | diamond | 1302 | 43.9 | 0.990888382687927 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 31939426 | 31939426 | PRJNA330616_P_NODE_9037_length_276_cov_1.559471_g8628_i0 | PRJNA330616 | 9037 | 276 | 1.559471 | 4.30413996 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 92 | 6.01e-20 | NR | XP_067922602.1 | 483139 | g8628 | i0 | 51.7 | 4.72826086956522 | 87 | 42 | 94.6 | 0 | 262 | 2 | 108 | 194 | XP_067922602.1 60s acidic ribosomal protein p0 [Cystoisospora suis] | diamond | 1305 | 92 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis |
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);;