contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA906294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3800759 | 3800759 | PRJNA906294_P_NODE_29823_length_1017_cov_2.448093_g26550_i0 | PRJNA906294 | 29823 | 1017 | 2.448093 | 24.89710581 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 7.700000000000001e-28 | NTclustered | gi|1976646300|ref|XR_005506384.1| | 5851 | g26550 | i0 | 88.793 | 13.5565388397247 | 116 | 9 | 11 | 4 | 619 | 732 | 2235 | 2348 | Plasmodium knowlesi strain H 28S ribosomal RNA (PKNH_1001000), rRNA | blastn | 13787 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 4714684 | 4714684 | PRJNA906294_P_NODE_138764_length_328_cov_2.317647_g134648_i0 | PRJNA906294 | 138764 | 328 | 2.317647 | 7.60188216 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.031 | NTclustered | gi|1249152248|ref|XM_022734333.1| | 88456 | g134648 | i0 | 100 | 0.0853658536585366 | 28 | 0 | 9 | 0 | 272 | 299 | 418 | 391 | PREDICTED: Cyclospora cayetanensis 60S ribosomal protein L27a (LOC34621108), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 10176865 | 10176865 | PRJNA906294_P_NODE_149288_length_313_cov_0.729167_g145172_i0 | PRJNA906294 | 149288 | 313 | 0.729167 | 2.28229271 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 2.4700000000000003e-122 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g145172 | i0 | 92.652 | 1128.28115015974 | 313 | 23 | 100 | 0 | 1 | 313 | 317 | 629 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 353152 | 453 | 0.995584988962472 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 12365910 | 12365910 | PRJNA906294_P_NODE_16590_length_1450_cov_13.405955_g14399_i0 | PRJNA906294 | 16590 | 1450 | 13.405955 | 194.3863475 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 2412 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g14399 | i0 | 96.754 | 1210.52137931034 | 1448 | 46 | 99 | 1 | 4 | 1450 | 1914 | 467 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 1755256 | 2412 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 13641361 | 13641361 | PRJNA906294_P_NODE_202231_length_253_cov_1.466667_g198115_i0 | PRJNA906294 | 202231 | 253 | 1.466667 | 3.71066751 | Sarcocystis tenella | 5818 | SAR_Eukaryotes | SAR_Eukaryotes | 414 | 2.54e-111 | NTclustered | gi|1777428592|gb|MK420024.1| | 5818 | g198115 | i0 | 96.078 | 76.600790513834 | 255 | 8 | 100 | 1 | 1 | 253 | 432 | 686 | Sarcocystis tenella isolate OS36 large subunit ribosomal RNA gene, partial sequence | blastn | 19380 | 414 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis tenella | ||
| 14914800 | 14914800 | PRJNA906294_P_NODE_16612_length_1449_cov_13.020349_g14399_i1 | PRJNA906294 | 16612 | 1449 | 13.020349 | 188.66485701 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 2468 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g14399 | i1 | 97.445 | 1416.51276742581 | 1448 | 35 | 99 | 2 | 1 | 1446 | 467 | 1914 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 2052527 | 2468 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 17466314 | 17466314 | PRJNA906294_P_NODE_219414_length_245_cov_0.883721_g215298_i0 | PRJNA906294 | 219414 | 245 | 0.883721 | 2.16511645 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.32e-4 | NTclustered | gi|915146105|ref|XM_013482944.1| | 5804 | g215298 | i0 | 100 | 0.620408163265306 | 32 | 0 | 13 | 0 | 22 | 53 | 2983 | 2952 | Eimeria maxima 30S ribosomal protein S1, putative partial mRNA | blastn | 152 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 19099671 | 19099671 | PRJNA906294_P_NODE_125195_length_353_cov_0.960714_g121079_i0 | PRJNA906294 | 125195 | 353 | 0.960714 | 3.39132042 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.033 | NTclustered | gi|915016179|ref|XM_013397389.1| | 5801 | g121079 | i0 | 100 | 0.475920679886686 | 28 | 0 | 8 | 0 | 197 | 224 | 216 | 189 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 168 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 20374759 | 20374759 | PRJNA906294_P_NODE_177796_length_278_cov_0.995122_g173680_i0 | PRJNA906294 | 177796 | 278 | 0.995122 | 2.76643916 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916418613|ref|XM_013375084.1| | 5802 | g173680 | i0 | 90.909 | 0.406474820143885 | 44 | 0 | 16 | 4 | 155 | 198 | 2461 | 2422 | Eimeria tenella leucine rich repeat containing protein / ankyrin repeat containing protein, putative (ETH_00024865), partial mRNA | blastn | 113 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 21289246 | 21289246 | PRJNA906294_P_NODE_18657_length_1357_cov_14.187695_g14399_i2 | PRJNA906294 | 18657 | 1357 | 14.187695 | 192.52702115 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 2320 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g14399 | i2 | 97.498 | 1325.5320560059 | 1359 | 32 | 100 | 2 | 1 | 1357 | 1825 | 467 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 1798747 | 2320 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 22563493 | 22563493 | PRJNA906294_P_NODE_150638_length_311_cov_0.957983_g146522_i0 | PRJNA906294 | 150638 | 311 | 0.957983 | 2.97932713 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.029 | NTclustered | gi|124505248|ref|XM_001351330.1| | 36329 | g146522 | i0 | 100 | 0.090032154340836 | 28 | 0 | 9 | 0 | 4 | 31 | 7015 | 6988 | Plasmodium falciparum 3D7 pre-mRNA-processing-splicing factor 8, putative (PF3D7_0405400), partial mRNA | blastn | 28 | 52.8 | 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);;