contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1166500 | 1166500 | PRJNA674308_P_NODE_19881_length_220_cov_1.824561_g19646_i0 | PRJNA674308 | 19881 | 220 | 1.824561 | 4.0140342 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|1145260099|ref|XM_020114913.1| | 5854 | g19646 | i0 | 100 | 1.31363636363636 | 29 | 0 | 13 | 0 | 170 | 198 | 1211 | 1183 | Plasmodium reichenowi hypothetical protein partial mRNA | blastn | 289 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 1920940 | 1920940 | PRJNA674308_P_NODE_42322_length_166_cov_1.333333_g42087_i0 | PRJNA674308 | 42322 | 166 | 1.333333 | 2.21333278 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|915125438|ref|XM_013478529.1| | 5804 | g42087 | i0 | 94.444 | 0.385542168674699 | 36 | 1 | 22 | 1 | 16 | 51 | 1503 | 1469 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 64 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 3195434 | 3195434 | PRJNA674308_P_NODE_12403_length_272_cov_2.089686_g12168_i0 | PRJNA674308 | 12403 | 272 | 2.089686 | 5.68394592 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 8.79e-17 | NTclustered | gi|1620124195|ref|XM_028672920.1| | 5849 | g12168 | i0 | 86.667 | 0.496323529411765 | 90 | 12 | 33 | 0 | 183 | 272 | 1405 | 1316 | Plasmodium gallinaceum ATP-dependent protease ATPase subunit ClpY, putative (ClpY), partial mRNA | blastn | 135 | 100 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 3718193 | 3718193 | PRJNA674308_P_NODE_22223_length_210_cov_2.000000_g21988_i0 | PRJNA674308 | 22223 | 210 | 2 | 4.2 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 2.9099999999999998e-40 | NTclustered | gi|1027954645|ref|XM_016798014.1| | 31271 | g21988 | i0 | 83.42 | 78.9952380952381 | 193 | 30 | 92 | 2 | 1 | 193 | 191 | 1 | Plasmodium chabaudi chabaudi histone H4, putative (PCHAS_0902400), partial mRNA | blastn | 16589 | 178 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 6270463 | 6270463 | PRJNA674308_P_NODE_25885_length_197_cov_1.182432_g25650_i0 | PRJNA674308 | 25885 | 197 | 1.182432 | 2.32939104 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.017 | NTclustered | gi|1843572313|ref|XM_034565959.1| | 5823 | g25650 | i0 | 92.105 | 0.33502538071066 | 38 | 2 | 19 | 1 | 20 | 57 | 1582 | 1546 | Plasmodium berghei ANKA IGPS-like protein, putative (PBANKA_1139700), partial mRNA | blastn | 66 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 10848729 | 10848729 | PRJNA674308_P_NODE_23989_length_203_cov_2.701299_g23754_i0 | PRJNA674308 | 23989 | 203 | 2.701299 | 5.48363697 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 7.78e-41 | NTclustered | gi|1270522599|ref|XM_721458.2| | 5861 | g23754 | i0 | 84.916 | 34.0443349753695 | 179 | 25 | 88 | 2 | 19 | 196 | 1712 | 1535 | Plasmodium yoelii uncharacterized protein (PY17X_1242900), partial mRNA | blastn | 6911 | 180 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 13398702 | 13398702 | PRJNA674308_P_NODE_16551_length_238_cov_3.015873_g16316_i0 | PRJNA674308 | 16551 | 238 | 3.015873 | 7.17777774 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 4.44e-29 | NTclustered | gi|83282436|ref|XM_724677.1| | 5861 | g16316 | i0 | 88.696 | 6.57983193277311 | 115 | 13 | 48 | 0 | 1 | 115 | 746 | 632 | Plasmodium yoelii T-complex protein 1 subunit eta, putative (PY17X_0408800), partial mRNA | blastn | 1566 | 141 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 13398736 | 13398736 | PRJNA674308_P_NODE_20931_length_216_cov_1.119760_g20696_i0 | PRJNA674308 | 20931 | 216 | 1.11976 | 2.4186816 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.17e-5 | NTclustered | gi|1620952974|ref|XM_028688548.1| | 77519 | g20696 | i0 | 94.872 | 1.25925925925926 | 39 | 2 | 18 | 0 | 92 | 130 | 2934 | 2896 | Plasmodium gonderi hypothetical protein, conserved (PGO_112100), partial mRNA | blastn | 272 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 13398919 | 13398919 | PRJNA674308_P_NODE_45671_length_165_cov_0.896552_g45436_i0 | PRJNA674308 | 45671 | 165 | 0.896552 | 1.4793108 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.46e-77 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g45436 | i0 | 99.394 | 28.2969696969697 | 165 | 1 | 100 | 0 | 1 | 165 | 116332 | 116168 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 4669 | 300 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 14673740 | 14673740 | PRJNA674308_P_NODE_28692_length_188_cov_1.496403_g28457_i0 | PRJNA674308 | 28692 | 188 | 1.496403 | 2.81323764 | Plasmodium malariae | 5858 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 9.63e-5 | NTclustered | gi|1624468939|ref|XM_029008249.1| | 5858 | g28457 | i0 | 88.462 | 0.276595744680851 | 52 | 3 | 26 | 3 | 64 | 112 | 2048 | 1997 | Plasmodium malariae 60 kDa chaperonin, putative (CPN60), partial mRNA | blastn | 52 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 21047102 | 21047102 | PRJNA674308_P_NODE_13097_length_265_cov_2.398148_g12862_i0 | PRJNA674308 | 13097 | 265 | 2.398148 | 6.3550922 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 4.02e-5 | NTclustered | gi|1084933524|ref|XM_018788157.1| | 647221 | g12862 | i0 | 97.222 | 3.20377358490566 | 36 | 1 | 14 | 0 | 163 | 198 | 981 | 1016 | Plasmodium gaboni hypothetical protein partial mRNA | blastn | 849 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 21568541 | 21568541 | PRJNA674308_P_NODE_14777_length_251_cov_1.544554_g14542_i0 | PRJNA674308 | 14777 | 251 | 1.544554 | 3.87683054 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 2.18e-32 | NTclustered | gi|3057043|gb|AF006204.1|AF006204 | 5833 | g14542 | i0 | 77.778 | 3.49003984063745 | 252 | 52 | 99 | 4 | 1 | 250 | 565 | 316 | Plasmodium falciparum PfSec61 (PfSec61) gene, complete cds | blastn | 876 | 152 | 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);;