contig_metadata
8 rows where bioproject = "PRJNA527965", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 496938 | 496938 | PRJNA527965_S_NODE_5061_length_166_cov_5.312977_g4978_i0 | PRJNA527965 | 5061 | 166 | 5.312977 | 8.81954182 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.82e-44 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g4978 | i0 | 90.476 | 34.6024096385542 | 147 | 10 | 87 | 4 | 6 | 150 | 1520 | 1664 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 5744 | 191 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 6874556 | 6874556 | PRJNA527965_S_NODE_4006_length_189_cov_9.032468_g3923_i0 | PRJNA527965 | 4006 | 189 | 9.032468 | 17.07136452 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 5.21e-82 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g3923 | i0 | 96.825 | 94.1904761904762 | 189 | 6 | 100 | 0 | 1 | 189 | 230 | 42 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 17802 | 316 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 6874570 | 6874570 | PRJNA527965_S_NODE_4646_length_174_cov_1.884892_g4563_i0 | PRJNA527965 | 4646 | 174 | 1.884892 | 3.27971208 | Pseudoperonospora cubensis | 143453 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 8.75e-5 | NTclustered | gi|927372602|ref|NC_027859.1| | 143453 | g4563 | i0 | 78.947 | 0.724137931034483 | 95 | 14 | 52 | 4 | 14 | 103 | 5727 | 5820 | Pseudoperonospora cubensis mitochondrion, complete genome | blastn | 126 | 60.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora cubensis | ||
| 8149872 | 8149872 | PRJNA527965_S_NODE_3427_length_205_cov_3.170588_g3344_i0 | PRJNA527965 | 3427 | 205 | 3.170588 | 6.4997054 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 3.3899999999999996e-94 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g3344 | i0 | 98.049 | 101.785365853659 | 205 | 4 | 100 | 0 | 1 | 205 | 488 | 692 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 20866 | 357 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 10700898 | 10700898 | PRJNA527965_S_NODE_5129_length_165_cov_7.707692_g5046_i0 | PRJNA527965 | 5129 | 165 | 7.707692 | 12.7176918 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 2.139999999999999e-55 | NTclustered | gi|161727445|dbj|AB370101.1| | 2052682 | g5046 | i0 | 91.617 | 30.0242424242424 | 167 | 11 | 100 | 2 | 1 | 165 | 196 | 31 | Pythium ultimum genes for 28S rRNA, intergenic spacer, 18S rRNA, partial and complete sequence, strain: UZ085-11 | blastn | 4954 | 228 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 19622935 | 19622935 | PRJNA527965_S_NODE_4616_length_175_cov_1.464286_g4533_i0 | PRJNA527965 | 4616 | 175 | 1.464286 | 2.5625005 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.4e-37 | NTclustered | gi|325194632|emb|FR825445.1| | 890382 | g4533 | i0 | 84.091 | 99.0457142857143 | 176 | 27 | 100 | 1 | 1 | 175 | 440 | 615 | Albugo laibachii Nc14, genomic contig CONTIG_2284_NC14_v4_911_15847 | blastn | 17333 | 169 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 20898969 | 20898969 | PRJNA527965_S_NODE_1357_length_326_cov_9.642612_g1274_i0 | PRJNA527965 | 1357 | 326 | 9.642612 | 31.43491512 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 575 | 1.4699999999999996e-159 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g1274 | i0 | 98.466 | 98.8006134969325 | 326 | 5 | 100 | 0 | 1 | 326 | 918 | 593 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 32209 | 575 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 20899064 | 20899064 | PRJNA527965_S_NODE_657_length_432_cov_2.801008_g575_i0 | PRJNA527965 | 657 | 432 | 2.801008 | 12.10035456 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 8.65e-29 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g575 | i0 | 90.09 | 24.6342592592593 | 111 | 8 | 25 | 3 | 300 | 409 | 41764 | 41656 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 10642 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii |
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);;