contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA666695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 630568 | 630568 | PRJNA666695_S_NODE_128301_length_194_cov_1.202614_g127207_i0 | PRJNA666695 | 128301 | 194 | 1.202614 | 2.33307116 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 4.56e-18 | NTclustered | gi|698783348|ref|XM_009826416.1| | 112090 | g127207 | i0 | 94.118 | 9.97938144329897 | 68 | 4 | 35 | 0 | 2 | 69 | 137 | 70 | Aphanomyces astaci hypothetical protein mRNA | blastn | 1936 | 104 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 632509 | 632509 | PRJNA666695_S_NODE_43841_length_309_cov_2.067164_g42747_i0 | PRJNA666695 | 43841 | 309 | 2.067164 | 6.38753676 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.69e-19 | NTclustered | gi|813218947|ref|XM_012355461.1| | 695850 | g42747 | i0 | 81.818 | 2.48543689320388 | 132 | 22 | 42 | 2 | 148 | 278 | 611 | 481 | Saprolegnia parasitica CBS 223.65 peroxiredoxin mRNA | blastn | 768 | 110 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 4460000 | 4460000 | PRJNA666695_S_NODE_29524_length_358_cov_11.545741_g28431_i0 | PRJNA666695 | 29524 | 358 | 11.545741 | 41.33375278 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.48e-43 | NTclustered | gi|2795036376|ref|XM_067936376.1| | 4785 | g28431 | i0 | 80.567 | 17.3240223463687 | 247 | 46 | 69 | 2 | 31 | 276 | 190 | 435 | Phytophthora cinnamomi 40S ribosomal protein S16 (IUM83_11796), partial mRNA | blastn | 6202 | 189 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 7011931 | 7011931 | PRJNA666695_S_NODE_84326_length_237_cov_3.051020_g83232_i0 | PRJNA666695 | 84326 | 237 | 3.05102 | 7.2309174 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 7.44e-22 | NTclustered | gi|301105318|ref|XM_002901697.1| | 403677 | g83232 | i0 | 81.013 | 3.22784810126582 | 158 | 20 | 65 | 9 | 1 | 153 | 157 | 309 | Phytophthora infestans T30-4 elongation factor 2 (PITG_10941), mRNA | blastn | 765 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 8285949 | 8285949 | PRJNA666695_S_NODE_55087_length_282_cov_6.286307_g53993_i0 | PRJNA666695 | 55087 | 282 | 6.286307 | 17.72738574 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 1.91e-38 | NTclustered | gi|2248513440|ref|NC_063805.1| | 4781 | g53993 | i0 | 81.166 | 61.1524822695035 | 223 | 35 | 78 | 6 | 22 | 242 | 27495 | 27278 | Plasmopara halstedii isolate 710 mitochondrion, complete genome | blastn | 17245 | 172 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 9561209 | 9561209 | PRJNA666695_S_NODE_54688_length_283_cov_3.900826_g53594_i0 | PRJNA666695 | 54688 | 283 | 3.900826 | 11.03933758 | Phytopythium vexans | 907947 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 9.26e-12 | NTclustered | gi|2248513842|ref|NC_063815.1| | 907947 | g53594 | i0 | 100 | 1.32155477031802 | 45 | 0 | 16 | 0 | 14 | 58 | 26962 | 26918 | Phytopythium vexans culture CBS:119.80 mitochondrion, complete genome | blastn | 374 | 84.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium vexans | ||
| 9561499 | 9561499 | PRJNA666695_S_NODE_67048_length_261_cov_2.840909_g65954_i0 | PRJNA666695 | 67048 | 261 | 2.840909 | 7.41477249 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.024 | NTclustered | gi|813143459|ref|XM_012344285.1| | 695850 | g65954 | i0 | 100 | 0.10727969348659 | 28 | 0 | 11 | 0 | 234 | 261 | 2315 | 2288 | Saprolegnia parasitica CBS 223.65 V-type H(+)-translocating pyrophosphatase mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 10834667 | 10834667 | PRJNA666695_S_NODE_129689_length_192_cov_5.907285_g128595_i0 | PRJNA666695 | 129689 | 192 | 5.907285 | 11.3419872 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 5.740000000000001e-27 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g128595 | i0 | 84.962 | 0.692708333333333 | 133 | 18 | 69 | 2 | 14 | 145 | 632 | 501 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 133 | 134 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 10837126 | 10837126 | PRJNA666695_S_NODE_68049_length_259_cov_10.339450_g66955_i0 | PRJNA666695 | 68049 | 259 | 10.33945 | 26.7791755 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 5e-14 | NTclustered | gi|675185160|ref|XM_008903217.1| | 761204 | g66955 | i0 | 88.312 | 0.575289575289575 | 77 | 8 | 29 | 1 | 184 | 259 | 648 | 572 | Phytophthora parasitica INRA-310 ubiquitin-conjugating enzyme E2-16 kDa mRNA | blastn | 149 | 91.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 11366085 | 11366085 | PRJNA666695_S_NODE_143189_length_182_cov_2.702128_g142095_i0 | PRJNA666695 | 143189 | 182 | 2.702128 | 4.91787296 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.4699999999999998e-37 | NTclustered | gi|93139337|gb|DQ361214.1| | 127443 | g142095 | i0 | 85.976 | 76 | 164 | 16 | 88 | 6 | 1 | 161 | 523 | 682 | Phytophthora richardiae strain MG 42-2 NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial | blastn | 13832 | 169 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora richardiae | ||
| 12112062 | 12112062 | PRJNA666695_S_NODE_58850_length_275_cov_3.572650_g57756_i0 | PRJNA666695 | 58850 | 275 | 3.57265 | 9.8247875 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 8.529999999999998e-47 | NTclustered | gi|695388802|ref|XM_009520976.1| | 67593 | g57756 | i0 | 80.377 | 19.1636363636364 | 265 | 50 | 96 | 2 | 3 | 266 | 473 | 736 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 5270 | 200 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 14659515 | 14659515 | PRJNA666695_S_NODE_13092_length_489_cov_29.131696_g12010_i0 | PRJNA666695 | 13092 | 489 | 29.131696 | 142.45399344 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 9.69e-44 | NTclustered | gi|813198778|ref|XM_012353582.1| | 695850 | g12010 | i0 | 84.694 | 2.31288343558282 | 196 | 24 | 39 | 5 | 19 | 211 | 315 | 123 | Saprolegnia parasitica CBS 223.65 autophagy-like protein 8 mRNA | blastn | 1131 | 191 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 15934576 | 15934576 | PRJNA666695_S_NODE_189553_length_153_cov_2.464286_g188459_i0 | PRJNA666695 | 189553 | 153 | 2.464286 | 3.77035758 | Phytophthora versiformis | 1833877 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.05e-15 | NTclustered | gi|2248513601|ref|NC_063809.1| | 1833877 | g188459 | i0 | 87.059 | 36.4052287581699 | 85 | 9 | 55 | 2 | 65 | 148 | 29130 | 29213 | Phytophthora versiformis isolate ST_20190930 mitochondrion, complete genome | blastn | 5570 | 95.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora versiformis | ||
| 18482594 | 18482594 | PRJNA666695_S_NODE_113115_length_207_cov_1.512048_g112021_i0 | PRJNA666695 | 113115 | 207 | 1.512048 | 3.12993936 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.07e-14 | NTclustered | gi|673039884|ref|XM_008875681.1| | 157072 | g112021 | i0 | 87.654 | 0.782608695652174 | 81 | 8 | 39 | 2 | 1 | 80 | 380 | 459 | Aphanomyces invadans 60S ribosomal protein mRNA | blastn | 162 | 93.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 18482643 | 18482643 | PRJNA666695_S_NODE_115635_length_204_cov_3.785276_g114541_i0 | PRJNA666695 | 115635 | 204 | 3.785276 | 7.72196304 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.2999999999999996e-43 | NTclustered | gi|698802469|ref|XM_009835962.1| | 112090 | g114541 | i0 | 83.333 | 65.25 | 204 | 34 | 100 | 0 | 1 | 204 | 730 | 933 | Aphanomyces astaci V-type H(+)-translocating pyrophosphatase mRNA | blastn | 13311 | 189 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18482977 | 18482977 | PRJNA666695_S_NODE_131155_length_191_cov_3.066667_g130061_i0 | PRJNA666695 | 131155 | 191 | 3.066667 | 5.85733397 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.69e-15 | NTclustered | gi|675165376|ref|XM_008893325.1| | 761204 | g130061 | i0 | 93.75 | 24.7068062827225 | 64 | 2 | 33 | 2 | 128 | 190 | 700 | 638 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 4719 | 95.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 22309439 | 22309439 | PRJNA666695_S_NODE_31278_length_351_cov_4.809677_g30184_i0 | PRJNA666695 | 31278 | 351 | 4.809677 | 16.88196627 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 4.99e-75 | NTclustered | gi|166301|gb|J05597.1|ACKBTUB | 4767 | g30184 | i0 | 86.397 | 73.1481481481482 | 272 | 33 | 77 | 2 | 78 | 346 | 1542 | 1272 | A.klebsiana beta-tubulin gene, complete cds | blastn | 25675 | 294 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 22840786 | 22840786 | PRJNA666695_S_NODE_95058_length_225_cov_1.940217_g93964_i0 | PRJNA666695 | 95058 | 225 | 1.940217 | 4.36548825 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 5.29e-38 | NTclustered | gi|2795036376|ref|XM_067936376.1| | 4785 | g93964 | i0 | 81.773 | 84.5111111111111 | 203 | 37 | 90 | 0 | 21 | 223 | 190 | 392 | Phytophthora cinnamomi 40S ribosomal protein S16 (IUM83_11796), partial mRNA | blastn | 19015 | 171 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi |
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);;