contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2729998 | 2729998 | PRJNA1063685_S_NODE_27963_length_444_cov_2.916442_g27422_i0 | PRJNA1063685 | 27963 | 444 | 2.916442 | 12.94900248 | Globisporangium hypogynum | 255163 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 8.73e-44 | NTclustered | gi|115111174|gb|DQ914548.1| | 255163 | g27422 | i0 | 80.738 | 48.5833333333333 | 244 | 47 | 55 | 0 | 23 | 266 | 657 | 900 | Pythium hypogynum strain BK clone 2 cytochrome c oxidase subunit I gene, partial cds; mitochondrial | blastn | 21571 | 191 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium hypogynum | ||
| 4006354 | 4006354 | PRJNA1063685_S_NODE_8644_length_651_cov_4.107266_g8139_i0 | PRJNA1063685 | 8644 | 651 | 4.107266 | 26.73830166 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 1.25e-78 | NTclustered | gi|675204844|ref|XM_008913059.1| | 761204 | g8139 | i0 | 78.2 | 17.1751152073733 | 500 | 95 | 76 | 13 | 159 | 651 | 664 | 172 | Phytophthora parasitica INRA-310 ribosomal protein S4 mRNA | blastn | 11181 | 307 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 5282606 | 5282606 | PRJNA1063685_S_NODE_64865_length_264_cov_4.246073_g64322_i0 | PRJNA1063685 | 64865 | 264 | 4.246073 | 11.20963272 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 1.1e-15 | NTclustered | gi|669154215|ref|XM_008614448.1| | 1156394 | g64322 | i0 | 87.059 | 1.20075757575758 | 85 | 11 | 32 | 0 | 150 | 234 | 248 | 332 | Saprolegnia diclina VS20 cystathionine beta-synthase mRNA | blastn | 317 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 6115283 | 6115283 | PRJNA1063685_S_NODE_64525_length_265_cov_3.947917_g63982_i0 | PRJNA1063685 | 64525 | 265 | 3.947917 | 10.46198005 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.024 | NTclustered | gi|2795035382|ref|XM_067928504.1| | 4785 | g63982 | i0 | 100 | 0.211320754716981 | 28 | 0 | 11 | 0 | 199 | 226 | 1529 | 1556 | Phytophthora cinnamomi Lupus La protein (IUM83_04425), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 6557669 | 6557669 | PRJNA1063685_S_NODE_54286_length_301_cov_1.491228_g53743_i0 | PRJNA1063685 | 54286 | 301 | 1.491228 | 4.48859628 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1.0599999999999996e-145 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g53743 | i0 | 98.339 | 15.4285714285714 | 301 | 5 | 100 | 0 | 1 | 301 | 1555 | 1255 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 4644 | 529 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7831950 | 7831950 | PRJNA1063685_S_NODE_14287_length_570_cov_8.261569_g13761_i0 | PRJNA1063685 | 14287 | 570 | 8.261569 | 47.0909433 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 1.3999999999999995e-82 | NTclustered | gi|2795059380|ref|XM_067933301.1| | 4785 | g13761 | i0 | 79.046 | 79.2298245614035 | 482 | 90 | 84 | 10 | 93 | 570 | 1206 | 732 | Phytophthora cinnamomi 26S protease regulatory subunit 8 (IUM83_08903), partial mRNA | blastn | 45161 | 320 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 7832029 | 7832029 | PRJNA1063685_S_NODE_19487_length_514_cov_12.147392_g18949_i0 | PRJNA1063685 | 19487 | 514 | 12.147392 | 62.43759488 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 5.9e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g18949 | i0 | 80.533 | 65.8132295719844 | 375 | 65 | 72 | 4 | 34 | 401 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8664963 | 8664963 | PRJNA1063685_S_NODE_17967_length_530_cov_1.956236_g17431_i0 | PRJNA1063685 | 17967 | 530 | 1.956236 | 10.3680508 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 1.01e-73 | NTclustered | gi|93139288|gb|DQ361189.1| | 162113 | g17431 | i0 | 80.99 | 71.4037735849057 | 384 | 58 | 70 | 12 | 53 | 425 | 467 | 846 | Peronospora conglomerata strain MG 18-11 NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial | blastn | 37844 | 292 | 0.996575342465753 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora conglomerata | ||
| 10382834 | 10382834 | PRJNA1063685_S_NODE_32609_length_411_cov_1.366864_g32067_i0 | PRJNA1063685 | 32609 | 411 | 1.366864 | 5.61781104 | Hyaloperonospora arabidopsidis | 272952 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 6.42e-20 | NTclustered | gi|2248512796|ref|NC_063789.1| | 272952 | g32067 | i0 | 77.957 | 55.7080291970803 | 186 | 35 | 45 | 5 | 228 | 411 | 1107 | 926 | Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome | blastn | 22896 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora arabidopsidis | ||
| 10382994 | 10382994 | PRJNA1063685_S_NODE_52049_length_310_cov_3.388186_g51506_i0 | PRJNA1063685 | 52049 | 310 | 3.388186 | 10.5033766 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.6000000000000004e-59 | NTclustered | gi|695406619|ref|XM_009525862.1| | 67593 | g51506 | i0 | 89.175 | 61.6709677419355 | 194 | 21 | 63 | 0 | 11 | 204 | 1156 | 1349 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 19118 | 243 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 12490875 | 12490875 | PRJNA1063685_S_NODE_40650_length_365_cov_1.921233_g40107_i0 | PRJNA1063685 | 40650 | 365 | 1.921233 | 7.01250045 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 5.4e-50 | NTclustered | gi|2795027162|ref|XM_067926592.1| | 4785 | g40107 | i0 | 81.569 | 3.2958904109589 | 255 | 47 | 70 | 0 | 3 | 257 | 687 | 433 | Phytophthora cinnamomi pre-mRNA-splicing factor CWC22 (IUM83_02652), partial mRNA | blastn | 1203 | 211 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 18031305 | 18031305 | PRJNA1063685_S_NODE_40995_length_363_cov_3.548276_g40452_i0 | PRJNA1063685 | 40995 | 363 | 3.548276 | 12.88024188 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 2.45e-63 | NTclustered | gi|2794882649|ref|XM_067895061.1| | 164328 | g40452 | i0 | 84.151 | 34.3856749311295 | 265 | 40 | 73 | 2 | 98 | 361 | 546 | 283 | Phytophthora ramorum ADP-ribosylation factor (KRP23_969), partial mRNA | blastn | 12482 | 255 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 19305207 | 19305207 | PRJNA1063685_S_NODE_27156_length_450_cov_2.387268_g26615_i0 | PRJNA1063685 | 27156 | 450 | 2.387268 | 10.742706 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 9.17e-19 | NTclustered | gi|698793878|ref|XR_717100.1| | 112090 | g26615 | i0 | 81.679 | 32.1088888888889 | 131 | 23 | 35 | 1 | 247 | 376 | 3791 | 3661 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 14449 | 108 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 20580440 | 20580440 | PRJNA1063685_S_NODE_17797_length_531_cov_12.602620_g17261_i0 | PRJNA1063685 | 17797 | 531 | 12.60262 | 66.9199122 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 9.66e-109 | NTclustered | gi|2794905961|ref|XM_067889945.1| | 164328 | g17261 | i0 | 81.386 | 42.7570621468927 | 505 | 89 | 95 | 5 | 6 | 508 | 674 | 1175 | Phytophthora ramorum 26S proteasome regulatory subunit 6B-like protein (KRP23_4930), partial mRNA | blastn | 22704 | 407 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 20580721 | 20580721 | PRJNA1063685_S_NODE_43457_length_350_cov_3.884477_g42914_i0 | PRJNA1063685 | 43457 | 350 | 3.884477 | 13.5956695 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 558 | 1.5999999999999994e-154 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g42914 | i0 | 97.554 | 98.4771428571429 | 327 | 6 | 93 | 2 | 1 | 325 | 2235 | 2561 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 34467 | 558 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 20580740 | 20580740 | PRJNA1063685_S_NODE_45077_length_342_cov_2.698885_g44534_i0 | PRJNA1063685 | 45077 | 342 | 2.698885 | 9.2301867 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 3.9199999999999996e-46 | NTclustered | gi|2794923344|ref|XM_067881972.1| | 164328 | g44534 | i0 | 77.846 | 3.57894736842105 | 325 | 68 | 94 | 4 | 4 | 326 | 1547 | 1225 | Phytophthora ramorum T-complex protein 1 subunit epsilon (KRP23_11422), partial mRNA | blastn | 1224 | 198 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 22688778 | 22688778 | PRJNA1063685_S_NODE_38_length_3583_cov_20.662393_g9_i0 | PRJNA1063685 | 38 | 3583 | 20.662393 | 740.33354119 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 9.07e-97 | NTclustered | gi|2248512996|ref|NC_063794.1| | 4785 | g9 | i0 | 72.72 | 23.788166341055 | 1195 | 293 | 33 | 28 | 1270 | 2448 | 14929 | 13752 | Phytophthora cinnamomi culture NZFS:3750 mitochondrion, complete genome | blastn | 85233 | 370 | 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);;