contig_metadata
11 rows where bioproject = "PRJNA564810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 554073 | 554073 | PRJNA564810_S_NODE_1961_length_339_cov_2.105839_g1939_i0 | PRJNA564810 | 1961 | 339 | 2.105839 | 7.13879421 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.69e-32 | NR | KAH9113818.1 | 100861 | g1939 | i0 | 70.7 | 3.73451327433628 | 82 | 23 | 72.6 | 1 | 334 | 89 | 340 | 420 | KAH9113818.1 hypothetical protein AeMF1_012051 [Aphanomyces euteiches] | diamond | 1266 | 128 | 0.9921875 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 11336730 | 11336730 | PRJNA564810_S_NODE_1489_length_363_cov_1.721477_g1467_i0 | PRJNA564810 | 1489 | 363 | 1.721477 | 6.24896151 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.0299999999999999e-40 | NR | XP_012202741.1 | 695850 | g1467 | i0 | 67.6 | 5.90082644628099 | 102 | 33 | 84.3 | 0 | 363 | 58 | 467 | 568 | XP_012202741.1 hypothetical protein SPRG_08003 [Saprolegnia parasitica CBS 223.65] | diamond | 2142 | 152 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 17711474 | 17711474 | PRJNA564810_S_NODE_1794_length_346_cov_4.085409_g1772_i0 | PRJNA564810 | 1794 | 346 | 4.085409 | 14.13551514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 5.11e-50 | NTclustered | gi|937408816|ref|NC_027966.1| | 114742 | g1772 | i0 | 79.739 | 94.7109826589595 | 306 | 51 | 87 | 10 | 45 | 344 | 9797 | 10097 | Pythium insidiosum mitochondrial DNA, complete genome | blastn | 32770 | 213 | 0.990610328638498 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 18406200 | 18406200 | PRJNA564810_S_NODE_455_length_509_cov_2.619369_g434_i0 | PRJNA564810 | 455 | 509 | 2.619369 | 13.33258821 | Hyaloperonospora arabidopsidis | 272952 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 1.7400000000000003e-21 | NTclustered | gi|2248512796|ref|NC_063789.1| | 272952 | g434 | i0 | 77.949 | 59.2848722986248 | 195 | 37 | 38 | 5 | 51 | 243 | 917 | 1107 | Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome | blastn | 30176 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora arabidopsidis | ||
| 24780400 | 24780400 | PRJNA564810_S_NODE_3140_length_294_cov_2.751092_g3118_i0 | PRJNA564810 | 3140 | 294 | 2.751092 | 8.08821048 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 1.87e-14 | NR | XP_024576029.1 | 4781 | g3118 | i0 | 85 | 9.36734693877551 | 40 | 6 | 40.8 | 0 | 1 | 120 | 347 | 386 | XP_024576029.1 dead-box atp-dependent rna helicase 8 [Plasmopara halstedii] | diamond | 2754 | 78.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 27914140 | 27914140 | PRJNA564810_S_NODE_7025_length_223_cov_0.860759_g7003_i0 | PRJNA564810 | 7025 | 223 | 0.860759 | 1.91949257 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 1.37e-12 | NR | KAF4145619.1 | 4787 | g7003 | i0 | 72.7 | 1.77578475336323 | 44 | 12 | 59.2 | 0 | 8 | 139 | 203 | 246 | KAF4145619.1 GDP dissociation inhibitor domain-containing protein [Phytophthora infestans] | diamond | 396 | 70.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 29794847 | 29794847 | PRJNA564810_S_NODE_2911_length_301_cov_3.639831_g2889_i0 | PRJNA564810 | 2911 | 301 | 3.639831 | 10.95589131 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 7.19e-8 | NR | KAF0735749.1 | 100861 | g2889 | i0 | 41 | 1.04651162790698 | 105 | 53 | 96.7 | 3 | 298 | 8 | 235 | 338 | KAF0735749.1 hypothetical protein Ae201684_007755 [Aphanomyces euteiches] | diamond | 315 | 59.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30837597 | 30837597 | PRJNA564810_S_NODE_2094_length_332_cov_2.250936_g2072_i0 | PRJNA564810 | 2094 | 332 | 2.250936 | 7.47310752 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 2.09e-9 | NR | DAZ99226.1 | 4803 | g2072 | i0 | 35.6 | 2.26807228915663 | 87 | 56 | 78.6 | 0 | 3 | 263 | 796 | 882 | DAZ99226.1 TPA: hypothetical protein N0F65_008093 [Lagenidium giganteum] | diamond | 753 | 64.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31153172 | 31153172 | PRJNA564810_S_NODE_7175_length_221_cov_2.179487_g7153_i0 | PRJNA564810 | 7175 | 221 | 2.179487 | 4.81666627 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.01e-4 | NR | CCI43921.1 | 65357 | g7153 | i0 | 63.6 | 9.38009049773756 | 33 | 12 | 44.8 | 0 | 1 | 99 | 1086 | 1118 | CCI43921.1 unnamed protein product [Albugo candida] | diamond | 2073 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 31198463 | 31198463 | PRJNA564810_S_NODE_3695_length_280_cov_1.897674_g3673_i0 | PRJNA564810 | 3695 | 280 | 1.897674 | 5.3134872 | root | 1 | Root_unresolved | Root_unresolved | 47 | 0.00189 | NR | TYZ63837.1 | 1485010 | g3673 | i0 | 51.1 | 1.92857142857143 | 47 | 23 | 50.4 | 0 | 274 | 134 | 651 | 697 | TYZ63837.1 hypothetical protein PybrP1_001433 [[Pythium] brassicae (nom. inval.)] | diamond | 540 | 47 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31546976 | 31546976 | PRJNA564810_S_NODE_3736_length_279_cov_1.761682_g3714_i0 | PRJNA564810 | 3736 | 279 | 1.761682 | 4.91509278 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 2.07e-14 | NR | TMW64388.1 | 41045 | g3714 | i0 | 67.2 | 6.3010752688172 | 64 | 20 | 68.8 | 1 | 192 | 1 | 242 | 304 | TMW64388.1 hypothetical protein Poli38472_013010 [Pythium oligandrum] | diamond | 1758 | 78.2 | 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);;