contig_metadata
13 rows where bioproject = "PRJNA1180292" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4144746 | 4144746 | PRJNA1180292_P_NODE_11884_length_244_cov_0.912281_g11752_i0 | PRJNA1180292 | 11884 | 244 | 0.912281 | 2.22596564 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|301095059|ref|XM_002896586.1| | 403677 | g11752 | i0 | 96.774 | 0.127049180327869 | 31 | 1 | 13 | 0 | 206 | 236 | 182 | 152 | Phytophthora infestans T30-4 uncharacterized protein (PITG_17785), partial mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 13071480 | 13071480 | PRJNA1180292_P_NODE_2271_length_452_cov_1.535620_g2139_i0 | PRJNA1180292 | 2271 | 452 | 1.53562 | 6.9410024 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2e-31 | NR | OQR88668.1 | 74557 | g2139 | i0 | 56.5 | 2.35619469026549 | 115 | 46 | 76.3 | 2 | 81 | 425 | 100 | 210 | OQR88668.1 DEAD/DEAH box RNA helicase [Thraustotheca clavata] | diamond | 1065 | 129 | 0.992248062015504 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 13071526 | 13071526 | PRJNA1180292_P_NODE_7871_length_253_cov_0.866667_g7739_i0 | PRJNA1180292 | 7871 | 253 | 0.866667 | 2.19266751 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|669166087|ref|XM_008620384.1| | 1156394 | g7739 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 119 | 146 | 2518 | 2491 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 21994487 | 21994487 | PRJNA1180292_P_NODE_11298_length_246_cov_0.901734_g11166_i0 | PRJNA1180292 | 11298 | 246 | 0.901734 | 2.21826564 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.66e-28 | NTclustered | gi|813142308|ref|XM_012343858.1| | 695850 | g11166 | i0 | 92 | 2.55284552845528 | 100 | 7 | 41 | 1 | 4 | 103 | 890 | 988 | Saprolegnia parasitica CBS 223.65 aspartate carbamoyltransferase mRNA | blastn | 628 | 139 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 21994570 | 21994570 | PRJNA1180292_P_NODE_6798_length_270_cov_1.786802_g6666_i0 | PRJNA1180292 | 6798 | 270 | 1.786802 | 4.8243654 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 6.4999999999999984e-43 | NTclustered | gi|2661441985|ref|XR_009934438.1| | 403677 | g6666 | i0 | 94.355 | 45.9333333333333 | 124 | 4 | 46 | 3 | 55 | 178 | 1292 | 1412 | Phytophthora infestans T30-4 28S ribosomal RNA (PITG_33044), partial rRNA | blastn | 12402 | 187 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 27609402 | 27609402 | PRJNA1180292_P_NODE_11164_length_246_cov_0.901734_g11032_i0 | PRJNA1180292 | 11164 | 246 | 0.901734 | 2.21826564 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.22e-6 | NR | KAG1704360.1 | 4784 | g11032 | i0 | 44.1 | 1.3780487804878 | 59 | 32 | 72 | 1 | 35 | 211 | 24 | 81 | KAG1704360.1 hypothetical protein DVH05_006368 [Phytophthora capsici] | diamond | 339 | 55.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 27660183 | 27660183 | PRJNA1180292_P_NODE_2444_length_435_cov_1.240331_g2312_i0 | PRJNA1180292 | 2444 | 435 | 1.240331 | 5.39543985 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 8.719999999999999e-45 | NR | TMW61584.1 | 41045 | g2312 | i0 | 61.3 | 7.7448275862069 | 124 | 48 | 85.5 | 0 | 374 | 3 | 3 | 126 | TMW61584.1 hypothetical protein Poli38472_012775 [Pythium oligandrum] | diamond | 3369 | 153 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 27798915 | 27798915 | PRJNA1180292_P_NODE_10364_length_248_cov_0.891429_g10232_i0 | PRJNA1180292 | 10364 | 248 | 0.891429 | 2.21074392 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 6.07e-11 | NR | DAZ99581.1 | 4803 | g10232 | i0 | 63.6 | 0.665322580645161 | 55 | 16 | 61.7 | 1 | 92 | 244 | 37 | 91 | DAZ99581.1 TPA: hypothetical protein N0F65_001409 [Lagenidium giganteum] | diamond | 165 | 67.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28745951 | 28745951 | PRJNA1180292_P_NODE_8087_length_253_cov_0.866667_g7955_i0 | PRJNA1180292 | 8087 | 253 | 0.866667 | 2.19266751 | Phytophthora citrophthora | 4793 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.03 | NR | KAK1934529.1 | 4793 | g7955 | i0 | 44.4 | 0.533596837944664 | 45 | 24 | 53.4 | 1 | 137 | 3 | 56 | 99 | KAK1934529.1 Protein-glutamate O-methyltransferase C1393.13 [Phytophthora citrophthora] | diamond | 135 | 43.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 30767330 | 30767330 | PRJNA1180292_P_NODE_10914_length_246_cov_1.595376_g10782_i0 | PRJNA1180292 | 10914 | 246 | 1.595376 | 3.92462496 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 1.64e-13 | NR | KAF1318798.1 | 82926 | g10782 | i0 | 54.5 | 1.68292682926829 | 66 | 29 | 79.3 | 1 | 207 | 13 | 52 | 117 | KAF1318798.1 Dihydrolipoyllysine-residue succinyltransferase component of 2-oxoglutarate dehydrogenase, partial [Globisporangium splendens] | diamond | 414 | 75.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 31368013 | 31368013 | PRJNA1180292_P_NODE_5236_length_304_cov_2.086580_g5104_i0 | PRJNA1180292 | 5236 | 304 | 2.08658 | 6.3432032 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 1.2e-20 | NR | DAZ93756.1 | 4803 | g5104 | i0 | 54.5 | 2.37828947368421 | 77 | 35 | 76 | 0 | 4 | 234 | 300 | 376 | DAZ93756.1 TPA: hypothetical protein N0F65_000599 [Lagenidium giganteum] | diamond | 723 | 95.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 32538552 | 32538552 | PRJNA1180292_P_NODE_6539_length_275_cov_1.544554_g6407_i0 | PRJNA1180292 | 6539 | 275 | 1.544554 | 4.2475235 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 5.43e-9 | NR | KAF4318810.1 | 1284355 | g6407 | i0 | 45.5 | 0.84 | 77 | 40 | 81.8 | 2 | 269 | 45 | 1 | 77 | KAF4318810.1 hypothetical protein G195_007779 [Phytophthora kernoviae 00238/432] | diamond | 231 | 58.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 32746500 | 32746500 | PRJNA1180292_P_NODE_6200_length_282_cov_1.468900_g6068_i0 | PRJNA1180292 | 6200 | 282 | 1.4689 | 4.142298 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 2.33e-10 | NR | POM69094.1 | 4796 | g6068 | i0 | 42.5 | 3.70212765957447 | 87 | 43 | 92.6 | 1 | 261 | 1 | 269 | 348 | POM69094.1 Crinkler (CRN) family protein [Phytophthora palmivora] | diamond | 1044 | 66.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora |
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);;