contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA577580" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9492409 | 9492409 | PRJNA577580_P_NODE_14168_length_250_cov_1.983051_g14090_i0 | PRJNA577580 | 14168 | 250 | 1.983051 | 4.9576275 | Phytophthora colocasiae | 129350 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.75e-46 | NTclustered | gi|2308292407|gb|OK574296.1| | 129350 | g14090 | i0 | 86.932 | 70.256 | 176 | 23 | 70 | 0 | 15 | 190 | 8437 | 8612 | Phytophthora colocasiae voucher Fj20_1 mitochondrion, complete genome | blastn | 17564 | 198 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora colocasiae | ||
| 10066655 | 10066655 | PRJNA577580_P_NODE_2248_length_604_cov_3.306968_g2170_i0 | PRJNA577580 | 2248 | 604 | 3.306968 | 19.97408672 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 1.5e-77 | NTclustered | gi|2431515601|ref|NC_070108.1| | 230839 | g2170 | i0 | 78.794 | 75.5132450331126 | 481 | 81 | 78 | 12 | 89 | 562 | 2022 | 2488 | Peronosclerospora sorghi isolate P6 mitochondrion, complete genome | blastn | 45610 | 303 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 12043094 | 12043094 | PRJNA577580_P_NODE_14970_length_247_cov_1.534483_g14892_i0 | PRJNA577580 | 14970 | 247 | 1.534483 | 3.79017301 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 5.659999999999999e-68 | NTclustered | gi|328802538|emb|FR832890.1| | 890382 | g14892 | i0 | 87.554 | 86.9554655870445 | 233 | 29 | 94 | 0 | 14 | 246 | 1306 | 1074 | Albugo laibachii Nc14, mitochondrial genomic contig NODE_36_length_2553_cov_1396.121460 | blastn | 21478 | 270 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 12043109 | 12043109 | PRJNA577580_P_NODE_170_length_1628_cov_11.859807_g149_i0 | PRJNA577580 | 170 | 1628 | 11.859807 | 193.07765796 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 756 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g149 | i0 | 77.232 | 58.4846437346437 | 1344 | 272 | 82 | 30 | 135 | 1461 | 48027 | 49353 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 95213 | 756 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13317979 | 13317979 | PRJNA577580_P_NODE_11991_length_267_cov_1.608247_g11913_i0 | PRJNA577580 | 11991 | 267 | 1.608247 | 4.29401949 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.06e-50 | NTclustered | gi|2795026849|ref|XM_067926286.1| | 4785 | g11913 | i0 | 81.203 | 98.7228464419476 | 266 | 48 | 99 | 2 | 1 | 265 | 527 | 263 | Phytophthora cinnamomi succinyl-CoA ligase [GDP-forming] subunit alpha, mitochondrial (IUM83_02375), partial mRNA | blastn | 26359 | 213 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 17715985 | 17715985 | PRJNA577580_P_NODE_10274_length_286_cov_2.070423_g10196_i0 | PRJNA577580 | 10274 | 286 | 2.070423 | 5.92140978 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 2.61e-12 | NTclustered | gi|2311026826|gb|OP554785.1| | 4798 | g10196 | i0 | 93.22 | 16.7342657342657 | 59 | 3 | 20 | 1 | 1 | 58 | 410 | 352 | Pythium hydnosporum isolate R-28 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 4786 | 86.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium hydnosporum | ||
| 18415995 | 18415995 | PRJNA577580_P_NODE_9595_length_295_cov_1.405405_g9517_i0 | PRJNA577580 | 9595 | 295 | 1.405405 | 4.14594475 | Phytopythium vexans | 907947 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 3.009999999999999e-116 | NTclustered | gi|90655144|gb|DQ361265.1| | 907947 | g9517 | i0 | 92.929 | 100.996610169492 | 297 | 19 | 100 | 2 | 1 | 295 | 78 | 374 | Pythium vexans large subunit ribosomal RNA gene, partial sequence | blastn | 29794 | 431 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium vexans | ||
| 18989489 | 18989489 | PRJNA577580_P_NODE_12075_length_266_cov_2.134715_g11997_i0 | PRJNA577580 | 12075 | 266 | 2.134715 | 5.6783419 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.93e-25 | NTclustered | gi|1663822450|gb|MH730822.1| | 184466 | g11997 | i0 | 93.103 | 32.4774436090226 | 87 | 6 | 33 | 0 | 178 | 264 | 858 | 772 | Peronospora arborescens voucher GLM64105 28S ribosomal RNA gene, partial sequence | blastn | 8639 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora arborescens | ||
| 18989496 | 18989496 | PRJNA577580_P_NODE_455_length_1216_cov_23.739283_g417_i0 | PRJNA577580 | 455 | 1216 | 23.739283 | 288.66968128 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 1.5e-50 | NTclustered | gi|813199071|ref|XR_001099870.1| | 695850 | g417 | i0 | 85.446 | 20.8141447368421 | 213 | 23 | 32 | 7 | 730 | 938 | 866 | 658 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 25310 | 217 | 0.990783410138249 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 20264646 | 20264646 | PRJNA577580_P_NODE_9076_length_302_cov_1.375546_g8998_i0 | PRJNA577580 | 9076 | 302 | 1.375546 | 4.15414892 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.6e-57 | NTclustered | gi|813150484|ref|XM_012345499.1| | 695850 | g8998 | i0 | 81.126 | 21.0132450331126 | 302 | 49 | 99 | 8 | 5 | 302 | 397 | 694 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein S3a-2 mRNA | blastn | 6346 | 235 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 22241105 | 22241105 | PRJNA577580_P_NODE_12238_length_265_cov_1.145833_g12160_i0 | PRJNA577580 | 12238 | 265 | 1.145833 | 3.03645745 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 2.0199999999999998e-132 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g12160 | i0 | 99.623 | 109.369811320755 | 265 | 1 | 100 | 0 | 1 | 265 | 2145 | 2409 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 28983 | 484 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 22815300 | 22815300 | PRJNA577580_P_NODE_17178_length_222_cov_5.221477_g17100_i0 | PRJNA577580 | 17178 | 222 | 5.221477 | 11.59167894 | Lagenidium | 4802 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 2.8199999999999996e-110 | NTclustered | gi|918464324|gb|KT257472.1| | 4803 | g17100 | i0 | 100 | 100.045045045045 | 222 | 0 | 100 | 0 | 1 | 222 | 876 | 1097 | Lagenidium giganteum internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 22210 | 411 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum |
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);;