contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1002816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152992 | 152992 | PRJNA1002816_P_NODE_4301_length_546_cov_2.029598_g4141_i0 | PRJNA1002816 | 4301 | 546 | 2.029598 | 11.08160508 | Actinosphaerium nucleofilum | 238767 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 9.88e-114 | NTclustered | gi|33089895|gb|AY283757.1| | 238767 | g4141 | i0 | 82.618 | 93.4908424908425 | 489 | 75 | 89 | 8 | 1 | 484 | 298 | 781 | Actinosphaerium nucleofilum isolate Anu4_3 actin gene, partial cds | blastn | 51046 | 424 | 1 | Eukaryota | Sar | Actinophryidae | Actinosphaerium | Actinosphaerium nucleofilum | |||||
| 153028 | 153028 | PRJNA1002816_P_NODE_6381_length_448_cov_2.053333_g6221_i0 | PRJNA1002816 | 6381 | 448 | 2.053333 | 9.19893184 | Vorticella microstoma | 77619 | SAR_Eukaryotes | SAR_Eukaryotes | 773 | 0 | NTclustered | gi|21429685|gb|AY101350.1| | 77619 | g6221 | i0 | 97.768 | 97.8549107142857 | 448 | 10 | 100 | 0 | 1 | 448 | 337 | 784 | Vorticella microstoma alpha-tubulin gene, partial cds | blastn | 43839 | 773 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella microstoma | ||
| 5255888 | 5255888 | PRJNA1002816_P_NODE_5925_length_466_cov_1.508906_g5765_i0 | PRJNA1002816 | 5925 | 466 | 1.508906 | 7.03150196 | Oxytricha granulifera | 5947 | SAR_Eukaryotes | SAR_Eukaryotes | 579 | 1.6799999999999994e-160 | NTclustered | gi|21215206|gb|AF510205.1| | 5947 | g5765 | i0 | 89.056 | 96.7081545064378 | 466 | 51 | 100 | 0 | 1 | 466 | 893 | 1358 | Oxytricha granulifera beta-tubulin gene, complete cds | blastn | 45066 | 579 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha granulifera | ||
| 5255899 | 5255899 | PRJNA1002816_P_NODE_6385_length_448_cov_1.682667_g6225_i0 | PRJNA1002816 | 6385 | 448 | 1.682667 | 7.53834816 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 6.62e-65 | NTclustered | gi|74830672|emb|CR932267.1| | 5888 | g6225 | i0 | 79.427 | 7.52232142857143 | 384 | 67 | 84 | 8 | 1 | 375 | 1548 | 1168 | ER-type hsp70, Paramecium tetraurelia macronuclear gene | blastn | 3370 | 261 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 7805410 | 7805410 | PRJNA1002816_P_NODE_17127_length_255_cov_1.269231_g16967_i0 | PRJNA1002816 | 17127 | 255 | 1.269231 | 3.23653905 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|187468407|emb|CU855855.1| | 123356 | g16967 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 176 | 203 | 107949 | 107976 | H.parasitica DNA sequence from clone HpEmoy2-17E12, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 7805503 | 7805503 | PRJNA1002816_P_NODE_21107_length_229_cov_2.487179_g20947_i0 | PRJNA1002816 | 21107 | 229 | 2.487179 | 5.69563991 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 9.24e-21 | NTclustered | gi|820692312|tpe|LN714484.1| | 572307 | g20947 | i0 | 78.824 | 16.1441048034934 | 170 | 34 | 74 | 2 | 53 | 221 | 2914748 | 2914580 | TPA_asm: Neospora caninum Liverpool, chromosome chrIX, complete genome | blastn | 3697 | 113 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 9080251 | 9080251 | PRJNA1002816_P_NODE_1268_length_994_cov_2.856678_g1159_i0 | PRJNA1002816 | 1268 | 994 | 2.856678 | 28.39537932 | Aurantiochytrium mangrovei | 333832 | SAR_Eukaryotes | SAR_Eukaryotes | 699 | 0 | NTclustered | gi|85822962|gb|DQ356647.1| | 333832 | g1159 | i0 | 80.816 | 55.3148893360161 | 907 | 160 | 91 | 12 | 34 | 933 | 900 | 1 | Schizochytrium mangrovei elongation factor 1-alpha gene, partial cds | blastn | 54983 | 699 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Aurantiochytrium | Aurantiochytrium mangrovei | |||
| 11631354 | 11631354 | PRJNA1002816_P_NODE_12790_length_309_cov_1.750000_g12630_i0 | PRJNA1002816 | 12790 | 309 | 1.75 | 5.4075 | Schizochytrium aggregatum | 4773 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 5.78e-54 | NTclustered | gi|85822990|gb|DQ356661.1| | 4773 | g12630 | i0 | 81.387 | 91.8187702265372 | 274 | 51 | 89 | 0 | 23 | 296 | 739 | 466 | Schizochytrium aggregatum actin gene, partial cds | blastn | 28372 | 224 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Schizochytrium | Schizochytrium aggregatum | |||
| 11631490 | 11631490 | PRJNA1002816_P_NODE_20130_length_243_cov_0.905882_g19970_i0 | PRJNA1002816 | 20130 | 243 | 0.905882 | 2.20129326 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 9.77e-31 | NTclustered | gi|1027954050|ref|XM_736288.2| | 31271 | g19970 | i0 | 80.095 | 6.36213991769547 | 211 | 30 | 86 | 10 | 36 | 243 | 1088 | 887 | Plasmodium chabaudi chabaudi heat shock protein 90, putative (PCHAS_0806000), partial mRNA | blastn | 1546 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 15455498 | 15455498 | PRJNA1002816_P_NODE_16673_length_260_cov_2.048128_g16513_i0 | PRJNA1002816 | 16673 | 260 | 2.048128 | 5.3251328000000004 | Oxytricha trifallax | 1172189 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 6.31e-33 | NTclustered | gi|6851292|gb|AF192970.1| | 1172189 | g16513 | i0 | 83.832 | 31.7769230769231 | 167 | 21 | 63 | 4 | 3 | 166 | 1396 | 1233 | Oxytricha trifallax histone H4 gene, complete cds | blastn | 8262 | 154 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha trifallax | ||
| 16729668 | 16729668 | PRJNA1002816_P_NODE_10954_length_336_cov_1.266160_g10794_i0 | PRJNA1002816 | 10954 | 336 | 1.26616 | 4.2542976 | Phytophthora palmivora | 4796 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.75e-59 | NTclustered | gi|2026389858|gb|MT032128.1| | 4796 | g10794 | i0 | 80.122 | 70.2440476190476 | 327 | 63 | 97 | 2 | 1 | 326 | 13682 | 14007 | Phytophthora palmivora mitochondrion, complete genome | blastn | 23602 | 243 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 16729748 | 16729748 | PRJNA1002816_P_NODE_14894_length_282_cov_1.162679_g14734_i0 | PRJNA1002816 | 14894 | 282 | 1.162679 | 3.27875478 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 6.64e-63 | NTclustered | gi|698815387|ref|XM_009842421.1| | 112090 | g14734 | i0 | 87.054 | 71.3794326241135 | 224 | 29 | 79 | 0 | 59 | 282 | 64 | 287 | Aphanomyces astaci actin mRNA | blastn | 20129 | 254 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18004666 | 18004666 | PRJNA1002816_P_NODE_20735_length_241_cov_1.035714_g20575_i0 | PRJNA1002816 | 20735 | 241 | 1.035714 | 2.49607074 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.28e-14 | NTclustered | gi|813156946|ref|XM_012346432.1| | 695850 | g20575 | i0 | 93.548 | 35.850622406639 | 62 | 4 | 26 | 0 | 15 | 76 | 136 | 75 | Saprolegnia parasitica CBS 223.65 histone H2B partial mRNA | blastn | 8640 | 93.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 19278361 | 19278361 | PRJNA1002816_P_NODE_13836_length_295_cov_1.040541_g13676_i0 | PRJNA1002816 | 13836 | 295 | 1.040541 | 3.06959595 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 1.99e-48 | NTclustered | gi|160347|gb|J04005.1|PFAHSP70AC | 5825 | g13676 | i0 | 81.855 | 62.0067796610169 | 248 | 41 | 83 | 3 | 33 | 278 | 479 | 234 | P.chabaudi hsp70 gene encoding a heat shock protein | blastn | 18292 | 206 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 20553920 | 20553920 | PRJNA1002816_P_NODE_10777_length_339_cov_1.736842_g10617_i0 | PRJNA1002816 | 10777 | 339 | 1.736842 | 5.88789438 | Opisthonecta henneguyi | 6026 | SAR_Eukaryotes | SAR_Eukaryotes | 516 | 9.44e-142 | NTclustered | gi|4063597|gb|AF056109.1| | 6026 | g10617 | i0 | 94.1 | 61.0294985250737 | 339 | 20 | 100 | 0 | 1 | 339 | 916 | 578 | Telotrochidium henneguyii translation elongation factor 1-alpha (TEF1) gene, partial cds | blastn | 20689 | 516 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta henneguyi | ||
| 23104999 | 23104999 | PRJNA1002816_P_NODE_12859_length_309_cov_0.898305_g12699_i0 | PRJNA1002816 | 12859 | 309 | 0.898305 | 2.77576245 | Pyrocystis lunula | 2972 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 5.7e-64 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g12699 | i0 | 81.818 | 92.546925566343 | 308 | 54 | 99 | 2 | 3 | 309 | 782 | 476 | Pyrocystis lunula actin mRNA, complete cds | blastn | 28597 | 257 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 24378721 | 24378721 | PRJNA1002816_P_NODE_10980_length_336_cov_0.844106_g10820_i0 | PRJNA1002816 | 10980 | 336 | 0.844106 | 2.83619616 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.032 | NTclustered | gi|471220273|ref|XM_004025160.1| | 5932 | g10820 | i0 | 100 | 0.0833333333333333 | 28 | 0 | 8 | 0 | 212 | 239 | 263 | 236 | Ichthyophthirius multifiliis ubiquitin- hect domain protein, putative (IMG5_189580) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 24378740 | 24378740 | PRJNA1002816_P_NODE_11880_length_322_cov_0.807229_g11720_i0 | PRJNA1002816 | 11880 | 322 | 0.807229 | 2.59927738 | Prorocentrum minimum | 39449 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.37e-20 | NTclustered | gi|727705467|gb|KJ078642.1| | 39449 | g11720 | i0 | 75 | 9.06211180124224 | 272 | 54 | 83 | 11 | 44 | 311 | 989 | 728 | Prorocentrum minimum strain D-127 calreticulin 2 (crt2) mRNA, complete cds | blastn | 2918 | 113 | 1 | Eukaryota | Sar | Dinophyceae | Prorocentrales | Prorocentraceae | Prorocentrum | Prorocentrum minimum | |||
| 25227076 | 25227076 | PRJNA1002816_P_NODE_15120_length_279_cov_1.490291_g14960_i0 | PRJNA1002816 | 15120 | 279 | 1.490291 | 4.15791189 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.47e-34 | NTclustered | gi|813156379|ref|XM_012346149.1| | 695850 | g14960 | i0 | 83.237 | 3.56989247311828 | 173 | 29 | 62 | 0 | 107 | 279 | 439 | 267 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 996 | 159 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica |
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);;