contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA758088" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13489562 | 13489562 | PRJNA758088_P_NODE_212291_length_292_cov_1.406393_g205320_i0 | PRJNA758088 | 212291 | 292 | 1.406393 | 4.10666756 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 203 | 1.92e-64 | NR | XP_024584861.1 | 4781 | g205320 | i0 | 97.9 | 10.9623287671233 | 97 | 2 | 99.7 | 0 | 292 | 2 | 59 | 155 | XP_024584861.1 adp-ribosylation factor [Plasmopara halstedii] | diamond | 3201 | 203 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 26799770 | 26799770 | PRJNA758088_P_NODE_340041_length_244_cov_0.900585_g333070_i0 | PRJNA758088 | 340041 | 244 | 0.900585 | 2.1974274 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 1.7e-5 | NR | OQR92591.1 | 74557 | g333070 | i0 | 34.1 | 1.99180327868852 | 82 | 48 | 93.4 | 1 | 228 | 1 | 6 | 87 | OQR92591.1 hypothetical protein THRCLA_08670, partial [Thraustotheca clavata] | diamond | 486 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 27062741 | 27062741 | PRJNA758088_P_NODE_249322_length_269_cov_1.260204_g242351_i0 | PRJNA758088 | 249322 | 269 | 1.260204 | 3.38994876 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 9.24e-10 | NR | XP_024576743.1 | 4781 | g242351 | i0 | 41.5 | 2.68773234200743 | 82 | 44 | 87 | 1 | 2 | 235 | 33 | 114 | XP_024576743.1 Protein of unknown function DUF3661, vaculolar transmembrane [Plasmopara halstedii] | diamond | 723 | 64.3 | 0.993779160186625 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 28104917 | 28104917 | PRJNA758088_P_NODE_210165_length_294_cov_1.040724_g203194_i0 | PRJNA758088 | 210165 | 294 | 1.040724 | 3.05972856 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 2.19e-16 | NR | XP_067818556.1 | 4779 | g203194 | i0 | 46.5 | 7.07142857142857 | 99 | 51 | 99 | 1 | 292 | 2 | 139 | 237 | XP_067818556.1 hypothetical protein CCR75_004917 [Bremia lactucae] | diamond | 2079 | 83.6 | 0.990430622009569 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 28168272 | 28168272 | PRJNA758088_P_NODE_361245_length_241_cov_0.916667_g354274_i0 | PRJNA758088 | 361245 | 241 | 0.916667 | 2.20916747 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.96e-28 | NR | DBA00640.1 | 4803 | g354274 | i0 | 61.7 | 11.0663900414938 | 81 | 30 | 99.6 | 1 | 1 | 240 | 194 | 274 | DBA00640.1 TPA: hypothetical protein N0F65_003569 [Lagenidium giganteum] | diamond | 2667 | 116 | 0.991379310344828 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28610318 | 28610318 | PRJNA758088_P_NODE_320947_length_246_cov_0.890173_g313976_i0 | PRJNA758088 | 320947 | 246 | 0.890173 | 2.18982558 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 8.11e-14 | NR | XP_024571954.1 | 4781 | g313976 | i0 | 64.3 | 6.86585365853659 | 56 | 20 | 68.3 | 0 | 170 | 3 | 393 | 448 | XP_024571954.1 cmgc clk protein kinase [Plasmopara halstedii] | diamond | 1689 | 75.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 28821183 | 28821183 | PRJNA758088_P_NODE_353768_length_242_cov_0.911243_g346797_i0 | PRJNA758088 | 353768 | 242 | 0.911243 | 2.20520806 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 7.54e-5 | NR | KAH9127232.1 | 100861 | g346797 | i0 | 36.3 | 2.83884297520661 | 80 | 48 | 97.9 | 2 | 238 | 2 | 123 | 200 | KAH9127232.1 hypothetical protein AeMF1_002449 [Aphanomyces euteiches] | diamond | 687 | 50.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 29452647 | 29452647 | PRJNA758088_P_NODE_306870_length_248_cov_0.880000_g299899_i0 | PRJNA758088 | 306870 | 248 | 0.88 | 2.1824 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.91e-32 | NR | DAZ97989.1 | 4803 | g299899 | i0 | 77.2 | 1.91129032258065 | 79 | 18 | 95.6 | 0 | 239 | 3 | 204 | 282 | DAZ97989.1 TPA: hypothetical protein N0F65_005147 [Lagenidium giganteum] | diamond | 474 | 127 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30252536 | 30252536 | PRJNA758088_P_NODE_237792_length_276_cov_1.275862_g230821_i0 | PRJNA758088 | 237792 | 276 | 1.275862 | 3.52137912 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.28e-9 | NR | XP_008870975.1 | 157072 | g230821 | i0 | 41.4 | 2.82608695652174 | 87 | 49 | 94.6 | 2 | 268 | 8 | 96 | 180 | XP_008870975.1 hypothetical protein H310_07366 [Aphanomyces invadans] | diamond | 780 | 63.2 | 0.993670886075949 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 31199793 | 31199793 | PRJNA758088_P_NODE_38355_length_748_cov_1.554074_g32086_i0 | PRJNA758088 | 38355 | 748 | 1.554074 | 11.62447352 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.8e-31 | NR | OQS00341.1 | 74557 | g32086 | i0 | 40.1 | 2.97192513368984 | 172 | 101 | 68.6 | 2 | 3 | 515 | 77 | 247 | OQS00341.1 hypothetical protein THRCLA_06000 [Thraustotheca clavata] | diamond | 2223 | 129 | 0.992248062015504 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31380324 | 31380324 | PRJNA758088_P_NODE_300436_length_249_cov_0.875000_g293465_i0 | PRJNA758088 | 300436 | 249 | 0.875 | 2.17875 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 4.8e-13 | NR | TYZ58174.1 | 1485010 | g293465 | i0 | 51.9 | 0.951807228915663 | 79 | 38 | 95.2 | 0 | 5 | 241 | 143 | 221 | TYZ58174.1 hypothetical protein PybrP1_005726 [[Pythium] brassicae (nom. inval.)] | diamond | 237 | 72.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31927675 | 31927675 | PRJNA758088_P_NODE_341577_length_244_cov_0.900585_g334606_i0 | PRJNA758088 | 341577 | 244 | 0.900585 | 2.1974274 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 6.92e-8 | NR | ETI41766.1 | 1317065 | g334606 | i0 | 54.2 | 2.95081967213115 | 48 | 22 | 59 | 0 | 95 | 238 | 293 | 340 | ETI41766.1 hypothetical protein F443_13025 [Phytophthora nicotianae P1569] | diamond | 720 | 58.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 32834111 | 32834111 | PRJNA758088_P_NODE_146320_length_348_cov_1.389091_g139349_i0 | PRJNA758088 | 146320 | 348 | 1.389091 | 4.83403668 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 2.28e-21 | NR | XP_008867388.1 | 157072 | g139349 | i0 | 48.3 | 2.25 | 87 | 45 | 75 | 0 | 3 | 263 | 214 | 300 | XP_008867388.1 hypothetical protein H310_04708 [Aphanomyces invadans] | diamond | 783 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans |
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);;