contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA492406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24678415 | 24678415 | PRJNA492406_P_NODE_18540_length_290_cov_1.184332_g18241_i0 | PRJNA492406 | 18540 | 290 | 1.184332 | 3.4345628 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 2.12e-29 | NR | TYZ62936.1 | 1485010 | g18241 | i0 | 57.3 | 11.8965517241379 | 96 | 41 | 99.3 | 0 | 2 | 289 | 40 | 135 | TYZ62936.1 hypothetical protein PybrP1_003316 [[Pythium] brassicae (nom. inval.)] | diamond | 3450 | 115 | 0.991304347826087 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 26633231 | 26633231 | PRJNA492406_P_NODE_31041_length_243_cov_0.905882_g30742_i0 | PRJNA492406 | 31041 | 243 | 0.905882 | 2.20129326 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.51e-5 | NR | XP_024574507.1 | 4781 | g30742 | i0 | 48.3 | 1.67901234567901 | 58 | 27 | 71.6 | 2 | 5 | 178 | 1351 | 1405 | XP_024574507.1 Membrane-associated protein FER-1 and related ferlins, contain multiple C2 domains [Plasmopara halstedii] | diamond | 408 | 52.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 26664638 | 26664638 | PRJNA492406_P_NODE_30601_length_244_cov_0.871345_g30302_i0 | PRJNA492406 | 30601 | 244 | 0.871345 | 2.1260818 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.63e-25 | NR | TMW64793.1 | 41045 | g30302 | i0 | 60 | 0.983606557377049 | 80 | 31 | 98.4 | 1 | 243 | 4 | 766 | 844 | TMW64793.1 hypothetical protein Poli38472_008960 [Pythium oligandrum] | diamond | 240 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 27171050 | 27171050 | PRJNA492406_P_NODE_26682_length_251_cov_0.865169_g26383_i0 | PRJNA492406 | 26682 | 251 | 0.865169 | 2.17157419 | Phytophthora palmivora | 4796 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 9.03e-6 | NR | POM60098.1 | 4796 | g26383 | i0 | 59.5 | 0.442231075697211 | 37 | 13 | 44.2 | 1 | 2 | 112 | 14 | 48 | POM60098.1 hypothetical protein PHPALM_31083 [Phytophthora palmivora] | diamond | 111 | 53.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 27471733 | 27471733 | PRJNA492406_P_NODE_21883_length_274_cov_1.532338_g21584_i0 | PRJNA492406 | 21883 | 274 | 1.532338 | 4.19860612 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 2.95e-25 | NR | XP_067820228.1 | 4779 | g21584 | i0 | 55.6 | 12.8102189781022 | 90 | 39 | 98.5 | 1 | 272 | 3 | 402 | 490 | XP_067820228.1 hypothetical protein CCR75_004221 [Bremia lactucae] | diamond | 3510 | 109 | 0.990825688073395 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 27487212 | 27487212 | PRJNA492406_P_NODE_20343_length_282_cov_1.263158_g20044_i0 | PRJNA492406 | 20343 | 282 | 1.263158 | 3.56210556 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 1.64e-5 | NR | KAG9412244.1 | 112091 | g20044 | i0 | 34.6 | 0.861702127659574 | 81 | 50 | 86.2 | 2 | 248 | 6 | 110 | 187 | KAG9412244.1 hypothetical protein AC1031_015185 [Aphanomyces cochlioides] | diamond | 243 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 28860775 | 28860775 | PRJNA492406_P_NODE_31408_length_242_cov_0.911243_g31109_i0 | PRJNA492406 | 31408 | 242 | 0.911243 | 2.20520806 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.5e-4 | NR | KAG2817228.1 | 29920 | g31109 | i0 | 47.7 | 3.07438016528926 | 44 | 23 | 54.5 | 0 | 139 | 8 | 616 | 659 | KAG2817228.1 hypothetical protein PC112_g13146 [Phytophthora cactorum] | diamond | 744 | 49.3 | 0.991886409736308 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 29113570 | 29113570 | PRJNA492406_P_NODE_21888_length_274_cov_1.527363_g21589_i0 | PRJNA492406 | 21888 | 274 | 1.527363 | 4.18497462 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.95e-22 | NR | DBA04368.1 | 4803 | g21589 | i0 | 50 | 9.6021897810219 | 90 | 45 | 98.5 | 0 | 272 | 3 | 1244 | 1333 | DBA04368.1 TPA: hypothetical protein N0F65_002130 [Lagenidium giganteum] | diamond | 2631 | 100 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29350162 | 29350162 | PRJNA492406_P_NODE_6269_length_479_cov_2.007389_g5970_i0 | PRJNA492406 | 6269 | 479 | 2.007389 | 9.61539331 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.84e-21 | NR | KAF1329144.1 | 82926 | g5970 | i0 | 36.9 | 2.01043841336117 | 160 | 87 | 99.6 | 3 | 3 | 479 | 100 | 246 | KAF1329144.1 Major vault protein, partial [Globisporangium splendens] | diamond | 963 | 101 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 29428993 | 29428993 | PRJNA492406_P_NODE_26309_length_252_cov_0.977654_g26010_i0 | PRJNA492406 | 26309 | 252 | 0.977654 | 2.46368808 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 2.02e-17 | NR | CAI5746136.1 | 86335 | g26010 | i0 | 50.6 | 4.07142857142857 | 85 | 40 | 98.8 | 2 | 4 | 252 | 92 | 176 | CAI5746136.1 unnamed protein product [Peronospora destructor] | diamond | 1026 | 85.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora destructor | ||
| 29428995 | 29428995 | PRJNA492406_P_NODE_28929_length_247_cov_0.885057_g28630_i0 | PRJNA492406 | 28929 | 247 | 0.885057 | 2.18609079 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 3.2299999999999996e-45 | NR | DBA03690.1 | 4803 | g28630 | i0 | 93.8 | 4.91902834008097 | 81 | 5 | 98.4 | 0 | 245 | 3 | 46 | 126 | DBA03690.1 TPA: hypothetical protein N0F65_004107 [Lagenidium giganteum] | diamond | 1215 | 157 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29492320 | 29492320 | PRJNA492406_P_NODE_21770_length_275_cov_1.153465_g21471_i0 | PRJNA492406 | 21770 | 275 | 1.153465 | 3.17202875 | root | 1 | Root_unresolved | Root_unresolved | 117 | 3.76e-28 | NR | RHY29296.1 | 157072 | g21471 | i0 | 66.3 | 8.06181818181818 | 80 | 27 | 87.3 | 0 | 20 | 259 | 489 | 568 | RHY29296.1 hypothetical protein DYB32_005265 [Aphanomyces invadans] | diamond | 2217 | 118 | 0.991525423728814 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 30092217 | 30092217 | PRJNA492406_P_NODE_27112_length_250_cov_0.870056_g26813_i0 | PRJNA492406 | 27112 | 250 | 0.870056 | 2.17514 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 9.41e-29 | NR | KAF0687225.1 | 120398 | g26813 | i0 | 70.7 | 8.268 | 75 | 22 | 90 | 0 | 24 | 248 | 26 | 100 | KAF0687225.1 hypothetical protein As57867_020919 [Aphanomyces stellatus] | diamond | 2067 | 117 | 0.991452991452991 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 30724272 | 30724272 | PRJNA492406_P_NODE_5514_length_511_cov_1.648402_g5216_i0 | PRJNA492406 | 5514 | 511 | 1.648402 | 8.42333422 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 175 | 5.03e-53 | NR | TYZ60753.1 | 1485010 | g5216 | i0 | 66.2 | 8.54207436399217 | 133 | 44 | 78.1 | 1 | 22 | 420 | 4 | 135 | TYZ60753.1 hypothetical protein PybrP1_007794 [[Pythium] brassicae (nom. inval.)] | diamond | 4365 | 176 | 0.994318181818182 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 30771669 | 30771669 | PRJNA492406_P_NODE_19134_length_287_cov_2.065421_g18835_i0 | PRJNA492406 | 19134 | 287 | 2.065421 | 5.92775827 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0431 | NR | KAH9106211.1 | 100861 | g18835 | i0 | 28.4 | 0.700348432055749 | 67 | 45 | 70 | 1 | 248 | 48 | 51 | 114 | KAH9106211.1 hypothetical protein AeMF1_018127 [Aphanomyces euteiches] | diamond | 201 | 42.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30834699 | 30834699 | PRJNA492406_P_NODE_31494_length_242_cov_0.911243_g31195_i0 | PRJNA492406 | 31494 | 242 | 0.911243 | 2.20520806 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00405 | NR | GLE07382.1 | 114742 | g31195 | i0 | 47.5 | 1.46280991735537 | 59 | 29 | 70.7 | 1 | 175 | 5 | 282 | 340 | GLE07382.1 hypothetical protein PINS_up017544 [Pythium insidiosum] | diamond | 354 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31293046 | 31293046 | PRJNA492406_P_NODE_31815_length_241_cov_1.470238_g31516_i0 | PRJNA492406 | 31815 | 241 | 1.470238 | 3.54327358 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 4.18e-19 | NR | OQR84160.1 | 1202772 | g31516 | i0 | 57.3 | 4.50622406639004 | 89 | 29 | 99.6 | 1 | 2 | 241 | 368 | 456 | OQR84160.1 major vault protein [Achlya hypogyna] | diamond | 1086 | 91.7 | 0.991275899672846 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 31640939 | 31640939 | PRJNA492406_P_NODE_17816_length_295_cov_2.454955_g17517_i0 | PRJNA492406 | 17816 | 295 | 2.454955 | 7.24211725 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 1.75e-16 | NR | RHY03263.1 | 112090 | g17517 | i0 | 43.3 | 4.63728813559322 | 90 | 51 | 91.5 | 0 | 271 | 2 | 22 | 111 | RHY03263.1 hypothetical protein DYB36_008331, partial [Aphanomyces astaci] | diamond | 1368 | 81.3 | 0.990159901599016 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31719932 | 31719932 | PRJNA492406_P_NODE_7777_length_435_cov_1.696133_g7478_i0 | PRJNA492406 | 7777 | 435 | 1.696133 | 7.37817855 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 1.53e-6 | NR | CCA27070.1 | 890382 | g7478 | i0 | 35.6 | 0.696551724137931 | 101 | 62 | 69.7 | 3 | 431 | 129 | 185 | 282 | CCA27070.1 voltagedependent anionselective channel protein puta [Albugo laibachii Nc14] | diamond | 303 | 57.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 31783029 | 31783029 | PRJNA492406_P_NODE_30677_length_243_cov_1.800000_g30378_i0 | PRJNA492406 | 30677 | 243 | 1.8 | 4.374 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 9.8e-37 | NR | KAJ0390552.1 | 114742 | g30378 | i0 | 82.5 | 3.95061728395062 | 80 | 14 | 98.8 | 0 | 241 | 2 | 113 | 192 | KAJ0390552.1 hypothetical protein ATCC90586_011289 [Pythium insidiosum] | diamond | 960 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32083890 | 32083890 | PRJNA492406_P_NODE_20978_length_279_cov_1.135922_g20679_i0 | PRJNA492406 | 20978 | 279 | 1.135922 | 3.16922238 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.36e-11 | NR | KAF1330486.1 | 82926 | g20679 | i0 | 59.6 | 6.75268817204301 | 52 | 21 | 55.9 | 0 | 162 | 7 | 221 | 272 | KAF1330486.1 Heterogeneous nuclear ribonucleoprotein 1-like isoform x1, partial [Globisporangium splendens] | diamond | 1884 | 70.5 | 0.994326241134752 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 32179038 | 32179038 | PRJNA492406_P_NODE_30798_length_243_cov_1.317647_g30499_i0 | PRJNA492406 | 30798 | 243 | 1.317647 | 3.20188221 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 9.7e-38 | NR | TMW60059.1 | 41045 | g30499 | i0 | 83.8 | 3.95061728395062 | 80 | 13 | 98.8 | 0 | 242 | 3 | 96 | 175 | TMW60059.1 hypothetical protein Poli38472_000101 [Pythium oligandrum] | diamond | 960 | 145 | 0.993103448275862 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 32447868 | 32447868 | PRJNA492406_P_NODE_5759_length_500_cov_1.894614_g5460_i0 | PRJNA492406 | 5759 | 500 | 1.894614 | 9.47307 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.6499999999999998e-72 | NR | KAF0710955.1 | 112090 | g5460 | i0 | 69.1 | 4.896 | 162 | 50 | 97.2 | 0 | 10 | 495 | 25 | 186 | KAF0710955.1 hypothetical protein AaE_012304 [Aphanomyces astaci] | diamond | 2448 | 226 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci |
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);;