contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 213406 | 213406 | PRJNA1108487_P_NODE_281_length_1125_cov_2.383080_g242_i0 | PRJNA1108487 | 281 | 1125 | 2.38308 | 26.80965 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 579 | 4.2499999999999985e-160 | NTclustered | gi|813110813|ref|XM_012339619.1| | 695850 | g242 | i0 | 78.141 | 82.712 | 947 | 182 | 83 | 21 | 190 | 1125 | 1161 | 229 | Saprolegnia parasitica CBS 223.65 isocitrate dehydrogenase mRNA | blastn | 93051 | 579 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 1488091 | 1488091 | PRJNA1108487_P_NODE_2602_length_420_cov_2.011527_g2536_i0 | PRJNA1108487 | 2602 | 420 | 2.011527 | 8.4484134 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 6.22e-60 | NTclustered | gi|2795030183|ref|XM_067927740.1| | 4785 | g2536 | i0 | 78.976 | 29.2952380952381 | 371 | 68 | 86 | 8 | 32 | 394 | 667 | 1035 | Phytophthora cinnamomi Guanine nucleotide-binding protein subunit beta (IUM83_03712), partial mRNA | blastn | 12304 | 244 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 1488103 | 1488103 | PRJNA1108487_P_NODE_3982_length_347_cov_1.138686_g3916_i0 | PRJNA1108487 | 3982 | 347 | 1.138686 | 3.95124042 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 6.579999999999998e-54 | NTclustered | gi|675169410|ref|XM_008895342.1| | 761204 | g3916 | i0 | 80.903 | 68.3775216138329 | 288 | 52 | 82 | 2 | 29 | 313 | 590 | 303 | Phytophthora parasitica INRA-310 adenosylhomocysteinase mRNA | blastn | 23727 | 224 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 2764143 | 2764143 | PRJNA1108487_P_NODE_3063_length_388_cov_2.790476_g2997_i0 | PRJNA1108487 | 3063 | 388 | 2.790476 | 10.82704688 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 1.2e-76 | NTclustered | gi|669149341|ref|XM_008612011.1| | 1156394 | g2997 | i0 | 83.333 | 70.5077319587629 | 324 | 54 | 84 | 0 | 1 | 324 | 405 | 82 | Saprolegnia diclina VS20 Ras-like GTP-binding protein YPT1 mRNA | blastn | 27357 | 300 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 2764151 | 2764151 | PRJNA1108487_P_NODE_4103_length_342_cov_4.171004_g4037_i0 | PRJNA1108487 | 4103 | 342 | 4.171004 | 14.26483368 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 4.93e-65 | NTclustered | gi|695460853|ref|XM_009539792.1| | 67593 | g4037 | i0 | 82.653 | 15.7134502923977 | 294 | 51 | 86 | 0 | 36 | 329 | 309 | 16 | Phytophthora sojae hypothetical protein mRNA | blastn | 5374 | 261 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 4040232 | 4040232 | PRJNA1108487_P_NODE_5664_length_299_cov_1.592920_g5598_i0 | PRJNA1108487 | 5664 | 299 | 1.59292 | 4.7628308 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 4.4e-40 | NTclustered | gi|166051101|emb|CU363198.1| | 100861 | g5598 | i0 | 84.239 | 3.07357859531773 | 184 | 27 | 61 | 2 | 117 | 299 | 528 | 710 | Aphanomyces euteiches cDNA | blastn | 919 | 178 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 5316322 | 5316322 | PRJNA1108487_P_NODE_5465_length_304_cov_1.350649_g5399_i0 | PRJNA1108487 | 5465 | 304 | 1.350649 | 4.10597296 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.62e-57 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g5399 | i0 | 80.719 | 32.5822368421053 | 306 | 55 | 100 | 4 | 1 | 304 | 160 | 463 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 9905 | 235 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 6591519 | 6591519 | PRJNA1108487_P_NODE_3446_length_368_cov_2.803390_g3380_i0 | PRJNA1108487 | 3446 | 368 | 2.80339 | 10.3164752 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.5499999999999998e-35 | NTclustered | gi|301093299|ref|XM_002997452.1| | 403677 | g3380 | i0 | 82.292 | 2.52717391304348 | 192 | 30 | 52 | 4 | 1 | 190 | 358 | 169 | Phytophthora infestans T30-4 nascent polypeptide-associated complex subunit alpha-like protein, putative (PITG_19008), partial mRNA | blastn | 930 | 163 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 6591527 | 6591527 | PRJNA1108487_P_NODE_5246_length_309_cov_1.322034_g5180_i0 | PRJNA1108487 | 5246 | 309 | 1.322034 | 4.08508506 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.29e-30 | NTclustered | gi|2795045367|ref|XM_067939679.1| | 4785 | g5180 | i0 | 78.879 | 3.50485436893204 | 232 | 38 | 74 | 9 | 74 | 301 | 46 | 270 | Phytophthora cinnamomi transitional endoplasmic reticulum ATPase (IUM83_14904), partial mRNA | blastn | 1083 | 147 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 7866152 | 7866152 | PRJNA1108487_P_NODE_1107_length_630_cov_1.676840_g1044_i0 | PRJNA1108487 | 1107 | 630 | 1.67684 | 10.564092 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 2.56e-90 | NTclustered | gi|2795023275|ref|XM_067929756.1| | 4785 | g1044 | i0 | 83.651 | 56.8095238095238 | 367 | 60 | 58 | 0 | 264 | 630 | 941 | 575 | Phytophthora cinnamomi serine/threonine-protein phosphatase 2A catalytic subunit beta isoform (IUM83_05609), partial mRNA | blastn | 35790 | 346 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 11692093 | 11692093 | PRJNA1108487_P_NODE_1990_length_482_cov_2.317848_g1924_i0 | PRJNA1108487 | 1990 | 482 | 2.317848 | 11.17202736 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 2.08e-35 | NTclustered | gi|669138905|ref|XM_008606799.1| | 1156394 | g1924 | i0 | 80.18 | 0.518672199170125 | 222 | 40 | 46 | 4 | 263 | 482 | 1499 | 1280 | Saprolegnia diclina VS20 seryl-tRNA synthetase mRNA | blastn | 250 | 163 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 11692109 | 11692109 | PRJNA1108487_P_NODE_4150_length_340_cov_5.400749_g4084_i0 | PRJNA1108487 | 4150 | 340 | 5.400749 | 18.3625466 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.74e-74 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g4084 | i0 | 87.649 | 72.2382352941176 | 251 | 31 | 74 | 0 | 3 | 253 | 251 | 1 | A.bisexualis gene for actin | blastn | 24561 | 292 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 12499428 | 12499428 | PRJNA1108487_P_NODE_8710_length_252_cov_0.871508_g8644_i0 | PRJNA1108487 | 8710 | 252 | 0.871508 | 2.19620016 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.03e-25 | NTclustered | gi|813187256|ref|XM_012352047.1| | 695850 | g8644 | i0 | 87.5 | 7.26190476190476 | 112 | 14 | 44 | 0 | 28 | 139 | 168 | 57 | Saprolegnia parasitica CBS 223.65 actin-like protein 2/3 complex subunit 4 mRNA | blastn | 1830 | 130 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 15516010 | 15516010 | PRJNA1108487_P_NODE_1033_length_648_cov_10.180870_g970_i0 | PRJNA1108487 | 1033 | 648 | 10.18087 | 65.9720376 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 9.91e-60 | NTclustered | gi|673039884|ref|XM_008875681.1| | 157072 | g970 | i0 | 77.305 | 13.3117283950617 | 423 | 90 | 65 | 6 | 21 | 440 | 31 | 450 | Aphanomyces invadans 60S ribosomal protein mRNA | blastn | 8626 | 244 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 16790586 | 16790586 | PRJNA1108487_P_NODE_6594_length_280_cov_1.014493_g6528_i0 | PRJNA1108487 | 6594 | 280 | 1.014493 | 2.8405804 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.46e-44 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g6528 | i0 | 80.309 | 66.3642857142857 | 259 | 47 | 92 | 3 | 1 | 257 | 621 | 365 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 18582 | 193 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 18065117 | 18065117 | PRJNA1108487_P_NODE_4855_length_319_cov_1.264228_g4789_i0 | PRJNA1108487 | 4855 | 319 | 1.264228 | 4.03288732 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 4.73e-40 | NTclustered | gi|2794921692|ref|XM_067881078.1| | 164328 | g4789 | i0 | 85.465 | 2.6833855799373 | 172 | 23 | 54 | 2 | 109 | 279 | 166 | 336 | Phytophthora ramorum V-type proton ATPase 16 kDa proteolipid subunit (KRP23_10609), partial mRNA | blastn | 856 | 178 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 18872163 | 18872163 | PRJNA1108487_P_NODE_8235_length_253_cov_2.522222_g8169_i0 | PRJNA1108487 | 8235 | 253 | 2.522222 | 6.38122166 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 2.81e-41 | NTclustered | gi|169305|gb|M83535.1|PHTCALPIA | 4787 | g8169 | i0 | 90.511 | 45.2411067193676 | 137 | 13 | 54 | 0 | 117 | 253 | 1170 | 1034 | P.infestans calmodulin (calA) gene, complete cds | blastn | 11446 | 183 | 0.994535519125683 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 19339283 | 19339283 | PRJNA1108487_P_NODE_2976_length_393_cov_1.296875_g2910_i0 | PRJNA1108487 | 2976 | 393 | 1.296875 | 5.09671875 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.71e-53 | NTclustered | gi|673036227|ref|XM_008873853.1| | 157072 | g2910 | i0 | 84.12 | 33.4783715012723 | 233 | 34 | 59 | 2 | 17 | 246 | 239 | 471 | Aphanomyces invadans adenosylhomocysteinase 2 mRNA | blastn | 13157 | 222 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 20614580 | 20614580 | PRJNA1108487_P_NODE_7877_length_259_cov_1.677419_g7811_i0 | PRJNA1108487 | 7877 | 259 | 1.677419 | 4.34451521 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 7.79e-62 | NTclustered | gi|2794905809|ref|XM_067889902.1| | 164328 | g7811 | i0 | 84.585 | 86.3011583011583 | 253 | 37 | 97 | 2 | 6 | 257 | 312 | 61 | Phytophthora ramorum 13 kDa ribonucleoprotein-associated protein (KRP23_4892), partial mRNA | blastn | 22352 | 250 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 24439336 | 24439336 | PRJNA1108487_P_NODE_3900_length_350_cov_1.126354_g3834_i0 | PRJNA1108487 | 3900 | 350 | 1.126354 | 3.942239 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 8.44e-63 | NTclustered | gi|2794906059|ref|XM_067889971.1| | 164328 | g3834 | i0 | 80.403 | 39.2971428571429 | 347 | 56 | 97 | 8 | 1 | 341 | 603 | 263 | Phytophthora ramorum Aconitate hydratase, mitochondrial (KRP23_4954), partial mRNA | blastn | 13754 | 254 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum |
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);;