contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA312615" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1653063 | 1653063 | PRJNA312615_P_NODE_36222_length_204_cov_1.316129_g36071_i0 | PRJNA312615 | 36222 | 204 | 1.316129 | 2.68490316 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 5.8e-72 | NTclustered | gi|698826681|ref|XM_009848067.1| | 112090 | g36071 | i0 | 91.667 | 2.73039215686275 | 204 | 17 | 100 | 0 | 1 | 204 | 265 | 468 | Aphanomyces astaci ribosomal protein S4 mRNA | blastn | 557 | 283 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 2339327 | 2339327 | PRJNA312615_P_NODE_48982_length_171_cov_1.278689_g48831_i0 | PRJNA312615 | 48982 | 171 | 1.278689 | 2.18655819 | root | 1 | Root_unresolved | Root_unresolved | 316 | 4.6e-82 | NTclustered | gi|2845540150|gb|PQ478072.1| | 4796 | g48831 | i0 | 100 | 99.5438596491228 | 171 | 0 | 100 | 0 | 1 | 171 | 375 | 545 | Phytophthora palmivora clone BAX_control_positivo_de_HR_donado BAX protein (BAX) gene, complete cds | blastn | 17022 | 316 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 2929242 | 2929242 | PRJNA312615_P_NODE_51663_length_167_cov_0.864407_g51512_i0 | PRJNA312615 | 51663 | 167 | 0.864407 | 1.44355969 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 1.77e-16 | NTclustered | gi|813135523|ref|XM_012343129.1| | 695850 | g51512 | i0 | 91.549 | 2.83832335329341 | 71 | 6 | 43 | 0 | 25 | 95 | 2186 | 2116 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 474 | 99 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 4205083 | 4205083 | PRJNA312615_P_NODE_1764_length_812_cov_5.431193_g1648_i0 | PRJNA312615 | 1764 | 812 | 5.431193 | 44.10128716 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 1.59e-73 | NTclustered | gi|2795027182|ref|XM_067926253.1| | 4785 | g1648 | i0 | 76.382 | 30.4088669950739 | 597 | 107 | 71 | 27 | 203 | 779 | 583 | 1 | Phytophthora cinnamomi 40S ribosomal protein S8 (IUM83_02343), partial mRNA | blastn | 24692 | 291 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 6755496 | 6755496 | PRJNA312615_P_NODE_16366_length_303_cov_2.807087_g16215_i0 | PRJNA312615 | 16366 | 303 | 2.807087 | 8.50547361 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.69e-37 | NTclustered | gi|669153141|ref|XM_008613911.1| | 1156394 | g16215 | i0 | 86.452 | 28.6336633663366 | 155 | 19 | 51 | 2 | 1 | 154 | 367 | 214 | Saprolegnia diclina VS20 60S ribosomal protein mRNA | blastn | 8676 | 169 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 6755949 | 6755949 | PRJNA312615_P_NODE_36206_length_204_cov_1.316129_g36055_i0 | PRJNA312615 | 36206 | 204 | 1.316129 | 2.68490316 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.6199999999999998e-67 | NTclustered | gi|166038692|emb|CU352740.1| | 100861 | g36055 | i0 | 90.594 | 4.36274509803922 | 202 | 19 | 99 | 0 | 3 | 204 | 907 | 706 | Aphanomyces euteiches cDNA | blastn | 890 | 268 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 6756210 | 6756210 | PRJNA312615_P_NODE_4906_length_542_cov_2.062880_g4760_i0 | PRJNA312615 | 4906 | 542 | 2.06288 | 11.1808096 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 5.11e-32 | NTclustered | gi|669145241|ref|XM_008609961.1| | 1156394 | g4760 | i0 | 75.692 | 28.3892988929889 | 325 | 67 | 59 | 10 | 2 | 320 | 134 | 452 | Saprolegnia diclina VS20 50S ribosomal protein L22e mRNA | blastn | 15387 | 152 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 8031517 | 8031517 | PRJNA312615_P_NODE_36787_length_202_cov_2.307190_g36636_i0 | PRJNA312615 | 36787 | 202 | 2.30719 | 4.6605238 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 5.69e-77 | NTclustered | gi|673038061|ref|XM_008874770.1| | 157072 | g36636 | i0 | 93.939 | 3.8019801980198 | 198 | 12 | 98 | 0 | 1 | 198 | 79 | 276 | Aphanomyces invadans 60S ribosomal protein L38 mRNA | blastn | 768 | 300 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 8031565 | 8031565 | PRJNA312615_P_NODE_39227_length_196_cov_1.040816_g39076_i0 | PRJNA312615 | 39227 | 196 | 1.040816 | 2.03999936 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 2.7199999999999997e-30 | NTclustered | gi|675188148|ref|XM_008904711.1| | 761204 | g39076 | i0 | 80.645 | 1.74489795918367 | 186 | 36 | 95 | 0 | 1 | 186 | 2080 | 2265 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 342 | 145 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 8031605 | 8031605 | PRJNA312615_P_NODE_4127_length_583_cov_6.361423_g3985_i0 | PRJNA312615 | 4127 | 583 | 6.361423 | 37.08709609 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 2.4100000000000003e-75 | NTclustered | gi|698822976|ref|XM_009846215.1| | 112090 | g3985 | i0 | 78.288 | 58.7907375643225 | 479 | 90 | 81 | 11 | 22 | 494 | 57 | 527 | Aphanomyces astaci 40S ribosomal protein S13 mRNA | blastn | 34275 | 296 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8031978 | 8031978 | PRJNA312615_P_NODE_6287_length_486_cov_1.425629_g6139_i0 | PRJNA312615 | 6287 | 486 | 1.425629 | 6.92855694 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 1.94e-90 | NTclustered | gi|2795040529|ref|XM_067944818.1| | 4785 | g6139 | i0 | 81.971 | 73.2201646090535 | 416 | 67 | 85 | 6 | 30 | 441 | 426 | 15 | Phytophthora cinnamomi 60S ribosomal protein L23 (IUM83_19754), partial mRNA | blastn | 35585 | 346 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 11856610 | 11856610 | PRJNA312615_P_NODE_21110_length_265_cov_1.865741_g20959_i0 | PRJNA312615 | 21110 | 265 | 1.865741 | 4.94421365 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 2.92e-51 | NTclustered | gi|695404622|ref|XM_009525283.1| | 67593 | g20959 | i0 | 81.961 | 80.7433962264151 | 255 | 44 | 96 | 2 | 3 | 256 | 1241 | 988 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 21397 | 215 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 13131503 | 13131503 | PRJNA312615_P_NODE_12511_length_349_cov_4.303333_g12361_i0 | PRJNA312615 | 12511 | 349 | 4.303333 | 15.01863217 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 1.7999999999999998e-69 | NTclustered | gi|166052859|emb|CU367305.1| | 100861 | g12361 | i0 | 80.98 | 42.2206303724928 | 347 | 66 | 99 | 0 | 1 | 347 | 540 | 886 | Aphanomyces euteiches cDNA | blastn | 14735 | 276 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13132045 | 13132045 | PRJNA312615_P_NODE_38251_length_198_cov_2.382550_g38100_i0 | PRJNA312615 | 38251 | 198 | 2.38255 | 4.717449 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 5.79e-47 | NTclustered | gi|669159105|ref|XM_008616893.1| | 1156394 | g38100 | i0 | 84.848 | 3.47979797979798 | 198 | 30 | 100 | 0 | 1 | 198 | 250 | 447 | Saprolegnia diclina VS20 50S ribosomal protein L13 mRNA | blastn | 689 | 200 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 14406719 | 14406719 | PRJNA312615_P_NODE_14672_length_320_cov_4.656827_g14521_i0 | PRJNA312615 | 14672 | 320 | 4.656827 | 14.9018464 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 1.27e-65 | NTclustered | gi|813119301|ref|XM_012340833.1| | 695850 | g14521 | i0 | 82.508 | 88.05625 | 303 | 50 | 94 | 3 | 3 | 303 | 633 | 934 | Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA | blastn | 28178 | 263 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14407188 | 14407188 | PRJNA312615_P_NODE_34892_length_207_cov_8.196203_g34741_i0 | PRJNA312615 | 34892 | 207 | 8.196203 | 16.96614021 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.34e-33 | NTclustered | gi|669165645|ref|XM_008620163.1| | 1156394 | g34741 | i0 | 82.857 | 3.48792270531401 | 175 | 28 | 84 | 2 | 4 | 177 | 278 | 105 | Saprolegnia diclina VS20 caltractin mRNA | blastn | 722 | 156 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 15680747 | 15680747 | PRJNA312615_P_NODE_2153_length_755_cov_2.924929_g2031_i0 | PRJNA312615 | 2153 | 755 | 2.924929 | 22.08321395 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 616 | 2.1399999999999995e-171 | NTclustered | gi|669151349|ref|XM_008613015.1| | 1156394 | g2031 | i0 | 83.161 | 92.0649006622517 | 677 | 110 | 89 | 4 | 81 | 755 | 1543 | 869 | Saprolegnia diclina VS20 adenosylhomocysteinase mRNA | blastn | 69509 | 616 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 15680951 | 15680951 | PRJNA312615_P_NODE_31373_length_218_cov_1.786982_g31222_i0 | PRJNA312615 | 31373 | 218 | 1.786982 | 3.89562076 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 5.099999999999999e-38 | NTclustered | gi|695462293|ref|XM_009540118.1| | 67593 | g31222 | i0 | 80.734 | 2.87155963302752 | 218 | 42 | 100 | 0 | 1 | 218 | 609 | 392 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 626 | 171 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 16955830 | 16955830 | PRJNA312615_P_NODE_43694_length_185_cov_1.125000_g43543_i0 | PRJNA312615 | 43694 | 185 | 1.125 | 2.08125 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 4.01e-68 | NTclustered | gi|166035484|emb|CU354363.1| | 100861 | g43543 | i0 | 92.973 | 99.9675675675676 | 185 | 13 | 100 | 0 | 1 | 185 | 643 | 459 | Aphanomyces euteiches cDNA | blastn | 18494 | 270 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 24604719 | 24604719 | PRJNA312615_P_NODE_5700_length_508_cov_1.664488_g5552_i0 | PRJNA312615 | 5700 | 508 | 1.664488 | 8.45559904 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 4.38e-92 | NTclustered | gi|2795045367|ref|XM_067939679.1| | 4785 | g5552 | i0 | 79.417 | 83.1653543307087 | 515 | 92 | 100 | 14 | 1 | 508 | 527 | 1034 | Phytophthora cinnamomi transitional endoplasmic reticulum ATPase (IUM83_14904), partial mRNA | blastn | 42248 | 351 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 24604842 | 24604842 | PRJNA312615_P_NODE_8220_length_429_cov_6.731579_g8070_i0 | PRJNA312615 | 8220 | 429 | 6.731579 | 28.87847391 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 1.2799999999999998e-106 | NTclustered | gi|2794923360|ref|XM_067881981.1| | 164328 | g8070 | i0 | 83.933 | 94.3310023310023 | 417 | 67 | 97 | 0 | 8 | 424 | 450 | 34 | Phytophthora ramorum Calmodulin (KRP23_11430), partial mRNA | blastn | 40468 | 399 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum |
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);;