contig_metadata
16 rows where bioproject = "PRJNA738523" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5025980 | 5025980 | PRJNA738523_P_NODE_12004_length_248_cov_1.760000_g11933_i0 | PRJNA738523 | 12004 | 248 | 1.76 | 4.3648 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.27e-44 | NTclustered | gi|813233307|ref|XM_012358054.1| | 695850 | g11933 | i0 | 82.143 | 38.0846774193548 | 224 | 40 | 90 | 0 | 4 | 227 | 284 | 61 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein S15a partial mRNA | blastn | 9445 | 193 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 7098287 | 7098287 | PRJNA738523_P_NODE_8946_length_265_cov_1.348958_g8875_i0 | PRJNA738523 | 8946 | 265 | 1.348958 | 3.5747387 | Phytopythium vexans | 907947 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.22e-62 | NTclustered | gi|71063372|gb|DQ071321.1| | 907947 | g8875 | i0 | 83.895 | 28.1358490566038 | 267 | 39 | 100 | 4 | 1 | 265 | 292 | 556 | Pythium vexans strain NBRC100112 beta-tubulin gene, partial cds | blastn | 7456 | 252 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium vexans | ||
| 17297648 | 17297648 | PRJNA738523_P_NODE_7154_length_282_cov_1.473684_g7083_i0 | PRJNA738523 | 7154 | 282 | 1.473684 | 4.15578888 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 4.14e-35 | NTclustered | gi|2794921884|ref|XM_067881184.1| | 164328 | g7083 | i0 | 81.633 | 12.4893617021277 | 196 | 34 | 69 | 2 | 9 | 203 | 196 | 390 | Phytophthora ramorum 60S ribosomal protein L23 (KRP23_10704), partial mRNA | blastn | 3522 | 161 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 18571371 | 18571371 | PRJNA738523_P_NODE_8595_length_268_cov_1.579487_g8524_i0 | PRJNA738523 | 8595 | 268 | 1.579487 | 4.23302516 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 5.02e-39 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g8524 | i0 | 80.426 | 73.5746268656716 | 235 | 41 | 86 | 5 | 30 | 260 | 656 | 423 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 19718 | 174 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 23672510 | 23672510 | PRJNA738523_P_NODE_10539_length_251_cov_0.865169_g10468_i0 | PRJNA738523 | 10539 | 251 | 0.865169 | 2.17157419 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 9.93e-46 | NTclustered | gi|695372681|ref|XM_009516579.1| | 67593 | g10468 | i0 | 82.174 | 95.5418326693227 | 230 | 39 | 91 | 2 | 7 | 235 | 633 | 861 | Phytophthora sojae hypothetical protein mRNA | blastn | 23981 | 196 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 23672563 | 23672563 | PRJNA738523_P_NODE_3979_length_345_cov_1.698529_g3908_i0 | PRJNA738523 | 3979 | 345 | 1.698529 | 5.85992505 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 3.8499999999999995e-66 | NTclustered | gi|2794906124|ref|XM_067889988.1| | 164328 | g3908 | i0 | 80.826 | 70.0840579710145 | 339 | 63 | 98 | 2 | 6 | 343 | 632 | 969 | Phytophthora ramorum 60S ribosomal protein L3 (KRP23_4970), partial mRNA | blastn | 24179 | 265 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 27599913 | 27599913 | PRJNA738523_P_NODE_8744_length_267_cov_1.304124_g8673_i0 | PRJNA738523 | 8744 | 267 | 1.304124 | 3.48201108 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 6.41e-10 | NR | KAJ0410772.1 | 114742 | g8673 | i0 | 50 | 4.12359550561798 | 100 | 38 | 98.9 | 4 | 3 | 266 | 132 | 231 | KAJ0410772.1 hypothetical protein ATCC90586_001401 [Pythium insidiosum] | diamond | 1101 | 65.5 | 0.993893129770992 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 27905064 | 27905064 | PRJNA738523_P_NODE_10825_length_251_cov_0.865169_g10754_i0 | PRJNA738523 | 10825 | 251 | 0.865169 | 2.17157419 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.68e-8 | NR | KAG2519636.1 | 325452 | g10754 | i0 | 41.9 | 4.47011952191235 | 74 | 40 | 88.4 | 2 | 26 | 247 | 55 | 125 | KAG2519636.1 hypothetical protein JM18_006761 [Phytophthora kernoviae] | diamond | 1122 | 60.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 28262626 | 28262626 | PRJNA738523_P_NODE_13526_length_246_cov_0.890173_g13455_i0 | PRJNA738523 | 13526 | 246 | 0.890173 | 2.18982558 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 8.75e-18 | NR | RHY06105.1 | 112090 | g13455 | i0 | 58 | 4.9390243902439 | 81 | 33 | 98.8 | 1 | 244 | 2 | 339 | 418 | RHY06105.1 hypothetical protein DYB36_008297, partial [Aphanomyces astaci] | diamond | 1215 | 87 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28473745 | 28473745 | PRJNA738523_P_NODE_14446_length_244_cov_0.900585_g14375_i0 | PRJNA738523 | 14446 | 244 | 0.900585 | 2.1974274 | Nothophytophthora sp. Chile5 | 2483409 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00416 | NR | RLN92552.1 | 2483409 | g14375 | i0 | 40.7 | 1.65983606557377 | 54 | 31 | 65.2 | 1 | 159 | 1 | 206 | 259 | RLN92552.1 hypothetical protein BBJ28_00007100 [Nothophytophthora sp. Chile5] | diamond | 405 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. Chile5 | ||
| 28547214 | 28547214 | PRJNA738523_P_NODE_15887_length_241_cov_1.398810_g15816_i0 | PRJNA738523 | 15887 | 241 | 1.39881 | 3.3711321 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 3.98e-4 | NR | KAH9197853.1 | 100861 | g15816 | i0 | 41.8 | 1.50622406639004 | 67 | 31 | 77.2 | 2 | 210 | 25 | 26 | 89 | KAH9197853.1 hypothetical protein AeNC1_000130 [Aphanomyces euteiches] | diamond | 363 | 48.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 29020888 | 29020888 | PRJNA738523_P_NODE_14368_length_244_cov_0.900585_g14297_i0 | PRJNA738523 | 14368 | 244 | 0.900585 | 2.1974274 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 5.41e-20 | NR | KAE9210719.1 | 53985 | g14297 | i0 | 54.3 | 5.7172131147541 | 81 | 37 | 99.6 | 0 | 1 | 243 | 185 | 265 | KAE9210719.1 hypothetical protein PF005_g11305 [Phytophthora fragariae] | diamond | 1395 | 91.7 | 0.995637949836423 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 31126351 | 31126351 | PRJNA738523_P_NODE_11755_length_249_cov_0.875000_g11684_i0 | PRJNA738523 | 11755 | 249 | 0.875 | 2.17875 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 1.18e-8 | NR | CAI5722649.1 | 162125 | g11684 | i0 | 48.6 | 0.867469879518072 | 72 | 30 | 86.7 | 3 | 26 | 241 | 204 | 268 | CAI5722649.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 216 | 61.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 32528941 | 32528941 | PRJNA738523_P_NODE_11679_length_249_cov_0.875000_g11608_i0 | PRJNA738523 | 11679 | 249 | 0.875 | 2.17875 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 7.45e-18 | NR | XP_024585157.1 | 4781 | g11608 | i0 | 66.7 | 2.02409638554217 | 54 | 18 | 65.1 | 0 | 231 | 70 | 489 | 542 | XP_024585157.1 propionyl-carboxylase beta mitochondrial [Plasmopara halstedii] | diamond | 504 | 87.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 32749314 | 32749314 | PRJNA738523_P_NODE_11500_length_249_cov_1.698864_g11429_i0 | PRJNA738523 | 11500 | 249 | 1.698864 | 4.23017136 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00174 | NR | OQR81620.1 | 74557 | g11429 | i0 | 42 | 3.49397590361446 | 50 | 29 | 60.2 | 0 | 21 | 170 | 130 | 179 | OQR81620.1 wu:fk36e11 [Thraustotheca clavata] | diamond | 870 | 47 | 0.991489361702128 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32770599 | 32770599 | PRJNA738523_P_NODE_13360_length_246_cov_0.890173_g13289_i0 | PRJNA738523 | 13360 | 246 | 0.890173 | 2.18982558 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 2.47e-17 | NR | TYZ68759.1 | 1485010 | g13289 | i0 | 55.6 | 0.98780487804878 | 81 | 36 | 98.8 | 0 | 3 | 245 | 281 | 361 | TYZ68759.1 hypothetical protein PybrP1_007006 [[Pythium] brassicae (nom. inval.)] | diamond | 243 | 85.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) |
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);;