contig_metadata
9 rows where bioproject = "PRJNA1068830" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16760749 | 16760749 | PRJNA1068830_P_NODE_85134_length_244_cov_0.912281_g84431_i0 | PRJNA1068830 | 85134 | 244 | 0.912281 | 2.22596564 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916497934|ref|XM_013494333.1| | 44415 | g84431 | i0 | 83.607 | 0.25 | 61 | 8 | 25 | 2 | 33 | 92 | 1362 | 1421 | Eimeria mitis CW-type zinc finger domain-containing protein, related (EMH_0083020), partial mRNA | blastn | 61 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 20583851 | 20583851 | PRJNA1068830_P_NODE_41697_length_343_cov_3.177778_g40994_i0 | PRJNA1068830 | 41697 | 343 | 3.177778 | 10.89977854 | Cryptosporidium ubiquitum | 857276 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 7.259999999999999e-31 | NR | XP_028876282.1 | 857276 | g40994 | i0 | 57.6 | 3.52478134110787 | 99 | 42 | 86.6 | 0 | 34 | 330 | 3 | 101 | XP_028876282.1 histone H4 [Cryptosporidium ubiquitum] | diamond | 1209 | 117 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ubiquitum | ||
| 21859678 | 21859678 | PRJNA1068830_P_NODE_47198_length_320_cov_1.153846_g46495_i0 | PRJNA1068830 | 47198 | 320 | 1.153846 | 3.6923072 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.03 | NTclustered | gi|1620951189|ref|XM_028687656.1| | 77519 | g46495 | i0 | 100 | 0.0875 | 28 | 0 | 9 | 0 | 195 | 222 | 1240 | 1267 | Plasmodium gonderi hypothetical protein, conserved (PGO_090660), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 21860223 | 21860223 | PRJNA1068830_P_NODE_68878_length_260_cov_1.352941_g68175_i0 | PRJNA1068830 | 68878 | 260 | 1.352941 | 3.5176466 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916416283|ref|XM_013373919.1| | 5802 | g68175 | i0 | 100 | 0.330769230769231 | 30 | 0 | 12 | 0 | 219 | 248 | 594 | 623 | Eimeria tenella uncharacterized protein (ETH_00000385), partial mRNA | blastn | 86 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 22690928 | 22690928 | PRJNA1068830_P_NODE_20878_length_521_cov_1.741071_g20177_i0 | PRJNA1068830 | 20878 | 521 | 1.741071 | 9.07097991 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|2785758627|ref|XM_067219803.1| | 5824 | g20177 | i0 | 97.059 | 0.130518234165067 | 34 | 1 | 7 | 0 | 301 | 334 | 1146 | 1113 | Plasmodium brasilianum tyrosine kinase-like protein (MKS88_001144), partial mRNA | blastn | 68 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 27415271 | 27415271 | PRJNA1068830_P_NODE_73863_length_252_cov_0.871508_g73160_i0 | PRJNA1068830 | 73863 | 252 | 0.871508 | 2.19620016 | Babesia ovis | 5869 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00368 | NR | GFE52946.1 | 5869 | g73160 | i0 | 41.2 | 0.80952380952381 | 68 | 40 | 81 | 0 | 247 | 44 | 36 | 103 | GFE52946.1 SNF7 family protein [Babesia ovis] | diamond | 204 | 45.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 30098813 | 30098813 | PRJNA1068830_P_NODE_9912_length_804_cov_2.265390_g9274_i0 | PRJNA1068830 | 9912 | 804 | 2.26539 | 18.2137356 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 7.4e-9 | NR | XP_028865435.1 | 189622 | g9274 | i0 | 44.8 | 1.00746268656716 | 67 | 36 | 24.6 | 1 | 455 | 258 | 2 | 68 | XP_028865435.1 PP-loop family protein [Babesia ovata] | diamond | 810 | 67.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 32398570 | 32398570 | PRJNA1068830_P_NODE_28739_length_428_cov_1.752113_g28036_i0 | PRJNA1068830 | 28739 | 428 | 1.752113 | 7.49904364 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 186 | 6.22e-57 | NR | KAK1441808.1 | 33632 | g28036 | i0 | 58.5 | 7.93457943925234 | 142 | 59 | 99.5 | 0 | 427 | 2 | 3 | 144 | KAK1441808.1 ribosomal protein L22/L17 like protein [Babesia gibsoni] | diamond | 3396 | 187 | 0.994652406417112 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia gibsoni | ||
| 32722594 | 32722594 | PRJNA1068830_P_NODE_82900_length_246_cov_0.901734_g82197_i0 | PRJNA1068830 | 82900 | 246 | 0.901734 | 2.21826564 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 3.63e-11 | NR | XP_013250213.1 | 5801 | g82197 | i0 | 46.8 | 13.6219512195122 | 79 | 41 | 96.3 | 1 | 8 | 244 | 93 | 170 | XP_013250213.1 heterogeneous nuclear ribonucleoprotein A3, putative [Eimeria acervulina] | diamond | 3351 | 68.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina |
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);;