contig_metadata
5 rows where bioproject = "PRJDB4941" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10213208 | 10213208 | PRJDB4941_P_NODE_29469_length_184_cov_1.037037_g28701_i0 | PRJDB4941 | 29469 | 184 | 1.037037 | 1.90814808 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|1027955494|ref|XM_016798297.1| | 31271 | g28701 | i0 | 92.105 | 0.206521739130435 | 38 | 3 | 21 | 0 | 19 | 56 | 4955 | 4918 | Plasmodium chabaudi chabaudi glutamate synthase [NADH], putative (PCHAS_1010400), partial mRNA | blastn | 38 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 14038405 | 14038405 | PRJDB4941_P_NODE_27092_length_192_cov_2.013986_g26324_i0 | PRJDB4941 | 27092 | 192 | 2.013986 | 3.86685312 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 3.55e-4 | NTclustered | gi|916510972|ref|XM_013500255.1| | 44415 | g26324 | i0 | 94.595 | 5.59375 | 37 | 2 | 19 | 0 | 93 | 129 | 261 | 225 | Eimeria mitis uncharacterized protein (EMH_0080490), partial mRNA | blastn | 1074 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 19135611 | 19135611 | PRJDB4941_P_NODE_14396_length_282_cov_1.364807_g13628_i0 | PRJDB4941 | 14396 | 282 | 1.364807 | 3.84875574 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|1620956679|ref|XM_028690398.1| | 77519 | g13628 | i0 | 100 | 0.102836879432624 | 29 | 0 | 10 | 0 | 236 | 264 | 2833 | 2861 | Plasmodium gonderi phospholipid-transporting ATPase (PGO_144080), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 24236077 | 24236077 | PRJDB4941_P_NODE_20200_length_227_cov_2.820225_g19432_i0 | PRJDB4941 | 20200 | 227 | 2.820225 | 6.40191075 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.02 | NTclustered | gi|156094807|ref|XM_001613390.1| | 5855 | g19432 | i0 | 100 | 0.123348017621145 | 28 | 0 | 12 | 0 | 194 | 221 | 543 | 516 | Plasmodium vivax AAA family ATPase, putative (PVX_087895), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 31833941 | 31833941 | PRJDB4941_P_NODE_21897_length_217_cov_1.238095_g21129_i0 | PRJDB4941 | 21897 | 217 | 1.238095 | 2.68666615 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 3.43e-4 | NR | XP_067183668.1 | 310047 | g21129 | i0 | 29.3 | 1.036866359447 | 75 | 50 | 99.5 | 1 | 216 | 1 | 1038 | 1112 | XP_067183668.1 uncharacterized protein FG379_002260 [Cryptosporidium bovis] | diamond | 225 | 48.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis |
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);;