contig_metadata
21 rows where bioproject = "PRJNA1174207", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1590567 | 1590567 | PRJNA1174207_P_NODE_42282_length_235_cov_5.358025_g41753_i0 | PRJNA1174207 | 42282 | 235 | 5.358025 | 12.59135875 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 8.33e-116 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g41753 | i0 | 99.574 | 102.191489361702 | 235 | 1 | 100 | 0 | 1 | 235 | 176 | 410 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 24015 | 429 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 4142682 | 4142682 | PRJNA1174207_P_NODE_35304_length_249_cov_0.875000_g34775_i0 | PRJNA1174207 | 35304 | 249 | 0.875 | 2.17875 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 1.56e-41 | NR | XP_024572655.1 | 4781 | g34775 | i0 | 86.6 | 40.5060240963855 | 82 | 11 | 98.8 | 0 | 2 | 247 | 47 | 128 | XP_024572655.1 autophagy-related protein 8 precursor [Plasmopara halstedii] | diamond | 10086 | 143 | 0.993006993006993 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 9243757 | 9243757 | PRJNA1174207_P_NODE_38468_length_245_cov_0.895349_g37939_i0 | PRJNA1174207 | 38468 | 245 | 0.895349 | 2.19360505 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 5.229999999999999e-118 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g37939 | i0 | 98.776 | 2.16734693877551 | 245 | 3 | 100 | 0 | 1 | 245 | 1275 | 1519 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 531 | 436 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 9243856 | 9243856 | PRJNA1174207_P_NODE_43288_length_226_cov_2.143791_g42759_i0 | PRJNA1174207 | 43288 | 226 | 2.143791 | 4.84496766 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 3.97e-64 | NTclustered | gi|673036739|ref|XM_008874109.1| | 157072 | g42759 | i0 | 88.942 | 0.920353982300885 | 208 | 23 | 92 | 0 | 1 | 208 | 339 | 546 | Aphanomyces invadans hypothetical protein partial mRNA | blastn | 208 | 257 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 15618571 | 15618571 | PRJNA1174207_P_NODE_37293_length_246_cov_0.890173_g36764_i0 | PRJNA1174207 | 37293 | 246 | 0.890173 | 2.18982558 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 3.71e-49 | NR | RHY73488.1 | 112090 | g36764 | i0 | 93.8 | 2.96341463414634 | 81 | 5 | 98.8 | 0 | 245 | 3 | 452 | 532 | RHY73488.1 hypothetical protein DYB38_004317 [Aphanomyces astaci] | diamond | 729 | 174 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 16892979 | 16892979 | PRJNA1174207_P_NODE_41754_length_241_cov_0.916667_g41225_i0 | PRJNA1174207 | 41754 | 241 | 0.916667 | 2.20916747 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.19e-64 | NTclustered | gi|673052656|ref|XM_008882067.1| | 157072 | g41225 | i0 | 90 | 21.5477178423237 | 200 | 20 | 83 | 0 | 1 | 200 | 465 | 664 | Aphanomyces invadans 40S ribosomal protein S15a mRNA | blastn | 5193 | 259 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 26723464 | 26723464 | PRJNA1174207_P_NODE_17681_length_339_cov_1.375940_g17152_i0 | PRJNA1174207 | 17681 | 339 | 1.37594 | 4.6644366 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 3.76e-39 | NR | KAJ0392104.1 | 114742 | g17152 | i0 | 60.4 | 9.78761061946903 | 111 | 44 | 98.2 | 0 | 335 | 3 | 49 | 159 | KAJ0392104.1 hypothetical protein P43SY_009801 [Pythium insidiosum] | diamond | 3318 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 26819125 | 26819125 | PRJNA1174207_P_NODE_13801_length_393_cov_1.443750_g13272_i0 | PRJNA1174207 | 13801 | 393 | 1.44375 | 5.6739375 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.02 | NR | OQS01313.1 | 1202772 | g13272 | i0 | 32.6 | 0.702290076335878 | 92 | 50 | 61.1 | 3 | 358 | 119 | 303 | 394 | OQS01313.1 ubiquitin carboxyl-terminal hydrolase [Achlya hypogyna] | diamond | 276 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 27008702 | 27008702 | PRJNA1174207_P_NODE_27722_length_274_cov_1.532338_g27193_i0 | PRJNA1174207 | 27722 | 274 | 1.532338 | 4.19860612 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 9.849999999999999e-43 | NR | GLD96418.1 | 114742 | g27193 | i0 | 73.6 | 0.996350364963504 | 91 | 24 | 99.6 | 0 | 273 | 1 | 30 | 120 | GLD96418.1 hypothetical protein PINS_up005101 [Pythium insidiosum] | diamond | 273 | 149 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 28525019 | 28525019 | PRJNA1174207_P_NODE_40547_length_242_cov_0.911243_g40018_i0 | PRJNA1174207 | 40547 | 242 | 0.911243 | 2.20520806 | Phytophthora palmivora | 4796 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 7.76e-9 | NR | POM71525.1 | 4796 | g40018 | i0 | 48.1 | 6.42148760330578 | 77 | 40 | 95.5 | 0 | 239 | 9 | 177 | 253 | POM71525.1 Hypothetical protein PHPALM_11899 [Phytophthora palmivora] | diamond | 1554 | 61.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 29365082 | 29365082 | PRJNA1174207_P_NODE_22089_length_303_cov_1.317391_g21560_i0 | PRJNA1174207 | 22089 | 303 | 1.317391 | 3.99169473 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 4.029999999999999e-46 | NR | DAZ97987.1 | 4803 | g21560 | i0 | 73.7 | 13.8019801980198 | 99 | 26 | 98 | 0 | 3 | 299 | 4 | 102 | DAZ97987.1 TPA: hypothetical protein N0F65_005145 [Lagenidium giganteum] | diamond | 4182 | 159 | 0.993710691823899 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29554255 | 29554255 | PRJNA1174207_P_NODE_31150_length_260_cov_1.358289_g30621_i0 | PRJNA1174207 | 31150 | 260 | 1.358289 | 3.5315514 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 1.74e-20 | NR | KAJ0410185.1 | 114742 | g30621 | i0 | 71 | 3.01153846153846 | 62 | 18 | 71.5 | 0 | 186 | 1 | 11 | 72 | KAJ0410185.1 hypothetical protein P43SY_002517 [Pythium insidiosum] | diamond | 783 | 95.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 29661088 | 29661088 | PRJNA1174207_P_NODE_29370_length_267_cov_1.587629_g28841_i0 | PRJNA1174207 | 29370 | 267 | 1.587629 | 4.23896943 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 4.62e-4 | NR | TMW58714.1 | 41045 | g28841 | i0 | 34.7 | 0.842696629213483 | 75 | 46 | 82 | 2 | 258 | 40 | 443 | 516 | TMW58714.1 hypothetical protein Poli38472_010273 [Pythium oligandrum] | diamond | 225 | 48.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29724390 | 29724390 | PRJNA1174207_P_NODE_36770_length_247_cov_0.885057_g36241_i0 | PRJNA1174207 | 36770 | 247 | 0.885057 | 2.18609079 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 3.3e-12 | NR | RLN54651.1 | 325452 | g36241 | i0 | 51.4 | 4.36032388663968 | 72 | 34 | 86.2 | 1 | 2 | 214 | 104 | 175 | RLN54651.1 hypothetical protein BBP00_00008848 [Phytophthora kernoviae] | diamond | 1077 | 70.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 30767248 | 30767248 | PRJNA1174207_P_NODE_32094_length_256_cov_1.295082_g31565_i0 | PRJNA1174207 | 32094 | 256 | 1.295082 | 3.31540992 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00656 | NR | KAF1335313.1 | 82926 | g31565 | i0 | 59.3 | 0.31640625 | 27 | 11 | 31.6 | 0 | 5 | 85 | 187 | 213 | KAF1335313.1 Phosphatidylinositol-4-phosphate 5-kinase, partial [Globisporangium splendens] | diamond | 81 | 45.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 30988514 | 30988514 | PRJNA1174207_P_NODE_16434_length_354_cov_1.206406_g15905_i0 | PRJNA1174207 | 16434 | 354 | 1.206406 | 4.27067724 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 186 | 1.26e-56 | NR | GLD96418.1 | 114742 | g15905 | i0 | 72 | 3.99152542372881 | 118 | 33 | 100 | 0 | 1 | 354 | 37 | 154 | GLD96418.1 hypothetical protein PINS_up005101 [Pythium insidiosum] | diamond | 1413 | 186 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31020075 | 31020075 | PRJNA1174207_P_NODE_33555_length_251_cov_0.865169_g33026_i0 | PRJNA1174207 | 33555 | 251 | 0.865169 | 2.17157419 | Phytophthora lilii | 2077276 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 5.22e-40 | NR | GMF65511.1 | 2077276 | g33026 | i0 | 84.3 | 4.94820717131474 | 83 | 13 | 99.2 | 0 | 251 | 3 | 64 | 146 | GMF65511.1 unnamed protein product [Phytophthora lilii] | diamond | 1242 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lilii | ||
| 31114525 | 31114525 | PRJNA1174207_P_NODE_20075_length_316_cov_2.958848_g19546_i0 | PRJNA1174207 | 20075 | 316 | 2.958848 | 9.34995968 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.32e-38 | NR | XP_008867284.1 | 157072 | g19546 | i0 | 71.8 | 4.03481012658228 | 85 | 24 | 80.7 | 0 | 3 | 257 | 54 | 138 | XP_008867284.1 60S ribosomal protein L37 [Aphanomyces invadans] | diamond | 1275 | 135 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 31387083 | 31387083 | PRJNA1174207_P_NODE_8836_length_523_cov_2.413333_g8311_i0 | PRJNA1174207 | 8836 | 523 | 2.413333 | 12.62173159 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 1.5e-66 | NR | UIZ28103.1 | 542832 | g8311 | i0 | 70.4 | 32.8451242829828 | 152 | 43 | 86.6 | 2 | 508 | 56 | 21 | 171 | UIZ28103.1 hypothetical protein KXD40_004629 [Peronospora effusa] | diamond | 17178 | 213 | 0.990610328638498 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora effusa | ||
| 32431006 | 32431006 | PRJNA1174207_P_NODE_30819_length_261_cov_1.638298_g30290_i0 | PRJNA1174207 | 30819 | 261 | 1.638298 | 4.27595778 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.013 | NR | DAZ92596.1 | 4803 | g30290 | i0 | 70.8 | 0.540229885057471 | 24 | 7 | 27.6 | 0 | 188 | 259 | 54 | 77 | DAZ92596.1 TPA: hypothetical protein N0F65_003488 [Lagenidium giganteum] | diamond | 141 | 43.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 32557745 | 32557745 | PRJNA1174207_P_NODE_20099_length_316_cov_1.880658_g19570_i0 | PRJNA1174207 | 20099 | 316 | 1.880658 | 5.94287928 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 3.3e-10 | NR | CCA27042.1 | 890382 | g19570 | i0 | 46.3 | 1.36708860759494 | 67 | 35 | 62.7 | 1 | 7 | 204 | 4 | 70 | CCA27042.1 conserved hypothetical protein [Albugo laibachii Nc14] | diamond | 432 | 63.2 | 0.993670886075949 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii |
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);;