contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2128437 | 2128437 | PRJNA876641_P_NODE_15622_length_251_cov_1.370787_g15548_i0 | PRJNA876641 | 15622 | 251 | 1.370787 | 3.44067537 | Plectospira myriandra | 100863 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.2600000000000001e-59 | NTclustered | gi|57903370|gb|AY729836.1| | 100863 | g15548 | i0 | 84.49 | 55.1673306772908 | 245 | 38 | 98 | 0 | 5 | 249 | 269 | 25 | Plectospira myriandra alpha-tubulin gene, partial cds | blastn | 13847 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Plectospira | Plectospira myriandra | ||
| 2128443 | 2128443 | PRJNA876641_P_NODE_15762_length_251_cov_0.865169_g15688_i0 | PRJNA876641 | 15762 | 251 | 0.865169 | 2.17157419 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.01e-35 | NTclustered | gi|813141452|ref|XM_012343573.1| | 695850 | g15688 | i0 | 83.908 | 7.88844621513944 | 174 | 24 | 69 | 4 | 80 | 251 | 767 | 596 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L8 mRNA | blastn | 1980 | 163 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 4681460 | 4681460 | PRJNA876641_P_NODE_12184_length_269_cov_2.403061_g12110_i0 | PRJNA876641 | 12184 | 269 | 2.403061 | 6.46423409 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.42e-29 | NTclustered | gi|301119740|ref|XM_002907552.1| | 403677 | g12110 | i0 | 82.635 | 31.5947955390335 | 167 | 23 | 61 | 5 | 4 | 167 | 382 | 219 | Phytophthora infestans T30-4 60S ribosomal protein L23a (PITG_02694), mRNA | blastn | 8499 | 143 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 4681521 | 4681521 | PRJNA876641_P_NODE_16664_length_250_cov_0.870056_g16590_i0 | PRJNA876641 | 16664 | 250 | 0.870056 | 2.17514 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.15e-37 | NTclustered | gi|813218880|ref|XM_012355428.1| | 695850 | g16590 | i0 | 79.283 | 6.212 | 251 | 45 | 99 | 5 | 4 | 250 | 526 | 773 | Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA | blastn | 1553 | 169 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 4681567 | 4681567 | PRJNA876641_P_NODE_1964_length_495_cov_9.514218_g1890_i0 | PRJNA876641 | 1964 | 495 | 9.514218 | 47.0953791 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 5.66e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g1890 | i0 | 80.533 | 68.3393939393939 | 375 | 65 | 74 | 4 | 114 | 481 | 441 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 5956496 | 5956496 | PRJNA876641_P_NODE_22165_length_242_cov_1.822485_g22091_i0 | PRJNA876641 | 22165 | 242 | 1.822485 | 4.4104137 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 3.5e-30 | NTclustered | gi|2794915646|ref|XM_067893010.1| | 164328 | g22091 | i0 | 84.354 | 41.3388429752066 | 147 | 23 | 61 | 0 | 96 | 242 | 1587 | 1441 | Phytophthora ramorum Aldehyde dehydrogenase, mitochondrial (KRP23_7665), partial mRNA | blastn | 10004 | 145 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 7231441 | 7231441 | PRJNA876641_P_NODE_22766_length_242_cov_0.911243_g22692_i0 | PRJNA876641 | 22766 | 242 | 0.911243 | 2.20520806 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 7.2e-62 | NTclustered | gi|695369285|ref|XM_009515721.1| | 67593 | g22692 | i0 | 85.957 | 85.4380165289256 | 235 | 31 | 97 | 2 | 1 | 234 | 2417 | 2650 | Phytophthora sojae hypothetical protein mRNA | blastn | 20676 | 250 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 8505964 | 8505964 | PRJNA876641_P_NODE_10507_length_279_cov_1.466019_g10433_i0 | PRJNA876641 | 10507 | 279 | 1.466019 | 4.09019301 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.45e-44 | NTclustered | gi|675208352|ref|XM_008914813.1| | 761204 | g10433 | i0 | 81.78 | 6.18996415770609 | 236 | 37 | 84 | 4 | 46 | 278 | 409 | 177 | Phytophthora parasitica INRA-310 ribonucleoprotein-associated protein mRNA | blastn | 1727 | 193 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 8506029 | 8506029 | PRJNA876641_P_NODE_15027_length_254_cov_1.441989_g14953_i0 | PRJNA876641 | 15027 | 254 | 1.441989 | 3.66265206 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.04e-20 | NTclustered | gi|301107276|ref|XM_002902675.1| | 403677 | g14953 | i0 | 80.132 | 0.594488188976378 | 151 | 30 | 59 | 0 | 104 | 254 | 1443 | 1293 | Phytophthora infestans T30-4 adenosylhomocysteinase (PITG_10198), partial mRNA | blastn | 151 | 113 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 8506072 | 8506072 | PRJNA876641_P_NODE_17147_length_249_cov_1.142045_g17073_i0 | PRJNA876641 | 17147 | 249 | 1.142045 | 2.84369205 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 3.56e-40 | NTclustered | gi|695424642|ref|XM_009530689.1| | 67593 | g17073 | i0 | 79.675 | 13.7228915662651 | 246 | 50 | 99 | 0 | 1 | 246 | 208 | 453 | Phytophthora sojae hypothetical protein mRNA | blastn | 3417 | 178 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 8506201 | 8506201 | PRJNA876641_P_NODE_3167_length_413_cov_2.855882_g3093_i0 | PRJNA876641 | 3167 | 413 | 2.855882 | 11.79479266 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 1.01e-62 | NTclustered | gi|675207712|ref|XM_008914493.1| | 761204 | g3093 | i0 | 84.091 | 85.2421307506053 | 264 | 40 | 64 | 2 | 84 | 346 | 290 | 28 | Phytophthora parasitica INRA-310 hsp70-like protein partial mRNA | blastn | 35205 | 254 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 9781083 | 9781083 | PRJNA876641_P_NODE_21408_length_243_cov_2.111765_g21334_i0 | PRJNA876641 | 21408 | 243 | 2.111765 | 5.13158895 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.54e-25 | NTclustered | gi|2795047393|ref|XM_067937896.1| | 4785 | g21334 | i0 | 88.073 | 4.67489711934156 | 109 | 11 | 44 | 2 | 48 | 155 | 10 | 117 | Phytophthora cinnamomi Nucleoside diphosphate kinase B (IUM83_13233), partial mRNA | blastn | 1136 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 12332280 | 12332280 | PRJNA876641_P_NODE_20030_length_245_cov_1.465116_g19956_i0 | PRJNA876641 | 20030 | 245 | 1.465116 | 3.5895342 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.74e-31 | NTclustered | gi|698822200|ref|XM_009845827.1| | 112090 | g19956 | i0 | 88.525 | 45.9755102040816 | 122 | 14 | 50 | 0 | 69 | 190 | 472 | 351 | Aphanomyces astaci peptidyl-prolyl cis-trans isomerase 1 mRNA | blastn | 11264 | 148 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 12332446 | 12332446 | PRJNA876641_P_NODE_9170_length_287_cov_1.140187_g9096_i0 | PRJNA876641 | 9170 | 287 | 1.140187 | 3.27233669 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 6.9699999999999984e-43 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g9096 | i0 | 78.808 | 49.5644599303136 | 302 | 46 | 100 | 12 | 1 | 287 | 30687 | 30985 | Achlya hypogyna mitochondrion, complete genome | blastn | 14225 | 187 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 12718076 | 12718076 | PRJNA876641_P_NODE_4710_length_358_cov_2.161404_g4636_i0 | PRJNA876641 | 4710 | 358 | 2.161404 | 7.73782632 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 9.29e-13 | NTclustered | gi|166038860|emb|CU355090.1| | 100861 | g4636 | i0 | 85.542 | 20.1145251396648 | 83 | 12 | 23 | 0 | 257 | 339 | 750 | 668 | Aphanomyces euteiches cDNA | blastn | 7201 | 87.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13606665 | 13606665 | PRJNA876641_P_NODE_10411_length_280_cov_1.115942_g10337_i0 | PRJNA876641 | 10411 | 280 | 1.115942 | 3.1246376 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 1.0599999999999999e-90 | NTclustered | gi|675199240|ref|XM_008910257.1| | 761204 | g10337 | i0 | 88.929 | 102.55 | 280 | 31 | 100 | 0 | 1 | 280 | 1340 | 1061 | Phytophthora parasitica INRA-310 ATP synthase subunit beta, mitochondrial mRNA | blastn | 28714 | 346 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 14881260 | 14881260 | PRJNA876641_P_NODE_2692_length_438_cov_3.331507_g2618_i0 | PRJNA876641 | 2692 | 438 | 3.331507 | 14.59200066 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 6.98e-10 | NTclustered | gi|695382888|ref|XM_009519246.1| | 67593 | g2618 | i0 | 100 | 0.550228310502283 | 42 | 0 | 10 | 0 | 184 | 225 | 357 | 398 | Phytophthora sojae hypothetical protein mRNA | blastn | 241 | 78.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 16541013 | 16541013 | PRJNA876641_P_NODE_14613_length_256_cov_1.683060_g14539_i0 | PRJNA876641 | 14613 | 256 | 1.68306 | 4.3086336 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 4.6e-64 | NTclustered | gi|2795052452|ref|XM_067926699.1| | 4785 | g14539 | i0 | 84.825 | 21.66015625 | 257 | 37 | 100 | 2 | 1 | 256 | 388 | 133 | Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA | blastn | 5545 | 257 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 17815972 | 17815972 | PRJNA876641_P_NODE_22914_length_242_cov_0.786982_g22840_i0 | PRJNA876641 | 22914 | 242 | 0.786982 | 1.90449644 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 5.77e-38 | NTclustered | gi|156986897|gb|EU080062.1| | 4788 | g22840 | i0 | 81.193 | 90.702479338843 | 218 | 35 | 89 | 4 | 15 | 229 | 1517 | 1731 | Phytophthora megasperma isolate PD_00017(P3136) heat shock protein 90 (HSP90) gene, partial cds | blastn | 21950 | 172 | 0.994186046511628 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 19979932 | 19979932 | PRJNA876641_P_NODE_2496_length_449_cov_4.050532_g2422_i0 | PRJNA876641 | 2496 | 449 | 4.050532 | 18.18688868 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 6.269999999999998e-105 | NTclustered | gi|675199806|ref|XM_008910540.1| | 761204 | g2422 | i0 | 84.635 | 85.9354120267261 | 397 | 59 | 88 | 2 | 1 | 396 | 524 | 129 | Phytophthora parasitica INRA-310 calmodulin mRNA | blastn | 38585 | 394 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 22529770 | 22529770 | PRJNA876641_P_NODE_10218_length_281_cov_1.139423_g10144_i0 | PRJNA876641 | 10218 | 281 | 1.139423 | 3.20177863 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 514 | 2.75e-141 | NTclustered | gi|166044475|emb|CU367384.1| | 100861 | g10144 | i0 | 99.644 | 42.8362989323843 | 281 | 1 | 100 | 0 | 1 | 281 | 712 | 432 | Aphanomyces euteiches cDNA | blastn | 12037 | 514 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 25079360 | 25079360 | PRJNA876641_P_NODE_4940_length_353_cov_1.878571_g4866_i0 | PRJNA876641 | 4940 | 353 | 1.878571 | 6.63135563 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.3999999999999996e-53 | NTclustered | gi|813184507|ref|XM_012351036.1| | 695850 | g4866 | i0 | 87.065 | 24.5835694050992 | 201 | 20 | 56 | 4 | 44 | 241 | 139 | 336 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein mRNA | blastn | 8678 | 222 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica |
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);;