contig_metadata
12 rows where bioproject = "PRJNA751877", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 726490 | 726490 | PRJNA751877_P_NODE_2921_length_516_cov_2.085779_g2799_i0 | PRJNA751877 | 2921 | 516 | 2.085779 | 10.76261964 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 1.35e-32 | NTclustered | gi|669145241|ref|XM_008609961.1| | 1156394 | g2799 | i0 | 75.51 | 30.5910852713178 | 343 | 68 | 65 | 14 | 92 | 426 | 452 | 118 | Saprolegnia diclina VS20 50S ribosomal protein L22e mRNA | blastn | 15785 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 2002597 | 2002597 | PRJNA751877_P_NODE_5542_length_420_cov_2.293948_g5420_i0 | PRJNA751877 | 5542 | 420 | 2.293948 | 9.6345816 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 1.66e-90 | NTclustered | gi|2795040529|ref|XM_067944818.1| | 4785 | g5420 | i0 | 81.971 | 84.697619047619 | 416 | 67 | 98 | 6 | 8 | 419 | 426 | 15 | Phytophthora cinnamomi 60S ribosomal protein L23 (IUM83_19754), partial mRNA | blastn | 35573 | 346 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 3277877 | 3277877 | PRJNA751877_P_NODE_3123_length_505_cov_3.671296_g3001_i0 | PRJNA751877 | 3123 | 505 | 3.671296 | 18.5400448 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.29e-47 | NTclustered | gi|2794929698|ref|XM_067885402.1| | 164328 | g3001 | i0 | 77.778 | 42.6376237623762 | 342 | 69 | 67 | 6 | 140 | 476 | 368 | 29 | Phytophthora ramorum 60S ribosomal protein L18a (KRP23_14565), partial mRNA | blastn | 21532 | 204 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 5829990 | 5829990 | PRJNA751877_P_NODE_24385_length_249_cov_0.875000_g24263_i0 | PRJNA751877 | 24385 | 249 | 0.875 | 2.17875 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.64e-25 | NTclustered | gi|2795026484|ref|XM_067934071.1| | 4785 | g24263 | i0 | 82.877 | 6.37349397590361 | 146 | 21 | 58 | 3 | 106 | 249 | 631 | 488 | Phytophthora cinnamomi Transketolase (IUM83_09620), partial mRNA | blastn | 1587 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 10930319 | 10930319 | PRJNA751877_P_NODE_23769_length_249_cov_1.312500_g23647_i0 | PRJNA751877 | 23769 | 249 | 1.3125 | 3.268125 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 3.81e-29 | NR | TMW64105.1 | 41045 | g23647 | i0 | 69.5 | 17.7831325301205 | 82 | 25 | 98.8 | 0 | 2 | 247 | 37 | 118 | TMW64105.1 hypothetical protein Poli38472_014222 [Pythium oligandrum] | diamond | 4428 | 119 | 0.991596638655462 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 13480264 | 13480264 | PRJNA751877_P_NODE_25771_length_247_cov_0.885057_g25649_i0 | PRJNA751877 | 25771 | 247 | 0.885057 | 2.18609079 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 73.1 | 1.71e-8 | NTclustered | gi|2794888530|ref|XM_067886608.1| | 164328 | g25649 | i0 | 92.157 | 0.206477732793522 | 51 | 4 | 21 | 0 | 145 | 195 | 471 | 421 | Phytophthora ramorum tRNA (adenine(58)-N(1))-methyltransferase non-catalytic subunit trm6 (KRP23_1938), partial mRNA | blastn | 51 | 73.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 16503255 | 16503255 | PRJNA751877_P_NODE_27713_length_244_cov_0.900585_g27591_i0 | PRJNA751877 | 27713 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 407 | 4.08e-109 | NTclustered | gi|166044630|emb|CU367539.1| | 100861 | g27591 | i0 | 96.721 | 98.4180327868852 | 244 | 8 | 100 | 0 | 1 | 244 | 168 | 411 | Aphanomyces euteiches cDNA | blastn | 24014 | 407 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 20326563 | 20326563 | PRJNA751877_P_NODE_18256_length_276_cov_1.517241_g18134_i0 | PRJNA751877 | 18256 | 276 | 1.517241 | 4.18758516 | root | 1 | Root_unresolved | Root_unresolved | 488 | 1.6299999999999995e-133 | NTclustered | gi|166044608|emb|CU367517.1| | 100861 | g18134 | i0 | 98.551 | 99.6992753623188 | 276 | 4 | 100 | 0 | 1 | 276 | 472 | 747 | Aphanomyces euteiches cDNA | blastn | 27517 | 488 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 24953086 | 24953086 | PRJNA751877_P_NODE_4900_length_438_cov_2.378082_g4778_i0 | PRJNA751877 | 4900 | 438 | 2.378082 | 10.41599916 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 1.85e-45 | NTclustered | gi|301114940|ref|XM_002999194.1| | 403677 | g4778 | i0 | 81.59 | 10.9543378995434 | 239 | 42 | 54 | 2 | 201 | 438 | 855 | 618 | Phytophthora infestans T30-4 pyrophosphate-energized vacuolar membrane proton pump, putative (PITG_05615), partial mRNA | blastn | 4798 | 196 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 25426978 | 25426978 | PRJNA751877_P_NODE_4620_length_447_cov_1.235294_g4498_i0 | PRJNA751877 | 4620 | 447 | 1.235294 | 5.52176418 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 8.189999999999997e-94 | NTclustered | gi|813119301|ref|XM_012340833.1| | 695850 | g4498 | i0 | 82.716 | 76.4093959731544 | 405 | 66 | 90 | 4 | 45 | 447 | 962 | 560 | Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA | blastn | 34155 | 359 | 0.994428969359331 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 29936453 | 29936453 | PRJNA751877_P_NODE_9351_length_355_cov_1.092199_g9229_i0 | PRJNA751877 | 9351 | 355 | 1.092199 | 3.87730645 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 9.06e-28 | NR | XP_067822191.1 | 4779 | g9229 | i0 | 57.6 | 27.9380281690141 | 92 | 39 | 77.7 | 0 | 276 | 1 | 186 | 277 | XP_067822191.1 uncharacterized protein CCR75_008787 [Bremia lactucae] | diamond | 9918 | 114 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 30694597 | 30694597 | PRJNA751877_P_NODE_22473_length_251_cov_0.865169_g22351_i0 | PRJNA751877 | 22473 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 2.83e-18 | NR | OWZ03480.1 | 4795 | g22351 | i0 | 53.4 | 12.2151394422311 | 73 | 34 | 87.3 | 0 | 25 | 243 | 42 | 114 | OWZ03480.1 hypothetical protein PHMEG_00024782 [Phytophthora megakarya] | diamond | 3066 | 86.7 | 0.990772779700115 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya |
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);;