contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1025141" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 162843 | 162843 | PRJNA1025141_P_NODE_8261_length_273_cov_0.960000_g8200_i0 | PRJNA1025141 | 8261 | 273 | 0.96 | 2.6208 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.98e-61 | NTclustered | gi|2795026849|ref|XM_067926286.1| | 4785 | g8200 | i0 | 86.937 | 75.974358974359 | 222 | 27 | 81 | 2 | 12 | 232 | 495 | 275 | Phytophthora cinnamomi succinyl-CoA ligase [GDP-forming] subunit alpha, mitochondrial (IUM83_02375), partial mRNA | blastn | 20741 | 248 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 2713244 | 2713244 | PRJNA1025141_P_NODE_5983_length_327_cov_2.866142_g5922_i0 | PRJNA1025141 | 5983 | 327 | 2.866142 | 9.37228434 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 3.76e-41 | NTclustered | gi|695460853|ref|XM_009539792.1| | 67593 | g5922 | i0 | 87.342 | 13.131498470948 | 158 | 20 | 48 | 0 | 8 | 165 | 151 | 308 | Phytophthora sojae hypothetical protein mRNA | blastn | 4294 | 182 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 2713269 | 2713269 | PRJNA1025141_P_NODE_7643_length_285_cov_1.816038_g7582_i0 | PRJNA1025141 | 7643 | 285 | 1.816038 | 5.1757083 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 4.13e-45 | NTclustered | gi|301099992|ref|XM_002899041.1| | 403677 | g7582 | i0 | 79.779 | 3.97543859649123 | 272 | 51 | 95 | 4 | 1 | 270 | 165 | 434 | Phytophthora infestans T30-4 40S ribosomal protein S16 (PITG_14913), partial mRNA | blastn | 1133 | 195 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 3989368 | 3989368 | PRJNA1025141_P_NODE_4104_length_401_cov_1.268293_g4043_i0 | PRJNA1025141 | 4104 | 401 | 1.268293 | 5.08585493 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 2.17e-44 | NTclustered | gi|2794929698|ref|XM_067885402.1| | 164328 | g4043 | i0 | 77.193 | 56.0074812967581 | 342 | 71 | 84 | 6 | 59 | 395 | 29 | 368 | Phytophthora ramorum 60S ribosomal protein L18a (KRP23_14565), partial mRNA | blastn | 22459 | 193 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 7815337 | 7815337 | PRJNA1025141_P_NODE_2307_length_538_cov_1.002151_g2246_i0 | PRJNA1025141 | 2307 | 538 | 1.002151 | 5.39157238 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 3.65e-83 | NTclustered | gi|2794920874|ref|XM_067880626.1| | 164328 | g2246 | i0 | 79.339 | 87.3029739776952 | 484 | 80 | 88 | 16 | 9 | 482 | 1067 | 594 | Phytophthora ramorum Adenosylhomocysteinase (KRP23_10205), partial mRNA | blastn | 46969 | 322 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 15031859 | 15031859 | PRJNA1025141_P_NODE_2632_length_505_cov_2.673611_g2571_i0 | PRJNA1025141 | 2632 | 505 | 2.673611 | 13.50173555 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 1.6e-76 | NTclustered | gi|813142340|ref|XM_012343869.1| | 695850 | g2571 | i0 | 78.054 | 89.9069306930693 | 483 | 100 | 95 | 6 | 10 | 489 | 63 | 542 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein S6 mRNA | blastn | 45403 | 300 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 16739687 | 16739687 | PRJNA1025141_P_NODE_12914_length_241_cov_1.136905_g12853_i0 | PRJNA1025141 | 12914 | 241 | 1.136905 | 2.73994105 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 9.27e-61 | NTclustered | gi|2795049776|ref|XM_067938656.1| | 4785 | g12853 | i0 | 86.026 | 54 | 229 | 32 | 95 | 0 | 1 | 229 | 327 | 555 | Phytophthora cinnamomi polyadenylate-binding protein 1-B (IUM83_13951), partial mRNA | blastn | 13014 | 246 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 18014665 | 18014665 | PRJNA1025141_P_NODE_3855_length_414_cov_2.583578_g3794_i0 | PRJNA1025141 | 3855 | 414 | 2.583578 | 10.69601292 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 6.2899999999999986e-40 | NTclustered | gi|301093299|ref|XM_002997452.1| | 403677 | g3794 | i0 | 82.075 | 41.0289855072464 | 212 | 34 | 51 | 4 | 65 | 274 | 378 | 169 | Phytophthora infestans T30-4 nascent polypeptide-associated complex subunit alpha-like protein, putative (PITG_19008), partial mRNA | blastn | 16986 | 178 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans |
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);;