contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA796753" and tax_phylum = "Oomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 780702 | 780702 | PRJNA796753_P_NODE_3941_length_672_cov_5.522538_g3642_i0 | PRJNA796753 | 3941 | 672 | 5.522538 | 37.11145536 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 433 | 2.05e-116 | NTclustered | gi|695389557|ref|XM_009521174.1| | 67593 | g3642 | i0 | 87.139 | 305.924107142857 | 381 | 49 | 57 | 0 | 3 | 383 | 544 | 924 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 205581 | 433 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 9708865 | 9708865 | PRJNA796753_P_NODE_208_length_1967_cov_4.329461_g177_i0 | PRJNA796753 | 208 | 1967 | 4.329461 | 85.16049787 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 3.76e-108 | NTclustered | gi|2795048880|ref|XM_067943659.1| | 4785 | g177 | i0 | 83.036 | 23.3431621759024 | 448 | 76 | 23 | 0 | 76 | 523 | 1 | 448 | Phytophthora cinnamomi Calmodulin (IUM83_18649), partial mRNA | blastn | 45916 | 407 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9709062 | 9709062 | PRJNA796753_P_NODE_52988_length_242_cov_0.911243_g52676_i0 | PRJNA796753 | 52988 | 242 | 0.911243 | 2.20520806 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.2499999999999999e-34 | NTclustered | gi|166041590|emb|CU357622.1| | 100861 | g52676 | i0 | 79.817 | 10.198347107438 | 218 | 44 | 90 | 0 | 24 | 241 | 364 | 147 | Aphanomyces euteiches cDNA | blastn | 2468 | 159 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 10145259 | 10145259 | PRJNA796753_P_NODE_5248_length_589_cov_0.736434_g4941_i0 | PRJNA796753 | 5248 | 589 | 0.736434 | 4.33759626 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 1.75e-126 | NTclustered | gi|2795027172|ref|XM_067926257.1| | 4785 | g4941 | i0 | 83.951 | 47.5517826825127 | 486 | 78 | 83 | 0 | 70 | 555 | 1473 | 988 | Phytophthora cinnamomi citrate (Si)-synthase, eukaryotic (IUM83_02347), partial mRNA | blastn | 28008 | 470 | 0.991489361702128 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 10145269 | 10145269 | PRJNA796753_P_NODE_6208_length_543_cov_2.651064_g5900_i0 | PRJNA796753 | 6208 | 543 | 2.651064 | 14.39527752 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 2.85e-84 | NTclustered | gi|2795040529|ref|XM_067944818.1| | 4785 | g5900 | i0 | 83.429 | 63.6022099447514 | 350 | 58 | 64 | 0 | 77 | 426 | 77 | 426 | Phytophthora cinnamomi 60S ribosomal protein L23 (IUM83_19754), partial mRNA | blastn | 34536 | 329 | 0.990881458966565 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 10984689 | 10984689 | PRJNA796753_P_NODE_36029_length_260_cov_1.374332_g35717_i0 | PRJNA796753 | 36029 | 260 | 1.374332 | 3.5732632 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 3.72e-45 | NTclustered | gi|2794885911|ref|XM_067885836.1| | 164328 | g35717 | i0 | 89.172 | 34.6307692307692 | 157 | 15 | 60 | 2 | 100 | 255 | 189 | 34 | Phytophthora ramorum 60S ribosomal protein L27a (KRP23_1503), partial mRNA | blastn | 9004 | 195 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 12260282 | 12260282 | PRJNA796753_P_NODE_44450_length_248_cov_0.880000_g44138_i0 | PRJNA796753 | 44450 | 248 | 0.88 | 2.1824 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2794711540|ref|XM_067958869.1| | 4779 | g44138 | i0 | 100 | 0.116935483870968 | 29 | 0 | 12 | 0 | 50 | 78 | 1337 | 1309 | Bremia lactucae uncharacterized protein (CCR75_000763), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 13534244 | 13534244 | PRJNA796753_P_NODE_14131_length_377_cov_1.763158_g13819_i0 | PRJNA796753 | 14131 | 377 | 1.763158 | 6.64710566 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 5.48e-65 | NTclustered | gi|2795024423|ref|XM_067938288.1| | 4785 | g13819 | i0 | 79.63 | 77.1856763925729 | 378 | 65 | 99 | 10 | 1 | 372 | 372 | 1 | Phytophthora cinnamomi 60S ribosomal protein (IUM83_13598), partial mRNA | blastn | 29099 | 261 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 13534314 | 13534314 | PRJNA796753_P_NODE_24411_length_303_cov_2.343478_g24099_i0 | PRJNA796753 | 24411 | 303 | 2.343478 | 7.10073834 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.99e-68 | NTclustered | gi|2794882649|ref|XM_067895061.1| | 164328 | g24099 | i0 | 83.916 | 44.478547854785504 | 286 | 44 | 94 | 2 | 19 | 303 | 546 | 262 | Phytophthora ramorum ADP-ribosylation factor (KRP23_969), partial mRNA | blastn | 13477 | 272 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 13534540 | 13534540 | PRJNA796753_P_NODE_7511_length_497_cov_3.561321_g7200_i0 | PRJNA796753 | 7511 | 497 | 3.561321 | 17.69976537 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 544 | 6.57e-150 | NTclustered | gi|166303|gb|J05116.1|ACKCAL | 4767 | g7200 | i0 | 88.326 | 89.1629778672032 | 454 | 51 | 91 | 2 | 14 | 466 | 493 | 945 | A.klebsiana calmodulin gene, complete cds | blastn | 44314 | 544 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 13970577 | 13970577 | PRJNA796753_P_NODE_13771_length_381_cov_2.000000_g13459_i0 | PRJNA796753 | 13771 | 381 | 2 | 7.62 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 7.81e-4 | NTclustered | gi|169305|gb|M83535.1|PHTCALPIA | 4787 | g13459 | i0 | 100 | 1.27296587926509 | 31 | 0 | 8 | 0 | 351 | 381 | 1171 | 1141 | P.infestans calmodulin (calA) gene, complete cds | blastn | 485 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 18632265 | 18632265 | PRJNA796753_P_NODE_4935_length_606_cov_1.515947_g4629_i0 | PRJNA796753 | 4935 | 606 | 1.515947 | 9.18663882 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 3.37e-49 | NTclustered | gi|669167679|ref|XM_008621180.1| | 1156394 | g4629 | i0 | 81.041 | 5.4009900990099 | 269 | 45 | 44 | 6 | 32 | 297 | 456 | 721 | Saprolegnia diclina VS20 30S ribosomal protein SAe mRNA | blastn | 3273 | 209 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 19907484 | 19907484 | PRJNA796753_P_NODE_28956_length_283_cov_2.233333_g28644_i0 | PRJNA796753 | 28956 | 283 | 2.233333 | 6.32033239 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 9.07e-27 | NTclustered | gi|813163222|ref|XM_012347282.1| | 695850 | g28644 | i0 | 79.679 | 10.1484098939929 | 187 | 36 | 66 | 2 | 92 | 277 | 323 | 138 | Saprolegnia parasitica CBS 223.65 translation initiation factor eIF-5A mRNA | blastn | 2872 | 134 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 21183226 | 21183226 | PRJNA796753_P_NODE_42937_length_249_cov_0.875000_g42625_i0 | PRJNA796753 | 42937 | 249 | 0.875 | 2.17875 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 2.72e-51 | NTclustered | gi|669155015|ref|XM_008614848.1| | 1156394 | g42625 | i0 | 83.621 | 83.5622489959839 | 232 | 35 | 92 | 3 | 1 | 229 | 263 | 32 | Saprolegnia diclina VS20 actin mRNA | blastn | 20807 | 215 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 21618810 | 21618810 | PRJNA796753_P_NODE_31977_length_273_cov_1.700000_g31665_i0 | PRJNA796753 | 31977 | 273 | 1.7 | 4.641 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 8.219999999999999e-67 | NTclustered | gi|2795048880|ref|XM_067943659.1| | 4785 | g31665 | i0 | 84.502 | 73.9304029304029 | 271 | 40 | 99 | 2 | 1 | 270 | 69 | 338 | Phytophthora cinnamomi Calmodulin (IUM83_18649), partial mRNA | blastn | 20183 | 267 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 22457754 | 22457754 | PRJNA796753_P_NODE_16698_length_353_cov_1.100000_g16386_i0 | PRJNA796753 | 16698 | 353 | 1.1 | 3.883 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 8.410000000000001e-73 | NTclustered | gi|2795041536|ref|XM_067930708.1| | 4785 | g16386 | i0 | 81.844 | 5.61756373937677 | 347 | 57 | 97 | 6 | 10 | 353 | 1005 | 662 | Phytophthora cinnamomi NADH dehydrogenase [ubiquinone] flavoprotein 1, mitochondrial (IUM83_06496), partial mRNA | blastn | 1983 | 287 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 22457756 | 22457756 | PRJNA796753_P_NODE_16838_length_351_cov_7.859712_g16526_i0 | PRJNA796753 | 16838 | 351 | 7.859712 | 27.58758912 | Pythium torulosum | 4799 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 1.1399999999999999e-31 | NTclustered | gi|1780534029|gb|MK753000.1| | 4799 | g16526 | i0 | 89.744 | 28.8547008547009 | 117 | 12 | 33 | 0 | 1 | 117 | 1205 | 1321 | Pythium torulosum isolate MISO_8-29.1 beta-tubulin mRNA, complete cds | blastn | 10128 | 150 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium torulosum | ||
| 25007050 | 25007050 | PRJNA796753_P_NODE_1960_length_915_cov_2.808789_g1723_i0 | PRJNA796753 | 1960 | 915 | 2.808789 | 25.70041935 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 435 | 7.86e-117 | NTclustered | gi|2794882649|ref|XM_067895061.1| | 164328 | g1723 | i0 | 82.157 | 55.0950819672131 | 510 | 87 | 56 | 4 | 76 | 583 | 37 | 544 | Phytophthora ramorum ADP-ribosylation factor (KRP23_969), partial mRNA | blastn | 50412 | 435 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 25007212 | 25007212 | PRJNA796753_P_NODE_47520_length_245_cov_1.790698_g47208_i0 | PRJNA796753 | 47520 | 245 | 1.790698 | 4.3872101 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.65e-19 | NTclustered | gi|301114940|ref|XM_002999194.1| | 403677 | g47208 | i0 | 77.778 | 0.971428571428571 | 180 | 36 | 73 | 4 | 1 | 178 | 770 | 593 | Phytophthora infestans T30-4 pyrophosphate-energized vacuolar membrane proton pump, putative (PITG_05615), partial mRNA | blastn | 238 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 25443405 | 25443405 | PRJNA796753_P_NODE_19540_length_332_cov_2.270270_g19228_i0 | PRJNA796753 | 19540 | 332 | 2.27027 | 7.5372964 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 8.159999999999998e-48 | NTclustered | gi|695460914|ref|XM_009539807.1| | 67593 | g19228 | i0 | 89.441 | 45.9367469879518 | 161 | 17 | 48 | 0 | 1 | 161 | 198 | 358 | Phytophthora sojae hypothetical protein mRNA | blastn | 15251 | 204 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae |
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);;