contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA975724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 945381 | 945381 | PRJNA975724_S_NODE_11341_length_438_cov_25.397260_g11160_i0 | PRJNA975724 | 11341 | 438 | 25.39726 | 111.2399988 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 6.549999999999998e-55 | NTclustered | gi|813141452|ref|XM_012343573.1| | 695850 | g11160 | i0 | 80.887 | 7.51369863013699 | 293 | 52 | 66 | 4 | 107 | 397 | 767 | 477 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L8 mRNA | blastn | 3291 | 228 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 945500 | 945500 | PRJNA975724_S_NODE_16241_length_405_cov_6.641566_g16060_i0 | PRJNA975724 | 16241 | 405 | 6.641566 | 26.8983423 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 8.06e-29 | NTclustered | gi|2794917624|ref|XM_067894101.1| | 164328 | g16060 | i0 | 79.803 | 2.12592592592593 | 203 | 33 | 49 | 7 | 29 | 227 | 786 | 984 | Phytophthora ramorum Cytochrome c peroxidase, mitochondrial (KRP23_8638), partial mRNA | blastn | 861 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 945998 | 945998 | PRJNA975724_S_NODE_35521_length_331_cov_2.348837_g35340_i0 | PRJNA975724 | 35521 | 331 | 2.348837 | 7.77465047 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 3.03e-22 | NTclustered | gi|2795057987|ref|XM_067936138.1| | 4785 | g35340 | i0 | 85.217 | 27.6012084592145 | 115 | 17 | 35 | 0 | 4 | 118 | 1707 | 1821 | Phytophthora cinnamomi Electron transfer flavoprotein-ubiquinone oxidoreductase (IUM83_11567), partial mRNA | blastn | 9136 | 119 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 3496371 | 3496371 | PRJNA975724_S_NODE_25063_length_365_cov_4.253425_g24882_i0 | PRJNA975724 | 25063 | 365 | 4.253425 | 15.52500125 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 4.09e-66 | NTclustered | gi|695438657|ref|XM_009534219.1| | 67593 | g24882 | i0 | 82.838 | 36.3616438356164 | 303 | 44 | 82 | 7 | 65 | 363 | 1203 | 905 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 13272 | 265 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 3818760 | 3818760 | PRJNA975724_S_NODE_27903_length_355_cov_1.918440_g27722_i0 | PRJNA975724 | 27903 | 355 | 1.91844 | 6.810462 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 1.1e-66 | NTclustered | gi|2308292407|gb|OK574296.1| | 129350 | g27722 | i0 | 81.875 | 83.4253521126761 | 320 | 54 | 90 | 4 | 38 | 355 | 8196 | 8513 | Phytophthora colocasiae voucher Fj20_1 mitochondrion, complete genome | blastn | 29616 | 267 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora colocasiae | ||
| 4774217 | 4774217 | PRJNA975724_S_NODE_3184_length_583_cov_17.943137_g3010_i0 | PRJNA975724 | 3184 | 583 | 17.943137 | 104.60848871 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 5.4e-47 | NTclustered | gi|669151349|ref|XM_008613015.1| | 1156394 | g3010 | i0 | 83.117 | 27.1989708404803 | 231 | 30 | 39 | 7 | 332 | 556 | 1594 | 1367 | Saprolegnia diclina VS20 adenosylhomocysteinase mRNA | blastn | 15857 | 202 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 6050039 | 6050039 | PRJNA975724_S_NODE_6745_length_490_cov_2.273381_g6564_i0 | PRJNA975724 | 6745 | 490 | 2.273381 | 11.1395669 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 6.99e-95 | NTclustered | gi|2308292368|gb|OK574295.1| | 29920 | g6564 | i0 | 81.292 | 38.3816326530612 | 449 | 80 | 91 | 4 | 3 | 449 | 9902 | 10348 | Phytophthora cactorum voucher CH9812411 mitochondrion, complete genome | blastn | 18807 | 361 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 6050263 | 6050263 | PRJNA975724_S_NODE_75645_length_254_cov_4.629834_g75464_i0 | PRJNA975724 | 75645 | 254 | 4.629834 | 11.75977836 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 6.28e-18 | NTclustered | gi|166043101|emb|CU357747.1| | 100861 | g75464 | i0 | 81.89 | 1.0511811023622 | 127 | 20 | 50 | 2 | 125 | 251 | 922 | 799 | Aphanomyces euteiches cDNA | blastn | 267 | 104 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 7324946 | 7324946 | PRJNA975724_S_NODE_75086_length_255_cov_2.115385_g74905_i0 | PRJNA975724 | 75086 | 255 | 2.115385 | 5.39423175 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.87e-19 | NTclustered | gi|325195177|emb|FR825972.1| | 890382 | g74905 | i0 | 80.69 | 37.1882352941176 | 145 | 23 | 55 | 5 | 97 | 237 | 302 | 445 | Albugo laibachii Nc14, genomic contig CONTIG_3045_NC14_v4_482_22195 | blastn | 9483 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7325266 | 7325266 | PRJNA975724_S_NODE_87146_length_244_cov_1.350877_g86965_i0 | PRJNA975724 | 87146 | 244 | 1.350877 | 3.29613988 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.67e-46 | NTclustered | gi|301111827|ref|XM_002904947.1| | 403677 | g86965 | i0 | 82.379 | 25.1803278688525 | 227 | 40 | 93 | 0 | 16 | 242 | 537 | 763 | Phytophthora infestans T30-4 isocitrate lyase (PITG_07027), mRNA | blastn | 6144 | 198 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 7325445 | 7325445 | PRJNA975724_S_NODE_93786_length_228_cov_2.387097_g93605_i0 | PRJNA975724 | 93786 | 228 | 2.387097 | 5.44258116 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.17e-29 | NTclustered | gi|937408816|ref|NC_027966.1| | 114742 | g93605 | i0 | 82.036 | 49.6447368421053 | 167 | 30 | 73 | 0 | 37 | 203 | 35546 | 35712 | Pythium insidiosum mitochondrial DNA, complete genome | blastn | 11319 | 143 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 7644866 | 7644866 | PRJNA975724_S_NODE_46_length_2162_cov_21.900431_g41_i0 | PRJNA975724 | 46 | 2162 | 21.900431 | 473.48731822 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 3.49e-49 | NTclustered | gi|937408816|ref|NC_027966.1| | 114742 | g41 | i0 | 79.739 | 15.2428307123034 | 306 | 51 | 14 | 10 | 324 | 623 | 9797 | 10097 | Pythium insidiosum mitochondrial DNA, complete genome | blastn | 32955 | 213 | 0.990610328638498 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 8919606 | 8919606 | PRJNA975724_S_NODE_11987_length_433_cov_15.858333_g11806_i0 | PRJNA975724 | 11987 | 433 | 15.858333 | 68.66658189 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 2.41e-29 | NTclustered | gi|698822380|ref|XM_009845917.1| | 112090 | g11806 | i0 | 78.378 | 28.8013856812933 | 222 | 46 | 51 | 2 | 208 | 428 | 422 | 202 | Aphanomyces astaci hypothetical protein mRNA | blastn | 12471 | 143 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8919705 | 8919705 | PRJNA975724_S_NODE_77787_length_251_cov_4.455056_g77606_i0 | PRJNA975724 | 77787 | 251 | 4.455056 | 11.18219056 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 2.84e-26 | NTclustered | gi|2795022847|ref|XM_067930005.1| | 4785 | g77606 | i0 | 81.176 | 3.27490039840637 | 170 | 26 | 68 | 1 | 80 | 249 | 1304 | 1141 | Phytophthora cinnamomi Histone-binding protein RBBP4 (IUM83_05845), partial mRNA | blastn | 822 | 132 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9873982 | 9873982 | PRJNA975724_S_NODE_28228_length_354_cov_1.644128_g28047_i0 | PRJNA975724 | 28228 | 354 | 1.644128 | 5.82021312 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.033 | NTclustered | gi|2795057611|ref|XM_067940868.1| | 4785 | g28047 | i0 | 100 | 0.0790960451977401 | 28 | 0 | 8 | 0 | 88 | 115 | 458 | 485 | Phytophthora cinnamomi Zinc ion binding protein (IUM83_16014), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 12426291 | 12426291 | PRJNA975724_S_NODE_7730_length_475_cov_17.582090_g7549_i0 | PRJNA975724 | 7730 | 475 | 17.58209 | 83.5149275 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 7.68e-5 | NTclustered | gi|675189506|ref|XM_008905390.1| | 761204 | g7549 | i0 | 97.222 | 0.0757894736842105 | 36 | 1 | 8 | 0 | 440 | 475 | 414 | 379 | Phytophthora parasitica INRA-310 histone partial mRNA | blastn | 36 | 62.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 14020603 | 14020603 | PRJNA975724_S_NODE_11851_length_434_cov_22.141274_g11670_i0 | PRJNA975724 | 11851 | 434 | 22.141274 | 96.09312916 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 2.42e-29 | NTclustered | gi|813164367|ref|XM_012347854.1| | 695850 | g11670 | i0 | 77.459 | 1.56912442396313 | 244 | 51 | 56 | 4 | 129 | 370 | 331 | 90 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L37-A mRNA | blastn | 681 | 143 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14973655 | 14973655 | PRJNA975724_S_NODE_26372_length_360_cov_6.905923_g26191_i0 | PRJNA975724 | 26372 | 360 | 6.905923 | 24.8613228 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 5.67e-5 | NTclustered | gi|813184929|ref|XM_012351247.1| | 695850 | g26191 | i0 | 93.023 | 0.25 | 43 | 2 | 12 | 1 | 188 | 230 | 1974 | 1933 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 90 | 62.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14974705 | 14974705 | PRJNA975724_S_NODE_66652_length_268_cov_1.184615_g66471_i0 | PRJNA975724 | 66652 | 268 | 1.184615 | 3.1747682 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 6.4e-48 | NTclustered | gi|813141452|ref|XM_012343573.1| | 695850 | g66471 | i0 | 82.895 | 17.3768656716418 | 228 | 37 | 85 | 2 | 42 | 268 | 767 | 541 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L8 mRNA | blastn | 4657 | 204 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 16248358 | 16248358 | PRJNA975724_S_NODE_16213_length_405_cov_32.319277_g16032_i0 | PRJNA975724 | 16213 | 405 | 32.319277 | 130.89307185 | Halophytophthora thermoambigua | 2874305 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 2.19e-44 | NTclustered | gi|2213903340|gb|OK091352.1| | 2874305 | g16032 | i0 | 78.808 | 72.5086419753086 | 302 | 52 | 74 | 10 | 107 | 405 | 416 | 124 | Halophytophthora sp. MHJ-2021h isolate BD630 from Portugal heat shock protein 90 (hsp90) gene, partial cds | blastn | 29366 | 193 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Halophytophthora | Halophytophthora thermoambigua | ||
| 17525575 | 17525575 | PRJNA975724_S_NODE_92774_length_234_cov_3.236025_g92593_i0 | PRJNA975724 | 92774 | 234 | 3.236025 | 7.5722985 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.99e-37 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g92593 | i0 | 84 | 17.8034188034188 | 175 | 28 | 75 | 0 | 1 | 175 | 18823 | 18997 | Achlya hypogyna mitochondrion, complete genome | blastn | 4166 | 169 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 21347487 | 21347487 | PRJNA975724_S_NODE_13337_length_423_cov_8.654286_g13156_i0 | PRJNA975724 | 13337 | 423 | 8.654286 | 36.60762978 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 6.49e-35 | NTclustered | gi|698822200|ref|XM_009845827.1| | 112090 | g13156 | i0 | 81.095 | 24.0756501182033 | 201 | 38 | 48 | 0 | 177 | 377 | 551 | 351 | Aphanomyces astaci peptidyl-prolyl cis-trans isomerase 1 mRNA | blastn | 10184 | 161 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci |
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);;