contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA781196" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 759117 | 759117 | PRJNA781196_P_NODE_28201_length_328_cov_1.835294_g27824_i0 | PRJNA781196 | 28201 | 328 | 1.835294 | 6.01976432 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1084939551|ref|XM_018788273.1| | 647221 | g27824 | i0 | 100 | 5.76524390243902 | 30 | 0 | 9 | 0 | 252 | 281 | 778 | 749 | Plasmodium gaboni hypothetical protein partial mRNA | blastn | 1891 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 2035394 | 2035394 | PRJNA781196_P_NODE_43482_length_272_cov_1.000000_g43105_i0 | PRJNA781196 | 43482 | 272 | 1 | 2.72 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 2.48e-7 | NTclustered | gi|1620130862|ref|XM_028673722.1| | 5849 | g43105 | i0 | 93.617 | 0.408088235294118 | 47 | 1 | 17 | 2 | 54 | 99 | 1383 | 1428 | Plasmodium gallinaceum RNA polymerase II-associated protein 1, putative (PGAL8A_00492300), partial mRNA | blastn | 111 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 4587160 | 4587160 | PRJNA781196_P_NODE_11944_length_469_cov_3.537879_g11568_i0 | PRJNA781196 | 11944 | 469 | 3.537879 | 16.59265251 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 2.56e-49 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g11568 | i0 | 78.997 | 6.35820895522388 | 319 | 57 | 67 | 10 | 54 | 367 | 380 | 67 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 2982 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 12239270 | 12239270 | PRJNA781196_P_NODE_58010_length_248_cov_0.891429_g57633_i0 | PRJNA781196 | 58010 | 248 | 0.891429 | 2.21074392 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915128576|ref|XM_013479404.1| | 5804 | g57633 | i0 | 100 | 0.362903225806452 | 30 | 0 | 12 | 0 | 95 | 124 | 2618 | 2589 | Eimeria maxima RNA-binding protein, putative partial mRNA | blastn | 90 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 14788355 | 14788355 | PRJNA781196_P_NODE_67372_length_242_cov_0.893491_g66995_i0 | PRJNA781196 | 67372 | 242 | 0.893491 | 2.16224822 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 6.9e-92 | NTclustered | gi|1843573164|ref|XM_034566431.1| | 5823 | g66995 | i0 | 99.479 | 3.96694214876033 | 192 | 1 | 79 | 0 | 3 | 194 | 195 | 4 | Plasmodium berghei ANKA U6 snRNA-associated Sm-like protein LSm2, putative (PBANKA_1235100), partial mRNA | blastn | 960 | 350 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 23711819 | 23711819 | PRJNA781196_P_NODE_14579_length_430_cov_2.532213_g14202_i0 | PRJNA781196 | 14579 | 430 | 2.532213 | 10.8885159 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 8.25e-59 | NTclustered | gi|401402052|ref|XM_003881109.1| | 572307 | g14202 | i0 | 78.307 | 63.2116279069767 | 378 | 78 | 87 | 4 | 1 | 376 | 3 | 378 | Neospora caninum Liverpool putative ubiquitin / ribosomal protein CEP52 fusion protein (NCLIV_042000), partial mRNA | blastn | 27181 | 241 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23712152 | 23712152 | PRJNA781196_P_NODE_39419_length_285_cov_1.103774_g39042_i0 | PRJNA781196 | 39419 | 285 | 1.103774 | 3.1457559 | Plasmodium mackerrasae | 2138133 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.5099999999999996e-37 | NTclustered | gi|1372150144|gb|MF508315.1| | 2138133 | g39042 | i0 | 84.94 | 3.33684210526316 | 166 | 25 | 58 | 0 | 78 | 243 | 1 | 166 | Plasmodium mackerrasae isolate 1-26-11 putative 26S proteasome regulatory subunit 7 gene, partial cds | blastn | 951 | 169 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium mackerrasae | ||
| 24163059 | 24163059 | PRJNA781196_P_NODE_64819_length_243_cov_0.917647_g64442_i0 | PRJNA781196 | 64819 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.71e-4 | NTclustered | gi|915009362|ref|XM_013395395.1| | 5801 | g64442 | i0 | 100 | 7.51851851851852 | 31 | 0 | 13 | 0 | 98 | 128 | 130 | 100 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 1827 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina |
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);;