contig_metadata
23 rows where bioproject = "PRJNA909412", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 890629 | 890629 | PRJNA909412_P_NODE_1561_length_443_cov_2.759901_g1421_i0 | PRJNA909412 | 1561 | 443 | 2.759901 | 12.22636143 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 4.08e-49 | NR | DBA01302.1 | 4803 | g1421 | i0 | 58.6 | 10.4424379232506 | 140 | 52 | 91.4 | 2 | 406 | 2 | 42 | 180 | DBA01302.1 TPA: hypothetical protein N0F65_001807 [Lagenidium giganteum] | diamond | 4626 | 167 | 0.994011976047904 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 4719229 | 4719229 | PRJNA909412_P_NODE_5724_length_218_cov_2.782123_g5583_i0 | PRJNA909412 | 5724 | 218 | 2.782123 | 6.06502814 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.46e-18 | NTclustered | gi|166034691|emb|CU356728.1| | 100861 | g5583 | i0 | 84.259 | 3.46330275229358 | 108 | 17 | 50 | 0 | 29 | 136 | 735 | 842 | Aphanomyces euteiches cDNA | blastn | 755 | 106 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 7268849 | 7268849 | PRJNA909412_P_NODE_2066_length_375_cov_2.690476_g1926_i0 | PRJNA909412 | 2066 | 375 | 2.690476 | 10.089285 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 6.85e-84 | NTclustered | gi|166301|gb|J05597.1|ACKBTUB | 4767 | g1926 | i0 | 86.333 | 75.0506666666667 | 300 | 37 | 79 | 2 | 79 | 375 | 1542 | 1244 | A.klebsiana beta-tubulin gene, complete cds | blastn | 28144 | 324 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 7627293 | 7627293 | PRJNA909412_P_NODE_5986_length_214_cov_2.057143_g5845_i0 | PRJNA909412 | 5986 | 214 | 2.057143 | 4.40228602 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.02e-33 | NR | XP_024579212.1 | 4781 | g5845 | i0 | 88.6 | 15.7289719626168 | 70 | 8 | 98.1 | 0 | 213 | 4 | 478 | 547 | XP_024579212.1 pre-mrna-processing-splicing factor 8 [Plasmopara halstedii] | diamond | 3366 | 132 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 9818557 | 9818557 | PRJNA909412_P_NODE_17788_length_150_cov_1.927928_g17647_i0 | PRJNA909412 | 17788 | 150 | 1.927928 | 2.891892 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 4.009999999999999e-67 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g17647 | i0 | 98.667 | 86.04 | 150 | 2 | 100 | 0 | 1 | 150 | 113 | 262 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 12906 | 267 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 11094240 | 11094240 | PRJNA909412_P_NODE_1409_length_464_cov_2.708235_g1270_i0 | PRJNA909412 | 1409 | 464 | 2.708235 | 12.5662104 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 1.1099999999999999e-23 | NR | DAZ96774.1 | 4803 | g1270 | i0 | 43.5 | 5.93534482758621 | 124 | 65 | 76.9 | 2 | 358 | 2 | 39 | 162 | DAZ96774.1 TPA: hypothetical protein N0F65_005772 [Lagenidium giganteum] | diamond | 2754 | 108 | 0.990740740740741 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 16193478 | 16193478 | PRJNA909412_P_NODE_2373_length_345_cov_3.918301_g2233_i0 | PRJNA909412 | 2373 | 345 | 3.918301 | 13.51813845 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 1.1e-10 | NR | DBA01819.1 | 4803 | g2233 | i0 | 43.1 | 0.947826086956522 | 109 | 58 | 91.3 | 2 | 24 | 338 | 99 | 207 | DBA01819.1 TPA: hypothetical protein N0F65_002935 [Lagenidium giganteum] | diamond | 327 | 68.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 18742180 | 18742180 | PRJNA909412_P_NODE_1575_length_440_cov_4.403990_g1435_i0 | PRJNA909412 | 1575 | 440 | 4.40399 | 19.377556 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 4.96e-41 | NR | KAH9127992.1 | 100861 | g1435 | i0 | 55.2 | 14.8295454545455 | 145 | 60 | 98.9 | 1 | 1 | 435 | 687 | 826 | KAH9127992.1 hypothetical protein AeMF1_001797, partial [Aphanomyces euteiches] | diamond | 6525 | 156 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21292596 | 21292596 | PRJNA909412_P_NODE_1977_length_384_cov_14.800000_g1837_i0 | PRJNA909412 | 1977 | 384 | 14.8 | 56.832 | root | 1 | Root_unresolved | Root_unresolved | 201 | 3.13e-63 | NR | KAI9994045.1 | 4787 | g1837 | i0 | 75.8 | 18.7421875 | 124 | 29 | 96.1 | 1 | 371 | 3 | 53 | 176 | KAI9994045.1 hypothetical protein PInf_016604 [Phytophthora infestans] | diamond | 7197 | 201 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 22567752 | 22567752 | PRJNA909412_P_NODE_1238_length_502_cov_3.580994_g1099_i0 | PRJNA909412 | 1238 | 502 | 3.580994 | 17.97658988 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 201 | 1.13e-62 | NR | OQR91948.1 | 1202772 | g1099 | i0 | 60.1 | 3.70517928286853 | 153 | 61 | 91.4 | 0 | 460 | 2 | 5 | 157 | OQR91948.1 60S ribosomal protein L18a [Achlya hypogyna] | diamond | 1860 | 201 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 27063478 | 27063478 | PRJNA909412_P_NODE_16402_length_152_cov_1.486726_g16261_i0 | PRJNA909412 | 16402 | 152 | 1.486726 | 2.25982352 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.96e-12 | NR | KAG1685155.1 | 4784 | g16261 | i0 | 68.1 | 2.78289473684211 | 47 | 15 | 92.8 | 0 | 146 | 6 | 261 | 307 | KAG1685155.1 hypothetical protein DVH05_009702 [Phytophthora capsici] | diamond | 423 | 70.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 28319290 | 28319290 | PRJNA909412_P_NODE_5346_length_225_cov_2.935484_g5205_i0 | PRJNA909412 | 5346 | 225 | 2.935484 | 6.604839 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 2.96e-8 | NR | KAF0682950.1 | 120398 | g5205 | i0 | 50.8 | 1.73333333333333 | 65 | 31 | 86.7 | 1 | 30 | 224 | 5 | 68 | KAF0682950.1 hypothetical protein As57867_024885 [Aphanomyces stellatus] | diamond | 390 | 59.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 28319291 | 28319291 | PRJNA909412_P_NODE_9506_length_174_cov_2.140741_g9365_i0 | PRJNA909412 | 9506 | 174 | 2.140741 | 3.72488934 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 5e-10 | NR | TMW69019.1 | 41045 | g9365 | i0 | 50 | 1 | 58 | 24 | 100 | 1 | 174 | 1 | 285 | 337 | TMW69019.1 hypothetical protein Poli38472_001175 [Pythium oligandrum] | diamond | 174 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29305501 | 29305501 | PRJNA909412_P_NODE_2609_length_329_cov_3.527586_g2469_i0 | PRJNA909412 | 2609 | 329 | 3.527586 | 11.60575794 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 3.1e-42 | NR | TMW56563.1 | 41045 | g2469 | i0 | 80.8 | 3.61094224924012 | 99 | 19 | 90.3 | 0 | 30 | 326 | 567 | 665 | TMW56563.1 hypothetical protein Poli38472_006573 [Pythium oligandrum] | diamond | 1188 | 157 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30087560 | 30087560 | PRJNA909412_P_NODE_11352_length_170_cov_1.587786_g11211_i0 | PRJNA909412 | 11352 | 170 | 1.587786 | 2.6992362 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 3.77e-11 | NR | KAJ0400886.1 | 114742 | g11211 | i0 | 59.3 | 2.85882352941176 | 54 | 21 | 95.3 | 1 | 167 | 6 | 126 | 178 | KAJ0400886.1 hypothetical protein P43SY_004498 [Pythium insidiosum] | diamond | 486 | 67 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30309293 | 30309293 | PRJNA909412_P_NODE_8312_length_184_cov_3.448276_g8171_i0 | PRJNA909412 | 8312 | 184 | 3.448276 | 6.34482784 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 5.5e-15 | NR | KAJ8578052.1 | 4785 | g8171 | i0 | 64.2 | 1.69565217391304 | 53 | 19 | 86.4 | 0 | 24 | 182 | 116 | 168 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 312 | 76.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30372395 | 30372395 | PRJNA909412_P_NODE_7232_length_196_cov_2.840764_g7091_i0 | PRJNA909412 | 7232 | 196 | 2.840764 | 5.56789744 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 1.04e-8 | NR | TMW56488.1 | 41045 | g7091 | i0 | 59.2 | 0.75 | 49 | 20 | 75 | 0 | 195 | 49 | 291 | 339 | TMW56488.1 hypothetical protein Poli38472_006498 [Pythium oligandrum] | diamond | 147 | 60.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30498426 | 30498426 | PRJNA909412_P_NODE_2473_length_338_cov_3.612040_g2333_i0 | PRJNA909412 | 2473 | 338 | 3.61204 | 12.2086952 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 5.1e-34 | NR | KAJ0412157.1 | 114742 | g2333 | i0 | 66 | 3.21301775147929 | 97 | 30 | 86.1 | 1 | 324 | 34 | 614 | 707 | KAJ0412157.1 hypothetical protein ATCC90586_005770 [Pythium insidiosum] | diamond | 1086 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30505886 | 30505886 | PRJNA909412_P_NODE_14293_length_158_cov_1.907563_g14152_i0 | PRJNA909412 | 14293 | 158 | 1.907563 | 3.01394954 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 1.45e-13 | NR | XP_009830284.1 | 112090 | g14152 | i0 | 62.7 | 22.4620253164557 | 51 | 19 | 96.8 | 0 | 5 | 157 | 128 | 178 | XP_009830284.1 hypothetical protein, variant [Aphanomyces astaci] | diamond | 3549 | 73.2 | 0.994535519125683 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31864923 | 31864923 | PRJNA909412_P_NODE_1417_length_462_cov_3.458629_g1278_i0 | PRJNA909412 | 1417 | 462 | 3.458629 | 15.97886598 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 164 | 1.2399999999999998e-47 | NR | TMW69510.1 | 41045 | g1278 | i0 | 52.1 | 3.61038961038961 | 140 | 67 | 90.9 | 0 | 41 | 460 | 2 | 141 | TMW69510.1 hypothetical protein Poli38472_001666 [Pythium oligandrum] | diamond | 1668 | 165 | 0.993939393939394 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31896724 | 31896724 | PRJNA909412_P_NODE_6077_length_212_cov_3.196532_g5936_i0 | PRJNA909412 | 6077 | 212 | 3.196532 | 6.77664784 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.034 | NR | KAK1928758.1 | 4793 | g5936 | i0 | 58.3 | 1.40094339622642 | 24 | 10 | 34 | 0 | 9 | 80 | 139 | 162 | KAK1928758.1 putative palmitoyltransferase ZDHHC11 [Phytophthora citrophthora] | diamond | 297 | 42.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 32047605 | 32047605 | PRJNA909412_P_NODE_2718_length_321_cov_1.336879_g2578_i0 | PRJNA909412 | 2718 | 321 | 1.336879 | 4.29138159 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 1.43e-19 | NR | XP_009844135.1 | 112090 | g2578 | i0 | 50.5 | 6.18691588785047 | 105 | 52 | 98.1 | 0 | 2 | 316 | 49 | 153 | XP_009844135.1 hypothetical protein H257_17150 [Aphanomyces astaci] | diamond | 1986 | 92.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 32616839 | 32616839 | PRJNA909412_P_NODE_3060_length_301_cov_3.343511_g2920_i0 | PRJNA909412 | 3060 | 301 | 3.343511 | 10.06396811 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 5.12e-14 | NR | TMW55219.1 | 41045 | g2920 | i0 | 47.9 | 24.8172757475083 | 96 | 50 | 95.7 | 0 | 7 | 294 | 1280 | 1375 | TMW55219.1 hypothetical protein Poli38472_013110 [Pythium oligandrum] | diamond | 7470 | 77.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum |
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);;