contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA811237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 808830 | 808830 | PRJNA811237_S_NODE_9121_length_252_cov_2.064039_g8881_i0 | PRJNA811237 | 9121 | 252 | 2.064039 | 5.20137828 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.01e-35 | NTclustered | gi|669165645|ref|XM_008620163.1| | 1156394 | g8881 | i0 | 80.269 | 3.3968253968254 | 223 | 38 | 87 | 5 | 9 | 228 | 324 | 105 | Saprolegnia diclina VS20 caltractin mRNA | blastn | 856 | 163 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 3359676 | 3359676 | PRJNA811237_S_NODE_14643_length_211_cov_3.672840_g14403_i0 | PRJNA811237 | 14643 | 211 | 3.67284 | 7.7496924 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.3899999999999998e-23 | NTclustered | gi|2795047393|ref|XM_067937896.1| | 4785 | g14403 | i0 | 87.156 | 1.41706161137441 | 109 | 12 | 51 | 2 | 51 | 158 | 117 | 10 | Phytophthora cinnamomi Nucleoside diphosphate kinase B (IUM83_13233), partial mRNA | blastn | 299 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9736903 | 9736903 | PRJNA811237_S_NODE_3308_length_397_cov_3.402299_g3068_i0 | PRJNA811237 | 3308 | 397 | 3.402299 | 13.50712703 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 4.45e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g3068 | i0 | 80.533 | 85.2090680100756 | 375 | 65 | 93 | 4 | 10 | 377 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 11012746 | 11012746 | PRJNA811237_S_NODE_489_length_970_cov_2.916395_g320_i0 | PRJNA811237 | 489 | 970 | 2.916395 | 28.2890315 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 649 | 0 | NTclustered | gi|2795016949|ref|XM_067930458.1| | 4785 | g320 | i0 | 80.828 | 79.1515463917526 | 845 | 147 | 86 | 14 | 17 | 853 | 83 | 920 | Phytophthora cinnamomi protein transporter Sec61 subunit alpha isoform 2 (IUM83_06269), partial mRNA | blastn | 76777 | 649 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 14837024 | 14837024 | PRJNA811237_S_NODE_30032_length_165_cov_0.879310_g29792_i0 | PRJNA811237 | 30032 | 165 | 0.87931 | 1.4508615 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 1.71e-31 | NTclustered | gi|698796373|ref|XM_009832914.1| | 112090 | g29792 | i0 | 85.816 | 0.854545454545454 | 141 | 18 | 85 | 2 | 3 | 142 | 762 | 901 | Aphanomyces astaci hypothetical protein mRNA | blastn | 141 | 148 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 16111207 | 16111207 | PRJNA811237_S_NODE_14493_length_212_cov_1.877301_g14253_i0 | PRJNA811237 | 14493 | 212 | 1.877301 | 3.97987812 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 6.29e-47 | NTclustered | gi|2794921684|ref|XM_067881073.1| | 164328 | g14253 | i0 | 83.886 | 7.74056603773585 | 211 | 32 | 99 | 2 | 3 | 212 | 1332 | 1123 | Phytophthora ramorum Citrate synthase, mitochondrial (KRP23_10605), partial mRNA | blastn | 1641 | 200 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 17387125 | 17387125 | PRJNA811237_S_NODE_20374_length_188_cov_1.143885_g20134_i0 | PRJNA811237 | 20374 | 188 | 1.143885 | 2.1505038 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.016 | NTclustered | gi|675181664|ref|XM_008901469.1| | 761204 | g20134 | i0 | 100 | 0.297872340425532 | 28 | 0 | 15 | 0 | 79 | 106 | 625 | 598 | Phytophthora parasitica INRA-310 hypothetical protein partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 17387163 | 17387163 | PRJNA811237_S_NODE_3234_length_402_cov_3.711048_g2994_i0 | PRJNA811237 | 3234 | 402 | 3.711048 | 14.91841296 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 6.36e-10 | NTclustered | gi|673049422|ref|XM_008880450.1| | 157072 | g2994 | i0 | 95.833 | 0.477611940298507 | 48 | 2 | 12 | 0 | 204 | 251 | 3171 | 3218 | Aphanomyces invadans hypothetical protein, variant 2 mRNA | blastn | 192 | 78.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 17801155 | 17801155 | PRJNA811237_S_NODE_9914_length_244_cov_1.046154_g9674_i0 | PRJNA811237 | 9914 | 244 | 1.046154 | 2.55261576 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 3.48e-40 | NTclustered | gi|695434207|ref|XM_009533074.1| | 67593 | g9674 | i0 | 83.77 | 5.75409836065574 | 191 | 27 | 77 | 4 | 25 | 213 | 189 | 1 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 1404 | 178 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 18660186 | 18660186 | PRJNA811237_S_NODE_1235_length_645_cov_2.585570_g1014_i0 | PRJNA811237 | 1235 | 645 | 2.58557 | 16.6769265 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 4.43e-83 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g1014 | i0 | 78.476 | 39.1085271317829 | 525 | 90 | 79 | 22 | 11 | 522 | 716 | 202 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 25225 | 322 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 19935398 | 19935398 | PRJNA811237_S_NODE_13836_length_216_cov_1.209581_g13596_i0 | PRJNA811237 | 13836 | 216 | 1.209581 | 2.61269496 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 3.93e-34 | NTclustered | gi|166041637|emb|CU357669.1| | 100861 | g13596 | i0 | 80.905 | 24.7268518518519 | 199 | 38 | 92 | 0 | 13 | 211 | 721 | 523 | Aphanomyces euteiches cDNA | blastn | 5341 | 158 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 19935403 | 19935403 | PRJNA811237_S_NODE_15396_length_208_cov_1.283019_g15156_i0 | PRJNA811237 | 15396 | 208 | 1.283019 | 2.66867952 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 8.07e-36 | NTclustered | gi|2795025992|ref|XM_067924992.1| | 4785 | g15156 | i0 | 83.616 | 18.6682692307692 | 177 | 25 | 84 | 4 | 34 | 208 | 489 | 663 | Phytophthora cinnamomi chaperonin GroL (IUM83_01160), partial mRNA | blastn | 3883 | 163 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 21210992 | 21210992 | PRJNA811237_S_NODE_21837_length_183_cov_1.253731_g21597_i0 | PRJNA811237 | 21837 | 183 | 1.253731 | 2.29432773 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 7.1e-16 | NTclustered | gi|673046258|ref|XM_008878868.1| | 157072 | g21597 | i0 | 87.059 | 6.83606557377049 | 85 | 11 | 46 | 0 | 60 | 144 | 246 | 162 | Aphanomyces invadans 14-3-3-like protein mRNA | blastn | 1251 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 22485709 | 22485709 | PRJNA811237_S_NODE_5538_length_310_cov_1.758621_g5298_i0 | PRJNA811237 | 5538 | 310 | 1.758621 | 5.4517251 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.66e-34 | NTclustered | gi|166051101|emb|CU363198.1| | 100861 | g5298 | i0 | 80.788 | 7.3 | 203 | 39 | 65 | 0 | 3 | 205 | 558 | 760 | Aphanomyces euteiches cDNA | blastn | 2263 | 159 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 23761380 | 23761380 | PRJNA811237_S_NODE_29579_length_165_cov_3.517241_g29339_i0 | PRJNA811237 | 29579 | 165 | 3.517241 | 5.80344765 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 6.37e-6 | NTclustered | gi|669170970|ref|XM_008622612.1| | 1156394 | g29339 | i0 | 93.182 | 7.98181818181818 | 44 | 1 | 26 | 2 | 30 | 72 | 265 | 223 | Saprolegnia diclina VS20 rab family, other partial mRNA | blastn | 1317 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 25035238 | 25035238 | PRJNA811237_S_NODE_20960_length_186_cov_1.138686_g20720_i0 | PRJNA811237 | 20960 | 186 | 1.138686 | 2.11795596 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 1.15e-48 | NTclustered | gi|695438657|ref|XM_009534219.1| | 67593 | g20720 | i0 | 86.559 | 7.04301075268817 | 186 | 25 | 100 | 0 | 1 | 186 | 617 | 432 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 1310 | 206 | 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);;