contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838704 | 838704 | PRJNA849822_P_NODE_40901_length_244_cov_1.748538_g40727_i0 | PRJNA849822 | 40901 | 244 | 1.748538 | 4.26643272 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.3e-14 | NTclustered | gi|301111441|ref|XM_002904754.1| | 403677 | g40727 | i0 | 88.312 | 0.631147540983607 | 77 | 9 | 32 | 0 | 154 | 230 | 1390 | 1314 | Phytophthora infestans T30-4 NADH dehydrogenase flavoprotein 1, mitochondrial precursor (PITG_06815), mRNA | blastn | 154 | 93.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 838763 | 838763 | PRJNA849822_P_NODE_7001_length_582_cov_7.180747_g6832_i0 | PRJNA849822 | 7001 | 582 | 7.180747 | 41.79194754 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.74e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g6832 | i0 | 80.533 | 58.1237113402062 | 375 | 65 | 63 | 4 | 191 | 558 | 441 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 1233458 | 1233458 | PRJNA849822_P_NODE_2881_length_963_cov_1.857303_g2740_i0 | PRJNA849822 | 2881 | 963 | 1.857303 | 17.88582789 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 667 | 0 | NTclustered | gi|2795054652|ref|XM_067932801.1| | 4785 | g2740 | i0 | 81.459 | 82.3167185877466 | 836 | 135 | 86 | 18 | 105 | 930 | 1236 | 411 | Phytophthora cinnamomi ATP-dependent RNA helicase eIF4A (IUM83_08428), partial mRNA | blastn | 79271 | 667 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 3389330 | 3389330 | PRJNA849822_P_NODE_28823_length_272_cov_1.351759_g28649_i0 | PRJNA849822 | 28823 | 272 | 1.351759 | 3.67678448 | Saprolegnia ferax | 4770 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 3.1200000000000003e-26 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g28649 | i0 | 80.337 | 14.3455882352941 | 178 | 31 | 65 | 4 | 96 | 271 | 45657 | 45482 | Saprolegnia ferax mitochondrion, complete genome | blastn | 3902 | 132 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 3389538 | 3389538 | PRJNA849822_P_NODE_9523_length_486_cov_2.288136_g9350_i0 | PRJNA849822 | 9523 | 486 | 2.288136 | 11.12034096 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 1.55e-66 | NTclustered | gi|2794877204|ref|XM_067892388.1| | 164328 | g9350 | i0 | 80.223 | 8.92592592592593 | 359 | 67 | 73 | 4 | 121 | 477 | 64 | 420 | Phytophthora ramorum 40S ribosomal protein S14 (KRP23_72), partial mRNA | blastn | 4338 | 267 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 3785497 | 3785497 | PRJNA849822_P_NODE_6823_length_591_cov_1.530888_g6654_i0 | PRJNA849822 | 6823 | 591 | 1.530888 | 9.04754808 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 1.7699999999999998e-121 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g6654 | i0 | 85.135 | 51.5194585448393 | 444 | 61 | 75 | 4 | 3 | 444 | 43 | 483 | Pythium splendens calmodulin mRNA, complete cds | blastn | 30448 | 449 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 7216869 | 7216869 | PRJNA849822_P_NODE_44126_length_202_cov_4.178295_g43952_i0 | PRJNA849822 | 44126 | 202 | 4.178295 | 8.4401559 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 6.15e-22 | NTclustered | gi|673042992|ref|XM_008877235.1| | 157072 | g43952 | i0 | 86.111 | 0.534653465346535 | 108 | 15 | 53 | 0 | 94 | 201 | 135 | 242 | Aphanomyces invadans UPF0468 protein mRNA | blastn | 108 | 117 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 8491314 | 8491314 | PRJNA849822_P_NODE_10387_length_462_cov_6.889460_g10214_i0 | PRJNA849822 | 10387 | 462 | 6.88946 | 31.8293052 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 6.89e-60 | NTclustered | gi|673039884|ref|XM_008875681.1| | 157072 | g10214 | i0 | 77.305 | 18.5844155844156 | 423 | 90 | 91 | 6 | 19 | 438 | 31 | 450 | Aphanomyces invadans 60S ribosomal protein mRNA | blastn | 8586 | 244 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 9766680 | 9766680 | PRJNA849822_P_NODE_27648_length_277_cov_1.941176_g27474_i0 | PRJNA849822 | 27648 | 277 | 1.941176 | 5.37705752 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 5.03e-64 | NTclustered | gi|301113823|ref|XM_002998636.1| | 403677 | g27474 | i0 | 84.151 | 57.9963898916968 | 265 | 42 | 96 | 0 | 13 | 277 | 1207 | 943 | Phytophthora infestans T30-4 ATP synthase subunit beta, putative (PITG_06595), partial mRNA | blastn | 16065 | 257 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 9766867 | 9766867 | PRJNA849822_P_NODE_9248_length_494_cov_1.717340_g9075_i0 | PRJNA849822 | 9248 | 494 | 1.71734 | 8.4836596 | Plectospira myriandra | 100863 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 3.38e-73 | NTclustered | gi|59894157|gb|AY729861.1| | 100863 | g9075 | i0 | 77.624 | 7.37246963562753 | 505 | 93 | 99 | 15 | 1 | 492 | 1098 | 601 | Plectospira myriandra heat shock protein 90 gene, partial cds | blastn | 3642 | 289 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Plectospira | Plectospira myriandra | ||
| 11042237 | 11042237 | PRJNA849822_P_NODE_22789_length_303_cov_2.034783_g22615_i0 | PRJNA849822 | 22789 | 303 | 2.034783 | 6.16539249 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 7.469999999999999e-38 | NTclustered | gi|2795036376|ref|XM_067936376.1| | 4785 | g22615 | i0 | 81.221 | 17.4125412541254 | 213 | 38 | 70 | 2 | 3 | 214 | 224 | 435 | Phytophthora cinnamomi 40S ribosomal protein S16 (IUM83_11796), partial mRNA | blastn | 5276 | 171 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 13592221 | 13592221 | PRJNA849822_P_NODE_15971_length_363_cov_1.810345_g15797_i0 | PRJNA849822 | 15971 | 363 | 1.810345 | 6.57155235 | Phytophthora richardiae | 127443 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 5.329999999999998e-55 | NTclustered | gi|156986743|gb|EU079541.1| | 127443 | g15797 | i0 | 78.378 | 32.7741046831956 | 370 | 66 | 100 | 10 | 1 | 363 | 483 | 845 | Phytophthora richardiae isolate PD_00090(P10358) heat shock protein 90 (HSP90) gene, partial cds | blastn | 11897 | 228 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora richardiae | ||
| 14866619 | 14866619 | PRJNA849822_P_NODE_28472_length_274_cov_0.995025_g28298_i0 | PRJNA849822 | 28472 | 274 | 0.995025 | 2.7263685 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 8.609999999999999e-37 | NTclustered | gi|2795017814|ref|XM_067936785.1| | 4785 | g28298 | i0 | 82.292 | 2.01459854014599 | 192 | 34 | 70 | 0 | 48 | 239 | 440 | 249 | Phytophthora cinnamomi 60S ribosomal protein L10a-1 (IUM83_12178), partial mRNA | blastn | 552 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 14866798 | 14866798 | PRJNA849822_P_NODE_9832_length_478_cov_1.343210_g9659_i0 | PRJNA849822 | 9832 | 478 | 1.34321 | 6.4205438 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 1.1e-117 | NTclustered | gi|673019533|ref|XM_008865506.1| | 157072 | g9659 | i0 | 84.919 | 89.7029288702929 | 431 | 65 | 90 | 0 | 2 | 432 | 539 | 109 | Aphanomyces invadans hypothetical protein mRNA | blastn | 42878 | 436 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 16141327 | 16141327 | PRJNA849822_P_NODE_24313_length_294_cov_1.031674_g24139_i0 | PRJNA849822 | 24313 | 294 | 1.031674 | 3.03312156 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 3.45e-16 | NTclustered | gi|698791027|ref|XM_009830244.1| | 112090 | g24139 | i0 | 77.439 | 0.557823129251701 | 164 | 37 | 56 | 0 | 25 | 188 | 16 | 179 | Aphanomyces astaci hypothetical protein partial mRNA | blastn | 164 | 99 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 17416975 | 17416975 | PRJNA849822_P_NODE_6074_length_632_cov_1.327370_g5905_i0 | PRJNA849822 | 6074 | 632 | 1.32737 | 8.3889784 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 2.13e-41 | NTclustered | gi|301093299|ref|XM_002997452.1| | 403677 | g5905 | i0 | 76.253 | 30.7879746835443 | 379 | 71 | 59 | 11 | 161 | 534 | 169 | 533 | Phytophthora infestans T30-4 nascent polypeptide-associated complex subunit alpha-like protein, putative (PITG_19008), partial mRNA | blastn | 19458 | 183 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 17810933 | 17810933 | PRJNA849822_P_NODE_21534_length_312_cov_2.284519_g21360_i0 | PRJNA849822 | 21534 | 312 | 2.284519 | 7.12769928 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.66e-67 | NTclustered | gi|695393603|ref|XM_009522363.1| | 67593 | g21360 | i0 | 82.792 | 98.8301282051282 | 308 | 45 | 97 | 8 | 8 | 310 | 954 | 650 | Phytophthora sojae hypothetical protein mRNA | blastn | 30835 | 268 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 18689943 | 18689943 | PRJNA849822_P_NODE_27255_length_279_cov_1.514563_g27081_i0 | PRJNA849822 | 27255 | 279 | 1.514563 | 4.22563077 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.92e-28 | NTclustered | gi|2795030968|ref|XM_067936713.1| | 4785 | g27081 | i0 | 82.5 | 1.72043010752688 | 160 | 26 | 57 | 2 | 71 | 229 | 330 | 172 | Phytophthora cinnamomi sporangia induced deflagellation-inducible protein (IUM83_12111), partial mRNA | blastn | 480 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 19964989 | 19964989 | PRJNA849822_P_NODE_18856_length_333_cov_1.500000_g18682_i0 | PRJNA849822 | 18856 | 333 | 1.5 | 4.995 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.77e-44 | NTclustered | gi|698802469|ref|XM_009835962.1| | 112090 | g18682 | i0 | 81.739 | 41.6696696696697 | 230 | 42 | 69 | 0 | 1 | 230 | 740 | 969 | Aphanomyces astaci V-type H(+)-translocating pyrophosphatase mRNA | blastn | 13876 | 193 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 19965087 | 19965087 | PRJNA849822_P_NODE_30776_length_263_cov_3.563158_g30602_i0 | PRJNA849822 | 30776 | 263 | 3.563158 | 9.37110554 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 6.54e-18 | NTclustered | gi|673042388|ref|XM_008876933.1| | 157072 | g30602 | i0 | 91.892 | 6.80228136882129 | 74 | 6 | 28 | 0 | 80 | 153 | 151 | 224 | Aphanomyces invadans 60S ribosomal protein L39 mRNA | blastn | 1789 | 104 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 20359941 | 20359941 | PRJNA849822_P_NODE_6016_length_636_cov_1.500888_g5847_i0 | PRJNA849822 | 6016 | 636 | 1.500888 | 9.54564768 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 1.4599999999999997e-132 | NTclustered | gi|2795052452|ref|XM_067926699.1| | 4785 | g5847 | i0 | 86.728 | 41.9072327044025 | 437 | 58 | 69 | 0 | 103 | 539 | 506 | 70 | Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA | blastn | 26653 | 486 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 21240637 | 21240637 | PRJNA849822_P_NODE_22797_length_303_cov_1.908696_g22623_i0 | PRJNA849822 | 22797 | 303 | 1.908696 | 5.78334888 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 3.3499999999999995e-61 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g22623 | i0 | 87.156 | 68.8943894389439 | 218 | 28 | 72 | 0 | 2 | 219 | 218 | 1 | A.bisexualis gene for actin | blastn | 20875 | 248 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 21635569 | 21635569 | PRJNA849822_P_NODE_22837_length_303_cov_1.356522_g22663_i0 | PRJNA849822 | 22837 | 303 | 1.356522 | 4.11026166 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 4.69e-5 | NTclustered | gi|813171669|ref|XM_012349200.1| | 695850 | g22663 | i0 | 93.023 | 0.66006600660066 | 43 | 2 | 14 | 1 | 250 | 292 | 322 | 363 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 200 | 62.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 23790982 | 23790982 | PRJNA849822_P_NODE_4619_length_738_cov_2.106767_g4455_i0 | PRJNA849822 | 4619 | 738 | 2.106767 | 15.54794046 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 507 | 1.31e-138 | NTclustered | gi|2795038286|ref|XM_067939758.1| | 4785 | g4455 | i0 | 79.555 | 93.310298102981 | 719 | 139 | 97 | 8 | 24 | 738 | 832 | 1546 | Phytophthora cinnamomi Chaperone dnaK (IUM83_14977), partial mRNA | blastn | 68863 | 507 | 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);;