contig_metadata
6 rows where bioproject = "PRJNA1136505", tax_phylum = "Apicomplexa" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9212503 | 9212503 | PRJNA1136505_P_NODE_156768_length_237_cov_2.304878_g149908_i0 | PRJNA1136505 | 156768 | 237 | 2.304878 | 5.46256086 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.53e-5 | NTclustered | gi|914997060|ref|XM_013391675.1| | 5801 | g149908 | i0 | 100 | 1.78481012658228 | 33 | 0 | 14 | 0 | 1 | 33 | 2366 | 2334 | Eimeria acervulina ImpB/MucB/SamB family domain-containing protein, putative partial mRNA | blastn | 423 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 10488067 | 10488067 | PRJNA1136505_P_NODE_50889_length_437_cov_1.903846_g44030_i0 | PRJNA1136505 | 50889 | 437 | 1.903846 | 8.31980702 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 6.77e-30 | NTclustered | gi|820692312|tpe|LN714484.1| | 572307 | g44030 | i0 | 85.926 | 6.70022883295194 | 135 | 19 | 31 | 0 | 300 | 434 | 2002162 | 2002028 | TPA_asm: Neospora caninum Liverpool, chromosome chrIX, complete genome | blastn | 2928 | 145 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 21961285 | 21961285 | PRJNA1136505_P_NODE_39958_length_532_cov_3.886710_g33116_i0 | PRJNA1136505 | 39958 | 532 | 3.88671 | 20.6772972 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 1.57e-126 | NTclustered | gi|166083980|gb|EF024503.1| | 404735 | g33116 | i0 | 82.9 | 101.323308270677 | 538 | 72 | 100 | 18 | 1 | 532 | 560 | 37 | Eimeriidae environmental sample clone Elev_18S_807 18S ribosomal RNA gene, partial sequence | blastn | 53904 | 466 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 27828497 | 27828497 | PRJNA1136505_P_NODE_23284_length_943_cov_5.862069_g16993_i0 | PRJNA1136505 | 23284 | 943 | 5.862069 | 55.27931067 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 282 | 6.22e-92 | NR | XP_029221002.1 | 94643 | g16993 | i0 | 66.4 | 27.8748674443266 | 217 | 72 | 69 | 1 | 901 | 251 | 1 | 216 | XP_029221002.1 ribosomal protein RPL10A [Besnoitia besnoiti] | diamond | 26286 | 282 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 29806599 | 29806599 | PRJNA1136505_P_NODE_93631_length_299_cov_1.004425_g86771_i0 | PRJNA1136505 | 93631 | 299 | 1.004425 | 3.00323075 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.2699999999999998e-31 | NR | CDJ45709.1 | 51314 | g86771 | i0 | 56 | 6.06020066889632 | 100 | 41 | 97.3 | 1 | 293 | 3 | 59 | 158 | CDJ45709.1 hypothetical protein EBH_0061260 [Eimeria brunetti] | diamond | 1812 | 119 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti | ||
| 30291943 | 30291943 | PRJNA1136505_P_NODE_53092_length_424_cov_1.233618_g46233_i0 | PRJNA1136505 | 53092 | 424 | 1.233618 | 5.23054032 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 1.14e-53 | NR | XP_029215426.1 | 94643 | g46233 | i0 | 69.9 | 1.77594339622642 | 123 | 36 | 86.3 | 1 | 369 | 4 | 5 | 127 | XP_029215426.1 putative phosphate carrier [Besnoitia besnoiti] | diamond | 753 | 182 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti |
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);;