contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1174234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 316173 | 316173 | PRJNA1174234_P_NODE_21961_length_294_cov_2.796380_g21765_i0 | PRJNA1174234 | 21961 | 294 | 2.79638 | 8.2213572 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.6000000000000002e-37 | NTclustered | gi|695420111|ref|XM_009529545.1| | 67593 | g21765 | i0 | 82.979 | 9.02721088435374 | 188 | 30 | 64 | 2 | 70 | 256 | 199 | 13 | Phytophthora sojae hypothetical protein mRNA | blastn | 2654 | 169 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 316181 | 316181 | PRJNA1174234_P_NODE_24201_length_280_cov_1.111111_g24005_i0 | PRJNA1174234 | 24201 | 280 | 1.111111 | 3.1111108 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.46e-37 | NTclustered | gi|669165645|ref|XM_008620163.1| | 1156394 | g24005 | i0 | 78.467 | 3.23928571428571 | 274 | 47 | 96 | 10 | 5 | 272 | 105 | 372 | Saprolegnia diclina VS20 caltractin mRNA | blastn | 907 | 169 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 1040948 | 1040948 | PRJNA1174234_P_NODE_32941_length_245_cov_0.895349_g32745_i0 | PRJNA1174234 | 32941 | 245 | 0.895349 | 2.19360505 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 7.46e-47 | NTclustered | gi|2795047467|ref|XM_067937988.1| | 4785 | g32745 | i0 | 84.058 | 51.9020408163265 | 207 | 33 | 84 | 0 | 25 | 231 | 297 | 91 | Phytophthora cinnamomi UPF0468 protein (IUM83_13323), partial mRNA | blastn | 12716 | 200 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 5419215 | 5419215 | PRJNA1174234_P_NODE_30005_length_250_cov_0.870056_g29809_i0 | PRJNA1174234 | 30005 | 250 | 0.870056 | 2.17514 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 4.57e-49 | NTclustered | gi|669150423|ref|XM_008612552.1| | 1156394 | g29809 | i0 | 81.673 | 15.82 | 251 | 44 | 100 | 2 | 1 | 250 | 558 | 807 | Saprolegnia diclina VS20 ubiquitin-conjugating enzyme E2 4 mRNA | blastn | 3955 | 207 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 6694009 | 6694009 | PRJNA1174234_P_NODE_18286_length_322_cov_1.530120_g18090_i0 | PRJNA1174234 | 18286 | 322 | 1.53012 | 4.9269864 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 2.7e-82 | NTclustered | gi|695434207|ref|XM_009533074.1| | 67593 | g18090 | i0 | 88.104 | 42.4409937888199 | 269 | 30 | 83 | 2 | 18 | 285 | 327 | 60 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 13666 | 318 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 6694011 | 6694011 | PRJNA1174234_P_NODE_18606_length_320_cov_1.141700_g18410_i0 | PRJNA1174234 | 18606 | 320 | 1.1417 | 3.65344 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 4.92e-15 | NTclustered | gi|166043104|emb|CU357750.1| | 100861 | g18410 | i0 | 74.786 | 29.98125 | 234 | 47 | 70 | 8 | 1 | 225 | 177 | 407 | Aphanomyces euteiches cDNA | blastn | 9594 | 95.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 6694020 | 6694020 | PRJNA1174234_P_NODE_19486_length_312_cov_2.464435_g19290_i0 | PRJNA1174234 | 19486 | 312 | 2.464435 | 7.6890372 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 6.18e-14 | NTclustered | gi|813149133|ref|XM_012344824.1| | 695850 | g19290 | i0 | 87.342 | 0.253205128205128 | 79 | 10 | 25 | 0 | 47 | 125 | 1165 | 1087 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 79 | 91.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 13069683 | 13069683 | PRJNA1174234_P_NODE_20891_length_302_cov_1.344978_g20695_i0 | PRJNA1174234 | 20891 | 302 | 1.344978 | 4.06183356 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 3.34e-61 | NTclustered | gi|813219605|ref|XM_012355790.1| | 695850 | g20695 | i0 | 84.462 | 61.7086092715232 | 251 | 39 | 83 | 0 | 13 | 263 | 1267 | 1517 | Saprolegnia parasitica CBS 223.65 methylmalonate-semialdehyde dehydrogenase mRNA | blastn | 18636 | 248 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 15618814 | 15618814 | PRJNA1174234_P_NODE_17833_length_326_cov_1.505929_g17637_i0 | PRJNA1174234 | 17833 | 326 | 1.505929 | 4.90932854 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 592 | 1.4599999999999996e-164 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g17637 | i0 | 99.387 | 14.2883435582822 | 326 | 2 | 100 | 0 | 1 | 326 | 1227 | 1552 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 4658 | 592 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 15618869 | 15618869 | PRJNA1174234_P_NODE_25333_length_273_cov_1.155000_g25137_i0 | PRJNA1174234 | 25333 | 273 | 1.155 | 3.15315 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 1.03e-90 | NTclustered | gi|2795052452|ref|XM_067926699.1| | 4785 | g25137 | i0 | 91.6 | 83.4029304029304 | 250 | 21 | 92 | 0 | 24 | 273 | 519 | 270 | Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA | blastn | 22769 | 346 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 15618969 | 15618969 | PRJNA1174234_P_NODE_6853_length_522_cov_0.942094_g6657_i0 | PRJNA1174234 | 6853 | 522 | 0.942094 | 4.91773068 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 3.74e-43 | NTclustered | gi|2794905809|ref|XM_067889902.1| | 164328 | g6657 | i0 | 79.554 | 15.860153256705 | 269 | 51 | 51 | 4 | 56 | 323 | 24 | 289 | Phytophthora ramorum 13 kDa ribonucleoprotein-associated protein (KRP23_4892), partial mRNA | blastn | 8279 | 189 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 15618981 | 15618981 | PRJNA1174234_P_NODE_8293_length_478_cov_1.429630_g8097_i0 | PRJNA1174234 | 8293 | 478 | 1.42963 | 6.8336314 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 9.93e-9 | NTclustered | gi|673020635|ref|XM_008866057.1| | 157072 | g8097 | i0 | 79.63 | 0.648535564853556 | 108 | 18 | 22 | 4 | 1 | 106 | 1196 | 1091 | Aphanomyces invadans dihydrolipoyl dehydrogenase mRNA | blastn | 310 | 75 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 16893289 | 16893289 | PRJNA1174234_P_NODE_6014_length_555_cov_1.068465_g5818_i0 | PRJNA1174234 | 6014 | 555 | 1.068465 | 5.92998075 | Pseudoperonospora cubensis | 143453 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 1.73e-91 | NTclustered | gi|927372602|ref|NC_027859.1| | 143453 | g5818 | i0 | 79.879 | 89.1675675675676 | 497 | 84 | 87 | 9 | 46 | 528 | 23332 | 23826 | Pseudoperonospora cubensis mitochondrion, complete genome | blastn | 49488 | 350 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora cubensis | ||
| 21992653 | 21992653 | PRJNA1174234_P_NODE_12878_length_383_cov_8.454839_g12682_i0 | PRJNA1174234 | 12878 | 383 | 8.454839 | 32.38203337 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 702 | 0 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g12682 | i0 | 99.739 | 97.710182767624 | 383 | 1 | 100 | 0 | 1 | 383 | 505 | 123 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 37423 | 702 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 22717840 | 22717840 | PRJNA1174234_P_NODE_24158_length_280_cov_1.376812_g23962_i0 | PRJNA1174234 | 24158 | 280 | 1.376812 | 3.8550736 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 73.1 | 1.98e-8 | NTclustered | gi|325183295|emb|FR824085.1| | 890382 | g23962 | i0 | 92.157 | 0.939285714285714 | 51 | 4 | 21 | 0 | 140 | 190 | 34757 | 34707 | Albugo laibachii Nc14, genomic contig CONTIG_40_NC14_v4_133649_231 | blastn | 263 | 73.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 25267195 | 25267195 | PRJNA1174234_P_NODE_15060_length_355_cov_1.556738_g14864_i0 | PRJNA1174234 | 15060 | 355 | 1.556738 | 5.5264199 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 7.22e-4 | NTclustered | gi|2794880233|ref|XM_067890569.1| | 164328 | g14864 | i0 | 97.143 | 3.71549295774648 | 35 | 0 | 10 | 1 | 41 | 74 | 211 | 177 | Phytophthora ramorum Translation machinery-associated protein 22 (KRP23_570), partial mRNA | blastn | 1319 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum |
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);;