contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJNA692200" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1949009 | 1949009 | PRJNA692200_S_NODE_9642_length_227_cov_2.359551_g9585_i0 | PRJNA692200 | 9642 | 227 | 2.359551 | 5.35618077 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.4799999999999996e-43 | NTclustered | gi|698776103|ref|XM_009822794.1| | 112090 | g9585 | i0 | 97.297 | 9.34361233480176 | 111 | 3 | 49 | 0 | 117 | 227 | 1211 | 1101 | Aphanomyces astaci 60S ribosomal protein mRNA | blastn | 2121 | 189 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 3731119 | 3731119 | PRJNA692200_S_NODE_7163_length_254_cov_95.814634_g7106_i0 | PRJNA692200 | 7163 | 254 | 95.814634 | 243.36917036 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.2299999999999997e-125 | NTclustered | gi|2099741709|gb|OK271022.1| | 253176 | g7106 | i0 | 99.216 | 100.086614173228 | 255 | 1 | 100 | 1 | 1 | 254 | 661 | 915 | Aphanomyces cladogamus voucher CCIBt3854 small subunit ribosomal RNA gene, partial sequence | blastn | 25422 | 464 | 0.991379310344828 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cladogamus | ||
| 4500635 | 4500635 | PRJNA692200_S_NODE_14604_length_190_cov_1.106383_g14547_i0 | PRJNA692200 | 14604 | 190 | 1.106383 | 2.1021277 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 5.469999999999999e-52 | NTclustered | gi|2248513156|ref|NC_063798.1| | 325452 | g14547 | i0 | 89.535 | 62.6315789473684 | 172 | 16 | 90 | 2 | 20 | 190 | 31858 | 31688 | Phytophthora kernoviae isolate 00844/4 mitochondrion, complete genome | blastn | 11900 | 217 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 5776219 | 5776219 | PRJNA692200_S_NODE_18965_length_169_cov_9.700000_g18908_i0 | PRJNA692200 | 18965 | 169 | 9.7 | 16.393 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.56e-77 | NTclustered | gi|166039764|emb|CU357372.1| | 100861 | g18908 | i0 | 99.394 | 97.6213017751479 | 165 | 1 | 98 | 0 | 1 | 165 | 531 | 367 | Aphanomyces euteiches cDNA | blastn | 16498 | 300 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 5776298 | 5776298 | PRJNA692200_S_NODE_23045_length_157_cov_2.277778_g22988_i0 | PRJNA692200 | 23045 | 157 | 2.277778 | 3.57611146 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 2.78e-4 | NTclustered | gi|1378164915|ref|XM_024716554.1| | 4781 | g22988 | i0 | 100 | 0.197452229299363 | 31 | 0 | 20 | 0 | 42 | 72 | 812 | 782 | Plasmopara halstedii uncharacterized protein (PHALS_02046), partial mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 6283267 | 6283267 | PRJNA692200_S_NODE_3925_length_313_cov_21.155303_g3868_i0 | PRJNA692200 | 3925 | 313 | 21.155303 | 66.21609839 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|698813671|ref|XM_009841563.1| | 112090 | g3868 | i0 | 100 | 0.463258785942492 | 29 | 0 | 9 | 0 | 51 | 79 | 502 | 474 | Aphanomyces astaci hypothetical protein mRNA | blastn | 145 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 7051217 | 7051217 | PRJNA692200_S_NODE_13506_length_196_cov_3.993197_g13449_i0 | PRJNA692200 | 13506 | 196 | 3.993197 | 7.82666612 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 9.92e-20 | NTclustered | gi|673015481|ref|XM_008863480.1| | 157072 | g13449 | i0 | 93.243 | 0.673469387755102 | 74 | 5 | 38 | 0 | 122 | 195 | 401 | 328 | Aphanomyces invadans 60S ribosomal protein L44 mRNA | blastn | 132 | 110 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 7051303 | 7051303 | PRJNA692200_S_NODE_1706_length_394_cov_264.918841_g1649_i0 | PRJNA692200 | 1706 | 394 | 264.918841 | 1043.78023354 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 640 | 6.319999999999999e-179 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g1649 | i0 | 98.093 | 92.0482233502538 | 367 | 7 | 93 | 0 | 2 | 368 | 31 | 397 | Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 36267 | 640 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 7051648 | 7051648 | PRJNA692200_S_NODE_946_length_447_cov_408.806533_g190_i1 | PRJNA692200 | 946 | 447 | 408.806533 | 1827.36520251 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 688 | 0 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g190 | i1 | 97.297 | 98.8456375838926 | 407 | 7 | 90 | 2 | 44 | 447 | 6320 | 5915 | Achlya hypogyna mitochondrion, complete genome | blastn | 44184 | 688 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 8325847 | 8325847 | PRJNA692200_S_NODE_19187_length_169_cov_1.300000_g19130_i0 | PRJNA692200 | 19187 | 169 | 1.3 | 2.197 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.7600000000000002e-26 | NTclustered | gi|673014097|ref|XM_008862788.1| | 157072 | g19130 | i0 | 86.508 | 1.43786982248521 | 126 | 10 | 70 | 3 | 50 | 168 | 532 | 407 | Aphanomyces invadans hypothetical protein mRNA | blastn | 243 | 132 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 8326004 | 8326004 | PRJNA692200_S_NODE_47_length_779_cov_19.550685_g35_i0 | PRJNA692200 | 47 | 779 | 19.550685 | 152.29983615 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 1301 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g35 | i0 | 97.154 | 105.667522464698 | 773 | 17 | 99 | 5 | 1 | 769 | 2625 | 1854 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 82315 | 1301 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8326087 | 8326087 | PRJNA692200_S_NODE_7367_length_252_cov_1.438424_g7310_i0 | PRJNA692200 | 7367 | 252 | 1.438424 | 3.62482848 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 6.09e-33 | NTclustered | gi|669157573|ref|XM_008616127.1| | 1156394 | g7310 | i0 | 87.313 | 2.91666666666667 | 134 | 17 | 53 | 0 | 116 | 249 | 540 | 407 | Saprolegnia diclina VS20 30S ribosomal protein S24e mRNA | blastn | 735 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 9601029 | 9601029 | PRJNA692200_S_NODE_13068_length_199_cov_2.786667_g13011_i0 | PRJNA692200 | 13068 | 199 | 2.786667 | 5.54546733 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 3.56e-34 | NTclustered | gi|166043221|emb|CU357867.1| | 100861 | g13011 | i0 | 82.653 | 14.2211055276382 | 196 | 16 | 92 | 14 | 17 | 199 | 934 | 744 | Aphanomyces euteiches cDNA | blastn | 2830 | 158 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9601165 | 9601165 | PRJNA692200_S_NODE_188_length_596_cov_154.548446_g35_i1 | PRJNA692200 | 188 | 596 | 154.548446 | 921.10873816 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 907 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g35 | i1 | 98.084 | 93.1291946308725 | 522 | 8 | 87 | 2 | 1 | 520 | 2625 | 2104 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 55505 | 907 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 10876679 | 10876679 | PRJNA692200_S_NODE_14629_length_189_cov_305.607143_g14572_i0 | PRJNA692200 | 14629 | 189 | 305.607143 | 577.59750027 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 4.08e-73 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g14572 | i0 | 100 | 82.3862433862434 | 155 | 0 | 82 | 0 | 1 | 155 | 548 | 702 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 15571 | 287 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 10876844 | 10876844 | PRJNA692200_S_NODE_21749_length_162_cov_5.070796_g21692_i0 | PRJNA692200 | 21749 | 162 | 5.070796 | 8.21468952 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 6.14e-16 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g21692 | i0 | 89.157 | 0.512345679012346 | 83 | 2 | 48 | 4 | 1 | 77 | 417 | 498 | Aphanomyces astaci polyubiquitin mRNA | blastn | 83 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 12152121 | 12152121 | PRJNA692200_S_NODE_570_length_492_cov_285.997743_g534_i0 | PRJNA692200 | 570 | 492 | 285.997743 | 1407.10889556 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 806 | 0 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g534 | i0 | 99.326 | 91.4857723577236 | 445 | 3 | 90 | 0 | 1 | 445 | 2102 | 2546 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 45011 | 806 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 14701728 | 14701728 | PRJNA692200_S_NODE_19832_length_167_cov_2.084746_g19775_i0 | PRJNA692200 | 19832 | 167 | 2.084746 | 3.48152582 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 6.29e-26 | NTclustered | gi|673036683|ref|XM_008874081.1| | 157072 | g19775 | i0 | 92.391 | 0.550898203592814 | 92 | 6 | 55 | 1 | 74 | 165 | 655 | 565 | Aphanomyces invadans hypothetical protein mRNA | blastn | 92 | 130 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 15975568 | 15975568 | PRJNA692200_S_NODE_2793_length_347_cov_202.248322_g2736_i0 | PRJNA692200 | 2793 | 347 | 202.248322 | 701.80167734 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 556 | 5.709999999999999e-154 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g2736 | i0 | 100 | 92.7752161383285 | 301 | 0 | 87 | 0 | 46 | 346 | 463 | 763 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 32193 | 556 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18524611 | 18524611 | PRJNA692200_S_NODE_15415_length_186_cov_1.109489_g15358_i0 | PRJNA692200 | 15415 | 186 | 1.109489 | 2.06364954 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 1.48e-52 | NTclustered | gi|166041668|emb|CU357700.1| | 100861 | g15358 | i0 | 92.715 | 23.2150537634409 | 151 | 11 | 81 | 0 | 29 | 179 | 891 | 741 | Aphanomyces euteiches cDNA | blastn | 4318 | 219 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 19799607 | 19799607 | PRJNA692200_S_NODE_18036_length_173_cov_2.838710_g17979_i0 | PRJNA692200 | 18036 | 173 | 2.83871 | 4.9109683 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 3.98e-13 | NTclustered | gi|673039864|ref|XM_008875671.1| | 157072 | g17979 | i0 | 94.737 | 0.61271676300578 | 57 | 2 | 32 | 1 | 117 | 172 | 259 | 203 | Aphanomyces invadans ubiquitin-60S ribosomal protein L40 mRNA | blastn | 106 | 87.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 19799682 | 19799682 | PRJNA692200_S_NODE_216_length_581_cov_58.304511_g190_i0 | PRJNA692200 | 216 | 581 | 58.304511 | 338.74920891 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 998 | 0 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g190 | i0 | 97.603 | 109.903614457831 | 584 | 10 | 100 | 2 | 1 | 581 | 6497 | 5915 | Achlya hypogyna mitochondrion, complete genome | blastn | 63854 | 998 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 20305643 | 20305643 | PRJNA692200_S_NODE_15356_length_186_cov_1.795620_g15299_i0 | PRJNA692200 | 15356 | 186 | 1.79562 | 3.3398532 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 5.48e-32 | NTclustered | gi|698807045|ref|XM_009838250.1| | 112090 | g15299 | i0 | 94.792 | 1.04838709677419 | 96 | 5 | 52 | 0 | 87 | 182 | 619 | 524 | Aphanomyces astaci 60S ribosomal protein mRNA | blastn | 195 | 150 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21075143 | 21075143 | PRJNA692200_S_NODE_17917_length_174_cov_1.232000_g17860_i0 | PRJNA692200 | 17917 | 174 | 1.232 | 2.14368 | Saprolegnia ferax | 4770 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 8.149999999999998e-55 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g17860 | i0 | 90.588 | 75.8390804597701 | 170 | 16 | 98 | 0 | 3 | 172 | 15806 | 15975 | Saprolegnia ferax mitochondrion, complete genome | blastn | 13196 | 226 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 21075172 | 21075172 | PRJNA692200_S_NODE_19277_length_169_cov_0.866667_g19220_i0 | PRJNA692200 | 19277 | 169 | 0.866667 | 1.46466723 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 6.12e-51 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g19220 | i0 | 89.412 | 23.4556213017751 | 170 | 17 | 100 | 1 | 1 | 169 | 34554 | 34723 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 3964 | 213 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 24899117 | 24899117 | PRJNA692200_S_NODE_23480_length_154_cov_5.752381_g23423_i0 | PRJNA692200 | 23480 | 154 | 5.752381 | 8.85866674 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 2.59e-39 | NTclustered | gi|673046094|ref|XM_008878786.1| | 157072 | g23423 | i0 | 91.339 | 0.824675324675325 | 127 | 11 | 82 | 0 | 1 | 127 | 376 | 502 | Aphanomyces invadans hypothetical protein mRNA | blastn | 127 | 174 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans |
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);;