contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1010662" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1001447 | 1001447 | PRJNA1010662_P_NODE_8861_length_192_cov_2.601399_g8802_i0 | PRJNA1010662 | 8861 | 192 | 2.601399 | 4.99468608 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 4.31e-48 | NTclustered | gi|164508134|emb|AM412176.1| | 4785 | g8802 | i0 | 91.275 | 80.1354166666667 | 149 | 13 | 78 | 0 | 43 | 191 | 10 | 158 | Phytophthora cinnamomi act2 gene for actin, strain Pr120 | blastn | 15386 | 206 | 0.990291262135922 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 1429749 | 1429749 | PRJNA1010662_S_NODE_1002_length_296_cov_6.754941_g957_i0 | PRJNA1010662 | 1002 | 296 | 6.754941 | 19.99462536 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 6.359999999999999e-133 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g957 | i0 | 96.284 | 100.168918918919 | 296 | 11 | 100 | 0 | 1 | 296 | 357 | 62 | 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 | 29650 | 486 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 2705160 | 2705160 | PRJNA1010662_P_NODE_543_length_671_cov_3.136656_g492_i0 | PRJNA1010662 | 543 | 671 | 3.136656 | 21.04696176 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 1.3499999999999999e-48 | NTclustered | gi|813133999|ref|XM_012342618.1| | 695850 | g492 | i0 | 81.496 | 3.43666169895678 | 254 | 45 | 38 | 2 | 70 | 322 | 72 | 324 | Saprolegnia parasitica CBS 223.65 ribonucleoprotein-associated protein mRNA | blastn | 2306 | 207 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 2705220 | 2705220 | PRJNA1010662_S_NODE_3023_length_193_cov_2.013333_g2978_i0 | PRJNA1010662 | 3023 | 193 | 2.013333 | 3.88573269 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 5.27e-92 | NTclustered | gi|1578815423|gb|MK546600.1| | 1982524 | g2978 | i0 | 100 | 97.979274611399 | 189 | 0 | 98 | 0 | 1 | 189 | 840 | 652 | Aphanomyces sp. voucher CPZ14 large subunit ribosomal RNA gene, partial sequence | blastn | 18910 | 350 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 4829426 | 4829426 | PRJNA1010662_P_NODE_12584_length_169_cov_0.866667_g12525_i0 | PRJNA1010662 | 12584 | 169 | 0.866667 | 1.46466723 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 8.26e-20 | NTclustered | gi|813222734|ref|XM_012356268.1| | 695850 | g12525 | i0 | 80.986 | 8.09467455621302 | 142 | 23 | 83 | 4 | 21 | 160 | 282 | 143 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 1368 | 110 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 6104615 | 6104615 | PRJNA1010662_P_NODE_6285_length_219_cov_2.070588_g6226_i0 | PRJNA1010662 | 6285 | 219 | 2.070588 | 4.53458772 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 8.76e-21 | NTclustered | gi|2795032696|ref|XM_067933028.1| | 4785 | g6226 | i0 | 78.286 | 4.91324200913242 | 175 | 38 | 80 | 0 | 40 | 214 | 330 | 156 | Phytophthora cinnamomi cytochrome c (IUM83_08641), partial mRNA | blastn | 1076 | 113 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 7807503 | 7807503 | PRJNA1010662_P_NODE_8807_length_193_cov_1.423611_g8748_i0 | PRJNA1010662 | 8807 | 193 | 1.423611 | 2.74756923 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 4.43e-33 | NTclustered | gi|669143973|ref|XM_008609327.1| | 1156394 | g8748 | i0 | 83.636 | 1.38341968911917 | 165 | 25 | 85 | 2 | 30 | 193 | 380 | 217 | Saprolegnia diclina VS20 50S ribosomal protein L21e mRNA | blastn | 267 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 9082324 | 9082324 | PRJNA1010662_P_NODE_10968_length_178_cov_1.201550_g10909_i0 | PRJNA1010662 | 10968 | 178 | 1.20155 | 2.138759 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.17e-19 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g10909 | i0 | 79.605 | 12.4887640449438 | 152 | 29 | 85 | 2 | 1 | 151 | 277 | 127 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 2223 | 108 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 9082434 | 9082434 | PRJNA1010662_P_NODE_7128_length_210_cov_0.950311_g7069_i0 | PRJNA1010662 | 7128 | 210 | 0.950311 | 1.9956531 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 2.37e-6 | NTclustered | gi|675173790|ref|XM_008897532.1| | 761204 | g7069 | i0 | 95.122 | 0.195238095238095 | 41 | 2 | 20 | 0 | 29 | 69 | 368 | 328 | Phytophthora parasitica INRA-310 CMGC/RCK protein kinase mRNA | blastn | 41 | 65.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 9082481 | 9082481 | PRJNA1010662_S_NODE_2548_length_206_cov_7.361963_g2503_i0 | PRJNA1010662 | 2548 | 206 | 7.361963 | 15.16564378 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 9.539999999999999e-90 | NTclustered | gi|256009645|gb|GQ374534.1| | 112090 | g2503 | i0 | 96.602 | 96.868932038835 | 206 | 7 | 100 | 0 | 1 | 206 | 188 | 393 | Aphanomyces astaci strain Gb04 28S ribosomal RNA gene, partial sequence | blastn | 19955 | 342 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 10358004 | 10358004 | PRJNA1010662_P_NODE_2109_length_349_cov_6.386667_g2050_i0 | PRJNA1010662 | 2109 | 349 | 6.386667 | 22.28946783 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.37e-53 | NTclustered | gi|698791735|ref|XM_009830598.1| | 112090 | g2050 | i0 | 79.228 | 26.1117478510029 | 337 | 57 | 94 | 11 | 19 | 347 | 554 | 223 | Aphanomyces astaci malate dehydrogenase, NAD-dependent mRNA | blastn | 9113 | 222 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 10358093 | 10358093 | PRJNA1010662_S_NODE_1869_length_232_cov_2.465608_g1824_i0 | PRJNA1010662 | 1869 | 232 | 2.465608 | 5.72021056 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 8.2e-116 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g1824 | i0 | 100 | 101.129310344828 | 232 | 0 | 100 | 0 | 1 | 232 | 91 | 322 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 23462 | 429 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 11633534 | 11633534 | PRJNA1010662_P_NODE_6470_length_217_cov_1.244048_g6411_i0 | PRJNA1010662 | 6470 | 217 | 1.244048 | 2.69958416 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 5.22e-18 | NTclustered | gi|669161361|ref|XM_008618021.1| | 1156394 | g6411 | i0 | 90 | 25.4562211981567 | 80 | 8 | 37 | 0 | 87 | 166 | 1392 | 1313 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 5524 | 104 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 11633589 | 11633589 | PRJNA1010662_S_NODE_4130_length_169_cov_3.968254_g4085_i0 | PRJNA1010662 | 4130 | 169 | 3.968254 | 6.70634926 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 3.71e-43 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g4085 | i0 | 86.982 | 37.9585798816568 | 169 | 19 | 99 | 3 | 3 | 169 | 1575 | 1742 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 6415 | 187 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 19280524 | 19280524 | PRJNA1010662_S_NODE_4156_length_169_cov_1.714286_g4111_i0 | PRJNA1010662 | 4156 | 169 | 1.714286 | 2.89714334 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.58e-80 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g4111 | i0 | 100 | 99.2781065088757 | 167 | 0 | 99 | 0 | 3 | 169 | 572 | 738 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 16778 | 309 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 25227660 | 25227660 | PRJNA1010662_P_NODE_10500_length_181_cov_1.181818_g10441_i0 | PRJNA1010662 | 10500 | 181 | 1.181818 | 2.13909058 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 1.13e-38 | NTclustered | gi|2795054923|ref|XM_067941504.1| | 4785 | g10441 | i0 | 84.571 | 18.9502762430939 | 175 | 25 | 96 | 2 | 4 | 177 | 405 | 232 | Phytophthora cinnamomi S-adenosylmethionine synthase 2 (IUM83_16610), partial mRNA | blastn | 3430 | 172 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 25227730 | 25227730 | PRJNA1010662_S_NODE_4440_length_164_cov_3.355372_g4395_i0 | PRJNA1010662 | 4440 | 164 | 3.355372 | 5.50281008 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.42e-78 | NTclustered | gi|166048041|emb|CU364162.1| | 100861 | g4395 | i0 | 100 | 96.7682926829268 | 164 | 0 | 100 | 0 | 1 | 164 | 536 | 373 | Aphanomyces euteiches cDNA | blastn | 15870 | 303 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;