contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015894 | 2015894 | PRJNA758398_S_NODE_4002_length_473_cov_2.929245_g3861_i0 | PRJNA758398 | 4002 | 473 | 2.929245 | 13.85532885 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 3.29e-58 | NTclustered | gi|166041070|emb|CU355542.1| | 100861 | g3861 | i0 | 79.819 | 32.0021141649049 | 332 | 63 | 70 | 4 | 89 | 418 | 120 | 449 | Aphanomyces euteiches cDNA | blastn | 15137 | 239 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 3290700 | 3290700 | PRJNA758398_S_NODE_10623_length_298_cov_1.120482_g10482_i0 | PRJNA758398 | 10623 | 298 | 1.120482 | 3.33903636 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 5.43e-69 | NTclustered | gi|2795049776|ref|XM_067938656.1| | 4785 | g10482 | i0 | 84.138 | 4.09395973154362 | 290 | 38 | 96 | 4 | 1 | 286 | 231 | 516 | Phytophthora cinnamomi polyadenylate-binding protein 1-B (IUM83_13951), partial mRNA | blastn | 1220 | 274 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 3290801 | 3290801 | PRJNA758398_S_NODE_17723_length_238_cov_2.042328_g17582_i0 | PRJNA758398 | 17723 | 238 | 2.042328 | 4.86074064 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 7.53e-17 | NTclustered | gi|675165376|ref|XM_008893325.1| | 761204 | g17582 | i0 | 95.312 | 21.4915966386555 | 64 | 1 | 26 | 2 | 90 | 152 | 638 | 700 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 5115 | 100 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 3290815 | 3290815 | PRJNA758398_S_NODE_18583_length_234_cov_1.102703_g18442_i0 | PRJNA758398 | 18583 | 234 | 1.102703 | 2.58032502 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.29e-39 | NTclustered | gi|813125660|ref|XM_012341391.1| | 695850 | g18442 | i0 | 80.519 | 45.7991452991453 | 231 | 41 | 98 | 4 | 4 | 232 | 262 | 34 | Saprolegnia parasitica CBS 223.65 elongation factor 2 mRNA | blastn | 10717 | 174 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 3291149 | 3291149 | PRJNA758398_S_NODE_44743_length_166_cov_0.871795_g44602_i0 | PRJNA758398 | 44743 | 166 | 0.871795 | 1.4471797 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 2.2e-40 | NTclustered | gi|2794914128|ref|XM_067892206.1| | 164328 | g44602 | i0 | 89.362 | 60.9036144578313 | 141 | 15 | 85 | 0 | 26 | 166 | 881 | 1021 | Phytophthora ramorum Inositol-3-phosphate synthase (KRP23_6954), partial mRNA | blastn | 10110 | 178 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 5843104 | 5843104 | PRJNA758398_S_NODE_17865_length_238_cov_0.962963_g17724_i0 | PRJNA758398 | 17865 | 238 | 0.962963 | 2.29185194 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.6e-28 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g17724 | i0 | 85.401 | 55.6848739495798 | 137 | 16 | 57 | 4 | 90 | 224 | 41793 | 41659 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 13253 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 5843245 | 5843245 | PRJNA758398_S_NODE_28245_length_199_cov_1.020000_g28104_i0 | PRJNA758398 | 28245 | 199 | 1.02 | 2.0298 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 5.91e-37 | NTclustered | gi|695407986|ref|XM_009526229.1| | 67593 | g28104 | i0 | 90.551 | 48.5628140703518 | 127 | 10 | 63 | 2 | 8 | 133 | 421 | 546 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 9664 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 8857476 | 8857476 | PRJNA758398_S_NODE_52107_length_162_cov_0.902655_g51966_i0 | PRJNA758398 | 52107 | 162 | 0.902655 | 1.4623011 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 4.78e-12 | NTclustered | gi|2795048588|ref|XM_067932045.1| | 4785 | g51966 | i0 | 76.543 | 6.51851851851852 | 162 | 32 | 98 | 4 | 2 | 160 | 470 | 312 | Phytophthora cinnamomi 40S ribosomal protein S6 (IUM83_07725), partial mRNA | blastn | 1056 | 84.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9668424 | 9668424 | PRJNA758398_S_NODE_46148_length_165_cov_0.879310_g46007_i0 | PRJNA758398 | 46148 | 165 | 0.87931 | 1.4508615 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 1.02e-38 | NTclustered | gi|695381842|ref|XM_009518920.1| | 67593 | g46007 | i0 | 85.455 | 6 | 165 | 24 | 100 | 0 | 1 | 165 | 31 | 195 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 990 | 172 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 9668431 | 9668431 | PRJNA758398_S_NODE_46528_length_165_cov_0.879310_g46387_i0 | PRJNA758398 | 46528 | 165 | 0.87931 | 1.4508615 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 8.02e-25 | NTclustered | gi|2795024233|ref|XM_067938299.1| | 4785 | g46387 | i0 | 86.325 | 1.58181818181818 | 117 | 14 | 70 | 2 | 18 | 133 | 924 | 809 | Phytophthora cinnamomi T-complex protein 1, alpha subunit (IUM83_13609), partial mRNA | blastn | 261 | 126 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 16042446 | 16042446 | PRJNA758398_S_NODE_35113_length_181_cov_1.522727_g34972_i0 | PRJNA758398 | 35113 | 181 | 1.522727 | 2.75613587 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.19e-29 | NTclustered | gi|673019533|ref|XM_008865506.1| | 157072 | g34972 | i0 | 88.696 | 10.5745856353591 | 115 | 13 | 64 | 0 | 67 | 181 | 107 | 221 | Aphanomyces invadans hypothetical protein mRNA | blastn | 1914 | 141 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 18591765 | 18591765 | PRJNA758398_S_NODE_895_length_920_cov_2.160735_g816_i0 | PRJNA758398 | 895 | 920 | 2.160735 | 19.878762 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 503 | 2.14e-137 | NTclustered | gi|695416746|ref|XM_009528626.1| | 67593 | g816 | i0 | 82.137 | 49.6815217391304 | 599 | 95 | 64 | 10 | 1 | 593 | 433 | 1025 | Phytophthora sojae hypothetical protein mRNA | blastn | 45707 | 503 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 20330838 | 20330838 | PRJNA758398_S_NODE_51636_length_162_cov_0.902655_g51495_i0 | PRJNA758398 | 51636 | 162 | 0.902655 | 1.4623011 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 2.0899999999999995e-55 | NTclustered | gi|2795052452|ref|XM_067926699.1| | 4785 | g51495 | i0 | 92.949 | 43.9753086419753 | 156 | 11 | 96 | 0 | 5 | 160 | 218 | 63 | Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA | blastn | 7124 | 228 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 22417217 | 22417217 | PRJNA758398_S_NODE_4078_length_469_cov_1.566667_g3937_i0 | PRJNA758398 | 4078 | 469 | 1.566667 | 7.34766823 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 1.2099999999999999e-32 | NTclustered | gi|669145241|ref|XM_008609961.1| | 1156394 | g3937 | i0 | 75.51 | 33.6567164179104 | 343 | 68 | 71 | 14 | 58 | 392 | 452 | 118 | Saprolegnia diclina VS20 50S ribosomal protein L22e mRNA | blastn | 15785 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 22882093 | 22882093 | PRJNA758398_S_NODE_938_length_903_cov_2.925059_g855_i0 | PRJNA758398 | 938 | 903 | 2.925059 | 26.41328277 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 1.77e-73 | NTclustered | gi|695427108|ref|XM_009531298.1| | 67593 | g855 | i0 | 76.391 | 18.4518272425249 | 593 | 108 | 64 | 27 | 306 | 882 | 585 | 9 | Phytophthora sojae hypothetical protein mRNA | blastn | 16662 | 292 | 0.996575342465753 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 23692895 | 23692895 | PRJNA758398_S_NODE_49219_length_163_cov_1.587719_g49078_i0 | PRJNA758398 | 49219 | 163 | 1.587719 | 2.58798197 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.7e-26 | NTclustered | gi|695387581|ref|XM_009520634.1| | 67593 | g49078 | i0 | 86.555 | 0.730061349693252 | 119 | 16 | 73 | 0 | 16 | 134 | 1287 | 1169 | Phytophthora sojae pyrophosphatase partial mRNA | blastn | 119 | 132 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 24966272 | 24966272 | PRJNA758398_S_NODE_28940_length_197_cov_1.047297_g28799_i0 | PRJNA758398 | 28940 | 197 | 1.047297 | 2.06317509 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 9.98e-20 | NTclustered | gi|2795045055|ref|XM_067937582.1| | 4785 | g28799 | i0 | 89.655 | 34.0812182741117 | 87 | 7 | 44 | 2 | 112 | 197 | 313 | 228 | Phytophthora cinnamomi ribosomal protein L34 (IUM83_12935), partial mRNA | blastn | 6714 | 110 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 24966351 | 24966351 | PRJNA758398_S_NODE_35820_length_180_cov_0.877863_g35679_i0 | PRJNA758398 | 35820 | 180 | 0.877863 | 1.5801534 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.5e-15 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g35679 | i0 | 88.462 | 1.15555555555556 | 78 | 9 | 43 | 0 | 79 | 156 | 1132 | 1209 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 208 | 95.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 24966433 | 24966433 | PRJNA758398_S_NODE_43780_length_166_cov_1.307692_g43639_i0 | PRJNA758398 | 43780 | 166 | 1.307692 | 2.17076872 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.31e-5 | NTclustered | gi|166034832|emb|CU351832.1| | 100861 | g43639 | i0 | 97.222 | 0.216867469879518 | 36 | 1 | 22 | 0 | 35 | 70 | 73 | 108 | Aphanomyces euteiches cDNA | blastn | 36 | 62.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 25431021 | 25431021 | PRJNA758398_S_NODE_10140_length_304_cov_1.854902_g9999_i0 | PRJNA758398 | 10140 | 304 | 1.854902 | 5.63890208 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 7.24e-63 | NTclustered | gi|156987611|gb|EU079758.1| | 4785 | g9999 | i0 | 83.755 | 90.1085526315789 | 277 | 35 | 88 | 9 | 36 | 304 | 348 | 74 | Phytophthora cinnamomi isolate PD_00120(P2159) translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 27393 | 255 | 0.996078431372549 | 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);;