contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5896922 | 5896922 | PRJNA799842_P_NODE_132585_length_253_cov_1.283333_g131012_i0 | PRJNA799842 | 132585 | 253 | 1.283333 | 3.24683249 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 96.7 | 2.7500000000000003e-21 | NR | XP_013332951.1 | 5804 | g131012 | i0 | 61.6 | 0.865612648221344 | 73 | 25 | 83 | 1 | 43 | 252 | 166 | 238 | XP_013332951.1 thioredoxin, putative [Eimeria maxima] | diamond | 219 | 96.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 9721648 | 9721648 | PRJNA799842_P_NODE_144728_length_249_cov_1.312500_g143155_i0 | PRJNA799842 | 144728 | 249 | 1.3125 | 3.268125 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 6.6e-42 | NR | KAF8820306.1 | 476202 | g143155 | i0 | 82.9 | 2.96385542168675 | 82 | 14 | 98.8 | 0 | 2 | 247 | 10 | 91 | KAF8820306.1 putative small GTPase Rab2 [Cardiosporidium cionae] | diamond | 738 | 145 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 26873460 | 26873460 | PRJNA799842_P_NODE_106161_length_284_cov_0.815166_g104588_i0 | PRJNA799842 | 106161 | 284 | 0.815166 | 2.31507144 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00349 | NR | GFE53071.1 | 5869 | g104588 | i0 | 37 | 1.64788732394366 | 73 | 39 | 77.1 | 2 | 229 | 11 | 284 | 349 | GFE53071.1 PP-loop family protein [Babesia ovis] | diamond | 468 | 46.6 | 0.991416309012876 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 28443820 | 28443820 | PRJNA799842_P_NODE_31326_length_518_cov_1.622472_g29762_i0 | PRJNA799842 | 31326 | 518 | 1.622472 | 8.40440496 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 4.27e-7 | NR | XP_029216214.1 | 94643 | g29762 | i0 | 25.3 | 1.05405405405405 | 182 | 117 | 97.3 | 5 | 504 | 1 | 311 | 487 | XP_029216214.1 LETM1 family protein [Besnoitia besnoiti] | diamond | 546 | 60.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 28790757 | 28790757 | PRJNA799842_P_NODE_114267_length_274_cov_1.174129_g112694_i0 | PRJNA799842 | 114267 | 274 | 1.174129 | 3.21711346 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.46e-33 | NR | CAL7860658.1 | 1344799 | g112694 | i0 | 71.8 | 1.86131386861314 | 85 | 24 | 93.1 | 0 | 267 | 13 | 31 | 115 | CAL7860658.1 unnamed protein product [Sarcocystis calchasi] | diamond | 510 | 122 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 29169956 | 29169956 | PRJNA799842_P_NODE_122909_length_264_cov_1.209424_g121336_i0 | PRJNA799842 | 122909 | 264 | 1.209424 | 3.19287936 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 2.15e-8 | NR | CAL7857401.1 | 1344799 | g121336 | i0 | 52.9 | 0.579545454545455 | 51 | 20 | 58 | 1 | 1 | 153 | 1628 | 1674 | CAL7857401.1 unnamed protein product [Sarcocystis calchasi] | diamond | 153 | 60.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 29233146 | 29233146 | PRJNA799842_P_NODE_58929_length_370_cov_2.558923_g57356_i0 | PRJNA799842 | 58929 | 370 | 2.558923 | 9.4680151 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 4.59e-9 | NR | XP_002368527.1 | 508771 | g57356 | i0 | 61.8 | 1.67027027027027 | 55 | 18 | 42.2 | 1 | 6 | 161 | 5 | 59 | XP_002368527.1 ribosomal protein RPS30 [Toxoplasma gondii ME49] | diamond | 618 | 59.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 30527888 | 30527888 | PRJNA799842_P_NODE_171753_length_244_cov_0.900585_g170180_i0 | PRJNA799842 | 171753 | 244 | 0.900585 | 2.1974274 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 2.62e-39 | NR | XP_029215426.1 | 94643 | g170180 | i0 | 80 | 0.983606557377049 | 80 | 16 | 98.4 | 0 | 3 | 242 | 20 | 99 | XP_029215426.1 putative phosphate carrier [Besnoitia besnoiti] | diamond | 240 | 142 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 32330611 | 32330611 | PRJNA799842_P_NODE_141099_length_250_cov_0.870056_g139526_i0 | PRJNA799842 | 141099 | 250 | 0.870056 | 2.17514 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 71.2 | 3.71e-12 | NR | KAF8819511.1 | 476202 | g139526 | i0 | 56.5 | 0.744 | 62 | 27 | 74.4 | 0 | 1 | 186 | 544 | 605 | KAF8819511.1 putative Dna-directed Rna polymerase, partial [Cardiosporidium cionae] | diamond | 186 | 71.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae |
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);;