contig_metadata
16 rows where bioproject = "PRJEB27957" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6089962 | 6089962 | PRJEB27957_P_NODE_89405_length_182_cov_1.172932_g89295_i0 | PRJEB27957 | 89405 | 182 | 1.172932 | 2.13473624 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|328926933|emb|FN813244.1| | 5804 | g89295 | i0 | 100 | 1.40659340659341 | 28 | 0 | 15 | 0 | 31 | 58 | 12569 | 12596 | Eimeria maxima imp-1 gene for immune mapped protein 1, exons 1-4, strain Weybridge, clone EmaxBAC2k08 | blastn | 256 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 8950457 | 8950457 | PRJEB27957_P_NODE_71188_length_201_cov_2.052632_g71078_i0 | PRJEB27957 | 71188 | 201 | 2.052632 | 4.12579032 | Plasmodium brasilianum | 5824 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 3.76e-4 | NTclustered | gi|2785765338|ref|XM_067217735.1| | 5824 | g71078 | i0 | 94.595 | 3.35323383084577 | 37 | 2 | 18 | 0 | 1 | 37 | 699 | 663 | Plasmodium brasilianum HSP90 co-chaperone p23 (MKS88_004551), partial mRNA | blastn | 674 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 10226157 | 10226157 | PRJEB27957_P_NODE_21249_length_322_cov_1.523810_g21139_i0 | PRJEB27957 | 21249 | 322 | 1.52381 | 4.9066682 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|1843571743|ref|XM_034565642.1| | 5823 | g21139 | i0 | 100 | 0.177018633540373 | 29 | 0 | 9 | 0 | 17 | 45 | 12958 | 12930 | Plasmodium berghei ANKA RNA pseudouridylate synthase, putative (PBANKA_1111000), partial mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 11501434 | 11501434 | PRJEB27957_P_NODE_590_length_1055_cov_7.366799_g543_i0 | PRJEB27957 | 590 | 1055 | 7.366799 | 77.71972945 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.03 | NTclustered | gi|829099727|ref|XM_972206.2| | 312017 | g543 | i0 | 100 | 0.0274881516587678 | 29 | 0 | 3 | 0 | 74 | 102 | 4173 | 4145 | Tetrahymena thermophila SB210 cation channel family protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 14051567 | 14051567 | PRJEB27957_P_NODE_77372_length_194_cov_1.793103_g77262_i0 | PRJEB27957 | 77372 | 194 | 1.793103 | 3.47861982 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.017 | NTclustered | gi|471232929|ref|XM_004037476.1| | 5932 | g77262 | i0 | 96.774 | 0.15979381443299 | 31 | 1 | 16 | 0 | 147 | 177 | 2253 | 2223 | Ichthyophthirius multifiliis serine threonine kinase cdc2, putative (IMG5_049980) mRNA, complete cds | blastn | 31 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 15325569 | 15325569 | PRJEB27957_P_NODE_120033_length_163_cov_3.052632_g119923_i0 | PRJEB27957 | 120033 | 163 | 3.052632 | 4.97579016 | Cryptosporidium ryanae | 515981 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.014 | NTclustered | gi|2787719454|ref|XM_067340226.1| | 515981 | g119923 | i0 | 100 | 0.171779141104294 | 28 | 0 | 17 | 0 | 114 | 141 | 618 | 645 | Cryptosporidium ryanae uncharacterized protein (FG386_000882), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 15325586 | 15325586 | PRJEB27957_P_NODE_50053_length_231_cov_2.527473_g49943_i0 | PRJEB27957 | 50053 | 231 | 2.527473 | 5.83846263 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|698820852|ref|XM_009845153.1| | 112090 | g49943 | i0 | 100 | 0.121212121212121 | 28 | 0 | 12 | 0 | 18 | 45 | 1735 | 1762 | Aphanomyces astaci hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 17875023 | 17875023 | PRJEB27957_P_NODE_59015_length_217_cov_1.797619_g58905_i0 | PRJEB27957 | 59015 | 217 | 1.797619 | 3.90083323 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|1145258282|ref|XM_020114684.1| | 5854 | g58905 | i0 | 96.97 | 0.152073732718894 | 33 | 0 | 15 | 1 | 68 | 99 | 10931 | 10899 | Plasmodium reichenowi putative membrane protein partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 18838602 | 18838602 | PRJEB27957_P_NODE_63455_length_211_cov_1.604938_g63345_i0 | PRJEB27957 | 63455 | 211 | 1.604938 | 3.38641918 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.019 | NTclustered | gi|2785757292|ref|XM_067215662.1| | 5824 | g63345 | i0 | 100 | 0.265402843601896 | 28 | 0 | 13 | 0 | 176 | 203 | 141 | 114 | Plasmodium brasilianum heat shock protein 86 family protein (MKS88_000460), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 20113335 | 20113335 | PRJEB27957_P_NODE_125976_length_162_cov_0.920354_g125866_i0 | PRJEB27957 | 125976 | 162 | 0.920354 | 1.49097348 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.013 | NTclustered | gi|820699808|tpe|LN714499.1| | 432359 | g125866 | i0 | 100 | 0.518518518518518 | 28 | 0 | 17 | 0 | 56 | 83 | 5454422 | 5454449 | TPA_asm: Toxoplasma gondii VEG, chromosome chrIX, complete genome | blastn | 84 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 22663806 | 22663806 | PRJEB27957_P_NODE_90638_length_181_cov_1.022727_g90528_i0 | PRJEB27957 | 90638 | 181 | 1.022727 | 1.85113587 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|1084824081|ref|XM_018785116.1| | 647221 | g90528 | i0 | 100 | 0.30939226519337 | 28 | 0 | 15 | 0 | 70 | 97 | 4034 | 4007 | Plasmodium gaboni putative membrane protein partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 24249243 | 24249243 | PRJEB27957_P_NODE_55800_length_222_cov_1.387283_g55690_i0 | PRJEB27957 | 55800 | 222 | 1.387283 | 3.07976826 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.02 | NTclustered | gi|914996737|ref|XM_013391590.1| | 5801 | g55690 | i0 | 96.875 | 0.144144144144144 | 32 | 0 | 14 | 1 | 154 | 185 | 423 | 453 | Eimeria acervulina zinc finger (C3HC4 RING finger) protein, putative partial mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 29212332 | 29212332 | PRJEB27957_P_NODE_100649_length_171_cov_1.278689_g100539_i0 | PRJEB27957 | 100649 | 171 | 1.278689 | 2.18655819 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 41.2 | 0.0496 | NR | DBA04522.1 | 4803 | g100539 | i0 | 33.3 | 0.842105263157895 | 48 | 31 | 84.2 | 1 | 157 | 14 | 413 | 459 | DBA04522.1 TPA: hypothetical protein N0F65_011070 [Lagenidium giganteum] | diamond | 144 | 41.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29212334 | 29212334 | PRJEB27957_P_NODE_58029_length_219_cov_0.917647_g57919_i0 | PRJEB27957 | 58029 | 219 | 0.917647 | 2.00964693 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0202 | NR | SBT44928.1 | 864142 | g57919 | i0 | 34.3 | 0.917808219178082 | 67 | 39 | 91.8 | 2 | 8 | 208 | 985 | 1046 | SBT44928.1 protein phosphatase, putative [Plasmodium ovale wallikeri] | diamond | 201 | 43.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 31739756 | 31739756 | PRJEB27957_P_NODE_58777_length_218_cov_0.911243_g58667_i0 | PRJEB27957 | 58777 | 218 | 0.911243 | 1.98650974 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0375 | NR | XP_022812141.1 | 5861 | g58667 | i0 | 47.2 | 0.495412844036697 | 36 | 19 | 49.5 | 0 | 152 | 45 | 474 | 509 | XP_022812141.1 conserved Plasmodium protein, unknown function [Plasmodium yoelii] | diamond | 108 | 42.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 32151264 | 32151264 | PRJEB27957_P_NODE_77718_length_194_cov_1.289655_g77608_i0 | PRJEB27957 | 77718 | 194 | 1.289655 | 2.5019307 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0494 | NR | KAH9158890.1 | 100861 | g77608 | i0 | 37.9 | 0.896907216494845 | 58 | 35 | 88.1 | 1 | 174 | 4 | 236 | 293 | KAH9158890.1 hypothetical protein LEN26_002657 [Aphanomyces euteiches] | diamond | 174 | 41.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;