contig_metadata
21 rows where bioproject = "PRJNA352610", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 393856 | 393856 | PRJNA352610_P_NODE_23101_length_262_cov_1.148148_g23040_i0 | PRJNA352610 | 23101 | 262 | 1.148148 | 3.00814776 | Peronospora belbahrii | 622444 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.37e-34 | NTclustered | gi|1590853183|gb|MH620960.1| | 622444 | g23040 | i0 | 82.011 | 33.1641221374046 | 189 | 32 | 72 | 2 | 69 | 256 | 103 | 290 | Peronospora belbahrii isolate HI01 beta-tubulin mRNA, complete cds | blastn | 8689 | 159 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 393932 | 393932 | PRJNA352610_P_NODE_26761_length_249_cov_0.875000_g26700_i0 | PRJNA352610 | 26761 | 249 | 0.875 | 2.17875 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 7.709999999999999e-37 | NTclustered | gi|2795041302|ref|XM_067930902.1| | 4785 | g26700 | i0 | 80.455 | 21.4738955823293 | 220 | 41 | 88 | 2 | 23 | 241 | 1359 | 1141 | Phytophthora cinnamomi CCR4-NOT transcription complex subunit 11 (IUM83_06675), partial mRNA | blastn | 5347 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 19519807 | 19519807 | PRJNA352610_P_NODE_31936_length_241_cov_0.916667_g31875_i0 | PRJNA352610 | 31936 | 241 | 0.916667 | 2.20916747 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|2794919753|ref|XM_067895242.1| | 164328 | g31875 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 30 | 57 | 39 | 66 | Phytophthora ramorum Choline transporter-like protein 1 (KRP23_9661), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 26617143 | 26617143 | PRJNA352610_P_NODE_2281_length_641_cov_1.382042_g2222_i0 | PRJNA352610 | 2281 | 641 | 1.382042 | 8.85888922 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 9.35e-91 | NR | KAF1326337.1 | 82926 | g2222 | i0 | 67 | 3.9594383775351 | 212 | 68 | 99.2 | 1 | 3 | 638 | 13 | 222 | KAF1326337.1 Ribulose-phosphate 3-epimerase, partial [Globisporangium splendens] | diamond | 2538 | 277 | 0.996389891696751 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 26821770 | 26821770 | PRJNA352610_P_NODE_11541_length_349_cov_1.137681_g11480_i0 | PRJNA352610 | 11541 | 349 | 1.137681 | 3.97050669 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.22e-8 | NR | KAF0690009.1 | 120398 | g11480 | i0 | 37.6 | 0.730659025787966 | 85 | 53 | 73.1 | 0 | 95 | 349 | 690 | 774 | KAF0690009.1 hypothetical protein As57867_018509 [Aphanomyces stellatus] | diamond | 255 | 62.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27769995 | 27769995 | PRJNA352610_P_NODE_30984_length_242_cov_0.911243_g30923_i0 | PRJNA352610 | 30984 | 242 | 0.911243 | 2.20520806 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 6.3299999999999986e-24 | NR | XP_012199480.1 | 695850 | g30923 | i0 | 69.3 | 1.8595041322314 | 75 | 22 | 93 | 1 | 14 | 238 | 43 | 116 | XP_012199480.1 hypothetical protein SPRG_04952 [Saprolegnia parasitica CBS 223.65] | diamond | 450 | 98.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 27895942 | 27895942 | PRJNA352610_P_NODE_24405_length_254_cov_1.276243_g24344_i0 | PRJNA352610 | 24405 | 254 | 1.276243 | 3.24165722 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 3.76e-5 | NR | XP_008872675.1 | 157072 | g24344 | i0 | 39.3 | 1.98425196850394 | 84 | 47 | 95.7 | 2 | 245 | 3 | 139 | 221 | XP_008872675.1 tRNA pseudouridine(38-40) synthase, variant 2 [Aphanomyces invadans] | diamond | 504 | 51.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 28022507 | 28022507 | PRJNA352610_P_NODE_4925_length_483_cov_1.126829_g4864_i0 | PRJNA352610 | 4925 | 483 | 1.126829 | 5.44258407 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 0.00197 | NR | XP_008617958.1 | 1156394 | g4864 | i0 | 47.2 | 0.329192546583851 | 53 | 27 | 32.3 | 1 | 166 | 11 | 370 | 422 | XP_008617958.1 hypothetical protein SDRG_13639 [Saprolegnia diclina VS20] | diamond | 159 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 28401210 | 28401210 | PRJNA352610_P_NODE_14686_length_319_cov_1.065041_g14625_i0 | PRJNA352610 | 14686 | 319 | 1.065041 | 3.39748079 | Phytophthora palmivora | 4796 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0257 | NR | POM58589.1 | 4796 | g14625 | i0 | 32 | 1.49529780564263 | 75 | 50 | 69.6 | 1 | 314 | 93 | 45 | 119 | POM58589.1 Ankyrin repeat protein [Phytophthora palmivora] | diamond | 477 | 44.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 28401229 | 28401229 | PRJNA352610_P_NODE_26066_length_250_cov_0.870056_g26005_i0 | PRJNA352610 | 26066 | 250 | 0.870056 | 2.17514 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 5.12e-4 | NR | RHY29310.1 | 157072 | g26005 | i0 | 51.4 | 2.1 | 35 | 17 | 42 | 0 | 83 | 187 | 552 | 586 | RHY29310.1 hypothetical protein DYB32_005240 [Aphanomyces invadans] | diamond | 525 | 48.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 28748514 | 28748514 | PRJNA352610_P_NODE_24067_length_256_cov_1.262295_g24006_i0 | PRJNA352610 | 24067 | 256 | 1.262295 | 3.2314752 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00352 | NR | GLD96390.1 | 114742 | g24006 | i0 | 42.1 | 2.23828125 | 38 | 22 | 44.5 | 0 | 255 | 142 | 206 | 243 | GLD96390.1 hypothetical protein PINS_up005073 [Pythium insidiosum] | diamond | 573 | 45.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 29049993 | 29049993 | PRJNA352610_P_NODE_15508_length_313_cov_0.854167_g15447_i0 | PRJNA352610 | 15508 | 313 | 0.854167 | 2.67354271 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.84e-22 | NR | KAK1947031.1 | 4793 | g15447 | i0 | 51.7 | 12.1533546325879 | 89 | 43 | 85.3 | 0 | 310 | 44 | 962 | 1050 | KAK1947031.1 Xanthine dehydrogenase [Phytophthora citrophthora] | diamond | 3804 | 102 | 0.990196078431373 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 29663846 | 29663846 | PRJNA352610_P_NODE_7150_length_419_cov_1.335260_g7089_i0 | PRJNA352610 | 7150 | 419 | 1.33526 | 5.5947394 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.4699999999999996e-29 | NR | KUF80320.1 | 4792 | g7089 | i0 | 51.6 | 1.90453460620525 | 128 | 60 | 91.6 | 2 | 3 | 386 | 241 | 366 | KUF80320.1 hypothetical protein AM587_10016941 [Phytophthora nicotianae] | diamond | 798 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 29997319 | 29997319 | PRJNA352610_P_NODE_1471_length_757_cov_1.130117_g1419_i0 | PRJNA352610 | 1471 | 757 | 1.130117 | 8.55498569 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 1.61e-26 | NR | TMW57009.1 | 41045 | g1419 | i0 | 31.3 | 1.82694848084544 | 230 | 138 | 87.6 | 5 | 753 | 91 | 68 | 286 | TMW57009.1 hypothetical protein Poli38472_002934 [Pythium oligandrum] | diamond | 1383 | 116 | 0.991379310344828 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30408242 | 30408242 | PRJNA352610_P_NODE_6853_length_426_cov_1.305949_g6792_i0 | PRJNA352610 | 6853 | 426 | 1.305949 | 5.56334274 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.9e-38 | NR | KAF0693398.1 | 120398 | g6792 | i0 | 49 | 11.4507042253521 | 145 | 65 | 99.3 | 3 | 3 | 425 | 145 | 284 | KAF0693398.1 hypothetical protein As57867_015595 [Aphanomyces stellatus] | diamond | 4878 | 142 | 0.992957746478873 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 30580065 | 30580065 | PRJNA352610_P_NODE_25893_length_250_cov_0.870056_g25832_i0 | PRJNA352610 | 25893 | 250 | 0.870056 | 2.17514 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00343 | NR | KAF1329359.1 | 82926 | g25832 | i0 | 44.6 | 0.78 | 65 | 32 | 78 | 2 | 198 | 4 | 129 | 189 | KAF1329359.1 reverse transcriptase, partial [Globisporangium splendens] | diamond | 195 | 45.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 30833068 | 30833068 | PRJNA352610_P_NODE_24374_length_254_cov_1.624309_g24313_i0 | PRJNA352610 | 24374 | 254 | 1.624309 | 4.12574486 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 3.14e-5 | NR | TYZ68931.1 | 1485010 | g24313 | i0 | 46 | 0.590551181102362 | 50 | 27 | 59.1 | 0 | 248 | 99 | 343 | 392 | TYZ68931.1 hypothetical protein PybrP1_012193, partial [[Pythium] brassicae (nom. inval.)] | diamond | 150 | 51.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31402190 | 31402190 | PRJNA352610_P_NODE_23856_length_257_cov_1.603261_g23795_i0 | PRJNA352610 | 23856 | 257 | 1.603261 | 4.12038077 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 4.07e-4 | NR | TMW64476.1 | 41045 | g23795 | i0 | 37.9 | 2.49805447470817 | 58 | 34 | 65.4 | 1 | 75 | 242 | 121 | 178 | TMW64476.1 hypothetical protein Poli38472_011356 [Pythium oligandrum] | diamond | 642 | 48.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31654856 | 31654856 | PRJNA352610_P_NODE_13897_length_325_cov_1.535714_g13836_i0 | PRJNA352610 | 13897 | 325 | 1.535714 | 4.9910705 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 1.4e-15 | NR | XP_067816803.1 | 4779 | g13836 | i0 | 70.2 | 3.13846153846154 | 57 | 16 | 52.6 | 1 | 155 | 325 | 27 | 82 | XP_067816803.1 hypothetical protein CCR75_001676 [Bremia lactucae] | diamond | 1020 | 81.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 31686543 | 31686543 | PRJNA352610_P_NODE_18517_length_290_cov_1.064516_g18456_i0 | PRJNA352610 | 18517 | 290 | 1.064516 | 3.0870964 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 3.19e-14 | NR | KAF1332490.1 | 82926 | g18456 | i0 | 42 | 1.03448275862069 | 100 | 53 | 98.3 | 2 | 285 | 1 | 208 | 307 | KAF1332490.1 Kinesin-like protein, partial [Globisporangium splendens] | diamond | 300 | 77.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 32824435 | 32824435 | PRJNA352610_P_NODE_19060_length_287_cov_0.864486_g18999_i0 | PRJNA352610 | 19060 | 287 | 0.864486 | 2.48107482 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 5.09e-13 | NR | TMW60219.1 | 41045 | g18999 | i0 | 50.7 | 0.721254355400697 | 69 | 34 | 72.1 | 0 | 284 | 78 | 59 | 127 | TMW60219.1 hypothetical protein Poli38472_000261 [Pythium oligandrum] | diamond | 207 | 72.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);;