contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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);;