contig_metadata
6 rows where bioproject = "PRJNA1196384" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322705 | 322705 | PRJNA1196384_S_NODE_4701_length_186_cov_2.073826_g4637_i0 | PRJNA1196384 | 4701 | 186 | 2.073826 | 3.85731636 | Porospora cf. gigantea B | 2853592 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.53e-35 | NTclustered | gi|2806422306|ref|XM_068520460.1| | 2853592 | g4637 | i0 | 82.796 | 4.45698924731183 | 186 | 26 | 98 | 6 | 2 | 184 | 300 | 118 | MAG: Porospora cf. gigantea B uncharacterized protein (KVP17_003324), partial mRNA | blastn | 829 | 161 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 5425880 | 5425880 | PRJNA1196384_S_NODE_4565_length_188_cov_1.781457_g4501_i0 | PRJNA1196384 | 4565 | 188 | 1.781457 | 3.34913916 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 2.82e-23 | NR | XP_067069864.1 | 117008 | g4501 | i0 | 66.1 | 0.98936170212766 | 62 | 21 | 98.9 | 0 | 186 | 1 | 21 | 82 | XP_067069864.1 60s ribosomal protein L13A [Cryptosporidium andersoni] | diamond | 186 | 97.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 19448778 | 19448778 | PRJNA1196384_S_NODE_6636_length_163_cov_1.857143_g6572_i0 | PRJNA1196384 | 6636 | 163 | 1.857143 | 3.02714309 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 1.75e-6 | NTclustered | gi|921119139|ref|XM_013578735.1| | 51315 | g6572 | i0 | 95.122 | 0.251533742331288 | 41 | 2 | 25 | 0 | 85 | 125 | 474 | 514 | Eimeria necatrix 60S ribosomal protein L10a, putative partial mRNA | blastn | 41 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 27830531 | 27830531 | PRJNA1196384_S_NODE_3424_length_212_cov_1.771429_g3360_i0 | PRJNA1196384 | 3424 | 212 | 1.771429 | 3.75542948 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 2.86e-6 | NR | CAL7859344.1 | 1344799 | g3360 | i0 | 45.3 | 0.905660377358491 | 64 | 28 | 90.6 | 1 | 6 | 197 | 995 | 1051 | CAL7859344.1 unnamed protein product [Sarcocystis calchasi] | diamond | 192 | 53.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 27944315 | 27944315 | PRJNA1196384_S_NODE_7365_length_157_cov_2.025000_g7301_i0 | PRJNA1196384 | 7365 | 157 | 2.025 | 3.17925 | root | 1 | Root_unresolved | Root_unresolved | 42 | 0.00567 | NR | XP_029220421.1 | 94643 | g7301 | i0 | 65.2 | 6.09554140127389 | 23 | 8 | 43.9 | 0 | 3 | 71 | 32 | 54 | XP_029220421.1 hypothetical protein BESB_046040 [Besnoitia besnoiti] | diamond | 957 | 42 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 32840854 | 32840854 | PRJNA1196384_S_NODE_5040_length_181_cov_2.687500_g4976_i0 | PRJNA1196384 | 5040 | 181 | 2.6875 | 4.864375 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 8.04e-12 | NR | SBT78878.1 | 36330 | g4976 | i0 | 56.4 | 1.8232044198895 | 55 | 23 | 91.2 | 1 | 181 | 17 | 130 | 183 | SBT78878.1 glutathione S-transferase, putative [Plasmodium ovale] | diamond | 330 | 67.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale |
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);;