contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371871 | 371871 | PRJNA285816_S_NODE_11121_length_222_cov_1.502890_g11019_i0 | PRJNA285816 | 11121 | 222 | 1.50289 | 3.3364158 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.14e-29 | NTclustered | gi|2794910559|ref|XM_067891130.1| | 164328 | g11019 | i0 | 85.401 | 4.42792792792793 | 137 | 20 | 62 | 0 | 2 | 138 | 422 | 286 | Phytophthora ramorum 3-oxoacyl-[acyl-carrier-protein] reductase FabG (KRP23_5997), partial mRNA | blastn | 983 | 143 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 371893 | 371893 | PRJNA285816_S_NODE_12801_length_211_cov_1.629630_g12699_i0 | PRJNA285816 | 12801 | 211 | 1.62963 | 3.4385193 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.019 | NTclustered | gi|187467924|emb|CU694972.3| | 123356 | g12699 | i0 | 100 | 0.132701421800948 | 28 | 0 | 13 | 0 | 121 | 148 | 53066 | 53039 | H.parasitica DNA sequence from clone HpEmoy2-18K24, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 4199052 | 4199052 | PRJNA285816_S_NODE_1604_length_520_cov_10.016985_g1504_i0 | PRJNA285816 | 1604 | 520 | 10.016985 | 52.088322 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 2.82e-59 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g1504 | i0 | 79.05 | 15.2403846153846 | 358 | 71 | 68 | 4 | 113 | 468 | 482 | 127 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 7925 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 6749578 | 6749578 | PRJNA285816_S_NODE_1226_length_590_cov_7.293900_g1135_i0 | PRJNA285816 | 1226 | 590 | 7.2939 | 43.03401 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.83e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g1135 | i0 | 80.533 | 56.9372881355932 | 375 | 65 | 62 | 4 | 191 | 558 | 441 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33593 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 6749733 | 6749733 | PRJNA285816_S_NODE_2426_length_428_cov_1.604222_g2324_i0 | PRJNA285816 | 2426 | 428 | 1.604222 | 6.86607016 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 1.3899999999999999e-46 | NTclustered | gi|813158096|ref|XM_012347005.1| | 695850 | g2324 | i0 | 80.769 | 37.838785046729 | 260 | 46 | 60 | 4 | 169 | 426 | 605 | 348 | Saprolegnia parasitica CBS 223.65 NADH dehydrogenase iron-sulfur protein 8 mRNA | blastn | 16195 | 200 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 6749822 | 6749822 | PRJNA285816_S_NODE_4466_length_323_cov_1.120438_g4364_i0 | PRJNA285816 | 4466 | 323 | 1.120438 | 3.61901474 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 7.75e-63 | NTclustered | gi|166036871|emb|CU360758.1| | 100861 | g4364 | i0 | 80.805 | 74.0866873065015 | 323 | 62 | 100 | 0 | 1 | 323 | 750 | 428 | Aphanomyces euteiches cDNA | blastn | 23930 | 254 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9299955 | 9299955 | PRJNA285816_S_NODE_12388_length_214_cov_0.939394_g12286_i0 | PRJNA285816 | 12388 | 214 | 0.939394 | 2.01030316 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.34e-63 | NTclustered | gi|2795047822|ref|XM_067933895.1| | 4785 | g12286 | i0 | 89.216 | 95.7990654205608 | 204 | 22 | 95 | 0 | 1 | 204 | 1104 | 901 | Phytophthora cinnamomi Inositol-3-phosphate synthase (IUM83_09454), partial mRNA | blastn | 20501 | 255 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9300007 | 9300007 | PRJNA285816_S_NODE_1708_length_504_cov_6.903297_g1606_i0 | PRJNA285816 | 1708 | 504 | 6.903297 | 34.79261688 | Phytophthora clandestina | 89334 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 9.32e-94 | NTclustered | gi|2314988938|ref|NC_067073.1| | 89334 | g1606 | i0 | 84.807 | 71.5496031746032 | 362 | 47 | 71 | 7 | 8 | 366 | 33713 | 34069 | Phytophthora clandestina voucher P3942 mitochondrion, complete genome | blastn | 36061 | 357 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora clandestina | ||
| 9300043 | 9300043 | PRJNA285816_S_NODE_19568_length_182_cov_1.142857_g19466_i0 | PRJNA285816 | 19568 | 182 | 1.142857 | 2.07999974 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.15e-33 | NTclustered | gi|813142340|ref|XM_012343869.1| | 695850 | g19466 | i0 | 87.407 | 41.8626373626374 | 135 | 17 | 74 | 0 | 21 | 155 | 287 | 153 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein S6 mRNA | blastn | 7619 | 156 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 12537635 | 12537635 | PRJNA285816_S_NODE_20290_length_179_cov_2.746154_g20188_i0 | PRJNA285816 | 20290 | 179 | 2.746154 | 4.91561566 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 6.96e-11 | NTclustered | gi|2314988938|ref|NC_067073.1| | 89334 | g20188 | i0 | 92.727 | 28.1899441340782 | 55 | 4 | 31 | 0 | 90 | 144 | 33089 | 33143 | Phytophthora clandestina voucher P3942 mitochondrion, complete genome | blastn | 5046 | 80.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora clandestina | ||
| 15086752 | 15086752 | PRJNA285816_S_NODE_25152_length_167_cov_1.788136_g25050_i0 | PRJNA285816 | 25152 | 167 | 1.788136 | 2.98618712 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 8.08e-30 | NTclustered | gi|2795036376|ref|XM_067936376.1| | 4785 | g25050 | i0 | 84.247 | 3.50299401197605 | 146 | 23 | 87 | 0 | 18 | 163 | 392 | 247 | Phytophthora cinnamomi 40S ribosomal protein S16 (IUM83_11796), partial mRNA | blastn | 585 | 143 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 15674667 | 15674667 | PRJNA285816_S_NODE_17813_length_188_cov_1.122302_g17711_i0 | PRJNA285816 | 17813 | 188 | 1.122302 | 2.10992776 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 9.49e-15 | NTclustered | gi|2795032265|ref|XM_067933159.1| | 4785 | g17711 | i0 | 88.462 | 0.654255319148936 | 78 | 7 | 41 | 2 | 105 | 181 | 221 | 145 | Phytophthora cinnamomi cyclin-dependent kinase regulatory subunit 1 (IUM83_08766), partial mRNA | blastn | 123 | 93.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 15674868 | 15674868 | PRJNA285816_S_NODE_6593_length_272_cov_2.672646_g6491_i0 | PRJNA285816 | 6593 | 272 | 2.672646 | 7.26959712 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.38e-59 | NTclustered | gi|2795016949|ref|XM_067930458.1| | 4785 | g6491 | i0 | 84.337 | 87.7389705882353 | 249 | 37 | 91 | 2 | 3 | 250 | 917 | 670 | Phytophthora cinnamomi protein transporter Sec61 subunit alpha isoform 2 (IUM83_06269), partial mRNA | blastn | 23865 | 243 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 19498085 | 19498085 | PRJNA285816_S_NODE_8756_length_243_cov_1.530928_g8654_i0 | PRJNA285816 | 8756 | 243 | 1.530928 | 3.72015504 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.2100000000000004e-59 | NTclustered | gi|2794920874|ref|XM_067880626.1| | 164328 | g8654 | i0 | 85.169 | 44.4650205761317 | 236 | 35 | 97 | 0 | 5 | 240 | 1331 | 1096 | Phytophthora ramorum Adenosylhomocysteinase (KRP23_10205), partial mRNA | blastn | 10805 | 243 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 20773358 | 20773358 | PRJNA285816_S_NODE_1097_length_620_cov_8.094571_g1013_i0 | PRJNA285816 | 1097 | 620 | 8.094571 | 50.1863402 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.6e-47 | NTclustered | gi|2794905809|ref|XM_067889902.1| | 164328 | g1013 | i0 | 79.577 | 9.98870967741935 | 284 | 58 | 46 | 0 | 238 | 521 | 302 | 19 | Phytophthora ramorum 13 kDa ribonucleoprotein-associated protein (KRP23_4892), partial mRNA | blastn | 6193 | 204 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 20773498 | 20773498 | PRJNA285816_S_NODE_22577_length_172_cov_3.569106_g22475_i0 | PRJNA285816 | 22577 | 172 | 3.569106 | 6.13886232 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 1.76e-41 | NTclustered | gi|673019533|ref|XM_008865506.1| | 157072 | g22475 | i0 | 85.882 | 85.6918604651163 | 170 | 24 | 99 | 0 | 1 | 170 | 326 | 157 | Aphanomyces invadans hypothetical protein mRNA | blastn | 14739 | 182 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 20773664 | 20773664 | PRJNA285816_S_NODE_897_length_670_cov_1.969404_g828_i0 | PRJNA285816 | 897 | 670 | 1.969404 | 13.1950068 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 1.24e-108 | NTclustered | gi|1219685856|gb|KY965925.1| | 1440116 | g828 | i0 | 80.741 | 76.5746268656716 | 540 | 88 | 79 | 15 | 94 | 622 | 737 | 203 | Lagenidium giganteum f. caninum isolate UF15-01 heat shock protein 90 (hsp90) gene, partial cds | blastn | 51305 | 407 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 22048584 | 22048584 | PRJNA285816_S_NODE_3938_length_341_cov_2.681507_g3836_i0 | PRJNA285816 | 3938 | 341 | 2.681507 | 9.14393887 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 3.909999999999999e-46 | NTclustered | gi|669138905|ref|XM_008606799.1| | 1156394 | g3836 | i0 | 77.391 | 19.891495601173 | 345 | 70 | 100 | 8 | 1 | 341 | 994 | 1334 | Saprolegnia diclina VS20 seryl-tRNA synthetase mRNA | blastn | 6783 | 198 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 24598080 | 24598080 | PRJNA285816_S_NODE_1860_length_486_cov_8.750572_g1758_i0 | PRJNA285816 | 1860 | 486 | 8.750572 | 42.52777992 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 3.51e-33 | NTclustered | gi|1111669769|ref|NC_032052.1| | 157072 | g1758 | i0 | 76.645 | 32.9506172839506 | 304 | 58 | 61 | 11 | 42 | 337 | 3468 | 3766 | Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome | blastn | 16014 | 156 | 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);;