contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA929522" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 905329 | 905329 | PRJNA929522_S_NODE_2041_length_466_cov_1.282443_g1971_i0 | PRJNA929522 | 2041 | 466 | 1.282443 | 5.97618438 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 5.27e-76 | NTclustered | gi|695434207|ref|XM_009533074.1| | 67593 | g1971 | i0 | 82.37 | 15.5922746781116 | 346 | 58 | 74 | 3 | 3 | 347 | 223 | 566 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 7266 | 298 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 905343 | 905343 | PRJNA929522_S_NODE_3841_length_345_cov_1.415441_g3771_i0 | PRJNA929522 | 3841 | 345 | 1.415441 | 4.88327145 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 8.46e-53 | NTclustered | gi|695446741|ref|XM_009536267.1| | 67593 | g3771 | i0 | 79.205 | 2.23188405797101 | 327 | 60 | 94 | 8 | 11 | 333 | 848 | 1170 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 770 | 220 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 905355 | 905355 | PRJNA929522_S_NODE_521_length_851_cov_3.974293_g471_i0 | PRJNA929522 | 521 | 851 | 3.974293 | 33.82123343 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 1.2099999999999994e-119 | NTclustered | gi|675199240|ref|XM_008910257.1| | 761204 | g471 | i0 | 78.249 | 70.0810810810811 | 731 | 132 | 85 | 20 | 120 | 841 | 316 | 1028 | Phytophthora parasitica INRA-310 ATP synthase subunit beta, mitochondrial mRNA | blastn | 59639 | 444 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 905364 | 905364 | PRJNA929522_S_NODE_5941_length_290_cov_1.419355_g5871_i0 | PRJNA929522 | 5941 | 290 | 1.419355 | 4.1161295 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.47e-64 | NTclustered | gi|2794908947|ref|XM_067890725.1| | 164328 | g5871 | i0 | 85.484 | 15.0448275862069 | 248 | 36 | 86 | 0 | 43 | 290 | 922 | 1169 | Phytophthora ramorum V-type proton ATPase catalytic subunit A (KRP23_5635), partial mRNA | blastn | 4363 | 259 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 2180723 | 2180723 | PRJNA929522_S_NODE_3122_length_379_cov_1.343137_g3052_i0 | PRJNA929522 | 3122 | 379 | 1.343137 | 5.09048923 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 9.56e-38 | NTclustered | gi|813198519|ref|XM_012353453.1| | 695850 | g3052 | i0 | 82.178 | 7.15303430079156 | 202 | 32 | 53 | 4 | 109 | 308 | 121 | 320 | Saprolegnia parasitica CBS 223.65 succinate dehydrogenase iron-sulfur subunit mRNA | blastn | 2711 | 171 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 4733773 | 4733773 | PRJNA929522_S_NODE_2464_length_425_cov_1.531250_g2394_i0 | PRJNA929522 | 2464 | 425 | 1.53125 | 6.5078125 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.07e-47 | NTclustered | gi|2795034451|ref|XM_067934743.1| | 4785 | g2394 | i0 | 82.684 | 1.33411764705882 | 231 | 38 | 54 | 2 | 148 | 377 | 330 | 559 | Phytophthora cinnamomi Eukaryotic translation initiation factor 2 subunit beta (IUM83_10251), partial mRNA | blastn | 567 | 204 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 6008600 | 6008600 | PRJNA929522_S_NODE_505_length_858_cov_2.078981_g457_i0 | PRJNA929522 | 505 | 858 | 2.078981 | 17.83765698 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 3.439999999999999e-110 | NTclustered | gi|2795036206|ref|XM_067943759.1| | 4785 | g457 | i0 | 77.954 | 70.8368298368298 | 694 | 129 | 79 | 19 | 177 | 858 | 82 | 763 | Phytophthora cinnamomi ATP-dependent RNA helicase eIF4A (IUM83_18748), partial mRNA | blastn | 60778 | 412 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 8558238 | 8558238 | PRJNA929522_S_NODE_1287_length_575_cov_5.868526_g1220_i0 | PRJNA929522 | 1287 | 575 | 5.868526 | 33.7440245 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 5.1e-77 | NTclustered | gi|698822976|ref|XM_009846215.1| | 112090 | g1220 | i0 | 78.452 | 61.7217391304348 | 478 | 91 | 82 | 9 | 19 | 491 | 57 | 527 | Aphanomyces astaci 40S ribosomal protein S13 mRNA | blastn | 35490 | 302 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8558279 | 8558279 | PRJNA929522_S_NODE_7087_length_270_cov_1.314721_g7017_i0 | PRJNA929522 | 7087 | 270 | 1.314721 | 3.5497467 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 4.959999999999999e-54 | NTclustered | gi|166044724|emb|CU350983.1| | 100861 | g7017 | i0 | 82.129 | 44.9333333333333 | 263 | 45 | 97 | 2 | 1 | 262 | 256 | 517 | Aphanomyces euteiches cDNA | blastn | 12132 | 224 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 8558284 | 8558284 | PRJNA929522_S_NODE_7707_length_261_cov_1.228723_g7637_i0 | PRJNA929522 | 7707 | 261 | 1.228723 | 3.20696703 | Phytophthora insulinativitatica | 2822406 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 8.029999999999999e-47 | NTclustered | gi|1983384301|gb|MT583676.1| | 2822406 | g7637 | i0 | 80.989 | 100.766283524904 | 263 | 41 | 99 | 7 | 2 | 261 | 263 | 7 | Phytophthora insulinativitatica isolate CBS 146553 heat shock protein 90 (hsp90) gene, partial cds | blastn | 26300 | 200 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora insulinativitatica | ||
| 9833208 | 9833208 | PRJNA929522_S_NODE_2568_length_417_cov_2.479651_g2498_i0 | PRJNA929522 | 2568 | 417 | 2.479651 | 10.34014467 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 2.3e-34 | NTclustered | gi|669160265|ref|XM_008617473.1| | 1156394 | g2498 | i0 | 79.079 | 7.61151079136691 | 239 | 44 | 57 | 5 | 105 | 340 | 202 | 437 | Saprolegnia diclina VS20 ADP-ribosylation factor 1 mRNA | blastn | 3174 | 159 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 11108944 | 11108944 | PRJNA929522_S_NODE_5009_length_310_cov_1.894515_g4939_i0 | PRJNA929522 | 5009 | 310 | 1.894515 | 5.8729965 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 1.22e-70 | NTclustered | gi|2794889416|ref|XM_067886769.1| | 164328 | g4939 | i0 | 83.228 | 72.0064516129032 | 316 | 41 | 100 | 10 | 1 | 310 | 1179 | 870 | Phytophthora ramorum ATP-dependent RNA helicase eIF4A (KRP23_2082), partial mRNA | blastn | 22322 | 279 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 12384452 | 12384452 | PRJNA929522_S_NODE_6230_length_284_cov_3.165877_g6160_i0 | PRJNA929522 | 6230 | 284 | 3.165877 | 8.99109068 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 8.66e-62 | NTclustered | gi|2794889416|ref|XM_067886769.1| | 164328 | g6160 | i0 | 82.867 | 44.8521126760563 | 286 | 41 | 99 | 8 | 3 | 284 | 791 | 1072 | Phytophthora ramorum ATP-dependent RNA helicase eIF4A (KRP23_2082), partial mRNA | blastn | 12738 | 250 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 14007440 | 14007440 | PRJNA929522_S_NODE_7331_length_266_cov_2.870466_g7261_i0 | PRJNA929522 | 7331 | 266 | 2.870466 | 7.63543956 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 6.35e-48 | NTclustered | gi|937408816|ref|NC_027966.1| | 114742 | g7261 | i0 | 83.036 | 51.3345864661654 | 224 | 38 | 84 | 0 | 9 | 232 | 31868 | 32091 | Pythium insidiosum mitochondrial DNA, complete genome | blastn | 13655 | 204 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 16208325 | 16208325 | PRJNA929522_S_NODE_9753_length_243_cov_1.147059_g9683_i0 | PRJNA929522 | 9753 | 243 | 1.147059 | 2.78735337 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 2.1e-32 | NTclustered | gi|675188148|ref|XM_008904711.1| | 761204 | g9683 | i0 | 82.286 | 2.07818930041152 | 175 | 31 | 72 | 0 | 54 | 228 | 2284 | 2110 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 505 | 152 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 17483553 | 17483553 | PRJNA929522_S_NODE_3554_length_357_cov_1.102113_g3484_i0 | PRJNA929522 | 3554 | 357 | 1.102113 | 3.93454341 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 5.27e-50 | NTclustered | gi|2795039278|ref|XM_067938479.1| | 4785 | g3484 | i0 | 79.725 | 47.9803921568627 | 291 | 59 | 82 | 0 | 67 | 357 | 97 | 387 | Phytophthora cinnamomi iron sulfur cluster assembly protein 1 (IUM83_13781), partial mRNA | blastn | 17129 | 211 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 20031969 | 20031969 | PRJNA929522_S_NODE_1116_length_607_cov_4.430712_g1051_i0 | PRJNA929522 | 1116 | 607 | 4.430712 | 26.89442184 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 1.48e-87 | NTclustered | gi|2795029237|ref|XM_067937609.1| | 4785 | g1051 | i0 | 81.951 | 52.1943986820428 | 410 | 63 | 67 | 8 | 84 | 487 | 49 | 453 | Phytophthora cinnamomi 40S ribosomal protein S14 (IUM83_12961), partial mRNA | blastn | 31682 | 337 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 21655720 | 21655720 | PRJNA929522_S_NODE_297_length_1064_cov_2.931382_g261_i0 | PRJNA929522 | 297 | 1064 | 2.931382 | 31.18990448 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 654 | 0 | NTclustered | gi|813171391|ref|XM_012349061.1| | 695850 | g261 | i0 | 78.294 | 82.390977443609 | 1055 | 201 | 98 | 23 | 27 | 1064 | 1099 | 56 | Saprolegnia parasitica CBS 223.65 adenosylhomocysteinase mRNA | blastn | 87664 | 656 | 0.996951219512195 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 22582446 | 22582446 | PRJNA929522_S_NODE_3978_length_340_cov_1.722846_g3908_i0 | PRJNA929522 | 3978 | 340 | 1.722846 | 5.8576764 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 1.7499999999999998e-69 | NTclustered | gi|38489929|gb|AY456093.1| | 4792 | g3908 | i0 | 81.525 | 85.7441176470588 | 341 | 57 | 99 | 4 | 1 | 338 | 1481 | 1144 | Phytophthora nicotianae heat shock protein 70 (Hsp70a) gene, complete cds | blastn | 29153 | 276 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae |
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);;