contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1025141" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1437548 | 1437548 | PRJNA1025141_P_NODE_3882_length_413_cov_1.141176_g3821_i0 | PRJNA1025141 | 3882 | 413 | 1.141176 | 4.71305688 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.04e-47 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g3821 | i0 | 78.616 | 7.19370460048426 | 318 | 60 | 76 | 8 | 19 | 332 | 380 | 67 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 2971 | 204 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 2279346 | 2279346 | PRJNA1025141_P_NODE_1162_length_766_cov_2.209235_g1109_i0 | PRJNA1025141 | 1162 | 766 | 2.209235 | 16.9227401 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 4.34e-44 | NTclustered | gi|260323800|dbj|AK318085.1| | 5811 | g1109 | i0 | 84.08 | 5.8798955613577 | 201 | 31 | 26 | 1 | 230 | 430 | 482 | 283 | Toxoplasma gondii cDNA, clone: XTG04568.2, full cDNA, XTG Sugano cDNA library | blastn | 4504 | 193 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 9090407 | 9090407 | PRJNA1025141_P_NODE_5408_length_346_cov_1.575092_g5347_i0 | PRJNA1025141 | 5408 | 346 | 1.575092 | 5.44981832 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 8.539999999999999e-48 | NTclustered | gi|1624693841|ref|XM_029011792.1| | 189622 | g5347 | i0 | 81.855 | 57.0520231213873 | 248 | 39 | 71 | 4 | 8 | 252 | 1 | 245 | Babesia ovata elongation factor 2 (BOVATA_028750), partial mRNA | blastn | 19740 | 204 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 12916496 | 12916496 | PRJNA1025141_P_NODE_211_length_1467_cov_8.026542_g188_i0 | PRJNA1025141 | 211 | 1467 | 8.026542 | 117.74937114 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 2567 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g188 | i0 | 98.23 | 1373.14178595774 | 1469 | 24 | 100 | 1 | 1 | 1467 | 1847 | 379 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 2014399 | 2567 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 12916598 | 12916598 | PRJNA1025141_P_NODE_9131_length_255_cov_1.126374_g9070_i0 | PRJNA1025141 | 9131 | 255 | 1.126374 | 2.8722537 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.98e-4 | NTclustered | gi|916501701|ref|XM_013496211.1| | 44415 | g9070 | i0 | 100 | 0.12156862745098 | 31 | 0 | 12 | 0 | 152 | 182 | 168 | 138 | Eimeria mitis uncharacterized protein (EMH_0046780), partial mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 14191498 | 14191498 | PRJNA1025141_P_NODE_952_length_840_cov_5.035202_g188_i1 | PRJNA1025141 | 952 | 840 | 5.035202 | 42.2956968 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 1474 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g188 | i1 | 98.333 | 913.092857142857 | 840 | 14 | 100 | 0 | 1 | 840 | 379 | 1218 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 766998 | 1474 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 18014596 | 18014596 | PRJNA1025141_P_NODE_11855_length_244_cov_0.900585_g11794_i0 | PRJNA1025141 | 11855 | 244 | 0.900585 | 2.1974274 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 8.639999999999999e-121 | NTclustered | gi|296004663|ref|XM_002808679.1| | 36329 | g11794 | i0 | 99.59 | 3.55737704918033 | 244 | 1 | 100 | 0 | 1 | 244 | 617 | 374 | Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_0614100), partial mRNA | blastn | 868 | 446 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 21406170 | 21406170 | PRJNA1025141_P_NODE_10637_length_248_cov_0.880000_g10576_i0 | PRJNA1025141 | 10637 | 248 | 0.88 | 2.1824 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.05e-67 | NTclustered | gi|1145258038|ref|XM_020114651.1| | 5854 | g10576 | i0 | 98.675 | 2.43548387096774 | 151 | 2 | 61 | 0 | 1 | 151 | 2412 | 2562 | Plasmodium reichenowi hypothetical protein partial mRNA | blastn | 604 | 268 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 23115107 | 23115107 | PRJNA1025141_P_NODE_7279_length_294_cov_1.303167_g7218_i0 | PRJNA1025141 | 7279 | 294 | 1.303167 | 3.83131098 | Cryptosporidium baileyi | 27987 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 1.14e-75 | NTclustered | gi|193075908|gb|EU741857.1| | 27987 | g7218 | i0 | 84.899 | 94.969387755102 | 298 | 40 | 100 | 4 | 1 | 294 | 310 | 606 | Cryptosporidium baileyi strain ZJJHN27 heart shock protein 70 (HSP70) gene, partial cds | blastn | 27921 | 296 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium baileyi | ||
| 24388811 | 24388811 | PRJNA1025141_P_NODE_12560_length_242_cov_1.230769_g12499_i0 | PRJNA1025141 | 12560 | 242 | 1.230769 | 2.97846098 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.18e-74 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g12499 | i0 | 89.076 | 26.0743801652893 | 238 | 22 | 98 | 3 | 5 | 242 | 171 | 404 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 6310 | 292 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata |
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);;