contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB50765" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119568 | 119568 | PRJEB50765_P_NODE_661_length_421_cov_1.807292_g637_i0 | PRJEB50765 | 661 | 421 | 1.807292 | 7.60869932 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.4e-74 | NR | KAH9108398.1 | 100861 | g637 | i0 | 83.9 | 5.85748218527316 | 137 | 22 | 97.6 | 0 | 419 | 9 | 344 | 480 | KAH9108398.1 hypothetical protein AeMF1_016428 [Aphanomyces euteiches] | diamond | 2466 | 239 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9046778 | 9046778 | PRJEB50765_P_NODE_1008_length_322_cov_1.828070_g984_i0 | PRJEB50765 | 1008 | 322 | 1.82807 | 5.8863854 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 1.29e-46 | NR | KAH9108398.1 | 100861 | g984 | i0 | 83 | 2.62732919254658 | 94 | 16 | 87.6 | 0 | 3 | 284 | 387 | 480 | KAH9108398.1 hypothetical protein AeMF1_016428 [Aphanomyces euteiches] | diamond | 846 | 166 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9046789 | 9046789 | PRJEB50765_P_NODE_2848_length_164_cov_1.527559_g2824_i0 | PRJEB50765 | 2848 | 164 | 1.5275589999999999 | 2.50519676 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 2.37e-15 | NR | CAI5742847.1 | 162125 | g2824 | i0 | 73.1 | 3.89634146341463 | 52 | 14 | 95.1 | 0 | 3 | 158 | 127 | 178 | CAI5742847.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 639 | 77 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 14147899 | 14147899 | PRJEB50765_P_NODE_892_length_350_cov_2.616613_g868_i0 | PRJEB50765 | 892 | 350 | 2.616613 | 9.1581455 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 188 | 3.6199999999999995e-56 | NR | OQS04692.1 | 74557 | g868 | i0 | 85.5 | 14.1771428571429 | 110 | 16 | 94.3 | 0 | 19 | 348 | 1 | 110 | OQS04692.1 aspartyl/Asparaginyl beta-hydroxylase [Thraustotheca clavata] | diamond | 4962 | 188 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 24345406 | 24345406 | PRJEB50765_P_NODE_1320_length_266_cov_1.864629_g1296_i0 | PRJEB50765 | 1320 | 266 | 1.864629 | 4.95991314 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 1.17e-29 | NR | TMW58359.1 | 41045 | g1296 | i0 | 71.6 | 5.04135338345865 | 74 | 21 | 83.5 | 0 | 261 | 40 | 45 | 118 | TMW58359.1 hypothetical protein Poli38472_009918 [Pythium oligandrum] | diamond | 1341 | 112 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 28201943 | 28201943 | PRJEB50765_P_NODE_2326_length_186_cov_1.046980_g2302_i0 | PRJEB50765 | 2326 | 186 | 1.04698 | 1.9473828 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 6.81e-20 | NR | DAZ95755.1 | 4803 | g2302 | i0 | 71.9 | 1.80645161290323 | 57 | 16 | 91.9 | 0 | 1 | 171 | 361 | 417 | DAZ95755.1 TPA: hypothetical protein N0F65_006403 [Lagenidium giganteum] | diamond | 336 | 91.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31006242 | 31006242 | PRJEB50765_P_NODE_534_length_472_cov_3.825287_g511_i0 | PRJEB50765 | 534 | 472 | 3.825287 | 18.05535464 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 4.93e-43 | NR | XP_024573476.1 | 4781 | g511 | i0 | 64.7 | 8.6885593220339 | 116 | 41 | 73.7 | 0 | 447 | 100 | 533 | 648 | XP_024573476.1 dead deah box helicase [Plasmopara halstedii] | diamond | 4101 | 162 | 0.993827160493827 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 31234024 | 31234024 | PRJEB50765_P_NODE_1695_length_227_cov_2.452632_g1671_i0 | PRJEB50765 | 1695 | 227 | 2.452632 | 5.56747464 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 6.080000000000001e-27 | NR | GLE03297.1 | 114742 | g1671 | i0 | 75.4 | 6.7136563876652 | 65 | 16 | 85.9 | 0 | 196 | 2 | 1 | 65 | GLE03297.1 hypothetical protein PINS_up012187 [Pythium insidiosum] | diamond | 1524 | 106 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31265854 | 31265854 | PRJEB50765_P_NODE_2235_length_190_cov_0.908497_g2211_i0 | PRJEB50765 | 2235 | 190 | 0.908497 | 1.7261443 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 1.2e-4 | NR | TYZ61222.1 | 1485010 | g2211 | i0 | 65.6 | 0.505263157894737 | 32 | 11 | 50.5 | 0 | 94 | 189 | 6 | 37 | TYZ61222.1 hypothetical protein PybrP1_011567 [[Pythium] brassicae (nom. inval.)] | diamond | 96 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31265855 | 31265855 | PRJEB50765_P_NODE_675_length_416_cov_1.810026_g651_i0 | PRJEB50765 | 675 | 416 | 1.810026 | 7.52970816 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 2.8e-53 | NR | TMW55105.1 | 41045 | g651 | i0 | 67.7 | 4.74519230769231 | 133 | 42 | 95.2 | 1 | 396 | 1 | 1 | 133 | TMW55105.1 hypothetical protein Poli38472_013867 [Pythium oligandrum] | diamond | 1974 | 174 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 32144882 | 32144882 | PRJEB50765_P_NODE_2818_length_165_cov_1.507812_g2794_i0 | PRJEB50765 | 2818 | 165 | 1.507812 | 2.4878898 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 3.58e-20 | NR | DAZ99137.1 | 4803 | g2794 | i0 | 83.3 | 13.7454545454545 | 54 | 9 | 98.2 | 0 | 2 | 163 | 152 | 205 | DAZ99137.1 TPA: hypothetical protein N0F65_010221 [Lagenidium giganteum] | diamond | 2268 | 92.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum |
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);;