contig_metadata
9 rows where bioproject = "PRJNA263496", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 369307 | 369307 | PRJNA263496_P_NODE_22181_length_166_cov_0.871795_g21928_i0 | PRJNA263496 | 22181 | 166 | 0.871795 | 1.4471797 | Salilagenidium thermophilum | 135484 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.2500000000000001e-77 | NTclustered | gi|146760372|dbj|AB285219.1| | 135484 | g21928 | i0 | 99.398 | 98.3734939759036 | 166 | 1 | 100 | 0 | 1 | 166 | 548 | 383 | Lagenidium thermophilum gene for 28S large subunit ribosomal RNA, partial sequence | blastn | 16330 | 302 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Lagenidiaceae | Salilagenidium | Salilagenidium thermophilum | ||
| 3607716 | 3607716 | PRJNA263496_P_NODE_25323_length_161_cov_0.991071_g25070_i0 | PRJNA263496 | 25323 | 161 | 0.991071 | 1.59562431 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 4.55e-42 | NTclustered | gi|6688976|emb|AJ249839.1| | 4787 | g25070 | i0 | 88.235 | 95.0310559006211 | 153 | 18 | 95 | 0 | 9 | 161 | 1279 | 1127 | Phytophthora infestans partial mRNA for translation elongation factor 1 alpha (tef1 gene) | blastn | 15300 | 183 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 8022732 | 8022732 | PRJNA263496_P_NODE_21547_length_167_cov_0.864407_g21294_i0 | PRJNA263496 | 21547 | 167 | 0.864407 | 1.44355969 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 4.86e-27 | NTclustered | gi|2794906124|ref|XM_067889988.1| | 164328 | g21294 | i0 | 82.667 | 3.39520958083832 | 150 | 26 | 90 | 0 | 1 | 150 | 588 | 439 | Phytophthora ramorum 60S ribosomal protein L3 (KRP23_4970), partial mRNA | blastn | 567 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 15672120 | 15672120 | PRJNA263496_P_NODE_24293_length_163_cov_0.894737_g24040_i0 | PRJNA263496 | 24293 | 163 | 0.894737 | 1.45842131 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 4.649999999999999e-37 | NTclustered | gi|675205738|ref|XM_008913506.1| | 761204 | g24040 | i0 | 85.276 | 5.5521472392638 | 163 | 23 | 99 | 1 | 1 | 162 | 443 | 605 | Phytophthora parasitica INRA-310 40S ribosomal protein S18 mRNA | blastn | 905 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 26630883 | 26630883 | PRJNA263496_P_NODE_22421_length_165_cov_0.879310_g22168_i0 | PRJNA263496 | 22421 | 165 | 0.87931 | 1.4508615 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 2.92e-20 | NR | CCI41832.1 | 65357 | g22168 | i0 | 77.8 | 1.94545454545455 | 54 | 12 | 98.2 | 0 | 163 | 2 | 183 | 236 | CCI41832.1 unnamed protein product [Albugo candida] | diamond | 321 | 92.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 28653099 | 28653099 | PRJNA263496_P_NODE_25607_length_161_cov_0.910714_g25354_i0 | PRJNA263496 | 25607 | 161 | 0.910714 | 1.46624954 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 2.32e-21 | NR | KAJ0409191.1 | 114742 | g25354 | i0 | 84.9 | 1.97515527950311 | 53 | 8 | 98.8 | 0 | 2 | 160 | 965 | 1017 | KAJ0409191.1 hypothetical protein ATCC90586_010272 [Pythium insidiosum] | diamond | 318 | 95.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 28779222 | 28779222 | PRJNA263496_P_NODE_23167_length_164_cov_0.886957_g22914_i0 | PRJNA263496 | 23167 | 164 | 0.886957 | 1.45460948 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 1.17e-7 | NR | TYZ57306.1 | 1485010 | g22914 | i0 | 64.1 | 1.42682926829268 | 39 | 14 | 71.3 | 0 | 162 | 46 | 236 | 274 | TYZ57306.1 hypothetical protein PybrP1_008020 [[Pythium] brassicae (nom. inval.)] | diamond | 234 | 57 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 29252707 | 29252707 | PRJNA263496_P_NODE_22089_length_166_cov_0.871795_g21836_i0 | PRJNA263496 | 22089 | 166 | 0.871795 | 1.4471797 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 1.26e-20 | NR | CCA15626.1 | 890382 | g21836 | i0 | 81.1 | 0.957831325301205 | 53 | 10 | 95.8 | 0 | 6 | 164 | 375 | 427 | CCA15626.1 Dlactate dehydrogenase putative [Albugo laibachii Nc14] | diamond | 159 | 93.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 30502535 | 30502535 | PRJNA263496_P_NODE_24033_length_163_cov_0.894737_g23780_i0 | PRJNA263496 | 24033 | 163 | 0.894737 | 1.45842131 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 1.46e-12 | NR | POM75922.1 | 4796 | g23780 | i0 | 55.6 | 6.95705521472393 | 54 | 24 | 99.4 | 0 | 162 | 1 | 357 | 410 | POM75922.1 Hypothetical protein PHPALM_6909 [Phytophthora palmivora] | diamond | 1134 | 71.6 | 0.990223463687151 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora |
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);;