contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 683131 | 683131 | PRJNA700095_P_NODE_1341_length_1548_cov_38.159322_g49_i4 | PRJNA700095 | 1341 | 1548 | 38.159322 | 590.70630456 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.044 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g49 | i4 | 100 | 0.018733850129199 | 29 | 0 | 2 | 0 | 724 | 752 | 1761 | 1789 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 683156 | 683156 | PRJNA700095_P_NODE_2081_length_1308_cov_41.697166_g49_i6 | PRJNA700095 | 2081 | 1308 | 41.697166 | 545.39893128 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.037 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g49 | i6 | 100 | 0.02217125382263 | 29 | 0 | 2 | 0 | 724 | 752 | 1761 | 1789 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 4511114 | 4511114 | PRJNA700095_P_NODE_10744_length_590_cov_2.253385_g9504_i0 | PRJNA700095 | 10744 | 590 | 2.253385 | 13.2949715 | Hyaloperonospora arabidopsidis | 272952 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 7.28e-26 | NTclustered | gi|2248512796|ref|NC_063789.1| | 272952 | g9504 | i0 | 75 | 40.0610169491525 | 320 | 63 | 53 | 12 | 267 | 578 | 1227 | 917 | Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome | blastn | 23636 | 132 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora arabidopsidis | ||
| 14712097 | 14712097 | PRJNA700095_P_NODE_1532_length_1469_cov_39.614613_g49_i5 | PRJNA700095 | 1532 | 1469 | 39.614613 | 581.93866497 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.042 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g49 | i5 | 100 | 0.0197413206262764 | 29 | 0 | 2 | 0 | 724 | 752 | 1761 | 1789 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 15212856 | 15212856 | PRJNA700095_P_NODE_7852_length_707_cov_31.706625_g6695_i0 | PRJNA700095 | 7852 | 707 | 31.706625 | 224.16583875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 4.539999999999999e-133 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g6695 | i0 | 86.057 | 62.8401697312588 | 459 | 59 | 65 | 4 | 155 | 611 | 483 | 28 | Pythium splendens calmodulin mRNA, complete cds | blastn | 44428 | 492 | 0.991869918699187 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 19810182 | 19810182 | PRJNA700095_P_NODE_49236_length_255_cov_1.329670_g47972_i0 | PRJNA700095 | 49236 | 255 | 1.32967 | 3.3906585 | Plasmopara sp. HV-2014a | 1458840 | SAR_Eukaryotes | SAR_Eukaryotes | 409 | 1.19e-109 | NTclustered | gi|629748269|gb|KF041005.1| | 1458840 | g47972 | i0 | 95.669 | 99.7019607843137 | 254 | 11 | 99 | 0 | 1 | 254 | 505 | 758 | Plasmopara sp. HV-2014a large subunit ribosomal RNA gene, partial sequence | blastn | 25424 | 409 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara sp. HV-2014a | ||
| 21085483 | 21085483 | PRJNA700095_P_NODE_10697_length_591_cov_99.156371_g9457_i0 | PRJNA700095 | 10697 | 591 | 99.156371 | 586.01415261 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.85e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g9457 | i0 | 80.533 | 57.238578680203 | 375 | 65 | 62 | 4 | 191 | 558 | 441 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21085754 | 21085754 | PRJNA700095_P_NODE_66277_length_240_cov_2.161677_g65013_i0 | PRJNA700095 | 66277 | 240 | 2.161677 | 5.1880248 | Plectospira myriandra | 100863 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 1.59e-38 | NTclustered | gi|57903345|gb|AY729823.1| | 100863 | g65013 | i0 | 80.519 | 49.5916666666667 | 231 | 39 | 95 | 3 | 13 | 240 | 669 | 896 | Plectospira myriandra beta-tubulin gene, partial cds | blastn | 11902 | 172 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Plectospira | Plectospira myriandra | ||
| 23636161 | 23636161 | PRJNA700095_P_NODE_4859_length_895_cov_2.790754_g3894_i0 | PRJNA700095 | 4859 | 895 | 2.790754 | 24.9772483 | Phytophthora sp. ML-2023a | 3044284 | SAR_Eukaryotes | SAR_Eukaryotes | 507 | 1.6e-138 | NTclustered | gi|2500404807|gb|OQ735416.1| | 3044284 | g3894 | i0 | 78.473 | 46.0424581005587 | 799 | 154 | 88 | 17 | 1 | 790 | 6334 | 7123 | Phytophthora sp. ML-2023a voucher AM18FRL12 mitochondrion, complete genome | blastn | 41208 | 507 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. ML-2023a | ||
| 24909431 | 24909431 | PRJNA700095_P_NODE_19120_length_406_cov_7.798799_g17857_i0 | PRJNA700095 | 19120 | 406 | 7.798799 | 31.66312394 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 520 | 8.889999999999999e-143 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g17857 | i0 | 90.657 | 83.9630541871921 | 396 | 30 | 96 | 6 | 1 | 391 | 501 | 108 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 34089 | 520 | 1 | 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);;