contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA278119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371067 | 371067 | PRJNA278119_P_NODE_1561_length_980_cov_2.139635_g1376_i0 | PRJNA278119 | 1561 | 980 | 2.139635 | 20.968423 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 658 | 0 | NTclustered | gi|675185100|ref|XM_008903187.1| | 761204 | g1376 | i0 | 80.225 | 63.1510204081633 | 890 | 164 | 90 | 10 | 100 | 980 | 1771 | 885 | Phytophthora parasitica INRA-310 luminal-binding protein mRNA | blastn | 61888 | 658 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 371404 | 371404 | PRJNA278119_P_NODE_4041_length_600_cov_7.566243_g3801_i0 | PRJNA278119 | 4041 | 600 | 7.566243 | 45.397458 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 5.34e-77 | NTclustered | gi|698822976|ref|XM_009846215.1| | 112090 | g3801 | i0 | 78.452 | 59.15 | 478 | 91 | 79 | 9 | 32 | 504 | 57 | 527 | Aphanomyces astaci 40S ribosomal protein S13 mRNA | blastn | 35490 | 302 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 371538 | 371538 | PRJNA278119_P_NODE_6181_length_479_cov_2.772093_g5935_i0 | PRJNA278119 | 6181 | 479 | 2.772093 | 13.27832547 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 5.54e-61 | NTclustered | gi|166044724|emb|CU350983.1| | 100861 | g5935 | i0 | 80.428 | 40.9895615866388 | 327 | 62 | 68 | 2 | 151 | 476 | 146 | 471 | Aphanomyces euteiches cDNA | blastn | 19634 | 248 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 6749042 | 6749042 | PRJNA278119_P_NODE_33766_length_171_cov_1.278689_g33517_i0 | PRJNA278119 | 33766 | 171 | 1.278689 | 2.18655819 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 4.939999999999999e-32 | NTclustered | gi|301091304|ref|XM_002895794.1| | 403677 | g33517 | i0 | 84.177 | 1.59649122807018 | 158 | 21 | 91 | 4 | 16 | 171 | 356 | 201 | Phytophthora infestans T30-4 ADP-ribosylation factor family (PITG_20206), mRNA | blastn | 273 | 150 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 7436771 | 7436771 | PRJNA278119_P_NODE_34806_length_169_cov_1.175000_g34557_i0 | PRJNA278119 | 34806 | 169 | 1.175 | 1.98575 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 4.9000000000000005e-27 | NTclustered | gi|1236228842|gb|MF036250.1| | 78236 | g34557 | i0 | 85.385 | 76.0059171597633 | 130 | 17 | 76 | 2 | 4 | 132 | 389 | 261 | Phytophthora quercina isolate PL9 heat shock protein 90 (HSP90) gene, partial cds | blastn | 12845 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora quercina | ||
| 8024362 | 8024362 | PRJNA278119_P_NODE_13267_length_308_cov_1.362934_g13019_i0 | PRJNA278119 | 13267 | 308 | 1.362934 | 4.19783672 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 9.43e-67 | NTclustered | gi|2795031183|ref|XM_067929373.1| | 4785 | g13019 | i0 | 82.41 | 15.7727272727273 | 307 | 52 | 99 | 2 | 3 | 308 | 1041 | 736 | Phytophthora cinnamomi V-type ATPase, A subunit (IUM83_05246), partial mRNA | blastn | 4858 | 267 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 8024372 | 8024372 | PRJNA278119_P_NODE_13687_length_301_cov_1.178571_g13438_i0 | PRJNA278119 | 13687 | 301 | 1.178571 | 3.54749871 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 4.43e-40 | NTclustered | gi|813171835|ref|XM_012349283.1| | 695850 | g13438 | i0 | 77.778 | 2.86378737541528 | 306 | 57 | 100 | 11 | 1 | 301 | 725 | 1024 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 862 | 178 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 8024498 | 8024498 | PRJNA278119_P_NODE_2227_length_822_cov_11.727038_g2016_i0 | PRJNA278119 | 2227 | 822 | 11.727038 | 96.39625236 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 1338 | 0 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g2016 | i0 | 96.543 | 1.45863746958637 | 810 | 25 | 99 | 2 | 2 | 811 | 1380 | 574 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 1199 | 1338 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 8024836 | 8024836 | PRJNA278119_P_NODE_5227_length_522_cov_1.818182_g4983_i0 | PRJNA278119 | 5227 | 522 | 1.818182 | 9.49091004 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 2.2e-55 | NTclustered | gi|669165625|ref|XM_008620153.1| | 1156394 | g4983 | i0 | 79.179 | 4.09195402298851 | 341 | 63 | 65 | 7 | 162 | 498 | 1379 | 1043 | Saprolegnia diclina VS20 succinyl-CoA synthetase beta subunit mRNA | blastn | 2136 | 230 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 11849909 | 11849909 | PRJNA278119_P_NODE_30190_length_180_cov_1.587786_g29941_i0 | PRJNA278119 | 30190 | 180 | 1.587786 | 2.8580148 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 2.4e-45 | NTclustered | gi|166303|gb|J05116.1|ACKCAL | 4767 | g29941 | i0 | 86.188 | 91.9666666666667 | 181 | 23 | 100 | 2 | 1 | 180 | 615 | 794 | A.klebsiana calmodulin gene, complete cds | blastn | 16554 | 195 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 13125392 | 13125392 | PRJNA278119_P_NODE_6331_length_474_cov_3.357647_g6085_i0 | PRJNA278119 | 6331 | 474 | 3.357647 | 15.91524678 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 3.27e-63 | NTclustered | gi|695428657|ref|XM_009531708.1| | 67593 | g6085 | i0 | 80.712 | 12.0021097046414 | 337 | 57 | 70 | 7 | 1 | 333 | 378 | 46 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 5689 | 255 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 14400551 | 14400551 | PRJNA278119_P_NODE_6752_length_458_cov_2.310513_g6506_i0 | PRJNA278119 | 6752 | 458 | 2.310513 | 10.58214954 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 6.879999999999999e-55 | NTclustered | gi|673036179|ref|XM_008873829.1| | 157072 | g6506 | i0 | 82.222 | 56.0458515283843 | 270 | 42 | 58 | 5 | 1 | 267 | 2563 | 2829 | Aphanomyces invadans hypothetical protein mRNA | blastn | 25669 | 228 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 15673706 | 15673706 | PRJNA278119_P_NODE_11233_length_345_cov_1.875000_g10986_i0 | PRJNA278119 | 11233 | 345 | 1.875 | 6.46875 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 3.06e-47 | NTclustered | gi|698791735|ref|XM_009830598.1| | 112090 | g10986 | i0 | 81.967 | 30.2463768115942 | 244 | 38 | 70 | 6 | 105 | 345 | 554 | 314 | Aphanomyces astaci malate dehydrogenase, NAD-dependent mRNA | blastn | 10435 | 202 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 15674212 | 15674212 | PRJNA278119_P_NODE_46333_length_162_cov_1.380531_g46084_i0 | PRJNA278119 | 46333 | 162 | 1.380531 | 2.23646022 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 3.6199999999999997e-28 | NTclustered | gi|813198519|ref|XM_012353453.1| | 695850 | g46084 | i0 | 84.672 | 13.4259259259259 | 137 | 21 | 85 | 0 | 5 | 141 | 320 | 184 | Saprolegnia parasitica CBS 223.65 succinate dehydrogenase iron-sulfur subunit mRNA | blastn | 2175 | 137 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 16948937 | 16948937 | PRJNA278119_P_NODE_6554_length_466_cov_1.378897_g6308_i0 | PRJNA278119 | 6554 | 466 | 1.378897 | 6.42566002 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 3.15e-78 | NTclustered | gi|813173920|ref|XM_012349524.1| | 695850 | g6308 | i0 | 79.176 | 2.66738197424893 | 461 | 80 | 97 | 12 | 14 | 466 | 916 | 464 | Saprolegnia parasitica CBS 223.65 tyrosyl-tRNA synthetase mRNA | blastn | 1243 | 305 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 19496964 | 19496964 | PRJNA278119_P_NODE_1076_length_1168_cov_3.486148_g922_i0 | PRJNA278119 | 1076 | 1168 | 3.486148 | 40.71820864 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 534 | 9.7e-147 | NTclustered | gi|166034915|emb|CU351915.1| | 100861 | g922 | i0 | 79.02 | 54.3844178082192 | 796 | 155 | 68 | 10 | 146 | 935 | 61 | 850 | Aphanomyces euteiches cDNA | blastn | 63521 | 534 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 20772564 | 20772564 | PRJNA278119_P_NODE_1797_length_920_cov_1.517796_g1606_i0 | PRJNA278119 | 1797 | 920 | 1.517796 | 13.9637232 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 2.8e-126 | NTclustered | gi|166050425|emb|CU356122.1| | 100861 | g1606 | i0 | 79.285 | 16.645652173913 | 671 | 135 | 73 | 4 | 180 | 848 | 840 | 172 | Aphanomyces euteiches cDNA | blastn | 15314 | 466 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21460454 | 21460454 | PRJNA278119_P_NODE_1357_length_1048_cov_2.059059_g1178_i0 | PRJNA278119 | 1357 | 1048 | 2.059059 | 21.57893832 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 747 | 0 | NTclustered | gi|2795054652|ref|XM_067932801.1| | 4785 | g1178 | i0 | 79.749 | 90.7261450381679 | 1037 | 184 | 98 | 21 | 25 | 1047 | 188 | 1212 | Phytophthora cinnamomi ATP-dependent RNA helicase eIF4A (IUM83_08428), partial mRNA | blastn | 95081 | 747 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 22047873 | 22047873 | PRJNA278119_P_NODE_378_length_1669_cov_8.166049_g308_i0 | PRJNA278119 | 378 | 1669 | 8.166049 | 136.29135781 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 893 | 0 | NTclustered | gi|669151349|ref|XM_008613015.1| | 1156394 | g308 | i0 | 78.471 | 67.407429598562 | 1426 | 264 | 84 | 35 | 235 | 1634 | 1543 | 135 | Saprolegnia diclina VS20 adenosylhomocysteinase mRNA | blastn | 112503 | 893 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 22048065 | 22048065 | PRJNA278119_P_NODE_7878_length_423_cov_2.446524_g7631_i0 | PRJNA278119 | 7878 | 423 | 2.446524 | 10.34879652 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 2.38e-19 | NTclustered | gi|675176198|ref|XM_008898736.1| | 761204 | g7631 | i0 | 85.577 | 2.96926713947991 | 104 | 15 | 25 | 0 | 320 | 423 | 540 | 437 | Phytophthora parasitica INRA-310 iron sulfur cluster assembly protein 1 mRNA | blastn | 1256 | 110 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 23323470 | 23323470 | PRJNA278119_P_NODE_42559_length_164_cov_2.591304_g42310_i0 | PRJNA278119 | 42559 | 164 | 2.591304 | 4.24973856 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 7.73e-45 | NTclustered | gi|166301|gb|J05597.1|ACKBTUB | 4767 | g42310 | i0 | 88.199 | 89.780487804878 | 161 | 19 | 98 | 0 | 3 | 163 | 1258 | 1418 | A.klebsiana beta-tubulin gene, complete cds | blastn | 14724 | 193 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 24597232 | 24597232 | PRJNA278119_P_NODE_18580_length_236_cov_1.112299_g18331_i0 | PRJNA278119 | 18580 | 236 | 1.112299 | 2.62502564 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.52e-61 | NTclustered | gi|2795026083|ref|XM_067925526.1| | 4785 | g18331 | i0 | 86.076 | 83.5423728813559 | 237 | 25 | 99 | 7 | 1 | 233 | 447 | 215 | Phytophthora cinnamomi alanine-tRNA ligase (IUM83_01657), partial mRNA | blastn | 19716 | 248 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 24597570 | 24597570 | PRJNA278119_P_NODE_41980_length_165_cov_0.896552_g41731_i0 | PRJNA278119 | 41980 | 165 | 0.896552 | 1.4793108 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 1.71e-31 | NTclustered | gi|698781354|ref|XM_009825419.1| | 112090 | g41731 | i0 | 83.133 | 1.00606060606061 | 166 | 24 | 99 | 3 | 2 | 165 | 494 | 331 | Aphanomyces astaci hypothetical protein mRNA | blastn | 166 | 148 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 24597589 | 24597589 | PRJNA278119_P_NODE_43040_length_164_cov_1.313043_g42791_i0 | PRJNA278119 | 43040 | 164 | 1.313043 | 2.15339052 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 3.67e-28 | NTclustered | gi|673024575|ref|XM_008868027.1| | 157072 | g42791 | i0 | 90.385 | 55.1341463414634 | 104 | 10 | 63 | 0 | 5 | 108 | 1184 | 1081 | Aphanomyces invadans tubulin beta chain mRNA | blastn | 9042 | 137 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans |
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);;