contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA408129" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 418279 | 418279 | PRJNA408129_S_NODE_11161_length_214_cov_29.361582_g11143_i0 | PRJNA408129 | 11161 | 214 | 29.361582 | 62.83378548 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 2.94e-50 | NTclustered | gi|1378171755|ref|XM_024720355.1| | 4781 | g11143 | i0 | 93.056 | 2.27102803738318 | 144 | 10 | 67 | 0 | 46 | 189 | 477 | 334 | Plasmopara halstedii CRN-like protein (PHALS_06969), partial mRNA | blastn | 486 | 211 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 418439 | 418439 | PRJNA408129_S_NODE_2761_length_310_cov_11.073260_g2743_i0 | PRJNA408129 | 2761 | 310 | 11.07326 | 34.327106 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.73e-4 | NTclustered | gi|921131233|ref|XM_013584698.1| | 51315 | g2743 | i0 | 97.143 | 0.112903225806452 | 35 | 1 | 11 | 0 | 115 | 149 | 1443 | 1477 | Eimeria necatrix hypothetical protein, conserved partial mRNA | blastn | 35 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 1082700 | 1082700 | PRJNA408129_S_NODE_13821_length_200_cov_14.601227_g13803_i0 | PRJNA408129 | 13821 | 200 | 14.601227 | 29.202454 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 9.209999999999999e-90 | NTclustered | gi|2792507|gb|AF042107.1| | 5802 | g13803 | i0 | 98.958 | 91.385 | 192 | 1 | 96 | 1 | 1 | 191 | 847 | 656 | Eimeria tenella ribosomal protein S3a mRNA, complete cds | blastn | 18277 | 342 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 1082736 | 1082736 | PRJNA408129_S_NODE_34741_length_151_cov_5.491228_g34723_i0 | PRJNA408129 | 34741 | 151 | 5.4912280000000004 | 8.29175428 | Oxytricha | 5943 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 1.89e-60 | NTclustered | gi|1859609462|gb|MT640772.1| | 305490 | g34723 | i0 | 97.872 | 93.3774834437086 | 141 | 3 | 93 | 0 | 11 | 151 | 11 | 151 | Uncultured Hypotrichia clone OTU55.1 large subunit ribosomal RNA gene, partial sequence | blastn | 14100 | 244 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | uncultured Hypotrichia | |||||
| 1082755 | 1082755 | PRJNA408129_S_NODE_761_length_408_cov_13.568733_g743_i0 | PRJNA408129 | 761 | 408 | 13.568733 | 55.36043064 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 610 | 5.15e-170 | NTclustered | gi|2651589115|gb|PP108238.1| | 4785 | g743 | i0 | 97.479 | 91.031862745098 | 357 | 9 | 88 | 0 | 22 | 378 | 23130 | 22774 | Phytophthora cinnamomi strain CT09CHAP1 mitochondrion, complete genome | blastn | 37141 | 616 | 0.99025974025974 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 2969105 | 2969105 | PRJNA408129_S_NODE_18363_length_183_cov_5.513699_g18345_i0 | PRJNA408129 | 18363 | 183 | 5.513699 | 10.09006917 | Ciliophrys infusionum | 38824 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 2e-6 | NTclustered | gi|612134634|dbj|AB846664.1| | 38824 | g18345 | i0 | 97.368 | 19.7049180327869 | 38 | 1 | 21 | 0 | 146 | 183 | 8063 | 8100 | Ciliophrys infusionum DNA, ubiquitin specific peptidase 39, ubiquitin conjugating enzyme 12, pseudogenes of 18S ribosomal RNA, 5.8S ribosomal RNA, 28S ribosomal RNA, strain: YPF1207 | blastn | 3606 | 65.8 | 1 | Eukaryota | Sar | Dictyochophyceae | Rhizochromulinales | Ciliophryaceae | Ciliophrys | Ciliophrys infusionum | |||
| 3633630 | 3633630 | PRJNA408129_S_NODE_35783_length_150_cov_3.000000_g35765_i0 | PRJNA408129 | 35783 | 150 | 3 | 4.5 | Lotharella | 74819 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 1.55e-16 | NTclustered | gi|220983373|dbj|AB453009.1| | 74820 | g35765 | i0 | 81.452 | 30.9266666666667 | 124 | 20 | 81 | 3 | 15 | 136 | 3098 | 2976 | Lotharella vacuolata gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 4639 | 99 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Lotharella | Lotharella vacuolata | ||||
| 5522169 | 5522169 | PRJNA408129_S_NODE_19265_length_181_cov_1.798611_g19247_i0 | PRJNA408129 | 19265 | 181 | 1.798611 | 3.25548591 | Heterosigma akashiwo | 2829 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 5.19e-47 | NTclustered | gi|189095288|ref|NC_010772.1| | 2829 | g19247 | i0 | 87.791 | 124.314917127072 | 172 | 20 | 94 | 1 | 11 | 181 | 3425 | 3596 | Heterosigma akashiwo chloroplast, complete genome | blastn | 22501 | 200 | 1 | Eukaryota | Sar | Raphidophyceae | Chattonellales | Chattonellaceae | Heterosigma | Heterosigma akashiwo | |||
| 6796211 | 6796211 | PRJNA408129_S_NODE_2746_length_311_cov_3.791971_g2728_i0 | PRJNA408129 | 2746 | 311 | 3.791971 | 11.79302981 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.1799999999999999e-23 | NTclustered | gi|47176510|gb|AY618090.1| | 94289 | g2728 | i0 | 88.889 | 12.1736334405145 | 99 | 11 | 32 | 0 | 24 | 122 | 385 | 287 | Sterkiella histriomuscorum clone UGC1O0004_I02_R genomic sequence | blastn | 3786 | 122 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 8071664 | 8071664 | PRJNA408129_S_NODE_20047_length_179_cov_1.091549_g20029_i0 | PRJNA408129 | 20047 | 179 | 1.091549 | 1.95387271 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 4.19e-8 | NTclustered | gi|2794739894|ref|XM_067964161.1| | 4779 | g20029 | i0 | 85.294 | 0.379888268156425 | 68 | 10 | 38 | 0 | 110 | 177 | 449 | 382 | Bremia lactucae uncharacterized protein (CCR75_006089), partial mRNA | blastn | 68 | 71.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 11286077 | 11286077 | PRJNA408129_S_NODE_6229_length_251_cov_43.733645_g6211_i0 | PRJNA408129 | 6229 | 251 | 43.733645 | 109.77144895 | root | 1 | Root_unresolved | Root_unresolved | 388 | 1.5299999999999998e-103 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g6211 | i0 | 99.078 | 77.2231075697211 | 217 | 1 | 86 | 1 | 28 | 243 | 8330 | 8114 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 19383 | 388 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 11897160 | 11897160 | PRJNA408129_S_NODE_10550_length_218_cov_4.348066_g10532_i0 | PRJNA408129 | 10550 | 218 | 4.348066 | 9.47878388 | Platyophryides magnus | 1003332 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 4.7499999999999994e-88 | NTclustered | gi|328684914|gb|HM122030.1| | 1003332 | g10532 | i0 | 94.954 | 98.8348623853211 | 218 | 6 | 99 | 5 | 3 | 218 | 49 | 263 | Platyophryides magnus isolate SNK09112401 macronuclear | blastn | 21546 | 337 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Cyrtolophosidida | Platyophryidae | Platyophryides | Platyophryides magnus | ||
| 11897192 | 11897192 | PRJNA408129_S_NODE_14210_length_199_cov_2.320988_g14192_i0 | PRJNA408129 | 14210 | 199 | 2.320988 | 4.61876612 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.75e-35 | NTclustered | gi|673051696|ref|XM_008881587.1| | 157072 | g14192 | i0 | 86.486 | 17.0050251256281 | 148 | 18 | 74 | 2 | 52 | 198 | 615 | 469 | Aphanomyces invadans 40S ribosomal protein mRNA | blastn | 3384 | 161 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 13172244 | 13172244 | PRJNA408129_S_NODE_3471_length_293_cov_21794.503906_g3453_i0 | PRJNA408129 | 3471 | 293 | 21794.503906 | 63857.89644458 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 6.699999999999997e-88 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g3453 | i0 | 97.475 | 29.3617747440273 | 198 | 4 | 67 | 1 | 13 | 209 | 511 | 708 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 8603 | 337 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 14447467 | 14447467 | PRJNA408129_S_NODE_8332_length_233_cov_4.168367_g8314_i0 | PRJNA408129 | 8332 | 233 | 4.168367 | 9.71229511 | Paramecium polycaryum | 109354 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.9199999999999994e-99 | NTclustered | gi|1409630804|gb|MG953266.1| | 109354 | g8314 | i0 | 98.14 | 90.2231759656652 | 215 | 2 | 91 | 1 | 15 | 227 | 586 | 800 | Paramecium polycaryum isolate ChY12-6 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 21022 | 374 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium polycaryum | ||
| 15721235 | 15721235 | PRJNA408129_S_NODE_6593_length_248_cov_4.815166_g6575_i0 | PRJNA408129 | 6593 | 248 | 4.815166 | 11.94161168 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 8.93e-111 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g6575 | i0 | 97.908 | 100.379032258065 | 239 | 4 | 96 | 1 | 1 | 239 | 9213 | 9450 | Pythium ultimum mitochondrion, complete genome | blastn | 24894 | 412 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 16995924 | 16995924 | PRJNA408129_S_NODE_3034_length_303_cov_29.409774_g3016_i0 | PRJNA408129 | 3034 | 303 | 29.409774 | 89.11161522 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.44e-114 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3016 | i0 | 94.565 | 8.42904290429043 | 276 | 13 | 91 | 2 | 17 | 291 | 362 | 88 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2554 | 425 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17660313 | 17660313 | PRJNA408129_S_NODE_32414_length_154_cov_9.333333_g32396_i0 | PRJNA408129 | 32414 | 154 | 9.333333 | 14.37333282 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 2.48e-69 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g32396 | i0 | 98.701 | 97.8701298701299 | 154 | 2 | 100 | 0 | 1 | 154 | 2782 | 2935 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 15072 | 274 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 18270176 | 18270176 | PRJNA408129_S_NODE_7795_length_237_cov_19.615000_g7777_i0 | PRJNA408129 | 7795 | 237 | 19.615 | 46.48755 | uncultured stramenopile | 152704 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 5.79e-18 | NTclustered | gi|316990812|gb|HQ222507.1| | 152704 | g7777 | i0 | 77.841 | 7.07172995780591 | 176 | 34 | 73 | 5 | 16 | 188 | 405 | 232 | Uncultured stramenopile clone AN0680S06 18S ribosomal RNA gene, partial sequence | blastn | 1676 | 104 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 20208892 | 20208892 | PRJNA408129_S_NODE_1996_length_333_cov_70.577703_g1978_i0 | PRJNA408129 | 1996 | 333 | 70.577703 | 235.02375099 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.53e-149 | NTclustered | gi|440919553|gb|JX436353.1| | 1279233 | g1978 | i0 | 98.071 | 92.981981981982 | 311 | 6 | 93 | 0 | 20 | 330 | 33 | 343 | Myzocytiopsis sp. GPR-2013 28S ribosomal RNA gene, partial sequence | blastn | 30963 | 542 | 1 | Eukaryota | Sar | Oomycota | Myzocytiopsidales | Myzocytiopsidaceae | Myzocytiopsis | Myzocytiopsis sp. GPR-2013 | |||
| 22094859 | 22094859 | PRJNA408129_S_NODE_27658_length_162_cov_2.232000_g27640_i0 | PRJNA408129 | 27658 | 162 | 2.232 | 3.61584 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 1.73e-6 | NTclustered | gi|673042468|ref|XM_008876973.1| | 157072 | g27640 | i0 | 97.368 | 0.234567901234568 | 38 | 1 | 23 | 0 | 2 | 39 | 653 | 690 | Aphanomyces invadans hypothetical protein mRNA | blastn | 38 | 65.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 22759734 | 22759734 | PRJNA408129_S_NODE_27958_length_161_cov_5.766129_g27940_i0 | PRJNA408129 | 27958 | 161 | 5.766129 | 9.28346769 | root | 1 | Root_unresolved | Root_unresolved | 235 | 1.24e-57 | NTclustered | gi|833494852|ref|XM_012915026.1| | 5866 | g27940 | i0 | 96.503 | 133.540372670807 | 143 | 3 | 89 | 2 | 5 | 147 | 46 | 186 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 21500 | 235 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 25308892 | 25308892 | PRJNA408129_S_NODE_22820_length_171_cov_50.328358_g22802_i0 | PRJNA408129 | 22820 | 171 | 50.328358 | 86.06149218 | Lagenidium | 4802 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 2.17e-70 | NTclustered | gi|319769386|gb|HQ343198.1| | 884622 | g22802 | i0 | 99.346 | 89.9181286549708 | 153 | 1 | 89 | 0 | 15 | 167 | 544 | 696 | Lagenidium sp. PWL-2010f strain CBS 127284 18S ribosomal RNA gene, partial sequence | blastn | 15376 | 278 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium sp. PWL-2010f |
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);;