contig_metadata
8 rows where analysis = "blastn", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3288942 | 3288942 | PRJNA758088_P_NODE_338703_length_244_cov_0.900585_g331732_i0 | PRJNA758088 | 338703 | 244 | 0.900585 | 2.1974274 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 3.409999999999999e-55 | NTclustered | gi|189084149|gb|BT031665.1| | 4784 | g331732 | i0 | 84.848 | 51.6188524590164 | 231 | 29 | 93 | 6 | 16 | 243 | 1261 | 1034 | Phytophthora capsici clone CBOT53-I08 mRNA sequence | blastn | 12595 | 228 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 7113856 | 7113856 | PRJNA758088_P_NODE_168846_length_326_cov_1.209486_g161875_i0 | PRJNA758088 | 168846 | 326 | 1.209486 | 3.94292436 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|2794890102|ref|XM_067886897.1| | 164328 | g161875 | i0 | 88.889 | 0.138036809815951 | 45 | 4 | 14 | 1 | 217 | 261 | 872 | 829 | Phytophthora ramorum Ornithine decarboxylase 1 (KRP23_2194), partial mRNA | blastn | 45 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 8856827 | 8856827 | PRJNA758088_P_NODE_324607_length_246_cov_0.890173_g317636_i0 | PRJNA758088 | 324607 | 246 | 0.890173 | 2.18982558 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 2.08e-47 | NTclustered | gi|227811062|gb|FJ801890.1| | 109152 | g317636 | i0 | 93.431 | 58.979674796748 | 137 | 7 | 56 | 1 | 110 | 246 | 140 | 274 | Phytophthora boehmeriae clone WPC3963A1666 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence | blastn | 14509 | 202 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 9663941 | 9663941 | PRJNA758088_P_NODE_190528_length_308_cov_1.195745_g183557_i0 | PRJNA758088 | 190528 | 308 | 1.195745 | 3.6828946 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 4.4199999999999996e-60 | NTclustered | gi|2794920544|ref|XM_067895675.1| | 164328 | g183557 | i0 | 82.909 | 16.3831168831169 | 275 | 43 | 89 | 3 | 4 | 276 | 735 | 1007 | Phytophthora ramorum Mitochondrial phosphate carrier protein 3, mitochondrial (KRP23_10041), partial mRNA | blastn | 5046 | 244 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 15231551 | 15231551 | PRJNA758088_P_NODE_129512_length_369_cov_1.314189_g122541_i0 | PRJNA758088 | 129512 | 369 | 1.314189 | 4.84935741 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 5.47e-50 | NTclustered | gi|2248513842|ref|NC_063815.1| | 907947 | g122541 | i0 | 82.979 | 63.6016260162602 | 235 | 38 | 63 | 2 | 136 | 369 | 46007 | 45774 | Phytopythium vexans culture CBS:119.80 mitochondrion, complete genome | blastn | 23469 | 211 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium vexans | ||
| 16039261 | 16039261 | PRJNA758088_P_NODE_269953_length_257_cov_1.103261_g262982_i0 | PRJNA758088 | 269953 | 257 | 1.103261 | 2.83538077 | Phytophthora versiformis | 1833877 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 3.6199999999999984e-55 | NTclustered | gi|1710471323|gb|MK864060.1| | 1833877 | g262982 | i0 | 82.946 | 62.0739299610895 | 258 | 38 | 99 | 5 | 2 | 256 | 221 | 475 | Phytophthora versiformis strain CPHST BL 189 translation elongation factor 1-alpha (EF1a) gene, partial cds | blastn | 15953 | 228 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora versiformis | ||
| 21141630 | 21141630 | PRJNA758088_P_NODE_80397_length_473_cov_1.357500_g73432_i0 | PRJNA758088 | 80397 | 473 | 1.3575 | 6.420975 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 5.39e-71 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g73432 | i0 | 78.224 | 16.6871035940803 | 473 | 80 | 97 | 22 | 13 | 472 | 690 | 228 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 7893 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 22415831 | 22415831 | PRJNA758088_P_NODE_51278_length_620_cov_1.062157_g44540_i0 | PRJNA758088 | 51278 | 620 | 1.062157 | 6.5853734 | Phytophthora sp. ML-2023a | 3044284 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 7.359999999999998e-56 | NTclustered | gi|2500404807|gb|OQ735416.1| | 3044284 | g44540 | i0 | 79.096 | 42.6903225806452 | 354 | 60 | 55 | 9 | 102 | 442 | 22315 | 21963 | Phytophthora sp. ML-2023a voucher AM18FRL12 mitochondrion, complete genome | blastn | 26468 | 231 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. ML-2023a |
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);;