contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6747593 | 6747593 | PRJNA270367_P_NODE_15246_length_326_cov_1.765343_g15041_i0 | PRJNA270367 | 15246 | 326 | 1.765343 | 5.75501818 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 7.94e-53 | NTclustered | gi|401402052|ref|XM_003881109.1| | 572307 | g15041 | i0 | 80.887 | 76.0858895705521 | 293 | 45 | 87 | 6 | 44 | 326 | 384 | 93 | Neospora caninum Liverpool putative ubiquitin / ribosomal protein CEP52 fusion protein (NCLIV_042000), partial mRNA | blastn | 24804 | 220 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 6747793 | 6747793 | PRJNA270367_P_NODE_35826_length_181_cov_1.174242_g35621_i0 | PRJNA270367 | 35826 | 181 | 1.174242 | 2.12537802 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.001 | NTclustered | gi|915126392|ref|XM_013478856.1| | 5804 | g35621 | i0 | 89.362 | 0.734806629834254 | 47 | 2 | 26 | 1 | 70 | 116 | 1234 | 1191 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 133 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 6747814 | 6747814 | PRJNA270367_P_NODE_38786_length_171_cov_0.868852_g38581_i0 | PRJNA270367 | 38786 | 171 | 0.868852 | 1.48573692 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 6.62e-6 | NTclustered | gi|1620151015|ref|XM_028678899.1| | 85471 | g38581 | i0 | 86.207 | 0.748538011695906 | 58 | 8 | 34 | 0 | 2 | 59 | 142 | 199 | Plasmodium relictum serine/threonine protein phosphatase PP1, putative (PP1), partial mRNA | blastn | 128 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 9297870 | 9297870 | PRJNA270367_P_NODE_10308_length_414_cov_1.742466_g10106_i0 | PRJNA270367 | 10308 | 414 | 1.742466 | 7.21380924 | Cryptosporidium hominis | 237895 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 6.03e-70 | NTclustered | gi|67601419|ref|XM_661304.1| | 353151 | g10106 | i0 | 79.419 | 82.1570048309179 | 413 | 69 | 98 | 13 | 8 | 412 | 1077 | 673 | Cryptosporidium hominis TU502 elongation factor 1-alpha (EF-1-ALPHA) (Chro.60459) partial mRNA | blastn | 34013 | 278 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 18221790 | 18221790 | PRJNA270367_P_NODE_37635_length_174_cov_2.056000_g37430_i0 | PRJNA270367 | 37635 | 174 | 2.056 | 3.57744 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.4e-15 | NTclustered | gi|820693004|tpe|LN714485.1| | 572307 | g37430 | i0 | 86.364 | 1.45402298850575 | 88 | 10 | 50 | 2 | 52 | 138 | 854667 | 854581 | TPA_asm: Neospora caninum Liverpool, chromosome chrX, complete genome | blastn | 253 | 95.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 19495828 | 19495828 | PRJNA270367_P_NODE_14316_length_340_cov_1.862543_g14111_i0 | PRJNA270367 | 14316 | 340 | 1.862543 | 6.3326462 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915008004|ref|XM_013395022.1| | 5801 | g14111 | i0 | 100 | 0.0882352941176471 | 30 | 0 | 9 | 0 | 252 | 281 | 1019 | 990 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 19496151 | 19496151 | PRJNA270367_P_NODE_4636_length_636_cov_2.219761_g4447_i0 | PRJNA270367 | 4636 | 636 | 2.219761 | 14.11767996 | Plasmodium knowlesi | 5850 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 3.78e-4 | NTclustered | gi|1976646724|ref|XM_002259993.2| | 5851 | g4447 | i0 | 100 | 0.050314465408805 | 32 | 0 | 5 | 0 | 36 | 67 | 1715 | 1684 | Plasmodium knowlesi strain H RNA-binding protein, putative (PKNH_1269600), partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 24596181 | 24596181 | PRJNA270367_P_NODE_28500_length_211_cov_0.962963_g28295_i0 | PRJNA270367 | 28500 | 211 | 0.962963 | 2.03185193 | Cryptosporidium sp. chipmunk genotype I | 1280935 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 5.0099999999999997e-23 | NTclustered | gi|2787695164|ref|XM_067345064.1| | 1280935 | g28295 | i0 | 88.119 | 5.00473933649289 | 101 | 12 | 48 | 0 | 9 | 109 | 1188 | 1288 | Cryptosporidium sp. chipmunk genotype I 26S proteasome regulatory subunit 4 A-like (ELE39_002214), partial mRNA | blastn | 1056 | 121 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. chipmunk genotype I |
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);;