contig_metadata
9 rows where bioproject = "PRJNA1240805" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3601080 | 3601080 | PRJNA1240805_P_NODE_5623_length_192_cov_5.440559_g5574_i0 | PRJNA1240805 | 5623 | 192 | 5.440559 | 10.44587328 | root | 1 | Root_unresolved | Root_unresolved | 291 | 3.22e-74 | NTclustered | gi|166046653|emb|CU367770.1| | 100861 | g5574 | i0 | 99.375 | 14.890625 | 160 | 1 | 83 | 0 | 1 | 160 | 457 | 298 | Aphanomyces euteiches cDNA | blastn | 2859 | 291 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 4878582 | 4878582 | PRJNA1240805_P_NODE_2084_length_334_cov_5.245614_g2035_i0 | PRJNA1240805 | 2084 | 334 | 5.245614 | 17.52035076 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 2e-143 | NTclustered | gi|33520229|gb|AY273974.1| | 162125 | g2035 | i0 | 96.541 | 95.1736526946108 | 318 | 5 | 93 | 3 | 23 | 334 | 137 | 454 | Hyaloperonospora brassicae large subunit ribosomal RNA gene, partial sequence | blastn | 31788 | 521 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 5452926 | 5452926 | PRJNA1240805_P_NODE_3825_length_236_cov_9.871658_g3776_i0 | PRJNA1240805 | 3825 | 236 | 9.871658 | 23.29711288 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 1.8199999999999993e-107 | NTclustered | gi|166046724|emb|CU367834.1| | 100861 | g3776 | i0 | 100 | 10.114406779661 | 217 | 0 | 92 | 0 | 20 | 236 | 272 | 56 | Aphanomyces euteiches cDNA | blastn | 2387 | 401 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 6727281 | 6727281 | PRJNA1240805_P_NODE_4966_length_205_cov_2.467949_g4917_i0 | PRJNA1240805 | 4966 | 205 | 2.467949 | 5.05929545 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 8.21e-11 | NTclustered | gi|325195177|emb|FR825972.1| | 890382 | g4917 | i0 | 95.918 | 0.478048780487805 | 49 | 2 | 24 | 0 | 147 | 195 | 359 | 311 | Albugo laibachii Nc14, genomic contig CONTIG_3045_NC14_v4_482_22195 | blastn | 98 | 80.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7428376 | 7428376 | PRJNA1240805_P_NODE_4166_length_225_cov_1.954545_g4117_i0 | PRJNA1240805 | 4166 | 225 | 1.954545 | 4.39772625 | root | 1 | Root_unresolved | Root_unresolved | 416 | 6.159999999999998e-112 | NTclustered | gi|166046724|emb|CU367834.1| | 100861 | g4117 | i0 | 100 | 23.0133333333333 | 225 | 0 | 100 | 0 | 1 | 225 | 733 | 509 | Aphanomyces euteiches cDNA | blastn | 5178 | 416 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21452334 | 21452334 | PRJNA1240805_P_NODE_5277_length_198_cov_29.724832_g5228_i0 | PRJNA1240805 | 5277 | 198 | 29.724832 | 58.85516736 | root | 1 | Root_unresolved | Root_unresolved | 327 | 2.55e-85 | NTclustered | gi|166046732|emb|CU367842.1| | 100861 | g5228 | i0 | 100 | 39.5 | 177 | 0 | 89 | 0 | 22 | 198 | 289 | 113 | Aphanomyces euteiches cDNA | blastn | 7821 | 327 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22026239 | 22026239 | PRJNA1240805_P_NODE_818_length_555_cov_15.887352_g771_i0 | PRJNA1240805 | 818 | 555 | 15.887352 | 88.1748036 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 961 | 0 | NTclustered | gi|166044498|emb|CU367407.1| | 100861 | g771 | i0 | 99.62 | 94.5117117117117 | 526 | 2 | 95 | 0 | 23 | 548 | 846 | 321 | Aphanomyces euteiches cDNA | blastn | 52454 | 961 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30376485 | 30376485 | PRJNA1240805_P_NODE_5352_length_197_cov_5.554054_g5303_i0 | PRJNA1240805 | 5352 | 197 | 5.554054 | 10.94148638 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 5.79e-4 | NR | KAF1771875.1 | 29920 | g5303 | i0 | 53.7 | 4.55329949238579 | 54 | 25 | 82.2 | 0 | 2 | 163 | 18 | 71 | KAF1771875.1 hypothetical protein GQ600_12051 [Phytophthora cactorum] | diamond | 897 | 46.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 32652028 | 32652028 | PRJNA1240805_P_NODE_4940_length_205_cov_8.596154_g4891_i0 | PRJNA1240805 | 4940 | 205 | 8.596154 | 17.6221157 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 1.57e-15 | NR | DAZ99178.1 | 4803 | g4891 | i0 | 83.7 | 9.70243902439024 | 43 | 7 | 62.9 | 0 | 183 | 55 | 973 | 1015 | DAZ99178.1 TPA: hypothetical protein N0F65_008211 [Lagenidium giganteum] | diamond | 1989 | 80.5 | 0.995031055900621 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum |
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);;