contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA760976" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5033319 | 5033319 | PRJNA760976_P_NODE_9704_length_455_cov_1.007853_g9385_i0 | PRJNA760976 | 9704 | 455 | 1.007853 | 4.58573115 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 2.64e-4 | NTclustered | gi|915126252|ref|XM_013478820.1| | 5804 | g9385 | i0 | 97.143 | 8.66593406593407 | 35 | 1 | 8 | 0 | 371 | 405 | 965 | 999 | Eimeria maxima serine/threonine protein phosphatase 5, putative partial mRNA | blastn | 3943 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 5845879 | 5845879 | PRJNA760976_P_NODE_1525_length_1013_cov_2.253191_g1300_i0 | PRJNA760976 | 1525 | 1013 | 2.253191 | 22.82482483 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 699 | 0 | NTclustered | gi|1673117351|ref|XM_029364038.1| | 94643 | g1300 | i0 | 79.878 | 95.7601184600197 | 984 | 174 | 96 | 21 | 9 | 980 | 2190 | 1219 | Besnoitia besnoiti putative translation elongation factor 2 family protein (BESB_056030), partial mRNA | blastn | 97005 | 699 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 7121083 | 7121083 | PRJNA760976_P_NODE_23166_length_331_cov_1.178295_g22845_i0 | PRJNA760976 | 23166 | 331 | 1.178295 | 3.90015645 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 2.31e-33 | NTclustered | gi|1673111845|ref|XM_029359146.1| | 94643 | g22845 | i0 | 82.486 | 0.534743202416918 | 177 | 31 | 53 | 0 | 87 | 263 | 271 | 447 | Besnoitia besnoiti putative ATP synthase F0 subunit 9 (BESB_003910), partial mRNA | blastn | 177 | 156 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 9670748 | 9670748 | PRJNA760976_P_NODE_20808_length_344_cov_1.678967_g20487_i0 | PRJNA760976 | 20808 | 344 | 1.678967 | 5.77564648 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 5.15e-40 | NTclustered | gi|2794952797|ref|XM_067862068.1| | 5871 | g20487 | i0 | 81.333 | 32.1337209302326 | 225 | 36 | 65 | 4 | 123 | 344 | 458 | 237 | Babesia caballi 60S ribosomal protein L11a, putative (BcabD6B2_55360), partial mRNA | blastn | 11054 | 178 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 13959019 | 13959019 | PRJNA760976_P_NODE_53471_length_243_cov_7.605882_g53150_i0 | PRJNA760976 | 53471 | 243 | 7.605882 | 18.48229326 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 7.77e-12 | NTclustered | gi|2795624762|ref|XM_068066411.1| | 483139 | g53150 | i0 | 79.487 | 1.96296296296296 | 117 | 24 | 48 | 0 | 16 | 132 | 129 | 245 | Cystoisospora suis uncharacterized protein (CSUI_006247), partial mRNA | blastn | 477 | 84.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 14771353 | 14771353 | PRJNA760976_P_NODE_57712_length_229_cov_3.455128_g57391_i0 | PRJNA760976 | 57712 | 229 | 3.455128 | 7.91224312 | Klossiella equi | 2170311 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.97e-27 | NTclustered | gi|1532335275|gb|MH203050.1| | 2170311 | g57391 | i0 | 91.837 | 2.13973799126638 | 98 | 6 | 43 | 2 | 60 | 157 | 300 | 205 | Klossiella equi mitochondrion, complete genome | blastn | 490 | 135 | 1 | Eukaryota | Sar | Apicomplexa | Klossiellidae | Klossiella | Klossiella equi | ||||
| 15233553 | 15233553 | PRJNA760976_P_NODE_9632_length_456_cov_1.394256_g9313_i0 | PRJNA760976 | 9632 | 456 | 1.394256 | 6.35780736 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 8.730000000000001e-64 | NTclustered | gi|82704923|ref|XM_721661.1| | 5861 | g9313 | i0 | 79.101 | 62.7456140350877 | 378 | 76 | 83 | 3 | 22 | 398 | 541 | 916 | Plasmodium yoelii heat shock protein 70, putative (PY17X_0712100), partial mRNA | blastn | 28612 | 257 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 18594074 | 18594074 | PRJNA760976_P_NODE_4935_length_596_cov_2.024857_g4624_i0 | PRJNA760976 | 4935 | 596 | 2.024857 | 12.06814772 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 8.81e-80 | NTclustered | gi|2794945628|ref|XM_067860250.1| | 5871 | g4624 | i0 | 82.402 | 23.1560402684564 | 358 | 61 | 60 | 2 | 114 | 470 | 469 | 113 | Babesia caballi 40S ribosomal protein S11, putative (BcabD6B2_37170), partial mRNA | blastn | 13801 | 311 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 19869280 | 19869280 | PRJNA760976_P_NODE_45276_length_257_cov_2.375000_g44955_i0 | PRJNA760976 | 45276 | 257 | 2.375 | 6.10375 | Klossiella equi | 2170311 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.96e-16 | NTclustered | gi|1532335275|gb|MH203050.1| | 2170311 | g44955 | i0 | 91.549 | 0.276264591439689 | 71 | 6 | 28 | 0 | 187 | 257 | 5771 | 5701 | Klossiella equi mitochondrion, complete genome | blastn | 71 | 99 | 1 | Eukaryota | Sar | Apicomplexa | Klossiellidae | Klossiella | Klossiella equi | ||||
| 21144901 | 21144901 | PRJNA760976_P_NODE_25237_length_321_cov_4.963710_g24916_i0 | PRJNA760976 | 25237 | 321 | 4.96371 | 15.9335091 | Babesia sp. Xinjiang | 462227 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.75e-24 | NTclustered | gi|1624714493|ref|XM_029014537.1| | 462227 | g24916 | i0 | 84.375 | 4.01246105919003 | 128 | 20 | 40 | 0 | 176 | 303 | 128 | 1 | Babesia sp. Xinjiang 60S ribosomal protein L29-1 (BXIN_0596), partial mRNA | blastn | 1288 | 126 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia sp. Xinjiang |
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);;