contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193656 | 193656 | PRJNA1086823_P_NODE_12341_length_253_cov_0.866667_g12224_i0 | PRJNA1086823 | 12341 | 253 | 0.866667 | 2.19266751 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 1.92e-127 | NTclustered | gi|258597881|ref|XM_001348714.2| | 36329 | g12224 | i0 | 100 | 3.39130434782609 | 253 | 0 | 100 | 0 | 1 | 253 | 436 | 688 | Plasmodium falciparum 3D7 ubiquitin carboxyl-terminal hydrolase isozyme L3 (PF3D7_1460400), partial mRNA | blastn | 858 | 468 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 4020202 | 4020202 | PRJNA1086823_P_NODE_10284_length_270_cov_1.187817_g10167_i0 | PRJNA1086823 | 10284 | 270 | 1.187817 | 3.2071059 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 7.349999999999998e-137 | NTclustered | gi|124506184|ref|XM_001351654.1| | 36329 | g10167 | i0 | 100 | 5.61111111111111 | 270 | 0 | 100 | 0 | 1 | 270 | 81 | 350 | Plasmodium falciparum 3D7 purine nucleoside phosphorylase (PF3D7_0513300), partial mRNA | blastn | 1515 | 499 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 5296637 | 5296637 | PRJNA1086823_P_NODE_4325_length_377_cov_1.098684_g4208_i0 | PRJNA1086823 | 4325 | 377 | 1.098684 | 4.14203868 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|669195891|ref|XM_008624735.1| | 54757 | g4208 | i0 | 87.755 | 0.204244031830239 | 49 | 4 | 13 | 2 | 62 | 109 | 1523 | 1570 | Plasmodium vinckei vinckei ABC1 family, putative (PVVCY_1402920), partial mRNA | blastn | 77 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 6120483 | 6120483 | PRJNA1086823_P_NODE_10585_length_267_cov_1.206186_g10468_i0 | PRJNA1086823 | 10585 | 267 | 1.206186 | 3.22051662 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 494 | 3.38e-135 | NTclustered | gi|116014810|gb|DQ874471.1| | 5833 | g10468 | i0 | 100 | 22 | 267 | 0 | 100 | 0 | 1 | 267 | 657 | 391 | Plasmodium falciparum strain Ph1 fructose 1,6-biphosphate aldolase gene, partial cds | blastn | 5874 | 494 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 6571561 | 6571561 | PRJNA1086823_P_NODE_12826_length_252_cov_0.871508_g12709_i0 | PRJNA1086823 | 12826 | 252 | 0.871508 | 2.19620016 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.5e-118 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g12709 | i0 | 98.016 | 23.9801587301587 | 252 | 5 | 100 | 0 | 1 | 252 | 96795 | 97046 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6043 | 438 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10397195 | 10397195 | PRJNA1086823_P_NODE_4489_length_371_cov_1.191275_g4372_i0 | PRJNA1086823 | 4489 | 371 | 1.191275 | 4.41963025 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|669195891|ref|XM_008624735.1| | 54757 | g4372 | i0 | 90.698 | 0.115902964959569 | 43 | 2 | 11 | 2 | 70 | 111 | 1570 | 1529 | Plasmodium vinckei vinckei ABC1 family, putative (PVVCY_1402920), partial mRNA | blastn | 43 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 11672422 | 11672422 | PRJNA1086823_P_NODE_16970_length_245_cov_0.906977_g16853_i0 | PRJNA1086823 | 16970 | 245 | 0.906977 | 2.22209365 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 5.1900000000000006e-123 | NTclustered | gi|124506414|ref|XM_001351769.1| | 36329 | g16853 | i0 | 100 | 3.66530612244898 | 245 | 0 | 100 | 0 | 1 | 245 | 1699 | 1943 | Plasmodium falciparum 3D7 S-adenosyl-L-methionine-dependent tRNA 4-demethylwyosine synthase, putative (PF3D7_0524900), partial mRNA | blastn | 898 | 453 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 12496228 | 12496228 | PRJNA1086823_P_NODE_9150_length_281_cov_1.500000_g9033_i0 | PRJNA1086823 | 9150 | 281 | 1.5 | 4.215 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 520 | 5.909999999999999e-143 | NTclustered | gi|8918237|dbj|AB023579.1| | 5833 | g9033 | i0 | 100 | 22.3701067615658 | 281 | 0 | 100 | 0 | 1 | 281 | 1309 | 1029 | Plasmodium falciparum gene for elongation factor 2, partial cds | blastn | 6286 | 520 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 15496278 | 15496278 | PRJNA1086823_P_NODE_10673_length_266_cov_1.316062_g10556_i0 | PRJNA1086823 | 10673 | 266 | 1.316062 | 3.50072492 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 1.2099999999999999e-134 | NTclustered | gi|124804771|ref|XM_001348071.1| | 36329 | g10556 | i0 | 100 | 3 | 266 | 0 | 100 | 0 | 1 | 266 | 385 | 120 | Plasmodium falciparum 3D7 60S ribosomal protein L35ae, putative (PF3D7_1142600), partial mRNA | blastn | 798 | 492 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 19319362 | 19319362 | PRJNA1086823_P_NODE_10696_length_266_cov_1.036269_g10579_i0 | PRJNA1086823 | 10696 | 266 | 1.036269 | 2.75647554 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 4.7e-79 | NTclustered | gi|18076408|emb|AJ290926.2| | 36329 | g10579 | i0 | 100 | 2.49624060150376 | 166 | 0 | 62 | 0 | 101 | 266 | 1 | 166 | Plasmodium falciparum partial mRNA for early transcribed membrane protein 11.1 (etramp11.1) | blastn | 664 | 307 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 19319398 | 19319398 | PRJNA1086823_P_NODE_12496_length_253_cov_0.866667_g12379_i0 | PRJNA1086823 | 12496 | 253 | 0.866667 | 2.19266751 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 1.92e-127 | NTclustered | gi|124804187|ref|XM_001347892.1| | 36329 | g12379 | i0 | 100 | 5.9802371541502 | 253 | 0 | 100 | 0 | 1 | 253 | 183 | 435 | Plasmodium falciparum 3D7 ethanolamine kinase (PF3D7_1124600), partial mRNA | blastn | 1513 | 468 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 21870751 | 21870751 | PRJNA1086823_P_NODE_7398_length_303_cov_1.260870_g7281_i0 | PRJNA1086823 | 7398 | 303 | 1.26087 | 3.8204361 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 5.12e-124 | NTclustered | gi|124800696|ref|XM_001349500.1| | 36329 | g7281 | i0 | 100 | 4.04620462046205 | 247 | 0 | 100 | 0 | 1 | 247 | 511 | 757 | Plasmodium falciparum 3D7 EMP1-trafficking protein (PF3D7_0202200), partial mRNA | blastn | 1226 | 457 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum |
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);;