contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA770361" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746402 | 746402 | PRJNA770361_P_NODE_3061_length_539_cov_1.673820_g2967_i0 | PRJNA770361 | 3061 | 539 | 1.67382 | 9.0218898 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 1.2599999999999995e-112 | NTclustered | gi|820697789|tpe|LN714496.1| | 432359 | g2967 | i0 | 81.404 | 77.734693877551 | 527 | 86 | 97 | 10 | 1 | 521 | 1371653 | 1372173 | TPA_asm: Toxoplasma gondii VEG, chromosome chrVIIa, complete genome | blastn | 41899 | 420 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 746446 | 746446 | PRJNA770361_P_NODE_561_length_1202_cov_3.062002_g514_i0 | PRJNA770361 | 561 | 1202 | 3.062002 | 36.80526404 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 896 | 0 | NTclustered | gi|401412092|ref|XM_003885445.1| | 572307 | g514 | i0 | 80.183 | 97.1455906821963 | 1201 | 234 | 99 | 4 | 2 | 1200 | 13 | 1211 | Neospora caninum Liverpool tubulin alpha chain (NCLIV_058890), partial mRNA | blastn | 116769 | 896 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 5849817 | 5849817 | PRJNA770361_P_NODE_1485_length_768_cov_3.520863_g1397_i0 | PRJNA770361 | 1485 | 768 | 3.520863 | 27.04022784 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 1.95e-67 | NTclustered | gi|820688590|tpe|LN714475.1| | 572307 | g1397 | i0 | 87.826 | 28.5455729166667 | 230 | 28 | 30 | 0 | 538 | 767 | 951293 | 951064 | TPA_asm: Neospora caninum Liverpool, chromosome chrIb, complete genome | blastn | 21923 | 270 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 6310452 | 6310452 | PRJNA770361_P_NODE_325_length_1466_cov_9.092606_g299_i0 | PRJNA770361 | 325 | 1466 | 9.092606 | 133.29760396 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 867 | 0 | NTclustered | gi|260323703|dbj|AK317816.1| | 5811 | g299 | i0 | 78.629 | 49.9365620736698 | 1357 | 255 | 91 | 27 | 6 | 1346 | 1568 | 231 | Toxoplasma gondii cDNA, clone: XTG00910.2, full cDNA, XTG Sugano cDNA library | blastn | 73207 | 867 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 8399457 | 8399457 | PRJNA770361_P_NODE_12107_length_270_cov_1.187817_g12012_i0 | PRJNA770361 | 12107 | 270 | 1.187817 | 3.2071059 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 8.78e-12 | NTclustered | gi|1249165227|ref|XM_022730797.1| | 88456 | g12012 | i0 | 85.185 | 0.3 | 81 | 12 | 30 | 0 | 12 | 92 | 290 | 370 | PREDICTED: Cyclospora cayetanensis late histone H2B.L4 (LOC34617424), mRNA | blastn | 81 | 84.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 8859549 | 8859549 | PRJNA770361_P_NODE_6287_length_374_cov_1.036545_g6192_i0 | PRJNA770361 | 6287 | 374 | 1.036545 | 3.8766783 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.64e-5 | NTclustered | gi|916428551|ref|XM_013380051.1| | 5802 | g6192 | i0 | 97.368 | 23.457219251336895 | 38 | 0 | 10 | 1 | 136 | 173 | 249 | 213 | Eimeria tenella uncharacterized protein (ETH_00035845), partial mRNA | blastn | 8773 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 12226170 | 12226170 | PRJNA770361_P_NODE_6550_length_366_cov_1.672355_g6455_i0 | PRJNA770361 | 6550 | 366 | 1.672355 | 6.1208193 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.035 | NTclustered | gi|1620141828|ref|XM_028676858.1| | 85471 | g6455 | i0 | 100 | 0.0765027322404372 | 28 | 0 | 8 | 0 | 77 | 104 | 1365 | 1392 | Plasmodium relictum transcription factor with AP2 domain(s), putative (AP2-O), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 19873217 | 19873217 | PRJNA770361_P_NODE_416_length_1345_cov_1.647013_g382_i0 | PRJNA770361 | 416 | 1345 | 1.647013 | 22.15232485 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 1040 | 0 | NTclustered | gi|401405636|ref|XM_003882219.1| | 572307 | g382 | i0 | 80.772 | 22.528624535316 | 1347 | 245 | 99 | 12 | 1 | 1340 | 276 | 1615 | Neospora caninum Liverpool putative elongation factor 2 (NCLIV_020220), partial mRNA | blastn | 30301 | 1040 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 24973040 | 24973040 | PRJNA770361_P_NODE_3900_length_477_cov_5.099010_g3805_i0 | PRJNA770361 | 3900 | 477 | 5.09901 | 24.3222777 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 3.2699999999999998e-68 | NTclustered | gi|126649276|ref|XM_001388273.1| | 353152 | g3805 | i0 | 80.27 | 7.9979035639413 | 370 | 66 | 77 | 5 | 111 | 476 | 112 | 478 | Cryptosporidium parvum Iowa II ribosomal protein S23 (cgd6_1390) mRNA, partial cds | blastn | 3815 | 272 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum |
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);;